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

[Paul Ramsey]

Translating the WKT to PROJ4 is tricky with non-meter projections,
because sometimes different vendors put their offsets in different
units.  Here's my guess for yours:

+proj=lcc +lat_1=33 +lat_2=45 +lat_0=33 +lon_0=-89.5 +x_0=914400 
+to_meter=0.3048006096012192 +ellps=clrk66 +datum=NAD27


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]]


   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632