TransWikia.com

Trying to set SRID for a Geometry

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

One Answer

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP