https://www.americancityandcounty.com/wp-content/themes/acc_child/assets/images/logo/footer-logo.png
  • Home
  • Co-op Solutions
  • Commentaries
  • News
  • In-Depth
  • Multimedia
    • Back
    • Podcast
  • Resources
    • Back
    • Resources
    • Webinars
    • White Papers
    • Events
    • How to Contribute
    • Municipal Cost Index – Archive
    • Equipment Watch Page
    • American City & County Awards
  • Magazine
    • Back
    • Digital Editions
    • Reprints & Reuse
    • Advertise
  • About Us
    • Back
    • About Us
    • Contact Us
    • Privacy Statement
    • Terms of Service
American City and County
  • NEWSLETTER
  • Home
  • Co-op Solutions
  • Commentaries
  • News
  • In-Depth
  • Multimedia
    • Back
    • Podcasts
  • Resources
    • Back
    • Webinars
    • White Papers
    • Events
    • How to Contribute
    • American City & County Awards
    • Municipal Cost Index
    • Equipment Watch Page
  • Magazine
    • Back
    • Digital Editions
    • Reprints & Reuse
    • Subscribe to GovPro
    • Manage GovPro Subscription
    • Advertise
  • About Us
    • Back
    • About Us
    • Contact Us
    • Cookie Policy
    • Privacy Stament
    • Terms of Service
  • newsletter
  • Administration
  • Economy & Finance
  • Procurement
  • Public Safety
  • Public Works & Utilities
  • Smart Cities & Technology
acc.com

Public Works & Utilities


Sharing geographic data

Sharing geographic data

Central database feeds public works asset information to others.
  • Written by Nikki Swartz
  • 1st January 2006

The San José, Calif., Public Works Department has simplified its geographic information system (GIS) data management process with a single database that works with software from a variety of vendors. The change is saving time and improving productivity for the department’s 400 staff members.

As the Public Works Department’s GIS grew to include more information about parcels, sanitary sewers, storm drains and street lights, the department acquired several software formats to manage the large amount of data. However, the variety of software required staff to enter the same information more than once into different systems. In 2000, department managers decided to streamline efforts and simplify departmental processes. They wanted a system that would allow public works staff to update, access, analyze and publish geographic data so other departments could view GIS data as soon as it became available.

According to Kevin Briggs, public works GIS section manager, staff were reluctant to give up their software tools, so the department created a new, single database that a variety of software could access. The department purchased GeoMedia software from Madison, Ala.-based Intergraph and database software from Redwood Shores, Calif.-based Oracle to create, maintain and publish the geographic information. The new database integrates directly with other business systems, including San José Online Permits, Public Safety/E911, Capital Project Management and the city’s Infrastructure Management system.

Information is stored in the database, which anyone working for the city can access, and each department connects to it using software from Redlands, Calif.-based ESRI, Troy, N.Y.-based MapInfo or Exton, Pa.-based Bentley. The repository includes digital ortho photos of San José’s 177 square miles and a regional base map accurate within plus or minus one to two feet. In addition, San José shares its map data with Santa Clara County, the Santa Clara Valley Water District, the Association of Bay Area Governments and the Federal Emergency Management Agency.

Public works employees determined what information needed to be included in the database and what kind of data fields had to be populated. Now, when a data field must be changed or updated, the Public Works Department only has to make the change in one place. “Staff has been able to input data 25 percent to 30 percent quicker than before with fewer mistakes,” says Harsh Gautam, technology architect.

To meet the ever-increasing data demand, San José is moving toward a two-server architecture approach. Staff members who update GIS data daily connect to a production server, which then pushes the updates over to the publication server where other city staff members only can view the information. The department also plans to integrate GIS into all of the city’s 12 infrastructure management systems and to wirelessly push out GIS to maintenance crews and engineers in the field. Briggs says that will improve project turnaround time, allow greater field verification of data, increase spatial accuracy and, ultimately, eliminate paper reports.
— Nikki Swartz is a Kansas City, Mo.-based freelance writer.

Tags: Public Works & Utilities

