1) I fear there is no quick solution for your problem. A good solution would be to have additional Elements
<tileTableWhereCondition>....</tileTableWhereCondition>. <spatialTableWhereCondition>....</spatialTableWhereCondition>. Much harder is the integration into the import utility. 2) The only quick solution is to write your own access logic http://docs.geotools.org/latest/userguide/library/coverage/jdbc/customized.html Examples are here http://svn.osgeo.org/geotools/trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc all classes starting with JDBCAccess* I would have to change some code for passing the date/time values into the jdbc access implementation. And you must find another way to import your data. If you decide for 2) after reading the documentation and looking at the code, give me ping, I will try to assist. Cheers Christian Quoting Mario Cavicchi <[email protected]>: > On 05/17/2011 12:50 PM, [email protected] wrote: >> Quoting Mario Cavicchi <[email protected]>: >> >> Mario, you should stay on the mailing list, this mail was sent only to me. > > Sorry for my error, I wrong the to press reply. Now I send on mailing list. > >> I talked about the xml file where you specify the database mappings, the >> connection params and the coverage name and type. > > My configuration files are like in the tutorial (more or less): > > mainfile.xml: > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <!DOCTYPE ImageMosaicJDBCConfig [ > <!ENTITY mapping PUBLIC "mapping" "mapping.oracle.xml.inc"> > <!ENTITY connect PUBLIC "connect" "connect.oracle.xml.inc">]> > <config version="1.0"> > <coverageName name="classified"/> > <coordsys name="EPSG:32633"/> > <scaleop interpolation="1"/> > <verify cardinality="false"/> > &mapping; > &connect; > </config> > > > mapping.oracle.xml.inc: > <connect> > > <dstype value="DBCP"/> > <username value="geoserver" /> > <password value="password" /> > <jdbcUrl value="jdbc:oracle:thin:@localhost:1521:geoserver" /> > <driverClassName value="oracle.jdbc.OracleDriver"/> > <maxActive value="10"/> > <maxIdle value="0"/> > </connect> > > connect.oracle.xml.inc: > <spatialExtension name="oracle"/> > <mapping> > <masterTable name="mosaic" > > <coverageNameAttribute name="name"/> > <maxXAttribute name="maxX"/> > <maxYAttribute name="maxY"/> > <minXAttribute name="minX"/> > <minYAttribute name="minY"/> > <resXAttribute name="resX"/> > <resYAttribute name="resY"/> > <tileTableNameAtribute name="TileTable" /> > <spatialTableNameAtribute name="SpatialTable" /> > </masterTable> > <tileTable> > <blobAttributeName name="data" /> > <keyAttributeName name="location" /> > </tileTable> > <spatialTable> > <keyAttributeName name="location" /> > <geomAttributeName name="GEOM" /> > <tileMaxXAttribute name="maxX"/> > <tileMaxYAttribute name="maxY"/> > <tileMinXAttribute name="minX"/> > <tileMinYAttribute name="minY"/> > </spatialTable> > </mapping> > > >> >> I want to have a look at it to figure out a possible solution. >> Christian > > From my point of view, I would be nice if I can add the tag > "timeAttributeName" ( or something) in the tileTable and, in the query > to geoserver, I can specify a time range (start datetime, end datetime). > And finally, would be very nice add an option to gt-imagemosaic-jdbc.jar > with option import to specify to acquisition date/time of the tiles > imported. > > Thanks and regards, > > -- > Mario Cavicchi > > MEEO S.r.l. > Via Saragat 9 > I-44122 Ferrara, Italy > Tel: +39 0532 1861501 > Fax: +39 0532 1861637 > http://www.meeo.it > > ======================================== > "ATTENZIONE:le informazioni contenute in questo messaggio sono > da considerarsi confidenziali ed il loro utilizzo è riservato unicamente > al destinatario sopra indicato. Chi dovesse ricevere questo messaggio > per errore è tenuto ad informare il mittente ed a rimuoverlo > definitivamente da ogni supporto elettronico o cartaceo." > > "WARNING:This message contains confidential and/or proprietary > information which may be subject to privilege or immunity and which > is intended for use of its addressee only. Should you receive this > message in error, you are kindly requested to inform the sender and > to definitively remove it from any paper or electronic format." > > ------------------------------------------------------------------------------ > Achieve unprecedented app performance and reliability > What every C/C++ and Fortran developer should know. > Learn how Intel has extended the reach of its next-generation tools > to help boost performance applications - inlcuding clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
