BetaNYC/nyc-boundaries

Fix NTA SQL errors

Closed this issue · 2 comments

When users select Neighborhood Tabulation Area from the Query Overlapping districts dropdown, and then select 'Airport' or 'Hammels-Averne-Edgemere' (and I'm assuming some others), some of the boundaries (e.g. Police Precincts, Congressional districts, etc.) do not query.

For those boundaries, the console reports:
Failed to load resource: the server responded with a status of 400 (Bad Request)

zhik commented

#22
A query of 'Airport' or 'Hammels-Averne-Edgemere' will now work.

But the Airport query will return intersecting boundaries for both JFK and LGA. This can be fixed by modifying the data beforehand or in Carto.
image

Airport NTAs no longer displayed in v1.0.