AREA

The AREA table stores static information about areas (regions) as well as references to the data source and polygon.

Field	Required	Type	Description
area_id	Yes	integer	A unique identifier for each geographic location.
area_concept_id	No	varchar(50)	The standard concept that uniquely identifies the area.
area_name	Yes	varchar(50)	Name of the area. Useful when incorporating areas that lack standard concepts, such as custom or derived areas.
area_type_concept_id	Yes	integer	The standard concept for the type of area. County, block, tract, etc.
area_type_name	Yes	varchar(2)	The name of the area type. useful when incorporating custom area types.
centroid_x	No	varchar(9)	The x value for the coordinate center of the polygon.
centroid_y	No	varchar(20)	The y value for the coordinate center of the polygon.
centroid_datum	No	varchar(100)	The datum of the centroid
polygon_source_id	No	varchar(100)	Foreign key to the polygon_source table that contains the area's polygon
polygon_id	No	varchar(100)	Uniquely identifies the polygon within the shapefile, which is specified by polygon_source_id
data_source_id	No	varchar(50)	Foreign key to the data source table