[postgis-users] SRID and unprojected (Census) data

Paragon Corporation lr at pcorp.us
Wed Mar 12 01:36:15 PDT 2008


Correct 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Lee
Hachadoorian
Sent: Wednesday, March 12, 2008 3:38 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] SRID and unprojected (Census) data

Regina, Leo, Chris,

I had previously installed from packages on Ubuntu Linux, which means
Postgres 8.2 and PostGIS 1.2 (repositories aren't up to date).  I just
decided to build everything from source (Postgres, Proj4, GEOS, and 
PostGIS), and SRID 4269 is in spatial_ref_sys.   I don't think it was 
there previously, but then again, I might have missed it.  I did

SELECT * FROM spatial_ref_sys WHERE srtext LIKE '%NAD83';

but if 4269 was in the results, I didn't spot it.

So, if I understand correctly, I should run shp2pgsql with -s 4269 in order
to import the shapefiles that I download from the census.

Thanks for your help,
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences CUNY Graduate Center
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users






More information about the postgis-users mailing list