Name: Related Prescribed Fire Details Table

Display Field: FIRE_NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: e8720e331c49458dbadcee5051051f30

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• FIRE_AREA_GLOBALID ( type: esriFieldTypeGUID, alias: FIRE AREA GLOBAL ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: FIRE_AREA_GLOBALID )
• FIRE_NAME ( type: esriFieldTypeString, alias: FIRE NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIRE_NAME )
• BURN_PLAN_NUM ( type: esriFieldTypeString, alias: BURN PLAN NUMBER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BURN_PLAN_NUM )
• PLAN_APPROVE_DT ( type: esriFieldTypeDate, alias: PLAN APPROVED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAN_APPROVE_DT )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 1, defaultValue: P, modelName: STATUS , Coded Values: [C: Completed] , [P: Planned] )
• DATE_BURNED ( type: esriFieldTypeDate, alias: DATE BURNED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_BURNED )
• COMPLEXITY ( type: esriFieldTypeString, alias: COMPLEXITY, editable: true, nullable: true, length: 1, defaultValue: null, modelName: COMPLEXITY , Coded Values: [H: High] , [l: Low] , [M: Moderate] )
• PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, editable: true, nullable: true, length: 1, defaultValue: N, modelName: PRIORITY , Coded Values: [Y: Yes] , [N: No] )
• PROPERTY_NAME ( type: esriFieldTypeString, alias: PROPERTY NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROPERTY_NAME )
• PROPERTY_OWNER ( type: esriFieldTypeString, alias: PROPERTY OWNER, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PROPERTY_OWNER , Coded Values: [DNR: DCNR] , [HAC: Cooperator] , [IA: Inter- Agency] , ...1 more... )
• BURN_OBJ_NOTES ( type: esriFieldTypeString, alias: BURN OBJECTIVE NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BURN_OBJ_NOTES )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AREA_REVIEW ( type: esriFieldTypeString, alias: AREA REVIEW, editable: true, nullable: true, length: 1, defaultValue: N, modelName: AREA_REVIEW , Coded Values: [Y: Yes] , [N: No] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ACTIVITY_CODE ( type: esriFieldTypeSmallInteger, alias: ACTIVITY_CODE, editable: true, nullable: true, defaultValue: null, modelName: ACTIVITY_CODE , Coded Values: [114: 114 - Prescribed Burn Field Training] , [514: 514 - Prescribed Burning (Forestland)] , [516: 516 - Prescribed Burning, Unit Preparation] )
• TREATMENT ( type: esriFieldTypeString, alias: TREATMENT, editable: true, nullable: true, length: 3, defaultValue: -1, modelName: TREATMENT , Coded Values: [IPC: Interfering Plant Control (IPC)] , [LSR: Low-Shade Removal (LSR)] , [FM: Fuel Management (FM)] , ...8 more... )
• METHOD ( type: esriFieldTypeString, alias: METHOD, editable: true, nullable: true, length: 2, defaultValue: -1, modelName: METHOD , Coded Values: [HI: Hand Ignition] , [AH: Aerial Ignition (Helicopter)] , [AD: Aerial Ignition (Drone)] , ...2 more... )
• FUNDING ( type: esriFieldTypeString, alias: FUNDING, editable: true, nullable: true, length: 3, defaultValue: -1, modelName: FUNDING , Coded Values: [PR: Pittman-Roberts] , [GF: Game Fund] , [W: Land and Water Fund] , ...7 more... )
• sgl ( type: esriFieldTypeInteger, alias: SGL, editable: true, nullable: true, defaultValue: null, modelName: sgl )
• pgc_region ( type: esriFieldTypeSmallInteger, alias: PGC Region, editable: true, nullable: true, defaultValue: null, modelName: pgc_region , Coded Values: [1: Northwest Region] , [2: Southwest Region] , [3: Northcentral Region] , ...3 more... )
• burn_unit_name ( type: esriFieldTypeString, alias: Burn Unit Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: burn_unit_name )
• coverage_type ( type: esriFieldTypeString, alias: Coverage Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: coverage_type , Coded Values: [Full: Full] , [Spot: Spot] , [Random: Random] , ...4 more... )
• coverage_extent ( type: esriFieldTypeString, alias: Coverage Extent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: coverage_extent , Coded Values: [Minimal: Minimal (<20%)] , [Partial: Partial (>20%)] , [Around Half: Around Half (>40%)] , ...3 more... )
• habitat_type ( type: esriFieldTypeString, alias: Habitat Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: habitat_type , Coded Values: [Woody: Woody] , [Grass: Grass] , [Woody and Grass: Woody and Grass] )

Templates:

• Name: Related Prescribed Fire Details Table
  Description:
  Prototype:
  coverage_extent: null
  FIRE_AREA_GLOBALID: null
  FIRE_NAME: null
  BURN_PLAN_NUM: null
  PLAN_APPROVE_DT: null
  STATUS: P
  DATE_BURNED: null
  COMPLEXITY: null
  PRIORITY: N
  PROPERTY_NAME: null
  PROPERTY_OWNER: null
  BURN_OBJ_NOTES: null
  NOTES: null
  coverage_type: null
  burn_unit_name: null
  pgc_region: null
  sgl: null
  habitat_type: null
  AREA_REVIEW: N
  ACTIVITY_CODE: null
  TREATMENT: -1
  METHOD: -1
  FUNDING: -1
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GIS.GIS.Treatment_Area (0) -- Related To: Prescribed Fire Area (Priority Burn) (0)
• GIS.GIS.Treatment_Area (1) -- Related To: Prescribed Fire Areas - Completed (1)

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: 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: true

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata