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 <[email protected]> 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@orkun-HP-EliteBook-8470p:/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 <
> [email protected]> 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 <[email protected]>
>> 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 <
>>> [email protected]> 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 <[email protected]>
>>>> 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 <
>>>>> [email protected]> 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 <[email protected]>
>>>>>> 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
>>>>>>> [email protected]
>>>>>>> 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
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> 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
>>>
>>
>>
>>
>> --
>> 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
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
