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.

Data Relationship Mapping
One of the early challenges realized during schema design was using the existing data into new format. Here the concepts of relationship definition help resolving the placement of older data into new database with redefinition of same elements and rearrangement for others.

The process of data assembling and constructions of schema were taken up simultaneously. This was done with the awareness of type of schema construction, the city intended to follow. After few brainstorming sessions with users, the loose constructed schema was
   weighed 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
    and fields.
2. Study of existing database models and schema, comparing it with
    city’s database.
3. Developing new database.

Images (left to right)

Storm Water Network

Database Design (Research Poster)

Database Structure