[postgis-users] How to find out SRID

[cyw at dls.net]

Are these two the same:
The difference is in the units: +units=us-ft  vs. 
+to_meter=0.3048006096012192
Thnaks,
cyw


+proj=tmerc

+lat_0=36.66666666666666

+lon_0=-88.33333333333333

+k=0.999975

+x_0=300000

+y_0=0

+ellps=GRS80

+units=us-ft

+no_defs



> There isn't one, you'll have to add a new entry. The PROJ4TEXT will be
 +proj=tmerc
 +lat_0=36.66666666666666
 +lon_0=-88.33333333333333
 +k=0.999975
 +x_0=300000
 +y_0=0
 +ellps=GRS80
 +datum=NAD83
 +to_meter=0.3048006096012192
 +no_defs

On Thu, Oct 9, 2008 at 9:47 AM,  <cyw at dls.net> wrote:
> Hi All,
>
> I have some data which was exported to shape format using some ESRI tools.
> Bwlow is the prj file. How do find the cooresponding SRID in 
> spatial_ref_sys
> table (assume it exists)?
>
> PROJCS["NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet",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["Transverse_Mercator"],PARAMETER["False_Easting",984250.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-88.33333333333333],PARAMETER["Scale_Factor",0.999975],PARAMETER["Latitude_Of_Origin",36.66666666666666],UNIT["Foot_US",0.3048006096012192]]
>
> Thanks,
> CYW
>