{ "layers": [ { "currentVersion": 10.71, "id": 0, "name": "GISTrans.GISPUB.RCTreeInventory", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103768, "latestWkid": 103768 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 250000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 53, 128, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.0377488850529527E7, "ymin": 5605913.371078437, "xmax": -1.0350815265568817E7, "ymax": 5641689.134631718, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CommonName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "AssetNumber", "type": "esriFieldTypeInteger", "alias": "Tree identifier number", "domain": null }, { "name": "AssetId", "type": "esriFieldTypeString", "alias": "Tree Identifier", "length": 50, "domain": null }, { "name": "FullAddr", "type": "esriFieldTypeString", "alias": "Nearest Address", "length": 250, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District or Neighborhood", "length": 254, "domain": null }, { "name": "Municipality", "type": "esriFieldTypeString", "alias": "Municipality", "length": 150, "domain": null }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project", "length": 25, "domain": { "type": "codedValue", "name": "envProject", "description": "Tree Project", "codedValues": [ { "name": "1st Half Winter 2025", "code": "1st Half Winter 2025" }, { "name": "2025 Tree Removals RFB ", "code": "2025 Tree Removals RFB" }, { "name": "2nd Half Winter 2025", "code": "2nd Half Winter 2025" }, { "name": "Carr's Bald Eagle", "code": "Carr's Bald Eagle" }, { "name": "Dudley Oak Wilt", "code": "Dudley Oak Wilt" }, { "name": "Hodgson P3422", "code": "Hodgson P3422" }, { "name": "List 26", "code": "List 26" }, { "name": "List 27", "code": "List 27" }, { "name": "List 28", "code": "List 28" }, { "name": "List 29", "code": "List 29" }, { "name": "List 30", "code": "List 30" }, { "name": "List 31", "code": "List 31" }, { "name": "List 32", "code": "List 32" }, { "name": "List 33", "code": "List 33" }, { "name": "List 34 ", "code": "List 34" }, { "name": "List 35", "code": "List 35" }, { "name": "List 36", "code": "List 36" }, { "name": "MCARES 2025", "code": "MCARES 2025" }, { "name": "Owasso Residence ", "code": "Owasso Residence" }, { "name": "P3446 35E Cty J", "code": "P3446 35E Cty J" }, { "name": "Parks Winter 2025", "code": "Parks Winter 2025" }, { "name": "Public Works Maintenance ", "code": "Public Works Maintenance " }, { "name": "S. Shore P8025", "code": "S. Shore P8025" }, { "name": "SWCD Internal", "code": "SWCD Internal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "Invoice", "type": "esriFieldTypeString", "alias": "Invoice", "length": 100, "domain": null }, { "name": "TreeCount", "type": "esriFieldTypeInteger", "alias": "Tree Count", "domain": null }, { "name": "PlantsCode", "type": "esriFieldTypeString", "alias": "PlantsCode", "length": 7, "domain": { "type": "codedValue", "name": "envMNSpecies", "description": "envMNTreeSpecies", "codedValues": [ { "name": "Abies balsamea (Balsam Fir)", "code": "ABBA" }, { "name": "Juniperus virginiana (Eastern Redcedar)", "code": "JUVI" }, { "name": "Larix laricina (Tamarack)", "code": "LALA" }, { "name": "Picea abies (Norway Spruce)", "code": "PIAB" }, { "name": "Picea glauca (White Spruce)", "code": "PIGL" }, { "name": "Picea mariana (Black Spruce)", "code": "PIMA" }, { "name": "Picea rubens (Red Spruce)", "code": "PIRU" }, { "name": "Pinus banksiana (Jack Pine)", "code": "PIBA2" }, { "name": "Pinus echinata (Shortleaf Pine)", "code": "PIEC2" }, { "name": "Pinus pungens (Table Mountain Pine)", "code": "PIPU5" }, { "name": "Pinus resinosa (Red Pine)", "code": "PIRE" }, { "name": "Pinus rigida (Pitch Pine)", "code": "PIRI" }, { "name": "Pinus strobus (Eastern White Pine)", "code": "PIST" }, { "name": "Pinus sylvestris (Scotch Pine)", "code": "PISY" }, { "name": "Pinus taeda (Loblolly Pine)", "code": "PITA" }, { "name": "Pinus virginiana (Virginia Pine)", "code": "PIVI2" }, { "name": "Taxodium distichum (Baldcypress)", "code": "TADI2" }, { "name": "Thuja occidentalis (Northern White-Cedar)", "code": "THOC2" }, { "name": "Tsuga canadensis (Eastern Hemlock)", "code": "TSCA" }, { "name": "Acer negundo (Boxelder)", "code": "ACNE2" }, { "name": "Acer nigrum (Black Maple)", "code": "ACNI5" }, { "name": "Acer pensylvanicum (Striped Maple)", "code": "ACPE" }, { "name": "Acer rubrum (Red Maple)", "code": "ACRU" }, { "name": "Acer saccharinum (Silver Maple)", "code": "ACSA2" }, { "name": "Acer saccharum (Sugar Maple)", "code": "ACSA3" }, { "name": "Acer spicatum (Mountain Maple)", "code": "ACSP2" }, { "name": "Aesculus (Buckeye Spp.)", "code": "AESCU" }, { "name": "Aesculus glabra (Ohio Buckeye)", "code": "AEGL" }, { "name": "Aesculus flava (Yellow Buckeye)", "code": "AEFL" }, { "name": "Amelanchier (Serviceberry)", "code": "AMELA" }, { "name": "Betula alleghaniensis (Yellow Birch)", "code": "BEAL2" }, { "name": "Betula lenta (Sweet Birch)", "code": "BELE" }, { "name": "Betula nigra (River Birch)", "code": "BENI" }, { "name": "Betula papyrifera (Paper Birch)", "code": "BEPA" }, { "name": "Betula populifolia (Gray Birch)", "code": "BEPO" }, { "name": "Carpinus caroliniana (Blue-Beech/Hornbeam)", "code": "CACA18" }, { "name": "Carya (Hickory Spp.)", "code": "CARYA" }, { "name": "Carya cordiformis (Bitternut Hickory)", "code": "CACO15" }, { "name": "Carya glabra (Pignut Hickory)", "code": "CAGL8" }, { "name": "Carya illinoinensis (Pecan)", "code": "CAIL2" }, { "name": "Carya laciniosa (Shellbark Hickory)", "code": "CALA21" }, { "name": "Carya ovata (Shagbark Hickory)", "code": "CAOV2" }, { "name": "Carya texana (Black Hickory)", "code": "CATE9" }, { "name": "Carya alba (Mockernut Hickory)", "code": "CAAL27" }, { "name": "Castanea dentata (American Chestnut)", "code": "CADE12" }, { "name": "Catalpa speciosa (Northern Catalpa)", "code": "CASP8" }, { "name": "Celtis (Hackberry Spp.)", "code": "CELTI" }, { "name": "Celtis occidentalis (Common Hackberry)", "code": "CEOC" }, { "name": "Cercis canadensis (Eastern Redbud)", "code": "CECA4" }, { "name": "Cladrastis kentukea (Kentucky Yellowwood)", "code": "CLKE" }, { "name": "Cornus (Dowood Spp.)", "code": "CORNU" }, { "name": "Cornus florida (Flowering Dogwood)", "code": "COFL2" }, { "name": "Diospyros virginiana (Common Persimmon)", "code": "DIVI5" }, { "name": "Fagus grandifolia (American Beech)", "code": "FAGR" }, { "name": "Fraxinus americana (White Ash)", "code": "FRAM2" }, { "name": "Fraxinus nigra (Black Ash)", "code": "FRNI" }, { "name": "Fraxinus pennsylvanica (Green Ash)", "code": "FRPE" }, { "name": "Gleditsia triacanthos (Honeylocust)", "code": "GLTR" }, { "name": "Gymnocladus dioicus (Kentucky Coffeetree)", "code": "GYDI" }, { "name": "Juglans cinerea (Butternut)", "code": "JUCI" }, { "name": "Juglans nigra (Black Walnut)", "code": "JUNI" }, { "name": "Liquidambar styraciflua (Sweetgum)", "code": "LIST2" }, { "name": "Liriodendron tulipifera (Yellow-Poplar/Tuliptree)", "code": "LITU" }, { "name": "Maclura pomifera (Osage Orange)", "code": "MAPO" }, { "name": "Magnolia acuminata (Cucumbertree)", "code": "MAAC" }, { "name": "Magnolia macrophylla (Bigleaf Magnolia)", "code": "MAMA2" }, { "name": "Magnolia fraseri (Mountain Magnolia)", "code": "MAFR" }, { "name": "Nyssa aquatica (Water Tupelo)", "code": "NYAQ2" }, { "name": "Nyssa sylvatica (Blackgum)", "code": "NYSY" }, { "name": "Ostrya virginiana (Ironwood/Hophornbeam)", "code": "OSVI" }, { "name": "Platanus occidentalis (American Sycamore)", "code": "PLOC" }, { "name": "Populus balsamifera (Balsam Poplar)", "code": "POBA2" }, { "name": "Populus deltoides (Eastern Cottonwood)", "code": "PODE3" }, { "name": "Populus grandidentata (Bigtooth Aspen)", "code": "POGR4" }, { "name": "Populus heterophylla (Swamp Cottonwood)", "code": "POHE4" }, { "name": "Populus tremuloides (Quaking Aspen)", "code": "POTR5" }, { "name": "Prunus pensylvanica (Pin Cherry)", "code": "PRPE2" }, { "name": "Prunus serotina (Black Cherry)", "code": "PRSE2" }, { "name": "Quercus (Oak Spp.)", "code": "QUERC" }, { "name": "Quercus alba (White Oak)", "code": "QUAL" }, { "name": "Quercus bicolor (Swamp White Oak)", "code": "QUBI" }, { "name": "Quercus coccinea (Scarlet Oak)", "code": "QUCO2" }, { "name": "Quercus ellipsoidalis (Northern Pin Oak)", "code": "QUEL" }, { "name": "Quercus falcata (Southern Red Oak)", "code": "QUFA" }, { "name": "Quercus pagoda (Cherrybark Oak)", "code": "QUPA5" }, { "name": "Quercus ilicifolia (Bear Oak)", "code": "QUIL" }, { "name": "Quercus imbricaria (Shingle Oak)", "code": "QUIM" }, { "name": "Quercus lyrata (Overcup Oak)", "code": "QULY" }, { "name": "Quercus macrocarpa (Bur Oak)", "code": "QUMA2" }, { "name": "Quercus marilandica (Blackjack Oak)", "code": "QUMA3" }, { "name": "Quercus michauxii (Swamp Chestnut Oak)", "code": "QUMI" }, { "name": "Quercus muehlenbergii (Chinkapin Oak)", "code": "QUMU" }, { "name": "Quercus palustris (Pin Oak)", "code": "QUPA2" }, { "name": "Quercus phellos (Willow Oak)", "code": "QUPH" }, { "name": "Quercus prinus (Chestnut Oak)", "code": "QUPR2" }, { "name": "Quercus rubra (Northern Red Oak)", "code": "QURU" }, { "name": "Quercus shumardii (Shumard Oak)", "code": "QUSH" }, { "name": "Quercus stellata (Post Oak)", "code": "QUST" }, { "name": "Quercus velutina (Black Oak)", "code": "QUVE" }, { "name": "Robinia pseudoacacia (Black Locust)", "code": "ROPS" }, { "name": "Salix (Willow Spp.)", "code": "SALIX" }, { "name": "Salix nigra (Black Willow)", "code": "SANI" }, { "name": "Sassafras albidum (Sassafras)", "code": "SAAL5" }, { "name": "Sorbus americana (American Mountain Ash)", "code": "SOAM3" }, { "name": "Tilia americana (American Basswood)", "code": "TIAM" }, { "name": "Tilia americana v. heterophylla (White Basswood)", "code": "TIAMH" }, { "name": "Ulmus (Elm Spp.)", "code": "ULMUS" }, { "name": "Ulmus alata (Winged Elm)", "code": "ULAL" }, { "name": "Ulmus americana (American Elm)", "code": "ULAM" }, { "name": "Ulmus rubra (Slippery Elm)", "code": "ULRU" }, { "name": "Ulmus thomasii (Rock Elm)", "code": "ULTH" }, { "name": "Plant Area (Planting Area)", "code": "PLANT" }, { "name": "Other", "code": "TREE" }, { "name": "Unknown", "code": "2TREE" }, { "name": "Ulmus pumila (Siberian Elm)", "code": "ULPU" }, { "name": "Picea pungens (Blue Spruce)", "code": "PIPU" }, { "name": "Acer platanoides (Norway Maple)", "code": "ACPL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Family", "type": "esriFieldTypeString", "alias": "Family", "length": 254, "domain": { "type": "codedValue", "name": "envFamily", "description": "Tree Family", "codedValues": [ { "name": "Adoxaceae", "code": "Adoxaceae" }, { "name": "Altingiaceae", "code": "Altingiaceae" }, { "name": "Anacardiaceae", "code": "Anacardiaceae" }, { "name": "Annonaceae", "code": "Annonaceae" }, { "name": "Aquifoliaceae", "code": "Aquifoliaceae" }, { "name": "Araliaceae", "code": "Araliaceae" }, { "name": "Arecaceae", "code": "Arecaceae" }, { "name": "Asparagaceae", "code": "Asparagaceae" }, { "name": "Betulaceae", "code": "Betulaceae" }, { "name": "Bignoniaceae", "code": "Bignoniaceae" }, { "name": "Cannabaceae", "code": "Cannabaceae" }, { "name": "Casuarinaceae", "code": "Casuarinaceae" }, { "name": "Cornaceae", "code": "Cornaceae" }, { "name": "Cupressaceae", "code": "Cupressaceae" }, { "name": "Cyrillaceae", "code": "Cyrillaceae" }, { "name": "Ebenaceae", "code": "Ebenaceae" }, { "name": "Elaeagnaceae", "code": "Elaeagnaceae" }, { "name": "Ericaceae", "code": "Ericaceae" }, { "name": "Euphorbiaceae", "code": "Euphorbiaceae" }, { "name": "Fabaceae", "code": "Fabaceae" }, { "name": "Fagaceae", "code": "Fagaceae" }, { "name": "Ginkgoaceae", "code": "Ginkgoaceae" }, { "name": "Hamamelidaceae", "code": "Hamamelidaceae" }, { "name": "Juglandaceae", "code": "Juglandaceae" }, { "name": "Lauraceae", "code": "Lauraceae" }, { "name": "Magnoliaceae", "code": "Magnoliaceae" }, { "name": "Malvaceae", "code": "Malvaceae" }, { "name": "Meliaceae", "code": "Meliaceae" }, { "name": "Moraceae", "code": "Moraceae" }, { "name": "Myricaceae", "code": "Myricaceae" }, { "name": "Myrtaceae", "code": "Myrtaceae" }, { "name": "Nyssaceae", "code": "Nyssaceae" }, { "name": "Oleaceae", "code": "Oleaceae" }, { "name": "Paulowniaceae", "code": "Paulowniaceae" }, { "name": "Pinaceae", "code": "Pinaceae" }, { "name": "Platanaceae", "code": "Platanaceae" }, { "name": "Rhamnaceae", "code": "Rhamnaceae" }, { "name": "Rosaceae", "code": "Rosaceae" }, { "name": "Rubiaceae", "code": "Rubiaceae" }, { "name": "Salicaceae", "code": "Salicaceae" }, { "name": "Sapindaceae", "code": "Sapindaceae" }, { "name": "Simaroubaceae", "code": "Simaroubaceae" }, { "name": "Tamaricaceae", "code": "Tamaricaceae" }, { "name": "Taxaceae", "code": "Taxaceae" }, { "name": "Theaceae", "code": "Theaceae" }, { "name": "Ulmaceae", "code": "Ulmaceae" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Genus", "type": "esriFieldTypeString", "alias": "Genus", "length": 254, "domain": { "type": "codedValue", "name": "envGenus", "description": "Tree Genus", "codedValues": [ { "name": "Abies", "code": "Abies" }, { "name": "Acer", "code": "Acer" }, { "name": "Aesculus", "code": "Aesculus" }, { "name": "Ailanthus", "code": "Ailanthus" }, { "name": "Albizia", "code": "Albizia" }, { "name": "Alnus", "code": "Alnus" }, { "name": "Amelanchier", "code": "Amelanchier" }, { "name": "Aralia", "code": "Aralia" }, { "name": "Arbutus", "code": "Arbutus" }, { "name": "Asimina", "code": "Asimina" }, { "name": "Betula", "code": "Betula" }, { "name": "Callitropsis", "code": "Callitropsis" }, { "name": "Calocedrus", "code": "Calocedrus" }, { "name": "Carpinus", "code": "Carpinus" }, { "name": "Carya", "code": "Carya" }, { "name": "Castanea", "code": "Castanea" }, { "name": "Casuarina", "code": "Casuarina" }, { "name": "Celtis", "code": "Celtis" }, { "name": "Cephalanthus", "code": "Cephalanthus" }, { "name": "Cercis", "code": "Cercis" }, { "name": "Cercocarpus", "code": "Cercocarpus" }, { "name": "Chamaecyparis", "code": "Chamaecyparis" }, { "name": "Chilopsis", "code": "Chilopsis" }, { "name": "Chrysolepis", "code": "Chrysolepis" }, { "name": "Cornus", "code": "Cornus" }, { "name": "Corylus", "code": "Corylus" }, { "name": "Crataegus", "code": "Crataegus" }, { "name": "Cupressus", "code": "Cupressus" }, { "name": "Cyrilla", "code": "Cyrilla" }, { "name": "Dermatophyllum", "code": "Dermatophyllum" }, { "name": "Diospyros", "code": "Diospyros" }, { "name": "Elaeagnus", "code": "Elaeagnus" }, { "name": "Eucalyptus", "code": "Eucalyptus" }, { "name": "Fagus", "code": "Fagus" }, { "name": "Frangula", "code": "Frangula" }, { "name": "Fraxinus", "code": "Fraxinus" }, { "name": "Fremontodendron", "code": "Fremontodendron" }, { "name": "Ginkgo", "code": "Ginkgo" }, { "name": "Gleditsia", "code": "Gleditsia" }, { "name": "Gordonia", "code": "Gordonia" }, { "name": "Hamamelis", "code": "Hamamelis" }, { "name": "Heptapleurum", "code": "Heptapleurum" }, { "name": "Hesperocyparis", "code": "Hesperocyparis" }, { "name": "Ilex", "code": "Ilex" }, { "name": "Juglans", "code": "Juglans" }, { "name": "Juniperus", "code": "Juniperus" }, { "name": "Larix", "code": "Larix" }, { "name": "Ligustrum", "code": "Ligustrum" }, { "name": "Liquidambar", "code": "Liquidambar" }, { "name": "Liriodendron", "code": "Liriodendron" }, { "name": "Maclura", "code": "Maclura" }, { "name": "Magnolia", "code": "Magnolia" }, { "name": "Melaleuca", "code": "Melaleuca" }, { "name": "Melia", "code": "Melia" }, { "name": "Morus", "code": "Morus" }, { "name": "Myrica", "code": "Myrica" }, { "name": "Notholithocarpus", "code": "Notholithocarpus" }, { "name": "Nyssa", "code": "Nyssa" }, { "name": "Ostrya", "code": "Ostrya" }, { "name": "Oxydendrum", "code": "Oxydendrum" }, { "name": "Parkinsonia", "code": "Parkinsonia" }, { "name": "Paulownia", "code": "Paulownia" }, { "name": "Persea", "code": "Persea" }, { "name": "Picea", "code": "Picea" }, { "name": "Pinus", "code": "Pinus" }, { "name": "Platanus", "code": "Platanus" }, { "name": "Populus", "code": "Populus" }, { "name": "Prosopis", "code": "Prosopis" }, { "name": "Prunus", "code": "Prunus" }, { "name": "Pseudotsuga", "code": "Pseudotsuga" }, { "name": "Purshia", "code": "Purshia" }, { "name": "Pyrus", "code": "Pyrus" }, { "name": "Quercus", "code": "Quercus" }, { "name": "Rhamnus", "code": "Rhamnus" }, { "name": "Rhododendron", "code": "Rhododendron" }, { "name": "Rhus", "code": "Rhus" }, { "name": "Robinia", "code": "Robinia" }, { "name": "Sabal", "code": "Sabal" }, { "name": "Salix", "code": "Salix" }, { "name": "Sambucus", "code": "Sambucus" }, { "name": "Sapindus", "code": "Sapindus" }, { "name": "Sassafras", "code": "Sassafras" }, { "name": "Schinus", "code": "Schinus" }, { "name": "Senegalia", "code": "Senegalia" }, { "name": "Sequoia", "code": "Sequoia" }, { "name": "Sequoiadendron", "code": "Sequoiadendron" }, { "name": "Serenoa", "code": "Serenoa" }, { "name": "Shepherdia", "code": "Shepherdia" }, { "name": "Sorbus", "code": "Sorbus" }, { "name": "Spartium", "code": "Spartium" }, { "name": "Tamarix", "code": "Tamarix" }, { "name": "Taxodium", "code": "Taxodium" }, { "name": "Taxus", "code": "Taxus" }, { "name": "Thuja", "code": "Thuja" }, { "name": "Tilia", "code": "Tilia" }, { "name": "Torreya", "code": "Torreya" }, { "name": "Triadica", "code": "Triadica" }, { "name": "Tsuga", "code": "Tsuga" }, { "name": "Ulmus", "code": "Ulmus" }, { "name": "Umbellularia", "code": "Umbellularia" }, { "name": "Ungnadia", "code": "Ungnadia" }, { "name": "Vaccinium", "code": "Vaccinium" }, { "name": "Vachellia", "code": "Vachellia" }, { "name": "Washingtonia", "code": "Washingtonia" }, { "name": "Yucca", "code": "Yucca" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Species", "type": "esriFieldTypeString", "alias": "Tree Species", "length": 30, "domain": null }, { "name": "Cultivar", "type": "esriFieldTypeString", "alias": "Cultivar", "length": 254, "domain": { "type": "codedValue", "name": "envCultivar", "description": "Tree Cultivar", "codedValues": [ { "name": "Princeton", "code": "Princeton" }, { "name": "Valley Forge", "code": "Valley Forge" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CommonName", "type": "esriFieldTypeString", "alias": "Common Name", "length": 254, "domain": { "type": "codedValue", "name": "envCommonName", "description": "Tree Common Name", "codedValues": [ { "name": "American Elm", "code": "American Elm" }, { "name": "Balsam Poplar", "code": "Balsam Poplar" }, { "name": "Basswood", "code": "Basswood" }, { "name": "Black Locust", "code": "Black Locust" }, { "name": "Black Spruce", "code": "Black Spruce" }, { "name": "Blue Beech", "code": "Blue Beech" }, { "name": "Blue Spruce", "code": "Blue Spruce" }, { "name": "Boxelder", "code": "Boxelder" }, { "name": "Bur Oak", "code": "Bur Oak" }, { "name": "Common Hackberry", "code": "Common Hackberry" }, { "name": "Eastern Cottonwood", "code": "Eastern Cottonwood" }, { "name": "Eastern Redbud", "code": "Eastern Redbud" }, { "name": "Green Ash", "code": "Green Ash" }, { "name": "Honey-Locust", "code": "Honey-Locust" }, { "name": "Jack Pine", "code": "Jack Pine" }, { "name": "Northern Pin Oak", "code": "Northern Pin Oak" }, { "name": "Northern Red Oak", "code": "Northern Red Oak" }, { "name": "Norway Maple", "code": "Norway Maple" }, { "name": "Quaking Aspen", "code": "Quaking Aspen" }, { "name": "Red Pine", "code": "Red Pine" }, { "name": "Red Maple", "code": "Red Maple" }, { "name": "Red Spruce", "code": "Red Spruce" }, { "name": "River Birch", "code": "River Birch" }, { "name": "Siberian Elm", "code": "Siberian Elm" }, { "name": "Silver Maple", "code": "Silver Maple" }, { "name": "Sugar Maple", "code": "Sugar Maple" }, { "name": "Swamp White Oak", "code": "Swamp White Oak" }, { "name": "White Oak", "code": "White Oak" }, { "name": "White Pine", "code": "White Pine" }, { "name": "White Spruce", "code": "White Spruce" }, { "name": "Yellow Birch", "code": "Yellow Birch" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" }, { "name": "Alaska Willow", "code": "Alaska Willow" }, { "name": "Alaska-Cedar", "code": "Alaska-Cedar" }, { "name": "Allegheny Chinkapin", "code": "Allegheny Chinkapin" }, { "name": "Alligator Juniper", "code": "Alligator Juniper" }, { "name": "Alpine Larch", "code": "Alpine Larch" }, { "name": "Alternate-Leaf Dogwood", "code": "Alternate-Leaf Dogwood" }, { "name": "American Basswood", "code": "American Basswood" }, { "name": "American Beech", "code": "American Beech" }, { "name": "American Holly", "code": "American Holly" }, { "name": "American Hornbeam", "code": "American Hornbeam" }, { "name": "American Mountain-Ash", "code": "American Mountain-Ash" }, { "name": "American Plum", "code": "American Plum" }, { "name": "Apache Pine", "code": "Apache Pine" }, { "name": "Arizona Cypress", "code": "Arizona Cypress" }, { "name": "Arizona Madrone", "code": "Arizona Madrone" }, { "name": "Arizona Pine", "code": "Arizona Pine" }, { "name": "Arizona Walnut", "code": "Arizona Walnut" }, { "name": "Arizona White Oak", "code": "Arizona White Oak" }, { "name": "Ashe Juniper", "code": "Ashe Juniper" }, { "name": "Athel Tamarisk", "code": "Athel Tamarisk" }, { "name": "Atlantic White-Cedar", "code": "Atlantic White-Cedar" }, { "name": "Australian-Pine", "code": "Australian-Pine" }, { "name": "Autumn-Olive", "code": "Autumn-Olive" }, { "name": "Baker Cypress", "code": "Baker Cypress" }, { "name": "Baldcypress", "code": "Baldcypress" }, { "name": "Balsam Fir", "code": "Balsam Fir" }, { "name": "Bear Oak", "code": "Bear Oak" }, { "name": "Bebb Willow", "code": "Bebb Willow" }, { "name": "Bigcone Douglas-Fir", "code": "Bigcone Douglas-Fir" }, { "name": "Bigleaf Maple", "code": "Bigleaf Maple" }, { "name": "Bigtooth Aspen", "code": "Bigtooth Aspen" }, { "name": "Bigtooth Maple", "code": "Bigtooth Maple" }, { "name": "Bishop Pine", "code": "Bishop Pine" }, { "name": "Bitter Cherry", "code": "Bitter Cherry" }, { "name": "Bitternut Hickory", "code": "Bitternut Hickory" }, { "name": "Black Ash", "code": "Black Ash" }, { "name": "Black Cherry", "code": "Black Cherry" }, { "name": "Black Cottonwood", "code": "Black Cottonwood" }, { "name": "Black Oak", "code": "Black Oak" }, { "name": "Black Tupelo", "code": "Black Tupelo" }, { "name": "Black Walnut", "code": "Black Walnut" }, { "name": "Black Willow", "code": "Black Willow" }, { "name": "Blackjack Oak", "code": "Blackjack Oak" }, { "name": "Blue Elderberry", "code": "Blue Elderberry" }, { "name": "Blue Oak", "code": "Blue Oak" }, { "name": "Blue Paloverde", "code": "Blue Paloverde" }, { "name": "Bluegum Eucalyptus", "code": "Bluegum Eucalyptus" }, { "name": "Bluejack Oak", "code": "Bluejack Oak" }, { "name": "Brazilian Pepper", "code": "Brazilian Pepper" }, { "name": "Brewer Spruce", "code": "Brewer Spruce" }, { "name": "Bristlecone Fir", "code": "Bristlecone Fir" }, { "name": "Butternut", "code": "Butternut" }, { "name": "Buttonbush", "code": "Buttonbush" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TreeCondition", "type": "esriFieldTypeString", "alias": "Tree Condition", "length": 30, "domain": { "type": "codedValue", "name": "envTreeCondition", "description": "Tree Condition", "codedValues": [ { "name": "Planting Site", "code": "Planting Site" }, { "name": "Dead", "code": "Dead" }, { "name": "Stump", "code": "Stump" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Poor", "code": "Poor" }, { "name": "Fair", "code": "Fair" }, { "name": "Good", "code": "Good" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Recommendation", "type": "esriFieldTypeString", "alias": "Recommendation", "length": 30, "domain": { "type": "codedValue", "name": "envRecommendation", "description": "Tree Recommendation", "codedValues": [ { "name": "Available", "code": "Available" }, { "name": "Planted", "code": "Planted" }, { "name": "Remove", "code": "Remove" }, { "name": "Remove/Treat Stump", "code": "Remove/Treat Stump" }, { "name": "Remove/Grind Stump", "code": "Remove/Grind Stump" }, { "name": "Grind Stump", "code": "Grind Stump" }, { "name": "Prune", "code": "Prune" }, { "name": "None", "code": "None" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TreeStatus", "type": "esriFieldTypeString", "alias": "Tree Status", "length": 30, "domain": { "type": "codedValue", "name": "envTreeStatus", "description": "Tree Status", "codedValues": [ { "name": "Inspected", "code": "Inspected" }, { "name": "Submitted", "code": "Submitted" }, { "name": "Scheduled", "code": "Scheduled" }, { "name": "Removed(Stump)", "code": "Removed(Stump)" }, { "name": "Complete", "code": "Complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter at breast height", "domain": null }, { "name": "Height", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null }, { "name": "HeightUnit", "type": "esriFieldTypeString", "alias": "Height Units", "length": 50, "domain": { "type": "codedValue", "name": "envHeightUnits", "description": "Tree Height Units", "codedValues": [ { "name": "Feet", "code": "Feet" }, { "name": "Meters", "code": "Meters" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Date planted", "length": 8, "domain": null }, { "name": "TreeWires", "type": "esriFieldTypeString", "alias": "Tree Wires", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TreeGuard", "type": "esriFieldTypeString", "alias": "Tree Guard", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Designation", "type": "esriFieldTypeString", "alias": "Special designation", "length": 254, "domain": { "type": "codedValue", "name": "envDesignation", "description": "Tree Designation", "codedValues": [ { "name": "Memorial", "code": "Memorial" }, { "name": "Dedication", "code": "Dedication" }, { "name": "Heritage", "code": "Heritage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OverheadUtilities", "type": "esriFieldTypeString", "alias": "Overhead Utilities", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Warranty", "type": "esriFieldTypeString", "alias": "Warranty", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "WaterThroughDate", "type": "esriFieldTypeDate", "alias": "Water Through Date", "length": 8, "domain": null }, { "name": "ResidentTreating", "type": "esriFieldTypeString", "alias": "Resident Treating", "length": 5, "domain": { "type": "codedValue", "name": "envResidentTreating", "description": "Tree Resident Treating", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LastTreatment", "type": "esriFieldTypeString", "alias": "Last Treatment", "length": 50, "domain": null }, { "name": "TreeNotes", "type": "esriFieldTypeString", "alias": "Tree Notes", "length": 4000, "domain": null }, { "name": "RetireDate", "type": "esriFieldTypeDate", "alias": "Retire Date", "length": 8, "domain": null }, { "name": "SpaceId", "type": "esriFieldTypeString", "alias": "Planting space identifier", "length": 50, "domain": null }, { "name": "SpaceStatus", "type": "esriFieldTypeString", "alias": "Planting space status", "length": 50, "domain": { "type": "codedValue", "name": "envSpaceStatus", "description": "Tree Space Status", "codedValues": [ { "name": "Available", "code": "Available" }, { "name": "Planted", "code": "Planted" }, { "name": "Stump", "code": "Stump" }, { "name": "Retired", "code": "Retired" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SpaceType", "type": "esriFieldTypeString", "alias": "Planting space type", "length": 50, "domain": { "type": "codedValue", "name": "envSpaceType", "description": "Tree Space Type", "codedValues": [ { "name": "Bark", "code": "Bark" }, { "name": "Brick", "code": "Brick" }, { "name": "Grass", "code": "Grass" }, { "name": "Grate", "code": "Grate" }, { "name": "Gravel", "code": "Grave" }, { "name": "Mulch", "code": "Mulch" }, { "name": "Pavers", "code": "Pavers" }, { "name": "Soil", "code": "Soil" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SiteType", "type": "esriFieldTypeString", "alias": "Site Type", "length": 50, "domain": { "type": "codedValue", "name": "envSiteType", "description": "Tree Site Type", "codedValues": [ { "name": "Boulevard", "code": "Boulevard" }, { "name": "Traffic circle", "code": "Circle" }, { "name": "Traffic island", "code": "Island" }, { "name": "Traffic median", "code": "Median" }, { "name": "Boundary", "code": "Boundary" }, { "name": "Park", "code": "Park" }, { "name": "Landscape area", "code": "Landscape" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SpaceWidth", "type": "esriFieldTypeDouble", "alias": "Planting space width", "domain": null }, { "name": "SpaceLength", "type": "esriFieldTypeDouble", "alias": "Planting space length", "domain": null }, { "name": "SpaceNotes", "type": "esriFieldTypeString", "alias": "Planting space notes", "length": 4000, "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 2, "domain": { "type": "codedValue", "name": "geCountyCodeDept", "description": "geCountyCodeDept", "codedValues": [ { "name": "Communications", "code": "CO" }, { "name": "Corrections", "code": "CR" }, { "name": "County Assessors", "code": "AS" }, { "name": "County Attorney", "code": "AT" }, { "name": "County Board", "code": "CB" }, { "name": "County Managers Office", "code": "CM" }, { "name": "Elections Services", "code": "ES" }, { "name": "Emergency Communications", "code": "EC" }, { "name": "Emergency Management & Homeland Security", "code": "EM" }, { "name": "FAS", "code": "FA" }, { "name": "Health & Wellness Administration", "code": "HW" }, { "name": "Information Services", "code": "IS" }, { "name": "IPR Enterprise Services Team", "code": "IP" }, { "name": "Parks and Recreation", "code": "PR" }, { "name": "Property Management", "code": "PM" }, { "name": "Public Library", "code": "PL" }, { "name": "Public Works", "code": "PW" }, { "name": "Service Center", "code": "SC" }, { "name": "Sheriff Office", "code": "SO" }, { "name": "Social Services", "code": "SS" }, { "name": "Veteran Services", "code": "VS" }, { "name": "Workforce Solutions", "code": "WS" }, { "name": "Assessors Office", "code": "AO" }, { "name": "Public Health", "code": "PH" }, { "name": "Strategic Team", "code": "ST" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OwnedBy", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "envOwnedBy", "description": "Tree Owned By", "codedValues": [ { "name": "Public Works", "code": 0 }, { "name": "Parks & Recreation", "code": 1 }, { "name": "Municipal", "code": 2 }, { "name": "Private", "code": 3 }, { "name": "Other", "code": 4 }, { "name": "Railroad", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MaintBy", "type": "esriFieldTypeSmallInteger", "alias": "Maintained by", "domain": { "type": "codedValue", "name": "envMaintainedBy", "description": "Tree Maintained By", "codedValues": [ { "name": "Public Works", "code": 0 }, { "name": "Parks & Recreation", "code": 1 }, { "name": "Municipal", "code": 2 }, { "name": "Private", "code": 3 }, { "name": "Contractor", "code": 4 }, { "name": "Other", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectedBy", "type": "esriFieldTypeSmallInteger", "alias": "Collected By", "domain": { "type": "codedValue", "name": "envCollectedBy", "description": "Tree Collected By", "codedValues": [ { "name": "Public Works", "code": 0 }, { "name": "Parks & Recreation", "code": 1 }, { "name": "Municipal", "code": 2 }, { "name": "Private", "code": 3 }, { "name": "Other", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PublicView", "type": "esriFieldTypeString", "alias": "Publicly Visibile", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Stormwater", "type": "esriFieldTypeDouble", "alias": "Stormwater intercepted", "domain": null }, { "name": "Energy", "type": "esriFieldTypeDouble", "alias": "Energy conserved", "domain": null }, { "name": "Pollutants", "type": "esriFieldTypeDouble", "alias": "Air pollutants removed", "domain": null }, { "name": "CO2", "type": "esriFieldTypeDouble", "alias": "Carbon dioxide reduced", "domain": null }, { "name": "PropValue", "type": "esriFieldTypeDouble", "alias": "Increased property value", "domain": null }, { "name": "Benefits", "type": "esriFieldTypeDouble", "alias": "Total value of benefits", "domain": null }, { "name": "AdoptionStatus", "type": "esriFieldTypeString", "alias": "Adoption Status", "length": 50, "domain": { "type": "codedValue", "name": "envAdoptionStatus", "description": "Tree Adoption Status", "codedValues": [ { "name": "Available", "code": "Available" }, { "name": "Adopted", "code": "Adopted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AdoptedBy", "type": "esriFieldTypeString", "alias": "Adopted By", "length": 254, "domain": null }, { "name": "AdoptedOn", "type": "esriFieldTypeDate", "alias": "Adopted On", "length": 8, "domain": null }, { "name": "Nickname", "type": "esriFieldTypeString", "alias": "Nickname", "length": 254, "domain": null }, { "name": "DateCollected", "type": "esriFieldTypeDate", "alias": "Date Collected", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FeatureUniqueID", "type": "esriFieldTypeString", "alias": "FeatureUniqueID", "length": 20, "domain": null }, { "name": "ReadyForAW", "type": "esriFieldTypeString", "alias": "ReadyForAW", "length": 3, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 254, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 254, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited On", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R9469_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_9469", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_9469", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S8145_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "RCTreeInventory_ATTACH", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 1, "name": "RCTreeInventory_Inspections", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "RCTreeInventory_Maintenance", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.71, "id": 1, "name": "GISTrans.GISPUB.RCTreeInventory_ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R9470_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_149594_REL_G", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_9470", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_9470", "fields": "GlobalID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "RCTreeInventory", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }, { "currentVersion": 10.71, "id": 2, "name": "GISTrans.GISPUB.RCTreeInventory_Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspectType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "InspectType", "type": "esriFieldTypeString", "alias": "Inspection type", "length": 50, "domain": { "type": "codedValue", "name": "envInspectionType", "description": "Tree Inspection Type", "codedValues": [ { "name": "Tree", "code": "Tree" }, { "name": "Planting Space", "code": "Planting Space" }, { "name": "Tree and Planting Space", "code": "Tree and Planting Space" }, { "name": "Sidewalk", "code": "Sidewalk" }, { "name": "All", "code": "All" }, { "name": "Planting Area", "code": "Planting Area" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectDate", "type": "esriFieldTypeDate", "alias": "Inspection date", "length": 8, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "envInspStatus", "description": "Tree Inspection Status", "codedValues": [ { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" }, { "name": "Paused", "code": "Paused" }, { "name": "Canceled", "code": "Canceled" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TreeCondition", "type": "esriFieldTypeSmallInteger", "alias": "Tree condition", "domain": { "type": "codedValue", "name": "envInspCondition", "description": "Tree Inspection Condition", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Very Poor", "code": 1 }, { "name": "Poor", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Good", "code": 4 }, { "name": "Very Good", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SpaceCondition", "type": "esriFieldTypeSmallInteger", "alias": "Planting space condition", "domain": { "type": "codedValue", "name": "envInspCondition", "description": "Tree Inspection Condition", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Very Poor", "code": 1 }, { "name": "Poor", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Good", "code": 4 }, { "name": "Very Good", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SidewalkCondition", "type": "esriFieldTypeSmallInteger", "alias": "Sidewalk condition", "domain": { "type": "codedValue", "name": "envInspCondition", "description": "Tree Inspection Condition", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Very Poor", "code": 1 }, { "name": "Poor", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Good", "code": 4 }, { "name": "Very Good", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pests", "type": "esriFieldTypeString", "alias": "Evidence of pests", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Disease", "type": "esriFieldTypeString", "alias": "Evidence of disease", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SidewalkDamage", "type": "esriFieldTypeString", "alias": "Sidewalk damage", "length": 5, "domain": { "type": "codedValue", "name": "geYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Inspection notes", "length": 4000, "domain": null }, { "name": "assetglobalid", "type": "esriFieldTypeGUID", "alias": "Tree GlobalID", "length": 38, "domain": null }, { "name": "plantingareaglobalid", "type": "esriFieldTypeGUID", "alias": "Planting Area GlobalID", "length": 38, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited On", "length": 8, "domain": null }, { "name": "PlantingAreaCondition", "type": "esriFieldTypeSmallInteger", "alias": "Planting Area condition", "domain": { "type": "codedValue", "name": "envPlantingAreaCondition", "description": "Tree Planting Area Condition", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Very Poor", "code": 1 }, { "name": "Poor", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Good", "code": 4 }, { "name": "Very Good", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParentGlobalID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R9476_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_9476", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_149908_Paren", "fields": "ParentGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_9476", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "RCTreeInventory", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.71, "id": 3, "name": "GISTrans.GISPUB.RCTreeInventory_Inspections__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R9477_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_9477", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_149909_REL_G", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_9477", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }, { "currentVersion": 10.71, "id": 4, "name": "GISTrans.GISPUB.RCTreeInventory_Maintenance", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MaintType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MaintType", "type": "esriFieldTypeString", "alias": "Maintenance type", "length": 50, "domain": { "type": "codedValue", "name": "envMaintenanceType", "description": "Tree Maintenance Type", "codedValues": [ { "name": "Debris Removal", "code": "Debris Removal" }, { "name": "Hazard Removal", "code": "Hazard Removal" }, { "name": "Pest & Disease Treatment", "code": "Pest & Disease Treatment" }, { "name": "Pruning & Canopy Reduction", "code": "Pruning & Canopy Reduction" }, { "name": "Sidewalk Repair", "code": "Sidewalk Repair" }, { "name": "Stump Removal", "code": "Stump Removal" }, { "name": "Tree Planting", "code": "Tree Planting" }, { "name": "Tree Removal", "code": "Tree Removal" }, { "name": "Tree Repair", "code": "Tree Repair" }, { "name": "Tree Watering", "code": "Tree Watering" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "Start date", "length": 8, "domain": null }, { "name": "MaintDate", "type": "esriFieldTypeDate", "alias": "Date finished", "length": 8, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "envInspStatus", "description": "Tree Inspection Status", "codedValues": [ { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" }, { "name": "Paused", "code": "Paused" }, { "name": "Canceled", "code": "Canceled" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Maintenance notes", "length": 4000, "domain": null }, { "name": "assetglobalid", "type": "esriFieldTypeGUID", "alias": "Tree GlobalID", "length": 38, "domain": null }, { "name": "plantingareaglobalid", "type": "esriFieldTypeGUID", "alias": "Planting Area GlobalID", "length": 38, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited On", "length": 8, "domain": null }, { "name": "ParentGlobalID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R9478_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_9478", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_149610_Paren", "fields": "ParentGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_9478", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "RCTreeInventory", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.71, "id": 5, "name": "GISTrans.GISPUB.RCTreeInventory_Maintenance__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R9479_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_9479", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_149611_REL_G", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_9479", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } } ] }