Contents
Introduction to the Files
About the ASCII Delimited Text Files
About the Microsoft Access Database
Mapping Application

The database allows users to access the location, type and capacity of public and private educational, recreational, public safety, health, mental health, substance abuse, mental retardation, day care, foster care, senior citizen and homeless facilities and programs. These facilities or programs are, with few exceptions, either operated, funded, licensed or certified by a government agency. The information is updated periodically (see Metadata for sources and dates of latest update for each facility type).

To facilitate computer mapping and data analysis, each facility or program site is geocoded for tax block, tax lot, 2000 census tract, city council district, community district, school district, instructional region, police precinct, health area, zip code, borough, and X and Y coordinates, provided by the Department of City Planning's Geosupport System. City, state and national park properties are coded for borough, community district, tax block, tax lot, and X and Y coordinates only.

The files can be downloaded in two formats: ASCII delimited text files and Microsoft Access database.

These files include five main facility database files and six look-up files:

• mn.txt, bx.txt, bk.txt, qn.txt, si.txt
  These are five main facility database files for Manhattan, Bronx, Brooklyn, Queens and Staten Island respectively, of which some fields are coded and their explanations are found in the look-up tables listed below. For field names and their descriptions please refer to Data Dictionary.
  
  Note: Marble Hill is legally within the borough of Manhattan but is serviced by the Bronx. Facilities and sites within Marble Hill therefore carry the Bronx Community District 8 code (included in bx.txt) and the MN borough code. Similarly, Rikers Island is legally within the borough of the Bronx but is serviced by Queens. Facilities on Rikers Island therefore carry the Queens Community District 1 code (included in qn.txt) and the BX borough code.
  
  
• Factype.txt, Group.txt, Subgroup.txt, Captype.txt, Agoper.txt, Agoversi.txt
  These are six look-up files that describe the codes in selected fields of the main facility database files listed above. Example: the second field (labeled Decode) in look-up file named Captype.txt contains an explanation of the capacity type code in the CAPACITY-TYPE field in the main database files. Look-up files Factype.txt, Subgroup.txt, Captype.txt, Agoper.txt and Agoversi.txt also contain a third field labeled "Decode for Printing" that can be used to print abbreviated descriptions in a report.

In order to use the look-up files for report-writing, both the main database files and the look-up files should be imported into a relation database software format, such as the MS Access database available for downloading from this website. The first field of a look-up file serves as a linking field. The following table specifies the six look-up files and their corresponding fields in the database.

Main table objects:

tblMNfac, tblBXfac, tblBKfac, tblQNfac, and tblSIfac are the five main facility database files for Manhattan, the Bronx, Brooklyn, Queens, and Staten Island respectively. Some fields are coded and their explanations are found in the look-up tables listed below. For field names and their descriptions please refer to Data Dictionary.

Note: Marble Hill is legally within the borough of Manhattan but is serviced by the Bronx. Facilities and sites within Marble Hill therefore carry the Bronx Community District 8 code (included in tblBXFac) and the “MN” borough code. Similarly, Rikers Island is legally within the borough of the Bronx but is serviced by Queens. Facilities on Rakers Island therefore carry the Queens Community District 1 code (included in tblQNFac) and the “BX” borough code.

Look-up tables objects:

tblFactype, tblGroup, tblSubgroup,tblCaptype, tblAgoper, and tblAgoversi are the six look-up tables that describe codes in selected fields in the main tables listed above. Example: the second field (labeled Decode) in look-up table named tblCaptype contains an explanation of the capacity type code in the CAPACITY-TYPE field in the main table objects. Look-up tables tblFactype, tblSubgroup, tblCaptype, tblAgoper and tblAgoversi also contain a third field labeled "Decode for Printing" that can be used to print abbreviated descriptions in a report. The following table specifies the six look-up table objects and their corresponding fields in the database.

Sample report object:

rptFac is a sample report object that allows you to use one of the sample query objects listed below to print respective borough data in a specific format, listing all facilities or programs sorted by community district, group type, subgroup type, facility type, facility name, tax block, and tax lot.

Sample query objects:

qryMNfac, qryBXfac, qryBKfac, qryQNfac, and qrySIfac are the five sample queries created to be used alternatively in the sample report rptfac. They enable you to ask questions of, analyze, and locate data stored in tables.

Producing a Borough Report Based on a Sample Query

The report object named rptFac is a sample report based on a sample query, listing facilities or programs sorted by community district, group type, subgroup type, facility type, facility name, tax block, and tax lot. Follow the instructions below to produce either the sample report or a user-modified report for the desired borough.

For example, to generate a report for the Bronx:
1. Click the Group button under the Objects Bar on the left side of the Database Window -- A list of objects appears.

2. Right-click the report object rptFac. In the drop-down menu click Design View. rptFac:Report screen (rptfac in Design view) appears.

3. Double-click the report selector (the box where the rulers meet in the upper-left corner of the report in Design view ) to open the property sheet. Report property sheet appears.

4. Do one of the following:
To generate the sample report based on the sample query qryBXfac, click the arrow in the Record Source property box to select qryBXfac from a list of tables and queries. Close Report property sheet to go back to rptFac Report screen.

To generate a report based on a modified query qryBXfac, click the arrow in the Record Source property box to select qryBXfac, then click the Build button next to the Record Source property to open the query. qryBXfac:Query Builder screen appears. Use the design grid you see to make the changes you want. Besides adding or removing fields or columns, you can make a variety of changes, such as limiting results using criteria, setting sort order, or calculating amounts to get the query results you want. Close qryBXfac:Query Builder screen. Close Report property sheet to go back to rptFac Report screen. Modify the report design accordingly.

5. Click the Print Preview button on the toolbar to display the report.

This database can also be used with mapping software and one or more geographic base map files to show the locations of selected facility types in a selected area (see example below). The database's address, geographic (x,y) coordinate, and tax block/tax lot fields can be used for defining locations on a map.

DCPLION Single Line Street Base Map, Administrative & Political Districts, and Tax Block Base Maps Files of New York City are geographic base map files which can be downloaded from the Department of City Planning’s website (WWW.NYC.GOV/PLANNING). Tax Lot Base Map Files are a licensed product of the NYC Department of City Planning and may only be used through a license granted by the department. For information on these files call 212-720-3505.

Values in this database's x and y coordinate fields are expressed in New York Long Island State Plane Coordinates and are registered to the Tax Block and Tax Lot Map Files. Facility symbols can be placed using these fields with both Tax Block & Tax Lot and the Administrative and Political District base map files. A small number of small park properties are not coded with x and y coordinates. Certain park properties which are located on multiple tax lots are listed as multiple records in the database with multiple x and y coordinates.

Users should be aware that more than one facility or program may be located at the same address. In those cases, multiple records will contain identical values in the address, x,y coordinates and tax block and tax lot number fields and will result in map symbols displayed on top of one another.

Use of the Tax Lot Base Map file and this database allows for maps such as the example shown below.