|
|
| |
| The
City of Springfield Geographic Information System serves the
planning, designing, constructing, operating, maintaining and
preserving of public facilities and resources. |
| |
| These
functions can be illustrated with a few major database systems: |
| |
Infrastructure Management System (IMS) |
| |
|
|
| |
The
City's Infrastructure Management System supports routine maintenance
of public facilities, including:
a) work order management, tracking time and materials as system
components are maintained by field crews;
b) accounts
for investments in City facilities and depreciation;
c) basic inventory maintenance like keeping track of when components
were installed, activated, and then retired (abandon or removed)
from service.
This system supports most maintenance activities and helps the
City of Springfield, OR comply with regulations and best practice
standards such as GASB34.
In the IMS, components
are stored as link node topologies (lines and points that
snap end to end that retain important connectivity information
in their attributes).
|
|
|
| Natural
Resource Management System (NRMS) |
| |
|
|
|
This system allows
the City to inventory all of the natural features (invasive
species, endangered species, etc.) that occur along surface
waterways, maintain surface waterway assessment information,
and integrate our local inventories with other state and federal
inventories like the Oregon Department of Natural resources,
Oregon Water Resource Department and the Environmental Protection
Agency's Clearinghouse.
In the NRMS, system
components participate in link node topologies (along with
IMS system components) and share geometries with other features
as linear and point events.
|
|
| Hydraulic
Flow System (HFS) |
| |
|
|
|
This system supports drainage, hydrography, network and channel
analysis. Surface waterways are inventoried as hydro networks
(link node topologies), hydro networks are liked to drainage
areas, and channels are stored as three-dimensional models.
This system also maintains relationships between water features
and event features such as cross sections and time series
measurements recorded at gauging stations.
Hydro system components
participate in link node topologies (along with IMS and NRMS
system components) and polygonal topologies and share geometries
with other features as point events.
|
| |
| Combined
within a relational database management system (DBMS), the City
manages updates through a standard set of rules (stored procedures
in the DBMS). Rules check for connectivity, assign unique identifiers,
automatically populate tables and provide quality control and
quality assurance upon input. All of these rules ensure that
the combined system can support those systems diagrammed above
and that reliable information enters the system. Great care
is taken to make sure that our shared inventory contains the
best available information. |
| |
| Consolidated
Database Management System (DBMS) |
| |
|
|
|
|
| In
the consolidated DBMS shared attributes and rules are standardized
and applied to the appropriate components in an orderly fashion.
All nodal features, for example, share connectivity rules with
pipes and pipes share common attributes with streams. Similar
components such as storm pipes and open canals can be modeled
together. In this system, the City can trace flows through both
piped and surface waterway features.
The components
simplified in the diagram above are controlled by powerful
enterprise integration software. The software applies DBMS
rules (mentioned above) and allows City staff to maintain
the integrated systems through an AutoCAD interface.
|
|
SOFTWARE COMPONENTS
|
