Global Parcel Schemas

Field	Description	Datatype
`ogc_fid`	Object ID	serial primary key
`admin0`	Country Code - The ISO 3166-1 alpha-2 country code. Examples: US, CA, GT	text
`geoid`	County/Census Division ID number - Indicates the ID number of an admin2-equivalent boundary	text
`parcelnumb`	Parcel ID - The assessor's primary parcel identification number or code. Examples: 02004940, 001-020-4624-001	text
`parcelnumb_no_formatting`	Parcel ID without Formatting - The primary parcel identification number with spaces and formatting characters removed. Examples: 02004940, 0010204624001	text
`alt_parcelnumb1`	First Alternative Parcel ID - An assessor-provided additional or alternative parcel identification number. Examples: 02004940, 001-020-4624-001	text
`alt_parcelnumb2`	Second Alternative Parcel ID - An assessor-provided additional or alternative parcel identification number. Examples: 02004940, 001-020-4624-001	text
`alt_parcelnumb3`	Third Alternative Parcel ID - An assessor-provided additional or alternative parcel identification number. Examples: 02004940, 001-020-4624-001	text
`address`	Parcel Address - The address of the parcel itself, also called the "situs address" or "site address". Not every parcel has a street address, especially in agricultural areas. Examples: 170 SUMACH STREET	text
`address2`	Parcel Address Second Line	text
`saddno`	Parcel Address Number. Examples: 12109	text
`saddpref`	Parcel Address Prefix. Examples: N	text
`saddstr`	Parcel Address Street Name. Examples: GLENN	text
`saddsttyp`	Parcel Address Street Type. Examples: RD	text
`saddstsuf`	Parcel Address Street Suffix. Examples: NW	text
`sunit`	Parcel Address Unit. Examples: Apt 2, Unit B, 6th floor	text
`scity`	Parcel Address City. Examples: GRASS LAKE	text
`postcode`	Parcel Address Postal Code. Examples: M5A 0C3	text
`original_address`	Original Parcel Address - Parcel address fields as originally provided by the county, encoded as a JSON object. Examples: `{"address" => "170 SUMACH STREET", "saddno" => "170", "saddstr" => "SUMACH", "scity" => "TORONTO", "postcode" => "M5A 0C3"}`	text
`admin1`	Parcel Address Province. Examples: QC	text
`admin2`	Administrative boundary beneath the subnational	text
`admin3`	Census Subdivision - Used for organizational purposes. Refer to scity for the city associated with the site address. Below a county/census_division, equivalent to a city in most places.	text
`reserve`	Indigenous-Administered Land Flag - Used to indicate when a parcel is administered directly by a First Nation or other Indigenous group	text
`lat`	Latitude - On parcel centroid latitude decimal coordinate	text
`lon`	Longitude - On parcel centroid longitude decimal coordinate	text
`ll_last_refresh`	Last County Refresh Date - The last date Regrid refreshed the data from the county	date
`ll_gissqm`	Regrid Calculated Parcel Square Meters - Parcel square meters as calculated by Regrid from the parcel geometry	double precision
`path`	Parcel Path - Regrid's human-readable identifier for this parcel. Not guaranteed to be stable between updates. Examples: /us/mi/wayne/detroit/123, /us/ny/new-york/manhattan/375553	text
`ll_stable_id`	Stable ID Status - Indicates if the path and ll_uuid values have changed during the last refresh from the county. A value of 'preserved' means the ll_uuid was matched during county refresh to the previous data. A null indicates a new ll_uuid was generated because the new data was not matched to existing data.	text
`ll_uuid`	Regrid UUID - Uniquely identifies a single parcel with a v4 uuid. A stable parcel id across county data refreshes. This field should be used for tracking individual parcels. Examples: 4cc9eda6-883c-4f38-9a07-b44900a64b16	uuid
`ll_stack_uuid`	Parcel Stack UUID - Uniquely identifies a group of parcels with exact duplicate geometries using one stack member parcel's ll_uuid assigned to all parcels in the stack. Examples: 4cc9eda6-883c-4f38-9a07-b44900a64b16	text
`ll_row_parcel`	Regrid Right-of-Way Parcel Flag - Identifies a parcel as being a likely right-of-way parcel (roads, streetsets, railways, utilities, rivers, etc.). Examples: parcel_number, land_use, perimeter_ratio, hull_ratio	text
`ll_updated_at`	Last Modified - Timestamp of the last modification of any kind to this row. Examples: 2019-06-06 12:45:21.285102-04	timestamp with time zone