[gdal-dev] srs definition for wgs84

Imran Rajjad rajjad at gmail.com
Thu May 13 06:53:49 EDT 2010


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

-- 
I.R


More information about the gdal-dev mailing list