Re: [Geotools-devel] [jira] (GEOT-4507) Easiest way to setup imageMosaicJDBC-PGRaster

2013-07-15 Thread Christian Mueller
Ahh, sorry my fault, using  "raster2pgsql" is ok. There is no support for
importing raster data for Postgres Raster in the imagemosaic-JDBC module,
using the executable raster2pgsql is the way to go.

Cheers





2013/7/15 Daniele Romagnoli 

> Hi Christian,
> I'm not sure to have fully understood your feedbacks.
> Please, read below...
>
>
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
> Ing. Daniele Romagnoli
> Senior Software Engineer
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax:  +39 0584 1660272
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>
>
> On Mon, Jul 15, 2013 at 3:32 PM, Christian Mueller <
> christian.muel...@os-solutions.at> wrote:
>
>> Hi Daniele
>>
>> Personally, I would not go this way. I did a quick look at
>> http://postgis.refractions.net/docs/using_raster.xml.html#RT_Raster_Loader
>>
>> First, I would rely on raster2psql for importing the raster data.
>>
> I'm using indeed the raster2pgsql executable (not the python one) to do
> the raster data import.
> Is it a different tool with respect to raster2psql? I didn't find any
> documentation about raster2psql, whilst I did my tests checking the same
> doc on raster2pgsql you have reported. (Note the "g" char difference)
> If we are talking about the same tool, I see you said "I would"... do you
> mean "I wouldn't"?.
>
>
>
>> The resulting sql script may run a long time and you would risk a timeout
>> if you trigger it within GeoServer. As a consequence, the user has to start
>> the SQL script separately.
>>
>> Second, I would implement a complete new reader according to the new API
>> using the system views
>>
> Well, my task was to simplify and automatize the preconfigurations steps
> available on your ImageMosaicJDBC tutorials to let it work with the current
> ImageMosaicJDBCReader instead of creating a new reader using new APIs.
> Please, let me know your feedbacks about the first point.
>
> Cheers,
> Daniele
>
>
>
>> raster_columns
>> raster_overviews
>>
>> But I will leave it up to you.
>>
>> Cheers Christian
>>
>>
>>
>>
>>
>>
>>
>> 2013/7/15 Daniele Romagnoli 
>>
>>> Continuing the discussion here:
>>> We have a mandate to simplify the PostGIS raster support.
>>> My plan is to create a JDBCPGRasterConfigurationBuilder which, starting
>>> from an input folder containing tiles created with gdal_retile, do this:
>>> - store tiles into DB (using raster2pgsql script)
>>> - create metadata table and store tileTables into it
>>> - create XML configuration file (starting from a template) to specify
>>> connection params, mapping params, and coverage properties
>>> - pass down the newly created config file to the usual reader.
>>>
>>> Parameters (such as DB credentials, table prefixes, ) will be passed
>>> down as a JDBCPGRasterConfigurationBean through Hints.
>>> From a GS point of view, we can setup a new wicket to specify them.
>>>
>>> Cheers,
>>> Daniele
>>>
>>>
>>>
>>>
>>> Daniele
>>>
>>>
>>>
>>> ==
>>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>>> more information.
>>> ==
>>> Ing. Daniele Romagnoli
>>> Senior Software Engineer
>>>
>>> GeoSolutions S.A.S.
>>> Via Poggio alle Viti 1187
>>> 55054  Massarosa (LU)
>>> Italy
>>> phone: +39 0584 962313
>>> fax:  +39 0584 1660272
>>>
>>> http://www.geo-solutions.it
>>> http://twitter.com/geosolutions_it
>>>
>>> ---
>>>
>>>
>>> On Wed, Jul 10, 2013 at 6:23 PM, Daniele Romagnoli <
>>> daniele.romagn...@geo-solutions.it> wrote:
>>>
 A few notes about this JIRA.
 I would like to do something like this:

 1) specify basic parameters (maybe as Hints or as a ConfigurationBean):
 - tablename_prefix
 - mosaic_table_name
 - mosaic_name
 - db properties (host, user, password, db, schema)

 2) configure an ImageMosaicJDBC against a folder contained data
 prepared with gdal_retile.

 Automatic steps performed by new code:
 i) insert each level using raster2pgsql into the proper
 ${tablename_prefix}_level table into the proper $db.$schema
 ii) create a new ${mosaic_table_name} and insert new rows using
 ${mosaic_name} as value for the "name" column and previously created
 tablename_prefix_level tables as values for "tiletable" column.
 iii) create the XML file starting from a template and replace postgis
 connection parameter entries, mastertable name entry, and coverage name.
 iv) open the reader on top of the configuration.

  About point #1, I would like to work with wickets to allow specifying
 these parameters at configuration time when using it from GeoServer.

 What do you think about it?
 Cheers,
 Daniele




 ==
 Our support, Your Success! Visit http://opensdi.geo-solutions.i

