Re: [postgis-users] Topology performance test
2012/6/21 Sandro Santilli s...@keybit.net: On Thu, Jun 21, 2012 at 06:12:15PM +0200, Stefano Iacovella wrote: Sandro, I run $:~/sources/geos-3.3.3$sudo make uninstall then stefano@ubuntu1204vm:~/sources/geos-3.3.3$ ll /usr/local/lib/ ... drwxr-xr-x 2 root root 4096 Apr 27 16:10 geos/ -rwxr-xr-x 1 root root 15504429 Apr 27 16:10 libgeos-3.3.3.so* -rwxr-xr-x 1 root root 866246 Apr 27 16:10 libgeos_c.so.1.7.4* ... Should make uninstall delete the two libgeos file? Unless you configured the build to have a different prefix. No I didn't I installed 3.3.3 by ./configure make sudo make install sudo ldconfig make clean Before dealing with 3.3.4 I tried to delete the two files and install again 3.3.3 with ./configure make sudo make install sudo ldconfig then ll /usr/local/lib stefano@ubuntu1204vm:~/sources/geos-3.3.3$ ll /usr/local/lib total 50624 drwxr-xr-x 5 root root 4096 Jun 22 08:57 ./ drwxr-xr-x 11 root root 4096 May 2 14:38 ../ drwxr-xr-x 2 root root 4096 Apr 27 16:10 geos/ -rwxr-xr-x 1 root root 15504429 Jun 22 08:57 libgeos-3.3.3.so* -rw-r--r-- 1 root root 31419116 Jun 22 08:57 libgeos.a -rw-r--r-- 1 root root 1238562 Jun 22 08:57 libgeos_c.a -rwxr-xr-x 1 root root 957 Jun 22 08:57 libgeos_c.la* lrwxrwxrwx 1 root root18 Jun 22 08:57 libgeos_c.so - libgeos_c.so.1.7.4* lrwxrwxrwx 1 root root18 Jun 22 08:57 libgeos_c.so.1 - libgeos_c.so.1.7.4* -rwxr-xr-x 1 root root866246 Jun 22 08:57 libgeos_c.so.1.7.4* -rwxr-xr-x 1 root root 925 Jun 22 08:57 libgeos.la* lrwxrwxrwx 1 root root16 Jun 22 08:57 libgeos.so - libgeos-3.3.3.so* And running sudo make uninstall deleted all the files in /usr/local/lib (uhm geos related files I mean :) ) So there is no issue at all but for the sake of my understanding I wonder if there was some link to the geos library preventing make from uninstall them? thank you very much for your help Cheers Stefano It is safe if I delete them and then install geos-3.3.4? Yes. --strk; ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users --- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Topology performance test
Sandro, after installing geos-3.3.4 I saw a strange, to my understanding, libgeos_c version lrwxrwxrwx 1 root root18 Jun 22 09:38 libgeos_c.so - libgeos_c.so.1.7.3* lrwxrwxrwx 1 root root18 Jun 22 09:38 libgeos_c.so.1 - libgeos_c.so.1.7.3* -rwxr-xr-x 1 root root851276 Jun 22 09:38 libgeos_c.so.1.7.3* while geos-3.3.3 produced libgeos_c.so.1.7.4 Is this expected? Cheers Stefano ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Topology performance test
On 06/22/2012 11:16 AM, Luca Morandini wrote: ...but, still: select postgis_full_version(); POSTGIS=2.1.0SVN r9949 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.7.1, 23 September 2009 LIBXML=2.7.6 TOPOLOGY (1 row) PostGIS kept on looking for libgeos-3.3.3.so under /usr/lib, hence I added a symbolic link there - and in /usr/local/lib, for good measure - to 3.3.4 instead. Still no joy: select postgis_full_version(); POSTGIS=2.1.0SVN r9949 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.7.1, 23 September 2009 LIBXML=2.7.6 TOPOLOGY I did not install raster support, but this should be an issue. Regards, Luca Morandini Data Architect - AURIN project Department of Computing and Information Systems University of Melbourne Tel. +61 03 903 58 380 Skype: lmorandini ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] ST_Centroid error on very small polygon
Hi List, I cannot find answer to this phenomenon: When I do this select on a very small polygon made of 3 points I get an empty collection: VT=# select ST_AsText(ST_Centroid(ST_GeomFromText('POLYGON((56.528667 25.210167,56.529 25.2105,56.528833 25.210333,56.528667 25.210167))'))); st_astext -- GEOMETRYCOLLECTION EMPTY (1 row) If I modify one value just a little bit (56.529=56.5291) I get correct results: VT=# select ST_AsText(ST_Centroid(ST_GeomFromText('POLYGON((56.528667 25.210167,56.5291 25.2105,56.528833 25.210333,56.528667 25.210167))'))); st_astext -- POINT(56.52887 25.21033) (1 row) Any of you seen such thing? Thank you very much for your help! Csaba Versions: POSTGIS=1.5.2 GEOS=3.2.2-CAPI-1.6.2 PROJ=Rel. 4.7.1, 23 September 2009 LIBXML=2.7.6 USE_STATS PostgreSQL 8.4.11 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit -- Sándor Csaba szolgáltatási vezető ViaMap Kft. Székhely/postacím: 2176 Erdőkürt, Téglaház utca 4. Iroda: 1076 Budapest, Garay u. 29-31. I. 1. (EMLA Környezeti Management és Jog Egyesület) Tel: +3630/9605853 Fax: +3617002542 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Topology performance test
On Fri, Jun 22, 2012 at 09:52:04AM +0200, Stefano Iacovella wrote: Sandro, after installing geos-3.3.4 I saw a strange, to my understanding, libgeos_c version lrwxrwxrwx 1 root root18 Jun 22 09:38 libgeos_c.so - libgeos_c.so.1.7.3* lrwxrwxrwx 1 root root18 Jun 22 09:38 libgeos_c.so.1 - libgeos_c.so.1.7.3* -rwxr-xr-x 1 root root851276 Jun 22 09:38 libgeos_c.so.1.7.3* while geos-3.3.3 produced libgeos_c.so.1.7.4 Is this expected? Not at all ! Congratulations, you found a bug ! Ouch, it hurts pretty much. Time to push a 3.3.5 to fix this mess. Could you please file a ticket for this ? I'll go trough all versions in the 3.3 series to verify what happened. If 3.3.3 installed 1.7.4 I'd expect 3.3.2 to install 1.7.3 and 3.3.4 to install 1.7.5 ... --strk; Sent from our free software http://www.gnu.org/philosophy/free-sw.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ST_Centroid error on very small polygon
On Fri, Jun 22, 2012 at 11:39:52AM +0200, Sandor Csaba wrote: VT=# select ST_AsText(ST_Centroid(ST_GeomFromText('POLYGON((56.528667 25.210167,56.529 25.2105,56.528833 25.210333,56.528667 25.210167))'))); st_astext -- GEOMETRYCOLLECTION EMPTY (1 row) ... Any of you seen such thing? I can reproduce this. The polygon is valid. Definitely a bug. Could you file a ticket please ? --strk; Sent from our free software http://www.gnu.org/philosophy/free-sw.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Topology performance test
On Fri, Jun 22, 2012 at 12:27:48PM +0200, Sandro Santilli wrote: On Fri, Jun 22, 2012 at 09:52:04AM +0200, Stefano Iacovella wrote: Sandro, after installing geos-3.3.4 I saw a strange, to my understanding, libgeos_c version lrwxrwxrwx 1 root root18 Jun 22 09:38 libgeos_c.so - libgeos_c.so.1.7.3* lrwxrwxrwx 1 root root18 Jun 22 09:38 libgeos_c.so.1 - libgeos_c.so.1.7.3* -rwxr-xr-x 1 root root851276 Jun 22 09:38 libgeos_c.so.1.7.3* while geos-3.3.3 produced libgeos_c.so.1.7.4 Is this expected? Not at all ! Congratulations, you found a bug ! Ouch, it hurts pretty much. Time to push a 3.3.5 to fix this mess. Could you please file a ticket for this ? I did: http://trac.osgeo.org/geos/ticket/558 Working on closing up a 3.3.5 to fix this. --strk; Sent from our free software http://www.gnu.org/philosophy/free-sw.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Topology performance test
2012/6/22 Sandro Santilli s...@keybit.net: On Fri, Jun 22, 2012 at 12:27:48PM +0200, Sandro Santilli wrote: On Fri, Jun 22, 2012 at 09:52:04AM +0200, Stefano Iacovella wrote: Sandro, after installing geos-3.3.4 I saw a strange, to my understanding, libgeos_c version lrwxrwxrwx 1 root root 18 Jun 22 09:38 libgeos_c.so - libgeos_c.so.1.7.3* lrwxrwxrwx 1 root root 18 Jun 22 09:38 libgeos_c.so.1 - libgeos_c.so.1.7.3* -rwxr-xr-x 1 root root 851276 Jun 22 09:38 libgeos_c.so.1.7.3* while geos-3.3.3 produced libgeos_c.so.1.7.4 Is this expected? Not at all ! Congratulations, you found a bug ! Ouch, it hurts pretty much. Time to push a 3.3.5 to fix this mess. Could you please file a ticket for this ? I did: http://trac.osgeo.org/geos/ticket/558 Working on closing up a 3.3.5 to fix this. --strk; Sorry Sandro, I read it only now. Thanks for your support and my congratulations for the wonderful work you all do on geos and PostGIS. Cheers Stefano ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Topology performance test
Big thank to you all guys! Csaba On 22 June 2012 13:40, Stefano Iacovella stefano.iacove...@gmail.com wrote: 2012/6/22 Sandro Santilli s...@keybit.net: On Fri, Jun 22, 2012 at 12:27:48PM +0200, Sandro Santilli wrote: On Fri, Jun 22, 2012 at 09:52:04AM +0200, Stefano Iacovella wrote: Sandro, after installing geos-3.3.4 I saw a strange, to my understanding, libgeos_c version lrwxrwxrwx 1 root root 18 Jun 22 09:38 libgeos_c.so - libgeos_c.so.1.7.3* lrwxrwxrwx 1 root root 18 Jun 22 09:38 libgeos_c.so.1 - libgeos_c.so.1.7.3* -rwxr-xr-x 1 root root 851276 Jun 22 09:38 libgeos_c.so.1.7.3* while geos-3.3.3 produced libgeos_c.so.1.7.4 Is this expected? Not at all ! Congratulations, you found a bug ! Ouch, it hurts pretty much. Time to push a 3.3.5 to fix this mess. Could you please file a ticket for this ? I did: http://trac.osgeo.org/geos/ticket/558 Working on closing up a 3.3.5 to fix this. --strk; Sorry Sandro, I read it only now. Thanks for your support and my congratulations for the wonderful work you all do on geos and PostGIS. Cheers Stefano ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Sándor Csaba szolgáltatási vezető ViaMap Kft. Székhely/postacím: 2176 Erdőkürt, Téglaház utca 4. Iroda: 1076 Budapest, Garay u. 29-31. I. 1. (EMLA Környezeti Management és Jog Egyesület) Tel: +3630/9605853 Fax: +3617002542 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ST_Centroid error on very small polygon
Sorry for mixing threads up in the conversation. I will try to file the ticket Csaba On 22 June 2012 12:30, Sandro Santilli s...@keybit.net wrote: On Fri, Jun 22, 2012 at 11:39:52AM +0200, Sandor Csaba wrote: VT=# select ST_AsText(ST_Centroid(ST_GeomFromText('POLYGON((56.528667 25.210167,56.529 25.2105,56.528833 25.210333,56.528667 25.210167))'))); st_astext -- GEOMETRYCOLLECTION EMPTY (1 row) ... Any of you seen such thing? I can reproduce this. The polygon is valid. Definitely a bug. Could you file a ticket please ? --strk; Sent from our free software http://www.gnu.org/philosophy/free-sw.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Sándor Csaba szolgáltatási vezető ViaMap Kft. Székhely/postacím: 2176 Erdőkürt, Téglaház utca 4. Iroda: 1076 Budapest, Garay u. 29-31. I. 1. (EMLA Környezeti Management és Jog Egyesület) Tel: +3630/9605853 Fax: +3617002542 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] st_aspng and blob image
Hello everybody. I have some problems with st_aspng and st_asraster. I would try to generate a raster image from a vector polygon and view this with a php script. Following the example in the postgis documentation: SELECT ST_AsPNG(ST_AsRaster(ST_Buffer(ST_Point(1,5),10),150, 150, '2BUI')); this generate a binary sequence (blob) but when I try to view it in a web browser I obtain the follow error message Warning: imagecreatefromstring() [function.imagecreatefromstring]: Data is not in a recognized format This is my script: header('Content-Type: image/png'); $query_finale=SELECT ST_AsPNG(ST_AsRaster(ST_Buffer(ST_Point(1,5),10),10, 10, '2BUI')); $finale_result_raster=pg_query($conn,$query_finale); $final_result= pg_query($conn,$query_finale); $img_raster=pg_fetch_array($final_result); $immagine=$img_raster['immagine']; imagepng($immagine); does anyone know why it doesn't work? Thanks!!! Francesco ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] st_aspng and blob image
I can't comment specifically about the imagecreatefromstring() function but you could try the code provided at: http://www.bostongis.com/blog/index.php?/archives/175-Minimalist-Web-based-PHP-PostGIS-2.0-Spatial-GaeometryRaster-Viewer.html -bborie On Fri, Jun 22, 2012 at 8:06 AM, Francesco Geri francescog...@yahoo.it wrote: Hello everybody. I have some problems with st_aspng and st_asraster. I would try to generate a raster image from a vector polygon and view this with a php script. Following the example in the postgis documentation: SELECT ST_AsPNG(ST_AsRaster(ST_Buffer(ST_Point(1,5),10),150, 150, '2BUI')); this generate a binary sequence (blob) but when I try to view it in a web browser I obtain the follow error message Warning: imagecreatefromstring() [function.imagecreatefromstring]: Data is not in a recognized format This is my script: header('Content-Type: image/png'); $query_finale=SELECT ST_AsPNG(ST_AsRaster(ST_Buffer(ST_Point(1,5),10),10, 10, '2BUI')); $finale_result_raster=pg_query($conn,$query_finale); $final_result= pg_query($conn,$query_finale); $img_raster=pg_fetch_array($final_result); $immagine=$img_raster['immagine']; imagepng($immagine); does anyone know why it doesn't work? Thanks!!! Francesco ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Problem compiling PostGIS2.0 with GEOS 1.3.3+
Compiling PostGIS 2.0.0 will break down when the file liblwgeom.h is not included from the PostGIS distribution, but from the installed GEOS includes. This happens when the include path to the gcc compiler first explicitly specifies the standard include directories (/usr/include etc), and only afterwards the specific PostGIS include directories, like -I/usr/local/include -I../libwgeom. The problem is that the file liblwgeom.h exists both in the GEOS distribution and in the PostGIS source. Things are defined differently im both versions, i.e. a struct BOX3D with and without a srid member. I solved the problem by changing #include liblwgeom.h into #include ../liblwgeom.h in all C-files in the postgis subdirectory. Another way would be to change the compile setup in configure. Best would be, of course, to either synchronize both liblwgeom.h files, or rename the PostGIS version. The way it now is organised is asking for trouble. Cheers, Jan ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS 2.0.1 Released
The latest PostGIS release is a bug fix release, including a large number of minor issues reported since the release of 2.0.0. http://postgis.org/download/postgis-2.0.1.tar.gz Use and enjoy! * Bug Fixes * - #1264, fix st_dwithin(geog, geog, 0). - #1468 shp2pgsql-gui table column schema get shifted - #1694, fix building with clang. (vince) - #1708, improve restore of pre-PostGIS 2.0 backups. - #1714, more robust handling of high topology tolerance. - #1755, ST_GeographyFromText support for higher dimensions. - #1759, loading transformed shapefiles in raster enabled db. - #1761, handling of subdatasets in NetCDF, HDF4 and HDF5 in raster2pgsql. - #1763, topology.toTopoGeom use with custom search_path. - #1766, don't let ST_RemEdge* destroy peripheral TopoGeometry objects. - #1774, Clearer error on setting an edge geometry to an invalid one. - #1775, ST_ChangeEdgeGeom collision detection with 2-vertex target. - #1776, fix ST_SymDifference(empty, geom) to return geom. - #1779, install SQL comment files. - #1782, fix spatial reference string handling in raster. - #1789, fix false edge-node crossing report in ValidateTopology. - #1790, fix toTopoGeom handling of duplicated primitives. - #1791, fix ST_Azimuth with very close but distinct points. - #1797, fix (ValidateTopology(xxx)).* syntax calls. - #1805, put back the 900913 SRID entry. - #1813, Only show readable relations in metadata tables. - #1819, fix floating point issues with ST_World2RasterCoord and ST_Raster2WorldCoord variants. - #1820 compilation on 9.2beta1. - #1822, topology load on PostgreSQL 9.2beta1. - #1825, fix prepared geometry cache lookup - #1829, fix uninitialized read in GeoJSON parser - #1834, revise postgis extension to only backup user specified spatial_ref_sys - #1839, handling of subdatasets in GeoTIFF in raster2pgsql. - #1840, fix logic of when to compute # of tiles in raster2pgsql. - #1851, fix spatial_ref_system parameters for EPSG:3844 - #1857, fix failure to detect endpoint mismatch in ST_AddEdge*Face* - #1865, data loss in postgis_restore.pl when data rows have leading dashes. - #1867, catch invalid topology name passed to topogeo_add* - #1870, align the docs and actual behavior of raster's ST_Intersects - #1872, fix ST_ApproxSummarystats to prevent division by zero - #1873, fix ptarray_locate_point to return interpolated Z/M values for on-the-line case - #1875, ST_SummaryStats returns NULL for all parameters except count when count is zero * Enhancements * - More detailed exception message from topology editing functions. - #1786, improved build dependencies - #1806, speedup of ST_BuildArea, ST_MakeValid and ST_GetFaceGeometry. - #1812, Add lwgeom_normalize in LIBLWGEOM for more stable testing. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2.0.1 Released
On 06/23/2012 12:20 AM, Paul Ramsey wrote: The latest PostGIS release is a bug fix release, including a large number of minor issues reported since the release of 2.0.0. http://postgis.org/download/postgis-2.0.1.tar.gz Use and enjoy! * Bug Fixes * - #1264, fix st_dwithin(geog, geog, 0). - #1468 shp2pgsql-gui table column schema get shifted - #1694, fix building with clang. (vince) - #1708, improve restore of pre-PostGIS 2.0 backups. - #1714, more robust handling of high topology tolerance. - #1755, ST_GeographyFromText support for higher dimensions. - #1759, loading transformed shapefiles in raster enabled db. - #1761, handling of subdatasets in NetCDF, HDF4 and HDF5 in raster2pgsql. - #1763, topology.toTopoGeom use with custom search_path. - #1766, don't let ST_RemEdge* destroy peripheral TopoGeometry objects. - #1774, Clearer error on setting an edge geometry to an invalid one. - #1775, ST_ChangeEdgeGeom collision detection with 2-vertex target. - #1776, fix ST_SymDifference(empty, geom) to return geom. - #1779, install SQL comment files. - #1782, fix spatial reference string handling in raster. - #1789, fix false edge-node crossing report in ValidateTopology. - #1790, fix toTopoGeom handling of duplicated primitives. - #1791, fix ST_Azimuth with very close but distinct points. - #1797, fix (ValidateTopology(xxx)).* syntax calls. - #1805, put back the 900913 SRID entry. - #1813, Only show readable relations in metadata tables. - #1819, fix floating point issues with ST_World2RasterCoord and ST_Raster2WorldCoord variants. - #1820 compilation on 9.2beta1. - #1822, topology load on PostgreSQL 9.2beta1. - #1825, fix prepared geometry cache lookup - #1829, fix uninitialized read in GeoJSON parser - #1834, revise postgis extension to only backup user specified spatial_ref_sys - #1839, handling of subdatasets in GeoTIFF in raster2pgsql. - #1840, fix logic of when to compute # of tiles in raster2pgsql. - #1851, fix spatial_ref_system parameters for EPSG:3844 - #1857, fix failure to detect endpoint mismatch in ST_AddEdge*Face* - #1865, data loss in postgis_restore.pl when data rows have leading dashes. - #1867, catch invalid topology name passed to topogeo_add* - #1870, align the docs and actual behavior of raster's ST_Intersects - #1872, fix ST_ApproxSummarystats to prevent division by zero - #1873, fix ptarray_locate_point to return interpolated Z/M values for on-the-line case - #1875, ST_SummaryStats returns NULL for all parameters except count when count is zero * Enhancements * - More detailed exception message from topology editing functions. - #1786, improved build dependencies - #1806, speedup of ST_BuildArea, ST_MakeValid and ST_GetFaceGeometry. - #1812, Add lwgeom_normalize in LIBLWGEOM for more stable testing. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Thank you Paul, I am pushing this to openSUSE repository right now. Best regards, Angelos -- Angelos Tzotsos Remote Sensing Laboratory National Technical University of Athens http://users.ntua.gr/tzotsos ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Problem compiling PostGIS2.0 with GEOS 1.3.3+
On Fri, Jun 22, 2012 at 09:27:59PM +0200, Jan Hartmann wrote: Compiling PostGIS 2.0.0 will break down when the file liblwgeom.h is not included from the PostGIS distribution, but from the installed GEOS includes. This happens when the include path to the gcc compiler first explicitly specifies the standard include directories (/usr/include etc), and only afterwards the specific PostGIS include directories, like -I/usr/local/include -I../libwgeom. The problem is that the file liblwgeom.h exists both in the GEOS distribution and in the PostGIS source. Things are defined differently im both versions, i.e. a struct BOX3D with and without a srid member. There's no liblwgeom.h in GEOS, as far as I know. Maybe you refer to a previous installation of PostGIS ? --strk; Sent from our free software http://www.gnu.org/philosophy/free-sw.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users