Database Design, Management and Maintenance

GIS databases are increasingly complex, organized around spatial features. They link those graphic elements and features to literally hundreds of attributes stored in dozens of databases within the organization. Developing data structures that manage this data effectively, within our clients' organizational requirements, is a Spatial Focus specialty. In creating a logical database design, our approach is to focus on maintenance, management, and spatial records integration, rather than simply data creation.

Frequently, Spatial Focus works with clients with existing GIS databases who are preparing to expand their systems to an enterprise level. Our work includes defining the linkages to existing data throughout the organization, and the strategic steps required to link that data to the GIS features. Spatial Focus has extensive experience with the major relational databases and GIS software, as well as with many of the major commercial systems in use in government. Optimized database design, coupled with parsing and standardization of addresses and other tabular spatial data, has a profound impact on the effectiveness of a geographic information system. It is the key to linking operational data to mapped information, enabling rapid applications development. The difference is illustrated below.

Spatial records integration gives dimension to the objects on the maps, providing the most complete, accessible view of the data. Spatial Focus, Inc. pays attention to spatial records integration at every level. In some cases, as noted in the addressing example, we are involved in implementation. Consideration of spatial data generated by daily business processes is part of every project. Spatial records integration is one aspect of our blend of strategic and tactical perspectives, part of the craft we bring to every project.