View In:
ArcGIS Online Map Viewer
Name: DEPSDE.DBO.Tree_Montgomery
Display Field: Project_Status
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 3000000
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: -120561100
YMin: -95444400
XMax: 1369256.4619620591
YMax: 678460.2627532333
Spatial Reference: 102685
(2248)
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
)
-
Project_Status
(
type: esriFieldTypeString, alias: Project Status, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Project_Status
,
Coded Values:
[1: Planting delayed until future]
,
[2: Fast track, to be reviewed]
,
[3: In planning]
, ...16 more...
)
-
Property_ID
(
type: esriFieldTypeString, alias: Property ID, editable: true, nullable: false, length: 8, defaultValue: null, modelName: Property_ID
)
-
Property_Contact
(
type: esriFieldTypeString, alias: Property Contact, editable: true, nullable: false, length: 60, defaultValue: null, modelName: Contact
)
-
Tree_Species
(
type: esriFieldTypeString, alias: Tree Species, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Species
,
Coded Values:
[2: baldcypress]
,
[4: beech, American]
,
[5: birch, river (single stem)]
, ...73 more...
)
-
Water_Source
(
type: esriFieldTypeString, alias: Water Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Water_Source
,
Coded Values:
[91: None]
,
[92: Spigot only]
,
[93: Spigot and hose]
)
-
Guard_Ordered
(
type: esriFieldTypeString, alias: Guard Ordered?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Guard_Ordered
,
Coded Values:
[67: 4' HDPE]
,
[68: 4' wire cage]
,
[69: 8" plastic]
, ...1 more...
)
-
Stakes_Ordered
(
type: esriFieldTypeString, alias: Stakes Ordered?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Stakes_Ordered
,
Coded Values:
[65: None]
,
[66: Staking]
)
-
Warranty_Ordered
(
type: esriFieldTypeString, alias: Warranty Ordered?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Warrenty_Ordered
,
Coded Values:
[71: 2-Year Aftercare]
,
[72: 1-Year Aftercare]
,
[73: None]
)
-
Aftercare_Ordered
(
type: esriFieldTypeString, alias: Aftercare Ordered?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Aftercare_Ordered
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Rainscapes_Tree
(
type: esriFieldTypeString, alias: Rainscapes Tree?, editable: true, nullable: true, length: 50, defaultValue: No, modelName: Rainscapes_Tree
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Target_Date
(
type: esriFieldTypeString, alias: Target_Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Target_Date
)
-
Date_Easement_Signed
(
type: esriFieldTypeDate, alias: Date Easement Signed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Easement_Signed
)
-
Order_Date
(
type: esriFieldTypeDate, alias: Tree Order Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Order_Date
)
-
Planting_Date
(
type: esriFieldTypeDate, alias: Planting Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Planting_Date
)
-
First_Inspection_Date
(
type: esriFieldTypeDate, alias: 1st Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: First_Inspection_Date
)
-
First_Inspection_Condition
(
type: esriFieldTypeString, alias: 1st Inspection Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: First_Inspection_Condition
,
Coded Values:
[Excellent: Excellent]
,
[Good: Good]
,
[Fair: Fair]
, ...3 more...
)
-
First_Inspection_Caliper
(
type: esriFieldTypeDouble, alias: 1st Inspection Caliper, editable: true, nullable: true, defaultValue: 2, modelName: First_Inspection_Caliper
)
-
First_Inspection_Action_Require
(
type: esriFieldTypeString, alias: 1st Inspection Action Required?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: First_Inspection_Action_Required
,
Coded Values:
[Aftercare Package: Aftercare Package]
,
[Water: Water]
,
[Adjust mulch: Adjust mulch]
, ...7 more...
)
-
First_Inspection_Acceptance
(
type: esriFieldTypeString, alias: 1st Inspection Accepted?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: First_Inspection_Acceptance
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
First_Inspector
(
type: esriFieldTypeString, alias: 1st Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: First_Inspector
,
Coded Values:
[Laura Miller: Laura Miller]
,
[Evan Keto: Evan Keto]
,
[Donna Evans: Donna Evans]
, ...4 more...
)
-
Second_Inspection_Date
(
type: esriFieldTypeDate, alias: 2nd Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Second_Inspection_Date
)
-
Second_Inspection_Condition
(
type: esriFieldTypeString, alias: 2nd Inspection Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Second_Inspection_Condition
,
Coded Values:
[Excellent: Excellent]
,
[Good: Good]
,
[Fair: Fair]
, ...3 more...
)
-
Second_Inspection_Caliper
(
type: esriFieldTypeString, alias: 2nd Inspection Caliper, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Second_Inspection_Caliper
)
-
Second_Inspection_Action_Requir
(
type: esriFieldTypeString, alias: 2nd Inspection Action Required?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Second_Inspection_Action_Required
,
Coded Values:
[Aftercare Package: Aftercare Package]
,
[Water: Water]
,
[Adjust mulch: Adjust mulch]
, ...7 more...
)
-
Second_Inspection_Acceptance
(
type: esriFieldTypeString, alias: 2nd Inspection Accepted?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Second_Inpection_Acceptance
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Second_Inspector
(
type: esriFieldTypeString, alias: 2nd Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Second_Inspector
,
Coded Values:
[Laura Miller: Laura Miller]
,
[Evan Keto: Evan Keto]
,
[Donna Evans: Donna Evans]
, ...4 more...
)
-
Third_Inspection_Date
(
type: esriFieldTypeDate, alias: 3rd Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Third_Inspection_Date
)
-
Third_Inspection_Condition
(
type: esriFieldTypeString, alias: 3rd Inspection Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Third_Inspection_Condition
,
Coded Values:
[Excellent: Excellent]
,
[Good: Good]
,
[Fair: Fair]
, ...3 more...
)
-
Third_Inspection_Caliper
(
type: esriFieldTypeString, alias: 3rd Inspection Caliper, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Third_Inspection_Caliper
)
-
Third_Inspection_Action_Require
(
type: esriFieldTypeString, alias: 3rd Inspection Action Required?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Third_Inspection_Action_Required
,
Coded Values:
[Aftercare Package: Aftercare Package]
,
[Water: Water]
,
[Adjust mulch: Adjust mulch]
, ...7 more...
)
-
Third_Inspection_Acceptance
(
type: esriFieldTypeString, alias: 3rd Inspection Acceptance, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Third_Inspection_Acceptance
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Third_Inspector
(
type: esriFieldTypeString, alias: 3rd Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Third_Inspector
,
Coded Values:
[Laura Miller: Laura Miller]
,
[Evan Keto: Evan Keto]
,
[Donna Evans: Donna Evans]
, ...4 more...
)
-
Special_Case
(
type: esriFieldTypeString, alias: Special Case?, editable: true, nullable: true, length: 50, defaultValue: No, modelName: Notes
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments
)
-
FastTrackTreeSpecies
(
type: esriFieldTypeString, alias: FastTrackTreeSpecies, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FastTrackTreeSpecies
,
Coded Values:
[97: TBD]
,
[6: coffeetree, Kentucky]
,
[11: ginkgo (fruitless male)]
, ...40 more...
)
-
Visit_Complete
(
type: esriFieldTypeString, alias: Visit_Complete, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Visit_Complete
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Application_Map_ID
(
type: esriFieldTypeInteger, alias: Application_Map_ID, editable: true, nullable: true, defaultValue: null, modelName: Application_Map_ID
)
-
Dogs
(
type: esriFieldTypeString, alias: Dogs, editable: true, nullable: true, length: 5, defaultValue: No, modelName: Dogs
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Gates
(
type: esriFieldTypeString, alias: Gates, editable: true, nullable: true, length: 5, defaultValue: No, modelName: Gates
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Advance_Notice
(
type: esriFieldTypeString, alias: Advance_Notice, editable: true, nullable: true, length: 50, defaultValue: No, modelName: Advance_Notice
,
Coded Values:
[Yes: Yes]
,
[No: No]
)
-
Fund_Source
(
type: esriFieldTypeString, alias: Fund_Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Fund_Source
,
Coded Values:
[1: CBT-FY23]
,
[2: Earmark-FY23]
,
[3: WQPF]
, ...7 more...
)
Templates:
-
Name: DEPSDE.DBO.Tree_Montgomery
Description:
Prototype:
Advance_Notice: No
Project_Status:
Property_ID:
Property_Contact:
Tree_Species: null
Water_Source: null
Guard_Ordered: null
Stakes_Ordered: null
Warranty_Ordered: null
Aftercare_Ordered: null
Rainscapes_Tree: No
Target_Date: null
Date_Easement_Signed: null
Order_Date: null
Planting_Date: null
First_Inspection_Date: null
First_Inspection_Condition: null
First_Inspection_Caliper: 2
First_Inspection_Action_Require: null
First_Inspection_Acceptance: null
First_Inspector: null
Second_Inspection_Date: null
Second_Inspection_Condition: null
Second_Inspection_Caliper: null
Second_Inspection_Action_Requir: null
Second_Inspection_Acceptance: null
Second_Inspector: null
Third_Inspection_Date: null
Third_Inspection_Condition: null
Third_Inspection_Caliper: null
Third_Inspection_Action_Require: null
Third_Inspection_Acceptance: null
Third_Inspector: null
Special_Case: No
Comments: null
FastTrackTreeSpecies: null
Visit_Complete: null
Application_Map_ID: null
Dogs: No
Gates: No
Fund_Source: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: false
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 Analytic
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata