curated.boundary_constable_precinct · Houston Open Data Explorer

← All datasets
# curated.boundary_constable_precinct
Harris County constable and justice-of-the-peace precincts (8) (8 rows; category: Boundaries & demographics; geometry column `geom` (MultiPolygon, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 8/8 | values: 2; 4; 7; 3; 6; 5; 1; 8
- attrs->>'CITY' | string | 8/4 | values: Houston; Pasadena; Baytown; Spring
- attrs->>'COMMISH' | string | 8/8 | values: Mark Herman; James Phillips; Phil Sandlin; Terry Allbritton; Sherman Eagleton; Alan Rosen; Jerry Garcia; Silvia Trevino
- attrs->>'FAX' | string | 8/8 | values: (713)643-3401; (713)921-2334; (281)930-0494; (713)274-2554; (281)492-3525; (713)755-8951; (281)401-6287; (713)477-5348
- attrs->>'JPCON' | number | 8/1 | values: 0
- attrs->>'PCT_NUM' | number | 8/8 | values: 2; 4; 7; 3; 6; 5; 1; 8
- attrs->>'PHONE' | string | 8/8 | values: (713)755-5200; (713)477-2766; (281)927-6700; (832)927-6200; (281)479-2525; (713)643-6118; (713)923-9156; (281)427-4792
- attrs->>'PRECINCT' | string | 8/8 | values: Precinct 3 Sherman Eagleton; Precinct 2 Jerry Garcia; Precinct 6 Silvia Trevino; Precinct 4 Mark Herman; Precinct 1 Alan Rosen; Precinct 8 Phil Sandlin; Precinct 5 Terry Allbritton; Precinct 7 James Phillips
- attrs->>'Shape_STAr' | number | 8/8 | values: 10497803807.9; 3016318692.44; 10429405452.6; 4301752152.75; 4593933157.36; 2642340195.38; 13181195963.1; 890815874.904
- attrs->>'Shape_STLe' | number | 8/8 | values: 471550.261985; 194092.455536; 339447.212055; 873469.608935; 709161.724229; 568889.906857; 518435.610254; 282081.789682
- attrs->>'STATE' | string | 8/1 | values: TX
- attrs->>'STREET' | string | 8/8 | values: 701 W. Baker Rd.; 5290 Griggs; 17423 Katy Fwy; 7330 Spencer Hwy; 1302 Preston, 3rd floor; 5900 Canal St.; 101 S. Richey #C; 6831 Cypresswood Dr.
- attrs->>'TDD' | string | 8/7 | values:  ; (281)492-3500; (281)488-4040; (281)401-6277; (713)475-3090; (713)643-4052; (713)755-4879
- attrs->>'Web' | string | 8/8 | values: https://hccp3.com/; http://hccp2.com; http://www.harriscountytx.gov/pct8/; https://constablepct5.com/; http://www.pct1constable.net/; https://constable7.harriscountytx.gov; https://constablesilviatrevino.com/; https://www.constablepct4.com/
- attrs->>'ZIP' | string | 8/8 | values: 77506; 77505; 77002; 77521; 77021; 77011; 77094; 77379
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.