Hi Ahmet
The output of gdalinfo looks ok.
Cheers
Christian
On Mon, Apr 20, 2015 at 7:22 PM, Ahmet Temiz <[email protected]> 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 <
> [email protected]> 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 <[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
>>
>>
>
>
> --
> 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
