[Geoserver-users] Image Mosaic Plugin - Index Table - ORACLE

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

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=flownDate Schema=*Geometry:POLYGON,location:VARCHAR2,flownDate:java.util.Date,current:VARCHAR2 PropertyCollectors=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: Image Mosaic Plugin - Index Table - ORACLE
Sent from the GeoServer - User mailing list archive at Nabble.com.

All, No response so far - has anybody used Oracle for Image Mosaic??

Thanks

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Image-Mosaic-Plugin-Index-Table-ORACLE-tp5169346p5169690.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

On Mon, Oct 27, 2014 at 10:57 AM, gavin.montgomery <
gavin.montgomery@anonymised.com> wrote:

All, No response so far - has anybody used Oracle for Image Mosaic??

We did some time ago, it was working (well, we had to make some
improvements to the
code, to handle some Oracle oddities, but they were contributed to
GeoServer).
Which version of GeoServer are you using?
Can you share your mosaic config files?

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

-------------------------------------------------------

Hi Andrea, Thanks for your response.

Slightly complicated, in test we are using 2.4.4 - I have suggested we
upgrade in production which we will do at a later date to 2.4.8 (appreciate
not the most recent but we have had efficiency issues with our aerial
photoraphy on 2.5.x using JPEG compressed images).

Using a 2.4.4 test on my machine postGIS has no issues, if you believe it
was corrected by 2.4.8 I may have to press the environment team to upgrade
our geoserver sooner!

Files attached - FYI we use the imagery tile name and a year in the regex
expression. i.e. SY0204_2014.tiff

mosaics.zip <http://osgeo-org.1560.x6.nabble.com/file/n5169711/mosaics.zip&gt;

Regards

Gavin

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Image-Mosaic-Plugin-Index-Table-ORACLE-tp5169346p5169711.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

On Mon, Oct 27, 2014 at 1:19 PM, gavin.montgomery <gavin.montgomery@anonymised.com...

wrote:

Hi Andrea, Thanks for your response.

Slightly complicated, in test we are using 2.4.4 - I have suggested we
upgrade in production which we will do at a later date to 2.4.8 (appreciate
not the most recent but we have had efficiency issues with our aerial
photoraphy on 2.5.x using JPEG compressed images).

Please do report them with an reproducable test case, the 2.4.x series is
dead, there won't be any more releases out of it. The current stable is
2.6.x,
2.5.x already got in maintenance mode (mostly bug fixes)

Using a 2.4.4 test on my machine postGIS has no issues, if you believe it
was corrected by 2.4.8 I may have to press the environment team to upgrade
our geoserver sooner!

I don't know exactly which version would be working, but found something odd
in your schema definition:

Schema=SDO_GEOMETRY:POLYGON,location:VARCHAR2,flownDate:java.util.Date,current:VARCHAR2

SDO_GEOMETRY is a type name in oracle, I believe the above won't work, nor
will using
VARCHAR2, the schema is not a SQL one, it's a java one, the data store will
decide
which native sql type to use for you.
How comes you decided to use SQL types, is there some misleanding
documentation around?

Could you try this one?

Schema=geom:Polygon,location:String,flownDate:java.util.Date,current:String

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

-------------------------------------------------------

Hi Andrea,

Thank you again for your comments, unfortunately your suggestion has not
worked. Considering your suggestion regarding GeoServer versions, I will
endeavour to update the server on our development environment. It may
perhaps solve the problem.

In response to your statement regarding documentation, the only
documentation I can find is PostGIS based, in the geoserver docs, it may be
helpful if the documentation in this area could be expanded. The I sent you
had been through many different iterations in the attempt to get a positive
result, admittedly the one I sent you was not sure to work! :slight_smile:

Thank you for your help, I will further my efforts in this and update the
forum if I have any success. If anybody else has come across this I would
appreciate your comments.

Regards

Gavin

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Image-Mosaic-Plugin-Index-Table-ORACLE-tp5169346p5169742.html
Sent from the GeoServer - User mailing list archive at Nabble.com.