Re: [Geotools-devel] [jira] (GEOT-4507) Easiest way to setup imageMosaicJDBC-PGRaster

2013-07-15 Thread Daniele Romagnoli
Hi Christian,
I'm not sure to have fully understood your feedbacks.
Please, read below...


==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Daniele Romagnoli
Senior Software Engineer

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

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

---


On Mon, Jul 15, 2013 at 3:32 PM, Christian Mueller <
christian.muel...@os-solutions.at> wrote:

> Hi Daniele
>
> Personally, I would not go this way. I did a quick look at
> http://postgis.refractions.net/docs/using_raster.xml.html#RT_Raster_Loader
>
> First, I would rely on raster2psql for importing the raster data.
>
I'm using indeed the raster2pgsql executable (not the python one) to do the
raster data import.
Is it a different tool with respect to raster2psql? I didn't find any
documentation about raster2psql, whilst I did my tests checking the same
doc on raster2pgsql you have reported. (Note the "g" char difference)
If we are talking about the same tool, I see you said "I would"... do you
mean "I wouldn't"?.



> The resulting sql script may run a long time and you would risk a timeout
> if you trigger it within GeoServer. As a consequence, the user has to start
> the SQL script separately.
>
> Second, I would implement a complete new reader according to the new API
> using the system views
>
Well, my task was to simplify and automatize the preconfigurations steps
available on your ImageMosaicJDBC tutorials to let it work with the current
ImageMosaicJDBCReader instead of creating a new reader using new APIs.
Please, let me know your feedbacks about the first point.

Cheers,
Daniele



> raster_columns
> raster_overviews
>
> But I will leave it up to you.
>
> Cheers Christian
>
>
>
>
>
>
>
> 2013/7/15 Daniele Romagnoli 
>
>> Continuing the discussion here:
>> We have a mandate to simplify the PostGIS raster support.
>> My plan is to create a JDBCPGRasterConfigurationBuilder which, starting
>> from an input folder containing tiles created with gdal_retile, do this:
>> - store tiles into DB (using raster2pgsql script)
>> - create metadata table and store tileTables into it
>> - create XML configuration file (starting from a template) to specify
>> connection params, mapping params, and coverage properties
>> - pass down the newly created config file to the usual reader.
>>
>> Parameters (such as DB credentials, table prefixes, ) will be passed down
>> as a JDBCPGRasterConfigurationBean through Hints.
>> From a GS point of view, we can setup a new wicket to specify them.
>>
>> Cheers,
>> Daniele
>>
>>
>>
>>
>> Daniele
>>
>>
>>
>> ==
>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>> more information.
>> ==
>> Ing. Daniele Romagnoli
>> Senior Software Engineer
>>
>> GeoSolutions S.A.S.
>> Via Poggio alle Viti 1187
>> 55054  Massarosa (LU)
>> Italy
>> phone: +39 0584 962313
>> fax:  +39 0584 1660272
>>
>> http://www.geo-solutions.it
>> http://twitter.com/geosolutions_it
>>
>> ---
>>
>>
>> On Wed, Jul 10, 2013 at 6:23 PM, Daniele Romagnoli <
>> daniele.romagn...@geo-solutions.it> wrote:
>>
>>> A few notes about this JIRA.
>>> I would like to do something like this:
>>>
>>> 1) specify basic parameters (maybe as Hints or as a ConfigurationBean):
>>> - tablename_prefix
>>> - mosaic_table_name
>>> - mosaic_name
>>> - db properties (host, user, password, db, schema)
>>>
>>> 2) configure an ImageMosaicJDBC against a folder contained data prepared
>>> with gdal_retile.
>>>
>>> Automatic steps performed by new code:
>>> i) insert each level using raster2pgsql into the proper
>>> ${tablename_prefix}_level table into the proper $db.$schema
>>> ii) create a new ${mosaic_table_name} and insert new rows using
>>> ${mosaic_name} as value for the "name" column and previously created
>>> tablename_prefix_level tables as values for "tiletable" column.
>>> iii) create the XML file starting from a template and replace postgis
>>> connection parameter entries, mastertable name entry, and coverage name.
>>> iv) open the reader on top of the configuration.
>>>
>>>  About point #1, I would like to work with wickets to allow specifying
>>> these parameters at configuration time when using it from GeoServer.
>>>
>>> What do you think about it?
>>> Cheers,
>>> Daniele
>>>
>>>
>>>
>>>
>>> ==
>>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>>> more information.
>>> ==
>>> Ing. Daniele Romagnoli
>>> Senior Software Engineer
>>>
>>> GeoSolutions S.A.S.
>>> Via Poggio alle Viti 1187
>>> 55054  Massarosa (LU)
>>> Italy
>>> phone: +39 0584 962313
>>> fax:  +39 0584 1660272
>>>
>>> http://www.geo-solutions.it
>>> http://twitter.com/geosolutions_it
>>>
>>> ---
>>>
>>>
>>> On Wed, Jul 10, 2013 at 6:12 PM, Daniele

