cityofnewyork-us/facilities-database-ji82-xba5
Icon for Socrata external plugin
 
Readme
Updated 2 months ago
Indexed 2 hours ago

Facilities Database

The Facilities Database (FacDB) captures the locations and descriptions of public and

private facilities ranging from the provision of social services, recreation, education, to

solid waste management.

For data dictionary, please follow <a href="http://docs.capitalplanning.nyc/facdb/">this link</a>

All previously released versions of this data are available at <a href="https://www1.nyc.gov/site/planning/data-maps/open-data/bytes-archive.page?sorts[year]=0">BYTES of the BIG APPLE- Archive</a>

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
borocodeborocodeborocodeNumberThe number value representing the borough the facility is within.
boroughboroboroTextThe full name the borough the facility is within.
opabbrevopabbrevopabbrevTextAbbreviation for the oversight agency.
servareaservareaservareaText
ntantantaTextThe Neighborhood Tabulation Area (NTA) the facility is within. This 􀃗eld contains blanks because the NTA boundaries do not capture facilities beyond the shoreline.
facgroupfacgroupfacgroupTextThe value representing the group type, the second broadest category.
factypefactypefactypeTextThe value representing the facility type, the most granular category of facilities.
overagencyoveragencyoveragencyTextThe name of the agency overseeing the facility.
overabbrevoverabbrevoverabbrevTextAbbreviation for the oversight agency.
datasourcedatasourcedatasourceTextThe Agency whose data was used as the source for the record.
schooldistschooldistschooldistNumber
facdomainfacdomainfacdomainTextThe value representing the facility domain, the broadest category.
policeprctpoliceprctpoliceprctNumber
facsubgrpfacsubgrpfacsubgrpTextThe value representing the subgroup type.
uiduiduidTextUniversal Unique Identifier. When a row is added to the table the UID is automatically generated, enabling database replication.
facnamefacnamefacnameTextThe name of the facility in proper case.
streetstreetnamestreetnameTextThe 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 􀃗eld is left blank.
addressaddressaddressTextThe 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.
citycitycityTextThe USPS preferred name of the addressed city where the facility is located. Generated by GeoClient and spatial joins. This 􀃗eld contains some blanks for facilities that do not overlap with the shoreline Zip Code boundaries.
postcodezipcodezipcodeTextThe ZIP Code the facility is within. This 􀃗eld contains some blanks for facilities that do not overlap with the shoreline Zip Code boundaries.
latitudelatitudelatitudeNumberThe latitude of the location either calculated using the coordinates in the source data or provided by GeoClient.
longitudelongitudelongitudeNumberThe longitude of the location either calculated using the coordinates in the source data or provided by GeoClient.
xcoordxcoordxcoordNumberThe X coordinate of the location either calculated using the coordinates in the source data or provided by GeoClient.
ycoordycoordycoordNumberThe Y coordinate of the location either calculated using the coordinates in the source data or provided by GeoClient.
binbinbinTextThe BIN values for the buildings the facility is located in. This 􀃗eld 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.
bblbblbblTextThe BBL values for the tax lots the facility is located on. This 􀃗eld contains blanks, because some facility categories, like pedestrian plazas are not located on tax lots.
community boardcommboardcommboardNumberThe Community District the facility is within. This 􀃗eld contains blanks because the Community District boundaries do not capture facilities beyond the shoreline.
council districtcouncilcouncilNumberThe City Council District the facility is within
capacitycapacitycapacityTextHow many of capacity type/unit the facility is intended to hold. For many types of facilities, no capacity information was available. The capacity-related 􀃗elds are blank when no information was provided in the source data.
overleveloverleveloverlevelTextThe level of government of the oversight agency: City, State, City-State, Federal, or Non-public Oversight.
opnameopnameopnameTextThe name of the operating entity.
census tractcenstractcenstractNumberThe U.S. Census Tract the facility is within
numberaddressnumaddressnumTextThe 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 􀃗eld is left blank.
optypeoptypeoptypeTextIndicates whether the operating entity is public or non-public.
captypecaptypecaptypeTextThe value representing the unit type of capacity, such as beds, visitors, seats, etc.
 
Preview
  • facilities_database
     
Upstream Metadata