[postgis-users] Problem trying to import data from wetlands.fws.gov

[Kevin Neufeld]

It looks like your insert statement is missing the proj4 text string.  
PostGIS doesn't use the spatialreference wkt at all, rather, it 
delegates it's transformations to proj4. 

Bryan Montgomery wrote:
> Hi,
> We've bene trying to import shape files from the website here. (RI is 
> relatively small). I can display the shape files on udig, but have not 
> been able to use shp2pgsql to import them an make sense of it.
>  
> I tried running INSERT into spatial_ref_sys (srid, auth_name, 
> auth_srid, proj4text, srtext)
> values ( 924, 'sr-org', 24, '',
> 'PROJCS["NAD_1983_Albers",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.017453292519943295]],PROJECTION["Albers"],PARAMETER["False_Easting",00000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",23.0],UNIT["Meter",1.0]]');
> and use that as the srid of the imported data. Trying to st_transofrm 
> that to 4326 or 32015 on windows with postgresql 8.4.1 crashed the 
> server. We've also run it on 8.2 on linux - which doesn't die.
>  
> However, the results are essentially garbage. I assume there is 
> something (probably simple) that we are missing. Can someon point us 
> in the right direction to get this converted?
>  
> From what I can tell, udig sees thespatial reference as posted below. 
> I used a link from 
> http://spatialreference.org/ref/sr-org/24/postgis/ as the basis for 
> creating the srid above.
> PROJCS["NAD_1983_Albers",
>   GEOGCS["GCS_North_American_1983",
>     DATUM["D_North_American_1983",
>       SPHEROID["GRS_1980", 6378137.0, 298.257222101]],
>     PRIMEM["Greenwich", 0.0],
>     UNIT["degree", 0.017453292519943295],
>     AXIS["Lon", EAST],
>     AXIS["Lat", NORTH]],
>   PROJECTION["Albers_Conic_Equal_Area"],
>   PARAMETER["central_meridian", -96.0],
>   PARAMETER["latitude_of_origin", 23.0],
>   PARAMETER["standard_parallel_1", 29.5],
>   PARAMETER["false_easting", 0.0],
>   PARAMETER["false_northing", 0.0],
>   PARAMETER["standard_parallel_2", 45.5],
>   UNIT["m", 1.0],
>   AXIS["x", EAST],
>   AXIS["y", NORTH]]
> Thanks,
> Bryan.
>  
>  
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>