← All datasets

# curated.env_concrete_batch_plant
Permitted concrete batch plants in Harris County (129, TCEQ, 2021), a long-running neighborhood air-quality issue (129 rows; category: Environment; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 129/129 | e.g.: 118; 123; 8
- attrs->>'Checked_in_PCSMS' | null | 101/100 | e.g.: PCSID 13432; PCSID 25566; PCSID 27691
- attrs->>'Customer_Name' | string | 129/96 | e.g.: CAMPBELL CONCRETE & MATERIALS LLC; ALAMO CONCRETE PRODUCTS COMPANY; SOUTHERN STAR CONCRETE INC
- attrs->>'Lat' | number | 129/122 | e.g.: 29.880046; 29.88; 30.036831
- attrs->>'Lon' | null | 128/123 | e.g.: -95.588165; -95.52; -95.757205
- attrs->>'Near_City_Name' | null | 128/15 | e.g.: HOUSTON; HOCKLEY; TOMBALL
- attrs->>'Permit_Number' | null | 128/126 | e.g.: 87310; 77467; 115566
- attrs->>'Permit_Type' | null | 128/4 | values: STDPMT; PBR; NSR; EXEMPT
- attrs->>'Physical_Location' | string | 129/125 | e.g.: 11913 FM 529 RD; 17919 KERMIER RD; 5521 BREEN DR
- attrs->>'Regulated_Entity' | string | 128/127 | e.g.: RN102609617; RN110522695; RN101575702
- attrs->>'Renewal_Date' | number | 104/98 | e.g.: 1736812800000; 1761782400000; 1752537600000
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.