Yep, exactly, Jody can you migrate ? I think you are about ten times faster than me and I am currently working on a "pregeneralized features + postgis" tutorial.
If you have no time left, please tell me, I would reschedule and focus on the imagemosaic jdbc documentation first. Cheers Christian Quoting Jody Garnett <[email protected]>: > Yep it looks like those were missed - sorry about that. I am afraid > my goal was limited to starting the developers off with their > existing content; and I must of missed those during the conversion. > There was a two year gap between goetools deciding to use sphinx and > now ... > > There is the content for creating indexes for performance: > > GeoTools Users Guide : Creating indexes for performance > This page last changed on Jun 10, 2008 by [email protected]. > To achieve performance you must create indexes, depending on your > spatial extension. > Universal > Here is a proposal if you have more tiles in the x direction than in > the y direction. If the opposite is true, switch Minx / Miny and > Max/ Maxy > CREATE INDEX IX_SPATIAL0_1 ON SPATIAL0(MinX,MinY) CREATE INDEX > IX_SPATIAL0_2 ON SPATIAL0(MaxX,MaxY) > > > DB2 Spatial Extender > Use gseidx utility (ADVISE) to get a proposal for the last 3 > parameters (grid sizes) > CREATE INDEX IX_SPATIAL0 ON SPATIAL0(GEOM) EXTEND USING > db2gse.spatial_index (10000.0, 100000.0, 1000000.0) > > > Postgis > CREATE INDEX IX_spatial0 ON spatial0 USING gist(geom) > > > Mysql > CREATE SPATIAL INDEX IX_SPATIAL0 ON SPATIAL0(GEOM) > > > Oracle Location Based Services > CREATE INDEX IX_SPATIAL0 ON SPATIAL0(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX > > > > > > > > And the content for using the java import utility: > > GeoTools Users Guide : Using the java import utility > This page last changed on Mar 02, 2009 by [email protected]. > Classpath considerations > The classpath for the utility is set in the manifest file of > gt-imagemosiac-jdbc.jar, so you do not need > to bother about dependencies. > The only problem are the jdbc drivers for the the database. First > you need to download the jar files. > DB2 > We need db2jcc.jar and db2jcc_license.jar. Download from > https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-idsjs11 > Oracle > We need ojdbc14.jar. Download from > http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html > Postgres > http://jdbc.postgresql.org/download.html > MySql > http://www.mysql.com/products/connector/j/ > Other DB Systems > Google is your friend > The problem is to put the jars in the classpath. According to the > Sun documentation > http://java.sun.com/j2se/1.5.0/docs/tooldocs/findingclasses.html > a class path in a manifest overrides the CLASSPATH environment > variable and the -cp or -classpath java option. > A solution is to copy the jar files into /lib/ext of your java > runtime. In this case the extension class loader > is responsible to load your jdbc drivers. Another approach is to > investigate into the -X options of your java > runimte. java -X gives help. if there is an option > -Xbootclasspath/a: you can avoid copying the jdbc jar file into the > /lib/ext directory and call "java -Xbootclasspath/a:<location of > jdbc.jar> -jar ...." > Call Syntax > Common options: > -config > the URL or the file name of the xml config file , e.g "file:/temp/mymap.xml" > -commitCount > (optional), default 100, insert records in chunks to improve performance > Importing excactly one level > -spatialTN > the name of the spatial table which must already exist > -tileTN > the name of the tile table which must already exist. When using a > joined table, the tile table name has to be equal to the spatial > table name > Importing all tiles including the pyramids as produced by gdal_retile.py > -spatialTNPrefix > the prefix of spatial table names (produced by the ddl generation utility) > -tileTNPrefix > the prefix of tiles table names (produced by the ddl generation utility) > To import the output of gdal_retile.py using world files (one level) > java -jar gt-imagemosaic-jdbc.jar import -config URLOrFileName > -spatialTN spatialTableName -tileTN tileTableName [-commitCount > commitCount] -dir dir -ext extension > > > To import the output of gdal_retile.py using world files (all levels) > java -jar gt-imagemosaic-jdbc.jar import -config URLOrFileName > -spatialTNPrefix spatialTableNamePrefix -tileTNPrefix > tileTableNamePrefix [-commitCount commitCount] -dir dir -ext extension > > > Options > -dir > The directory containing tiles > -ext > The file extension (png,jpg,tif,..). The extension must have exactly > 3 chars. The world files must have an extension of "wld" or an > extension according to the standard for building word files > (removing the 2. character and appending a 'w'). > image.tif -> image.tfw, image.png -> image.pgw,.... > To import the output of gdal_retile.py using a shape file (one level) > java -jar gt-imagemosaic-jdbc.jar import -config URLOrFileName > -spatialTN spatialTableName -tileTN tileTableName [-commitCount > commitCount] -shape shapeURLOrFileName -shapeKeyField shapeKeyField > > > To import the output of gdal_retile.py using a shape file (all levels) > java -jar gt-imagemosaic-jdbc.jar import -config URLOrFileName > -spatialTNPrefix spatialTableNamePrefix -tileTNPrefix > tileTableNamePrefix [-commitCount commitCount] -shape > shapeURLOrFileName -shapeKeyField shapeKeyField > > > Options > -shape > the URL or the file name of the shape file , e.g "file:/temp/index.shp" > -shapeKeyField > the name of the attribute in the shape file holding the file names > for the tiles > To import the output of gdal_retile.py using a csv file (one level) > java -jar gt-imagemosaic-jdbc.jar import -config URLOrFileName > -spatialTN spatialTableName -tileTN tileTableName [-commitCount > commitCount] -csv csvURLOrFileName -csvDelim csvDelim > > > To import the output of gdal_retile.py using a csv file (all levels) > java -jar gt-imagemosaic-jdbc.jar import -config URLOrFileName > -spatialTNPrefix spatialTableNamePrefix -tileTNPrefix > tileTableNamePrefix [-commitCount commitCount] -csv csvURLOrFileName > -csvDelim csvDelim > > > Options > -csv > the URL or the file name of the csv file , e.g "file:/temp/index.csv" > -csvDelim > The column delimiter in the csv file. > The csv file has exactly 5 columns. > Filename of the tile > minx > maxx > miny > maxy > > Ensure using a point as decimal separator and do not use grouping > speparators for the coordinates. "12345.6789" is ok, "12.345,6789" > is not supported. > A csv example > oek4000_1_1.tif;109546.250000;429601.536800;333297.122340;573436.750000 > oek4000_1_2.tif;429601.536800;688046.180892;333297.122340;573436.750000 > oek4000_2_1.tif;109546.250000;429601.536800;272461.750000;333297.122340 > oek4000_2_2.tif;429601.536800;688046.180892;272461.750000;333297.122340 > > > > > > > > > Document generated by Confluence on Feb 16, 2011 06:43 > > > > > -- > Jody Garnett > > On Sunday, 15 May 2011 at 1:27 AM, [email protected] wrote: >> Hi Jody, I am working on fixing the my broken links from the geoserver >> users guide to the new geotools users guide. It seems that the >> imagemosaic-JDBC doc is not migrated completely. As an exmaple I >> cannot find >> >> >> http://docs.codehaus.org/display/GEOTDOC/Using+the+java+import+utility >> http://docs.codehaus.org/display/GEOTDOC/Creating+indexes+for+performance >> >> Which are referenced from here >> >> http://docs.codehaus.org/display/GEOTDOC/Image+Mosaicing+Pyramidal+JDBC+Plugin >> (bottom of page) >> >> In the new documentation the links are gone. >> >> Can you bring my pages into the game again. >> >> Thanks >> Christian >> >> >> >> >> ---------------------------------------------------------------- >> This message was sent using IMP, the Internet Messaging Program. >> > ---------------------------------------------------------------- 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 _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
