<div dir="ltr"><div>Hello Anthony,</div><div>In my understanding, I feel like this problem could be simplified by adding a 100-mile buffer to each of your locations and then extracting the remaining area not covered by any of the buffers.</div><div><br></div><div>Thanks</div><div><br></div><div>Faustin<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 29, 2019 at 10:02 PM <<a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send postgis-users mailing list submissions to<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/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" target="_blank">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" target="_blank">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. Calculating driving distance/times (Anthony DeBarros)<br>
2. Re: Calculating driving distance/times (James Keener)<br>
3. Re: Calculating driving distance/times (Anthony DeBarros)<br>
4. Request for ideas to enhance the geometry viewer - GSoC<br>
(Victoria Rautenbach)<br>
5. How to set parameters in 'options'? (Stefan Keller)<br>
6. Re: How to set parameters in 'options'? (Stefan Keller)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Mon, 28 Jan 2019 16:17:57 -0500<br>
From: Anthony DeBarros <<a href="mailto:adebarros@gmail.com" target="_blank">adebarros@gmail.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: [postgis-users] Calculating driving distance/times<br>
Message-ID:<br>
<<a href="mailto:CAAQFaFJjSrb8svQp%2Btj2rde_--4bqkE_vdWuME9r7SOfMOoDaw@mail.gmail.com" target="_blank">CAAQFaFJjSrb8svQp+tj2rde_--4bqkE_vdWuME9r7SOfMOoDaw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi, everyone. Longtime lurker, first-time poster here ...<br>
<br>
Let's say I have a collection of several thousand U.S. locations in the<br>
U.S. geocoded by lat/long.<br>
<br>
I'd like to perform an analysis that lets me visualize places in the U.S.<br>
that have none of these locations within a certain driving distance. For<br>
example, if I had a collection of locations of fast-food restaurants, I<br>
would like to show all the places in the U.S. that have no fast-food within<br>
100 miles.<br>
<br>
Are there tools PostGIS, QGIS, others or methodologies you'd recommend?<br>
<br>
Thanks,<br>
Anthony<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20190128/2fbf0886/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20190128/2fbf0886/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Mon, 28 Jan 2019 16:25:31 -0500<br>
From: James Keener <<a href="mailto:jim@jimkeener.com" target="_blank">jim@jimkeener.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] Calculating driving distance/times<br>
Message-ID:<br>
<CAG8g3tw8fJUa00uwH6anb6dDJRzzj_U3JCr+v=<a href="mailto:AuaEsy2noV7g@mail.gmail.com" target="_blank">AuaEsy2noV7g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="UTF-8"<br>
<br>
I actually just finished talking about this within the context of a<br>
transit stop's walkshed.<br>
<br>
<a href="http://jimkeener.com/posts/calculating-service-area-part-2-defining-the-walkshed" rel="noreferrer" target="_blank">http://jimkeener.com/posts/calculating-service-area-part-2-defining-the-walkshed</a><br>
<br>
I used PostgreSQL + postGIS + pg-routing to do analysis and QGIS to do<br>
the visualization.<br>
<br>
Hop that helps some!<br>
<br>
On 1/28/19, Anthony DeBarros <<a href="mailto:adebarros@gmail.com" target="_blank">adebarros@gmail.com</a>> wrote:<br>
> Hi, everyone. Longtime lurker, first-time poster here ...<br>
><br>
> Let's say I have a collection of several thousand U.S. locations in the<br>
> U.S. geocoded by lat/long.<br>
><br>
> I'd like to perform an analysis that lets me visualize places in the U.S.<br>
> that have none of these locations within a certain driving distance. For<br>
> example, if I had a collection of locations of fast-food restaurants, I<br>
> would like to show all the places in the U.S. that have no fast-food within<br>
> 100 miles.<br>
><br>
> Are there tools PostGIS, QGIS, others or methodologies you'd recommend?<br>
><br>
> Thanks,<br>
> Anthony<br>
><br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Mon, 28 Jan 2019 17:48:30 -0500<br>
From: Anthony DeBarros <<a href="mailto:adebarros@gmail.com" target="_blank">adebarros@gmail.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] Calculating driving distance/times<br>
Message-ID:<br>
<CAAQFaFJ6c2dv_aVXXji8a6TPhKMRy=g8w_=<a href="mailto:N7be2F_G-q-RC0A@mail.gmail.com" target="_blank">N7be2F_G-q-RC0A@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Looks very interesting -- thank you!<br>
<br>
On Mon, Jan 28, 2019 at 4:25 PM James Keener <<a href="mailto:jim@jimkeener.com" target="_blank">jim@jimkeener.com</a>> wrote:<br>
<br>
> I actually just finished talking about this within the context of a<br>
> transit stop's walkshed.<br>
><br>
><br>
> <a href="http://jimkeener.com/posts/calculating-service-area-part-2-defining-the-walkshed" rel="noreferrer" target="_blank">http://jimkeener.com/posts/calculating-service-area-part-2-defining-the-walkshed</a><br>
><br>
> I used PostgreSQL + postGIS + pg-routing to do analysis and QGIS to do<br>
> the visualization.<br>
><br>
> Hop that helps some!<br>
><br>
> On 1/28/19, Anthony DeBarros <<a href="mailto:adebarros@gmail.com" target="_blank">adebarros@gmail.com</a>> wrote:<br>
> > Hi, everyone. Longtime lurker, first-time poster here ...<br>
> ><br>
> > Let's say I have a collection of several thousand U.S. locations in the<br>
> > U.S. geocoded by lat/long.<br>
> ><br>
> > I'd like to perform an analysis that lets me visualize places in the U.S.<br>
> > that have none of these locations within a certain driving distance. For<br>
> > example, if I had a collection of locations of fast-food restaurants, I<br>
> > would like to show all the places in the U.S. that have no fast-food<br>
> within<br>
> > 100 miles.<br>
> ><br>
> > Are there tools PostGIS, QGIS, others or methodologies you'd recommend?<br>
> ><br>
> > Thanks,<br>
> > Anthony<br>
> ><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/postgis-users/attachments/20190128/9fdeea57/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/postgis-users/attachments/20190128/9fdeea57/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Tue, 29 Jan 2019 06:15:15 +0200<br>
From: Victoria Rautenbach <<a href="mailto:victoria.rautenbach@gmail.com" target="_blank">victoria.rautenbach@gmail.com</a>><br>
To: PostGIS Development Discussion <<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a>>,<br>
PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Cc: Frikan Erwee <<a href="mailto:ferwee@gmail.com" target="_blank">ferwee@gmail.com</a>><br>
Subject: [postgis-users] Request for ideas to enhance the geometry<br>
viewer - GSoC<br>
Message-ID:<br>
<<a href="mailto:CABU6Uf3N9FMCsVG_U5Dfk8hho_i34ZMwM_w_95%2B9B07oSNbf5g@mail.gmail.com" target="_blank">CABU6Uf3N9FMCsVG_U5Dfk8hho_i34ZMwM_w_95+9B07oSNbf5g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="UTF-8"<br>
<br>
Dear PostGIS devs and users<br>
<br>
Firstly, we (Frikan, Xuri and I) would like to thank the PostGIS<br>
community again for the support you provided us in 2018 during Google<br>
Summer of Code (GSoC). We truly appreciate your time and effort.<br>
<br>
The call for OSGeo GSoC ideas is now out [1]. Frikan and I would like<br>
to suggest a project to address some of the issues left in the<br>
geometry viewer (available in pgAdmin4), but also include some new<br>
functionality.<br>
<br>
Are there any ideas or suggestions from you, the PostGIS community,<br>
for extra functionalities that would improve the usefulness of the<br>
geometry viewer?<br>
<br>
Thank you in advance.<br>
<br>
Regards<br>
Victoria<br>
<br>
<br>
[1] <a href="https://lists.osgeo.org/pipermail/soc/2019-January/004200.html" rel="noreferrer" target="_blank">https://lists.osgeo.org/pipermail/soc/2019-January/004200.html</a><br>
<br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Tue, 29 Jan 2019 15:18:37 +0100<br>
From: Stefan Keller <<a href="mailto:sfkeller@gmail.com" target="_blank">sfkeller@gmail.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: [postgis-users] How to set parameters in 'options'?<br>
Message-ID:<br>
<CAFcOn2-0dbZ2hPYV6oxFzhsB=<a href="mailto:LKCy3EhLTUBtef7zjxV_tqAQw@mail.gmail.com" target="_blank">LKCy3EhLTUBtef7zjxV_tqAQw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="UTF-8"<br>
<br>
Hi,<br>
<br>
I'd like to write a function like this:<br>
<br>
create function foo(_host text, _port text, _dbname text)<br>
returns void as $$<br>
create server _server<br>
foreign data wrapper postgres_fdw<br>
options (host _host, port _port, dbname _dbname);<br>
-- ERROR: syntax error at or near "_host"<br>
$$ language sql;<br>
<br>
In order to do:<br>
select foo('111.11.11.11', '5432', 'mydb');<br>
<br>
How can I set the parameters in 'options' using those variables?<br>
<br>
:Stefan<br>
<br>
P.S. Actually I'll put this code in a plggsql later on.<br>
<br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Tue, 29 Jan 2019 15:37:01 +0100<br>
From: Stefan Keller <<a href="mailto:sfkeller@gmail.com" target="_blank">sfkeller@gmail.com</a>><br>
To: PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
Subject: Re: [postgis-users] How to set parameters in 'options'?<br>
Message-ID:<br>
<CAFcOn2-q=<a href="mailto:tbMRJHVkTGJ0RSexSXiZJdGtbOSs4yR5PgG1gj19w@mail.gmail.com" target="_blank">tbMRJHVkTGJ0RSexSXiZJdGtbOSs4yR5PgG1gj19w@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="UTF-8"<br>
<br>
Sorry, not best list to ask that...<br>
:Stefan<br>
<br>
Am Di., 29. Jan. 2019 um 15:18 Uhr schrieb Stefan Keller <<a href="mailto:sfkeller@gmail.com" target="_blank">sfkeller@gmail.com</a>>:<br>
><br>
> Hi,<br>
><br>
> I'd like to write a function like this:<br>
><br>
> create function foo(_host text, _port text, _dbname text)<br>
> returns void as $$<br>
> create server _server<br>
> foreign data wrapper postgres_fdw<br>
> options (host _host, port _port, dbname _dbname);<br>
> -- ERROR: syntax error at or near "_host"<br>
> $$ language sql;<br>
><br>
> In order to do:<br>
> select foo('111.11.11.11', '5432', 'mydb');<br>
><br>
> How can I set the parameters in 'options' using those variables?<br>
><br>
> :Stefan<br>
><br>
> P.S. Actually I'll put this code in a plggsql later on.<br>
<br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
<br>
------------------------------<br>
<br>
End of postgis-users Digest, Vol 203, Issue 19<br>
**********************************************<br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div>Gashakamba Faustin<br>Programme Development and Information Systems Manager, ARCOS<br>Tel: (+250) 783 023 303<br>E-mail: <a href="mailto:gashakamba@arcosnetwork.org" target="_blank">gashakamba@gmail.org</a><br>Skype: fgashakamba<br>Website: http://<a href="http://www.arcosnetwork.org" target="_blank">arcosnetwork.org</a><br><br><br></div></div></div>