Name: PlantingAreas_maintenance

Display Field: mainttype

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: true

Sources

Description: AttributeJoin

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:

Fields:

• mainttype (type: esriFieldTypeString, alias: Maintenance type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Debris Removal: Debris Removal], [Hazard Removal: Hazard Removal], [Pest & Disease Treatment: Pest & Disease Treatment], ... 8 more ...)
• startdate (type: esriFieldTypeDate, alias: Start date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• maintdate (type: esriFieldTypeDate, alias: Date finished, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [In Progress: In Progress], [Completed: Completed], [Paused: Paused], ... 1 more ...)
• notes (type: esriFieldTypeString, alias: Maintenance notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• assetglobalid (type: esriFieldTypeGUID, alias: Tree GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• plantingareaglobalid (type: esriFieldTypeGUID, alias: Planting Area GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• assetid (type: esriFieldTypeString, alias: Planting Area identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fulladdr (type: esriFieldTypeString, alias: Nearest address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: District or neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• habitat (type: esriFieldTypeString, alias: Habitat, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Tree Stand: Tree Stand], [Fern: Fern], [Grass: Grass/Sedge], ... 3 more ...)
• plantcount (type: esriFieldTypeInteger, alias: Plant count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Date planted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• waterthroughdate (type: esriFieldTypeDate, alias: Water through date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• notes_1685050912141 (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• retiredate (type: esriFieldTypeDate, alias: Date retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• collectedby (type: esriFieldTypeSmallInteger, alias: Collected by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• publicview (type: esriFieldTypeString, alias: Publicly Visibile, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• stormwater (type: esriFieldTypeDouble, alias: Stormwater intercepted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• energy (type: esriFieldTypeDouble, alias: Energy conserved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pollutants (type: esriFieldTypeDouble, alias: Air pollutants removed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• co2 (type: esriFieldTypeDouble, alias: Carbon dioxide reduced, SQL Type: sqlTypeOther, nullable: true, editable: true)
• propvalue (type: esriFieldTypeDouble, alias: Increased property value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• benefits (type: esriFieldTypeDouble, alias: Total value of benefits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• globalid_1685050912141 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user_1685050912141 (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date_1685050912141 (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user_1685050912141 (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date_1685050912141 (type: esriFieldTypeDate, alias: Last Edited By, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/15/2025 9:46:10 PM

Schema Last Edit Date: 6/14/2023 3:03:39 PM

Data Last Edit Date: 6/14/2023 3:03:39 PM

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