Unable to build WKT Raster

[Gilles Bassière-2]

Hi list,

I'd like to try WKT Raster but I have some troubles during install.

My first attempt was to build WKT Raster aginst PostGIS 1.3.5 source
code but the configure script fails because the liblwgeom/ directory
does not exist prior to PostGIS 1.4.0. I tried to create a symlink and
even to rename the directory lwgeom/ to liblwgeom/ but in both case, WKT
Raster don't build:

[...]
In file included from rt_pg.c:42:
pgsql_compat.h:15:1: warning: "SET_VARSIZE" redefined
[...]
rt_pg.c: In function ‘RASTER_lib_version’:
rt_pg.c:239: warning: implicit declaration of function ‘VARATT_SIZEP’
rt_pg.c:239: error: lvalue required as left operand of assignment
rt_pg.c: In function ‘RASTER_lib_build_date’:
rt_pg.c:250: error: lvalue required as left operand of assignment
[...]

Full configure output: http://pastebin.org/49983
Full build output: http://pastebin.org/49982
pg_config output: http://pastebin.org/49984

I've been able to track the problem down to rt_pg/pgsql_compat.h where
SET_VARSIZE seems to be redefined even if my PostgreSQL version is >8.3.
I can't find where/how POSTGIS_PGSQL_VERSION is defined though.

Technical details :
I'm running Ubuntu 9.04, PostgreSQL 8.3.5 comes from package manager,
PostGIS 1.3.5 is an svn checkout and WKT Raster is downloaded from
http://postgis.refractions.net/download/wktraster-0.1.6SVN.tar.gz.

BTW, in configure.ac (l. 414) the error message says "${POSTGIS_SRCDIR}
doesn't contain liblwgeom/liblwgeom.h or lwgeom/liblwgeom.h" which is
misleading, lwgeom/liblwgeom.h did exist in 1.3.5 source tree. I don't
know which of the message or the test should be changed though.

I also tried to build and install PostGIS 1.4.0 but I can't find a way
to do so within my home directory since the --prefix option is now
ignored (bug #160). Of course, I could compile a full PostgreSQL in my
home directory but there might be an easier solution, is there?

Regards

--
Gilles Bassière - MAKINA CORPUS
http://www.makina-corpus.com
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Mateusz Loskot]

Gilles Bassière wrote:
> Hi list,
>
> I'd like to try WKT Raster but I have some troubles during install.
>
> My first attempt was to build WKT Raster aginst PostGIS 1.3.5 source
> code but the configure script fails because the liblwgeom/ directory
> does not exist prior to PostGIS 1.4.0. I tried to create a symlink and
> even to rename the directory lwgeom/ to liblwgeom/ but in both case, WKT
> Raster don't build:

The WKT Raster README file available from
http://trac.osgeo.org/postgis/browser/spike/wktraster/README
says

"latest 1.3.5 release won't work"


> Full configure output: http://pastebin.org/49983
> Full build output: http://pastebin.org/49982
> pg_config output: http://pastebin.org/49984

It will not work. Please, use PostGIS 1.4.0 or recent source code
from trunk in SVN repository

> I also tried to build and install PostGIS 1.4.0 but I can't find a way
> to do so within my home directory since the --prefix option is now
> ignored (bug #160). Of course, I could compile a full PostgreSQL in my
> home directory but there might be an easier solution, is there?

If you want to build PostGIS, you need to compile and install PostGIS
only, no need to compile PostgreSQL.

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Paragon Corporation-2]

Mateusz,
We should probably update the docs here accordingly

http://trac.osgeo.org/postgis/wiki/WKTRaster/Documentation01

This user doc way at the bottom says it works with 1.3.5 or higher and even
points at the 1.3 docs for compilation.

Thanks,
Regina

 

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] On Behalf Of Mateusz
Loskot
Sent: Sunday, November 01, 2009 6:17 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Unable to build WKT Raster

Gilles Bassière wrote:
> Hi list,
>
> I'd like to try WKT Raster but I have some troubles during install.
>
> My first attempt was to build WKT Raster aginst PostGIS 1.3.5 source
> code but the configure script fails because the liblwgeom/ directory
> does not exist prior to PostGIS 1.4.0. I tried to create a symlink and
> even to rename the directory lwgeom/ to liblwgeom/ but in both case,
> WKT Raster don't build:

The WKT Raster README file available from
http://trac.osgeo.org/postgis/browser/spike/wktraster/README
says

"latest 1.3.5 release won't work"


> Full configure output: http://pastebin.org/49983 Full build output:
> http://pastebin.org/49982 pg_config output: http://pastebin.org/49984

It will not work. Please, use PostGIS 1.4.0 or recent source code from trunk
in SVN repository

> I also tried to build and install PostGIS 1.4.0 but I can't find a way
> to do so within my home directory since the --prefix option is now
> ignored (bug #160). Of course, I could compile a full PostgreSQL in my
> home directory but there might be an easier solution, is there?

If you want to build PostGIS, you need to compile and install PostGIS only,
no need to compile PostgreSQL.

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net Charter Member of OSGeo,
http://osgeo.org _______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Mark Cave-Ayland-3]

Gilles Bassière wrote:

> I also tried to build and install PostGIS 1.4.0 but I can't find a way
> to do so within my home directory since the --prefix option is now
> ignored (bug #160). Of course, I could compile a full PostgreSQL in my
> home directory but there might be an easier solution, is there?

PGXS makes use of the DESTDIR variable for installation, so for a
relocated install all you need to do is:

./configure
make DESTDIR=/path/to/output install


HTH,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: [phone]

Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Pierre Racine-2]

There is no technical reason that should prevent WKT Raster of working with any recent version of PostGIS. The doc should not then be changed. If it does not compile it is another story.

If Kevin's trick does the job we can document it.

Pierre

>-----Original Message-----
>From: postgis-users-bounces@... [mailto:postgis-users-
>bounces@...] On Behalf Of Mark Cave-Ayland
>Sent: 2 novembre 2009 08:45
>To: PostGIS Users Discussion
>Subject: Re: [postgis-users] Unable to build WKT Raster
>
>Gilles Bassière wrote:
>
>> I also tried to build and install PostGIS 1.4.0 but I can't find a way
>> to do so within my home directory since the --prefix option is now
>> ignored (bug #160). Of course, I could compile a full PostgreSQL in my
>> home directory but there might be an easier solution, is there?
>
>PGXS makes use of the DESTDIR variable for installation, so for a
>relocated install all you need to do is:
>
>./configure
>make DESTDIR=/path/to/output install
>
>
>HTH,
>
>Mark.
>
>--
>Mark Cave-Ayland - Senior Technical Architect
>PostgreSQL - PostGIS
>Sirius Corporation plc - control through freedom
>http://www.siriusit.co.uk
>t: [phone]
>
>Sirius Labs: http://www.siriusit.co.uk/labs
>_______________________________________________
>postgis-users mailing list
>postgis-users@...
>http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Mateusz Loskot]

Pierre Racine wrote:
> There is no technical reason that should prevent WKT Raster of
> working with any recent version of PostGIS. The doc should not then
> be changed. If it does not compile it is another story.

Pierre,

I got your point. I've only used WKT Raster with PostGIS from SVN.

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Gilles Bassière-2]

Mark Cave-Ayland wrote:
> PGXS makes use of the DESTDIR variable for installation, so for a
> relocated install all you need to do is:
>
> ./configure
> make DESTDIR=/path/to/output install

Thanks a lot, that information I was missing. PostGIS build just fine now.

When loading PostGIS however I got error because Postgres was not able
to find $libdir/postgis-1.4. Is it caused by forcing custom installation
path at install level?

Since I'm simply setting this up to try out wkt raster, I went for the
quick and dirty way: replacing $libdir by the absolute path to
postgis-1.4.so.

Regards

--
Gilles Bassière - MAKINA CORPUS
http://www.makina-corpus.com
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Gilles Bassière-2]

Mateusz Loskot wrote:
> The WKT Raster README file available from
> http://trac.osgeo.org/postgis/browser/spike/wktraster/README
> says
>
> "latest 1.3.5 release won't work"
>

I've seen this indeed but was confused by other sources of documentation.

In the meantime, I've managed to build PostGIS 1.4 and WKT raster
against it. It seems to work fine except that "make install" try to copy
gdal2wktraster.py directly to postgresql bin dir, ignoring the custom
prefix. Anyway, I copied the file manually and wktraster is now all set up.

I've been able to load an SRTM tile and fetch individual values using
st_value. What I'd like to do is to extract cells having "value > n" and
build a polygon from those. Is this the kind of query wkt raster is
intended to support?

Regards

--
Gilles Bassière - MAKINA CORPUS
http://www.makina-corpus.com
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Pierre Racine-2]

Gilles,

Glad you could build WKT Raster and it's working fine.

In order "to extract cells having "value > n" and build a polygon from those" you would need ST_SelectByValue(raster, ‘expression’) which would return a raster containing only the selected pixels (the others being filled with NODATA values) and then ST_AsPolygon(raster) which will convert every group of contiguous pixel with same value to a polygon.

These two functions are planned but unfortunately not implemented yet. If you can give a hand you are welcome. ST_AsPolygon(raster) is planned to be implemented very soon but not ST_SelectByValue(raster, ‘expression’).

Pierre

>-----Original Message-----
>From: postgis-users-bounces@... [mailto:postgis-users-
>bounces@...] On Behalf Of Gilles Bassière
>Sent: 2 novembre 2009 18:34
>To: PostGIS Users Discussion
>Subject: Re: [postgis-users] Unable to build WKT Raster
>
>Mateusz Loskot wrote:
>> The WKT Raster README file available from
>> http://trac.osgeo.org/postgis/browser/spike/wktraster/README
>> says
>>
>> "latest 1.3.5 release won't work"
>>
>
>I've seen this indeed but was confused by other sources of documentation.
>
>In the meantime, I've managed to build PostGIS 1.4 and WKT raster
>against it. It seems to work fine except that "make install" try to copy
>gdal2wktraster.py directly to postgresql bin dir, ignoring the custom
>prefix. Anyway, I copied the file manually and wktraster is now all set up.
>
>I've been able to load an SRTM tile and fetch individual values using
>st_value. What I'd like to do is to extract cells having "value > n" and
>build a polygon from those. Is this the kind of query wkt raster is
>intended to support?
>
>Regards
>
>--
>Gilles Bassière - MAKINA CORPUS
>http://www.makina-corpus.com
>_______________________________________________
>postgis-users mailing list
>postgis-users@...
>http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users