“GIS Strategies for the City and County of San Francisco”

1. www.sfgov.org “GIS Strategies for the City and County of San Francisco” Erich Seamon Technology Chief Dept. of Telecom. and Information Services (415) 554-0808 erich_seamon@ci.sf.ca.us Jeff Johnson Senior GIS Analyst Dept. of Public Works (415) 557-4742 jeff_johnson@cio.sf.ca.us

2. Introduction • Historical Overview of SF GIS • CCSF Enterprise GIS Initiatives • Spatial data distribution • Past data distribution policies • Current data distribution policies • Licensing Revenues • Legal Conformance • Long-term distribution objectives • Summary and Questions Department of Telecommunications & Information Services

3. Historical Overview • CCSF has a fairly decentralized city/county model • Spatial data developed in multiple departments independently • DPW takes lead in basemap development (1994) • City departments individually use basemap in their own applications: pay yearly subscription fee for access • Interaction between departments is minimal • November 2000: Mayor makes announcement for DTIS to implement Enterprise GIS initiative. Department of Telecommunications & Information Services

4. Enterprise GIS efforts • One primary Citywide data integrator, distributor, and entperprise application developer • Development of a dynamic, distributed spatial data warehouse • Implementation of web-enabled applications • Examination of data distribution policies • Design of appropriate citywide organizational model • Bring departments together (on multiple levels) Department of Telecommunications & Information Services

5. Board of Supervisors Office of the Mayor CIO GIS Executive Steering Committee Depts. DTIS GIS Manager Tech. Sub- Committee Depts. Additional Sub- Committees Management & Oversight Application Development Infrastructure & Networking Database Management Standards & Doc. DTIS Department of Telecommunications & Information Services

6. San Francisco’s GIS Basemap • Primary objective was • to create a common GIS Basemap for City government to use and; • to build additional GIS layers and applications. • Basemap development took roughly four years to develop. • +/- 2.5 foot accuracy. • available in three file formats: AutoCAD, ArcInfo, and ArcView; as well as TIF and MrSID image formats. • Basemap layers are maintained and updated by DPW staff, and now distributed citywide by DTIS. • DTIS is providing Enterprise GIS services for all of CCSF Department of Telecommunications & Information Services

7. Basemap Components Centerlines Blocks and Lots Basemap Features Orthophotos Department of Telecommunications & Information Services

8. Spatial Data Distribution Department of Telecommunications & Information Services

9. Previous Distribution Policy • Basemap Data Layers were available to public directly from Department of Public Works (DPW) • DPW staff processed each request, each licensing agreement, each CD, etc. for both internal and external customers • Result of above efforts: • DPW staff resources were not available for core duties • At that time, DPW/CCSF was unable to appropriately market data • DPW sought outside help to handle external requests Department of Telecommunications & Information Services

10. Current Distribution Policy • Basemap data layers available to public via our Value-Added Resellers • Barclay Mapworks, Inc. • Hammon, Jensen, Wallen & Associates, Inc. • ValueCAD, Inc. • City signed agreements with each VAR in 1998 • City receives percentage of gross licensing revenues, capped at a maximum amount • City receives royalties on all basemap-derived products sold Department of Telecommunications & Information Services

11. Licensing Revenues • City receives revenue from each VAR on quarterly basis, if any • Through the VAR program: • ~ $30,000 collected since 1998 • Through direct licensing by the City: over $110,000 collected since 1996 (if staff costs are subtracted, total net would be less …) • Current revenue supplements, but clearly does not supports GIS Basemap and Library operating revenues • City able to finance new orthophotography Department of Telecommunications & Information Services

12. Public Records ActConformance • CCSF has its own public records legislature • Sunshine Ordinance • Basemap system was granted an exception to the Sunshine Ordinance • Multiple CA govt. agencies dealing with • privacy • precedence in records act conformance • Electronic Media - AB2799 Department of Telecommunications & Information Services

13. Long-term distribution objectives • Re-evaluate current VAR policy • Possible alternatives: • Full distribution of spatial data over the web (fits with CCSF Enterprise GIS model) • Hybridization of VAR/free distribution approach • Indirect benefits of full, free distribution seem to outweigh fiscal benefits with current VAR model • Bottom line: a new method of distribution needs to be implemented, which better encourages the use of spatial data (internal to CCSF as well as to the public) Department of Telecommunications & Information Services

14. “GIS strategies for the City and County of San Francisco” www.sfgov.org Erich Seamon Technology Chief Dept. of Telecom. and Information Services (415) 554-0808 erich_seamon@ci.sf.ca.us Jeff Johnson Senior GIS Analyst Dept. of Public Works (415) 557-4742 jeff_johnson@cio.sf.ca.us Department of Telecommunications & Information Services