Related


  • How small cities are tackling lead service line replacement
    “We move Heaven and earth,” says Montana Birt. A transplant from Georgia, Birt is a pastor in a local church in Thorp, Wisc., the smallest of cities with a population of just more than 1,600. His more earthly endeavor, however, involves digging up and replacing lead pipes that threaten to poison his neighbors’ water in […]
  • Six tips for making sure your dispatch is doing all the right moves
    Planning, design, construction, maintenance and waste disposal are a few aspects public works departments deal with daily. It seems like a great deal of specialized work and reporting because it absolutely is. And all of it routed through a dispatch center. Without the right tools in place, a dispatcher cannot keep things running smoothly. Nor […]
  • Baltimore will distribute recycling carts to residents to encourage recycling
    Approximately 200,000 residents in Baltimore who receive trash removal or recycling pickup services from the city will receive new recycling carts this Spring to encourage recycling. The new program is part of a public-private partnership, funded by solid waste producers like Coca-Cola and Amazon, and subsidizes recycling cart programs, recycling education campaigns and other initiatives for […]
  • Local governments in Texas respond to cold snap, power grid failure
    As many Texans remain without power due to an ongoing cold snap in the state, local governments are taking varied measures to try to help their communities where they can. The Electric Reliability Council of Texas (ERCOT), which controls most of Texas’s power, said on Friday that it has returned to normal operating conditions, CNBC […]

Leave a comment Cancel reply

-or-

Log in with your American City and County account

Alternatively, post a comment by completing the form below:

Your email address will not be published. Required fields are marked *

Related Content

  • Six cities share $745,000 in grants for sustainability projects
  • The uncertain future of community composting in New York City
  • How Philadelphia is aiming for zero waste
  • Cleveland launches program to create circular rconomy

White papers


Discover How Public Sector Officials are Monitoring and Managing Overtime in This New White Paper

22nd February 2021

How to Assemble a Successful Government Grant Proposal

5th February 2021

The Rise of Procurement’s Next Normal

5th February 2021
view all

Events


PODCAST


Young Leaders Episode 4 – Cyril Jefferson – City Councilman, High Point, North Carolina

13th October 2020

Young Leaders Episode 3 – Shannon Hardin – City Council President, Columbus, Ohio

27th July 2020

Young Leaders Episode 2 – Christian Williams – Development Services Planner, Goodyear, Ariz.

1st July 2020
view all

Twitter


AmerCityCounty

American City & County’s 2020 Exemplary Public Servant of the Year Award dlvr.it/RtZbX2

26th February 2021
AmerCityCounty

American City & County’s 2020 Crown Communities Awards dlvr.it/RtZbVz

26th February 2021
AmerCityCounty

2020 Crown Communities Awards winner: Rock Hill, S.C.’s My Ride dlvr.it/RtZSFp

26th February 2021
AmerCityCounty

Three communities hosting Augmented Reality Developer Challenge competitions dlvr.it/RtZ94D

26th February 2021
AmerCityCounty

Using data to improve emergency response resources dlvr.it/RtVSc0

25th February 2021
AmerCityCounty

How small cities are tackling lead service line replacement dlvr.it/RtV9G8

25th February 2021
AmerCityCounty

COVID-19 and pivoting into a new year: It may be 2021, but did we really leave 2020? dlvr.it/RtQRcr

24th February 2021
AmerCityCounty

Six tips for making sure your dispatch is doing all the right moves dlvr.it/RtQBvl

24th February 2021

Newsletters

Sign up for American City & County’s newsletters to receive regular news and information updates about local governments.

Resale Insights Dashboard

The Resale Insights Dashboard provides model-level data for the entire used equipment market to help you save time and money.

Municipal Cost Index

Updated monthly since 1978, our exclusive Municipal Cost Index shows the effects of inflation on the cost of providing municipal services

Media Kit and Advertising

Want to reach our digital audience? Learn more here.

DISCOVER MORE FROM INFORMA TECH

  • IWCE’s Urgent Communications
  • IWCE Expo

WORKING WITH US

  • About Us
  • Contact Us

FOLLOW American City and County ON SOCIAL

  • Privacy
  • CCPA: “Do Not Sell My Data”
  • Cookies Policy
  • Terms
Copyright © 2021 Informa PLC. Informa PLC is registered in England and Wales with company number 8860726 whose registered and Head office is 5 Howick Place, London, SW1P 1WG.
This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services. By continuing to use our website, you agree to the use of such cookies. Click here for more information on our Cookie Policy and Privacy Policy.
X