[postgis-users] Importing shapefiles with srid != -1

[Paragon Corporation]

Actually the shp2pgsql loader completely ignores the prj file and the
pgsql2shp doesn't create a prj file.  That's one of those nice to have
features that should be on the to do list if it isn't.  Its of very minor
importance compared to other stuff though.

Regina 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of James
Dominy
Sent: Monday, May 12, 2008 9:01 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Importing shapefiles with srid != -1

Lee Hachadoorian wrote:
> Is there any chance spatial_ref_sys is missing srid 4326?

spatial_ref_sys has srid 4326. I was surprised that shp2pgsql didn't pick up
the srid from the .prj file though. Setting it manually worked out fine. The
constraint error was due to leaving out the quotes around the srid in the
AddGeometry call.

Thanks
James
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users