[Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

Ahmet_Temiz · April 19, 2015, 4:35pm

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

···

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

Christian_Mueller · April 20, 2015, 7:31am

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

···

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com4…> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet_Temiz · April 20, 2015, 8:35am

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :

raster2pgsql -s 4236 -I -C -M *.tif ....

regards

···

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com.84…> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

Christian_Mueller · April 20, 2015, 8:43am

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers
Christian

···

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :
raster2pgsql -s 4236 -I -C -M *.tif ....
regards

–

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet_Temiz · April 20, 2015, 12:57pm

(Thank you Christian ,)

when I tried raster2pgsql on tiles created previously with
gdal_retile.py, I got this error message

Processing 84/84: ./test3/dem2_4326_06_14.tif
ERROR: diff_rastinfo: Could not run raster alignment test

Do you have any idea ?

regards

···

On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers

Christian

–

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :
raster2pgsql -s 4236 -I -C -M *.tif ....
regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com…> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

Christian_Mueller · April 20, 2015, 1:20pm

Check your tile with

gdalinfo /test3/dem2_4326_06_14.tif

Additionally try to import only the problematic tiff.

Cheers
Christian

···

On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

(Thank you Christian ,)

when I tried raster2pgsql on tiles created previously with
gdal_retile.py, I got this error message

Processing 84/84: ./test3/dem2_4326_06_14.tif
ERROR: diff_rastinfo: Could not run raster alignment test

Do you have any idea ?

regards

–

On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <christian.mueller@anonymised.com…5445…> wrote:

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :
raster2pgsql -s 4236 -I -C -M *.tif ....
regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@…84…> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet_Temiz · April 20, 2015, 1:39pm

thank you and sorry taking up your time

untiled whole image can be loaded to postgis with raster2pgsql normally.

but when I tiled same image with:
gdal_retile.py -levels 3 -ps 256 256 -tileIndex index.shp -targetDir test2 dem2_4326.tif

gdalinfo looks like :

orkun@anonymised.com:/usr/local/dem22/test2$ gdalinfo dem2_4326_06_14.tif
Driver: GTiff/GeoTIFF
Files: dem2_4326_06_14.tif
dem2_4326_06_14.tfw
dem2_4326_06_14.tif.aux.xml
Size is 150, 101
Coordinate System is:
GEOGCS[“WGS 84”,
DATUM[“WGS_1984”,
SPHEROID[“WGS 84”,6378137,298.257223563,
AUTHORITY[“EPSG”,“7030”]],
AUTHORITY[“EPSG”,“6326”]],
PRIMEM[“Greenwich”,0],
UNIT[“degree”,0.0174532925199433],
AUTHORITY[“EPSG”,“4326”]]
Origin = (29.526600914328423,40.467521186796759)
Pixel Size = (0.000225018604065,-0.000225018604065)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 29.5266009, 40.4675212) ( 29d31’35.76"E, 40d28’ 3.08"N)
Lower Left ( 29.5266009, 40.4447943) ( 29d31’35.76"E, 40d26’41.26"N)
Upper Right ( 29.5603537, 40.4675212) ( 29d33’37.27"E, 40d28’ 3.08"N)
Lower Right ( 29.5603537, 40.4447943) ( 29d33’37.27"E, 40d26’41.26"N)
Center ( 29.5434773, 40.4561577) ( 29d32’36.52"E, 40d27’22.17"N)
Band 1 Block=150x27 Type=Int16, ColorInterp=Gray
Min=0.000 Max=0.000
Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
Metadata:
STATISTICS_MAXIMUM=0
STATISTICS_MEAN=0
STATISTICS_MINIMUM=0
STATISTICS_STDDEV=0

···

On Mon, Apr 20, 2015 at 4:20 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Check your tile with

gdalinfo /test3/dem2_4326_06_14.tif

Additionally try to import only the problematic tiff.

Cheers

Christian

–

On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz <ahmettemiz88@anonymised.com.> wrote:

(Thank you Christian ,)

when I tried raster2pgsql on tiles created previously with
gdal_retile.py, I got this error message

Processing 84/84: ./test3/dem2_4326_06_14.tif
ERROR: diff_rastinfo: Could not run raster alignment test

Do you have any idea ?

regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :
raster2pgsql -s 4236 -I -C -M *.tif ....
regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com5…> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

Christian_Mueller · April 20, 2015, 1:53pm

If raster2pgsql creates tiles (and overviews) itself, you can omit gdal_retile. AFAIK, this was not possible at the time I wrote the documentation.

Cheers
Christian

···

On Mon, Apr 20, 2015 at 3:39 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you and sorry taking up your time

untiled whole image can be loaded to postgis with raster2pgsql normally.

but when I tiled same image with:
gdal_retile.py -levels 3 -ps 256 256 -tileIndex index.shp -targetDir test2 dem2_4326.tif

gdalinfo looks like :