Re: [Geotools-devel] [jira] (GEOT-4507) Easiest way to setup imageMosaicJDBC-PGRaster

2013-07-15 Thread Christian Mueller
Hi Daniele

Personally, I would not go this way. I did a quick look at
http://postgis.refractions.net/docs/using_raster.xml.html#RT_Raster_Loader

First, I would rely on raster2psql for importing the raster data. The
resulting sql script may run a long time and you would risk a timeout if
you trigger it within GeoServer. As a consequence, the user has to start
the SQL script separately.

Second, I would implement a complete new reader according to the new API
using the system views

raster_columns
raster_overviews

But I will leave it up to you.

Cheers Christian







2013/7/15 Daniele Romagnoli 

> Continuing the discussion here:
> We have a mandate to simplify the PostGIS raster support.
> My plan is to create a JDBCPGRasterConfigurationBuilder which, starting
> from an input folder containing tiles created with gdal_retile, do this:
> - store tiles into DB (using raster2pgsql script)
> - create metadata table and store tileTables into it
> - create XML configuration file (starting from a template) to specify
> connection params, mapping params, and coverage properties
> - pass down the newly created config file to the usual reader.
>
> Parameters (such as DB credentials, table prefixes, ) will be passed down
> as a JDBCPGRasterConfigurationBean through Hints.
> From a GS point of view, we can setup a new wicket to specify them.
>
> Cheers,
> Daniele
>
>
>
>
> Daniele
>
>
>
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
> Ing. Daniele Romagnoli
> Senior Software Engineer
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax:  +39 0584 1660272
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>
>
> On Wed, Jul 10, 2013 at 6:23 PM, Daniele Romagnoli <
> daniele.romagn...@geo-solutions.it> wrote:
>
>> A few notes about this JIRA.
>> I would like to do something like this:
>>
>> 1) specify basic parameters (maybe as Hints or as a ConfigurationBean):
>> - tablename_prefix
>> - mosaic_table_name
>> - mosaic_name
>> - db properties (host, user, password, db, schema)
>>
>> 2) configure an ImageMosaicJDBC against a folder contained data prepared
>> with gdal_retile.
>>
>> Automatic steps performed by new code:
>> i) insert each level using raster2pgsql into the proper
>> ${tablename_prefix}_level table into the proper $db.$schema
>> ii) create a new ${mosaic_table_name} and insert new rows using
>> ${mosaic_name} as value for the "name" column and previously created
>> tablename_prefix_level tables as values for "tiletable" column.
>> iii) create the XML file starting from a template and replace postgis
>> connection parameter entries, mastertable name entry, and coverage name.
>> iv) open the reader on top of the configuration.
>>
>>  About point #1, I would like to work with wickets to allow specifying
>> these parameters at configuration time when using it from GeoServer.
>>
>> What do you think about it?
>> Cheers,
>> Daniele
>>
>>
>>
>>
>> ==
>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>> more information.
>> ==
>> Ing. Daniele Romagnoli
>> Senior Software Engineer
>>
>> GeoSolutions S.A.S.
>> Via Poggio alle Viti 1187
>> 55054  Massarosa (LU)
>> Italy
>> phone: +39 0584 962313
>> fax:  +39 0584 1660272
>>
>> http://www.geo-solutions.it
>> http://twitter.com/geosolutions_it
>>
>> ---
>>
>>
>> On Wed, Jul 10, 2013 at 6:12 PM, Daniele Romagnoli (JIRA) <
>> j...@codehaus.org> wrote:
>>
>>>Daniele 
>>> Romagnolicreated
>>>  [image:
>>> Improvement] GEOT-4507 
>>>  *Easiest way to setup 
>>> imageMosaicJDBC-PGRaster*
>>>*Issue Type:*  [image: Improvement] Improvement   *Assignee:* 
>>> Unassigned
>>> *Components:*  imagemosaic-jdbc plugin   *Created:*  10/Jul/13 11:11 AM
>>> *Description:*
>>>
>>> Right now, in order to config an imageMosaic JDBC against PGRaster DB
>>> there are several steps to be performed:
>>> 1) use gdal_retile to create tiles for images
>>> 2) insert tiled data as new table (one for level) into PGRaster using
>>> raster2pgsql scripts invokation
>>> 3) create a table containing level information (reference table,
>>> envelope, resolutions)
>>> 4) create 3 XML config files with JDBC mapping, coverage properties,
>>> table mapping
>>> 5) configure the mosaic.
>>>
>>> It would be good to have some automagic way to do steps 2 through 5 with
>>> minimal user intervention.
>>>
>>> As an instance, it would be great if we could just provide the location
>>> of the folder containing tiled images (levels), as well as a set of some
>>> additional parameters (table name prefix, mosaic name, coverage name, DB
>>> credentials) and let the imageMosaicJDBC do all 

