-
Notifications
You must be signed in to change notification settings - Fork 9
LOCATION_TO_AREA
Robert Miller edited this page May 28, 2019
·
2 revisions
The LOCATION TO AREA maintains relationships between locations (points) and areas (polygons). This table is purely for efficiency purposes so that we don't need to recalculate these static relationships.
| Field | Required | Type | Description |
|---|---|---|---|
| location_id | Yes | integer | A foreign key to the location table. |
| area_type_id | No | integer | Specifies the geography type. Tract vs. County etc. |
| area_id | Yes | integer | A foreign key to the area table. |
| relationship_id | No | integer | How relationship was determined. Point-in-polygon vs. ID match, etc. |
- TODO
Subject
Relation
Attribute
Metadata