_id	Name	fieldName	fieldDescription	dataType	dataFormat	length	uniqueID	permittedValues	fieldPublicAccessLevel	fieldPublicAccessLevelComment
1	Description	Field name	Description of the data field	Data type (text, numeric, boolean, etc.)	Special details related to data format (number of decimal places, date format, etc.	Field length	Does this field contain a unique ID or primary key?	Describes values permitted to be included in this field, if applicable	Describes if this field is subject to any public access limitations (public, sensitive, private)	An explanation for the field's selected “accessLevel” including instructions for how to access a restricted file, if applicable, or explanation for why a “non-public” or “restricted public” data asset is not “public,” if applicable. Also note options for making the data public, where appropriate, including obfuscation, aggregation, or anonymization.
2	Required	Y	Y	N	N	N	N	N	N	N
3	""	id	Automatically generated request ID	text	""	""	Yes	""	""	""
4	""	type	Type of Permit	text	""	""	""	""	""	""
5	""	open_date	Day permit was issued	date	YYYY-MM-DD	""	""	""	""	""
6	""	from_date	Date valid from	date	YYYY-MM-DD	""	""	""	""	""
7	""	to_date	Date valid to	date	YYYY-MM-DD	""	""	""	""	""
8	""	restoration_date	Date street must be restored (if applicable)	date	YYYY-MM-DD	""	""	""	""	""
9	""	description	Description of work	text	""	""	""	""	""	""
10	""	full_address	Primary address of the permit work	text	""	""	""	""	""	""
11	""	location	Location of work	text	""	""	""	""	""	""
12	""	from_street	Street from	text	if applicable	""	""	""	""	""
13	""	to_street	Street to	text	if applicable	""	""	""	""	""
14	""	business_name	Licensesed Contractor Name	text	if applicable	""	""	""	""	""
15	""	license_type	License Type	text	if applicable	""	""	""	""	""
16	""	latitude	longitude coordinate of primary address	double	""	""	""	""	""	""
17	""	longitude	latitude coordinate of primary address	double	""	""	""	""	""	""
18	""	from_lat	longitude coordinate of Street from	double	if applicable	""	""	""	""	""
19	""	from_lon	latitude coordinate of Street from	double	if applicable	""	""	""	""	""
20	""	to_lat	longitude coordinate of Street to	double	if applicable	""	""	""	""	""
21	""	to_lon	latitude coordinate of Street to	double	if applicable	""	""	""	""	""