Regrid Data Dictionary - All Product Schemas

	A	B	C	D	E	F	G	H	I
1	Regrid Parcel Record Schema						Current version:	16.0
2	Column Name	Shapefile Name	Type	Premium	Standard	Examples	Description	First Seen	Seq

3	ogc_fid		serial primary key	✔	✔		object ID - Not unique across counties, not persistant over time, use 'll_uuid' preferably below.	1.0	1
4	geoid		text	✔	✔	06205	A 5 digit county id number, consisting of the 2 digit FIPS state code + the 3 digit FIPS county code.	1.0	2
5	parcelnumb		text	✔	✔	2004940	Parcel ID/Parcel Number	1.0	3
6	parcelnumb_no_formatting	parcelnu_1	text	✔	✔	XH0118ROAD00	This is the county-provided 'parcelnumb' schema attribute, but has all non A-Z and 0-9 characters removed. It is intended to make searching and matching on county parcel number, PIN, or APN easier as formatting and spacing can vary. Please note that sometimes formatting and spacing is required to make parcel numbers unique and as a result this attribute is more likely to have duplicate parcel numbers, it should be used as a last resort for matching.	10.0	4
7	state_parcelnumb	state_parc	text	✔	✔	22051-0600003127	Statewide parcel identification number. Collected where available from states that provide a statewide parcel ID.	13.0	5
8	account_number	account_nu	text	✔	✔	01234X	The assessor or tax collector's account identification number for a property.	13.0	6
9	tax_id		text	✔	✔	87642-2002	The assessor or tax collector's tax identification number for a property.	13.0	7
10	alt_parcelnumb1	alt_parcel	text	✔	✔	RA0580030000	A county-provided parcel id number that is not considered to be the primary parcel id number used by the county, but is also used as a parcel id in some contexts. These could be previously used parcel numbers, map numbers, online system id numbers, etc. It is provided in this schema attribute for easy, consistent access, but is also duplicated as a county specific custom column to retain its original, county-provided attribute name.	10.0	8
11	alt_parcelnumb2	alt_parc_1	text	✔	✔	RA0580030000	A county-provided parcel id number that is not considered to be the primary parcel id number used by the county, but is also used as a parcel id in some contexts. These could be previously used parcel numbers, map numbers, online system id numbers, etc. It is provided in this schema attribute for easy, consistent access, but is also duplicated as a county specific custom column to retain its original, county-provided attribute name.	10.0	9
12	alt_parcelnumb3	alt_parc_2	text	✔	✔	RA0580030000	A county-provided parcel id number that is not considered to be the primary parcel id number used by the county, but is also used as a parcel id in some contexts. These could be previously used parcel numbers, map numbers, online system id numbers, etc. It is provided in this schema attribute for easy, consistent access, but is also duplicated as a county specific custom column to retain its original, county-provided attribute name.	10.0	10
13	usecode		text	✔	✔	104	Parcel Use Code	1.0	11
14	usedesc		text	✔	✔	Residential	Parcel Use Description	1.0	12
15	zoning		text	✔	✔	R-1	Governing municipality's zoning code	2.0	13
16	zoning_description	zoning_des	text	✔	✔	Residential	Governing municipality's zoning code description	2.0	14
17	zoning_type	zoning_typ	text	✔		Residential	A standardized zoning type	14.0	15
18	zoning_subtype	zoning_sub	text	✔		Single-family	A standardized zoning subtype	14.0	16
19	zoning_code_link	zoning_cod	text	✔		http://mohavecounty-az.elaws.us/code/coor_ptii_sec11	Direct link to the municipality's zoning code	14.0	17
20	zoning_id		integer	✔		5656	ID for the zoning area for matching to the full Regrid zoning add-on product	14.0	18
21	struct		boolean	✔	✔		Structure On Parcel	1.0	19
22	structno		integer	✔	✔		Number of Structures on Parcel	1.0	20
23	yearbuilt		integer	✔	✔		Structure Year Built	1.0	21
24	year_built_effective_date	year_built	integer	✔	✔	1980	Year built adjusted by the assessor to account for building condition and major structural changes. May be the year of the most recent major addition or renovation.	16.0	22
25	numstories		double precision	✔	✔		Number of Stories - Can be fractional like 1.5 stories	1.0	23
26	numunits		integer	✔	✔		The number of individual living units, apartments or condominiums on a parcel.	1.0	24
27	numrooms		double precision	✔	✔	2.5	The number of rooms in the parcel's primary structure as recorded in county records.	13.0	25
28	num_bath		double precision	✔	✔	3	The total number of bathrooms. Include partial bathrooms. Value may be interpreted.	16.0	26
29	num_bath_partial	num_bath_p	double precision	✔	✔	2	The total number of partial bathrooms as understood by common real estate definition.	16.0	27
30	num_bedrooms	num_bedroo	integer	✔	✔	4	The total number of bedrooms.	16.0	28
31	structstyle	structstyl	text	✔	✔		Structure Style	1.0	29
32	parvaltype		text	✔	✔	Appraised, Assessed, Taxable, Market, Market Value	Parcel Value Type - Describes the type or the method the Assessor used to determine and record the values in the parcel value attributes below	1.0	30
33	improvval		double precision	✔	✔		Improvement Value - in US Dollars (from Assessor's data)	1.0	31
34	landval		double precision	✔	✔		Land Value - in US Dollars (from Assessor's data)	1.0	32
35	parval		double precision	✔	✔		Total Parcel Value - in US Dollars (from Assessor's data)	1.0	33
36	agval		double precision	✔	✔		Agricultural Value - in US Dollars (from Assessor's data)	1.0	34
37	homestead_exemption	homestead_	text	✔		homeowner	A county-provided indicator that the parcel is eligible for county-provided exemptions for homeowners / owner occupied structures / homestead tax exemptions.	10.0	35
38	saleprice		double precision	✔	✔		Last Sale Price - in US Dollars (from Assessor's data)	1.0	36
39	saledate		date	✔	✔		Last Sale Date (from Assessor's data)	1.0	37
40	taxamt		double precision	✔	✔		Annual Tax Bill - in US Dollars (from Assessor's data)	1.0	38
41	taxyear		text	✔	✔	2020	The county provided year the tax related values apply to. When the county specifies a tax year or assessor's tax year, we record it in this attribute.	8.0	39
42	last_ownership_transfer_date	last_owner	date	✔	✔	2021-11-01	Date of the most recent ownership transfer. This includes all ownership transfer types including items such as non-arms-length transfers (ex. Parent to child non-sale) which would not be reflected in as a most recent sale date.	16.0	40
43	owntype		text	✔	✔		Owner Type	1.0	41
44	owner		text	✔	✔		Owner Name	1.0	42
45	unmodified_owner	unmodified	text	✔	✔		Owner name before any standardization of punctuation and common government owners, or other details, are modified in any manner.	15.0	43
46	ownfrst		text	✔	✔		Owner First Name (note field name uses "frst" instead of first.)	1.0	44
47	ownlast		text	✔	✔		Owner Last Name	1.0	45
48	owner2		text	✔	✔	Rosalind Franklin	Second owner's name	2.0	46
49	owner3		text	✔	✔	Ada Lovelace	Third owner's name	2.0	47
50	owner4		text	✔	✔	Barbara McClintock	Fourth owner's name	2.0	48
51	previous_owner	previous_o	text	✔	✔	Johnson, Katherine	The previous owner or grantor of a parcel.	13.0	49
52	mailadd		text	✔	✔	402 S FIFTH AVE	Parcel Mailing Address - This is the address where the tax and other assessor's communications are sent. It is often thought of as the owner's mailing address. It is often the same address as the parcel physical street address, but very commonly it is a different address than the parcel address itself.	1.0	50
53	mail_address2	mail_addre	text	✔	✔		Mailing address second line	2.0	51
54	careof		text	✔	✔	MIKE SMITH	Parcel Mailing Address Care Of	3.0	52
55	mail_addno		text	✔	✔	402	Mailing address street number	2.0	53
56	mail_addpref	mail_addpr	text	✔	✔	S	Mailing address street prefix	2.0	54
57	mail_addstr	mail_addst	text	✔	✔	FOURTH	Mailing address street name	2.0	55
58	mail_addsttyp	mail_add_1	text	✔	✔	AVE	Mailing address street type	2.0	56
59	mail_addstsuf	mail_add_2	text	✔	✔	NW	Mailing address street suffix	2.0	57
60	mail_unit		text	✔	✔	APT # 2	Mailing address unit number	2.0	58
61	mail_city		text	✔	✔	Ann Arbor	Mailing address city	2.0	59
62	mail_state2	mail_state	text	✔	✔	MI	Mailing address state	2.0	60
63	mail_zip		text	✔	✔	48103; 48104-3423	Mailing address zip code	2.0	61
64	mail_country		text	✔	✔	US, Indonesia, Canada	Mailing address country	7.0	62
65	mail_urbanization	mail_urban	text	✔	✔	Caguas	Mailing Urbanización (Puerto Rico)	2.0	63
66	original_mailing_address	original_m	text (jsonb)	✔	✔		Owner mailing address fields as originally provided by the county, encoded as a JSON object. Generated before any cleaning steps are done.	15.0	64
67	address		text	✔	✔	12109 KATZ RD	Parcel Physical Street Address - This is the address of the parcel itself. Not every parcel has a street address, especially in agricultural areas and other large parcels. Also called the "situs address" or "site address".	1.0	65
68	address2		text	✔	✔	George's Ice Cream Shoppe	Additional street address details	2.0	66
69	saddno		text	✔	✔	12109	Parcel Address Number	1.0	67
70	saddpref		text	✔	✔	N	Parcel Address Prefix	1.0	68
71	saddstr		text	✔	✔	GLENN	Parcel Address Street Name	1.0	69
72	saddsttyp		text	✔	✔	RD	Parcel Address Street Type	1.0	70
73	saddstsuf		text	✔	✔	NW	Parcel Address Street Suffix	1.0	71
74	sunit		text	✔	✔	Apt 2, Unit B	Parcel Address Unit	1.0	72
75	scity		text	✔	✔	GRASS LAKE	Parcel Address City	1.0	73
76	original_address	original_a	text	✔	✔	{"address":"12340 REID RD","saddno":"123400","saddstr":"REID RD","scity":"DURAND","szip":"48429"}	Parcel Address fields as originally provided by the county, encoded as a JSON object. This field was originally separated by a semicolon and a space and data will exist in that format as a migration happens over time.	2.0	74
77	city		text	✔	✔	woodstock	US Census County Subdivision - https://www2.census.gov/geo/pdfs/reference/GARM/Ch8GARM.pdf. Used for organizational purposes. Refer to scity for the city associated with the site address.	1.0	75
78	county		text	✔	✔	Livingston	Parcel Address County	1.0	76
79	state2		text	✔	✔	MI	Parcel Address State	1.0	77
80	szip		text	✔	✔	48137-2300	Parcel Address Zip Code	1.0	78
81	szip5		text	✔	✔	48137	5 Digit Parcel Zip Code	13.0	79
82	urbanization	urbanizati	text	✔	✔	Caguas	Site Urbanización (Puerto Rico)	2.0	80
83	ll_address_count	ll_address	integer	✔		8	A count of all the addresses we know of existing on a parcel. This includes the primary situs address and all the secondary or unit based addresses in our matched secondary address dataset. It is similar to the county provided 'numunits' in our schema, but calculated by us based on our nationwide address dataset from our address partner.	10.0	81
84	location_name	location_n	text	✔	✔	Briarwood Mall	A name commonly associated with this parcel	2.0	82
85	address_source	address_so	text	✔	✔	openaddresses;cass;county;ZCTA	Primary source of the address data for the parcel record. Default source if none is listed is the county.	2.0	83
86	legaldesc		text	✔	✔		Legal Description	1.0	84
87	plat		text	✔	✔	A	Plat number the parcel is recorded on	2.0	85
88	book		text	✔	✔	231	Book/Liber the parcel is recorded in	2.0	86
89	page		text	✔	✔	2	Page/Folio the parcel is recorded on	2.0	87
90	block		text	✔	✔		Parcel block	2.0	88
91	lot		text	✔	✔		Parcel lot	2.0	89
92	neighborhood	neighborho	text	✔	✔	Old West Side	Neighborhood name	2.0	90
93	neighborhood_code	neighbor_1	text	✔	✔		An alpha numeric code labeled from the source as a neighborhood code	15.0	91
94	subdivision	subdivisio	text	✔	✔		Subdivision	1.0	92
95	lat		text	✔	✔	42.266421	Decimal latitude coordinate (EPSG:4326). Guaranteed to be a point within the parcel. Usually this is the center or "centroid" of the parcel. When the center of the parcel is not actually in the parcel boundary, we move the point to the parcel itself.	8.0	93
96	lon		text	✔	✔	-83.747204	Decimal longitude coordinate (EPSG:4326). Guaranteed to be a point within the parcel. Usually this is the center or "centroid" of the parcel. When the center of the parcel is not actually in the parcel boundary, we move the point to the parcel itself.	8.0	94
97	fema_flood_zone	fema_flood	text	✔		A	FEMA Flood Zone per the Flood Insurance Rate Map (FIRM). Zones beginning with A or V represent the highest level of flood risk. More info here: https://www.fema.gov/glossary/flood-zones	13.0	95
98	fema_flood_zone_subtype	fema_flo_1	text	✔		1 PCT ANNUAL CHANCE FLOOD HAZARD CONTAINED IN STRUCTURE	FEMA Flood Zone Subtype per the Flood Insurance Rate Map (FIRM) providing specific details around the associated Flood Zone.	13.0	96
99	fema_flood_zone_raw	fema_flo_2	text	✔		[{"zone":"A","subtype":"1 PCT ANNUAL CHANCE FLOOD HAZARD CONTAINED IN STRUCTURE","percent":0.18},{"zone":"A","subtype":"RIVERINE FLOODPLAIN IN COASTAL AREA","percent":0.04},{"zone":"X","subtype":"AREA OF MINIMAL FLOOD HAZARD","percent":0.29}]	JSON field containing more complex details related to the Flood Zone specifically in instances where multiple Flood Zones are associated with a property.	13.0	97
100	fema_flood_zone_data_date	fema_flo_3	date	✔		2023-09-01	The Effective Date of the Flood Insurance Rate Map (FIRM) for the associated Flood Zone and property.	13.0	98