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

[Ivan Lucena]

Yes, please follow the instruction on that page http://trac.osgeo.org/gdal/ , first bullet "Submit a new bug report (you need to login with an  OSGeo Userid)".

It will help a lot if you can attach a gdalinfo report of your input file and the version of GDAL that you are using.

You can get that information by executing:

# gdalinfo --version
# gdalinfo <name of the file>

Regards.

>  -------Original Message-------
>  From: Pasta Bolognese <pasta.bolognese at gmail.com>
>  To: Ivan Lucena <ivan.lucena at pmldnet.com>
>  Cc: gdal-dev at lists.osgeo.org
>  Subject: Re: [gdal-dev] Oracle GeoRaster is not setting setModelSRID ?
>  Sent: Jul 12 '10 03:05
>  
>  In that case, is there any way I can rise a ticket for it ?
>  
>  On Mon, Jul 12, 2010 at 12:57 AM, Ivan Lucena <ivan.lucena at pmldnet.com> wrote:
>  >>  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
>  >>
>  >
>