extending the enterprise: using fme to integrate data silos in city government

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 BrownMike.Brown@sanjoseca.govSr. Geographic Systems Specialist