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
------------------------------------------------------------------------------
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
