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