← All datasets

# curated.dev_billboard_clear_channel
Clear Channel medium billboards (1,571 rows; category: Permits & development; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 1571/1571 | e.g.: 1487; 791; 71
- attrs->>'ADDRESS' | string | 1571/1359 | e.g.: 4000 1/2; 2700 1/2; 1000
- attrs->>'DESIGNATIO' | string | 1571/13 | e.g.: BLNK; UL; PNC
- attrs->>'DUPLICATE' | string | 99/2 | values: Yes; Spe
- attrs->>'FACE_HGT' | number | 1571/6 | values: 12; 6; 14; 10; 11; 20
- attrs->>'FACE_WDTH' | number | 1571/17 | e.g.: 24; 12; 48
- attrs->>'IDENTIFER' | number | 1571/585 | e.g.: 0; 5425; 2560
- attrs->>'LATITUDE' | number | 1571/1469 | e.g.: 29.77823; 29.84011; 29.7657
- attrs->>'LOCATE' | string | 1571/1458 | e.g.:  ; EL 265' N/O CONNERVALE; EL 90' N/O GREENSTONE
- attrs->>'LOCATION' | string | 1571/1528 | e.g.:  ; I-10 Katy Fwy SS 0.3 mi w/o I-45; Veterans Memorial ES 25 ft n/o Mitchell
- attrs->>'LONGITUDE' | number | 1571/1472 | e.g.: -95.52441; -95.42995; -95.28422
- attrs->>'MATCH' | null | 223/1 | values: Yes
- attrs->>'MAX_HEIGHT' | number | 1571/84 | e.g.: 14; 30; 24
- attrs->>'NHS' | string | 1571/5 | values: YES; NO; Yes; No;  
- attrs->>'NOTE' | string | 1571/183 | e.g.:  ; CC changed to 2fc but BB has 1 face, where did second face c; CC changed to Wood BB and picture show Steel
- attrs->>'OF_FACES' | number | 1571/4 | values: 2; 1; 4; 3
- attrs->>'OLD_LOG__' | string | 1571/1504 | e.g.:  ; relo; Katy Relo
- attrs->>'PERMIT_PRO' | string | 1571/1387 | e.g.:  ; 3064698; 1005099
- attrs->>'S_M_L__XL' | string | 1571/4 | values: M; S; L; XL
- attrs->>'STREETNAME' | string | 1571/362 | e.g.: HEMPSTEAD; NORTH FWY; SH 003
- attrs->>'WOOD_STEEL' | string | 1571/4 | values: S; W; Steel; Wood
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.