Information about trees owned and maintained by the City of Mesa and includes trees maintained by Parks, Recreation and Community Facilities (PRCF), Transportation and Transit departments. This dataset also includes other vegetation in city owned parks, open basins, and rights of way including cacti, bushes, etc. City owned/maintained trees are managed by 3rd parties such as West Coast Arborists (WCA). See also <b><a href="https://www.mesalistens.com/trees-are-cool" target="_blank" rel="noopener noreferrer">Mesa Trees Are Cool</a></b>.
This dataset has the following 32 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
RowID | rowid | number | Unique row identifier | 16336 10051 21232 26601 36585 view top 100 |
OBJECTID | objectid | number | 147077 16336 141747 163585 165443 view top 100 | |
FACILITYID | facilityid | text | A computer-generated unique identifier used for Cityworks, the City's work management system. | PKVG10307477 TLVG27734 TSTR20419 PKVG9992440 TSTR23493 view top 100 |
LANDKEY | landkey | text | A unique ID created by the City of Mesa for each area of landscape that is maintained by the City of Mesa. | LC09DAW01 AEH15AW02 ABY13AS01 LG03BAE01 AGT04BW01 view top 100 |
LOCDESC | locdesc | text | Identifies the general location of the identified vegetation using roadway names and direction as a point of reference. | Fighter Aces Dr to McKellips Rd (4 medians) Taxiway to Fighter Aces Dr (6 medians) Park & Ride Lot - N/of US 60 from Superstition Springs Blvd to Power Rd 613' E/of Power Rd to Roslyn (1 median) Pepper to Main St view top 100 |
LOCATION | location | text | Identifies the vegetation location by roadway and roadway boundaries (i.e., "roadway ~ N/E boundary street - S/W boundary street"). | Mesa Cemetery Riverview Park Gene Autry Park Eastmark Great Park Red Mountain Park view top 100 |
VEG CATEGORY | veg_category | text | Identifies the category of the vegetation (i.e., Accent, Amenity, Cactus, Groundcover, Shrub, Tree). | Tree Shrub Groundcover Accent Cactus view top 100 |
COMMON NAME | common_name | text | The common name of the identified vegetation. | VACANT SITE CHINESE ELM CHILEAN MESQUITE ORANGE MEXICAN FAN PALM view top 100 |
BOTANICAL NAME | botanical_name | text | The name given to the tree, which is identified as "genus - species." | Vacant site Ulmus parvifolia Prosopis chilensis Quercus virginiana Citrus sinensis view top 100 |
TREE DBH | tree_dbh | text | The "diameter at breast height" (DBH) measurement of the tree at approximately 54 inches from above ground level and is provided in units of inches. | 0-6 07-12 13-18 19-24 25-30 view top 100 |
VEG HEIGHT | veg_height | text | The measured height of the identified vegetation and is provided in 15' increments (i.e., 1' to 15', 15' to 30', '31' to 45', 46' to 60', 60'+). | 01-15 15-30 30-45 45-60 60+ view top 100 |
ISACTIVE | isactive | number | Identifies the active validity of the vegetation location (i.e., No or Yes). | 1 view top 100 |
COMMENT | comment | text | Provides additional information regarding the identified vegetation, if applicable. | Grid/Routine Trim Plant Small Tree Maintenance Young Tree Maintenance None view top 100 |
LEGACYID | legacyid | text | Unique ID created by the City of Mesa for each vegetation site in the landscape areas maintained by the City of Mesa. | TLVG26439 TLVG26444 TLVG26445 TLVG26446 TLVG26447 view top 100 |
OWNER | owner | text | Identifies the owner of the identified vegetation (i.e., PRCF, Trans, Transit, Private, Unknown). | Parks COM Trans Facilities COM Transit Transportation view top 100 |
SYMBOL_TYPE | symbol_type | text | Indicates the attribute symbol used to identify the vegetation on the map based on owner and vegetation category. | COM Trans~Tree COM Trans~Shrub COM Trans~Groundcover COM Trans~Accent COM Transit~Tree view top 100 |
ACTION | action | text | Indicates if any action was performed on the identified vegetation (i.e., Construction, None, Remove, Repair, Replace). | None Construction Replace Remove Repair view top 100 |
ACTION_DATE | action_date | calendar_date | Indicates the date of the action performed on the identified vegetation, if applicable. | 2021-03-02T00:00:00.000 2023-10-11T00:00:00.000 2021-02-25T00:00:00.000 2020-01-07T00:00:00.000 2018-04-18T00:00:00.000 view top 100 |
ACTION_USER | action_user | text | BHatch MCroft PCollin BRodrig RPerry view top 100 | |
CREATED BY | created_by | text | Computer-generated unique ID that identifies the person who added the attribute data | LOAD MCroft VBruno RPerry JMalave view top 100 |
CREATED DATE | created_date | calendar_date | Indicates the date that the identified vegetation was added into the source system. | 2015-12-14T00:00:00.000 2014-05-06T00:00:00.000 2014-04-21T00:00:00.000 2014-12-01T00:00:00.000 2014-05-13T00:00:00.000 view top 100 |
CREATED YEAR | created_year | text | Year associated with created date | 2014 2015 2019 2023 2016 view top 100 |
CREATED MONTH | created_month | text | Month name associated with created date | Dec May Apr Mar Feb view top 100 |
MODIFIED BY | modified_by | text | Computer-generated unique ID that identifies the person who edited or modified the attribute data | MSowers MCroft LOAD RPerry JMalave view top 100 |
MODIFIED DATE | modified_date | calendar_date | Indicates the date that the identified vegetation was either edited or modified in the source system. | 2017-09-21T00:00:00.000 2019-03-14T00:00:00.000 2022-11-16T00:00:00.000 2023-09-19T00:00:00.000 2022-10-06T00:00:00.000 view top 100 |
INVENTORYID | inventoryid | text | Unique Tree ID assigned by source system | 9905548 12861766 12862142 9993309 10132307 view top 100 |
COM NAME | com_name | text | Mesa Cemetery Riverview Park Gene Autry Park Eastmark Great Park Dobson Ranch Golf Course view top 100 | |
STREET | street | text | Frontage address street name | CITY CEMETERY RIVERVIEW PARK GENE AUTRY PARK DOBSON RANCH GOLF COURSE EASTMARK GREAT PARK view top 100 |
EST VALUE | est_value | text | Estimated replacement value of tree | 700 1380 3260 0 1030 view top 100 |
Longitude | longitude | number | Longitude of tree | -111.70543032308701 -111.88014739544046 -111.70532880159107 -111.73925571301197 -111.73094113183939 view top 100 |
Latitude | latitude | number | Latitude of tree | 33.37934292681382 33.43289595460021 33.45168298106135 33.41482499707865 33.45364290430535 view top 100 |
Geolocation 2 | geolocation_2 | point | Geocoded location of tree | {"coordinates":[-111.61510658537487,33.402221635961354],"type":"Point"} {"coordinates":[-111.73094113183939,33.45450910319851],"type":"Point"} {"coordinates":[-111.87503667283737,33.43289595460021],"type":"Point"} {"coordinates":[-111.68499886868139,33.37934292681382],"type":"Point"} {"coordinates":[-111.83529699230849,33.44458164792476],"type":"Point"} view top 100 |