<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Buona sera a tutti.<br>
Ho caricato 12 GeoTIFF ASTER su PostGIS con il comando<br>
<font color="#cc0000"><small><small>raster2pgsql -c -s 4326 -F -I -M
-e *.tif aster.astergdem1sec | psql -d [nomedatabase] -U
[nomeutente]</small></small></font><br>
e visualizzando la vista "raster_columns" il campo "srid" è
valorizzato come 0.<br>
ho provato a farmi dare l'SRID di ogni GeoTIFF con il comando<br>
<font color="#cc0000"><small><small>SELECT rid, filename,
ST_SRID(rast) FROM aster.astergdem1sec</small></small></font><br>
e la terza colonna viene correttamente valorizzata a 4326, inoltre
ho provato con gdalinfo su un GeoTIFF ed ho ottenuto<br>
<font color="#cc0000"><small><small>$ gdalinfo
ASTGTM2_N37E015_dem.tif<br>
Driver: GTiff/GeoTIFF<br>
Files: ASTGTM2_N37E015_dem.tif<br>
Size is 3601, 3601<br>
Coordinate System is:<br>
GEOGCS["WGS 84",<br>
DATUM["WGS_1984",<br>
SPHEROID["WGS 84",6378137,298.257223563,<br>
AUTHORITY["EPSG","7030"]],<br>
AUTHORITY["EPSG","6326"]],<br>
PRIMEM["Greenwich",0],<br>
UNIT["degree",0.0174532925199433],<br>
AUTHORITY["EPSG","4326"]]<br>
Origin = (14.999861111111111,38.000138888888891)<br>
Pixel Size = (0.000277777777778,-0.000277777777778)<br>
Metadata:<br>
AREA_OR_POINT=Area<br>
TIFFTAG_DATETIME=2011:03:15 19:22:45<br>
TIFFTAG_DOCUMENTNAME=created at<br>
TIFFTAG_IMAGEDESCRIPTION=SILC TIFF<br>
TIFFTAG_RESOLUTIONUNIT=2 (pixels/inch)<br>
TIFFTAG_SOFTWARE=IDL 7.1.1, ITT Visual Information Solutions<br>
TIFFTAG_XRESOLUTION=100<br>
TIFFTAG_YRESOLUTION=100<br>
Image Structure Metadata:<br>
INTERLEAVE=BAND<br>
Corner Coordinates:<br>
Upper Left ( 14.9998611, 38.0001389) ( 14d59'59.50"E, 38d
0' 0.50"N)<br>
Lower Left ( 14.9998611, 36.9998611) ( 14d59'59.50"E,
36d59'59.50"N)<br>
Upper Right ( 16.0001389, 38.0001389) ( 16d 0' 0.50"E, 38d
0' 0.50"N)<br>
Lower Right ( 16.0001389, 36.9998611) ( 16d 0' 0.50"E,
36d59'59.50"N)<br>
Center ( 15.5000000, 37.5000000) ( 15d30' 0.00"E,
37d30' 0.00"N)<br>
Band 1 Block=3601x1 Type=Int16, ColorInterp=Gray</small></small></font><br>
... secondo voi ho dimenticato qualcosa?<br>
La versione di PostGIS è la seguente<br>
<font color="#cc0000"><small><small>POSTGIS="2.0.1 r9979"
GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012"
GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" RASTER</small></small></font><br>
Saluti.<br>
</body>
</html>