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
Public Safety 2019
Motorola conducted an industry survey on the latest trends in public safety communications. The results provide an outlook of what technology is in store for your agency in the next five years. Download the results to gain this valuable insight.
Improving Emergency Response with Digital Communications
Saginaw County, Mich., increases interoperability, communication and collaboration with a digital voice and data network, as well as modern computer-aided dispatch.
Reduce Talk Time in Your Support Center by 40%
As the amount of information available to citizens and employees grows each year, so do customer expectations for efficient service. Contextual Knowledge makes information easy to find, dropping resolution times and skyrocketing satisfaction.
View All

Featured Papers