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

QGIS US User Group

QGIS US User Group

I've been too busy to write anything as of late. I have a lot to talk about - just not much time to do it. So FOSS4GNA happened on Sept 9-11 2024. Probably the biggest thing for me during the conference was we had two BOFs on QGIS. Granted - I think it was supposed to...

QGIS and LIDAR

So this will be my last "New Class" announcement for a bit. Back in the spring of 2024, I taught a 4 hour QGIS and LIDAR class at the TNGIC meeting (State of TN GIS meeting). I ran through it and shelved it and now I'm fixing the problem spots and smoothing down the...

NENA 911 Database in QGIS

NENA 911 Database in QGIS

I work with two counties in TN with the TN NG911 standard. Flash back 10 years ago and I hadn't really grasped how complicated address is. Do I like it? Mostly Yes. Occasionally I get questions from outside TN and I demo the two counties and how that works. A while...