An Enterprise Street Addressing System Using Open Source Paul E. McCullough City and County of San Francisco • • • gmail – p{dot}e{dot}mccullough slides - tinyurl.com/26cuhcj code - esams.googlecode.com/svn/

Contributors     City and County of San Francisco Department of Technology Department of Building Inspection Office of the Assessor-Recorder Department of Public Works  Farallon Geographics Fargeo.com

  You?

civiccommons.org

Karl Fogel

We built it to...

  satisfy 80% of street address use cases be the “system of record”

We thought it should be...

 geospatial  web centric  based on open source

Agenda  architecture  web client demonstration  extract - transform - load  inter-application messaging

Web Client Javascript Ext JS OpenLayers model view controller Architecture / Deploy Web Server Httpd Python Django GeoDjango model template view RDBMS PostgreSQL/PostGIS app_db map_db json ajax maps Geoserver map cache Virtualized Linux on Applogic

Web Client Demonstration  search  data  change request  address review

Extract - Transform - Load transform Enterprise GIS parcels streets Public Works ownership Assessor ETL app_db map_db applogic

Extract - Transform - Load  Feature Manipulation Engine  two-phase commit  ssh  map cache reseed  dev, qa, prod  Python scripts

Inter-Application Messaging change notification Web Services look up Client System Web Server Address System Web Server

Review  architecture  web client  extract - transform - load  inter-application messaging

Thanks To  Ext JS / OpenLayers  Mozilla / Firefox / Firebug  EveryBlock  Python / Django / GeoDjango  Tomcat / GeoServer  PostgreSQL / PostGIS  Linux

End • gmail – p{dot}e{dot}mccullough • slides - tinyurl.com/26cuhcj • code - esams.googlecode.com/svn/ • Farallon Geographics • fargeo.com

• civiccommons.com

• Karl Fogel

the following slides are supplemental

Data Model

Feature: Simple, Adequate Data Model parcel to address (many to many) apartments timeshares multi-story condos tenants in common mailing address status (official, provisional ...)

Feature: Address Lineage Main Street change request

Feature: Address Point Table street based geo-coding falls short 100 101 Main Street 198 199 Add Constraint: point must be within a polygon