-
Notifications
You must be signed in to change notification settings - Fork 10
AREA
Robert Miller edited this page May 28, 2019
·
3 revisions
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 |
Subject
Relation
Attribute
Metadata