[Live-demo] Postgis questions

Sat Jan 23 11:44:07 PST 2016

Hi Brian

In Ubuntu 14.04, set the last part of
/etc/postgresql/9.4/main/postgresql.conf (under the comment
# Add settings for extensions here

as such:

postgis.gdal_enabled_drivers 'ENABLE_ALL'
postgis.enable_outdb_rasters TRUE

restart postgres

In your postgis enabled db, do the following:
select long_name from st_gdaldrivers();

and you will see a lot of gdal enabled drivers

such as:

                long_name
--------------------------------------------
 Virtual Raster
 GeoTIFF
 National Imagery Transmission Format
 Erdas Imagine Images (.img)
 Arc/Info ASCII Grid
 DTED Elevation Raster
 Portable Network Graphics
 JPEG JFIF
 Graphics Interchange Format (.gif)
 X11 PixMap Format
 ILWIS Raster Map
 SRTMHGT File Format
 JPEG-2000 driver based on OpenJPEG library
 FIT Image
 JPEG-2000 part 1 (ISO/IEC 15444-1)
 OGC Web Map Service
 Idrisi Raster A.1
 Intergraph Raster
 Golden Software ASCII Grid (.grd)
 Golden Software Binary Grid (.grd)
 Golden Software 7 Binary Grid (.grd)
 R Object Data Store
 ESRI .hdr Labelled
 FARSITE v.4 Landscape File (.lcp)
 Azavea Raster Grid format
 USGS Optional ASCII DEM (and CDED)
 Epsilon wavelets
 SAGA GIS Binary Grid (.sdat)
 Kml Super Overlay
 ASCII Gridded XYZ
 HF2/HFZ heightfield raster
 Geospatial PDF
 WEBP
 ZMap Plus Grid
(34 rows)

Regards

Pieter

On Sat, Jan 23, 2016 at 9:01 PM, Brian M Hamlin <maplabs at light42.com> wrote:

> Hi Pieter --
>
>
>
>   oh, ok.. thats new to me..
>
>   according to the PostGIS docs page..
>
>    http://postgis.net/docs/postgis_gdal_enabled_drivers.html
>
>
>
>   those variables can be set at all levels..
>
>   cluster-wide -> postgresql.conf
>
>   database-persistant ->  ALTER DATABASE ...
>
>   database-temp, psql session temp  ->  set ....
>
>
>
> also apparently SHELL with bash-style environment vars, as in .bashrc
>
>
>
> I would think that all gdal drivers would be enabled by default, and that
> really you
>
> need  raster out_db set...  so I look here
>
>     http://postgis.net/docs/postgis_enable_outdb_rasters.html
>
>
>
> make sense ?
>
>   -Brian
>
>
>
> On Sat, 23 Jan 2016 19:51:42 +0200, Pieter du Plooy <
> pjduplooy at zpanelcp.com> wrote:
>
> Hi Brian
>
> Thx for the info, but what I really need is where to
>
> postgis.gdal_enabled_drivers = 'ENABLE_ALL'
>
> and postgis.enable_outdb_rasters=1
>
> in Ubuntu 14.04, and system wide
>
> I did it previously in my .bashrc, but for some reason its not
> working now.
>
> Pieter
>
>
> On Sat, Jan 23, 2016 at 6:58 PM, Brian M Hamlin <maplabs at light42.com>
> wrote:
>
>> Hi Pieter --
>>
>>
>>
>>   I have an a2 build running in a VM.
>>
>>
>>
>> user at live95a:~$ locate raster.tif        <= there is an example file for
>> a QGis plugin called this
>>
>> user at live95a:~$ gdalinfo /path/to/raster.tif
>>
>>    hmm non-trivial .. open qgis to let qgis do the work
>>
>>    qgis shows the projection is EPSG:32633
>>
>>
>>
>> user at live95a:~$  createdb raster_test
>>
>> user at live95a:~$ psql -c 'create extension postgis' raster_test
>>
>> user at live95a:~$ psql -c 'select postgis_full_version()' raster_test
>>
>>     yes, RASTER is enabled
>>
>>     use raster2pgsql to load a raster, as per PostGIS raster manual
>>
>>
>>
>> user at live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif
>> raster_test | less
>>
>>     inspect output, yes looks valid
>>
>>
>>
>> user at live95a:~$ raster2pgsql -s 32633 -I -C /path/to/raster.tif
>> raster_test | psql raster_test
>>
>> user at live95a:~$ psql -c '\d raster_test'
>>
>>     note rid, rast columns.. lots of other detail
>>
>>     better command line would name the tables, split into tiles, etc...
>>
>>
>>
>>   hth --Brian
>>
>>
>>
>>
>>
>> On Sat, 23 Jan 2016 16:45:50 +0200, Pieter du Plooy <
>> pjduplooy at zpanelcp.com> wrote:
>>
>> I am struggling to enable postgis gdal drivers and outdb rasters on
>> Ubuntu (using postgis from the osgeolive nightly, so its for trusty.
>>
>> How do I go about enabling them in Ubuntu Trusty?
>>
>> I have tried setting it in .profile, as well as .bashrc systemwide
>> etc..., but no luck.
>>
>> Any help?
>>
>> Regards
>>
>> Pieter
>> ------------------------------
>>
>> _______________________________________________
>> Live-demo mailing list
>> Live-demo at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/live-demo
>> <http://../hwebmail/services/go.php?url=http%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Flive-demo>
>> http://live.osgeo.org
>> <http://../hwebmail/services/go.php?url=http%3A%2F%2Flive.osgeo.org>
>> http://wiki.osgeo.org/wiki/Live_GIS_Disc
>> <http://../hwebmail/services/go.php?url=http%3A%2F%2Fwiki.osgeo.org%2Fwiki%2FLive_GIS_Disc>
>>
>>
>>
>>
>> --
>> Brian M Hamlin
>> OSGeo California Chapter
>> blog.light42.com
>>
>>
>>
>
>
>
> --
> Brian M Hamlin
> OSGeo California Chapter
> blog.light42.com
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20160123/29d38ac8/attachment.html>