[postgis-users] Projection questions

Pagurek,Debbie [NCR] Debbie.Pagurek at ec.gc.ca
Wed Jun 22 12:24:24 PDT 2005


I have just received a shapefile (polygons) that is in an Albers
projection and from what I can see it does not have an associated EPSG
code.
My question is this:
Do I have to reproject the shapefile to meet an EPSG code (e.g.42304)
before loading the data into postgis? Or can I load it using shp2pgsql
(what would I set the -s to?) and then somehow set up a new SRID that
defines the projection below? How would I add a new SRID to the
SPATIAL_REF_SYS Table?
In the end, I would like to have this in postgis and serve it as WMS/WFS
using Mapserver. 

Just trying to find the easiest way to deal with this non-EPSG
projection.

Here is the projection in WKT SRS representation:
Layer name: pda_al83_polygon
Geometry: Polygon
Feature Count: 5013
Extent: (3668545.746945, 620284.375175) - (9021698.683472,
5271375.948747)
Layer SRS WKT:
PROJCS["NAD_1983_Albers",
    GEOGCS["GCS_North_American_1983",
        DATUM["North_American_Datum_1983",
            SPHEROID["GRS_1980",6378137.0,298.257222101]],
        PRIMEM["Greenwich",0.0],
        UNIT["Degree",0.0174532925199433]],
    PROJECTION["Albers_Conic_Equal_Area"],
    PARAMETER["False_Easting",6200000.0],
    PARAMETER["False_Northing",3000000.0],
    PARAMETER["longitude_of_center",-91.86666666666666],
    PARAMETER["Standard_Parallel_1",49.0],
    PARAMETER["Standard_Parallel_2",77.0],
    PARAMETER["latitude_of_center",63.390675],
    UNIT["Meter",1.0]]

Thanks in advance for advice that anyone can offer.

D. Pagurek



More information about the postgis-users mailing list