Forum Stats

  • 3,855,344 Users
  • 2,264,499 Discussions
  • 7,905,975 Comments

Discussions

Coordinate System SRID GeoRaster data

783582
783582 Member Posts: 7
edited Jul 8, 2010 11:10AM in Spatial Discussions
Hi All,

I'm learning GeoRaster and I have some problems setting the coordinate system.

I've successfully loaded ArcGis Raster data (binary grid) using FME. I can run queries using sdo_geor.getCellValue using the numRow and numColumn parameters. my question is:

How can I run the same query using the model coordinates (*British National Grid*) instead of the pixel coordinates ?

Thanks !
Tagged:

Answers

  • Jeffrey Xie-Oracle
    Jeffrey Xie-Oracle Member Posts: 595 Employee
    please follow these steps:

    1. make sure the loaded georaster object is properly georeferenced and has the model srid set. call sdo_geor.validategeoraster and sdo_geor.getmodelsrid.

    2. find the Oracle srid for British National Grid.

    3. directly call SDO_GEOR.getCellValue(
    georaster IN SDO_GEORASTER,
    pyramidLevel IN NUMBER,
    ptGeom IN SDO_GEOMETRY, - where your point in your srid - any srid is fine
    layers IN VARCHAR2
    ) RETURN SDO_NUMBER_ARRAY;

    4. you can convert cell coordinates (numRow, numColumn) to/from ground coordinates (X,Y) whenever needed. call sdo_geor.getModelCoordinate and sdo_geor.getCellCoordinate

    jeffrey
    Jeffrey Xie-Oracle
This discussion has been closed.