September 22, 2008 By Jessica Jones, Contributing Writer
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."
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.