20260510 05012000 1.0 TRUE Completed Capital Projects by Council Districts This dataset depicts all categories of completed Capital Projects from the past 5 years occurring inside the city limits of Houston or within Houston’s extraterritorial jurisdiction (ETJ). The categories include Agreements, Contract Overlay, Roadway, Sidewalks, Storm/Sewar, Wastewater, and Water. The original datasets reside in GeoGIMS DB under the CP schema (i.e., GeoGIMS.CP.AGREEMENTS, GeoGIMS.CP.CONTR_OVL, GeoGIMS.CP.ROADWAY, GeoGIMS.CP.SIDEWALKS, GeoGIMS.CP.STORM_SEWER, GeoGIMS.CP.WASTEWATER, and GeoGIMS.CP.WATER). This dataset is recreated every Monday at 2 AM using a Windows Scheduled Task on .144 calling a Python script called update_council_district_capital_project.py. It is recreated weekly since the 7 origin datasets are recreated weekly. City of Houston Public Works Disclaimer: This is a derived dataset designed to depict completed Capital Projects by Council District. Therefore, projects crossing council districts, have been duplicated enough times to ensure that only a single council district value appears in the COUN_DIST column (e.g., if a specific project occurs in 3 council districts, it has 3 records in this dataset). This allows us to use a simple definition query on each council district layer (i.e., COUN_DIST = 'A'). Furthermore, this COH data is prepared and made available for general reference purposes only and should not be used, or relied upon for specific applications, without independent verification. The City of Houston neither represents, nor warrants data accuracy, or completeness, nor will the City of Houston accept liability of any kind in conjunction with its use. Inter Agency Agreements Inter Local AgreementsContract Overlay Asphalt Concrete RepairsRoadway Street and TrafficSidewalksStorm Water Storm SewerWaste Water Sanitary SewerWater Line Replacement Pump Station Improvements Water Wells This derived dataset depicts completed Capital Projects by council district from the following 7 origin datasets. 1. AGREEMENTS Agreements layer provides up to date information on TIRZ projects, TXDOT and various other Agency managed projects, that are in various stages such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP). 2. CONTR_OVL Contract Overlay layer provides up to date information on projects involving asphalt and concrete panel replacement that are in various such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP). 3. ROADWAY Roadway layer provides up to date information on active CIP projects involving various projects such as Bridge reconstruction, Intersection redesign, Local street reconstruction, Major Thoroughfare, and Traffic signals that are in various stages such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP). 4. SIDEWALKS Sidewalks layer provides up to date information on active CIP projects involving sidewalks that are in various stages such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP). 5. STORM_SEWER Stormwater layer provides up to date information on active CIP projects involving sewer lines, pump stations, and local drainage projects that are in various stages such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP). 6. WASTEWATER Wastewater layer provides up to date information on active CIP projects involving sewer lines, Lift stations, treatment plants, and substitute services that are in various stages such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP). 7. WATER Water layer provides up to date information on active CIP projects involving water lines, purification plants, wells, and substitute services that are in various stages such as Future (Unfunded/ Unscheduled) (F), Future Programmed (FP), Programmed (P), Design (E), Pending Construction (PC), Construction (C) and Complete (CP).