Layers:

Layer: Trees (0)


Name: Trees

Display Field: site_x_lon

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description: tree_layer

Copyright Text:

Min. Scale: 913534

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8126195.6323
YMin: 5049523.9089
XMax: -8117286.369
YMax: 5060902.0339
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":null,"valueExpression":"// Write a script that returns a value that will be used to draw features.\n// For example, find the percentage of males:\n// Round(($feature.MalePop / $feature.TotalPop) * 100, 2)\n\nif( $feature[\"prop_priority_dedication\"] != null ){ return 'Dedication' }\nelse if ( $feature[\"prop_priority_noteworthy\"] == 'Y'){ return 'Noteworthy' }\nelse if ( $feature[\"prop_priority_raretaxonomy\"] == 'Y'){ return 'Rare' }\nelse if ( $feature[\"prop_priority_specimen\"] == 'Y'){ return 'Specimen' }\nelse { return null }","valueExpressionTitle":"Custom","uniqueValueInfos":[{"value":"Specimen","symbol":{"color":[255,255,0,255],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSDiamond","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Specimen"}]},"transparency":2}

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• tree_tag_no (type: esriFieldTypeInteger, alias: Tag Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prop_priority_dedication (type: esriFieldTypeString, alias: Priority Dedication, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Memorial: Personal/Class/Historical Tree], [Milestone: YHR Milestone Tree], [Other: Other])
• prop_priority_specimen (type: esriFieldTypeString, alias: Priority Specimen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• prop_priority_raretaxonomy (type: esriFieldTypeString, alias: Priority Rare, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• prop_priority_noteworthy (type: esriFieldTypeString, alias: Priority Noteworthy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• site_addr_state: CT
• site_addr_county: New Haven

Relationships:
• Tree Tasks (0) -- Related To: tasks (2)
• Tree History (1) -- Related To: Versions (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/15/2024 5:51:22 PM

Schema Last Edit Date: 11/15/2024 5:51:22 PM

Data Last Edit Date: 11/15/2024 5:51:22 PM

Layer: Versions (1)


Name: Versions

Display Field: site_x_lon

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description: History

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -20037507.8427882
YMin: -30240971.4583861
XMax: 20037507.8427882
YMax: 30240971.4583861
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[58,107,142,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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• site_x_lon (type: esriFieldTypeSingle, alias: site_x_lon, SQL Type: sqlTypeOther, nullable: true, editable: true)
• site_y_lat (type: esriFieldTypeSingle, alias: site_y_lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• site_addr_no (type: esriFieldTypeSmallInteger, alias: Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• site_addr_street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_addr_unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_addr_zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_addr_region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_addr_state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_addr_county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_addr_muni (type: esriFieldTypeString, alias: Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_addr_full (type: esriFieldTypeString, alias: FullAddress, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_app_area (type: esriFieldTypeString, alias: Area/Campus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Central North: Central North], [Central South: Central South], [West Campus: West Campus], ... 2 more ...)
• site_app_subarea (type: esriFieldTypeString, alias: Court/Quad/etc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_util_wire (type: esriFieldTypeString, alias: Utilities Wire, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: No Obstacle], [OVERHEAD: Directly Overhead], [NEARBY: Site Overhead])
• site_util_other (type: esriFieldTypeString, alias: Utilities Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_type (type: esriFieldTypeString, alias: Site Features, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Dead Tree: Dead Tree], [Forest Plot: Forest Plot], [Lawn Strip: Lawn Strip], ... 6 more ...)
• tree_tag_no (type: esriFieldTypeInteger, alias: Tag Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tree_id_common (type: esriFieldTypeString, alias: Common Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tree_id_scientific (type: esriFieldTypeString, alias: Scientific, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tree_dbh (type: esriFieldTypeSmallInteger, alias: DBH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tree_condition (type: esriFieldTypeSmallInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [90: Excellent], [70: Good], [50: Fair], ... 3 more ...)
• tree_obs_brokentop (type: esriFieldTypeString, alias: Has Broken Top, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_buckling (type: esriFieldTypeString, alias: Has Surface Buckling, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_cabled (type: esriFieldTypeString, alias: Has Cable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_canker (type: esriFieldTypeString, alias: Has Canker, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_cavitydecay (type: esriFieldTypeString, alias: Has Cavity/Decay, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_codomstems (type: esriFieldTypeString, alias: Has Codominant Stems, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_crack (type: esriFieldTypeString, alias: Has Crack, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_deadwood (type: esriFieldTypeString, alias: Has Deadwood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_disease (type: esriFieldTypeString, alias: Has Disease, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_decline (type: esriFieldTypeString, alias: Has Decline, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_encroach (type: esriFieldTypeString, alias: Has Blocking Limbs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_epicormics (type: esriFieldTypeString, alias: Has Excessive Epicormics, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_leaning (type: esriFieldTypeString, alias: Has Lean, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_poorattach (type: esriFieldTypeString, alias: Has Poor Attachment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_pos_high (type: esriFieldTypeString, alias: Has Exposed Root/High Placement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_pos_low (type: esriFieldTypeString, alias: Has Sunken Planting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_removed (type: esriFieldTypeString, alias: Has Been Removed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_stump (type: esriFieldTypeString, alias: Has Stump, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Y], [No: N])
• tree_obs_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_org_owner (type: esriFieldTypeString, alias: Responsible Org, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_org_maintenance (type: esriFieldTypeString, alias: Maintaining Org, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_datalink (type: esriFieldTypeString, alias: Link to More Data, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_assessor (type: esriFieldTypeString, alias: Last Assessor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_priority_dedication (type: esriFieldTypeString, alias: Priority Dedication, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Memorial: Personal/Class/Historical Tree], [Milestone: YHR Milestone Tree], [Other: Other])
• prop_priority_specimen (type: esriFieldTypeString, alias: Priority Specimen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_priority_raretaxonomy (type: esriFieldTypeString, alias: Priority Rare, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_priority_noteworthy (type: esriFieldTypeString, alias: Priority Noteworthy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prop_priority_notes (type: esriFieldTypeString, alias: Priority Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_activity (type: esriFieldTypeString, alias: Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cable: Cable], [Grind Stump: Grind Stump], [Inventory: Inventory], ... 5 more ...)
• task_activity_start (type: esriFieldTypeDate, alias: Activity Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• task_activity_interval (type: esriFieldTypeString, alias: Activity Schedule, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Annual: Annual], [Mitigation: Mitigation], ... 1 more ...)
• task_activity_url (type: esriFieldTypeString, alias: Activity URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_activity_notes (type: esriFieldTypeString, alias: Activity Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_regimen (type: esriFieldTypeString, alias: Regimen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [IPM: IPM], [IPM L2: IPM L2], [IPM L3: IPM L3], ... 1 more ...)
• task_regimen_start (type: esriFieldTypeDate, alias: Regimen Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• task_regimen_interval (type: esriFieldTypeString, alias: Regimen Schedule, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Annual: Annual], [Mitigation: Mitigation], ... 1 more ...)
• task_regimen_url (type: esriFieldTypeString, alias: Regimen URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_regimen_notes (type: esriFieldTypeString, alias: Regimen Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_monitor (type: esriFieldTypeString, alias: Monitor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_monitor_start (type: esriFieldTypeDate, alias: Monitor Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• task_monitor_interval (type: esriFieldTypeString, alias: Monitor Schedule, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [i1y: 1y Interval], [i2y: 2y Interval], ... 8 more ...)
• task_monitor_url (type: esriFieldTypeString, alias: Monitor URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_monitor_notes (type: esriFieldTypeString, alias: Monitor Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fkey_tree (type: esriFieldTypeGUID, alias: Parent Tree Record, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Templates:

Name: Versions
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• site_addr_state: CT
• site_addr_county: New Haven

Relationships:
• Trees (1) -- Related To: Trees (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/9/2021 2:56:55 PM

Schema Last Edit Date: 11/15/2024 5:51:22 PM

Data Last Edit Date: 11/15/2024 5:51:22 PM

Tables:

tasks (2)


Name: tasks

Display Field: task_family

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field: task_family

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• fkey_tree (type: esriFieldTypeGUID, alias: fkey_tree, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• task_family (type: esriFieldTypeSmallInteger, alias: task_family, SQL Type: sqlTypeOther, nullable: true, editable: true)
• task_type (type: esriFieldTypeString, alias: task_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_subject (type: esriFieldTypeString, alias: task_subject, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_description (type: esriFieldTypeString, alias: task_description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_status (type: esriFieldTypeString, alias: task_status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_ticket (type: esriFieldTypeString, alias: task_ticket, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_datalink (type: esriFieldTypeString, alias: task_datalink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_url (type: esriFieldTypeString, alias: task_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• task_notes (type: esriFieldTypeString, alias: task_notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Types:

ID: 10
Name: Regimen
Domains:

• Field Name: task_type
  Coded Values:[Apply Treatment: Apply Treatment], [Other: Other]
  
Templates:

Name: Regimen
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• task_family: 10

---

ID: 20
Name: Monitor
Domains:

• Field Name: task_type
  Coded Values:[Cable: Cable], [Traffic: Traffic], [Health: Health], More
  
Templates:

Name: Monitor
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• task_family: 20

---

ID: 30
Name: Activity
Domains:

• Field Name: task_type
  Coded Values:[Cable: Cable], [Grind Stump: Grind Stump], [Inventory: Inventory], More
  
Templates:

Name: Activity
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• task_family: 30

---

ID: 100
Name: Other
Domains:

Templates:

Name: Other
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• task_family: 100

---


Relationships:
• Trees (0) -- Related To: Trees (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/9/2021 2:56:55 PM

Schema Last Edit Date: 11/15/2024 5:51:22 PM

Data Last Edit Date: 11/15/2024 5:51:22 PM