PostGIS
Spatial and Geographic objects for PostgreSQL
Upcoming Events
PGConf US Local: Philly July 13th-14th, 2017 in Philadelphia, PA, USA
PGConf US Local: Seattle August 11th-12th, 2017 in Seattle, WA, USA
Recent past events
May 23-26th Ottawa, Ontario
Tips
Causes for 'postgis.backend' is already set
The error ‘postgis.backend’ is already set comes up every so often in PostGIS mailing list. The issue arises often during or after an upgrade. I’ll go over causes for this I am aware of and how to fix.
The question goes something like this
After upgrading to Postgis 2.3 from 2.1, my server log is filled with these messages :
“WARNING ‘postgis.backend’ is already set and cannot be changed until you reconnect”
Case Studies
Nautilytics Case Study
Nautilytics is a small data visualization and GIS startup based out of Boston, MA. We use PostGIS and PostgreSQL, among other open-source tools to build powerful web applications for US government organizations, public, and private sector companies.
PostGIS for fast prototyping and Research
I used extensively postgis (+ecosystem) for my phd thesis, in several ways. The first is that PostGIS is a good steady horse (elephant?): a database is the perfect place to store a lot of very different information in the same place and put them in relation. For geospatial data, postgis means you always have a way to put data in relation (are they at the same place?).