2

I have a list of 300 points of interests within 500m radius from a given point.

I need to automatically put numbers in every block/square and then list in which block/square each point of interest is located in. The attached image is just an example.

Is there a way to do that automatically without resorting to manual interventions (e.g drawing the numbers one by one). ex1 ex2

UPDATE: I managed to obtain the blocks by using OSM roads shape files and the poligonize feature in QGIS and model buider.

  • 1
    Do the numbers have to mean anything, can they be arbitrary, should they relate to other address information? – DPSSpatial May 21 '20 at 22:52
  • The black/white numbers should increase according to its proximity to the center, or like a clockwise spiral. The image above it's not a very good example of that since numbers were put manually. – fsimoyama May 21 '20 at 23:03
  • see the answer and the comment i posted below – DPSSpatial May 21 '20 at 23:15
1

One idea to think about:

  • calculate the distance of each polygon centroid to the given point
  • using a row_number function assign a value to a distance column in the polygon ordered by the distance to the given point

From there, it is just a matter of intersecting the points of interest to the polygons and grabbing the row_number value.

  • I don't see where the letters come in though - what are those referring to? – DPSSpatial May 21 '20 at 23:15
  • Letters (green) represent one type of the points of interest. Red numbers also represent points of interest (of other type). However, I'm interested in the little numbers (black numbers inside white boxes), which represent the blocks/squares. – fsimoyama May 22 '20 at 2:04
  • @fsimoyama ok, the method above will work - my tool of choice is PostGIS, but you could do this against shapefiles using virtual layers and sql spatial... – DPSSpatial May 22 '20 at 13:24
  • sorry I forgot to mention that I don't have the polygons/shapes of each block, so I need a tool that captures the blocks automatically and put numbers on it. If this was one case only, I could easily draw the blocks by myself, however I have more than 50 to do that same task. – fsimoyama May 22 '20 at 14:44
  • 2
    I think you'll need to check either a local government for that, or possibly open street map – DPSSpatial May 22 '20 at 15:15
0

UPDATE: I managed to obtain the blocks by using OSM roads shape files and the poligonize feature in QGIS and Model Builder.

The data of the roads were obtained from http://download.geofabrik.de/ Then I imported roads shape files into QGIS. I used the select features in QGIS and then the poligonize feature.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.