Does anyone know of a simple tool, method or dataset to enable someone to convert geographic coordinates to New York City neighborhood names?
At the very least, it would be good to map a dataset to the set of neighborhoods.
Open Data Stack Exchange is a question and answer site for developers and researchers interested in open data. It only takes a minute to sign up.
Sign up to join this communitytamu has a killer geocoder, as well as a definitive list of other free geocoders. all you have to do is upload your data
http://geoservices.tamu.edu/Services/Geocode/BatchProcess/
http://geoservices.tamu.edu/Services/Geocode/OtherGeocoders/
Zillow provides Shapefiles for neighborhoods for the largest US Cities (includes NYC) for free (CC license). You can find them here:
For anyone else looking to figure this out, the trick is the following.
You'll need
Once you have all three, log into cartodb and upload your file with long/lat coordinates and the nyc neighborhood geometry file. Then follow these instructions:
Run the following SQL query from within the file:
SELECT s.*,n.neighborhood FROM {{yourFileName}} as s, nyc_pediacities_neighborhoods_v3_polygon as n WHERE ST_Within(s.the_geom,n.the_geom)
You're creating two objects, yourFile as s and the shapefile as n, then matching the geometries against one another with the WHERE
clause.
That should create a new column with rows featuring the NYC neighborhood of the long/lat of the same row.
3 . Export your file.