Re: [postgis-users] [postgis-devel] PostGIS case usages

2018-10-30 Thread Nicklas Avén
Hi again Here is a small example serving roads from postgrest. The token will expire the 23 of november. https://tilelessmap.org/postgrest/?token=eyJhbGciOiJIUzI1NiIsInR5cCI6Ik pXVCJ9.eyJyb2xlIjoicG9zdGdyZXN0X3Rlc3QiLCJleHAiOjE1NDMwMDAwMDB9.4LEbPIo SCJsqAGHK00pnNQxQ8zYO4m2RP1dBuHocHjU /Nicklas

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, b

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Birgit Laggner
Hi Regina, I work at a Federal Research Institute and we use PostGIS for various purposes. A very common use case is joining different spatial datasets (vector and sometimes raster) with ST_Intersects, e.g. to find out how agricultural land use is related to nature conservation areas or other p

Re: [postgis-users] PostGIS case usages

2018-10-30 Thread Regina Obe
Birgit, Yes that helps a lot. Thanks, Regina > -Original Message- > From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf > Of Birgit Laggner > Sent: Tuesday, October 30, 2018 7:28 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] PostGIS case usage

[postgis-users] Fwd: Problem creating postgis (2.5) extension with postgres 11 - SOLVED

2018-10-30 Thread Richard Huesken
Hi, My issue has been solved by a tip from Raúl Marín Rodríguez, who pointed out that geod_polygon_init was introduced in PROJ 4.9.1 and it appears I was using 4.8.0-4.el7. This was most likely caused by a packaging issue, I created a ticket for this issue at: www.postgresql.org (#15472). [root@

[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 ar

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 limited

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 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 Stephen V. Mather
Probably my favorite use of PostGIS at my place of employment is with pgRouting and trails -- we calculate and cache trail routes on a 3D network, which allows us to automatically extract elevation profiles, and gives better time estimates for walking and horseback riding (using Tobler's functio