[postgis-users] spatial_ref_sys entry from .prj file?

[Erich Schroeder]

Is there a script available to take a shapefile .prj file and create the 
correct insert statement to make a full new entry to spatial_ref_sys? In 
my case the contents is:

PROJCS["Clarke_1866_Lambert_Conformal_Conic",GEOGCS["GCS_Clarke_1866",DATUM["D_Clarke_1866",SPHEROID["Clarke_1866",6378206.4,294.9786982]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2999994.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-89.5],PARAMETER["Standard_Parallel_1",33.0],PARAMETER["Standard_Parallel_2",45.0],PARAMETER["Latitude_Of_Origin",33.0],UNIT["Foot_US",0.3048006096012192]]

Which is I guess the SRTEXT item, but I was hoping for something that 
would pull out the correct proj4 text from that.

Erich


---------------------------------------------------------------------
Erich Schroeder                    Phone: (217)785-0033
Curator, Learning Center           FAX:   (217)785-2857
Illinois State Museum GIS Lab      email:erich(at)illinois.state.museum
http://www.museum.state.il.us/     Linux user #18660
---------------------------------------------------------------------