Name: AFFF Materials - RFP West

Display Field: material_name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 537a5155f3c04605b2e7ae920de8301b

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Unique Id Infos:

Type: simple
Fields: ["objectid"]
OID Field Contains Hash Value: false

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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid )
• mat_entry_id ( type: esriFieldTypeDouble, alias: mat_entry_id )
• manufacturer ( type: esriFieldTypeString, alias: manufacturer, length: 255 )
• other___not_listed_manufacturer ( type: esriFieldTypeString, alias: other___not_listed_manufacturer, length: 255 )
• material_name ( type: esriFieldTypeString, alias: material_name, length: 255 )
• other___not_listed_material_name ( type: esriFieldTypeString, alias: other___not_listed_material_name, length: 255 )
• does_this_material_contain_pfas ( type: esriFieldTypeString, alias: does_this_material_contain_pfas, length: 255 )
• is_this_material_a_rinsate_ ( type: esriFieldTypeString, alias: is_this_material_a_rinsate_, length: 255 )
• unknown_material ( type: esriFieldTypeString, alias: unknown_material, length: 255 )
• description_of_unknown_material ( type: esriFieldTypeString, alias: description_of_unknown_material, length: 255 )
• container_type ( type: esriFieldTypeString, alias: container_type, length: 255 )
• other_container_type ( type: esriFieldTypeString, alias: other_container_type, length: 255 )
• container_size__gallons_ ( type: esriFieldTypeDouble, alias: container_size__gallons_ )
• material_status ( type: esriFieldTypeString, alias: material_status, length: 255 )
• pallet_number ( type: esriFieldTypeString, alias: pallet_number, length: 255 )
• material_status_last_modified ( type: esriFieldTypeString, alias: material_status_last_modified, length: 255 )
• is_overpack_ ( type: esriFieldTypeString, alias: is_overpack_, length: 255 )
• parent_entry_id ( type: esriFieldTypeString, alias: parent_entry_id, length: 255 )
• globalid ( type: esriFieldTypeString, alias: globalid, length: 38 )
• parent_globalid ( type: esriFieldTypeString, alias: parent_globalid, length: 38 )
• mat_entry_date ( type: esriFieldTypeDate, alias: mat_entry_date, length: 8, precision: 1 )
• date_updated ( type: esriFieldTypeDate, alias: date_updated, length: 8, precision: 1 )
• purchase_date ( type: esriFieldTypeDate, alias: purchase_date, length: 8, precision: 1 )
• manufacture_date ( type: esriFieldTypeDate, alias: manufacture_date, length: 8, precision: 1 )
• sealed_ready ( type: esriFieldTypeSmallInteger, alias: sealed_ready )
• sealed_not_ready ( type: esriFieldTypeSmallInteger, alias: sealed_not_ready )
• unsealed_ready ( type: esriFieldTypeSmallInteger, alias: unsealed_ready )
• unsealed_not_ready ( type: esriFieldTypeSmallInteger, alias: unsealed_not_ready )
• gallons_ready ( type: esriFieldTypeInteger, alias: gallons_ready )
• gallons_not_ready ( type: esriFieldTypeInteger, alias: gallons_not_ready )
• total_gallons ( type: esriFieldTypeInteger, alias: total_gallons )
• entity_name ( type: esriFieldTypeString, alias: entity_name, length: 255 )
• entity_id ( type: esriFieldTypeString, alias: entity_id, length: 60000 )
• entity_city ( type: esriFieldTypeString, alias: entity_city, length: 255 )
• entity_county ( type: esriFieldTypeString, alias: entity_county, length: 255 )

Relationships:

• epaprodgis.oepa_eu.%gis_afff_registered_entities_vw (0) -- Related To: AFFF_Form (0)
• epaprodgis.oepa_eu.%gis_afff_registered_entities_vw (3) -- Related To: AFFF Registrations East (4)
• epaprodgis.oepa_eu.%gis_afff_registered_entities_vw (6) -- Related To: AFFF Registrations West (5)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata