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

Nicklas Avén nicklas.aven at jordogskog.no
Tue Oct 30 01:00:47 PDT 2018


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

On Tue, 2018-10-30 at 08:34 +0100, Nicklas Avén wrote:
> 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, but also functions (to
> build customized json objects).
> 
> So it is fairly straight forward to create a simple geojson service
> with bounding box filtering. It also has an authentication system
> where
> the db-role to use is baked into a jwt.io token that goes in the
> request header. So, with some row level security out of the box or
> customized row level security, the geometries delivered can be
> controlled by the token used. 
> 
> With all the functionality in PostgreSQL and PostGIS straight into
> the
> api controlled by ordinary database roles this is very powerful.
> 
> I use nginx in front but postgrest can also run it's own web server. 
> 
> I think this could be worth some text in a nnew book :-)
> 
> Regards
> 
> Nicklas
> 
> 
> On Fri, 2018-10-26 at 13:05 -0400, 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.
> > 
> > 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
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel


More information about the postgis-devel mailing list