[gdal-dev] gdalinfo on PostGIS rasters (GDAL 1.9)

Mathieu Basille basille at ase-research.org
Wed Nov 14 12:46:03 PST 2012


Dear Even,

This works now perfectly!

I didn't have time to install GDAL trunk until now. The installation went 
almost smoothly (see below if it is any useful). If I run the exact same 
gdalinfo command as before , I now have relevant information:

$ gdalinfo "PG:dbname=mydb host=localhost user=pguser schema=myschema 
table=myraster"
Driver: PostGISRaster/PostGIS Raster driver
Files: none associated
Size is 12, 11
Coordinate System is:
GEOGCS["WGS 84",
     DATUM["WGS_1984",
         SPHEROID["WGS 84",6378137,298.257223563,
             AUTHORITY["EPSG","7030"]],
         AUTHORITY["EPSG","6326"]],
     PRIMEM["Greenwich",0,
         AUTHORITY["EPSG","8901"]],
     UNIT["degree",0.0174532925199433,
         AUTHORITY["EPSG","9122"]],
     AUTHORITY["EPSG","4326"]]
Origin = (-81.971000000000004,26.337499999999999)
Pixel Size = (0.167000000000000,-0.167000000000000)
Corner Coordinates:
Upper Left  ( -81.9710000,  26.3375000) ( 81d58'15.60"W, 26d20'15.00"N)
Lower Left  ( -81.9710000,  24.5005000) ( 81d58'15.60"W, 24d30' 1.80"N)
Upper Right ( -79.9670000,  26.3375000) ( 79d58' 1.20"W, 26d20'15.00"N)
Lower Right ( -79.9670000,  24.5005000) ( 79d58' 1.20"W, 24d30' 1.80"N)
Center      ( -80.9690000,  25.4190000) ( 80d58' 8.40"W, 25d25' 8.40"N)
Band 1 Block=12x11 Type=Float32, ColorInterp=Undefined
   NoData Value=0
   Overviews: arbitrary

This is perfect! Thanks a lot.
Mathieu.


=====================================================================
   Installation procedure of GDAL trunk under Debian Wheezy
=====================================================================

# aptitude install libpoppler-dev libproj-dev libpq-dev python-dev
# cd /usr/src
# svn checkout https://svn.osgeo.org/gdal/trunk/gdal gdal
# cd gdal
# ./configure --with-poppler --with-geos --with-python --with-odbc --with-pg
# make
# make install
# exit


Le 08/11/2012 13:52, Even Rouault a écrit :
>> Even, that's what I was afraid of... I think I will give it a try. Is there
>> a preferred solution between sources from Subversion and the nightly
>> snapshots?
>
> up to you
>
>> Second, do I understand it correctly that I need to 1) install GDAL from
>> sources,
>
> yes
>
>> and 2) recompile PostGIS on this GDAL version?
>
> not necessarily. The raster module of PostGIS doesn't use the GDAL
> PostGISRaster driver (AFAIK)
>
>> Third, can GDAL trunk live together with my current version of GDAL?
>
> Yes, you have to ./configure --prefix=/some/path and then by adjusting the PATH
> and LD_LIBRARY_PATH environmenet variables, you can run your custom build of
> GDAL.

-- 

~$ whoami
Mathieu Basille, PhD

~$ locate --details
University of Florida \\
Fort Lauderdale Research and Education Center
(+1) 954-577-6314
http://ase-research.org/basille

~$ fortune
« Le tout est de tout dire, et je manque de mots
Et je manque de temps, et je manque d'audace. »
  -- Paul Éluard


More information about the gdal-dev mailing list