[postgis-users] Projection Question.

[Jason C. Leach]

Hi,

I have a shape file that is in NAD83, UTM, Zone 11.  When I export the
table (pgsql2shp) I would like to also create a .prj file for the
shape file; I'll do this with a Python script.  If I use the text from
the spatial_ref_sys table ArcMap complains that the projection does
not agree with the data in the shape file.  If I replace and use the
original .prj file I had when I imported the data ArcMap is happy. 
The reason I'd like to use the text from the spatial_ref_sys table is
so I can create the .prj files on the fly.

The polygon is located in South East BC, Canada (Near Oliver). 
Attached is the text from the original .prj file.

Can I even use the text from the spatial_ref_sys table in a .prj file?

Thanks,
Jason.

PROJCS["NAD_1983_UTM_Zone_11N",GEOGCS["GCS_North_American_1983",
DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],
PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],
PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],
PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-117.0],
PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],
UNIT["Meter",1.0]]


--
........................................
.... Jason C. Leach
.... PGP Key: 0x62DDDF75
.... Keyserver: gpg.mit.edu