Re: [Geotools-devel] [jira] (GEOT-4507) Easiest way to setup imageMosaicJDBC-PGRaster

2013-07-15 Thread Daniele Romagnoli
Continuing the discussion here:
We have a mandate to simplify the PostGIS raster support.
My plan is to create a JDBCPGRasterConfigurationBuilder which, starting
from an input folder containing tiles created with gdal_retile, do this:
- store tiles into DB (using raster2pgsql script)
- create metadata table and store tileTables into it
- create XML configuration file (starting from a template) to specify
connection params, mapping params, and coverage properties
- pass down the newly created config file to the usual reader.

Parameters (such as DB credentials, table prefixes, ) will be passed down
as a JDBCPGRasterConfigurationBean through Hints.
>From a GS point of view, we can setup a new wicket to specify them.

Cheers,
Daniele




Daniele



==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Daniele Romagnoli
Senior Software Engineer

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

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

---


On Wed, Jul 10, 2013 at 6:23 PM, Daniele Romagnoli <
daniele.romagn...@geo-solutions.it> wrote:

> A few notes about this JIRA.
> I would like to do something like this:
>
> 1) specify basic parameters (maybe as Hints or as a ConfigurationBean):
> - tablename_prefix
> - mosaic_table_name
> - mosaic_name
> - db properties (host, user, password, db, schema)
>
> 2) configure an ImageMosaicJDBC against a folder contained data prepared
> with gdal_retile.
>
> Automatic steps performed by new code:
> i) insert each level using raster2pgsql into the proper
> ${tablename_prefix}_level table into the proper $db.$schema
> ii) create a new ${mosaic_table_name} and insert new rows using
> ${mosaic_name} as value for the "name" column and previously created
> tablename_prefix_level tables as values for "tiletable" column.
> iii) create the XML file starting from a template and replace postgis
> connection parameter entries, mastertable name entry, and coverage name.
> iv) open the reader on top of the configuration.
>
>  About point #1, I would like to work with wickets to allow specifying
> these parameters at configuration time when using it from GeoServer.
>
> What do you think about it?
> Cheers,
> Daniele
>
>
>
>
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
> Ing. Daniele Romagnoli
> Senior Software Engineer
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax:  +39 0584 1660272
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>
>
> On Wed, Jul 10, 2013 at 6:12 PM, Daniele Romagnoli (JIRA) <
> j...@codehaus.org> wrote:
>
>>Daniele 
>> Romagnolicreated
>>  [image:
>> Improvement] GEOT-4507 
>>  *Easiest way to setup 
>> imageMosaicJDBC-PGRaster*
>>*Issue Type:*  [image: Improvement] Improvement   *Assignee:* 
>> Unassigned
>> *Components:*  imagemosaic-jdbc plugin   *Created:*  10/Jul/13 11:11 AM
>> *Description:*
>>
>> Right now, in order to config an imageMosaic JDBC against PGRaster DB
>> there are several steps to be performed:
>> 1) use gdal_retile to create tiles for images
>> 2) insert tiled data as new table (one for level) into PGRaster using
>> raster2pgsql scripts invokation
>> 3) create a table containing level information (reference table,
>> envelope, resolutions)
>> 4) create 3 XML config files with JDBC mapping, coverage properties,
>> table mapping
>> 5) configure the mosaic.
>>
>> It would be good to have some automagic way to do steps 2 through 5 with
>> minimal user intervention.
>>
>> As an instance, it would be great if we could just provide the location
>> of the folder containing tiled images (levels), as well as a set of some
>> additional parameters (table name prefix, mosaic name, coverage name, DB
>> credentials) and let the imageMosaicJDBC do all these steps automatically.
>>   *Project:*  GeoTools    *
>> Priority:*  [image: Minor] Minor   *Reporter:*  Daniele 
>> Romagnoli
>>This
>> message is automatically generated by JIRA.
>> If you think it was sent incorrectly, please contact your JIRA
>> administrators
>> For more information on JIRA, see: http://www.atlassian.com/software/jira
>>
>>
>> --
>> See everything from the browser to the database with AppDynamics
>> Get end-to-end visibility with application monitoring from AppDynamics
>> Isolate bottlenecks and diagnose root cause in seconds.
>> Start your free tria

Re: [Geotools-devel] [jira] (GEOT-4507) Easiest way to setup imageMosaicJDBC-PGRaster

2013-07-10 Thread Daniele Romagnoli
A few notes about this JIRA.
I would like to do something like this:

1) specify basic parameters (maybe as Hints or as a ConfigurationBean):
- tablename_prefix
- mosaic_table_name
- mosaic_name
- db properties (host, user, password, db, schema)

2) configure an ImageMosaicJDBC against a folder contained data prepared
with gdal_retile.

Automatic steps performed by new code:
i) insert each level using raster2pgsql into the proper
${tablename_prefix}_level table into the proper $db.$schema
ii) create a new ${mosaic_table_name} and insert new rows using
${mosaic_name} as value for the "name" column and previously created
tablename_prefix_level tables as values for "tiletable" column.
iii) create the XML file starting from a template and replace postgis
connection parameter entries, mastertable name entry, and coverage name.
iv) open the reader on top of the configuration.

About point #1, I would like to work with wickets to allow specifying these
parameters at configuration time when using it from GeoServer.

What do you think about it?
Cheers,
Daniele




==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Daniele Romagnoli
Senior Software Engineer

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

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

---


On Wed, Jul 10, 2013 at 6:12 PM, Daniele Romagnoli (JIRA)  wrote:

>Daniele 
> Romagnolicreated
>  [image:
> Improvement] GEOT-4507 
>  *Easiest way to setup 
> imageMosaicJDBC-PGRaster*
>*Issue Type:*  [image: Improvement] Improvement   *Assignee:* 
> Unassigned
> *Components:*  imagemosaic-jdbc plugin   *Created:*  10/Jul/13 11:11 AM
> *Description:*
>
> Right now, in order to config an imageMosaic JDBC against PGRaster DB
> there are several steps to be performed:
> 1) use gdal_retile to create tiles for images
> 2) insert tiled data as new table (one for level) into PGRaster using
> raster2pgsql scripts invokation
> 3) create a table containing level information (reference table, envelope,
> resolutions)
> 4) create 3 XML config files with JDBC mapping, coverage properties, table
> mapping
> 5) configure the mosaic.
>
> It would be good to have some automagic way to do steps 2 through 5 with
> minimal user intervention.
>
> As an instance, it would be great if we could just provide the location of
> the folder containing tiled images (levels), as well as a set of some
> additional parameters (table name prefix, mosaic name, coverage name, DB
> credentials) and let the imageMosaicJDBC do all these steps automatically.
>   *Project:*  GeoTools    *
> Priority:*  [image: Minor] Minor   *Reporter:*  Daniele 
> Romagnoli 
>   This
> message is automatically generated by JIRA.
> If you think it was sent incorrectly, please contact your JIRA
> administrators
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
> --
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> ___
> GeoTools-Devel mailing list
> GeoTools-Devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
>
--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel


[Geotools-devel] [jira] (GEOT-4507) Easiest way to setup imageMosaicJDBC-PGRaster

2013-07-10 Thread Daniele Romagnoli (JIRA)














































Daniele Romagnoli
 created  GEOT-4507


Easiest way to setup imageMosaicJDBC-PGRaster















Issue Type:


Improvement



Assignee:


Unassigned


Components:


imagemosaic-jdbc plugin



Created:


10/Jul/13 11:11 AM



Description:


Right now, in order to config an imageMosaic JDBC against PGRaster DB there are several steps to be performed:
1) use gdal_retile to create tiles for images
2) insert tiled data as new table (one for level) into PGRaster using raster2pgsql scripts invokation
3) create a table containing level information (reference table, envelope, resolutions)
4) create 3 XML config files with JDBC mapping, coverage properties, table mapping
5) configure the mosaic.

It would be good to have some automagic way to do steps 2 through 5 with minimal user intervention.

As an instance, it would be great if we could just provide the location of the folder containing tiled images (levels), as well as a set of some additional parameters (table name prefix, mosaic name, coverage name, DB credentials) and let the imageMosaicJDBC do all these steps automatically.





Project:


GeoTools



Priority:


Minor




Reporter:


Daniele Romagnoli




























This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira





--
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel