Um I am, and always have been on volunteer time for this so I was out of time
before I started :-)
I am making a uDig release tonight and thus cannot promise when I will get to
this; it sounds like you need something to link to right now?
Idea - could we put a placeholder in so you have something to link to?
Also for this specific section I was trying to ask you if we could combine it
all into one big long page? If you agree you could simply link to the seup (ie
http://docs.geotools.org/latest/userguide/library/coverage/jdbc/setup.html) and
call it a day.
--
Jody Garnett
On Sunday, 15 May 2011 at 4:48 PM, [email protected] wrote:
> 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
