Skip to content

POLYGON_FILE

Robert Miller edited this page May 28, 2019 · 3 revisions

The POLYGON FILE table persists the information to access locally stored polygons.

Field Required Type Description
polygon_file_id Yes integer A unique identifier for the table.
area_type_id No integer Specifies the subject of the polygons. Counties, blocks, etc.
alt_path No integer Takes precedence over global shapefile repository path if populated.
layer Yes integer Name of the layer. Needed for readOGR function
file_id_col Yes integer Specifies which data column in the shapefile is the matching identifier.
source_file_name No varchar(200) Name of source file. For documentation purposes only
file_format No varchar(100) (For later versions) Format of file. 'ESRI Shapefile', 'geojson', etc
data_source_id No varchar(100) FK to data_source table

Conventions

  • For now, we are only considering polygons in the form of shapefiles. Given the versatility of OGR, we could allow other files form and add polygon_type column to specify shapefile vs. geojson etc.
Clone this wiki locally