An Enterprise Street Addressing System Using Open Source - PowerPoint PPT Presentation

Loading...

PPT – An Enterprise Street Addressing System Using Open Source PowerPoint presentation | free to download - id: 5c9f5a-NmJhM



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

An Enterprise Street Addressing System Using Open Source

Description:

An Enterprise Street Addressing System Using Open Source Paul E. McCullough City and County of San Francisco gmail - p.e.mccullough s - http://tinyurl.com/26cuhcj – PowerPoint PPT presentation

Number of Views:256
Avg rating:3.0/5.0
Slides: 27
Provided by: PaulMcC1
Learn more at: http://assets.en.oreilly.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: An Enterprise Street Addressing System Using Open Source


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

2
Enterprise Addressing System
  • mundane
  • insert, update, delete (retire)
  • useful

3
We built it to...
  • satisfy 80 of street address use cases
  • be the system of record
  • reduce the silo count

4
We thought it should be...
  • geospatial
  • web centric
  • based on open source

5
Agenda
  • architecture
  • web client demonstration
  • extract - transform - load
  • messaging

6
Architecture/Deploy
Virtualized Linux on Applogic
7
Web Client Demonstration
  • search
  • change request
  • address review

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

10
Messaging
Web Services
11
Review
  • architecture
  • web client
  • extract - transform - load
  • messaging

12
Questions
gmail p.e.mcculloughslides todo urlrepo
todo - url
13
Credits
  • City and County of San Francisco
  • Department of Technology
  • Department of Building Inspection
  • Assessors Office
  • Department of Public Works
  • Farallon Geographics
  • Open Source Projects
  • Ext JS / OpenLayers
  • Mozilla / Firefox / Firebug
  • EveryBlock
  • Python / Django / GeoDjango
  • GeoServer
  • PostgreSQL / PostGIS
  • Linux

14
  • the following slides are supplemental

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

17
Feature Address Lineage
150
change request
18
Feature Address Point Tablestreet based
geo-coding falls short
Add Constraintpoint must be within a polygon
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
About PowerShow.com