[gdal-dev] srs definition for wgs84

[Peter J Halls]

Imran,

    the Oracle SRID value of 8192 *is* WGS84.  Oracle does not store the EPSG 
values, but has its own set.

Best wishes,

Peter

Imran Rajjad wrote:
> Hi list,
> 
> I`m trying to export a shape file to oracle, however when I view my
> oracle table I find that the SRS has not been set. I tried to add the
> -a_srs paramter to the command line and gave it 4326 which EPSG from
> Geographical WGS84
> 
> 
> ogr2ogr -f OCI OCI:mdsys/mediation at 10.0.80.31:1521/attmsd rural.shp
> -a_srs EPSG:4326
> 
> but SDO_SRID in the table is set to 8192 whereas it should be 4326
> 
>  ORA_GEOMETRY(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO,
> SDO_ORDINAT
> --------------------------------------------------------------------------------
> SDO_GEOMETRY(3001, 8192, SDO_POINT_TYPE(69.4, 27.55, 0), NULL, NULL)
> SDO_GEOMETRY(3001, 8192, SDO_POINT_TYPE(72.283333, 29.066667, 0), NULL, NULL)
> SDO_GEOMETRY(3001, 8192, SDO_POINT_TYPE(65.6, 27.116667, 0), NULL, NULL)
> SDO_GEOMETRY(3001, 8192, SDO_POINT_TYPE(71.383333, 29.483333, 0), NULL, NULL)
> SDO_GEOMETRY(3001, 8192, SDO_POINT_TYPE(70.183333, 28.016667, 0), NULL, NULL)
> 
> 
> what am i doing
> 

-- 
--------------------------------------------------------------------------------
Peter J Halls, GIS Advisor, University of York
Telephone: 01904 433806     Fax: 01904 433740
Snail mail: Computing Service, University of York, Heslington, York YO10 5DD
This message has the status of a private and personal communication
--------------------------------------------------------------------------------