[postgis-users] postgis-users Digest, Vol 203, Issue 19

Tue Jan 29 23:27:59 PST 2019

Hello Anthony,
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.

Thanks

Faustin

On Tue, Jan 29, 2019 at 10:02 PM <postgis-users-request at lists.osgeo.org>
wrote:

> Send postgis-users mailing list submissions to
>         postgis-users at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.osgeo.org/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
>         postgis-users-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         postgis-users-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
>
>
> Today's Topics:
>
>    1. Calculating driving distance/times (Anthony DeBarros)
>    2. Re: Calculating driving distance/times (James Keener)
>    3. Re: Calculating driving distance/times (Anthony DeBarros)
>    4. Request for ideas to enhance the geometry viewer -        GSoC
>       (Victoria Rautenbach)
>    5. How to set parameters in 'options'? (Stefan Keller)
>    6. Re: How to set parameters in 'options'? (Stefan Keller)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 28 Jan 2019 16:17:57 -0500
> From: Anthony DeBarros <adebarros at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: [postgis-users] Calculating driving distance/times
> Message-ID:
>         <
> CAAQFaFJjSrb8svQp+tj2rde_--4bqkE_vdWuME9r7SOfMOoDaw at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi, everyone. Longtime lurker, first-time poster here ...
>
> Let's say I have a collection of several thousand U.S. locations in the
> U.S. geocoded by lat/long.
>
> I'd like to perform an analysis that lets me visualize places in the U.S.
> that have none of these locations within a certain driving distance. For
> example, if I had a collection of locations of fast-food restaurants, I
> would like to show all the places in the U.S. that have no fast-food within
> 100 miles.
>
> Are there tools PostGIS, QGIS, others or methodologies you'd recommend?
>
> Thanks,
> Anthony
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/postgis-users/attachments/20190128/2fbf0886/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Mon, 28 Jan 2019 16:25:31 -0500
> From: James Keener <jim at jimkeener.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] Calculating driving distance/times
> Message-ID:
>         <CAG8g3tw8fJUa00uwH6anb6dDJRzzj_U3JCr+v=
> AuaEsy2noV7g at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> I actually just finished talking about this within the context of a
> transit stop's walkshed.
>
>
> http://jimkeener.com/posts/calculating-service-area-part-2-defining-the-walkshed
>
> I used PostgreSQL + postGIS + pg-routing to do analysis and QGIS to do
> the visualization.
>
> Hop that helps some!
>
> On 1/28/19, Anthony DeBarros <adebarros at gmail.com> wrote:
> > Hi, everyone. Longtime lurker, first-time poster here ...
> >
> > Let's say I have a collection of several thousand U.S. locations in the
> > U.S. geocoded by lat/long.
> >
> > I'd like to perform an analysis that lets me visualize places in the U.S.
> > that have none of these locations within a certain driving distance. For
> > example, if I had a collection of locations of fast-food restaurants, I
> > would like to show all the places in the U.S. that have no fast-food
> within
> > 100 miles.
> >
> > Are there tools PostGIS, QGIS, others or methodologies you'd recommend?
> >
> > Thanks,
> > Anthony
> >
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 28 Jan 2019 17:48:30 -0500
> From: Anthony DeBarros <adebarros at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] Calculating driving distance/times
> Message-ID:
>         <CAAQFaFJ6c2dv_aVXXji8a6TPhKMRy=g8w_=
> N7be2F_G-q-RC0A at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Looks very interesting -- thank you!
>
> On Mon, Jan 28, 2019 at 4:25 PM James Keener <jim at jimkeener.com> wrote:
>
> > I actually just finished talking about this within the context of a
> > transit stop's walkshed.
> >
> >
> >
> http://jimkeener.com/posts/calculating-service-area-part-2-defining-the-walkshed
> >
> > I used PostgreSQL + postGIS + pg-routing to do analysis and QGIS to do
> > the visualization.
> >
> > Hop that helps some!
> >
> > On 1/28/19, Anthony DeBarros <adebarros at gmail.com> wrote:
> > > Hi, everyone. Longtime lurker, first-time poster here ...
> > >
> > > Let's say I have a collection of several thousand U.S. locations in the
> > > U.S. geocoded by lat/long.
> > >
> > > I'd like to perform an analysis that lets me visualize places in the
> U.S.
> > > that have none of these locations within a certain driving distance.
> For
> > > example, if I had a collection of locations of fast-food restaurants, I
> > > would like to show all the places in the U.S. that have no fast-food
> > within
> > > 100 miles.
> > >
> > > Are there tools PostGIS, QGIS, others or methodologies you'd recommend?
> > >
> > > Thanks,
> > > Anthony
> > >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/postgis-users/attachments/20190128/9fdeea57/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 4
> Date: Tue, 29 Jan 2019 06:15:15 +0200
> From: Victoria Rautenbach <victoria.rautenbach at gmail.com>
> To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>,
>         PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Cc: Frikan Erwee <ferwee at gmail.com>
> Subject: [postgis-users] Request for ideas to enhance the geometry
>         viewer -        GSoC
> Message-ID:
>         <
> CABU6Uf3N9FMCsVG_U5Dfk8hho_i34ZMwM_w_95+9B07oSNbf5g at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Dear PostGIS devs and users
>
> Firstly, we (Frikan, Xuri and I) would like to thank the PostGIS
> community again for the support you provided us in 2018 during Google
> Summer of Code (GSoC). We truly appreciate your time and effort.
>
> The call for OSGeo GSoC ideas is now out [1]. Frikan and I would like
> to suggest a project to address some of the issues left in the
> geometry viewer (available in pgAdmin4), but also include some new
> functionality.
>
> Are there any ideas or suggestions from you, the PostGIS community,
> for extra functionalities that would improve the usefulness of the
> geometry viewer?
>
> Thank you in advance.
>
> Regards
> Victoria
>
>
> [1] https://lists.osgeo.org/pipermail/soc/2019-January/004200.html
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 29 Jan 2019 15:18:37 +0100
> From: Stefan Keller <sfkeller at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: [postgis-users] How to set parameters in 'options'?
> Message-ID:
>         <CAFcOn2-0dbZ2hPYV6oxFzhsB=
> LKCy3EhLTUBtef7zjxV_tqAQw at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi,
>
> I'd like to write a function like this:
>
> create function foo(_host text, _port text, _dbname text)
> returns void as $$
>   create server _server
>     foreign data wrapper postgres_fdw
>     options (host _host, port _port, dbname _dbname);
>     -- ERROR: syntax error at or near "_host"
> $$ language sql;
>
> In order to do:
> select foo('111.11.11.11', '5432', 'mydb');
>
> How can I set the parameters in 'options' using those variables?
>
> :Stefan
>
> P.S. Actually I'll put this code in a plggsql later on.
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 29 Jan 2019 15:37:01 +0100
> From: Stefan Keller <sfkeller at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] How to set parameters in 'options'?
> Message-ID:
>         <CAFcOn2-q=
> tbMRJHVkTGJ0RSexSXiZJdGtbOSs4yR5PgG1gj19w at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Sorry, not best list to ask that...
> :Stefan
>
> Am Di., 29. Jan. 2019 um 15:18 Uhr schrieb Stefan Keller <
> sfkeller at gmail.com>:
> >
> > Hi,
> >
> > I'd like to write a function like this:
> >
> > create function foo(_host text, _port text, _dbname text)
> > returns void as $$
> >   create server _server
> >     foreign data wrapper postgres_fdw
> >     options (host _host, port _port, dbname _dbname);
> >     -- ERROR: syntax error at or near "_host"
> > $$ language sql;
> >
> > In order to do:
> > select foo('111.11.11.11', '5432', 'mydb');
> >
> > How can I set the parameters in 'options' using those variables?
> >
> > :Stefan
> >
> > P.S. Actually I'll put this code in a plggsql later on.
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> ------------------------------
>
> End of postgis-users Digest, Vol 203, Issue 19
> **********************************************
>

-- 
Gashakamba Faustin
Programme Development and Information Systems Manager, ARCOS
Tel: (+250) 783 023 303
E-mail: gashakamba at gmail.org <gashakamba at arcosnetwork.org>
Skype: fgashakamba
Website: http://arcosnetwork.org <http://www.arcosnetwork.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190130/ff8b5774/attachment.html>