Changes between Version 2 and Version 3 of OracleSpatial
- Timestamp:
- Jan 28, 2009, 9:03:08 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
OracleSpatial
v2 v3 15 15 1) the native built-in support through maporaclespatial.c 2) OGR, but watch out: OGR is not compiled with Oracle Spatial support so it won't work without compiling in OCI (Oracle client) yourself. This requires both recompiling GDAL/OGR as well as recompiling Mapserver itself against the new GDAL/OGR !!!! 16 16 17 OPTION 1 NATIVE ORACLE SPATIAL SUPPORT There are two possible syntaxes in the mapfile for the DATA statement: 17 === OPTION 1 NATIVE ORACLE SPATIAL SUPPORT === 18 19 There are two possible syntaxes in the mapfile for the DATA statement: 18 20 19 21 1. DATA "GEOMETRIE FROM KWADRANTEN USING SRID 90112" … … 73 75 SELECT rownum, KWADRANTNR, GEOMETRIE FROM KWADRANTEN WHERE SDO_FILTER( KWADRANTEN.GEOMETRIE, MDSYS.SDO_GEOMETRY(2003, 90112, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(171673.094,449742.685,178343.906,456414.315) ),'querytype=window') = 'TRUE' 74 76 }}} 75 OPTION 2 ORACLE SPATIAL SUPPORT THROUGH OGR Mapserver 4.0.1 Windows binary with OGR Oracle Spatial support (GDAL version 1.2) downloadable from: http://www.vz.geodan.nl/users/bart/mapserv4.0.1-OGR-Oracle.zip 77 === OPTION 2 ORACLE SPATIAL SUPPORT THROUGH OGR === 78 79 Mapserver 4.0.1 Windows binary with OGR Oracle Spatial support (GDAL version 1.2) downloadable from: http://www.vz.geodan.nl/users/bart/mapserv4.0.1-OGR-Oracle.zip 76 80 77 81 Syntax for your MAP file: