Recent Searches

Loading Search Results...
Loading Directory Results...
Close

History

Close

Recent Pages

Recent Searches

EIU QGIS Workshop

Table Join Narcotics Count To The Total Crime Count Layer

The goal of this action is to have a single layer that shows total crime count and narcotics count in the attribute data.

  • Right click on the total crime layer >>> properties>>>join
  • Click on the green cross icon Green cross and select as shown below

Table join 1

 

 

 

 

 

 

 

 

 

 

 

 

The total crime layer table should be as shown below,

Table join attribute table

 

Calculate % Narcotics

To get the % narcotics for each district let’s use the formula below,

                                        Narcotics count / Total crime count * 100

  • Right click on total crime layer >>> open attribute table
  • Click on edit mode button followed by the open field calculator button
  • Enter % Narcotics in the output field name
  • Click on fields and values >>> double click Narcotics_count >>> click on forward slash >>> double click on count >>> click on the asterisk button >>> enter 100

Calculator dialogue box

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Click OK and a % Narcotics field is populated in the attribute data as shown below

Percentage Narcotics

 

 

 

 

 

 

 

 

 

Related Pages


Take the next step

apply now
schedule a visit