-
Notifications
You must be signed in to change notification settings - Fork 59
External Data
Each iTree region has a ResourceUnit spreadsheet in iTree's data files. This spreadsheet contains base data for calculating environmental benefits for each tree based on species and trunk diameter. OpenTreeMap includes a python script for importing the data in this spreadsheet.
To use this script:
- Enter the word 'code' without quotes into each data worksheet's A1 cell.
- Save each data worksheet as a csv file
- Run manage.py itree_import <filename>.csv <database_column> for each csv file
OpenTreeMap requires cost values for 10 benefits trees bring to the urban landscape. Defaults for each region can be found in iTree's data files, however you may be able to locate more accurate data for your specific city or area.
- Stormwater - $/gallon
- Electricity - $/kWh
- Natural Gas - $/therm
- Co2 - $/lb
- Ozone - $/lb
- NOx - $/lb
- PM10 - $/lb
- SOX - $/lb
- VOC - $/lb
- BVOX - $/lb
Generate a list of species in your area and match each to a USDA symbol from their Plants online database and also to an iTree resource code. OpenTreeMap provides a species import template and a python script for importing species. Run manage.py speciesimport <filename>.csv to add species.
OpenTreeMap includes an SQL file of default values for the treemap_choices table. Import and change the value column as needed before you begin adding tree data.