Name: TreeInventoryActive_Testing

Display Field: botname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8878456.76706244
YMin: 5396202.30519051
XMax: -8867682.19094635
YMax: 5399654.35769309
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[42,98,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• botname (type: esriFieldTypeString, alias: BOTNAME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ALEUOO: EUROPEAN ALDER], [ALOOOO: ALDER SPP.], [ALSPOO: SPECKLED ALDER], ... 278 more ...)
• unittype (type: esriFieldTypeString, alias: UNITTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• stemno (type: esriFieldTypeInteger, alias: STEMNO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 5 more ...)
• diam (type: esriFieldTypeDouble, alias: DIAM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diam2 (type: esriFieldTypeDouble, alias: DIAM2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diam3 (type: esriFieldTypeDouble, alias: DIAM3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diam4 (type: esriFieldTypeDouble, alias: DIAM4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diam5 (type: esriFieldTypeDouble, alias: DIAM5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diam6 (type: esriFieldTypeDouble, alias: DIAM6, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diam7 (type: esriFieldTypeDouble, alias: DIAM7, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diam8 (type: esriFieldTypeDouble, alias: DIAM8, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wireht (type: esriFieldTypeDouble, alias: WIREHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• condrat (type: esriFieldTypeDouble, alias: CONDRAT, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Very Good], [2: Good], [3: Fair], ... 4 more ...)
• compkey (type: esriFieldTypeDouble, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• loc (type: esriFieldTypeString, alias: LOC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [FRONT: Front], [BACK: Back], [SIDE: Side], ... 3 more ...)
• xcoord (type: esriFieldTypeDouble, alias: XCOORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ycoord (type: esriFieldTypeDouble, alias: YCOORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• own (type: esriFieldTypeString, alias: OWN, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [MISS: Mississauga], [BOUN: Boundary/Shared], [HYDRO: Hydro], ... 9 more ...)
• servstat (type: esriFieldTypeString, alias: SERVSTAT, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true, Coded Values: [OPS: Tree Maintained by City], [MNTC: Maintained by City, not owner], [PRIV: Private], ... 8 more ...)
• spacetype (type: esriFieldTypeString, alias: SPACETYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [BLVD: Boulevard], [RF: Residential Frontage], [REV/FRTG: Reverse Frontage], ... 6 more ...)
• struccond (type: esriFieldTypeInteger, alias: Risk Rating, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Very Low], [2: Low], [3: Medium], ... 2 more ...)
• inventoried (type: esriFieldTypeString, alias: INVENTORIED, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [2023: 2023], [2024: 2024], [Y: Yes], ... 1 more ...)
• zarea (type: esriFieldTypeString, alias: ZAREA, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• instdate (type: esriFieldTypeDate, alias: INSTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• addrkey (type: esriFieldTypeDouble, alias: ADDRKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• botdesc (type: esriFieldTypeString, alias: BOTDESC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• unitid (type: esriFieldTypeString, alias: UNITID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• addrqual (type: esriFieldTypeString, alias: ADDRQUAL, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• adddttm (type: esriFieldTypeDate, alias: ADDDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• moddttm (type: esriFieldTypeDate, alias: MODDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• cent_x_3857 (type: esriFieldTypeDouble, alias: CENT_X_3857, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cent_y_3857 (type: esriFieldTypeDouble, alias: CENT_Y_3857, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wo (type: esriFieldTypeInteger, alias: WO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• url_lnk (type: esriFieldTypeString, alias: URL_LNK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• treetype (type: esriFieldTypeString, alias: TREETYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• biodefect (type: esriFieldTypeSmallInteger, alias: BioPestPresence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Minor], [3: Moderate], ... 1 more ...)
• structuredefect (type: esriFieldTypeSmallInteger, alias: SCoDominant, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Minor], [3: Moderate], ... 1 more ...)
• tef (type: esriFieldTypeString, alias: TEFStake, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Acceptable: Acceptable], [Replace: Replacement Feature], [Remove: Remove Feature])
• MulchRing (type: esriFieldTypeString, alias: MulchRing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Acceptable: Acceptable], [Replace: Replacement Feature], [Remove: Remove Feature])
• wireconflict (type: esriFieldTypeSmallInteger, alias: WireConflict, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Minor], [3: Moderate], ... 1 more ...)
• encroachment (type: esriFieldTypeSmallInteger, alias: EncroachmentSignage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Minor], [3: Moderate], ... 1 more ...)
• activity (type: esriFieldTypeString, alias: ACTIVITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No Action: No Action], [Prune: Prune], [Removal: Removal], ... 2 more ...)
• priority (type: esriFieldTypeString, alias: PRIORITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NWR: No work required], [Low: Low], [Medium: Medium], ... 2 more ...)
• hardwarecb (type: esriFieldTypeString, alias: HARDWARECB, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PlantType (type: esriFieldTypeString, alias: PlantType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [HS: Hardscape], [M: Memorial], [Bed: Planting Bed], ... 1 more ...)
• stumpobstruction (type: esriFieldTypeString, alias: StumpObstruction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Removable: Removable], [Permanent: Permanent], [Horticultural: Horticultural], ... 2 more ...)
• suckering (type: esriFieldTypeString, alias: Suckering, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• review (type: esriFieldTypeString, alias: Review, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• AuditScore (type: esriFieldTypeDouble, alias: AuditScore, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0.0], [0.200000003: 0.2], [0.400000006: 0.4], ... 3 more ...)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• NewXC (type: esriFieldTypeDouble, alias: NewXC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NewYC (type: esriFieldTypeDouble, alias: NewYC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: TreeInventoryActive_Testing
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• stemno: 1
• diam: 5
• diam2: 5
• diam3: 0
• diam4: 0
• diam5: 0
• diam6: 0
• diam7: 0
• diam8: 0
• biodefect: 1
• structuredefect: 1
• wireconflict: 1
• encroachment: 1
• hardwarecb: No
• suckering: No
• review: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/22/2025 1:10:43 PM

Schema Last Edit Date: 4/22/2025 1:10:43 PM

Data Last Edit Date: 4/22/2025 1:10:43 PM

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