curated.facility_mental_health_clinic · Houston Open Data Explorer

← All datasets
# curated.facility_mental_health_clinic
Mental health clinics in Harris County (83), compiled by the county in 2026 (83 rows; category: Facilities; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 83/83 | e.g.: 75; 13; 34
- attrs->>'AddNum' | string | 83/37 | e.g.: 7660; 6671; 2450
- attrs->>'AddNumFrom' | string | 83/7 | values: ; 7210; 2501; 9201; 7101; 12000; 9000
- attrs->>'AddNumTo' | string | 83/7 | values: ; 7398; 2549; 12038; 7199; 9299; 9198
- attrs->>'Addr_type' | string | 83/3 | values: PointAddress; StreetAddress; 
- attrs->>'City' | string | 83/2 | values: HOUSTON; 
- attrs->>'Country' | string | 83/2 | values: ; USA
- attrs->>'County' | string | 83/2 | values: HARRIS COUNTY; 
- attrs->>'DisplayX' | number | 83/7 | values: 0; -95.516272; -95.53833; -95.507906; -95.533536; -95.590402; -95.528488
- attrs->>'DisplayY' | number | 83/7 | values: 0; 29.702069; 29.740165; 29.718115; 29.681298; 29.684934; 29.730882
- attrs->>'Distance' | number | 83/1 | values: 0
- attrs->>'IN_SingleLine' | string | 83/61 | e.g.: 7660 Woodway Dr. Suite 585 Houston, TX 77063; 7660 Woodway Dr. Suite 385 Houston, TX 77063; 7670 Woodway Drive Suite 270 Houston, TX 77063
- attrs->>'LangCode' | string | 83/1 | values: 
- attrs->>'Loc_name' | string | 83/3 | values: HGAC_Address_P; HGAC_StarMap_R; 
- attrs->>'Match_addr' | string | 83/37 | e.g.: 7660 WOODWAY DR, HOUSTON, TX, 77063; 6671 SOUTHWEST FWY, HOUSTON, TX, 77074; 2450 FONDREN RD, HOUSTON, TX, 77063
- attrs->>'Match_type' | string | 83/1 | values: A
- attrs->>'Score' | number | 83/8 | values: 100; 90.1; 0; 96.29; 99.32; 94.01; 90.92; 98.02
- attrs->>'Side' | string | 83/3 | values: ; R; L
- attrs->>'StAddr' | string | 83/37 | e.g.: 7660 WOODWAY DR; 6671 SOUTHWEST FWY; 2450 FONDREN RD
- attrs->>'State' | string | 83/2 | values: TX; 
- attrs->>'StateAbbr' | string | 83/2 | values: TX; 
- attrs->>'Status' | string | 83/3 | values: M; U; T
- attrs->>'StDir' | string | 83/1 | values: 
- attrs->>'StName' | string | 83/22 | e.g.: WOODWAY; SOUTHWEST; FONDREN
- attrs->>'StPreDir' | string | 83/2 | values: ; S
- attrs->>'StPreType' | string | 83/1 | values: 
- attrs->>'StType' | string | 83/8 | values: DR; FWY; RD; BLVD; ST; ; AVE; LN
- attrs->>'USER_Address' | string | 83/61 | e.g.: 7660 Woodway Dr. Suite 585 Houston, TX 77063; 7660 Woodway Dr. Suite 385 Houston, TX 77063; 7670 Woodway Drive Suite 270 Houston, TX 77063
- attrs->>'USER_LCDC' | number | 42/2 | values: 0; 1
- attrs->>'USER_LMFT_AAMFT' | null | 45/2 | values: 0; 1
- attrs->>'USER_LPC' | number | 61/2 | values: 1; 0
- attrs->>'USER_MD' | null | 40/2 | values: 0; 1
- attrs->>'USER_MSW_LCSW_LMSW' | number | 48/2 | values: 0; 1
- attrs->>'USER_Name' | string | 83/83 | e.g.: Mark Duane Woodhouse; Kennedy Sanchez; Craig Vaughn
- attrs->>'USER_Other__associates__Interns__Pre_Licensed__etc_' | number | 41/2 | values: 0; 1
- attrs->>'USER_PhD_EdD_PsyD_DSW' | number | 47/2 | values: 0; 1
- attrs->>'USER_Zip_Code' | number | 83/7 | values: 77063; 77074; 77036; 77092; 77082; 77081; 77099
- attrs->>'X' | number | 83/37 | e.g.: -95.503474; -95.498692; -95.522144
- attrs->>'Xmax' | number | 83/1 | values: 0
- attrs->>'Xmin' | number | 83/1 | values: 0
- attrs->>'Y' | number | 83/37 | e.g.: 29.752745; 29.714393; 29.740879
- attrs->>'Ymax' | number | 83/1 | values: 0
- attrs->>'Ymin' | number | 83/1 | values: 0
- attrs->>'ZIP' | string | 83/10 | values: 77063; 77074; 77036; 77092; ; 77082; 77099; 77081; 77090; 77027
- attrs->>'ZIP4' | string | 83/1 | values: 
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.