|2008 | Department of Finance, City of SeaTac|
|Research and design of SeaTac utility and transportation database | SeaTac, WA|
The project was to integrate various data
sources into a unified GIS system. The utility data was primarily
being used for maintaining, recording, projecting and decision
making. The main users of this data were GIS Analyst, City’s public
works department. The whole process of data gathering and storage
was fragmented and inconsistent, involving multiple systems.
in over a strict schema, where larger numbers of elements
demanding longer development time are considered. Another
interesting aspect was exploration and research into sample
models developed , such as ESRI’s ‘simplified database design’
and neighboring (parallels) cities that have established
database or are in process of developing one. The collaborative
approach to unify the database schema and the process of storing
data provides uniformity across cities.
1. Researching existing datasets, segregation of redundant layers
2. Study of existing database models and schema, comparing it with
3. Developing new database.
Storm Water Network
Database Design (Research Poster)