﻿_id	Name	fieldName	fieldDescription	fieldDescription_2	dataFormat	length	uniqueID	permittedValues	fieldPublicAccessLevel	fieldPublicAccessLevelComment
1	Description	Field name	Description of the data field	Description of the data field	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	Y	N	N	N	N	N	N
3		id	Unique Identifier	numeric			Y			
4		name	Capital Project Name	text						
5		task_description	Description Capital Project	text						
6		area	Functional area of project	text						
7		budgeted_amount	Amount budgeted for project	text						
8		status	Status of project	text						
9		asset_id	Name of asset that is the focus of the project	text						
10		asset_type	Type of asset for the project	text						
11		fiscal_year	Fiscal year in which the project was budgeted for	numeric		4 digits				
12		neighborhood	Neighborhood(s) where the capital project is located (when applicable)	text						
13		council_district	Council district(s) where the capital project is located	text						
14		ward	Ward(s) where the capital project is located	text						
15		tract	Tract(s) number of the capital project's location	text						
16		public_works_division	Public Works Division(s) where the capital project is located	text						
17		pli_division	Permits, Licenses & Inspection Division(s) where the capital project is located	text						
18		police_zone	Police Zone(s) where the capital project is located	text						
19		fire_zone	Fire Zone(s) where capital project is located	text						
20		latitude	Latitude	float						
21		longitude	Longitude	float						
