Name: Maintenance

Display Field: staff_name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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 )
• organization ( type: esriFieldTypeString, alias: Organization, editable: true, nullable: true, length: 50, defaultValue: null, modelName: organization )
• staff_name ( type: esriFieldTypeString, alias: Staff Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: staff_name )
• maintenance_date ( type: esriFieldTypeDate, alias: Maintenance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: maintenance_date )
• weather_conditions ( type: esriFieldTypeString, alias: Weather Conditions, editable: true, nullable: true, length: 75, defaultValue: null, modelName: weather_conditions , Coded Values: [cloudy: cloudy] , [overcast with chance of rain: overcast with chance of rain] , [raining: raining] , ...1 more... )
• activity_performed ( type: esriFieldTypeString, alias: Actiivty Performed, editable: true, nullable: true, length: 100, defaultValue: null, modelName: activity_performed )
• material_removed ( type: esriFieldTypeString, alias: Material Removed, editable: true, nullable: true, length: 100, defaultValue: null, modelName: material_removed )
• material_added ( type: esriFieldTypeString, alias: Material Added, editable: true, nullable: true, length: 50, defaultValue: null, modelName: material_added )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: inspector_Notes )
• 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 )
• rel_guid_bmp_point ( type: esriFieldTypeGUID, alias: rel_guid_bmp_point, editable: true, nullable: true, length: 38, defaultValue: null, modelName: rel_guid_bmp_point )
• maint_complete ( type: esriFieldTypeString, alias: Maintenance Complete, editable: true, nullable: true, length: 25, defaultValue: null, modelName: maint_complete , Coded Values: [Yes: Yes] , [No: No] )
• maint_activity ( type: esriFieldTypeString, alias: maint_activity, editable: true, nullable: true, length: 100, defaultValue: null, modelName: maint_activity )
• quantity_removed ( type: esriFieldTypeDouble, alias: Quantity Removed, editable: true, nullable: true, defaultValue: null, modelName: quantity_removed )
• unit_measure ( type: esriFieldTypeString, alias: unit, editable: true, nullable: true, length: 25, defaultValue: null, modelName: unit_measure )
• bmp_app_type ( type: esriFieldTypeSmallInteger, alias: bmp_app_type, editable: true, nullable: true, defaultValue: null, modelName: bmp_app_type , Coded Values: [1: Basin/Swale-Media w/ underdrain (.25 Acre)] , [2: Basin/Swale Non-Vegetated (.25 Acre)] , [3: Basin/Swale Vegetated (.25 Acre)] , ...9 more... )
• rel_guid_inspect_record ( type: esriFieldTypeGUID, alias: rel_guid_inspect_record, editable: true, nullable: true, length: 38, defaultValue: null, modelName: rel_guid_inspect_record )
• inspection_notes ( type: esriFieldTypeString, alias: inspection_notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: inspection_notes )
• bmp_notes ( type: esriFieldTypeString, alias: bmp_notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: bmp_notes )
• activity_quantity ( type: esriFieldTypeDouble, alias: activity_quantity, editable: true, nullable: true, defaultValue: null, modelName: activity_quantity )
• work_order_num ( type: esriFieldTypeString, alias: work_order_num, editable: true, nullable: true, length: 50, defaultValue: null, modelName: work_order_num )

Templates:

• Name: Maintenance
  Description:
  Prototype:
  activity_quantity: null
  bmp_notes: null
  organization: null
  staff_name: null
  maintenance_date: null
  weather_conditions: null
  activity_performed: null
  material_removed: null
  material_added: null
  notes: null
  work_order_num: null
  inspection_notes: null
  rel_guid_inspect_record: null
  bmp_app_type: null
  unit_measure: null
  rel_guid_bmp_point: null
  maint_complete: null
  maint_activity: null
  quantity_removed: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• bmp_point (0) -- Related To: BMP Point (0)
• bmp_inspection_history (3) -- Related To: Inspection (4)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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