View In:   ArcGIS Online Map Viewer

Name: SDE.Trees

Display Field: COMMONNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: These data represent tree inventory data collected between 01/31/2023 and 3/13/2023 in Nashville, TN

Copyright Text: Created by PlanIT Geo, INC. Arvada, Colorado. For use by Vanderbilt University

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: 1728058.40467437
YMin: 626477.9777202529
XMax: 1734397.92857667
YMax: 663772.9519326461
Spatial Reference: 102736  (2274)

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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ADDRESS )
• ARCHIVED ( type: esriFieldTypeString, alias: ARCHIVED, editable: true, nullable: true, length: 80, defaultValue: null, modelName: ARCHIVED )
• ASSESSEDTR ( type: esriFieldTypeString, alias: ASSESSEDTR, editable: true, nullable: true, length: 80, defaultValue: null, modelName: ASSESSEDTR )
• CLEARANCEC ( type: esriFieldTypeString, alias: CLEARANCEC, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CLEARANCEC )
• CODE ( type: esriFieldTypeString, alias: CODE, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CODE )
• COMMONNAME ( type: esriFieldTypeString, alias: COMMONNAME, editable: true, nullable: true, length: 80, defaultValue: null, modelName: COMMONNAME )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CONDITION , Coded Values: [New: Newly Planted Tree] , [Excellent: Excellent] , [Good: Good] , ...4 more... )
• CONSEQUENC ( type: esriFieldTypeString, alias: CONSEQUENC, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CONSEQUENC )
• CULTIVAR ( type: esriFieldTypeString, alias: CULTIVAR, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CULTIVAR )
• DATEADDED ( type: esriFieldTypeString, alias: DATEADDED, editable: true, nullable: true, length: 80, defaultValue: null, modelName: DATEADDED )
• DBH ( type: esriFieldTypeInteger, alias: DBH, editable: true, nullable: true, defaultValue: null, modelName: DBH )
• GENUS ( type: esriFieldTypeString, alias: GENUS, editable: true, nullable: true, length: 80, defaultValue: null, modelName: GENUS )
• GROWINGSPA ( type: esriFieldTypeString, alias: GROWINGSPA, editable: true, nullable: true, length: 80, defaultValue: null, modelName: GROWINGSPA )
• HASECOBENE ( type: esriFieldTypeString, alias: HASECOBENE, editable: true, nullable: true, length: 80, defaultValue: null, modelName: HASECOBENE )
• INSPECTION ( type: esriFieldTypeString, alias: INSPECTION, editable: true, nullable: true, length: 80, defaultValue: null, modelName: INSPECTION )
• LANDUSE ( type: esriFieldTypeString, alias: LANDUSE, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LANDUSE )
• LASTINSPEC ( type: esriFieldTypeString, alias: LASTINSPEC, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LASTINSPEC )
• LASTMODIFI ( type: esriFieldTypeString, alias: LASTMODIFI, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LASTMODIFI )
• LASTMODI_1 ( type: esriFieldTypeString, alias: LASTMODI_1, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LASTMODI_1 )
• LIKELIHOOD ( type: esriFieldTypeString, alias: LIKELIHOOD, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LIKELIHOOD )
• LIKELIHO_1 ( type: esriFieldTypeString, alias: LIKELIHO_1, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LIKELIHO_1 )
• LIKELIHO_2 ( type: esriFieldTypeString, alias: LIKELIHO_2, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LIKELIHO_2 )
• MAINTENANC ( type: esriFieldTypeString, alias: MAINTENANC, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MAINTENANC )
• NEXTINSPEC ( type: esriFieldTypeString, alias: NEXTINSPEC, editable: true, nullable: true, length: 80, defaultValue: null, modelName: NEXTINSPEC )
• NUMBEROFST ( type: esriFieldTypeDouble, alias: NUMBEROFST, editable: true, nullable: true, defaultValue: null, modelName: NUMBEROFST )
• OBSERVATIO ( type: esriFieldTypeString, alias: OBSERVATIO, editable: true, nullable: true, length: 80, defaultValue: null, modelName: OBSERVATIO )
• OVERHEADUT ( type: esriFieldTypeString, alias: OVERHEADUT, editable: true, nullable: true, length: 80, defaultValue: null, modelName: OVERHEADUT )
• PHOTOS ( type: esriFieldTypeString, alias: PHOTOS, editable: true, nullable: true, length: 138, defaultValue: null, modelName: PHOTOS )
• RISKRATING ( type: esriFieldTypeString, alias: RISKRATING, editable: true, nullable: true, length: 80, defaultValue: null, modelName: RISKRATING )
• SCIENTIFIC ( type: esriFieldTypeString, alias: SCIENTIFIC, editable: true, nullable: true, length: 80, defaultValue: null, modelName: SCIENTIFIC )
• SITEWIDTH ( type: esriFieldTypeString, alias: SITEWIDTH, editable: true, nullable: true, length: 80, defaultValue: null, modelName: SITEWIDTH )
• TREECOMMEN ( type: esriFieldTypeString, alias: TREECOMMEN, editable: true, nullable: true, length: 80, defaultValue: null, modelName: TREECOMMEN )
• TREEWORK ( type: esriFieldTypeString, alias: TREEWORK, editable: true, nullable: true, length: 80, defaultValue: null, modelName: TREEWORK )
• USER_ ( type: esriFieldTypeString, alias: USER_, editable: true, nullable: true, length: 80, defaultValue: null, modelName: USER_ )
• CREATED_US ( type: esriFieldTypeString, alias: CREATED_US, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CREATED_US )
• CREATED_DA ( type: esriFieldTypeDate, alias: CREATED_DA, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DA )
• LAST_EDITE ( type: esriFieldTypeString, alias: LAST_EDITE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LAST_EDITE )
• LAST_EDI_1 ( type: esriFieldTypeDate, alias: LAST_EDI_1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDI_1 )
• GLOBALID ( type: esriFieldTypeString, alias: GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GLOBALID )
• ASSETTAG ( type: esriFieldTypeDouble, alias: ASSETTAG, editable: true, nullable: true, defaultValue: null, modelName: ASSETTAG )
• LAT ( type: esriFieldTypeDouble, alias: LAT, editable: true, nullable: true, defaultValue: null, modelName: LAT )
• LONG_ ( type: esriFieldTypeDouble, alias: LONG_, editable: true, nullable: true, defaultValue: null, modelName: LONG_ )
• IMAGE ( type: esriFieldTypeString, alias: IMAGE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: IMAGE )
• DESIGNATION ( type: esriFieldTypeString, alias: DESIGNATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESIGNATION )
• DESIGNATIONNOTES ( type: esriFieldTypeString, alias: DESIGNATIONNOTES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: DESIGNATIONNOTES )
• PLANTEDDATE ( type: esriFieldTypeDate, alias: PLANTEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANTEDDATE )
• GLOBALID_1 ( type: esriFieldTypeGlobalID, alias: GLOBALID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID_1 )
• EXISTINGLABEL ( type: esriFieldTypeString, alias: EXISTINGLABEL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EXISTINGLABEL , Coded Values: [YES: YES] , [NO: NO] )
• NEWLABEL ( type: esriFieldTypeString, alias: NEWLABEL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEWLABEL , Coded Values: [YES: YES] , [NO: NO] )
• SPECIALITYLABEL ( type: esriFieldTypeString, alias: SPECIALITYLABEL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SPECIALITYLABEL , Coded Values: [YES: YES] , [NO: NO] )
• LABELNOTES ( type: esriFieldTypeString, alias: LABELNOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LABELNOTES )
• UPDATEDLABEL ( type: esriFieldTypeString, alias: UPDATEDLABEL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UPDATEDLABEL , Coded Values: [YES: YES] , [NO: NO] )
• REMOVALDATE ( type: esriFieldTypeDate, alias: Removal Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REMOVALDATE )
• REMOVALREASON ( type: esriFieldTypeString, alias: Removal Reason, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REMOVALREASON , Coded Values: [Environmental: Environmental] , [Construction: Construction] , [H&S: Health and Safety] )

Templates:

• Name: SDE.Trees
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata