Wednesday, 15 November 2017

postgis - Operation on mixed SRID geometries


[I'm new to the site and my English is poor, so it is difficult for me to explain my problem. But there is no other person I can ask.]



My question is related to this exercise http://postgis.net/workshops/postgis-intro/joins.html, but it gives an error when I run it.


SELECT
subways.name AS subway_name,
neighborhoods.name AS neighborhood_name,
neighborhoods.boroname AS borough
FROM nyc_neighborhoods AS neighborhoods
JOIN nyc_subway_stations AS subways
ON ST_Contains(neighborhoods.geom, subways.geom)
WHERE subways.name = 'Broad St';


The error is Operation on mixed SRID geometries




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...