Layers:

Layer: Trees (0)

Name: Trees

Display Field: TreeID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 899b6c2f3764419db4d8f6c8bb1f32cc

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -9614850.748898674
YMin: 5342012.543938876
XMax: -9595127.77610541
YMax: 5356302.926950393
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TreeID ( type: esriFieldTypeString, alias: Tree identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• Address ( type: esriFieldTypeString, alias: Nearest Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: fulladdr )
• Park ( type: esriFieldTypeString, alias: Park or Location Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: district )
• TreeLocDesc ( type: esriFieldTypeString, alias: Tree Location Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: municipality )
• Tree_CommonName ( type: esriFieldTypeInteger, alias: Common name, editable: true, nullable: true, defaultValue: null, modelName: commonname , Coded Values: [32: Apple - Crabapple] , [23: Ash - American Mountain] , [24: Ash - Black] , ...66 more... )
• Municipality ( type: esriFieldTypeString, alias: Genus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: genus , Coded Values: [02: MONTAGUE TOWNSHIP] , [04: BLUE LAKE TOWNSHIP] , [06: FRUITLAND TOWNSHIP] , ...25 more... )
• DBH ( type: esriFieldTypeDouble, alias: Diameter at Breast Height (in), editable: true, nullable: true, defaultValue: null, modelName: diameter )
• Height ( type: esriFieldTypeDouble, alias: Height (ft), editable: true, nullable: true, defaultValue: null, modelName: height )
• DatePlanted ( type: esriFieldTypeDate, alias: Date Planted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• Warranty ( type: esriFieldTypeSmallInteger, alias: Warranty on Tree, editable: true, nullable: true, defaultValue: null, modelName: treewires , Coded Values: [0: No] , [1: Yes] )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warrarnty Expiration, editable: true, nullable: true, length: 8, defaultValue: null, modelName: treeguard )
• HerritageTree ( type: esriFieldTypeSmallInteger, alias: Heritage tree, editable: true, nullable: true, defaultValue: 0, modelName: heritage , Coded Values: [0: No] , [1: Yes] )
• OwnedBy ( type: esriFieldTypeString, alias: Owned by, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ownedby )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained by, editable: true, nullable: true, length: 75, defaultValue: null, modelName: maintby )
• TreeNotes ( type: esriFieldTypeString, alias: TreeNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TreeNotes )
• TreeTagNum ( type: esriFieldTypeString, alias: Tree Tag Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: TreeTagNum )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_POSITIONSOURCETYPE , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ESRIGNSS_RECEIVER )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LATITUDE )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LONGITUDE )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_ALTITUDE )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_RMS )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_V_RMS )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ESRIGNSS_FIXDATETIME )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_CORRECTIONAGE )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_STATIONID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_NUMSATS , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_DIRECTION )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_SPEED )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°), editable: true, nullable: true, defaultValue: null, modelName: ESRISNSR_AZIMUTH )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_H_RMS )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_V_RMS )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_POSITIONS )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_STDDEV )
Templates:
• Name: Trees
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Trees_to_Inspections (1) -- Related To: Tree Inspections (2)
• Trees_to_Maintenance (2) -- Related To: Tree Maintenance (4)

Tables:

Table: Tree Inspections (2)

Name: Tree Inspections

Display Field: InspectionDate

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 899b6c2f3764419db4d8f6c8bb1f32cc

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• DBH ( type: esriFieldTypeDouble, alias: Diameter at Breast Height (in), editable: true, nullable: true, defaultValue: null, modelName: DBH )
• Height ( type: esriFieldTypeDouble, alias: Height (ft), editable: true, nullable: true, defaultValue: null, modelName: Height )
• Pests ( type: esriFieldTypeSmallInteger, alias: Pests Present, editable: true, nullable: true, defaultValue: null, modelName: Pests , Coded Values: [0: No] , [1: Yes] )
• Disease ( type: esriFieldTypeSmallInteger, alias: Disease Present, editable: true, nullable: true, defaultValue: null, modelName: Disease , Coded Values: [0: No] , [1: Yes] )
• MaintNeeded ( type: esriFieldTypeSmallInteger, alias: Maintenance Needed, editable: true, nullable: true, defaultValue: null, modelName: MaintNeeded , Coded Values: [0: No] , [1: Yes] )
• MaintType ( type: esriFieldTypeString, alias: Maintenance Type Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintType , Coded Values: [DR: Debris Removal] , [HR: Hazard Removal] , [PDT: Pest & Disease Treatment] , ...8 more... )
• MaintNotes ( type: esriFieldTypeString, alias: Notes for Maintenance Needed, editable: true, nullable: true, length: 150, defaultValue: null, modelName: MaintNotes )
• InspNotes ( type: esriFieldTypeString, alias: Inspection Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: InspNotes )
• InspBy ( type: esriFieldTypeString, alias: Inspection By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspBy )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• TreeGlobalID ( type: esriFieldTypeGUID, alias: TreeGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TreeGlobalID )
• InspectionStatus ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionStatus , Coded Values: [SC: Scheduled] , [IP: In Progress] , [COM: Complete] , ...2 more... )
• TreeCondition ( type: esriFieldTypeInteger, alias: Tree Condition, editable: true, nullable: true, defaultValue: null, modelName: TreeCondition , Coded Values: [1: Excellent / Specimin Tree] , [2: Good] , [3: Fair] , ...4 more... )
Templates:
• Name: Tree Inspections
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• TreeInsp_to_Maint (3) -- Related To: Tree Maintenance (4)
• Inspections_to_Trees (1) -- Related To: Trees (0)

Table: Tree Maintenance (4)

Name: Tree Maintenance

Display Field: TreeMaintID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 899b6c2f3764419db4d8f6c8bb1f32cc

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TreeMaintID ( type: esriFieldTypeString, alias: TreeMaintID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TreeMaintID )
• MaintStDate ( type: esriFieldTypeDate, alias: MaintStDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintStDate )
• MaintEndDate ( type: esriFieldTypeDate, alias: MaintEndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintEndDate )
• MaintType ( type: esriFieldTypeString, alias: MaintType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintType , Coded Values: [DR: Debris Removal] , [HR: Hazard Removal] , [PDT: Pest & Disease Treatment] , ...8 more... )
• MaintStatus ( type: esriFieldTypeString, alias: MaintStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintStatus , Coded Values: [SC: Scheduled] , [IP: In Progress] , [COM: Complete] , ...2 more... )
• MaintNotes ( type: esriFieldTypeString, alias: MaintNotes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintNotes )
• TreeGlobalID ( type: esriFieldTypeGUID, alias: TreeGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TreeGlobalID )
• InspGlobalID ( type: esriFieldTypeGUID, alias: InspGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: InspGlobalID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Tree Maintenance
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• TreeMaint_to_Trees (2) -- Related To: Trees (0)
• TreeMaint_to_Insp (3) -- Related To: Tree Inspections (2)