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/[email protected]: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
--------------------------------------------------------------------------------
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
