|
MSD recently completed the first major data conversion project supported solely by a participant agency. Over 2,400 miles of sanitary and combined sewers, an accompanying master inventory of these facilities, and a point coverage of service connections that links parcels to the sewer main that serves them was completed in 1997. The project is the first effort to integrate an external RDBMS for attribute data storage. Using Hansen’s Infrastructure Management System (IMS), the system links an Oracle database housed on SUN servers on the MSD network, with the graphic facilities data located on the LOJIC network. No annotation is maintained in the graphic data. All attributes are pulled live, through a dynamic, real-time link between the two systems. Users can click on the graphic symbology and attribute inventory data describing the facility is displayed on the screen. An MSD working group representing eleven internal departments has begun developing the system and database design, as well as the conversion methodology for the drainage facilities conversion effort.
This project is expected to take 3 years and be accomplished entirely by in-house staff, utilizing existing database maintenance applications.
In conjunction with this major conversion effort, LOJIC staff will be coordinating the development of a networked stream coverage and a water bodies layer, which will help form the backbone for county-wide drainage facilities. As well as being critical for the conversion effort, the stream network and water bodies layers are needed for applications such as stream flow modeling, facilities and work order management, and general cartographics.
Soils and floodplains were both developed under joint initiatives with NRCS and FEMA, respectively. The soils conversion project involved scanning existing soils maps, edgematching the data into a seamless coverage, and extensive quality control checking.
Development of the flood limits and the Flood Insurance Rate Mapping (FIRM) data in conjunction with the Corps of Engineers and FEMA, was the first successful joint effort of its kind in the country. MSD, as the entity responsible for stormwater management services in Jefferson County, uses LOJIC as the official repository. MSD staff is working with FEMA on new and better techniques for floodplain determination and modeling by using the official FIRM data maintained in the LOJIC GIS.
 Since 1996, LOJIC has produced high-resolution orthophoto imagery from annual aerial photography of Jefferson County rectified to the PTD mapping. The digital orthophoto imagery was originally created from 1"=660’ panchromatic photos acquired in Spring 1996 and 1997. Imagery was again updated using 1"=800’ color aerial photography acquired in Spring 1998. LOJIC is currently creating digital orthophoto imagery from its color Spring 2000 aerial photography. Digital imagery is accessible on-line via the LOJIC GIS and serves as background data to support a wide range of internal projects and as a future source for updating PTD mapping.
Spatial Databases (continued) >>
|
, 1.2 M)
symbol are available in Portable