Government Technology

GIS Offers Online Access to Zoning and Utility Information


GIS Offers Online Access to Zoning and Utility Information
Easy Access

September 22, 2008 By

Portsmouth, Ohio, has made getting maps and utility information much easier by implementing a Web-based GIS portal. Utility workers, engineers and residents can now access up-to-date sewer, floodway, zoning and parking information from virtually any location.

"This particular solution allows us to put all of our data that we've had in different sources together in one source, which is now an Oracle database," said city CIO Michael Penn. "It's a mountain of data we have right now and it's a lot easier to deal with when it's all in one place."

The Nitty-Gritty

Portsmouth began harnessing GIS technology in 1997, when the city hired Penn. "The current mayor had an idea that he'd like to see GIS implemented, and he brought me onboard; we got a start on it," he said. "We'd been doing digital maps within the city for a long time, and it's just been until recently that we had the idea to put everything on the Internet and make it available for pretty much everybody."

Now Portsmouth uses AutoCAD Map 3D, Autodesk MapGuide Enterprise software and Oracle Spatial database technology to display digital design data.

"If you think about it, Oracle is basically in the center -- that's where all the data is stored," said Mark Christian, product marketing manager for Autodesk. "The sewer lines, the cadastral data, zoning data -- all types of information like that -- is stored in the Oracle database."

Two types of clients access the database information: the desktop client, known as AutoCAD Map, which also is the tool engineering staff use to update that information; and MapGuide Enterprise, which is the Web server technology that serves up the information in the database to a Web browser.

Using the desktop client, city engineers edit the data or create new information, Christian said, whether it's editing a map vector, sewer line placements or attribute information that describes the object. "It's based on AutoCAD, so a lot of the engineering staff are already familiar with most of the tools. But rather than storing data in files, they're storing them in the Oracle database," he said.

In addition, AutoCAD Map 3D and MapGuide software support various computer-aided design (CAD) and GIS file formats and data servers, such as DWG, ESRI shapefiles, Oracle9i and industry-standard raster formats.

The integration of the various formats is virtually undetectable, Penn said.

"We can connect to any of the GIS formats out there," he said. "They get put into the Oracle database, and then when we access them through AutoCAD Map, there's really no conversion at all -- it's just kind of done on the fly. You don't ever see it."

For this system, Portsmouth uses one server -- a Hewlett-Packard DL380 with a quad-core processor that has 4 GB of RAM -- that runs both the Oracle and MapGuide software, Penn said.

"It has some pretty good hard drives in it -- eight different hard drives -- and they're about 15,000 RPM hard drives, so they're pretty fast. That was probably about half the cost of the switchover. But it's running great, and I think the Oracle database itself is right around 3.8 GB."

Laying the Groundwork

Penn said the GIS Department didn't run into any problems prior to or during implementation, but the scariest thing for him was working with the Oracle database. "I'm not an Oracle programmer or expert," he said, "but it seems to be pretty easy to work with right now."

Overall, Penn said the solution was exactly what the city needed. For example, it allows Sewer Supervisor Dwight Altman to look up sewer information in the field with a laptop instead of relying on a potentially outdated paper map, Penn said.


| More

Comments

Jerry    |    Commented September 24, 2008

Glad to see the Portsmouth is leveraging their GIS capacity. Here is the link to the City of Beaverton Interactive Maps system for citizens. They have been providing this ever expanding service for several years. http://www.beavertonoregon.gov/departments/gis/gis_maps.aspx It is a great online support tool for local citizens.

Jerry    |    Commented September 24, 2008

Glad to see the Portsmouth is leveraging their GIS capacity. Here is the link to the City of Beaverton Interactive Maps system for citizens. They have been providing this ever expanding service for several years. http://www.beavertonoregon.gov/departments/gis/gis_maps.aspx It is a great online support tool for local citizens.

Jerry    |    Commented September 24, 2008

Glad to see the Portsmouth is leveraging their GIS capacity. Here is the link to the City of Beaverton Interactive Maps system for citizens. They have been providing this ever expanding service for several years. http://www.beavertonoregon.gov/departments/gis/gis_maps.aspx It is a great online support tool for local citizens.


Add Your Comment

You are solely responsible for the content of your comments. We reserve the right to remove comments that are considered profane, vulgar, obscene, factually inaccurate, off-topic, or considered a personal attack.

In Our Library

White Papers | Exclusives Reports | Webinar Archives | Best Practices and Case Studies
Maintain Your IT Budget with Consistent Compliance Practices
Between the demands of meeting federal IT compliance mandates, increasing cybersecurity threats, and ever-shrinking budgets, it’s not uncommon for routine maintenance tasks to slip among state and local government IT departments. If it’s been months, or even only days, since you have maintained your systems, your agency may not be prepared for a compliance audit—and that could have severe financial consequences. Regardless of your mission, consistent systems keep your data secure, your age
Best Practice Guide for Cloud and As-A-Service Procurements
While technology service options for government continue to evolve, procurement processes and policies have remained firmly rooted in practices that are no longer effective. This guide, built upon the collaborative work of state and local government and industry executives, outlines and explains the changes needed for more flexible and agile procurement processes.
Fresh Ideas In Online Security for Public Safety Organizations
Lesley Carhart, Senior Information Security Specialist at Motorola Solutions, knows that online and computer security are more challenging than ever. Personal smartphones, removable devices like USB storage drives, and social media have a significant impact on security. In “Fresh Ideas in Online Security for Public Safely Organizations,” Lesley provides recommendations to improve your online security against threats from social networks, removable devices, weak passwords and digital photos.
View All

Featured Papers