Name: TCEQ Reported Spills

Display Field: princ_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This point feature class represents emergency response spills received and investigated by the TCEQ. Reported incidents are assigned a unique Incident Tracking Number to document responsible parties, released materials, affected media, and investigation statuses. Note that individual tracking numbers may appear multiple times if multiple materials, media, or impacts were recorded for a single incident. Source & Lineage:Data Source: TCEQ Emergency Response Spills Dataset - https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Emergenc/xagr-a3x2/about_dataGeometry & Attribute Processing: Derived by Grapevine Public Works GIS staff using coordinates and location descriptions provided in state incident reports.Maintenance & Update Frequency: As Needed / Periodic (Updated following state dataset releases)Process Step (Lineage Description):Data Extraction: Spill incident records were downloaded from the state open data portal ([https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Emergenc/xagr-a3x2](https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Emergenc/xagr-a3x2)).Spatial Filtering & Mapping: Incidents located within the municipal boundary and ETJ were filtered and mapped to spatial coordinates.Attribute Population: Incident tracking numbers, customer/entity names, released materials, and physical descriptions were imported into the enterprise geodatabase (Last updated July 4, 2023).

Service Item Id: d6300b0c4d494099a2b33d2d15c25778

Copyright Text: Texas Commission on Environmental Quality (TCEQ), PW GIS Division.

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.0811418523140363E7
YMin: 3879298.419513058
XMax: -1.0801331037253303E7
YMax: 3894112.3953177626
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: media_name
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: WASTE
  Label: Waste
  Description: N/A
  Symbol:
  
• Value: WATER
  Label: Water
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• cn ( nullable: true, length: 254, alias: Customer Number, type: esriFieldTypeString )
• princ_name ( nullable: true, length: 254, alias: Customer Name, type: esriFieldTypeString )
• rn ( nullable: true, length: 254, alias: Regulated Entity Number, type: esriFieldTypeString )
• reg_ent_na ( nullable: true, length: 254, alias: Regulated Entity Name, type: esriFieldTypeString )
• phys_loc_d ( nullable: true, length: 254, alias: Physical Location, type: esriFieldTypeString )
• near_city_ ( nullable: true, length: 254, alias: Nearest City Name, type: esriFieldTypeString )
• loc_cnty_n ( nullable: true, length: 254, alias: County, type: esriFieldTypeString )
• loc_zip_tx ( nullable: true, length: 254, alias: Location Zip Code, type: esriFieldTypeString )
• lat_dec_co ( nullable: true, alias: Latitude, type: esriFieldTypeDouble )
• long_dec_c ( nullable: true, alias: Longitude, type: esriFieldTypeDouble )
• deliv_txt ( nullable: true, length: 254, alias: Mailing Address, type: esriFieldTypeString )
• deliv_2_tx ( nullable: true, length: 254, alias: Mailing Address 2, type: esriFieldTypeString )
• usps_state ( nullable: true, length: 254, alias: State, type: esriFieldTypeString )
• zip_plus4_ ( nullable: true, length: 254, alias: Zip Code, type: esriFieldTypeString )
• incid_trac ( nullable: true, length: 254, alias: Incident Number, type: esriFieldTypeString )
• status_cd ( nullable: true, length: 254, alias: Incident Status, type: esriFieldTypeString )
• date_start ( nullable: true, length: 8, alias: Incident Start Date, type: esriFieldTypeDate )
• date_rcvd_ ( nullable: true, length: 8, alias: Incident Date Received, type: esriFieldTypeDate )
• date_statu ( nullable: true, length: 8, alias: Date status, type: esriFieldTypeDate )
• media_name ( nullable: true, length: 254, alias: Media, type: esriFieldTypeString )
• rcv_wtr_bo ( nullable: true, length: 254, alias: Receiving Water Body, type: esriFieldTypeString )
• source ( nullable: true, length: 254, alias: Incident Source, type: esriFieldTypeString )
• material_n ( nullable: true, length: 254, alias: Material Released, type: esriFieldTypeString )
• amt_num ( nullable: true, alias: Material Released Amount, type: esriFieldTypeDouble )
• uom_cd ( nullable: true, length: 254, alias: Unit of Measure, type: esriFieldTypeString )
• clas_cd ( nullable: true, length: 254, alias: Spill Classification, type: esriFieldTypeString )
• incident_e ( nullable: true, length: 254, alias: Effect, type: esriFieldTypeString )
• incident_n ( nullable: true, length: 254, alias: Nature, type: esriFieldTypeString )
• comments ( nullable: true, length: 254, alias: Incident Comment, type: esriFieldTypeString )
• action ( nullable: true, length: 254, alias: Incident Action Taken, type: esriFieldTypeString )
• descriptio ( nullable: true, length: 254, alias: Incident Description, type: esriFieldTypeString )
• inv_num ( nullable: true, length: 254, alias: Investigation Number, type: esriFieldTypeString )
• tnrcc_regi ( nullable: true, length: 254, alias: TCEQ Region, type: esriFieldTypeString )
• Shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

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

  Iteminfo   Thumbnail   Metadata