The upload file must be a delimited text file. In this type of file, each piece of data is separated by a designated character and each record is a new row within the file. This type of file is also commonly called a flat file. Common delimiters include the tab and comma. For simplicity, we recommend that you use a comma as a delimiter and that the “csv” be used as a file name extension.
The data file uploaded to CARS should have the following columns:
Name | Description | Required | |
1 | STATEABBR | Federal Information Processing Standard (FIPS) State Alpha Code, commonly used as the two-character state abbreviation by the US Postal Service (e.g. MN for Minnesota). Data type: Character. Length: 2. Allow null values: No. | Yes |
2 | PLACEFIPS | FIPS numeric code that uniquely identifies each census place within a state or territory. Data type: Character. Length: 5. Allow null values: Yes. | Yes |
3 | COUNTYFIPS | FIPS numeric code that uniquely identifies each county within a state or territory. Data type: Character. Length: 3. Allow null values: Yes. | Yes |
4 | CSDFIPS | FIPS numeric code that identifies each county subdivision with a county. Data type: Character. Length: 5. Allow null values: Yes. | Yes |
5 | NAME | Name used to identify a place or county subdivision. Data type: Character. Length: 100. Allow null values: No. | Yes |
6 | MGMT_PLAN | Identifies if a community has a management plan (0 indicates no, 1 indicates yes). Data type: Boolean. Allow null values: No. | Yes |
7 | STAFF | Identifies if a community has a professional forestry staff (0 indicates no, 1 indicates yes). Data type: Boolean. Allow null values: No. | Yes |
8 | ORDINANCE | Identifies if a community has existing ordinances or policies that focus on planting, protecting and maintaining community trees and forests (0 indicates no, 1 indicates yes). Data type: Boolean. Allow null values: No. | Yes |
9 | ADVOCACY | Identifies if a community has organizations that advocate or advise on urban forestry related issues (0 indicates no, 1 indicates yes). Data type: Boolean. Allow null values: No. | Yes |
10 | ASSISTANCE | Identifies if the community has been provided state assistance within the reporting fiscal year (0 indicates no, 1 indicates yes). Data type: Boolean. Allow null values: No. | Yes |
11 | LSRASSISTANCE | Identifies if the community has been provided LSR assistance within the reporting fiscal year (0 indicates no, 1 indicates yes). Data type: Boolean. Allow null values: No. | No |
12 | GSIASSISTANCE | Identifies if the community has been provided GSI assistance within the reporting fiscal year (0 indicates no, 1 indicates yes). Data type: Boolean. Allow null values: No. | No |
The upload data file shall have one row for each place or county subdivision. The following is a sample dataset that does not include the two optional columns (i.e. LSR and GSI Assistance):
MD,00125,,,Aberdeen,1,0,1,1,1
MD,00175,,,Aberdeen Proving Ground,1,0,1,1,1
MD,15400,,,Charlestown,0,0,1,0,0
MD,15475,,,Charlotte Hall,0,0,1,0,0
MD,15925,,,Chesapeake Beach,0,0,1,0,1
MD,,039,91084,District 12, Asbury,0,0,0,0,1
MD,,001,91197,District 14, Cumberland,0,0,0,0,0
MD,,043,91460,District 16, Beaver Creek,0,0,0,0,0