orkun@anonymised.com:/usr/local/dem22/test2$ gdalinfo dem2_4326_06_14.tif
Driver: GTiff/GeoTIFF
Files: dem2_4326_06_14.tif
dem2_4326_06_14.tfw
dem2_4326_06_14.tif.aux.xml
Size is 150, 101
Coordinate System is:
GEOGCS[“WGS 84”,
DATUM[“WGS_1984”,
SPHEROID[“WGS 84”,6378137,298.257223563,
AUTHORITY[“EPSG”,“7030”]],
AUTHORITY[“EPSG”,“6326”]],
PRIMEM[“Greenwich”,0],
UNIT[“degree”,0.0174532925199433],
AUTHORITY[“EPSG”,“4326”]]
Origin = (29.526600914328423,40.467521186796759)
Pixel Size = (0.000225018604065,-0.000225018604065)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 29.5266009, 40.4675212) ( 29d31’35.76"E, 40d28’ 3.08"N)
Lower Left ( 29.5266009, 40.4447943) ( 29d31’35.76"E, 40d26’41.26"N)
Upper Right ( 29.5603537, 40.4675212) ( 29d33’37.27"E, 40d28’ 3.08"N)
Lower Right ( 29.5603537, 40.4447943) ( 29d33’37.27"E, 40d26’41.26"N)
Center ( 29.5434773, 40.4561577) ( 29d32’36.52"E, 40d27’22.17"N)
Band 1 Block=150x27 Type=Int16, ColorInterp=Gray
Min=0.000 Max=0.000
Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
Metadata:
STATISTICS_MAXIMUM=0
STATISTICS_MEAN=0
STATISTICS_MINIMUM=0
STATISTICS_STDDEV=0

One more question
raster2pgsql creates tiles so why do we need gdal_retile as extra work ?

regards

–

On Mon, Apr 20, 2015 at 4:20 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Check your tile with

gdalinfo /test3/dem2_4326_06_14.tif

Additionally try to import only the problematic tiff.

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

(Thank you Christian ,)

when I tried raster2pgsql on tiles created previously with
gdal_retile.py, I got this error message

Processing 84/84: ./test3/dem2_4326_06_14.tif
ERROR: diff_rastinfo: Could not run raster alignment test

Do you have any idea ?

regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :
raster2pgsql -s 4236 -I -C -M *.tif ....
regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet_Temiz · April 20, 2015, 5:22pm

thank you

here is the excerpt from PostGIS Cookbook:

···

On Mon, Apr 20, 2015 at 4:53 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

If raster2pgsql creates tiles (and overviews) itself, you can omit gdal_retile. AFAIK, this was not possible at the time I wrote the documentation.

Cheers

Christian

–

On Mon, Apr 20, 2015 at 3:39 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you and sorry taking up your time

untiled whole image can be loaded to postgis with raster2pgsql normally.

but when I tiled same image with:
gdal_retile.py -levels 3 -ps 256 256 -tileIndex index.shp -targetDir test2 dem2_4326.tif

gdalinfo looks like :

orkun@anonymised.com:/usr/local/dem22/test2$ gdalinfo dem2_4326_06_14.tif
Driver: GTiff/GeoTIFF
Files: dem2_4326_06_14.tif
dem2_4326_06_14.tfw
dem2_4326_06_14.tif.aux.xml
Size is 150, 101
Coordinate System is:
GEOGCS[“WGS 84”,
DATUM[“WGS_1984”,
SPHEROID[“WGS 84”,6378137,298.257223563,
AUTHORITY[“EPSG”,“7030”]],
AUTHORITY[“EPSG”,“6326”]],
PRIMEM[“Greenwich”,0],
UNIT[“degree”,0.0174532925199433],
AUTHORITY[“EPSG”,“4326”]]
Origin = (29.526600914328423,40.467521186796759)
Pixel Size = (0.000225018604065,-0.000225018604065)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 29.5266009, 40.4675212) ( 29d31’35.76"E, 40d28’ 3.08"N)
Lower Left ( 29.5266009, 40.4447943) ( 29d31’35.76"E, 40d26’41.26"N)
Upper Right ( 29.5603537, 40.4675212) ( 29d33’37.27"E, 40d28’ 3.08"N)
Lower Right ( 29.5603537, 40.4447943) ( 29d33’37.27"E, 40d26’41.26"N)
Center ( 29.5434773, 40.4561577) ( 29d32’36.52"E, 40d27’22.17"N)
Band 1 Block=150x27 Type=Int16, ColorInterp=Gray
Min=0.000 Max=0.000
Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
Metadata:
STATISTICS_MAXIMUM=0
STATISTICS_MEAN=0
STATISTICS_MINIMUM=0
STATISTICS_STDDEV=0

One more question
raster2pgsql creates tiles so why do we need gdal_retile as extra work ?

regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 4:20 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Check your tile with

gdalinfo /test3/dem2_4326_06_14.tif

Additionally try to import only the problematic tiff.

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

