← All datasets

# curated.dev_billboard
Permitted billboards (1,164 rows; category: Permits & development; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 1164/1164 | e.g.: 537; 551; 909
- attrs->>'ACTUAL_ADD' | string | 1164/1105 | e.g.: 1000; 1314 1/2; 2600
- attrs->>'ARC_ADDRES' | string | 1164/1136 | e.g.: WAREHOUSE-AVAILABLE FOR RELO; 1410 CHOATE; 22730   KUYKENDAHL RD
- attrs->>'ARC_NAME' | string | 1164/2 | values:  ; 0
- attrs->>'BILLING_CY' | number | 1164/6 | values: 3; 1; 2; 13; 10; 9
- attrs->>'CITY_ETJ' | string | 1164/3 | values: CITY; ETJ;  
- attrs->>'COH_NUMBER' | string | 1164/485 | e.g.:  ; 332; 909
- attrs->>'COMMENTS' | string | 1164/982 | e.g.:  ; UPGRADE AS OUTLINED IN ORDINANCE 2008-336.; 2009 REMOVAL
- attrs->>'FACES' | number | 1164/5 | values: 2; 1; 4; 0; 55
- attrs->>'GIS_ADD' | string | 1164/1074 | e.g.:  ; 5000; 1000
- attrs->>'GIS_STREET' | string | 1164/276 | e.g.: NORTH FWY; GULF FWY; HEMPSTEAD
- attrs->>'H1' | number | 1164/18 | e.g.: 12; 14; 10
- attrs->>'HGT1' | number | 1164/100 | e.g.: 30; 35; 25
- attrs->>'ID_NUMBER' | string | 1164/1016 | e.g.:  ; 7108; 2254/2255
- attrs->>'KEY_' | string | 1164/520 | e.g.:  ; 492H; 451U
- attrs->>'LATITUDE' | string | 1164/1072 | e.g.: 29.73641; 29deg43'56N; 29.484839
- attrs->>'LOCATE' | string | 1164/1101 | e.g.:  ; AVAILABLE FOR RE-LO; WL 205' N/O LAURA KOPPE
- attrs->>'LOC_NAME' | string | 1164/2 | values: City_Points; 0
- attrs->>'LOG' | string | 1164/1041 | e.g.: RE-LO;  ; 10 YR
- attrs->>'LONGITUDE' | string | 1164/1075 | e.g.: -95.612898; -95.55488; -95.42995
- attrs->>'MATCH_ADDR' | string | 1164/657 | e.g.: 0; 23680 NORTH FWY; 9811 SOUTHWEST FWY
- attrs->>'MATCH_TYPE' | string | 1164/1 | values: A
- attrs->>'NUM' | number | 1164/12 | values: 1; 3; 6; 5; 2; 4; 7; 0; 8; 9; 14; 11
- attrs->>'PERMITTED' | string | 1164/1136 | e.g.: WAREHOUSE-AVAILABLE FOR RELO; 1410 CHOATE; 22730   KUYKENDAHL RD
- attrs->>'PROJECTNO' | string | 1164/1146 | e.g.:  ; 1015396; 98080818
- attrs->>'SCENIC_AIR' | string | 1164/5 | values:  ; 0; A; S; N
- attrs->>'SCORE' | number | 1164/11 | values: 0; 100; 75; 64; 63; 62; 61; 77; 60; 66; 81
- attrs->>'SIGN_CO' | string | 1164/40 | e.g.: CLEAR CHANNEL OUTDOOR, INC; SIGNAD; JOHN GANNON INC.
- attrs->>'STATUS' | string | 1164/3 | values: M; U; T
- attrs->>'STREET_NAM' | string | 1164/276 | e.g.: NORTH FWY; GULF FWY; SOUTHWEST FWY
- attrs->>'TYP' | string | 1164/3 | values: S; W;  
- attrs->>'W1' | number | 1164/33 | e.g.: 24; 48; 40
- attrs->>'X' | number | 1164/657 | e.g.: 0; 3095722.096138; 3065701.096141
- attrs->>'Y' | number | 1164/657 | e.g.: 0; 13967317.4156; 13808378.118322
- attrs->>'ZIP' | string | 1164/115 | e.g.: 77007;  ; 77092
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.