Monuments Data Dictionary

	A	B	C	D	E	F	G	H	I	J	K
1	Note: Hover over each column header for an explanation of each field.
2	Order	Field Name	Longform Name	Description	Geocoded	Required	Data Type	Expected/Allowed Values	Last Modified Date	No Longer In Use	Notes

3	1	name	Monument Name	Official name of the monument			Plain Text
4	2	fileorder	Fileorder	This is used for sorting monuments in Parks' nondigital archives. Generally, in the case of monuments named after people, the last name will come first.			Plain Text
5	3	number	Monument Number	Parks’ Monument database unique ID number			Number	Integer value
6	4	parkprop	Park Property	Denotes whether monument is on parkland. Y - Yes, N - No, O - Other (i.e. The Bronx Zoo, which is located on parkland, but operated by a non-Parks entity)			Plain Text	Y, N, O
7	5	borough	Borough	Full name of the borough monument is in			Plain Text	Manhattan, Bronx, Brooklyn, Queens, Staten Island
8	6	parkname	Park Name	Official park name in which monument is situated, if it is in a park			Plain Text
9	7	parknumber	Park Property Number	Unique ID number of park in which monument is situated, if it is in a park			Plain Text				The first letter indicates the borough the park is in. M for Manhattan, X for Bronx, B for Brooklyn, Q for Queens, R for Staten Island
10	8	commboard	Community Board	Community board monument is in			Number
11	9	council	City Council District	Council district monument is in			Number
12	10	Site, location	Location	Describes the location of the monument			Plain Text				These are stored in two separate but sometimes redundant fields in the database and have been concatenated here for clarity
13	11	extant	Extant	Denotes whether monument exists or not (i.e. Was stolen, broken etc.)			Plain Text
14	12	dedicated	Dedicated	Date or approximate date monument was dedicated, if known.			Plain Text	A variety of date formats: Month DD, YYYY; Month YYYY; YYYY; ca. YYYY			Approximate dates are noted with "ca."
15	13	cast	Cast	Date or approximate date monument was cast, if known.			Plain Text	A variety of date formats: Month DD, YYYY; Month YYYY; YYYY; ca. YYYY			Approximate dates are noted with "ca."
16	14	descrip	Description	Physical description only, does not include materials, dimensions, condition, or inscriptions. Example: "group of one female and two male figures (heroic scale) on pedestal".			Plain Text
17	15	dimen	Dimensions	Dimensions of monument			Plain Text
18	16	sponsor	Sponsor	Fiscal sponsor who holds endowment fund (if monument was sponsored and the sponsor is known)			Plain Text
19	17	materials	Materials	Material composition of monument			Plain Text
20	18	foundry	Foundry	Foundry where monument was cast (if it was cast in a foundry and that foundry is known)			Plain Text
21	19	fabricator	Fabricator	Fabricator of monument (if applicable)			Plain Text
22	20	sculptor	Sculptor	Sculptor of monument (if applicable)			Plain Text
23	21	architect	Architect	Architect of monument (if applicable).			Plain Text
24	22	donor	Donor	Donor of monument (if applicable). In most cases this entry denotes the group or organization that sponsored the monument at the time of its inception.			Plain Text
25	23	maintain	Maintenance Fund	Yes/No field indicating a maintenance endowment has been established for this monument			Plain Text
26	24	contractor	Contractor	Donors who contributed to the maintenance fund			Plain Text
27	25	inscribed	Inscription	Inscription on monument (if applicable)			Plain Text
28	27	Name2	Secondary Name	Secondary or colloquial name for monument if applicable			Plain Text
29	28	Name3	Tertiary Name	Tertiary or colloquial name for monument if applicable			Plain Text
30	29	MaintainedByParks	Maintained by Parks	Indicates whether or not the monument is maintained by parks. Y - Yes, N - No			Plain Text
31	30	Installation	Installation date	Date monument was installed			Date & Time
32	31	Rededication	Rededication date	When a monument is moved or undergoes significant restoration often times it is rededicated. This field denotes the full calendar date of rededication.			Date & Time	YYYY-MM-DD HH:MM:SS
33	32	Cost	Cost	Original cost, if more than one cost the original and replacement cost will be listed (ie. if monument was refabricated).			Number
34	33	Categories	Categories	Concatenation of all subject categories monument fits in. Used to sort monuments on Parks website.			Plain Text
35	34	X	X Coordinate	The X coordinate of the monument for mapping purposes.			Number		5/20/2019		Not all monuments in the database have been mapped - some will not have coordinates. Where they do exist, the coordinate units are Feet. The coordinate system is NAD83 / State Plane New York Long Island (ftUS) (EPSG:2263)
36	35	Y	Y Coordinate	The Y coordinate of the monument for mapping purposes.			Number		5/20/2019		Not all monuments in the database have been mapped - some will not have coordinates. Where they do exist, the coordinate units are Feet. The coordinate system is NAD83 / State Plane New York Long Island (ftUS) (EPSG:2263)
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