A short history lesson on simple features

During the mid 1990s, interest in simple geometric structures grew. Disk storage and hardware costs in general decreased while computational speed increased. At the same time, existing geographic information system (GIS) datasets were more readily available, and the work of GIS users was evolving from primarily data compilation activities to include data use, analysis, and data sharing. "Interoperability" was a major buzzword.

Users wanted faster performance for data use (for example, deliver the feature coordinates of these 1,200 polygons as quickly as possible). Thousands of GISs were in use and numerous datasets were readily available.

Around this time, Esri developed and published its Esri Shapefile format. Shapefiles used a simple storage model for feature coordinates. Each shapefile represented a single feature class (of points, lines, or polygons) and used a simple storage model for the feature's coordinates. Shapefiles could be easily created from many GIS systems. Over time, shapefiles were widely adopted as a de facto standard and are still widely used and deployed today.

A few years later, ArcSDE pioneered a similar simple features storage model in relational database tables. A feature table could hold one feature per row with the geometry in one of its columns along with other feature attribute columns.

A sample feature table of state polygons is shown below. Each row represents a state and the columns hold the attribute properties for each. One of the columns (the shape column) holds the polygon geometry of each state.

Feature class table showing the shape column

This simple features model fit the structured query language (SQL) processing engine well. Through the use of relational databases, GIS data began to scale to unprecedented sizes and numbers of users without degrading performance. This was the start of leveraging relational database management systems (RDBMS) for GIS data management.

Shapefiles became ubiquitous and this simple features mechanism became the fundamental feature storage model across the GIS industry. (To support interoperability, Esri was the lead author of the Open Geospatial Consortium (OGC) and International Organization for Standardization (ISO) simple features specification).

Simple feature storage had clear advantages. These included the following:

For more information on simple features, see Topology_basics.


9/20/2011