Going Enterprise

with QGIS and PostGIS

Jo Cook, Astun Technology / @archaeogeek

Astun Logo

Outline

  • Who?
  • What?
  • Why?
  • Customising QGIS for Enterprise use
  • Enterprise workflows for QGIS and PostGIS

Who?

Astun Technology was founded in 2005 to provide enterprise web-based mapping to (mainly) local authorities, based on an open source software stack

Astun Team

Who?

I've been working for Astun as a consultant for 3 years, but have been working with open source GIS since 2004, and this is me, according to "Find Your Kitten"

Kitten

What is "Enterprise"?

Sorry, couldn't resist...

Security

Auditing

Scalability

Sharing

Keep Going...

Business value

Centralised data store

Controlled editing

Auditing and compliance

Why Open Source Enterprise?

Security

Auditing

Scalability

Sharing

QGIS

QGIS Logo

Control exactly what gets loaded at install or startup

Command Line

Fine-grained customisation of appearance

QGIS Simple

Plus...

  • Auto-configure database connections per user
  • Control installation of plugins
  • New layer definition files include references to datasource as well as styling
  • Prepare and deploy print templates over a network
  • Change splashscreens/icons...
QGIS for Boundless
PostGreSQL PostGIS

PostgreSQL 9.2(+) is optimised for virtual environments and multi-processor scalability

New plugin: Postgres 91 plus Auditor

QGIS Audit Plugin

Data validation

Use custom forms for validating text entry

Custom Forms

Geometry validation

Create a workflow using st_isvalid/st_isvalidreason to highlight geometry errors

isvalid_reason
Solution
Simples

Simples!

Or at least, quite achievable!

Thanks :-)

Jo Cook, Astun Technology / @archaeogeek

Astun Logo