1 / 0

Enterprise Addressing System

Enterprise Addressing System. Spatial Data for the Enterprise (Imagery, Demographic Data). San Francisco Enterprise GIS Program. Enterprise Platform for Services ( VMware, ArcGIS Server). Enterprise License Agreements ( Esri , Pictometry ). Enterprise Addressing System.

drago
Download Presentation

Enterprise Addressing System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Enterprise Addressing System
  2. Spatial Data for the Enterprise (Imagery, Demographic Data) San Francisco Enterprise GIS Program Enterprise Platform for Services (VMware, ArcGIS Server) Enterprise License Agreements (Esri, Pictometry) Enterprise Addressing System
  3. Why an Enterprise Addressing System (EAS)? Departments are focused on their primary business Addresses critical but secondary Current ad hoc situation leads to inefficiencies and confusion An enterprise solution
  4. Current State DBI – Issues permits for an address new address for a building: $262 Maintains own address database (AVS) 311 CSC – Creates service request for an address Maintains own address table DPW – Services requests for Graffiti removal etc.; Issues permits Maintains own set of address lists and databases Emergency Management – send Fire and Police to address Maintains own address database Assessor – Appraises property by block and lot Site address in Parcel Database varies in accuracy TTX, SFMTA, Real Estate, Recreation and Park, etc.
  5. EAS is … Funded initially by COIT, now funded by SFGIS Focused solely on address management Shared source of address information Available across departments Easy to use Adopted by DBI (Director Day at COIT 4/14)
  6. An address in San Francisco per City Charter Assessor/Recorder Block 1244 Lot 022 Parcels (Assessor Parcel Number) 634 Ashbury St Department of Building Inspection Address Number Public Works Ashbury St 600 – 698 Streets (Street Name)
  7. Demonstration
  8. Schedule EAS 1.0 in production (eas.sfgov.org) Production environment on VMWare Regularly scheduled load of DBI’s data into EAS Nightly load of parcels and streets from DPW into EAS Active Open Source Project (http://code.google.com/eas) EAS 1.1 Real-time integration with DBI’s permitting system MOU/SLA between DT and DBI EAS 1.2 and beyond Integration with 311 Call Service Center database Integration with DPW Integration with other departments – Mail Merge services, etc. Leverage development work of other municipalities through the EAS Open Source Project – Civic Commons, Code for America, Sacramento, Bellevue, Virginia Beach, San Mateo Add imagery, building footprints
  9. Questions?
  10. Esri ELA software* *not including SFGIS
  11. VMware Infrastructure
  12. EAS – Cost since Jan 2009 professional services Phase I: $445K (COIT funding) professional services Phase II: $78K (SFGIS funding) hosting services (1) $99K (COIT) hosting services (2) $76K – AppLogic (SFGIS) hosting services (3) $38K – AppLogic > VMWare (SFGIS) hosting services (4) $38K – VMWare (12 months, if needed) (SFGIS) 3D building datasets for entire City: $133k (COIT) Total: $907K, COIT $677K, SFGIS $230K Staff time 1 full-time developer Project management, DBA, Operations DBI developer time
  13. transform Enterprise GIS app_db parcels streets Public Works ownership Assessor map_db Extract - Transform - Load ETL
  14. change notification look up Client System Web Server Address System Web Server Messaging Web Services
  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. Main Street 150 152 154 156 Feature: Address Lineage 150 change request
  18. Main Street 100 198 101 199 Feature: Address Point Tablestreet based geo-coding falls short Add Constraint:point must be within a polygon
  19. Why Open Source?
  20. Good timing for Open Source Open source standards are prevalent Web Feature Service (WFS), vector Web Map Service (WMS), raster ‘Legacy’ open source paves the path Apache most popular webserver since April 1996 54% websites use Apache today Netcraft Web Server Survey (January 2010)
  21. Maturity of Open Source options Linux ~ University of Helsinki, 1991 Apache ~ NCSA, 1994 PostgreSQL ~ Cal 1970’s PostGIS ~ Refractions Research, 2001 MapServer ~2000 Python ~1667
  22. Cost Software licensing is available to the City free of charge Bulk of funding could go to development work and creating solution Free to share with other organizations (GPL3) What about support? So far, not an issue; in fact a plus. Support options available
  23. EAS - Open Source Software PostgreSQL/PostGIS: An Open Source, spatially enabled relational database management system GeoServer: An Open Source application server capable of delivering spatial data using standard formats (such as Web Mapping Services and Web Feature Services) as specified by the Open Geospatial Consortium. OpenLayers: An Open Source JavaScript Library that permits the development of web mapping applications similar to Google Maps Django/GeoDjango: A spatially enabled Open Source web application development framework ExtJS: A modern javascript library (ajax, etc.)
  24. Why use the Cloud? Necessity Opportunity to evaluate offerings Virtualized Data Center Development to QA to Production Hot Site potential
More Related