GeoTools

OSGeo

Table Of Contents

Previous topic

Prepare with gdal_retile

Next topic

Create the meta table

This Page

Using the java ddl generation utility

Call Syntax:

java -jar gt-imagemosaicjdbc ddl   -config URLOrFileName -spatialTNPrefix spatialTNPrefix [-tileTNPrefix tileTNPrefix]
      [-pyramids pyramids] -statementDelim statementDelim [-srs srs ] -targetDir

Options:

  • -config

    The URL or the file name of your xml configuration

  • -spatialTNPrefix

    The Prefix of the spatial tables. A prefix of “SPAT” results in tables SPAT_0,SPAT_1,....

  • -tileTNPrefix

    The Prefix of the tile tables. Only needed if you plan to store image data in a separate table.

  • -pyramids

    Number of pyramid tables

  • -statementDelim

    The sql statement delimiter used in the scripts

  • -srs

    The srs needed for a spatial extension. Not required for universal and mysql.

  • -targetDir

    The directory where to put the script templates.

Generated Scripts

createmeta.sql
The create table statement for the metatable
dropmeta.sql
The drop table statement for the meta table
add_<coverage_name>.sql
All statements for adding a coverage named <coverage_name> (taken from the config)
remove_<coverage_name>.sql
All statements for removing a coverage named <coverage_name> (taken from the config)