From a 500-row sample across 39 columns.
boroughnameboroughlocationborough:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer+3boroughlocation:@computed_region_92fq_4b7q+3Mappable — Socrata point column `shape`.
Open on the map →| name | number | parkprop | borough | parknumber | commboard | council | location | extant | dedicated | descrip | dimen |
|---|---|---|---|---|---|---|---|---|---|---|---|
| John F. Kennedy Memorial Bust (original) | 2212 | Y | Manhattan | M010 | 8 | 6 | The Arsenal, Office of General Counsel, 3rd Floor | Y | 1965-01-01 00:00:00 | Bronze bust | 25" H x 26" W x 14" D |
| Fort Greene Park Cannons |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
name | text | Official name of the monument | 0% | EaglesChristopher ColumbusUnisphere Tablets (4) |
fileorder | text | 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. | 48% | eagles (8)Columbus, ChristopherWashington, George |
number | integer | Parks’ Monument database unique ID number | 0% | 4262971598 |
parkprop | categorical | 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) | 0% |
GET /api/datasets/6rrm-vxj9 GET /api/datasets/6rrm-vxj9/quality GET /api/datasets/6rrm-vxj9/related GET /api/columns?dataset=6rrm-vxj9
boroughlocationboroughnamesystemboroughlocationname| 2111 |
| Y |
| Brooklyn |
| B032 |
| 2 |
| 35 |
| Visitor Center |
| Y |
| — |
| Two cannons |
| — |
| Lin Ze Xu | 1979 | N | Manhattan | M246 | 3 | 1 | Lin Ze Xu Square, East Broadway at Chatham Square | Y | 1999-01-01 00:00:00 | Over life-size portrait statue on pedestal | 18' 5" H, |
| Frank and Constantine Busso | 1978 | Y | Staten Island | R127 | 1 | 49 | Forest Avenue, Goethals Road North; northwest corner of park | Y | 1996-11-16 00:00:00 | Two inscribed markers in ground in front of two cement plinths with blue anchors in relief | — |
| Robert R. Pellicane | 1967 | Y | Queens | QZ36A | — | — | 193rd Street and Hillside Avenue | Y | 1957-01-01 00:00:00 | Shield-shaped plaque attached to flagpost | — |
| John Wolfe Ambrose | 1938 | Y | Manhattan | M005 | 1 | 1 | South side of State Street between Pearl and Water Streets. | Y | 1936-06-03 00:00:00 | Stele with bust | H: 10' W: 6'2" D: 10"; Bust H: 2'3" |
| Lawrence Entrance | 1990 | Y | Queens | Q099 | 15 | 21 | East side of park, under Van Wyck Expressway overpass, near Lawrence Street and 57th Road | Y | — | 2 upright triangular stele; one has incised painted inscription | — |
| Foley Square Medallions | 1910 | Y | Manhattan | M030 | 1 | 1 | — | Y | 2000-10-01 00:00:00 | Five medallions embedded at different locations in the walkways | Diameter: 2 meters (each) |
| Winfield Memorial | 1711 | Y | Queens | QT21 | 2 | 26 | 65th Place and Laurel Hill Boulevard | Y | 1926-01-01 00:00:00 | Standing female figure (over life-size) on pedestal | Figure H: 7'4" W: 2'1" D: 2'1"; Pedestal H: 4' W: 3'5" D: 3'5" |
| Woodside Doughboy | 1731 | Y | Queens | Q031A | — | 26 | Woodside and Roosevelt Avenues, 39 Road and 52 Street | Y | 1923-01-01 00:00:00 | Figure (over life-size) on pedestal | Figure H: 7'2"; Pedestal H: 4'11½ W: 3'11" D: 3'11" |
Showing 12 of 34 columns. All of them are listed below.
YNOof 3 |
borough | categorical | Full name of the borough monument is in | 2% | ManhattanBrooklynQueensof 7 |
parkname | text | Official park name in which monument is situated, if it is in a park | 22% | Central ParkProspect ParkRiverside Park |
parknumber | text | Unique ID number of park in which monument is situated, if it is in a park | 2% | M010B073M071 |
commboard | integer | Community board monument is in | 2% | 7.01.02.0 |
council | integer | Council district monument is in | 2% | 6.01.03.0 |
location | text | Describes the location of the monument | 6% | Central Park Wildlife Ce…Flower GardenSouth end of Mall |
extant | categorical | Denotes whether monument exists or not (i.e. Was stolen, broken etc.) | 0% | YNSof 5 |
dedicated | text | Date or approximate date monument was dedicated, if known. | 12% | 194119391925 |
cast | text | Date or approximate date monument was cast, if known. | 51% | 20251892ca. 1994 |
descrip | text | Physical description only, does not include materials, dimensions, condition, or inscriptions. Example: "group of one female and two male figures (heroic scale) on pedestal". | 0% | PlaqueTabletPlaque on plinth |
dimen | text | Dimensions of monument | 16% | H: 4'10" W: 5'2" D: 2'1"see memoH: 16 ½" W: 18" |
sponsor | text | Fiscal sponsor who holds endowment fund (if monument was sponsored and the sponsor is known) | 80% | CPCMASCPF Endowment |
materials | text | Material composition of monument | 1% | BronzeBronze, graniteGranite |
foundry | text | Foundry where monument was cast (if it was cast in a foundry and that foundry is known) | 76% | Modern Art FoundryU.S. Bronze Sign Company…Roman Bronze Works |
fabricator | text | Fabricator of monument (if applicable) | 84% | A. Ottavino Corp.New Project, vanessa ger…Soapstone Studios, Brook… |
sculptor | text | Sculptor of monument (if applicable) | 53% | Frederick William MacMon…Rochette and ParziniJohn Quincy Adams Ward |
architect | text | Architect of monument (if applicable). | 72% | Stanford WhiteAymar Embury IIThomas Hastings |
donor | text | 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. | 25% | GiftPublic subscriptionPurchase |
maintain | categorical | Yes/No field indicating a maintenance endowment has been established for this monument | 98% | YM145-106MNof 3 |
contractor | text | Donors who contributed to the maintenance fund | 96% | maintenance endowment to…$100,000; fund establish…$10,000 contributed by B… |
name2 | text | Secondary or colloquial name for monument if applicable | 90% | Untitled #1Revolutionary War CannonAnne Loftus Playground P… |
name3 | categorical | Tertiary or colloquial name for monument if applicable | 100% | Ft. Clinton CannonsRockaway Memorialof 2 |
maintainedbyparks | categorical | Indicates whether or not the monument is maintained by parks. Y - Yes, N - No | 0% | YNof 2 |
installation | datetime | Date monument was installed | 96% | 2008-06-01T00:00:00.0001964-08-01T00:00:00.0001985-05-17T00:00:00.000 |
rededication | datetime | When a monument is moved or undergoes significant restoration often times it is rededicated. This field denotes the full calendar date of rededication. | 97% | 2006-11-16T00:00:00.0002001-11-01T00:00:00.0001983-10-08T00:00:00.000 |
cost | text | Original cost, if more than one cost the original and replacement cost will be listed (ie. if monument was refabricated). | 79% | full commission amount: …$50,00020000.00 |
categories | text | Concatenation of all subject categories monument fits in. Used to sort monuments on Parks website. | 27% | World War I, War Memoria…World War II, War Memori…Revolutionary War, War M… |
inscribed | text | Inscription on monument (if applicable) | 100% | — |
x | numeric | The X coordinate of the monument for mapping purposes. | 100% | — |
y | numeric | The Y coordinate of the monument for mapping purposes. | 100% | — |