[postgis-users] Windows Installers for PostGIS 2.0.0 including 64-bit
We have all the installers up on PostGIS site, but before we put it on stack builder (or rather give final okay to push to all deployment servers), we'd appreciate if some others test them or let us know your experiences whether successful or not. We've had some people test and some have run into issues. Some of the issues we have fixed, but we can't test all the permutations of how people have their postgresql configured to be sure it works for all and since we are not running into issues on the servers we've tested on, we can't be sure if these are isolated incidents or not. Case in point -- this one: http://trac.osgeo.org/postgis/ticket/1781 http://www.postgis.org/download/windows/#postgis-installers NOTE: PostGIS 2.0.0 is the first ever version to support PostgreSQL 64-bit (both 9.0 and 9.1) on windows. We'd again like to extend a big thank-you for our windows 64-bit campaign sponsors for making this a reality. Thanks, Leo and Regina http://www.postgis.us http://www.postgresonline.com http://www.bostongis.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] compile win_wkt_parse.y syntax error
I think you'll have to install bison and not use yacc. P. On Wed, Apr 18, 2012 at 1:07 PM, Gold, Jack L (US SSA) wrote: > I’m getting a byacc: e – line 99 of “lwin_wkt_parse.y”, syntax error. The > configuration appears to be correct, but I’m not sure where to go now to > figure out what is going wrong. Below is the bottom of the make dump: > > > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwpsurface.c -o lwpsurface.o >>/dev/null 2>&1 > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwtin.c -o lwtin.o >/dev/null > 2>&1 > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkb.c -fPIC -DPIC -o > .libs/lwout_wkb.o > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwin_wkb.c -fPIC -DPIC -o > .libs/lwin_wkb.o > > /bin/sh ..//libtool --mode=compile gcc -g -O2 -fPIC -DPIC > -I/usr/local/include -c -o lwout_wkt.lo lwout_wkt.c > > byacc lwin_wkt_parse.y > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkb.c -o lwout_wkb.o >>/dev/null 2>&1 > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkt.c -fPIC -DPIC -o > .libs/lwout_wkt.o > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwin_wkb.c -o lwin_wkb.o >>/dev/null 2>&1 > > byacc: e - line 99 of "lwin_wkt_parse.y", syntax error > > %locations > > ^ > > make[1]: *** [lwin_wkt_parse.c] Error 1 > > make[1]: *** Waiting for unfinished jobs > > gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkt.c -o lwout_wkt.o >>/dev/null 2>&1 > > make[1]: Leaving directory > `/home/ciduser/workspace/DB/PostGIS_2.0/postgis-2.0.1SVN/liblwgeom' > > make: *** [all] Error 1 > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] compile win_wkt_parse.y syntax error
I'm getting a byacc: e - line 99 of "lwin_wkt_parse.y", syntax error. The configuration appears to be correct, but I'm not sure where to go now to figure out what is going wrong. Below is the bottom of the make dump: gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwpsurface.c -o lwpsurface.o >/dev/null 2>&1 gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwtin.c -o lwtin.o >/dev/null 2>&1 gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkb.c -fPIC -DPIC -o .libs/lwout_wkb.o gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwin_wkb.c -fPIC -DPIC -o .libs/lwin_wkb.o /bin/sh ..//libtool --mode=compile gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c -o lwout_wkt.lo lwout_wkt.c byacc lwin_wkt_parse.y gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkb.c -o lwout_wkb.o >/dev/null 2>&1 gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkt.c -fPIC -DPIC -o .libs/lwout_wkt.o gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwin_wkb.c -o lwin_wkb.o >/dev/null 2>&1 byacc: e - line 99 of "lwin_wkt_parse.y", syntax error %locations ^ make[1]: *** [lwin_wkt_parse.c] Error 1 make[1]: *** Waiting for unfinished jobs gcc -g -O2 -fPIC -DPIC -I/usr/local/include -c lwout_wkt.c -o lwout_wkt.o >/dev/null 2>&1 make[1]: Leaving directory `/home/ciduser/workspace/DB/PostGIS_2.0/postgis-2.0.1SVN/liblwgeom' make: *** [all] Error 1 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Question about the right installation of postgis 2.0.0
On 18 April 2012 18:12, Giannis Giakoumidakis wrote: > So if I installed it correct, my next question is how I enable Postgis2.0.0 > in PgAdminIII (i have the 1.12.2-1 version). I created a new database with > "template_postgis" but when I ask "select postgis_full_version()" I get > "POSTGIS=1.5.3" so the new Postgis has not been enabled. Can anyone explain > me how i do this or send me a tutorial/documentation? Thanx for the help. > Hi, You have to install Postgis 2.0 on the database you are working on. The template_postgis you see in PgAdmin was probably created during a postgis 1.5 installation. You will find instructions here: http://postgis.org/documentation/manual-2.0/postgis_installation.html#create_new_db Nicolas > > > > From: Sandro Santilli > To: Giannis Giakoumidakis ; PostGIS Users > Discussion > Sent: Tuesday, April 17, 2012 5:00 PM > Subject: Re: [postgis-users] Question about the right installation of > postgis 2.0.0 > > On Tue, Apr 17, 2012 at 06:50:14AM -0700, Giannis Giakoumidakis wrote: >> I have followed the instructions from the manual. I have done the >> "configure" and "make" steps successfully and i got the message "PostGIS was >> built successfully. Ready to install.". But when I make "sudo make install" >> I don't get a message of full or succesfull installation, nor a message of >> mistake. It ends with that: >> >> >> make[2]: Leaving directory >> `/home/user/Desktop/diploma/Tools/Linux/postgis-2.0.0/extensions/postgis_topology' >> make[1]: Leaving directory >> `/home/user/Desktop/diploma/Tools/Linux/postgis-2.0.0/extensions' >> >> >> So I wanted to be sure that I've done the installation right and i won't >> have problems after. Thanks for your advices. > > You should be fine. > > --strk; > > ,--o-. > | __/ | Delivering high quality PostGIS 2.0 ! > | / 2.0 | http://strk.keybit.net - http://vizzuality.com > `-o--' > > > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Question about the right installation of postgis 2.0.0
So if I installed it correct, my next question is how I enable Postgis2.0.0 in PgAdminIII (i have the 1.12.2-1 version). I created a new database with "template_postgis" but when I ask "select postgis_full_version()" I get "POSTGIS=1.5.3" so the new Postgis has not been enabled. Can anyone explain me how i do this or send me a tutorial/documentation? Thanx for the help. From: Sandro Santilli To: Giannis Giakoumidakis ; PostGIS Users Discussion Sent: Tuesday, April 17, 2012 5:00 PM Subject: Re: [postgis-users] Question about the right installation of postgis 2.0.0 On Tue, Apr 17, 2012 at 06:50:14AM -0700, Giannis Giakoumidakis wrote: > I have followed the instructions from the manual. I have done the "configure" > and "make" steps successfully and i got the message "PostGIS was built > successfully. Ready to install.". But when I make "sudo make install" I don't > get a message of full or succesfull installation, nor a message of mistake. > It ends with that: > > > make[2]: Leaving directory > `/home/user/Desktop/diploma/Tools/Linux/postgis-2.0.0/extensions/postgis_topology' > make[1]: Leaving directory > `/home/user/Desktop/diploma/Tools/Linux/postgis-2.0.0/extensions' > > > So I wanted to be sure that I've done the installation right and i won't have > problems after. Thanks for your advices. You should be fine. --strk; ,--o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o--'___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Returning contiguous linestrings
On Wed, Apr 18, 2012 at 03:57:52AM -0700, Bob Pawley wrote: > I have, lets say, eight rows each containing a linestring, that, > when put together forms a closed shape or polygon. > > I can fairly easily detect one of the linestrings in this polygon. > > Since each linestring has a endpoint at (or near) the startpoint of > the next linestring in the polygon, I am wondering if there is a > method of detecting the other linestrings, that forms a closed > polygon, from that one contact. > > From this I would compare the shape to known shapes to identify it. topology.GetRingEdges does the walking around a ring, starting from an edge. You'd have to build the topology first, making sure that endpoints do close. A tolerance >= the max distance between those endpoint might be enough. --strk; ,--o-. | __/ |Delivering high quality PostGIS 2.0 ! | / 2.0 |http://strk.keybit.net - http://vizzuality.com `-o--' ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Returning contiguous linestrings
Hi Nicolas I have, lets say, eight rows each containing a linestring, that, when put together forms a closed shape or polygon. I can fairly easily detect one of the linestrings in this polygon. Since each linestring has a endpoint at (or near) the startpoint of the next linestring in the polygon, I am wondering if there is a method of detecting the other linestrings, that forms a closed polygon, from that one contact. From this I would compare the shape to known shapes to identify it. I have some ideas on how to possibly do this, but, I would rather not invent a function if a suitable one already exists. Bob -Original Message- From: Nicolas Ribot Sent: Wednesday, April 18, 2012 1:03 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Returning contiguous linestrings On 17 April 2012 19:21, Bob Pawley wrote: Hi I have a polygon shape composed of contiguous linestrings inhabiting different rows. Is there a fairly direct procedure for returning the polygon after detecting a single linestring?? Bob Hi Bob, Could you explain a bit further what you want to do, I don't understand. Nicolas ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] intersects (topogeom, topogeom) is too slow
On Wed, Apr 18, 2012 at 11:39:44AM +0200, Jose Carlos Martinez wrote: > >I've asked Regina some time ago to play a bit with an SQL implementation > >of && operator. Theoretically an SQL implementation could be inlined > >and as such could be using indices on the primitive tables. > > You re talking about a functional index? Nope, I was talking about using indices on tables containing the primitives rather than on tables containing the TopoGeometries. > s1=# create index test on suelos using gist (st_envelope(topogeom)); > ERROR: functions in index expression must be marked IMMUTABLE > > Even St_envelope is immutable I think its not working because > converting from topogeom to geometry needs reading for other tables > so it can not be immutable That's the reason for it to not be IMMUTABLE. But I guess it would "work" if you mark it as such. Only you won't have the update index on updated TopoGeometry semantic. An interesting research topic could be about how to notify TopoGeometry objects about changes occurred in the underlying table. We should have all information we need to find the TopoGeometry objects (so we could do a faked UPDATE or something like that to force re-indexing). > I will keep trying to study and to help you if I can. I think > topology is a very attractive field for teaching and researching. Great, looking forward for more contributions :) Beside, since you're looking at ST_Intersection, it may be worth adding a testcase for it as I'm pretty sure it has some unwanted side effects like throwing an exception when passed TopoGeometry objects from different topologies... --strk; ,--o-. | __/ |Delivering high quality PostGIS 2.0 ! | / 2.0 |http://strk.keybit.net - http://vizzuality.com `-o--' ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] intersects (topogeom, topogeom) is too slow
Hi Sandro, thanks for the answer On 18/04/2012 10:35, Sandro Santilli wrote: On Tue, Apr 17, 2012 at 11:00:47PM +0200, Jose Carlos Martinez Llario wrote: Hi, first I wanted to say thanks because Im asking a lot of questions lately and you guys always answer me in a fast and kind way. Sandro you specially must be tired of me. sorry!! :) Not at all. I'm happy that my creation is having a social life ;) now another more question. I found the function intersects (topogeom, topogeom) quite interesting even it is not documented, because I was expecting it to show me the persistent topology performance. I noticed that function too, but it's really something that has _not_ been reviewed in this last year of improvements. So something from 2005. Not regress-tested. Not reviewed for performance. So please don't take it as a proof of what performance you may get, but as an experiment. ok, I understand. Anyways, the code is interesting for learning. - How can we use spatial index with topogeometry layers, making a new box column and keep it synchronized? Why topogeom composite type does not include a box that we can index? This is a good question. It's to be researched upon. I've asked Regina some time ago to play a bit with an SQL implementation of&& operator. Theoretically an SQL implementation could be inlined and as such could be using indices on the primitive tables. You re talking about a functional index? s1=# create index test on suelos using gist (st_envelope(topogeom)); ERROR: functions in index expression must be marked IMMUTABLE Even St_envelope is immutable I think its not working because converting from topogeom to geometry needs reading for other tables so it can not be immutable Maintaining an index on TopoGeometry objects themeselves would not easily be done automatically because the index would need to be updated every time the primitives change. You can generally think of it as cache maintainance. Which in turn raises the question of how big should the link be between knwon TopoGeometry objects (those found in the topo.relation table) and deployed ones (those actually found in the tables reported as being the deploy tables for the given TopoGeometry layers). Lots of interesting tasks on the road ahead :) - The topogeom composite type is using indexes with its fields? I don't understand this question, but the answer sounds like being NO. - Why its taking more time that geometry types if it should have opposite behavior? I/O costs ? Prepared geometries ? Go figure... For sure there are more queries involved for each pair of geometries being compared. I bet your use case might be implemented using a completely different path to optimize those queries (something that an ST_Intersects override couldn't possibly do, not having visibility of the whole input you're willing to consider). I will keep trying to study and to help you if I can. I think topology is a very attractive field for teaching and researching. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] configure error: could not find gdal
Thanks Mike I could solve it with your help: I've checked my postgis config.log and found this: /usr/bin/ld: warning: libpq.so.5, needed by /usr/local/lib/libgdal.so, not found (try using -rpath or -rpath-link) I had installed postgres 9.1.3 from sources in /usr/local/pgsql and the symlinks libpq.so.* are in /usr/local/pgsql/lib So I added that directory to ld.so.conf, run ldconfig and the ./configure of postgis passed. It's odd I never had to do that in my previous postgres installs. I'll keep that in mind from now on. Thanks a lot for your help. Simon 2012/4/18 Mike Toews > Here is one of the issues with GDALAllRegister: > > http://postgis.refractions.net/pipermail/postgis-users/2012-March/033043.html > > Do you remember the details of building GDAL? What version of GEOS do > you have, and did you also install it from source for GDAL? > > $ geos-config --prefix > $ geos-config --version > > -Mike > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] configure error: could not find gdal
Here is one of the issues with GDALAllRegister: http://postgis.refractions.net/pipermail/postgis-users/2012-March/033043.html Do you remember the details of building GDAL? What version of GEOS do you have, and did you also install it from source for GDAL? $ geos-config --prefix $ geos-config --version -Mike ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] configure error: could not find gdal
On 18 April 2012 20:32, Simon Ortet wrote: > I'm running a Debian 6.0.4 64bits. > GDAL is installed from source and gdal-config is in the path. A "gdal-config > --version" command returns "1.9.0" Oh sorry, missed that. I've seen other issues with GDALAllRegister, so you aren't alone ... -Mike ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] configure error: could not find gdal
Thanks for your answer Mike, I would definitely prefer to have my postgis with raster support. Now i'm not sure why I'd need to install the libgdal-dev package (which is version 1.6 on debian squeeze) when I've already built and installed gdal 1.9 from source. I never had to install that package when installing previous postgis versions. Thanks Simon 2012/4/18 Mike Toews > On 18 April 2012 20:32, Simon Ortet wrote: > > Hi, > > > > I'm trying to install postgis 2.0 from source and I get this error when > > running "./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config": > > > > RASTER: Raster support requested > > checking for GDAL >= 1.6.0... found > > checking gdal.h usability... yes > > checking gdal.h presence... yes > > checking for gdal.h... yes > > checking ogr_api.h usability... yes > > checking ogr_api.h presence... yes > > checking for ogr_api.h... yes > > checking cpl_conv.h usability... yes > > checking cpl_conv.h presence... yes > > checking for cpl_conv.h... yes > > checking for library containing GDALAllRegister... no > > configure: error: could not find gdal > > > > I tried with "--with-gdalconfig=/usr/local/bin/gdal-config" parameter as > > well (although /usr/local/bin is in the path anyways) with the same > result. > > > > I'm running a Debian 6.0.4 64bits. > > GDAL is installed from source and gdal-config is in the path. A > "gdal-config > > --version" command returns "1.9.0" > > > > Could it be that my gdal is missing something? Any idea? > > Your two options is to install GDAL: > > sudo apt-get install libgdal-dev > > Or configure without gdal: > > ./configure --without-raster > > -Mike > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] intersects (topogeom, topogeom) is too slow
On Tue, Apr 17, 2012 at 11:00:47PM +0200, Jose Carlos Martinez Llario wrote: > Hi, > first I wanted to say thanks because Im asking a lot of questions > lately and you guys always answer me in a fast and kind way. Sandro > you specially must be tired of me. sorry!! :) Not at all. I'm happy that my creation is having a social life ;) > now another more question. > > I found the function intersects (topogeom, topogeom) quite > interesting even it is not documented, because I was expecting it to > show me the persistent topology performance. I noticed that function too, but it's really something that has _not_ been reviewed in this last year of improvements. So something from 2005. Not regress-tested. Not reviewed for performance. So please don't take it as a proof of what performance you may get, but as an experiment. > - How can we use spatial index with topogeometry layers, making a > new box column and keep it synchronized? Why topogeom composite type > does not include a box that we can index? This is a good question. It's to be researched upon. I've asked Regina some time ago to play a bit with an SQL implementation of && operator. Theoretically an SQL implementation could be inlined and as such could be using indices on the primitive tables. Maintaining an index on TopoGeometry objects themeselves would not easily be done automatically because the index would need to be updated every time the primitives change. You can generally think of it as cache maintainance. Which in turn raises the question of how big should the link be between knwon TopoGeometry objects (those found in the topo.relation table) and deployed ones (those actually found in the tables reported as being the deploy tables for the given TopoGeometry layers). Lots of interesting tasks on the road ahead :) > - The topogeom composite type is using indexes with its fields? I don't understand this question, but the answer sounds like being NO. > - Why its taking more time that geometry types if it should have > opposite behavior? I/O costs ? Prepared geometries ? Go figure... For sure there are more queries involved for each pair of geometries being compared. I bet your use case might be implemented using a completely different path to optimize those queries (something that an ST_Intersects override couldn't possibly do, not having visibility of the whole input you're willing to consider). --strk; ,--o-. | __/ |Delivering high quality PostGIS 2.0 ! | / 2.0 |http://strk.keybit.net - http://vizzuality.com `-o--' ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] configure error: could not find gdal
On 18 April 2012 20:32, Simon Ortet wrote: > Hi, > > I'm trying to install postgis 2.0 from source and I get this error when > running "./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config": > > RASTER: Raster support requested > checking for GDAL >= 1.6.0... found > checking gdal.h usability... yes > checking gdal.h presence... yes > checking for gdal.h... yes > checking ogr_api.h usability... yes > checking ogr_api.h presence... yes > checking for ogr_api.h... yes > checking cpl_conv.h usability... yes > checking cpl_conv.h presence... yes > checking for cpl_conv.h... yes > checking for library containing GDALAllRegister... no > configure: error: could not find gdal > > I tried with "--with-gdalconfig=/usr/local/bin/gdal-config" parameter as > well (although /usr/local/bin is in the path anyways) with the same result. > > I'm running a Debian 6.0.4 64bits. > GDAL is installed from source and gdal-config is in the path. A "gdal-config > --version" command returns "1.9.0" > > Could it be that my gdal is missing something? Any idea? Your two options is to install GDAL: sudo apt-get install libgdal-dev Or configure without gdal: ./configure --without-raster -Mike ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] configure error: could not find gdal
Hi, I'm trying to install postgis 2.0 from source and I get this error when running "./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config": RASTER: Raster support requested checking for GDAL >= 1.6.0... found checking gdal.h usability... yes checking gdal.h presence... yes checking for gdal.h... yes checking ogr_api.h usability... yes checking ogr_api.h presence... yes checking for ogr_api.h... yes checking cpl_conv.h usability... yes checking cpl_conv.h presence... yes checking for cpl_conv.h... yes *checking for library containing GDALAllRegister... no* *configure: error: could not find gdal* * * I tried with "--with-gdalconfig=/usr/local/bin/gdal-config" parameter as well (although /usr/local/bin is in the path anyways) with the same result. I'm running a Debian 6.0.4 64bits. GDAL is installed from source and gdal-config is in the path. A "gdal-config --version" command returns "1.9.0" Could it be that my gdal is missing something? Any idea? Thanks Simon ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Returning contiguous linestrings
On 17 April 2012 19:21, Bob Pawley wrote: > Hi > > I have a polygon shape composed of contiguous linestrings inhabiting > different rows. > > Is there a fairly direct procedure for returning the polygon after detecting > a single linestring?? > > Bob > Hi Bob, Could you explain a bit further what you want to do, I don't understand. Nicolas ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users