← All datasets

# curated.infra_cell_tower
Cell towers (720 rows; category: Infrastructure & drainage; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 720/720 | e.g.: 537; 75; 497
- attrs->>'Action_' | string | 720/40 | e.g.: approved; Approved; Exempt
- attrs->>'ActionDate' | null | 425/214 | e.g.: 781401600000; 885772800000; 875836800000
- attrs->>'Addr' | number | 720/584 | e.g.: 0; 6767; 4619
- attrs->>'Address' | string | 720/652 | e.g.: 6767 Alamo Rd; 0  ; 4229 Bellaire Blvd
- attrs->>'AdmApproval' | string | 720/4 | values: ; X; x; N/A
- attrs->>'Appeal' | string | 720/2 | values: ; X
- attrs->>'ApplicantRep' | string | 720/78 | e.g.: ; Dave Petrakovitz; Dave Petrokovitz
- attrs->>'CDist' | string | 720/14 | e.g.: A; I; B
- attrs->>'CompanyApplicant' | string | 720/134 | e.g.: Houston  Cellular; Sprint  PCS; GTE Mobilnet
- attrs->>'DateAct_Apprd' | number | 598/341 | e.g.: 781401600000; 885772800000; 881193600000
- attrs->>'DateRecd' | string | 720/381 | e.g.: 8/29/1994; 8/11/1997; 
- attrs->>'DateTCAct' | string | 39/30 | e.g.: 12/19/2000; 07/28/2008; 01/16/2001
- attrs->>'Dev_PlatNum' | string | 720/32 | e.g.: ; 92-10174; 97 - 14379
- attrs->>'DirDate' | number | 369/180 | e.g.: 781401600000; 885772800000; 875836800000
- attrs->>'Ext' | string | 720/7 | values: 6; ; 2/3; 1/2; C; 2/3 C; 2/3/
- attrs->>'Fee_Req' | string | 720/8 | values: ; no; yes paid; Yes; yes; no paid; yep paid; YES
- attrs->>'Height' | string | 720/72 | e.g.: 100'; 120'; 80'
- attrs->>'KeyMap' | string | 720/460 | e.g.: ; 410Y; 494P
- attrs->>'Lambert' | string | 720/193 | e.g.: ; 5061; 5256
- attrs->>'Lat_d' | string | 720/5 | values: 29; ; 30; 95; 21
- attrs->>'Lat_DD' | null | 677/479 | e.g.: 29.64333333; 29.86222222; 29.78527778
- attrs->>'Lat_m' | string | 720/46 | e.g.: 44; 40; 51
- attrs->>'Lat_s' | string | 720/72 | e.g.: ; 03; 23
- attrs->>'Loc_name' | null | 82/4 | values: ADDRESS; ; ROADS; APPRAISAL_HCAD
- attrs->>'Long_d' | null | 690/7 | values: 95; -95; 96; 99; 18; 94; 22
- attrs->>'Long_DD' | number | 674/524 | e.g.: -95.51166667; -95.33527778; -95.57083333
- attrs->>'Long_m' | number | 676/40 | e.g.: 20; 28; 18
- attrs->>'Long_s' | number | 674/65 | e.g.: 31; 10; 30
- attrs->>'Match_addr' | string | 82/61 | e.g.: ; 4115 S KIRKWOOD RD, HOUSTON, TX, 77072; 4301 EASTPARK DR, HOUSTON, TX, 77028
- attrs->>'PermitDate' | null | 168/135 | e.g.: 832291200000; 785462400000; 1261526400000
- attrs->>'ProjectNumb' | string | 720/290 | e.g.: ; 94084180; 99091352
- attrs->>'Protest' | string | 720/2 | values: ; X
- attrs->>'Remarks' | string | 720/149 | e.g.: ; cannot locate; no project
- attrs->>'Sffx' | string | 720/6 | values: ; E; W; S; N; C
- attrs->>'StreetName' | string | 720/422 | e.g.: Westheimer; Southwest; Fondren
- attrs->>'Sttype' | string | 720/28 | e.g.: Rd; St; Dr
- attrs->>'Tower_Num' | string | 720/720 | e.g.: 2008-T-0572; 1996-T-0184; 2004-T-0458
- attrs->>'Waiver' | string | 720/4 | values: ; X; XXX; XX
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.