[Geoserver-users] ImageMosaicJDBC does not import anything

hello, i am using the ImageMosaicJDBC, but it seems it does not import the tiles i prepared with gdal_retile.py. the followed this tutorial the problem happens when i try to import : java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar import -config /var/lib/tomcat8/webapps/geoserver/data/coverages/clc_l93_postgis.xml -spatialTNPrefix tile_start -dir /root/working/tiles_clc_l93 -ext tif the output is : Importing from a shapefile or csv file Importing all levels -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -dir directory -ext extension Importing one level -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -dir directory -ext extension The default for commitCount is 100 so, it seems the result would be the same if the command was sent without any argument ! and tables are not filled : geoserver=# select count(*) from tile_clc_l93_0; count ------- 0 (1 ligne) my conf : geoserver-2.8.1 gt-imagemosaic-jdbc-14.1 postgresql-9.4-postgis-2.1 I will appreciate, if anyone gives me hint. thanks in advance, Ernest.


View this message in context: ImageMosaicJDBC does not import anything
Sent from the GeoServer - User mailing list archive at Nabble.com.

sorry for the formatting… i repost the message ! hello, i am using the ImageMosaicJDBC, but it seems it does not import the tiles i prepared with gdal_retile.py. i followed this tutorial the problem happens when i try to import : java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar import -config /var/lib/tomcat8/webapps/geoserver/data/coverages/clc_l93_postgis.xml -spatialTNPrefix tile_start -dir /root/working/tiles_clc_l93 -ext tif the output is : Importing from a shapefile or csv file Importing all levels -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -dir directory -ext extension Importing one level -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -dir directory -ext extension The default for commitCount is 100 so, it seems the result would be the same if the command was sent without any argument ! and tables are not filled : geoserver=# select count(*) from tile_clc_l93_0; count ------- 0 my conf : geoserver-2.8.1 gt-imagemosaic-jdbc-14.1 postgresql-9.4-postgis-2.1 I will appreciate, if anyone gives me hint. thanks in advance, Ernest.


View this message in context: Re: ImageMosaicJDBC does not import anything
Sent from the GeoServer - User mailing list archive at Nabble.com.

View this message in context: Sent from the at Nabble.com.

···

sorry for the formatting…
i re-re-post the message, but with thunderbird this time.


hello, i am using the ImageMosaicJDBC, but it seems it does not import the tiles i prepared with gdal_retile.py.
i followed this tutorial the problem happens when i try to import :

java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar import -config /var/lib/tomcat8/webapps/geoserver/data/coverages/clc_l93_postgis.xml -spatialTNPrefix tile_start -dir /root/working/tiles_clc_l93 -ext tif

the output is :

Importing from a shapefile or csv file

Importing all levels

-config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField
Importing from a csv file
-config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim
Importing using world wfiles
-config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -dir directory -ext extension

Importing one level

-config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField
Importing from a csv file
-config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim
Importing using world wfiles
-config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -dir directory -ext extension

The default for commitCount is 100

so, it seems the result would be the same if the command was sent without any argument !

and tables are not filled :

geoserver=# select count(*) from tile_clc_l93_0;
count ------- 0

my conf : geoserver-2.8.1
gt-imagemosaic-jdbc-14.1
postgresql-9.4-postgis-2.1

what happens ? i do not understand, perhaps i miss something ?

I will appreciate, if anyone gives me hint. thanks in advance,

Ernest.

Le 21/01/2016 09:44, MaxiReglisse [via OSGeo.org] a écrit :

sorry for the formatting… i repost the message ! hello, i am using the ImageMosaicJDBC, but it seems it does not import the tiles i prepared with gdal_retile.py. i followed this tutorial the problem happens when i try to import : java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar import -config /var/lib/tomcat8/webapps/geoserver/data/coverages/clc_l93_postgis.xml -spatialTNPrefix tile_start -dir /root/working/tiles_clc_l93 -ext tif the output is : Importing from a shapefile or csv file Importing all levels -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -dir directory -ext extension Importing one level -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -dir directory -ext extension The default for commitCount is 100 so, it seems the result would be the same if the command was sent without any argument ! and tables are not filled : geoserver=# select count(*) from tile_clc_l93_0; count ------- 0 my conf : geoserver-2.8.1 gt-imagemosaic-jdbc-14.1 postgresql-9.4-postgis-2.1 I will appreciate, if anyone gives me hint. thanks in advance, Ernest.


If you reply to this email, your message will be added to the discussion below:
http://osgeo-org.1560.x6.nabble.com/ImageMosaicJDBC-does-not-import-anything-tp5246352p5246453.html
To unsubscribe from ImageMosaicJDBC does not import anything, click here.
NAML

-- 
Ernest CHIARELLO  -  [hidden email]
UMR6049 ThéMA - Théoriser et Modéliser pour Aménager
CNRS / université de Bourgogne Franche-Comté
32 rue Mégevand 25030 BESANÇON Cedex

Tel : 03 81 66 54 80           Mob : 07 82 99 11 08


Re: ImageMosaicJDBC does not import anything
GeoServer - User mailing list archive

problem solved :

-tileTNPrefix was missing !

sorry…

Ernest.

···

Le 21/01/2016 09:57, MaxiReglisse a écrit :

View this message in context: Sent from the at Nabble.com.

-- 
Ernest CHIARELLO  -  [Ernest.Chiarello@anonymised.com](mailto:Ernest.Chiarello@anonymised.com)
UMR6049 ThéMA - Théoriser et Modiliser pour Aménager
CNRS / université de Bourgogne Franche-Comté
32 rue Mégevand 25030 BESANÇON Cedex

Tel : 03 81 66 54 80           Mob : 07 82 99 11 08

sorry for the formatting…
i re-re-post the message, but with thunderbird this time.


hello, i am using the ImageMosaicJDBC, but it seems it does not import the tiles i prepared with gdal_retile.py.
i followed this tutorial the problem happens when i try to import :

java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar import -config /var/lib/tomcat8/webapps/geoserver/data/coverages/clc_l93_postgis.xml -spatialTNPrefix tile_start -dir /root/working/tiles_clc_l93 -ext tif

the output is :

Importing from a shapefile or csv file

Importing all levels

-config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField
Importing from a csv file
-config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim
Importing using world wfiles
-config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -dir directory -ext extension

Importing one level

-config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField
Importing from a csv file
-config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim
Importing using world wfiles
-config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -dir directory -ext extension

The default for commitCount is 100

so, it seems the result would be the same if the command was sent without any argument !

and tables are not filled :

geoserver=# select count(*) from tile_clc_l93_0;
count ------- 0

my conf : geoserver-2.8.1
gt-imagemosaic-jdbc-14.1
postgresql-9.4-postgis-2.1

what happens ? i do not understand, perhaps i miss something ?

I will appreciate, if anyone gives me hint. thanks in advance,

Ernest.

Le 21/01/2016 09:44, MaxiReglisse [via OSGeo.org] a écrit :

sorry for the formatting… i repost the message ! hello, i am using the ImageMosaicJDBC, but it seems it does not import the tiles i prepared with gdal_retile.py. i followed this tutorial the problem happens when i try to import : java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar import -config /var/lib/tomcat8/webapps/geoserver/data/coverages/clc_l93_postgis.xml -spatialTNPrefix tile_start -dir /root/working/tiles_clc_l93 -ext tif the output is : Importing from a shapefile or csv file Importing all levels -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTNPrefix spatialTablePrefix -tileTNPrefix tileTablePrefix [-commitCount commitCount] -dir directory -ext extension Importing one level -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -shape shapeURLOrFile -shapeKeyField shapeKeyField Importing from a csv file -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -csv csvURLOrFile -csvDelim csvDelim Importing using world wfiles -config URLOrFile -spatialTN spatialTableName -tileTN tileTableName [-commitCount commitCount] -dir directory -ext extension The default for commitCount is 100 so, it seems the result would be the same if the command was sent without any argument ! and tables are not filled : geoserver=# select count(*) from tile_clc_l93_0; count ------- 0 my conf : geoserver-2.8.1 gt-imagemosaic-jdbc-14.1 postgresql-9.4-postgis-2.1 I will appreciate, if anyone gives me hint. thanks in advance, Ernest.


If you reply to this email, your message will be added to the discussion below:
http://osgeo-org.1560.x6.nabble.com/ImageMosaicJDBC-does-not-import-anything-tp5246352p5246453.html
To unsubscribe from ImageMosaicJDBC does not import anything, click here.
NAML

-- 
Ernest CHIARELLO  -  [hidden email]
UMR6049 ThéMA - Théoriser et Modéliser pour Aménager
CNRS / université de Bourgogne Franche-Comté
32 rue Mégevand 25030 BESANÇON Cedex

Tel : 03 81 66 54 80           Mob : 07 82 99 11 08


Re: ImageMosaicJDBC does not import anything
GeoServer - User mailing list archive

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
[http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140](http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140)
_______________________________________________
Geoserver-users mailing list
[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.comsourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)