Name: FacilityInspectionTable

Display Field: Facility

Type: Table

Description: Table listing facilities of local interest in Chicago with recent EPA air enforcement activity. Information includes facility names, addresses, Federal Registry Service ID numbers, and year of the most recent EPA inspection.

Copyright Text: U.S. EPA Office of Enforcement and Compliance Assurance, U.S. EPA Region 5 Enforcement and Compliance Assurance Division

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Facility (type: esriFieldTypeString, alias: Facility, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FRSID (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• StreetAddress (type: esriFieldTypeString, alias: StreetAddress, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ZipCode (type: esriFieldTypeString, alias: ZipCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LinkToDocument (type: esriFieldTypeString, alias: Recent Inspection Report: , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• YearofDocument (type: esriFieldTypeString, alias: Year of Report:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: FacilityInspectionTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/24/2023 12:30:21 AM

Schema Last Edit Date: 1/24/2023 12:30:21 AM

Data Last Edit Date: 1/24/2023 12:30:02 AM

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