[postgis-users] How to reproject data with custom projection?

[Aren Cambre]

I have a SHP with this in its PRJ file:

*
PROJCS["Custom",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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1500000.0],PARAMETER["False_Northing",5000000.0],PARAMETER["Central_Meridian",-100.0],PARAMETER["Standard_Parallel_1",27.5],PARAMETER["Standard_Parallel_2",35.0],PARAMETER["Central_Parallel",18.0],UNIT["Meter",1.0]]
*


I need to get this into 3081 somehow since it's a good projection for Texas.

I have some 3081-reprojected PoistGIS data (originally 4269) for Texas
already. If I load this SHP into QGIS along with other 3081 data, it appears
well below the other data. QGIS indicates this SHP has a custom projection.

If I am not mistaken, to reproject with PostGIS, I need something besides -1
in the geometry table. So I guess I need to specify some SRID with *-s* when
I run shp2pgsql? If so, what projection is this?

Thanks, and I apologize in advance for my naivety.

Aren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110108/838a27f8/attachment.html>