(Thank you Christian ,)

when I tried raster2pgsql on tiles created previously with
gdal_retile.py, I got this error message

Processing 84/84: ./test3/dem2_4326_06_14.tif
ERROR: diff_rastinfo: Could not run raster alignment test

Do you have any idea ?

regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :
raster2pgsql -s 4236 -I -C -M *.tif ....
regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

Christian_Mueller · April 21, 2015, 7:36am

Hi Ahmet

The output of gdalinfo looks ok.

Cheers
Christian

···

On Mon, Apr 20, 2015 at 7:22 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you

here is the excerpt from PostGIS Cookbook:

$ raster2pgsql -I -C -F -t 100x100 -s 4326 worldclim/tmax01.bil chp01.
tmax01 > tmax01.sql

If you decide to include the -t option, then you will cut the original raster in tiles, each
inserted as a single row in the raster table. In this case, you decided to cut the raster in
100x100 tiles, resulting in 198 table rows in the raster table.

pg. 45

what do you say about my gdalinfo output?

regards

–

On Mon, Apr 20, 2015 at 4:53 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

If raster2pgsql creates tiles (and overviews) itself, you can omit gdal_retile. AFAIK, this was not possible at the time I wrote the documentation.

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 3:39 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you and sorry taking up your time

untiled whole image can be loaded to postgis with raster2pgsql normally.

but when I tiled same image with:
gdal_retile.py -levels 3 -ps 256 256 -tileIndex index.shp -targetDir test2 dem2_4326.tif

gdalinfo looks like :

orkun@anonymised.com:/usr/local/dem22/test2$ gdalinfo dem2_4326_06_14.tif
Driver: GTiff/GeoTIFF
Files: dem2_4326_06_14.tif
dem2_4326_06_14.tfw
dem2_4326_06_14.tif.aux.xml
Size is 150, 101
Coordinate System is:
GEOGCS[“WGS 84”,
DATUM[“WGS_1984”,
SPHEROID[“WGS 84”,6378137,298.257223563,
AUTHORITY[“EPSG”,“7030”]],
AUTHORITY[“EPSG”,“6326”]],
PRIMEM[“Greenwich”,0],
UNIT[“degree”,0.0174532925199433],
AUTHORITY[“EPSG”,“4326”]]
Origin = (29.526600914328423,40.467521186796759)
Pixel Size = (0.000225018604065,-0.000225018604065)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=BAND
Corner Coordinates:
Upper Left ( 29.5266009, 40.4675212) ( 29d31’35.76"E, 40d28’ 3.08"N)
Lower Left ( 29.5266009, 40.4447943) ( 29d31’35.76"E, 40d26’41.26"N)
Upper Right ( 29.5603537, 40.4675212) ( 29d33’37.27"E, 40d28’ 3.08"N)
Lower Right ( 29.5603537, 40.4447943) ( 29d33’37.27"E, 40d26’41.26"N)
Center ( 29.5434773, 40.4561577) ( 29d32’36.52"E, 40d27’22.17"N)
Band 1 Block=150x27 Type=Int16, ColorInterp=Gray
Min=0.000 Max=0.000
Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
Metadata:
STATISTICS_MAXIMUM=0
STATISTICS_MEAN=0
STATISTICS_MINIMUM=0
STATISTICS_STDDEV=0

One more question
raster2pgsql creates tiles so why do we need gdal_retile as extra work ?

regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 4:20 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Check your tile with

gdalinfo /test3/dem2_4326_06_14.tif

Additionally try to import only the problematic tiff.

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

(Thank you Christian ,)

when I tried raster2pgsql on tiles created previously with
gdal_retile.py, I got this error message

Processing 84/84: ./test3/dem2_4326_06_14.tif
ERROR: diff_rastinfo: Could not run raster alignment test

Do you have any idea ?

regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers

Christian

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

thank you Christian,

So, Is this way correct ?

after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :
raster2pgsql -s 4236 -I -C -M *.tif ....
regards

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz <ahmettemiz88@anonymised.com> wrote:

hello

I am trying to populate postgis raster table with " gt-imagemosaic-jdbc-12.2.jar import "

I got this structure in postgis :

tr2=> \d spatialtable_0
Table “public.spatialtable_0”
Column | Type | Modifiers
----------±----------------------------±----------
location | character(64) | not null
geom | geometry(MultiPolygon,4326) |
Indexes:
“spatialtable_0_pk” PRIMARY KEY, btree (location)
“ix_spatialtable_0” gist (geom)

tr2=> \d tiletable_0
Table “public.tiletable_0”
Column | Type | Modifiers
----------±--------------±----------
location | character(64) | not null
data | bytea |
Indexes:
“tiletable_0_pk” PRIMARY KEY, btree (location)

—

I am not sure if it is correct structure ?
What am I doing wrong ?

regards

–

Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem Dairesi Başkanlığı-CBS Grubu

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency

BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH