← All datasets

# curated.safety_safeclear_segment
SAFEClear freeway tow segments (39 rows; category: Traffic safety; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 39/39 | e.g.: 34; 18; 32
- attrs->>'COMPANY_NAME' | string | 39/16 | e.g.: Fast Tow; Car King Towing; Humble Towing Service
- attrs->>'COMPANY_PHONE' | string | 39/16 | e.g.: 713-228-2221; 281-540-1212; 713-686-5677
- attrs->>'Name' | string | 39/32 | e.g.: 28; 1; 21
- attrs->>'OWNER_1_EMAIL' | string | 39/18 | e.g.: humbletowing@aol.com; allen@collisionkingautocenter.com; Frankie@Fasttow.net or jeanetterash@gmail.com
- attrs->>'OWNER_1_NAME' | string | 39/15 | e.g.: Jeanette Rash; Allen Suleiman; Louis Matthew Teal
- attrs->>'OWNER_1_PHONE' | string | 39/15 | e.g.: 281-850-4001; 713-972-2303; 281-987-8697 or 281-361-8697
- attrs->>'OWNER_2_EMAIL' | string | 39/2 | values: N/A; natoparina@gmail.com
- attrs->>'OWNER_2_NAME' | string | 39/2 | values: N/A; Natalya Oparina
- attrs->>'OWNER_2_PHONE' | string | 39/2 | values: N/A; 832-661-1592
- attrs->>'SEGMENT' | string | 39/32 | e.g.: 28; 1; 21
- attrs->>'SEGMENT_DESCRIPTION' | string | 39/32 | e.g.: Downtown Inner Loop: Katy Freeway (I-10) between Gulf Freewa; Eastex Freeway (59) outside of 610: 5400-10600, 14600-18200,; 1. North Loop W to North Loop between Northwest Freeway (290
- attrs->>'Segment_Length' | number | 39/39 | e.g.: 4.08381224; 4.02821112; 3.83294463
- attrs->>'SUPERVISOR_24_HOUR' | string | 39/15 | e.g.: Frankie Rash; Matt Teal; Sedrick Bradley
- attrs->>'SUPERVISOR_PHONE' | string | 39/15 | e.g.: 281-960-3808; 713-829-7347; 281-802-5815
- attrs->>'VSF_1' | string | 39/15 | e.g.: Zone one Auto Storage; North Houston Motors; KTL Enterprises
- attrs->>'VSF_1_ADDRESS' | string | 39/16 | e.g.: 16711 Eastex Fwy; 2305 Lyons; 1700 Brittmore
- attrs->>'VSF_1_PHONE' | string | 39/15 | e.g.: 281-540-1019; 713-228-2221; 713-468-4242
- attrs->>'VSF_2' | string | 39/5 | values: N/A; Best Auto Storage; Expro Auto Storage; Zone one Auto Storage; Area 5 Vehicle Storage
- attrs->>'VSF_2_ADDRESS' | string | 39/5 | values: N/A; 6125 Industrial Way; 940 S. Hwy 6; 10410 SW Plaza Dr; 2305 Lyons
- attrs->>'VSF_2_PHONE' | string | 39/5 | values: N/A; 713-221-1747; 281-598-9774; 713-228-2221; 713-988-7600
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.