Getting Started
Data and API
- Parcel Data Onboarding and FAQ
- The Regrid Parcel Schema
- Bulk Data Delivery Formats
- Using the API
- Using the Tileserver
- Customer Support Service Levels
- Standardized Land Use Codes Documentation
- Standardized Land Use Code Keys
- USPS CASS Codes and Notes
- Cropland Data Layer (CDL) Key
- Regrid Matched Building Footprints Frequently Asked Questions
- Regrid Matched Building Footprints Schema
- Regrid Matched Address FAQ
- Regrid Matched Addresses Schema
- Reporting Parcel Data Issues to the Regrid Team
- Configuring S3 for Bulk Delivery
- Configuring GCP for Bulk Delivery
- Verse table schema
- Data Updates Monthly Email
Regrid Mapping Platform
Maps
Adding Data
Surveying
Regrid Status
Verse table schema
The verse
table provides metadata about each county in our dataset and is delivered
to bulk data customers and is available via API.
This table is provided in the same directories and formats as the county data.
The two critical pieces of information in the verse table are filename_stem
and last_refresh
. Those two fields tell you the name of the dataset for a county and the last time we did a full data pull from the source, usually the county or a designee.
Field | Type | Name | Description | Source |
---|---|---|---|---|
id | integer | ID | Row ID | Automatic |
wkb_geometry | geometry | Geometry | Geometry of the place described in this row | Census |
county | character varying | County | County name | Census |
state | character varying | State | Two-letter state abbreviation | Census |
seat | character varying | County Seat | County seat | Census |
population | integer | Population | Total county population (2010 Census) | Census |
sqmi | integer | Square Miles | County square miles | Automatic |
geoid | character varying | GEOID | US Census county GEOID | Census |
city | character varying | City | Slug representing the city, if the data applies to a sub-county area | Census |
table_name | character varying | Table Name | Table name in Regrid system | Automatic (bi-weekly) |
total_objects | integer | Total Objects | Total number of parcels in this place | Automatic (bi-weekly) |
last_refresh | date | Last Refresh Date | Date of the last full refresh of data from our county source. This is always the date of our ingest, see 'assesor_data_date' for the estimated date of the assessor data itself. | Hand |
path | character varying | Path | Path of data in Regrid system | Automatic (bi-weekly) |
canonical_path | text | Canonical Path | Internal path used by Regrid's tileserver to identify a place | Automatic |
filename_stem | text | Filename Stem | The base filename for exports of this place, without extension. Add an extension to get the filename (eg mi_wayne.csv) | Hand |
date_added | timestamp | Date Added | Date the place was first added to our parcel collection | Hand |
shapefile_size_flag | text | Shapefile Size Warning Flag | 'y' indicates this place is larger than the shapefile limit of 2 Gigabytes of data and some applications will silently truncate the file. OSGEO tools generally work fine with these files, Esri tools often truncate data silently. | Hand |
assessor_data_date | date | Date of the assessor data | Date of the assessor data to the best of Regrid's ability to determine. Determined at the same time we refresh our data from the county source. | Hand |
buildings_count | date | Count of buildings in the county | The total of all the individual parcel building counts for the county as derived from [Regrid Matched Building Footprints](https://regrid.com/buildings) data. | Automatic |
buildings_data_dates | date | Date of the building data sources | Dates of the imagery and/or lidar data the building counts and building footprint polygons are derived from. | Automatic |
address_count | date | Count of total primary and secondary addresses in the county | The total of all the [Matched Addresses](https://regrid.com/addresses) available in the county. | Automatic |
address_date | date | Date of the matched address data source | Date of the source data we use to provide matched secondary addresses. | Automatic |
partial | date | Partial county data flag | An indicator that some parcels in the county are not included in our parcel data. Please see our [FAQ for more information](/articles/parcel-data-faq/#why-do-some-counties-have-partial-data). | Hand |
msa | date | Metropolitan Statistical Area | The US Census Metropolitan Statistical Area a county falls in, if there is one. | Automatic |