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
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
borocode | borocode | borocode | Number | The number value representing the borough the facility is within. |
borough | boro | boro | Text | The full name the borough the facility is within. |
opabbrev | opabbrev | opabbrev | Text | Abbreviation for the oversight agency. |
servarea | servarea | servarea | Text | |
nta | nta | nta | Text | The Neighborhood Tabulation Area (NTA) the facility is within. This eld contains blanks because the NTA boundaries do not capture facilities beyond the shoreline. |
facgroup | facgroup | facgroup | Text | The value representing the group type, the second broadest category. |
factype | factype | factype | Text | The value representing the facility type, the most granular category of facilities. |
overagency | overagency | overagency | Text | The name of the agency overseeing the facility. |
overabbrev | overabbrev | overabbrev | Text | Abbreviation for the oversight agency. |
datasource | datasource | datasource | Text | The Agency whose data was used as the source for the record. |
schooldist | schooldist | schooldist | Number | |
facdomain | facdomain | facdomain | Text | The value representing the facility domain, the broadest category. |
policeprct | policeprct | policeprct | Number | |
facsubgrp | facsubgrp | facsubgrp | Text | The value representing the subgroup type. |
uid | uid | uid | Text | Universal Unique Identifier. When a row is added to the table the UID is automatically generated, enabling database replication. |
facname | facname | facname | Text | The name of the facility in proper case. |
street | streetname | streetname | Text | The 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. |
address | address | address | Text | The 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. |
city | city | city | Text | The 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. |
postcode | zipcode | zipcode | Text | The ZIP Code the facility is within. This eld contains some blanks for facilities that do not overlap with the shoreline Zip Code boundaries. |
latitude | latitude | latitude | Number | The latitude of the location either calculated using the coordinates in the source data or provided by GeoClient. |
longitude | longitude | longitude | Number | The longitude of the location either calculated using the coordinates in the source data or provided by GeoClient. |
xcoord | xcoord | xcoord | Number | The X coordinate of the location either calculated using the coordinates in the source data or provided by GeoClient. |
ycoord | ycoord | ycoord | Number | The Y coordinate of the location either calculated using the coordinates in the source data or provided by GeoClient. |
bin | bin | bin | Text | The 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. |
bbl | bbl | bbl | Text | The 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 board | commboard | commboard | Number | The Community District the facility is within. This eld contains blanks because the Community District boundaries do not capture facilities beyond the shoreline. |
council district | council | council | Number | The City Council District the facility is within |
capacity | capacity | capacity | Text | How 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. |
overlevel | overlevel | overlevel | Text | The level of government of the oversight agency: City, State, City-State, Federal, or Non-public Oversight. |
opname | opname | opname | Text | The name of the operating entity. |
census tract | censtract | censtract | Number | The U.S. Census Tract the facility is within |
number | addressnum | addressnum | Text | The 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. |
optype | optype | optype | Text | Indicates whether the operating entity is public or non-public. |
captype | captype | captype | Text | The value representing the unit type of capacity, such as beds, visitors, seats, etc. |
Upstream Metadata