2 Replies Latest reply: Dec 14, 2010 4:54 AM by Stefan Jager RSS

    SRID

    CNG
      HI Guys,

      how to find SRID for shape file which contains below PRJ.

      "PROJCS["NAD_1983_Florida_GDL_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.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.0],PARAMETER["Standard_Parallel_1",24.0],PARAMETER["Standard_Parallel_2",31.5],PARAMETER["Latitude_Of_Origin",24.0],UNIT["Meter",1.0]]""
        • 1. Re: SRID
          John O'Toole
          You seem to be referring to EPSG 3086: http://spatialreference.org/ref/epsg/3086/

          I don't see that in my 11gR2 database, so you might have to add it as a custom SRID. That should be pretty straightforward to do. Search the documentation and this forum for examples of inserting your own custom SRID.

          John
          • 2. Re: SRID
            Stefan Jager
            Now that's interesting. I'm checking on 10.2.0.4.0, so not as recent, but there are quite a few Florida-coordinate systems in there, but none for the entire state. And this one seems to be refferring to a coordinate system for the entire state, whereas the ones in my DB are all divided into East, West and North. If your data does not reflect the entire state, you could use one of those I guess. I am a bit surprised not to see the SRID for the entire state in there though, one would expect that to be in there as well.

            Like John says: if you really need that SRID, use the WKT to insert it, an before you do read the documentation (http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11830/sdo_cs_concepts.htm#SPATL712)