Brooklyn is having issues with a particular supergang : The rectangles.
They focus on controlling busy points within the city and carve out a particularly shaped area of influence: a rectangle. 1 point of interest, or node, is central to their operation, they control every other node within 750 meters.
They only seem to settle down if a node has at least 3 other nodes within 750 of a central node and they’ve also got a strange fascination with electronic stores. This means that there will be at least 4 nodes in a group.
Data is contained within the OpenStreetMap New York (by Sonra) on the Snowflake Marketplace
– connect to OpenStreetMap New York by Sonra
– use the v_osm_ny_shop_electronics view
– If 3 nodes are within 750 meters of another central node, group these together.
– Build a rectangle containing these groups , 1 rectangle per group
– The central node should be within the city of Brooklyn (look in addr_city and ignore the null values)
– Be able to plot all these rectangles on a single map using wkt formatting (search for wkt plotting to find these sites)
And below is what you should end up with if you were to plot the single line on a wkt plotter (pay attention to the red rectangles):
Remember, if you want to participate: