Geographic Information Systems Asked by Aaron Kreider on July 12, 2021
I imported precinct data from the Harvard Dataverse into Postgres 9.3 using the PostGIS Shapefile Import/Export Manager.
It creates a geom column with a SRID of 0. I think the data is projected as SRID 4326 as I was able to view a map of it using TileMill when I chose WGS 84. However, QGis says it is EPSG:4019 so maybe that is the problem.
How can I import it with this SRID? When I try to change the SRID it fails.
SELECT UpdateGeometrySRID('public', 'precinct', 'geom', 4326);
ERROR: Geometry has Z dimension but column does not
Either you cannot set a SRID for a geometry column that has multiple projections or you cannot do this if the projections are incompatible.
Answered by Aaron Kreider on July 12, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP