Re: [postgis-users] PostGIS case usages

2018-11-04 Thread Regina Obe
ostGIS Development Discussion ; > dylan.beaude...@ca.usda.gov > Subject: Re: [postgis-users] PostGIS case usages > > Happy to elaborate on how we have used PostGIS to support SoilWeb for the > last 10 years. This is a realtime interface to one of the largest spatial > databases

Re: [postgis-users] PostGIS case usages

2018-11-04 Thread Razy Kased
Great examples of use-cases thanks for sharing. Razy On Sunday, November 4, 2018, Dylan Beaudette wrote: > Happy to elaborate on how we have used PostGIS to support SoilWeb for the > last 10 years. This is a realtime interface to one of the largest spatial > databases in the world. > > Dylan >

Re: [postgis-users] PostGIS case usages

2018-11-04 Thread Dylan Beaudette
Happy to elaborate on how we have used PostGIS to support SoilWeb for the last 10 years. This is a realtime interface to one of the largest spatial databases in the world. Dylan USDA-NRCS > On Oct 26, 2018, at 10:05 AM, Regina Obe wrote: > > Hey all. So we've been in talks with our editor

Re: [postgis-users] PostGIS case usages

2018-11-04 Thread Roxanne Reid-Bennett
We've used PostGIS to support agriculture for the last 7 years. Our use cases are pretty straight forward * ST_Intersects, Union for Polygons and  MultiPolygons * Generation of Poly's from Area around Linestrings * Generation of Poly's from Area around Points turned into a Unioned Poly *

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Devdatta Tengshe
Development Discussion' > > Subject: Re: [postgis-users] PostGIS case usages > > > > Regina, > > > > Some very good points. > > > > I stopped using the term years ago given that I concentrate on applying > > spatial data and functions to solving

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Simon Greener
...@spatialdbadvisor.com] Sent: Wednesday, October 31, 2018 11:39 PM To: 'PostGIS Users Discussion' ; Regina Obe Cc: 'PostGIS Development Discussion' Subject: Re: [postgis-users] PostGIS case usages Regina, Some very good points. I stopped using the term years ago given that I concentrate on applying

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Regina Obe
> Cc: 'PostGIS Development Discussion' > Subject: Re: [postgis-users] PostGIS case usages > > Regina, > > Some very good points. > > I stopped using the term years ago given that I concentrate on applying > spatial data and functions to solving business problems. >

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Simon Greener
PostGIS Users Discussion Cc: 'PostGIS Development Discussion' Subject: Re: [postgis-users] PostGIS case usages Hi Regina, It might not really fit the book, because it's not exactly GIS, but our PostGIS use case is certainly an interesting one as well: As a software engineer at the Howard H

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Regina Obe
hanks, Regina > -Original Message- > From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf > Of Tom Kazimiers > Sent: Wednesday, October 31, 2018 3:16 PM > To: PostGIS Users Discussion > Cc: 'PostGIS Development Discussion' > Subject: Re:

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Tom Kazimiers
Hi Regina, It might not really fit the book, because it's not exactly GIS, but our PostGIS use case is certainly an interesting one as well: As a software engineer at the Howard Hughes Medical Institute, I work on a collaborative neuron reconstruction and analysis software called CATMAID [1]

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread Garret W
I just wanted to give my vote to some of the great ideas/projects that other people have all ready posted, that I would love to read more about. - stealing some data from some web endpoint - Anything dealing with using python to interact with your database is great. - line and parcel topology -

Re: [postgis-users] PostGIS case usages

2018-10-31 Thread christophe vergon
Hi,   A "french use of Postgis" (sorry for my poor english, it's easyer to read than to write ) :   We are working in Land Analysis and Urban Planning. Our Information System is based on Postgresql/postgis database engine. Topology is particulary usefull for us, but a little bit tricky. Our

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Stephen V. Mather
ussion' Subject: [postgis-users] PostGIS case usages Hey all. So we've been in talks with our editor about having a 3rd Edition of PostGIS hopefully to be released around the same time as PostGIS 3.0. I think they are more or less sold on the idea except they did ask about current market share and

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Basques, Bob (CI-StPaul)
Oops, some of my example links in the previous message got duplicated, sorry about that, here it is again: — Hi Regina, Sorry about the all over the place character of my list, but we use PostGIS quite a bit. City of Saint Paul, Public Works: * Local caching of offsite Geo-data

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Basques, Bob (CI-StPaul)
Hi Regina, Sorry about the all over the place character of my list, but we use PostGIS quite a bit. City of Saint Paul, Public Works: * Local caching of offsite Geo-data from other gov gencies (About 60 layers in all). * Other Municipalities * Counties * States

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Gerry Creager - NOAA Affiliate
Regina I use PostGIS for weather station (surface observations) data, as well as quality control flags. I'm now starting to look at weather satellite data with the newer GOES-16 and -17 satellites (GOES-R and -S). Keeping with the "all things meteorological" theme, I also have played, with

[postgis-users] PostGIS case usages

2018-10-30 Thread J Payne
Hi Regina, I'm an ecologist, and I do a lot of work with animal tracking. The niche is small, but it's a very active area of work. Typically, we are trying to figure out why animals go where they do. That involves overlaying track data with polygon and raster layers; the rasters

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Regina Obe
achines. > > Does that help? > > Regards and success with the new book! > > Birgit > > - Urspr ngliche Mail - > Von: "Regina Obe" > An: postgis-users@lists.osgeo.org > CC: "PostGIS Development Discussion" > Gesendet: Freitag, 26. Oktob

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Birgit Laggner
- Ursprüngliche Mail - Von: "Regina Obe" An: postgis-users@lists.osgeo.org CC: "PostGIS Development Discussion" Gesendet: Freitag, 26. Oktober 2018 19:05:52 Betreff: [postgis-users] PostGIS case usages Hey all. So we've been in talks with our editor about having a 3r

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Nicklas Avén
Hi Regina Very good news with a new PostGIS book! A simple but very powerful combination of tools I use quite a lot is PostgreSQL/PostGIS and postgREST (http://postgrest.org) PostgREST uses postgreSQL built in json functions to create a rest-api. It can serve tables and views out of the box,

Re: [postgis-users] PostGIS case usages

2018-10-27 Thread Andy Colson
On 10/26/18 12:05 PM, Regina Obe wrote: Hey all. So we've been in talks with our editor about having a 3rd Edition of PostGIS hopefully to be released around the same time as PostGIS 3.0. That said, if people can respond with what things they are currently using PostGIS for and also what

Re: [postgis-users] PostGIS case usages

2018-10-26 Thread Komяpa
Some things I've been using PostGIS for: - render OpenStreetMap. That's how I got to know about PostGIS, osm2pgsql, mapnik and its styles. Changing order of things, removing clutter of icons from map, adding clutter of icons you need for this map, getting tile server online. Sorting by area to

[postgis-users] PostGIS case usages

2018-10-26 Thread Regina Obe
Hey all. So we've been in talks with our editor about having a 3rd Edition of PostGIS hopefully to be released around the same time as PostGIS 3.0. I think they are more or less sold on the idea except they did ask about current market share and usage. Part of the reason for that is our