NYC_Parks_Inspection_Program_(PIP)_DataDictionary_UserGuide

	A	B	C
1
2	Data Dictionary for relational datasets
3	A relational database is a set of data tables which are connected to each other through primary keys and foreign keys.
4	Collection
5	Name	Parks Inspection Program (PIP)
6	Agency	NYC Parks
7	Category	City Government
8	Keywords	park inspection, PIP, OMP
9	Description	This data collection contains related datasets about the Parks Inspection Program, a comprehensive, outcome-based performance measurement system that generates frequent, random, and detailed inspections of parks and buildings.
10	Detailed Description	Trained inspectors currently perform approximately 6,000 PIP inspections each year, giving each inspected property an “Acceptable” (A) or “Unacceptable” (U) rating for overall condition and cleanliness. Individual “Acceptable” or “Unacceptable” ratings are given to as many as 17 separate park features which fall under three broad categories: cleanliness, structural, and landscape. For more information about the Parks Inspection Program, visit https://www.nycgovparks.org/park-features/parks-inspection-program.
11
12
13
14
15	Tables
16	Name	Description	Update Frequency
17	Parks Inspection Program – All Sites (MAPPED)	This dataset contains properties eligible for inspection as part of the Parks Inspection Program, and contains internal directives and comments related to the inspection process. Each row represents a property or sub-property. All of these properties have associated geometry.	Monthly
18	Parks Inspection Program – All Sites (UNMAPPED)	This dataset contains properties eligible for inspection as part of the Parks Inspection Program, and contains internal directives and comments related to the inspection process. Each row represents a property or sub-property. None of these properties have associated geometry and exist primarily for historical purposes to relate to historical inspection data.	Monthly
19	Parks Inspection Program – Conditions & Hazards	This dataset contains hazards (i.e. situations that may be potentially hazardous as well as graffiti that depicts profanity or hate speech) and conditions (i.e. unacceptable non-hazardous situations) identified during property inspections. Each row represents a single condition or hazard.	Monthly
20	Parks Inspection Program – Construction Information	This dataset contains instances of properties found to be closed or under construction during an inspection. Each row represents a single inspection.	Monthly
21	Parks Inspection Program – Public Restrooms	This dataset contains public restrooms eligible for inspection, and identifies extended public restroom closures. Each row represents a single public restroom.	Monthly
22	Parks Inspection Program – Public Restroom Conditions & Hazards	This dataset contains hazards (i.e. situations that may be potentially hazardous as well as graffiti that depicts profanity or hate speech) and conditions (i.e. unacceptable non-hazardous situations) identified during public restroom inspections. Each row represents a single condition or hazard.	Monthly
23	Parks Inspection Program – Public Restroom Inspections	This dataset contains overall ratings associated with public restroom inspections (similar to the "Inspections" table). Each row represents a single inspection.	Monthly
24	Parks Inspection Program – Public Restroom Room Inspections	This dataset contains overall condition ratings for public restroom rooms and counts of room amenities/items. Each row represents a single room inspection.	Monthly
25	Parks Inspection Program – Public Restroom Feature Ratings	This dataset contains ratings for inspected public restroom features. Each row represents a rating for a single feature.	Monthly
26	Parks Inspection Program – Daily Immediate Attentions	This dataset contains immediate attention hazards.that were communicated to maintenance staff, and the resolution information they entered in response.	Monthly
27	Parks Inspection Program – Element Tracking	This dataset contains additional items that are counted, and in some cases evaluated during a property inspection. Examples include signs, flags and drinking fountains. Each row represents a single observation.	Monthly
28	Parks Inspection Program – Feature Ratings	This dataset contains ratings for inspected property features. Each row represents a rating for a single feature	Monthly
29	Parks Inspection Program – Inspections	This dataset contains overall ratings associated with property inspections. Each row represents an individual inspection.	Monthly
30	Parks Inspection Program – Inventory	This dataset contains property features by type and category. Each row represents a single feature.	Monthly
31	Parks Inspection Program – PIP Plus	This dataset contains additional quality of experience issues observed during property inspections. Each row represents a single issue.	Monthly
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100