Calculation of fishing net road density

Fishing net road density calculation

First of all to prepare ：

Projected Beijing road network and Beijing administrative division grid data

First step ： Prepare area properties

Open the attribute table of fishing net , add to “unit_area” Field calculation area （ Square kilometers ）.

The second step ： Identify road data

In order to calculate the road network density value corresponding to each grid , First, calculate the road length in each grid , therefore , To pass the 【 identification 】 Tools to break each section at the grid boundary , And identify the grid to which each road section belongs FID.
Tools ：【 Analysis tools 】—>【 Superposition analysis 】—>【 identification 】

roads_Identity The attribute data looks like this ：

The third step ： By grid FID Summarize the road network length

To add “length” Field calculation length （ km ）.
In this step, even if the road network length of each grid is summarized . Output a table Sum_Output, as follows ：

Step four ： Connect fields to the grid

Connect the fishing net layer with the generated road network statistics table ：

Step five ： Calculate density

Build in the grid roaddensity Field , Through the field calculator , Total length / The area gets the road network density .

Exhibition ：

（ Warm reminder ： There is no need to mark the road network density of the Administrative Region ）