Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Facilities Database

ji82-xba5City Government38 columns
The Department of City Planning aggregates information about 30,000+ facilities and program sites that are owned, operated, funded, licensed, or certified by a City, State, or Federal agency in the City of New York into a central database called the City Planning Facilities Database (FacDB). These facilities generally help to shape quality of life in the city's neighborhoods, and this dataset is the basis for a series of planning activities. This public data resource allows all New Yorkers to understand the breadth of government resources in their neighborhoods. The data is also complemented with a new interactive web map that enables users to easily filter the data for their needs. Users are strongly encouraged to read the database documentation, particularly with regard to analytical limitations. Questions about this database can be directed to dcpopendata@planning.nyc.gov . All previously released versions of this data are available on the DCP Website: BYTES of the BIG APPLE . Current version: 26v1
View on NYC Open Data↗

Quality

A90.8 / 100

From a 500-row sample across 38 columns.

completeness94/ 25% weight
consistency79/ 20% weight
accuracy98/ 20% weight
timeliness92/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • NYC Zoning Tax Lot Database0.35
    joins onbbl
  • Expense Budget0.35
  • NYC Historical Vital Records: Index to Digitized Death Certificates0.34
  • City Council Discretionary Funding0.32
    joins onlatitudelongitudebbl+3
  • Register of Community Board Budget Requests0.32
    joins onborolatitudelongitude+2
  • Parking Violations Issued - Fiscal Year 2027

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

uidfacnameaddresscityboroborocodezipcodelatitudelongitudexcoordycoordbin
00041e822a3da19f11cb931f6b25b13f560 W 43RD STREET PARKING CORP555 WEST 42 STREETNEW YORKMANHATTAN11003640.760963-73.997607984912.926264216516.0729221026911
0004a8532521d7d9879f82f67f7fb2e5SIXTEEN SYCAMORES PLAYGROUND

Columns

38 queryable · 38 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
uidtextUniversal Unique Identifier. When a row is added to the table the UID is automatically generated, enabling database replication.0%25e36239820b6e03e3c4ca80…1361718d561f644dc630c885…69ab3e85a384efe4628e87d5…
facnametextThe name of the facility in proper case.0%SP PLUS CORPORATIONPARKOFFICES
addressnumtextThe address number of where the facility is located, validated by GeoClient. If the address that is available for the site is not complete with an address number (only the street name), this field is left blank.25%100180
streetnametextThe name of the street where the facility is located, validated by GeoClient. If the address that is available for the site is not complete with an address number (only the street name), this field is left blank.

Query this from your own app

