City Planning Facilities Database (FacDB)
While each source agency classifies its facilities according to their own naming systems, we have grouped all facilities and program sites into the following seven categories to help planners navigate the data more easily:Health and Human ServicesEducation, Child Welfare, and YouthParks, Gardens, and Historical SitesLibraries and Cultural ProgramsPublic Safety, Emergency Services, and Administration of JusticeCore Infrastructure and TransportationAdministration of GovernmentWithin each of these domains, each record is further categorized into a set of facility groups, subgroups, and types that are intended to make the data easy to navigate and more useful for specific planning purposes. Facility types and names appear as they do in source datasets, wherever possible. Notes on version 19v1:The code used to create the City Planning Facilities Database (FacDB) has been completely rewritten to make it more user-friendly and more maintainable. The schema has changed, as have some of the data sources. These changes are summarized below.FacDB is compiled from approximately 50 source files. Many facilities are available in more than one source file, sometimes with conflicting information. The previous version of FacDB had several fields, including CAPACITY that were formatted as strings, showing each source file that included that facility and the value contained in the source file. In version 19v1, one source is designated as the primary source for each facility type. All values in the record come from that single source. For some facility types, like public schools or fire stations, there is an authoritative source and no secondary sources are used. For example, the Department of Education is the only source used for public schools. While other source files, such as City Owned and Leased Properties (COLP), contain records for public schools, these are not used for FacDB.For other facility types, like day care centers, there is not a single authoritative source. One source is designated primary. All the facilities from that source are included in FacDB. If other sources include facilities at locations not in the primary source file, additional records are added to FacDB with data from the secondary source(s).Schema changes:The schema has been significantly changed for version 19v1. While field names remain the same, some fields have been removed. Some fields, like CAPACITY, which were previously text fields, have been changed to numeric fields. Please review the data dictionary for the new schema.Data source changes:Some city agency facilities, previously sourced from COLP, have been changed to use a source file from the agency. These agency specific files are updated more frequently than COLP and provide more accurate information. Please review the data sources file for a full list of these sources and the date each was updated.Health and human services facilities formerly taken from HHS Connect are now coming from the Mayor’s Office of Economic Opportunity. This has resulted in a number of changes to facility categorization.Data quality improvements:The geocoding of facilities has been improved and there are fewer duplicate facilities.
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'FACNAME', 'type': 'esriFieldTypeString', 'alias': 'FACNAME', 'sqlType': 'sqlTypeOther', 'length': 250, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ADDRESSNUM', 'type': 'esriFieldTypeString', 'alias': 'ADDRESSNUM', 'sqlType': 'sqlTypeOther', 'length': 12, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'STREETNAME', 'type': 'esriFieldTypeString', 'alias': 'STREETNAME', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ADDRESS', 'type': 'esriFieldTypeString', 'alias': 'ADDRESS', 'sqlType': 'sqlTypeOther', 'length': 150, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CITY', 'type': 'esriFieldTypeString', 'alias': 'CITY', 'sqlType': 'sqlTypeOther', 'length': 50, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ZIPCODE', 'type': 'esriFieldTypeString', 'alias': 'ZIPCODE', 'sqlType': 'sqlTypeOther', 'length': 5, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FACTYPE', 'type': 'esriFieldTypeString', 'alias': 'FACTYPE', 'sqlType': 'sqlTypeOther', 'length': 250, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FACSUBGRP', 'type': 'esriFieldTypeString', 'alias': 'FACSUBGRP', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FACGROUP', 'type': 'esriFieldTypeString', 'alias': 'FACGROUP', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'FACDOMAIN', 'type': 'esriFieldTypeString', 'alias': 'FACDOMAIN', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SERVAREA', 'type': 'esriFieldTypeString', 'alias': 'SERVAREA', 'sqlType': 'sqlTypeOther', 'length': 10, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OPNAME', 'type': 'esriFieldTypeString', 'alias': 'OPNAME', 'sqlType': 'sqlTypeOther', 'length': 150, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OPABBREV', 'type': 'esriFieldTypeString', 'alias': 'OPABBREV', 'sqlType': 'sqlTypeOther', 'length': 12, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OPTYPE', 'type': 'esriFieldTypeString', 'alias': 'OPTYPE', 'sqlType': 'sqlTypeOther', 'length': 12, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OVERAGENCY', 'type': 'esriFieldTypeString', 'alias': 'OVERAGENCY', 'sqlType': 'sqlTypeOther', 'length': 150, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OVERABBREV', 'type': 'esriFieldTypeString', 'alias': 'OVERABBREV', 'sqlType': 'sqlTypeOther', 'length': 12, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'OVERLEVEL', 'type': 'esriFieldTypeString', 'alias': 'OVERLEVEL', 'sqlType': 'sqlTypeOther', 'length': 12, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CAPACITY', 'type': 'esriFieldTypeInteger', 'alias': 'CAPACITY', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CAPTYPE', 'type': 'esriFieldTypeString', 'alias': 'CAPTYPE', 'sqlType': 'sqlTypeOther', 'length': 12, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'BORO', 'type': 'esriFieldTypeString', 'alias': 'BORO', 'sqlType': 'sqlTypeOther', 'length': 15, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'BIN', 'type': 'esriFieldTypeInteger', 'alias': 'BIN', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'BBL', 'type': 'esriFieldTypeDouble', 'alias': 'BBL', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'LATITUDE', 'type': 'esriFieldTypeDouble', 'alias': 'LATITUDE', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'LONGITUDE', 'type': 'esriFieldTypeDouble', 'alias': 'LONGITUDE', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'XCOORD', 'type': 'esriFieldTypeDouble', 'alias': 'XCOORD', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'YCOORD', 'type': 'esriFieldTypeDouble', 'alias': 'YCOORD', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CD', 'type': 'esriFieldTypeSmallInteger', 'alias': 'CD', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'NTA2010', 'type': 'esriFieldTypeString', 'alias': 'NTA2010', 'sqlType': 'sqlTypeOther', 'length': 6, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'NTA2020', 'type': 'esriFieldTypeString', 'alias': 'NTA2020', 'sqlType': 'sqlTypeOther', 'length': 6, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'COUNCIL', 'type': 'esriFieldTypeSmallInteger', 'alias': 'COUNCIL', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CT2010', 'type': 'esriFieldTypeString', 'alias': 'CT2010', 'sqlType': 'sqlTypeOther', 'length': 6, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CT2020', 'type': 'esriFieldTypeString', 'alias': 'CT2020', 'sqlType': 'sqlTypeOther', 'length': 6, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'BOROCODE', 'type': 'esriFieldTypeSmallInteger', 'alias': 'BOROCODE', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'SCHOOLDIST', 'type': 'esriFieldTypeString', 'alias': 'SCHOOLDIST', 'sqlType': 'sqlTypeOther', 'length': 3, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'POLICEPRCT', 'type': 'esriFieldTypeSmallInteger', 'alias': 'POLICEPRCT', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'DATASOURCE', 'type': 'esriFieldTypeString', 'alias': 'DATASOURCE', 'sqlType': 'sqlTypeOther', 'length': 150, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'UID', 'type': 'esriFieldTypeString', 'alias': 'UID', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__FACILITI__F4B70D855CAA7330', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_24452.FACILITIES_CITY_PLANNING_FACILITIES_DATABASE__FACDB__Shape_sidx', 'fields': 'Shape', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Spatial'}]
nan
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSMS', 'style': 'esriSMSCircle', 'color': [48, 153, 0, 255], 'size': 4, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'outline': {'color': [0, 0, 0, 255], 'width': 1}}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': None}
[]
[{'name': 'City Planning Facilities Database (FacDB)', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'DATASOURCE': None, 'UID': None, 'FACNAME': None, 'ADDRESSNUM': None, 'STREETNAME': None, 'ADDRESS': None, 'CITY': None, 'ZIPCODE': None, 'FACTYPE': None, 'FACSUBGRP': None, 'FACGROUP': None, 'FACDOMAIN': None, 'SERVAREA': None, 'OPNAME': None, 'OPABBREV': None, 'OPTYPE': None, 'OVERAGENCY': None, 'OVERABBREV': None, 'OVERLEVEL': None, 'CAPACITY': None, 'CAPTYPE': None, 'BORO': None, 'BIN': None, 'BBL': None, 'LATITUDE': None, 'LONGITUDE': None, 'XCOORD': None, 'YCOORD': None, 'CD': None, 'NTA2010': None, 'NTA2020': None, 'COUNCIL': None, 'CT2010': None, 'CT2020': None, 'BOROCODE': None, 'SCHOOLDIST': None, 'POLICEPRCT': None}}}]
{'lastEditDate': 1694611605877, 'schemaLastEditDate': 1694611605877, 'dataLastEditDate': 1694611605877}