Houston Open Data Explorer

← All datasets

# curated.zoning_special_min_building_line
Special minimum building line blocks (249 rows; category: Planning rules; geometry column `geom` (MultiPolygon, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 249/249 | e.g.: 13; 144; 121
- attrs->>'App_Num' | string | 249/249 | e.g.: 75; 52REN; 38002
- attrs->>'BLD__LINE' | number | 240/30 | e.g.: 20; 15; 25
- attrs->>'BLKFACE_' | number | 249/6 | values: 2; 1; 0; 4; 5; 3
- attrs->>'Expiration_Date' | number | 49/40 | e.g.: 2949523200000; 2939846400000; 2321395200000
- attrs->>'No_of_Lots' | number | 117/36 | e.g.: 6; 24; 12
- attrs->>'ORDINANCE_' | string | 234/230 | e.g.: 2002-0326; ; 2015-1171
- attrs->>'START_DATE' | null | 63/50 | e.g.: 1651795200000; 1659571200000; 1664236800000
- attrs->>'Status' | string | 249/5 | values: Approved; Expired; Pending; Ineligible; Withdrawn
- attrs->>'TIME' | string | 52/42 | e.g.: 5/7/22; 5/6/20; 9/16/22
- attrs->>'Type' | string | 249/3 | values: NEW; RENEW; RENEW

attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.