[postgis-users] PostGIS case usages

[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
     *   Federal
     *   Reginal
  *   Local caching of offsite Geo-Data related to conveyence sharing
     *   Bike Shares (LIME, BIRD, etc)
     *   Scooter Shares (LIME, NICERIDE, etc)
     *   Car Shares (Car2Go, recently decommissioned)
  *   AVL (GPS) tracking data storage
     *   Maintenance Fleet Vehicles.
     *   Cell Phone Tracking
  *   Logging of Spatial requests to Map Services.
     *   Apache logging of Spatial requests to Map Services.
     *   Generation of Time-lapse filmstrips of (on a daily basis):
        *   AVL Tracking<https://www.dropbox.com/s/15c6awmbd57vw54/latest.webm?dl=0>,
        *   Bike/Scooter Shares (just starting this . . .)
        *   Map Service Activity<https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0>.
  *   Property Assessment Analysis (this was a fun one!)
     *   Relating Parcels Frontages to Street and Alley Centerlines and displaying the output on a dynamic Web Map.
     *   Ties together these elements :
        *   Address Database (City),
        *   Parcel Dataset (County REST service cached locally in POSTGIS (Daily)
        *   Street Centerline dataset (City, Public Works - Admin)
        *   Alley Centerline dataset (City, Public Works - Maint.)
     *   And generates a view like this<https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0> on the fly inside of our (GeoMoose) web interface.
     *   All SQL based (with heavy usage of PostGIS functions).
  *   Place finder (FIDO).  We generate a searchable location database by crwaling all our spatial datasets and loading the data into Postgres/PostGIS for keyword searching.
     *   Any infrastruture ID # can be used to lookup and zoom to in our Mapping interface.
  *   Photo/Document finder.  Similar to FIDO, we use a connection to a MapWarper digitizing service which store sthe data behind the scenes in Postgres/PostGIS and we use the data in the GeoMOOSE webservice for Document<https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0> discovery.
     *   Works with Point, and Polygon georeferncing.
  *   Street Level photo library (2.5 million street level and oblique photos)
     *   Similar to Google Street View, but higher resolution
     *   Camera focal length and bearing is stored for each photo in Postgres/PostGIS and used to generate a location targeted photo collection result.
     *   A point is picked on a map, and all the photos pointing at the desired location are displayed in the response<https://www.dropbox.com/s/587w7jb2e6pew10/latest_activity.webm?dl=0>.

There are a bunch of other other uses as well,  but this is the high level stuff.

bobb



On Oct 26, 2018, at 12:05 PM, Regina Obe <lr at pcorp.us<mailto:lr at pcorp.us>> 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.

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 previous editions focused a lot on  "How
do I use this function or do this weird sounding thing that only GIS people
can make sense of"  instead of "How do I do this real world thing"

So one of the thoughts was having our table of contents be more like "How do
I do this with PostGIS" in somewhat laymen terms that most people can relate
to - like Political Districting, Real Estate analysis (walk scores,
elevation measurements to determine viablility of building on a plot of
land)
without scaring people off with "real world things" they can't relate to or
in overly techy terms.

Also since the 2nd Edition (which was in 2015 super ancient now since the
New shiny version at the time was 2.1 and 2.1 is not even supported
anymore).
Other major thing changed is a lot of people are deploying PostGIS on cloud
offerings like Amazon RDS, Microsoft Azure, and Google PostgreSQL for Cloud
so we plan to cover a bit about some things relevant in those that may not
be relevant when deploying on your own server.

That said, if people can respond with what things they are currently using
PostGIS for and also what hosting they are using for PostGIS, that would be
helpful for us to get a better idea of focus points.

It'd be great if you posted on the list, but if you are shy or need your
usage anonymized, you can write directly to me.

Thanks,
Regina

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users



I took a speed reading course and read ‘War and Peace’ in twenty minutes. It involves Russia.
—Woody Allen

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181030/37ad1bef/attachment.html>