Playing with pg_featureserv

Dec 21, 2023 | postgis, QGIS

Which is really all this post is about – learning something new. This year I hit a lot of Conferences and a talking point I’ve done for the last few years has been the tn 911 project. So during the talk I always had this graphic up:

QGIS makes the edits. PostGIS holds the data. Geoserver pushes out some imagery and services. The big problem was due to security at the 911 center geoserver wasn’t really pushing out data to share. We could – but then you have holes in the firewall and that just made me tired. I ended up falling back to Cloud Optimized Geotiffs to share out DEMs and imagery at some point to everyone in the 911. I also created a new problem by forgetting I had done this. The client was gleefully using them and somehow it slipped out of my brain.

After FOSS4GNA, I started thinking that the whole concept of the 911 database needed an update. I had COGS. I’ve been debating a openlayers map on the backend to just show the data. So I started looking at pg_featureserv and pg_tileserv. So now, I can get data straight from the database to whatever else that can consume a geojson. It would be insanely nice if the dispatch software could ingest geojson.

Anyway – nothing else much to say except I was able to trudge through docker and get this running. I’ve been playing with passing queries through CQL and maybe today I’ll execute a function through pg_featureserv.

It can be a nice addition to the Tennessee 911 project. It’s also a bit different in terms of the way I’m used to thinking about data. My life up until 2014 was very file centric. Then I started learning more about databases. Then all those OGC services. Now it’s “just do it”. Which really between this and COGS (I can’t believe I forgot I had implemented that) makes the project less of a “infrastructure pain” on my end.

Anyway – New things. Never stop learning.

You may also like

Watershed GIS Part 1

Watershed GIS Part 1

I typically spend June wondering about what I'm doing, have done, and need to do work wise. One thing I keep thinking about is "the old days". By old days I mean the start of my career which was doing a lot of Watershed Mapping. Back in the mid 90's we would be...

Mergin Maps Training Class

Mergin Maps Training Class

I had a boss that would always start off with "So the Short story is...." and you'd be stuck for at least 30 minutes and maybe an hour listening to a story that didn't go anywhere. So the short story on the Mergin Maps Class.......... NRGS is a Mergin Maps partner. A...

Unintended Joy

Unintended Joy

I was originally going to call this unintended consequences but - there was a small amount of joy at the end. In Tennessee you have 6 layers that are required by the NG 911 group. So you end up with a lot of information depending on the county being poured into the...