I don’t yet have a fix for this. I am trying to figure it out.
To be clear - this is a “someone is going to dislike this regardless of what I do” situation, based on what I know and can accomplish right now
- If the single node streets are included, the result is that all of the other streets that don’t cross over into the city but do have a single node on the border will be present in CityStrides
- If the single node streets are not included, the result is that some of the streets that do cross over into the city but don’t have detailed node placement will not be present in CityStrides
It’s more important for me to make a decision on this so that the overall city sync job can be finished, rather than pausing the entire city sync effort while I work on resolving this bit. This will let me finish the overall project and return back to clean this smaller problem up (and also address the grid city troubles where nodes only exist on intersections).
There’s probably a way to query PostGIS for “collect the coordinates within/on a city border from line strings that pass through the border, ignoring the lien strings that just touch the border with one of their coordinates”. I do not yet know how to do this.