Closed gregallensworth closed 6 years ago
Updated the DB table, and found that 291 intersections do not fall within a borough polygon and thus continue to have a blank for the borough field.
AND borough!=''
as a clause when filtering for intersections, so we only get those tagged with a boroughAND borough!=''
as a clause when filtering for intersections, so we only get those tagged with a boroughAll of the above done.
borough, name|id
format, and cross-links from Map to Chart and vice-versa confirmed to work.
Relevant to #73 some data thoughts...
Client wants Intersection names, to be prepended with the borough in which the intersection is located.
ST_CONTAINS
sqlIntersections
CONCAT
the borough name so the presented name has the borough prepended