Name: AFFF_Materials

Display Field: material_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 26edef57db884d1193c5afc098bb3824

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

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With Current User: true

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 )
• mat_entry_id ( type: esriFieldTypeDouble, alias: Material Entry Id, editable: true, nullable: true, defaultValue: null, modelName: mat_entry_id )
• manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: manufacturer )
• other___not_listed_manufacturer ( type: esriFieldTypeString, alias: Other / Not Listed Manufacturer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: other___not_listed_manufacturer )
• material_name ( type: esriFieldTypeString, alias: Material Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: material_name )
• other___not_listed_material_name ( type: esriFieldTypeString, alias: Other / Not Listed Material Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: other___not_listed_material_name )
• does_this_material_contain_pfas ( type: esriFieldTypeString, alias: Does this material contain PFAS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: does_this_material_contain_pfas )
• is_this_material_a_rinsate_ ( type: esriFieldTypeString, alias: Is this material a rinsate?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: is_this_material_a_rinsate_ )
• unknown_material ( type: esriFieldTypeString, alias: Unknown Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: unknown_material )
• description_of_unknown_material ( type: esriFieldTypeString, alias: Description of Unknown Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description_of_unknown_material )
• container_type ( type: esriFieldTypeString, alias: Container Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: container_type )
• other_container_type ( type: esriFieldTypeString, alias: Container Type Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: other_container_type )
• container_size__gallons_ ( type: esriFieldTypeDouble, alias: Container Size (Gallons), editable: true, nullable: true, defaultValue: null, modelName: container_size__gallons_ )
• material_status ( type: esriFieldTypeString, alias: Material Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: material_status )
• pallet_number ( type: esriFieldTypeString, alias: Pallet Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pallet_number )
• material_status_last_modified ( type: esriFieldTypeString, alias: Material Status Last Modified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: material_status_last_modified )
• is_overpack_ ( type: esriFieldTypeString, alias: Is Overpack?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: is_overpack_ )
• parent_entry_id ( type: esriFieldTypeString, alias: Parent Entry ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: parent_entry_id )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• parent_globalid ( type: esriFieldTypeGUID, alias: Parent GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_globalid )
• mat_entry_date ( type: esriFieldTypeDate, alias: Material Entry Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: mat_entry_date )
• date_updated ( type: esriFieldTypeDate, alias: Date Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_updated )
• purchase_date ( type: esriFieldTypeDate, alias: Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: purchase_date )
• manufacture_date ( type: esriFieldTypeDate, alias: Manufacture Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: manufacture_date )
• sealed_ready ( type: esriFieldTypeSmallInteger, alias: Sealed Ready to Collect, editable: true, nullable: true, defaultValue: null, modelName: sealed_ready )
• sealed_not_ready ( type: esriFieldTypeSmallInteger, alias: Sealed Not Ready to Collect, editable: true, nullable: true, defaultValue: null, modelName: sealed_not_ready )
• unsealed_ready ( type: esriFieldTypeSmallInteger, alias: Unsealed Ready to Collect, editable: true, nullable: true, defaultValue: null, modelName: unsealed_ready )
• unsealed_not_ready ( type: esriFieldTypeSmallInteger, alias: Unseadled Not Ready to Collect, editable: true, nullable: true, defaultValue: null, modelName: unsealed_not_ready )
• gallons_ready ( type: esriFieldTypeInteger, alias: Gallons Ready to Collect, editable: true, nullable: true, defaultValue: null, modelName: gallons_ready )
• gallons_not_ready ( type: esriFieldTypeInteger, alias: Gallons Not Ready to Collect, editable: true, nullable: true, defaultValue: null, modelName: gallons_not_ready )
• total_gallons ( type: esriFieldTypeInteger, alias: Total Gallons of Material, editable: true, nullable: true, defaultValue: null, modelName: total_gallons )

Templates:

• Name: AFFF_Materials
  Description:
  Prototype:
  gallons_not_ready: null
  mat_entry_id: null
  manufacturer: null
  other___not_listed_manufacturer: null
  material_name: null
  other___not_listed_material_name: null
  does_this_material_contain_pfas: null
  is_this_material_a_rinsate_: null
  unknown_material: null
  description_of_unknown_material: null
  container_type: null
  other_container_type: null
  container_size__gallons_: null
  material_status: null
  pallet_number: null
  material_status_last_modified: null
  is_overpack_: null
  parent_entry_id: null
  total_gallons: null
  parent_globalid: null
  mat_entry_date: null
  date_updated: null
  purchase_date: null
  manufacture_date: null
  sealed_ready: null
  sealed_not_ready: null
  unsealed_ready: null
  unsealed_not_ready: null
  gallons_ready: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• epatestgis.gis.gis_AFFF_Form (0) -- Related To: AFFF_Form (0)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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