Hello,
On my current project we are using an ImageMosaic to display aerial
photography for England. We are also working to enable the TIME attribute on
the layer so that we can display historic imagery.
Working in test environment I used postGIS to successfully generate the
index table following the instructions here:
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html
<http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html>
However, as our production environment is Oracle based, I have had to try
and replicate the indexer.properties file, but to be compatible with Oracle
spatial. I believe I am having trouble passing the geometry to table as an
SDO_GEOMETRY type, I have been unable to find any Oracle support on this
aspect of the properties file.
My indexer.properties file is as follows
TimeAttribute=flownDateSchema=*Geometry:POLYGON,location:VARCHAR2,flownDate:java.util.Date,current:VARCHAR2PropertyCollectors=TimestampFileNameExtractorSPI[timeregex](flownDate)
Connection to the DB works fine, I can tell this as a new table does get
created in my DB but with what I believe to be a default schema:
FID Number(38,0)
LOCATION Varchar2(255)
THE_GEOM SDO_GEOMETRY
Does anybody have experience with this and could shed any light on my issue?
Your help is greatly appreciated.
Regards, Gavin
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Image-Mosaic-Plugin-Index-Table-ORACLE-tp5169346.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
