[GIS] raster2pgsql part of PostGIS

homebrewpostgispostgis-1.5postgresqlraster

I wanted to use the PostGIS functionality raster2pgsql, but I had to discover that the Python function was not installed with my PostGIS installation.

Do you know if raster2pgsql is generally part of the PostGIS installation or do I have to install a special package?

I installed PostGreSQL and PostGIS on my mac via homebrew.
> brew upgrade postgis tells my that the latest version is installed, which is obviously not the case (1.5.3 installed, but 1.5.5 available).

The complete installation is

select PostGIS_full_version();
postgis_full_version                                          
---------------------------------------
POSTGIS="1.5.3" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.3" USE_STATS

Best Answer

According to the latest PostGIS docs on loading raster data:

The older version of this tool was a python script. The executable has replaced the python script. If you still find the need for the Python script Examples of the python one can be found at GDAL PostGIS Raster Driver Usage. Please note that the raster2pgsql python script may not work with future versions of PostGIS raster and is no longer supported.

To the question about versions, homebrew doesn't provide the latest version of a software package, it just provides the latest version that someone has packaged for homebrew. If the absolute latest isn't up there, then you won't get the absolute latest. An alternative source is KyngChaos.

If you are looking for the latest in raster processing for PostGIS I suggest checking out WKTRaster, too.

Related Solutions

[GIS] How to fix ‘GEOSDifference: TopologyException’

You're working with invalid geometries (at least the first one is invalid):

osm=# select st_isvalid(st_geomfromtext('POLYGON((-5.66666 43.53301,-5.66704 43.53335,-5.66931 43.53374,-5.66975299919511 43.533380063154,-5.66979 43.53335,-5.66971 43.53478,-5.66969091189271 43.5348058613067,-5.67026768864541 43.5374211525033,-5.67084666354158 43.5376334432986,-5.67111 43.53773,-5.67059550578171 43.53754135212,-5.66854 43.53971,-5.66854 43.53971,-5.66854 43.53971,-5.66758 43.53976,-5.6665 43.5402,-5.6665 43.5402,-5.66609712188377 43.539781395014,-5.66401 43.54013,-5.66401 43.54013,-5.66351576708437 43.5392869195307,-5.66281 43.53909,-5.6626 43.53851,-5.66159162498075 43.5369268527413,-5.66131 43.53695,-5.66196 43.53617,-5.66272791899155 43.5356642562857,-5.66378432333548 43.5344801289574,-5.66384 43.53414,-5.66452 43.53344,-5.6656 43.53337,-5.66611 43.5331,-5.66666 43.53301))', 4326));
NOTICE:  Self-intersection at or near point -5.6708422794605911 43.537631835802237
 st_isvalid 
------------
 f
(1 row)

A quick and dirty fix (not guaranteed to work) is to use st_buffer to fix your invalid geometries. Postgis returns a result if you do, I haven't checked if it's correct:

select st_astext(
    st_difference(
    st_buffer(st_geomfromtext('POLYGON((-5.66666 43.53301,-5.66704 ...))', 4326), 0), 
    st_buffer(st_geomfromtext('POLYGON((-5.66577 43.53447,-5.66612 ...))', 4326), 0)
));

PostGIS – How to Upgrade PostGIS 2.0 to 2.1 on Windows 7

Have you downloaded the correct file? This might be what you are looking for:

http://winnie.postgis.net/download/windows/pg92/buildbot/postgis-pg92-binaries-2.1.0w32.zip

Or the 64-bit version, of course.

From the README.txt

-- Upgrading extension -- To upgrade an extension, it's just as easy. If you are using PgAdmin, go to the extensions section and the postgis / postgis_topology. Select the version drop down and bump what you have currently to the latest.

Best Answer

Related Solutions

[GIS] How to fix ‘GEOSDifference: TopologyException’

PostGIS – How to Upgrade PostGIS 2.0 to 2.1 on Windows 7

Related Question