GET /api/datasets/ji82-xba5
GET /api/datasets/ji82-xba5/quality
GET /api/datasets/ji82-xba5/related
GET /api/columns?dataset=ji82-xba5
0.32
  • Parking Violations Issued - Fiscal Year 20140.31
  • Construction Demolition Registrants0.31
    joins onborolatitudelongitude+4
    • 358 SCHERMERHORN STREET
    BROOKLYN
    BROOKLYN
    3
    11217
    40.6865328767
    -73.9803003792
    989713.430527
    189399.483947
    3000575
    00056520e4c5483e13933cda8c8a736dMARKS JCH OF BENSONHURST DAY CAMP7802 BAY PARKWAYBROOKLYNBROOKLYN31121440.6063763817-73.9897520942987095.538251160195.8266573162352
    0005a5ab702b05d9c4337e743af7d26dPOWELL PLAYGROUND289 PITKIN AVENUEBROOKLYNBROOKLYN31121240.6712673544-73.90484269091010646.66383183851.5379470
    0005cf2135820de8d20395875ca0e506CENTER FOR JEWISH HISTORY15 WEST 16 STREETNEW YORKMANHATTAN11001140.7380713971-73.993804173985967.002972208175.9767351080631
    0005d3c51109b7d8d06a3942c267b95aG.V.C. LTD. (B2192)1396 COMMERCE AVEBRONXBRONX21046140.8382717188-73.84152469871028101.0244722.00
    00076593b6e70e9240d456da810a506bLEESEL TRANSPORTATION CORP (B2192)3900 WEBSTER AVENUEBRONXBRONX21047040.8885524241-73.8669847811021028.24162263029.4726312118629
    0008a139fbb4c4d09b5e0a4a5289f5c9MOUSE INC154 WEST 93 STREETNEW YORKMANHATTAN11002540.791469873-73.9709730943992287.561319227632.0752671032522
    0008d89ab4fda4d4e7e7b844098704fbGLENWOOD ROAD HEAD START3017 GLENWOOD ROADBROOKLYNBROOKLYN31121040.6342843773-73.9470930188998934.551193170367.7135373113939
    000961f714aac4560e19d13dc1398a79LINCOLN MEDICAL & MENTAL HEALTH CTR. ADULT GERIATRIC CLINIC234 EAST 149 STREETBRONXBRONX21045140.8170688541-73.92450355251005146.95487236966.3590272097050

    Showing 12 of 38 columns. All of them are listed below.

    24%
    BROADWAYJAMAICA AVENUEQUEENS BOULEVARD
    addresstextThe concatenated value of AddressNumber and StreetName of where the facility is located. If there is not a valid, complete address available, any location description that was provided is included in this field.9%1130 GRAND CONCOURSE800 EAST GUN HILL ROAD120-55 QUEENS BOULEVARD
    citytextThe USPS preferred name of the addressed city where the facility is located. Generated by GeoClient and spatial joins. This field contains some blanks for facilities that do not overlap with the shoreline Zip Code boundaries.1%NEW YORKBROOKLYNBRONX
    borocategoricalThe full name the borough the facility is within.0%MANHATTANBROOKLYNQUEENSof 5
    borocodecategoricalThe number value representing the borough the facility is within.0%134of 6
    zipcodetextThe ZIP Code the facility is within. This field contains some blanks for facilities that do not overlap with the shoreline Zip Code boundaries.1%112011000211207
    latitudefloatThe latitude of the location either calculated using the coordinates in the source data or provided by GeoClient.0%0.040.753625181140.808761484
    longitudefloatThe longitude of the location either calculated using the coordinates in the source data or provided by GeoClient.0%0.0-73.9919065887-73.9489296715
    xcoordfloatThe X coordinate of the location either calculated using the coordinates in the source data or provided by GeoClient.0%0.0986492.342669998387.720085
    ycoordfloatThe Y coordinate of the location either calculated using the coordinates in the source data or provided by GeoClient.0%0.0213842.760813233934.803456
    binintegerThe BIN values for the buildings the facility is located in. This field contains blanks, because 1) some lots do not have buildings on them, and 2) some lots have multiple buildings and a single BIN could not be reliably assigned given the information provided in the source data.0%010836241058640
    bblintegerThe BBL values for the tax lots the facility is located on. This field contains blanks, because some facility categories, like pedestrian plazas are not located on tax lots.0%0.01007860001.01013730001.0
    cdintegerThe Community District the facility is within. This field contains blanks because the Community District boundaries do not capture facilities beyond the shoreline.0%105302101
    councilintegerThe City Council District the facility is within0%138
    ct2010textThe 2010 U.S. Census Tract the facility is within2%002100000900000700
    ct2020textThe 2020 U.S. Census Tract the facility is within2%002100000900004300
    nta2010textThe 2010 Neighborhood Tabulation Area (NTA) the facility is within. This field contains blanks because the NTA boundaries do not capture facilities beyond the shoreline.2%MN17MN13MN25
    nta2020textThe 2020 Neighborhood Tabulation Area (NTA) the facility is within. This field contains blanks because the NTA boundaries do not capture facilities beyond the shoreline.2%MN0101MN0502BK0202
    facgrouptextThe value representing the group type, the second broadest category.0%YOUTH SERVICESDAY CARE AND PRE-KINDERG…TRANSPORTATION
    facsubgrptextThe value representing the subgroup type.0%PARKING LOTS AND GARAGESYOUTH CENTERS, LITERACY …AFTER-SCHOOL PROGRAMS
    factypetextThe value representing the facility type, the most granular category of facilities.0%COMMERCIAL GARAGE & PARK…SUMMER ONLY FEEDING SITEDAY CARE
    capacitytextHow many of capacity type/unit the facility is intended to hold. For many types of facilities, no capacity information was available. The capacity-related fields are blank when no information was provided in the source data.0%0200240
    captypecategoricalThe value representing the unit type of capacity, such as beds, visitors, seats, etc.94%seatsbedsroutesof 3
    optypecategoricalIndicates whether the operating entity is public or non-public.27%Non-publicPublicof 2
    opnametextThe name of the operating entity.3%NYC Department of Educat…NYC Department of Parks …Metropolitan Transportat…
    opabbrevtextAbbreviation for the oversight agency.27%Non-publicNYCDOENYCDPR
    overlevelcategoricalThe level of government of the oversight agency: City, State, City-State, Federal, or Non-public Oversight.2%CityStateFederalof 4
    overagencytextThe name of the agency overseeing the facility.0%NYC Department of Educat…NYC Department of Youth …NYC Department of Health…
    overabbrevtextAbbreviation for the oversight agency.0%NYCDOENYCDYCDNYCDOHMH
    datasourcetextThe Agency whose data was used as the source for the record.0%moeo_socialservicesitelo…nysed_activeinstitutionsdca_operatingbusinesses
    facdomaincategoricalThe value representing the facility domain, the broadest category.0%EDUCATION, CHILD WELFARE…HEALTH AND HUMAN SERVICE…CORE INFRASTRUCTURE AND …of 7
    schooldistinteger—2%23115
    policeprctinteger—0%1190
    servareacategorical—0%LocalRegionalof 2
    geometrytextSpatial data for the facility.2%POINT(986492.3426589966 …POINT(998387.7200937271 …POINT(1006726.7113866806…