<div dir="ltr">I tried the query that Remi suggested (thank you!) and it works and doesn't work. I have the exact same table in two different projections (2230, 4326). When I run the ST_Dwithin query against the 2230 table, I get results in under 100 ms. When I run the same query against the 4326 projection it still takes around 270 seconds! I have confirmed that I have the gist index on the 4326 table. Any ideas why the 4326 projection would be dramatically slower?</div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jul 9, 2014 at 12:00 PM, <span dir="ltr"><<a href="mailto:postgis-users-request@lists.osgeo.org" target="_blank">postgis-users-request@lists.osgeo.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send postgis-users mailing list submissions to<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:postgis-users-owner@lists.osgeo.org">postgis-users-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of postgis-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Error with Ubuntu installation from PostgreSQL APT repository<br>
(Matthew Baker)<br>
2. Re: Error with Ubuntu installation from PostgreSQL APT<br>
repository (Stephen V. Mather)<br>
3. Finding records withing XX distance from a geometry in the<br>
same table (Alexander W. Rolek)<br>
4. Re: Finding records withing XX distance from a geometry in<br>
the same table (Guido Lemoine)<br>
5. Re: Finding records withing XX distance from a geometry in<br>
the same table (R?mi Cura)<br>
6. Re: Finding records withing XX distance from a geometry in<br>
the same table (tommaso)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 08 Jul 2014 16:44:28 -0600<br>
From: Matthew Baker <<a href="mailto:mattbaker@gmail.com">mattbaker@gmail.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
Subject: [postgis-users] Error with Ubuntu installation from<br>
PostgreSQL APT repository<br>
Message-ID: <<a href="mailto:53BC744C.7040004@gmail.com">53BC744C.7040004@gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"<br>
<br>
Hi all,<br>
<br>
Last year I wrote up some PostGIS installation instructions for Ubuntu<br>
based on the PostgreSQL APT repository:<br>
<br>
<a href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt" target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt</a><br>
<br>
These worked great for a while, but seems to have stopped working with<br>
Ubuntu 14.04.<br>
<br>
I know there was a thread back at the end of January discussing the<br>
version of GDAL that would work with PostGIS (1.9 / 1.10) , but if<br>
nothing else, here's an update on the installation error messages:<br>
<br>
--When running this on a fresh Ubuntu 14.04 VM - with no QGIS installed<br>
(thanks Stephen), here are the messages that I get:<br>
<br>
After running this command:<br>
<br>
*sudo apt-get install postgresql-9.3 postgresql-9.3-postgis pgadmin3<br>
postgresql-contrib*<br>
<br>
I get the message:<br>
<br>
/Package postgresql-9.3-postgis is not available, but is referred to by<br>
another package.//<br>
//This may mean that the package is missing, has been obsoleted, or//<br>
//is only available from another source//<br>
//<br>
//E: Package 'postgresql-9.3-postgis' has no installation candidate/<br>
<br>
So I modified the install command specific to PostGIS:<br>
<br>
*sudo apt-get install postgresql-9.3 /postgis /pgadmin3 postgresql-contrib *<br>
<br>
Which gives the message:<br>
<br>
/Some packages could not be installed. This may mean that you have//<br>
//requested an impossible situation or if you are using the unstable//<br>
//distribution that some required packages have not yet been created//<br>
//or been moved out of Incoming.//<br>
//The following information may help to resolve the situation://<br>
//<br>
//The following packages have unmet dependencies://<br>
// postgis : Depends: libgdal1 (>= 1.9.0) but it is not going to be<br>
installed//<br>
//E: Unable to correct problems, you have held broken packages.//<br>
/<br>
So I tried to install libgdal1 v 1.10.0 via Synaptic Package Manager,<br>
but it doesn't seem to help.<br>
<br>
That's where I'm stuck.<br>
<br>
Does anyone have any info either regarding this error, or if the<br>
PostgreSQL APT repo is still packaging PostGIS?<br>
<br>
I will try this on Ubuntu 12.04.4 just for fun...<br>
<br>
I appreciate any feedback! Thank you!!!<br>
<br>
-m<br>
<br>
<br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20140708/0b24d96a/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20140708/0b24d96a/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Tue, 8 Jul 2014 23:40:33 +0000<br>
From: "Stephen V. Mather" <<a href="mailto:svm@clevelandmetroparks.com">svm@clevelandmetroparks.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] Error with Ubuntu installation from<br>
PostgreSQL APT repository<br>
Message-ID:<br>
<<a href="mailto:c53f89f0a2e24579ac8036a3059c1c08@DM2PR05MB734.namprd05.prod.outlook.com">c53f89f0a2e24579ac8036a3059c1c08@DM2PR05MB734.namprd05.prod.outlook.com</a>><br>
<br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Related, I started last night with a fork of vpicavet's docker/pggis as a fresh installer for PostGIS and friends for Ubuntu 14.4. It's not fully functional yet but serves as a sign post for installs on Ubuntu.<br>
<br>
Where would one start in doing package management for Debian / Ubuntu? Seems an ongoing issue for these flavors...<br>
<br>
<a href="https://github.com/smathermather/labr-pdal/blob/master/bootstrap.sh" target="_blank">https://github.com/smathermather/labr-pdal/blob/master/bootstrap.sh</a><br>
<br>
On Jul 8, 2014 6:44 PM, Matthew Baker <<a href="mailto:mattbaker@gmail.com">mattbaker@gmail.com</a>> wrote:<br>
Hi all,<br>
<br>
Last year I wrote up some PostGIS installation instructions for Ubuntu based on the PostgreSQL APT repository:<br>
<br>
<a href="http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt" target="_blank">http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt</a><br>
<br>
These worked great for a while, but seems to have stopped working with Ubuntu 14.04.<br>
<br>
I know there was a thread back at the end of January discussing the version of GDAL that would work with PostGIS (1.9 / 1.10) , but if nothing else, here's an update on the installation error messages:<br>
<br>
--When running this on a fresh Ubuntu 14.04 VM - with no QGIS installed (thanks Stephen), here are the messages that I get:<br>
<br>
After running this command:<br>
<br>
sudo apt-get install postgresql-9.3 postgresql-9.3-postgis pgadmin3 postgresql-contrib<br>
<br>
I get the message:<br>
<br>
Package postgresql-9.3-postgis is not available, but is referred to by another package.<br>
This may mean that the package is missing, has been obsoleted, or<br>
is only available from another source<br>
<br>
E: Package 'postgresql-9.3-postgis' has no installation candidate<br>
<br>
So I modified the install command specific to PostGIS:<br>
<br>
sudo apt-get install postgresql-9.3 postgis pgadmin3 postgresql-contrib<br>
<br>
Which gives the message:<br>
<br>
Some packages could not be installed. This may mean that you have<br>
requested an impossible situation or if you are using the unstable<br>
distribution that some required packages have not yet been created<br>
or been moved out of Incoming.<br>
The following information may help to resolve the situation:<br>
<br>
The following packages have unmet dependencies:<br>
postgis : Depends: libgdal1 (>= 1.9.0) but it is not going to be installed<br>
E: Unable to correct problems, you have held broken packages.<br>
<br>
So I tried to install libgdal1 v 1.10.0 via Synaptic Package Manager, but it doesn't seem to help.<br>
<br>
That's where I'm stuck.<br>
<br>
Does anyone have any info either regarding this error, or if the PostgreSQL APT repo is still packaging PostGIS?<br>
<br>
I will try this on Ubuntu 12.04.4 just for fun...<br>
<br>
I appreciate any feedback! Thank you!!!<br>
<br>
-m<br>
<br>
<br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20140708/44cba966/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20140708/44cba966/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Tue, 8 Jul 2014 20:36:14 -0700<br>
From: "Alexander W. Rolek" <<a href="mailto:a.rolek@gmail.com">a.rolek@gmail.com</a>><br>
To: <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>, Jeffrey Johnson<br>
<<a href="mailto:ortelius@gmail.com">ortelius@gmail.com</a>><br>
Subject: [postgis-users] Finding records withing XX distance from a<br>
geometry in the same table<br>
Message-ID:<br>
<<a href="mailto:CAKvx66W7QJUPj%2BrZDedb_-hNb%2B50Tq-YGqdgcfr1cq5%2BeB9UXA@mail.gmail.com">CAKvx66W7QJUPj+rZDedb_-hNb+50Tq-YGqdgcfr1cq5+eB9UXA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
I'm trying to query all the records within XX distance from a geometry. I<br>
would like to be able to reference the subject geometry via it's id, and<br>
then find every geometry that is either:<br>
<br>
A) within XX distance from a x/y coordinate of the geometry<br>
B) within XX distance from the edge of the geometry on all sides. (ideal)<br>
<br>
What is the best way to accomplish this? My current query:<br>
<br>
SELECT *<br>
FROM sdgis.parcels4326 AS parcels<br>
WHERE ST_Distance_Sphere(<br>
parcels.geom,<br>
<br>
ST_Transform(ST_SetSRID(ST_MakePoint('6255896.314288','1898596.929109'),2230),4326)<br>
) < 100.0;<br>
<br>
This takes a few minutes to run on a table with just over 1 million<br>
records. I would like to swap out the ST_MakePoint, with a multipolygon<br>
from a record that is looked up via it's id.<br>
<br>
Any suggestions are greatly appreciated.<br>
<br>
--<br>
Alexander W. Rolek<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20140708/5a8433ee/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20140708/5a8433ee/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Wed, 09 Jul 2014 09:25:59 +0200<br>
From: Guido Lemoine <<a href="mailto:guido.lemoine@jrc.ec.europa.eu">guido.lemoine@jrc.ec.europa.eu</a>><br>
To: "'PostGIS Users Discussion'" <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] Finding records withing XX distance from<br>
a geometry in the same table<br>
Message-ID: <002f01cf9b47$07bd8d40$1738a7c0$@<a href="http://jrc.ec.europa.eu" target="_blank">jrc.ec.europa.eu</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
Alexander,<br>
<br>
<br>
<br>
You would want to check out ST_BUFFER, which is doing what you intend to do.<br>
<br>
<br>
<br>
Guido<br>
<br>
<br>
<br>
<br>
<br>
From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>] On Behalf Of Alexander W. Rolek<br>
Sent: 09 July 2014 05:36<br>
To: <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>; Jeffrey Johnson<br>
Subject: [postgis-users] Finding records withing XX distance from a geometry in the same table<br>
<br>
<br>
<br>
I'm trying to query all the records within XX distance from a geometry. I would like to be able to reference the subject geometry via it's id, and then find every geometry that is either:<br>
<br>
<br>
<br>
A) within XX distance from a x/y coordinate of the geometry<br>
<br>
B) within XX distance from the edge of the geometry on all sides. (ideal)<br>
<br>
<br>
<br>
What is the best way to accomplish this? My current query:<br>
<br>
<br>
<br>
SELECT *<br>
<br>
FROM sdgis.parcels4326 AS parcels<br>
<br>
WHERE ST_Distance_Sphere(<br>
<br>
parcels.geom,<br>
<br>
ST_Transform(ST_SetSRID(ST_MakePoint('6255896.314288','1898596.929109'),2230),4326)<br>
<br>
) < 100.0;<br>
<br>
<br>
<br>
This takes a few minutes to run on a table with just over 1 million records. I would like to swap out the ST_MakePoint, with a multipolygon from a record that is looked up via it's id.<br>
<br>
<br>
<br>
Any suggestions are greatly appreciated.<br>
<br>
<br>
<br>
--<br>
Alexander W. Rolek<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20140709/16f3bedc/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20140709/16f3bedc/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Wed, 9 Jul 2014 09:34:52 +0200<br>
From: R?mi Cura <<a href="mailto:remi.cura@gmail.com">remi.cura@gmail.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] Finding records withing XX distance from<br>
a geometry in the same table<br>
Message-ID:<br>
<<a href="mailto:CAJvUf_seWmCRcmsf_fHJxhyD4-hO_K672POUxB0GhpxAz_3cTQ@mail.gmail.com">CAJvUf_seWmCRcmsf_fHJxhyD4-hO_K672POUxB0GhpxAz_3cTQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hey,<br>
please _don't_ use st_buffer<br>
, but ST_DWithin (<a href="http://postgis.net/docs/ST_DWithin.html" target="_blank">http://postgis.net/docs/ST_DWithin.html</a>).<br>
<br>
This querry should be around 30 ms.<br>
<br>
You need to add an index to the geometry :<br>
CREATE INDEX parcels_geom_gist_index ON sdgis.parcels4326 USING GIST(geom) ;<br>
<br>
Now if you want to use the field "id", you also need an index on it (unless<br>
it is already a primary key):<br>
CREATE INDEX parcels_id_btree_index ON sdgis.parcels4326 (id) ;<br>
<br>
Depending on your use case you may need to use the GEOGRAPHY type instead<br>
of the geometry.<br>
<br>
Your querry could look like this (there could be more efficicient way, at<br>
the price of readability)<br>
<br>
WITH my_input_polygon AS (<br>
SELECT *<br>
FROM sdgis.parcels4326 AS parcels<br>
WHERE id = #ID_OF_TARGET_POLYGON#<br>
)<br>
SELECT p.*<br>
FROM my_input_polygon AS mip<br>
INNER JOIN sdgis.parcels4326 AS p ON (ST_DWITHIN(mip.geom,p.geom,100)=TRUE);<br>
<br>
It sholdn't take more than few dozen milliseconds.<br>
<br>
Cheers,<br>
R?mi-C<br>
<br>
<br>
<br>
<br>
2014-07-09 9:25 GMT+02:00 Guido Lemoine <<a href="mailto:guido.lemoine@jrc.ec.europa.eu">guido.lemoine@jrc.ec.europa.eu</a>>:<br>
<br>
> Alexander,<br>
><br>
><br>
><br>
> You would want to check out ST_BUFFER, which is doing what you intend to<br>
> do.<br>
><br>
><br>
><br>
> Guido<br>
><br>
><br>
><br>
><br>
><br>
> *From:* <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> [mailto:<br>
> <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>] *On Behalf Of *Alexander W. Rolek<br>
> *Sent:* 09 July 2014 05:36<br>
> *To:* <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>; Jeffrey Johnson<br>
> *Subject:* [postgis-users] Finding records withing XX distance from a<br>
> geometry in the same table<br>
><br>
><br>
><br>
> I'm trying to query all the records within XX distance from a geometry. I<br>
> would like to be able to reference the subject geometry via it's id, and<br>
> then find every geometry that is either:<br>
><br>
><br>
><br>
> A) within XX distance from a x/y coordinate of the geometry<br>
><br>
> B) within XX distance from the edge of the geometry on all sides. (ideal)<br>
><br>
><br>
><br>
> What is the best way to accomplish this? My current query:<br>
><br>
><br>
><br>
> SELECT *<br>
><br>
> FROM sdgis.parcels4326 AS parcels<br>
><br>
> WHERE ST_Distance_Sphere(<br>
><br>
> parcels.geom,<br>
><br>
><br>
> ST_Transform(ST_SetSRID(ST_MakePoint('6255896.314288','1898596.929109'),2230),4326)<br>
><br>
> ) < 100.0;<br>
><br>
><br>
><br>
> This takes a few minutes to run on a table with just over 1 million<br>
> records. I would like to swap out the ST_MakePoint, with a multipolygon<br>
> from a record that is looked up via it's id.<br>
><br>
><br>
><br>
> Any suggestions are greatly appreciated.<br>
><br>
><br>
><br>
> --<br>
> Alexander W. Rolek<br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20140709/ab30650e/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20140709/ab30650e/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Wed, 09 Jul 2014 09:54:04 +0200<br>
From: tommaso <<a href="mailto:tommasodb@googlemail.com">tommasodb@googlemail.com</a>><br>
To: <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
Subject: Re: [postgis-users] Finding records withing XX distance from<br>
a geometry in the same table<br>
Message-ID: <op.xipz8esn9xab12@tommaso-laptop><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed";<br>
DelSp="yes"<br>
<br>
You could use DWithin:<br>
<a href="http://blog.cleverelephant.ca/2010_08_01_archive.html" target="_blank">http://blog.cleverelephant.ca/2010_08_01_archive.html</a><br>
Because your geometries are in 4326, you can cast the them and the point<br>
to geography (without ST_transform) and then use DWithin:<br>
<br>
WHERE ST_DWithin(parcels.geom::geography, yourpoint::geography, 100)<br>
<br>
Regards Tommaso<br>
<br>
<br>
<br>
On Wed, 09 Jul 2014 09:25:59 +0200, Guido Lemoine<br>
<<a href="mailto:guido.lemoine@jrc.ec.europa.eu">guido.lemoine@jrc.ec.europa.eu</a>> wrote:<br>
<br>
><br>
> Alexander,<br>
><br>
><br>
> You would want to check out ST_BUFFER, which is doing what you intend to<br>
> do.<br>
><br>
><br>
> Guido<br>
><br>
><br>
><br>
> From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a><br>
> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>] On Behalf Of Alexander W.<br>
> Rolek<br>
> Sent: 09 July 2014 05:36<br>
> To: <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>; Jeffrey Johnson<br>
> Subject: [postgis-users] Finding records withing XX distance from a<br>
> geometry in the same table<br>
><br>
><br>
> I'm trying to query all the records within XX distance from a geometry.<br>
> I would like to be able to reference the subject >geometry via it's id,<br>
> and then find every geometry that is either:<br>
><br>
><br>
> A) within XX distance from a x/y coordinate of the geometry<br>
><br>
> B) within XX distance from the edge of the geometry on all sides. (ideal)<br>
><br>
><br>
> What is the best way to accomplish this? My current query:<br>
><br>
><br>
> SELECT *<br>
><br>
> FROM sdgis.parcels4326 AS parcels<br>
><br>
> WHERE ST_Distance_Sphere(<br>
><br>
> parcels.geom,<br>
><br>
> ST_Transform(ST_SetSRID(ST_MakePoint('6255896.314288','1898596.929109'),2230),4326)<br>
><br>
> ) < 100.0;<br>
><br>
><br>
> This takes a few minutes to run on a table with just over 1 million<br>
> records. I would like to swap out the ST_MakePoint, >with a multipolygon<br>
> from a record that is looked up via it's id.<br>
><br>
> Any suggestions are greatly appreciated.<br>
><br>
><br>
> --Alexander W. Rolek<br>
<br>
<br>
<br>
--<br>
Using Opera's mail client: <a href="http://www.opera.com/mail/" target="_blank">http://www.opera.com/mail/</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20140709/ec0ea3bb/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20140709/ec0ea3bb/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
End of postgis-users Digest, Vol 149, Issue 6<br>
*********************************************<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Alexander W. Rolek<br>303-829-9989
</div>