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 > > [email protected] > > https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-devel mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-devel _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
