Name: Street Trees

Display Field: COMMON_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 5000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8974796.07579441
YMin: 5378806.22545638
XMax: -8958584.50207318
YMax: 5393146.25653572
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"a9de4a131f32602f50ceb3128a2c3437","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAAWCAYAAADNX8xBAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACeklEQVQ4jb3UzU8TQRgG8GfabUu7haUBBS0tH9KQuEQ0lohIUD6SWqIXDx48GI8kHvRkjBeJ0ehRjh7wD0APJsbDRoWYIEnFKo00KC3hs0HA1m2gpGx3Z8xyUD7aggnhuexkduY3877ZLId9Cncg0ODUYEERVTo1CsIr5kFRbFv9L2gkKvkB+FflZRctEl4Tgr41s/J0YLTf7eLt1zyervVdoWBUaqcgdwiYR6OZV2Dom5mehMtVdUtJp0mSFwIjEelho8f3Mi+0sBjrsduFUysrSVZe7rypz1VWHdMfpKS0DAykWFHSL4JRqeN0rW8gKxQYf1dCTJkaQgzDdt4uMqBw+0EETFlaXIDVyp8HkB0ymLQ+wOAkDJ8YYMvWPwZ4KlxV+vAegPs7IMZ6DENja+vx+LLsrKhcAeBAnlBKueEf753NdR2xLRAhPTQYlZ6RQ2UtAK4zMImA+PR3qqaCM25t59jYF7gr3OcA9O8ojRJ0WyzWXgDVBOj+e23jv2WMURqLzWpKOh0pLD3yIWuPQA2P5WTiro23us0mi/6tWDaVAk1TMfo1oAqCI2Wz2fimms7FrFCmQJsRIDwIzy/E1LlJR41Y32vkTJdlOY6JifDb4iKHrbzsqDgRGU9caOu6sXnvFqjZdTHxeUo6PBP82E449sQ8b5/Xm69qakI8frI1KSciy/Eleqax9XZTnX8oJ6THW+37HgpJc6kCJTA7PX2FM8phAPXxxK+fTNWCDd6WR5tLygnpaWjwpQCkQiHpeW3JWcXr9WbC4X6zKF5Vsq3PCW0DN5IPObj/kR7GGPk2+6b4ROWl3xsTObIrRAhhAPIie4L2mn2D/gAmHvjvAXKUyAAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":16,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• TREE_ID (type: esriFieldTypeInteger, alias: TREE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSET_ID (type: esriFieldTypeInteger, alias: ASSET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEGMENT_ID (type: esriFieldTypeInteger, alias: SEGMENT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VAIL_ID (type: esriFieldTypeDouble, alias: VAIL_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CIVIC_ADDRESS (type: esriFieldTypeString, alias: CIVIC_ADDRESS, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Existing: Existing], [Stump: Stump], ... 5 more ...)
• SPECIES (type: esriFieldTypeString, alias: SPECIES, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Acca: Acca], [Acfr: Acfr], [Acgi: Acgi], ... 113 more ...)
• COMMON_NAME (type: esriFieldTypeString, alias: COMMON_NAME, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Alder, speckled: Alder, speckled], [Ash, black: Ash, black], [Ash, blue: Ash, blue], ... 113 more ...)
• LATIN_NAME (type: esriFieldTypeString, alias: LATIN_NAME, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Acer campestre: Acer campestre], [Acer x freemanii: Acer x freemanii], [Acer ginnala: Acer ginnala], ... 113 more ...)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [City of Waterloo: City of Waterloo], [City of Kitchener: City of Kitchener], [Region of Waterloo: Region of Waterloo], ... 10 more ...)
• PERCENT_OWNED (type: esriFieldTypeSmallInteger, alias: PERCENT_OWNED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINTAINED_BY (type: esriFieldTypeString, alias: MAINTAINED_BY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [City of Waterloo: City of Waterloo], [City of Kitchener: City of Kitchener], [Region of Waterloo: Region of Waterloo], ... 10 more ...)
• FORESTRY_ZONE (type: esriFieldTypeString, alias: FORESTRY_ZONE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1E: 1E], [1W: 1W], [2: 2], ... 4 more ...)
• FORESTRY_SUBZONE (type: esriFieldTypeString, alias: FORESTRY_SUBZONE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 3 more ...)
• TREE_TYPE (type: esriFieldTypeString, alias: TREE_TYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Cemetery: Cemetery], [Facility: Facility], [Park: Park], ... 2 more ...)
• PROPOSED_SEASON (type: esriFieldTypeString, alias: PROPOSED_SEASON, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [F: F], [S: S])
• PROPOSED_YEAR (type: esriFieldTypeString, alias: PROPOSED_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DATE_RECORDED (type: esriFieldTypeDate, alias: DATE_RECORDED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PLANTING_ORDER1 (type: esriFieldTypeSmallInteger, alias: PLANTING_ORDER1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLANTING_ORDER2 (type: esriFieldTypeSmallInteger, alias: PLANTING_ORDER2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATE_PLANTED (type: esriFieldTypeDate, alias: DATE_PLANTED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WARRANTY_END (type: esriFieldTypeDate, alias: WARRANTY_END, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DEDICATION (type: esriFieldTypeString, alias: DEDICATION, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• DEDICATION_DETAILS (type: esriFieldTypeString, alias: DEDICATION_DETAILS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Young: Young], [Actively Growing: Actively Growing], [Mature: Mature], ... 2 more ...)
• DBH_CODE (type: esriFieldTypeSmallInteger, alias: DBH_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
• DIST_FROM_CURB (type: esriFieldTypeSmallInteger, alias: DIST_FROM_CURB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TREEL2R (type: esriFieldTypeString, alias: TREEL2R, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• BRACE_CABLE (type: esriFieldTypeString, alias: BRACE_CABLE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• BRACE_MATERIAL (type: esriFieldTypeString, alias: BRACE_MATERIAL, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• BRACE_CABLE_INSTALL (type: esriFieldTypeDate, alias: BRACE_CABLE_INSTALL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REMOVED_DATE (type: esriFieldTypeDate, alias: REMOVED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REMOVED_REASON (type: esriFieldTypeString, alias: REMOVED_REASON, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [EAB: EAB], [Storm: Storm], [Accident: Accident], ... 14 more ...)
• INSPECTION_SPRING (type: esriFieldTypeString, alias: INSPECTION_SPRING, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• INSPECTION_YEARLY (type: esriFieldTypeString, alias: INSPECTION_YEARLY, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• STORM_DAMAGE (type: esriFieldTypeString, alias: STORM_DAMAGE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ACCOUNT_NO (type: esriFieldTypeSmallInteger, alias: ACCOUNT_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNIT (type: esriFieldTypeString, alias: UNIT, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• COMMENTS_OLD (type: esriFieldTypeString, alias: COMMENTS_OLD, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• OLD_ADDRESS (type: esriFieldTypeString, alias: OLD_ADDRESS, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• CREATE_USER (type: esriFieldTypeString, alias: CREATE_USER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• CREATE_DATE (type: esriFieldTypeDate, alias: CREATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• UPDATE_USER (type: esriFieldTypeString, alias: UPDATE_USER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• UPDATE_DATE (type: esriFieldTypeDate, alias: UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• OVERHEAD_HYDRO (type: esriFieldTypeString, alias: OVERHEAD_HYDRO, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• DBH_CM (type: esriFieldTypeSmallInteger, alias: DBH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STUMP_SIZE (type: esriFieldTypeSmallInteger, alias: STUMP_SIZE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STAKED (type: esriFieldTypeString, alias: STAKED, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PLANTING_REASON (type: esriFieldTypeString, alias: PLANTING_REASON, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [EAB: EAB], [Accident: Accident], [Non Ash: Non Ash], ... 4 more ...)
• AGREEMENT (type: esriFieldTypeString, alias: AGREEMENT, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [EAB: EAB], [Planting: Planting], [Removal: Removal])
• AGREEMENT_NOTES (type: esriFieldTypeString, alias: AGREEMENT_NOTES, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• TOOL_DATE (type: esriFieldTypeDate, alias: TOOL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BILL_TO (type: esriFieldTypeString, alias: BILL_TO, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• TREEAZIN_DATE (type: esriFieldTypeDate, alias: TREEAZIN_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TREEAZIN_TREATMENT (type: esriFieldTypeString, alias: TREEAZIN_TREATMENT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [City: City], [Resident: Resident])
• DBH_DATE (type: esriFieldTypeDate, alias: DBH_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_PLANTED_TYPE (type: esriFieldTypeString, alias: DATE_PLANTED_TYPE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_PLANTED_SOURCE (type: esriFieldTypeString, alias: DATE_PLANTED_SOURCE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• ROAD_RECONSTR_YEAR (type: esriFieldTypeString, alias: ROAD_RECONSTR_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• INSPECTION_DATE (type: esriFieldTypeDate, alias: INSPECTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BRACE_CABLE_NOTES (type: esriFieldTypeString, alias: BRACE_CABLE_NOTES, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BRACE_CABLE_INSP (type: esriFieldTypeDate, alias: BRACE_CABLE_INSP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STATUS_ORIG (type: esriFieldTypeString, alias: STATUS_ORIG, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• SPECIES_ORIG (type: esriFieldTypeString, alias: SPECIES_ORIG, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• COMMON_NAME_ORIG (type: esriFieldTypeString, alias: COMMON_NAME_ORIG, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LATIN_NAME_ORIG (type: esriFieldTypeString, alias: LATIN_NAME_ORIG, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• CABLE_NUMBER (type: esriFieldTypeInteger, alias: CABLE_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDITION_HEALTH (type: esriFieldTypeString, alias: CONDITION_HEALTH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DAVEY_ID (type: esriFieldTypeSmallInteger, alias: DAVEY_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATA_SOURCE (type: esriFieldTypeString, alias: DATA_SOURCE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FACILITY_NAME (type: esriFieldTypeString, alias: FACILITY_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: Street Trees
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/27/2023 2:50:12 PM

Schema Last Edit Date: 4/27/2023 2:50:12 PM

Data Last Edit Date: 4/27/2023 2:50:12 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat