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	int	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_id	Yes	integer	The standard concept for the type of area. County, block, tract, etc.
area_source_concept_id	No	int	The standard concept that uniquely identifies the area.
area_source_value	Yes	varchar(50)	The name of the area type. useful when incorporating custom area types.
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