Extending the Enterprise: Using FME to integrate data silos in city government
Mike BrownCity of San Jose
How to make cool things when no one will give you money
About Us
Capital of Silicon ValleyServe 1,015,785 residents
3rd largest city in CA; 10th in USCover 180 Square miles
Annual budget of $3 billionWorkforce of 6,000+ in 10+ departments
BackgroundThe “Haves” and “Have Nots”Lack of consistent look and feelNot mobile friendlyGoogle Maps – internal survey winnerEvery department wants lightweight, easy-to-use maps
ProblemMany departments in different databases and systems – hard to share!
No public portal for interactive maps/data dissemination
Lack of funds for new initiatives
The objectiveDevelop a light-weight, mobile friendly, self service interactive map gallery for City of San Jose staff and citizens
Solution: &
Collaborated with Google and Safe to develop GME incremental update workflows
Developed database standards for data management and integration
Created specialized applications
Cone Zone Modernization
The GoalMake a spreadsheet SPATIAL
How?To get semi-spatial data on a map while reducing time investment from management?
o No addresseso Spatial locations with loose descriptions
To share this data with the public without compromising security and alienating current users?
Cone Zone: Editor App
Browser basedUsers need authenticationHas Validation: Less QA/QC from managementOn-premise
AutomationData is automatically deleted after Project End DateOnly current projects are visible to the publicUse FME to incrementally update data in Google Maps Engine (GME) nightly
Cone Zone Application
SUCCESS!
City of San José Maps Gallery
GME: DEPRECATED
Now what?
CartoDB!Meets all original needs
On Google Cloud Platformo Plays nice with Google Maps API
To do:Tweak workflows for new environment
Figure out the quirks
Geocodes
Incremental Updates
End Result:
No one notices and it looks like we did nothing.
Questions?Mike [email protected]. Geographic Systems Specialist