Re: [gdal-dev] Oracle GeoRaster is not setting setModelSRID ?

[Ivan Lucena]

>  What I mean is that If I can read the coordinate system (BNG), why
>  then I am forced to set it MANUALLY ? (using -co SRID=81989 to
>  assigned that SRID to the GeoRaster ob for example)...
>
>  I know that I can run a script, get the name of the coordinate system,
>  query the DB to get its number and then use the -co SRID=81989... But
>  I wonder, is it working as expected ??

No, it is certainly not doing what is expected.

>  
>  On Fri, Jul 9, 2010 at 11:42 PM, Ivan Lucena <ivan.lucena at pmldnet.com> wrote:
>  >>  If I run gdalinfo "C:\mymodel" I can see
>  >
>  > What format is that or which GDAL driver is reading it?
>  >
>  >>  Coordinate System is:
>  >>  PROJCS["OSGB 1936 / British National Grid",
>  >
>  > What comes after?
>  >
>  > A complete gdalinfo report would help.
>  >
>  >>  then, loading the model into Oracle with
>  >>
>  >>  gdal_translate -of georaster "C:\mymodel"
>  >>  georaster:user/password,db,geoserver.ARCVIEWGRID,georaster -co
>  >>  "DESCRIPTION=(ID NUMBER, SITE VARCHAR2(45), GEORASTER
>  >>  MDSYS.SDO_GEORASTER)" -co "INSERT=VALUES(1,'West fields',
>  >>  SDO_GEOR.INIT())" -co "BLOCKXSIZE=512" -co "BLOCKYSIZE=512" -co
>  >>  "BLOCKBSIZE=3"  -co "INTERLEAVE=PIXEL"
>  >>
>  >>  and fixing manually the XML (it is not valid as it has an extra NODATA
>  >>  in the wrong place)
>  >>
>  >
>  > Did it reported any warning?
>  >
>  >>  I've discovered that the ModelSRID has not been set... and therefore I
>  >>  had to set it manually (sdo_geor.setModelSRID(grobj, 81989); where
>  >>  81989 is BGN)
>  >>
>  >>  is is working as expected ?
>  >
>  > That is a trick question. It all depends on the WKT content that comes from the source dataset. If it has EPSG authority code and that code is supported by Oracle Spatial it might work.
>  >
>  >>
>  >>  is there any way to set it automatically ?
>  >
>  > You can use -co SRID=81989 to assigned that SRID to the GeoRaster object.
>  >
>  >>
>  >>  thanks
>  >>  _______________________________________________
>  >>  gdal-dev mailing list
>  >>  gdal-dev at lists.osgeo.org
>  >>  http://lists.osgeo.org/mailman/listinfo/gdal-dev
>  >>
>  >
>  _______________________________________________
>  gdal-dev mailing list
>  gdal-dev at lists.osgeo.org
>  http://lists.osgeo.org/mailman/listinfo/gdal-dev
>