Bulk Data Delivery Formats

Introduction

Regrid provides data in a varity of formats and configurations.

Parcel Data File Formats

Format Description
CSV All available data in CSV format, with double-quoted strings. A parcel centroid is provided in the lat and lon columns, but the full parcel geometry is not included. This format is often used in cloud based applications. Spreadsheet applications can make use of this format, but will likely encounter cell and row size limits.
CSVWKT All available data, with full geometries provided as Well-Known Text (WKT).
File GDB Esri-specific spatial format.
GeoJSON Web development and JavaScript focused.
GeoPackage Open source, QGIS and general interchange format, SQLite based.
KML Google Earth native format, does not handle typical county dataset sizes very well.
Newline-delimited GeoJSON Each parcel is represented by a GeoJSON feature. Each feature is on a separate line.
Shapefile Legacy Esri format. We recommend GeoPackage or FileGDB over Shapefile. The Shapefile format has a maximum data size of 2GB (some clients can read up to 4GB) and will truncate column names.
SQL Postgresql SQL for loading into Postgresql databases.



Parcel Record Layout Options

Record Layout Description
Standard Tier This includes all of the fields listed in our Standard Tier, plus all of the custom columns each county provides. Processing workflows must allow for a variable number of custom columns not in the Regrid schema.
Standard Tier, Schema Only This includes only the fields listed in our Standard Tier and none of the custom columns each county provides. Processing workflows can rely on a fixed number of fields.
Premium Tier This includes all of the fields listed in our Premium Tier plus all of the custom columns each county provides. Processing workflows must allow for the variable number custom columns.
Premium Tier, Schema Only This includes only the fields listed in our Premium Tier and none of the custom columns each county provides. Processing workflows can rely on a fixed number of fields.



Building Polygon Data File Formats

Format     Description
CSVWKT All the available data, full geometry provided as Well Known Text.
GeoJSON Web development and JavaScript focused.
GeoPackage Open source, QGIS and general interchange format, SQLite based.
Shapefile Legacy Esri format. We recommend GeoPackage or FileGDB over Shapefile. The Shapefile format has a maximum data size of 2GB (some software can read up to 4GB) and will truncate column names.



Matched Address Data File Formats

Format       Description
CSV All the available data, with comma separated, double-quoted strings, and lat/lon coordinates. Often used in cloud based applications. Spreadsheet applications can make use of this format, but will likely encounter cell and row size limits.



File Compression

Compression     Description
Zip .zip All file formats and record layouts are available as zip files. Supported on most platforms.
Gzip .gz Only available with CSVWKT formatted files. Intended for use in Google BigQuery and other data-processing applications.