Texas Commission on Environmental Quality (TCEQ) 20121203 Unknown Water CCN Service Areas vector digital data Phase 4 - Conversion to Personal Geodatabase withheld Austin, Texas Texas Commission on Environmental Quality (TCEQ) TCEQ Unpublished Material Water CCN Service Areas Phase 4 - Conversion to Personal Geodatabase ccn_w A Certificate of Convenience and Necessity (CCN) is issued by the Texas Commission on Environmental Quality (TCEQ), and authorizes a utility to provide water and/or sewer service to a specific area. The CCN obligates the water or sewer retail public utility to provide continuous and adequate service to every customer who requests service in that area. The maps and digital (spatial) data provided in the new Water Utilities Map Viewer delineate the official CCN service areas and CCN facility lines issued by the TCEQ. The Water Utilities Map Viewer may be accessed from the following web site: http://www.tceq.texas.gov/gis/iwudview.html This dataset is a Texas statewide polygon layer of water CCN service areas. The CCNs were digitized from Texas Department of Transportation (TxDOT) county mylar maps. The mylar maps were the base maps on which the CCNs were originally drawn and maintained. CCNs are currently created and maintained using digitizing methods, coordinate geography or imported from digital files submitted by the applicant. TxDOT digital county urban road files are used as the base maps on which the CCNs are geo-referenced. It is best to view the water CCN service area data in conjunction with the sewer CCN service areas, water and sewer CCN facility line data layers. *Important Note: This CCN spatial dataset is updated on a monthly, or as needed basis using Geographic Information System (GIS) software. The official CCN spatial dataset including all types of CCN services areas (water and sewer CCN service areas; water and sewer CCN facility lines) are available for download for the entire state of Texas and is current as of their last updated date. This dataset is used by TCEQ's Utilities & Districts Section to maintain a current spatial inventory of all CCNs. This information is used by state and local governmental agencies, water and sewer utility service purveyors and the public. This layer shows the official water CCN service areas that have been designated by the TCEQ. All CCNs go through an application and review process before the boundaries are made official. For more information about CCN Applications please visit the following website http://www.tceq.state.tx.us/permitting/water_supply/ud/publist.html#ccn. Pursuant to V.T.C.A., Water Code, Chapter 13, sub-chapter G, any retail public water and sewer utility may obtain a certificate of convenience and necessity (CCN). Investor owned utilities (IOU), non-profit, member-owned, member-controlled water supply or sewer service corporations (WSC) incorporated under Article 1434(a) of Vernon's Texas Civil Statutes, and affected counties are required to obtain a CCN before utility service can be provided to an area already lawfully being served. A CCN gives the holder the legal right to provide water and/or sewer utility service for compensation, either directly through a monthly rate or indirectly through maintenance fees, property owners fees etc., to a particular service area and obligates the certificate holder to provide service to every customer and qualified applicant who requests service within that area. en 20121203 20121203 In work As needed -106.645918 -93.582836 36.448487 25.837017 372962.940700 1610457.125500 412819.562500 1585476.125000 CCN Certificate of Convenience and Necessity Water IOU Investor-Owned-Utility WSC Water Supply Corporation Certificate Permit Service provider Utility Utility System TX Texas 254 Counties Read access only. Acknowledgment of the TCEQ on any products using or deriving from this CCN spatial dataset would be appreciated. Suzanne Jaster Texas Commission on Environmental Quality (TCEQ) Senior Cartographer mailing address
MC-153
P.O. Box 13087
Austin TX 78753 physical address
12100 Park 35 Circle
Bldg. F, 3rd Floor
Austin TX 78753 512-239-6950 512-239-6972 suzanne.jaster@tceq.texas.gov M-F 8:00 AM - 4:30 PM For questions about the CCN spatial dataset, please contact Suzanne Jaster by E-mail at: sjaster@tceq.texas.gov This CCN spatial dataset is edited and managed in GIS by Suzanne Jaster, the Senior Cartographer and CCN Data Custodian for TCEQ's Utilities & Districts Section. ESRI ArcCatalog 9.3.1.4000 File Geodatabase Feature Class Water CCN Service Areas All data records (attributes) are entered, updated, and maintained by the CCN data set custodian. This CCN spatial dataset only contains the CCN Mapping data obtained from the Final Maps, which were consented to by all parties and have been final ordered by the Commission. Each CCN is assigned a unique ID. The ID can be referenced back to the TCEQ's Water Utilities Database (WUD). By linking the CCN layer attribute table with the WUD database using the unique CCN ID, the CCN number, utility name, Texas County Code located in the attribute table can be verified against the values in WUD database. All CCNs and their attributes are checked for accuracy by CCN Mapping staff. The TCEQ has utilized Arcview 3.2a to edit and maintain the CCN polygons and polylines as shapefiles. Some shapefiles were converted to a regions layer with topology using ArcGIS 8.1 on NT 4.0 (Build 1381), Service pack 5. Once the entire State is converted to GIS, the TCEQ will work towards managing the CCN spatial data layers in a personal Geodatabase using ArcGIS. CCNs are created, updated and maintained on a daily basis. Both spatial and attribute information are added or modified based on maps and information contained in the CCN or STM application. The attribute information is entered in the same format as it is provided by the CCN or STM applicant. All data records are managed for quality assurance and quality control by Suzanne Jaster, the CCN dataset custodian. The TCEQ has completed their GIS conversion of all CCNs existing on hard copy mylar maps (254 counties in Texas) to a digital format. The CCN spatial dataset is available in the following three spatial formats: shapefile (SHP), AutoCAD (DWG) and Geodatabase (MDB). This CCN spatial dataset only contains the CCN mapping data obtained from the Final Maps, which were consented to by all parties and have been final ordered by the Commission. As of the last updated date for this CCN dataset all 254 counties in Texas have been retired and are now maintained only in a GIS. The utility names and CCN numbers represented in this CCN spatial dataset are also represented in the Water Utilities Database (WUD) as unique data records without a spatial component. Periodic checks are made to compare the utility names entered into the CCN shapefile attribute table to those existing in the WUD database. Comparisons are done by linking the unique CCN number in the attribute table with the CCN ID located in the WUD database. Any non-matching IDs are researched and corrected. The utility names located in the CCN shapefile may be shortened or abbreviated, since shape file field names have size limitations unlike the WUD database. Thus, the utility name provided in the CCN attribute table may not exactly match the utility name provided in the WUD database. However, the CCN number provided in the shapefile attribute table should match the CCN ID found in the WUD database. CCN service area polygons and facility lines are created and updated using the Texas Department of Transportation (TxDOT) digital county urban road series for base maps. The TxDOT county urban road files were digitized from USGS 7.5 minute quadrangles. Updates to the TxDOT urban county files are made from highway construction plans, aerial photographs, official city maps and field inventory data. City limit lines and new roads are updated prior to a map sheet being published. The Railroads may be displaced laterally as much as 200 feet from their true position when they parallel to roads or located in congested areas. The hydrology has been generalized except for the lakes that have been digitized at the mean pool elevation as described on the USGS 7.5 minute quadrangles. All line work is done at a 1" = 1/4 mile or 1320 ft scale. TxDOT estimates that the positional accuracy of most features on their Urban county road files are approximately plus or minus 50 feet (or 15 meters). CCNs are created either by on-screen digitizing, heads-down digitizing from hard copy maps or by digital files submitted by the utility. Boundary adjustments are made based on TCEQ rules and CCN Mapping requirements. Texas Water Commission Texas Natural Resource Conservation Commission 1986 Unknown Water CCN Service Areas Mylar map Beginning Date: 1986 Ending Date: Unknown 63360 stable-base material 1986 unknown unknown unknown ground condition CCN on TxDOT County Mylars Before it merged with the Air Control Board to form the TCEQ, the Texas Water Commission maintained the CCNs. Most all CCNs were drawn on TxDOT County mylar maps at a scale of 1" = 1 mile, some due to the size of the county were drawn at 1" = 2 miles. The CCNs were originally drawn and maintained on the TxDOT county mylar maps. All new and modified CCNs were changed on the mylar map. Phase I of the project involved converting the hard copy maps to digital form. Through a contract with Texas Natural Resources Information System (TNRIS), the maps were digitized off of the mylar maps and georeferenced using the TxDOT Urban Map files. withheld 11-01-1998 UNKNOWN withheld Tracy Harbour Texas Commission on Environmental Quality CCN MAPPING mailing address
MC-153
P.O. Box 13087
Austin TX 78711-3087 512-239-6952 512-239-6972 tracy.harbour@tceq.texas.gov M-F 9-6 PM If you have any questions about the CCN metadata, you may contact Tracy Harbour by E-mail at: tracy.harbour@tceq.texas.gov. ArcView 3.2 Phase II: This is the current phase of the project. There are two processes taking place simultaneously in this phase: 1) TCEQ must check and verify the accuracy of the CCNs that were digitized in Phase I, and 2) new CCNs and CCN amendments must be kept up-to-date in the layer. 1) Check and verify digitized CCN: All CCNs are being corrected using TxDOT Urban road files and the TxDOT Countyboundary layer for the base map. The CCNs are visually inspected on-screen and compared to the CCNs on the mylar maps. CCNs are created and updated using on-screen digitizing methods, coordinate geography (when the information is available), imported digital files (when files are available) and heads-down digitizing when needed. TCEQ is requesting that any maps submitted with the CCN application also be submitted digitally if the data is available. For more for more information, please refer to this page: http://www.tceq.state.tx.us/permitting/water_supply/ud/publist.html The Utility Financial Review Team is working county by county, checking the CCNs in each county and making sure all information is up-to-date. Once a county has been checked and updated, the mylar is retired. When a mylar is retired all subsequent additions of CCNs and changes to CCNs within that county are made using the GIS. 2) On-going layer maintenance: At this time there are three methods for adding a CCN service area to the layer: a) digitizing, b) metes and bounds, and c) digital file. TxDOT Urban Map files are used as the base map. New CCNs and CCN amendments are checked for overlaps with existing CCNs and Districts that also provide water and sewer services. If there is an overlap, the boundary will be modified to avoid the overlap. a) Digitized CCNs: These CCNs are digitized on-screen using the map(s) and boundary description submitted by the applicant. b) Metes and Bounds: If the application includes a map with bearings and distances and/or field notes, then this information is used to create the CCN service area. The service area is referenced using the geographic features on the base map. c) Digital Files: If a diskette or CD containing a digital file of the CCN service area is included with the application, the file can then be reprojected (if needed) and imported directly into CCN layer. Applicants are encouraged to submit a digital file of their requested service area so that it will be more accurately represented in the CCN layer and to speed up the application process. For more information, please refer to this page: http://www.tceq.state.tx.us/permitting/water_supply/ud/publist.html withheld Complete withheld Suzanne Jaster TCEQ Senior Cartographer 512-239-6950 512-239-6972 suzanne.jaster@tceq.texas.gov M-F 8 AM - 4:30 PM ArcView 3.2a Metadata imported. 20121207 17195900 Tracy Harbour TCEQ Project Manager for Water Utilities Map Viewer 512-239-6952 tracy.harbour@tceq.texas.gov M-F 9 AM - 6 PM ArcGIS 9.3.1 withheld Vector Simple FALSE 0 TRUE FALSE North American Datum of 1983 Geodetic Reference System 80 6378137.000000 298.257222 GCS_North_American_1983 TSMS 1.000000 Explicit elevation coordinate included with horizontal coordinates ccn_w WATER CCN SERVICE AREAS Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. UPDATED This date field indicates the most recent date the CCN attributes were changed for any field within each record. ESRI Coordinates defining the features. UPDATED Date 8 0 0 Shape Feature geometry. ESRI Coordinates defining the features. Shape Geometry 4 0 0 CCN The five-digit alphanumeric field contains a unique number assigned to each CCN when it is created and approved by the Commission. ESRI Sequential unique whole numbers that are automatically generated. As needed CCN String 5 0 0 UTILITY An alphanumeric field containing the name of the utility which owns the CCN ESRI Sequential unique whole numbers that are automatically generated. As needed UTILITY String 30 0 0 TYPE This numeric field indicates whether a CCN is considered a water or sewer system. If the CCN number begins with a "1", the CCN is considered a water system (utility). If a CCN number begins with a "2", this CCN is considered a sewer system. ESRI Sequential unique whole numbers that are automatically generated. As needed TYPE SmallInteger 2 5 0 TX_CNTY This three-character alphanumeric field, which contains the Texas county code as assigned to the Texas county by the Texas Department of Transportation (TXDOT). This code represents the county which completely contains the CCN. If the CCN crosses county lines, then an "M" is used to indicate multiple counties. The individual counties can be obtained by linking to the WUD database or doing a query on the CCN spatial dataset. ESRI Sequential unique whole numbers that are automatically generated. As needed TX_CNTY String 3 0 0 Shape_Leng Shape_Leng Double 8 38 8 Shape.STArea() Shape.STArea() Double 0 0 0 Shape.STLength() Shape.STLength() Double 0 0 0 Sequential unique whole numbers that are automatically generated. SHAPE.AREA SHAPE.LEN TCEQ/Water Supply Division /Utilities & Districts Section Tracy Harbour or Suzanne Jaster CCN Mapping Staff mailing address
MC-153
P.O. BOX 13087
Austin TX 78711-3087 512-239-4691 512-239-6972 utildist@tceq.texas.gov M-F 8 AM - 5 PM Please E-mail your questions or comments to CCN Mapping staff at: utildist@tceq.texas.gov Downloadable Data Although this CCN spatial dataset has been processed successfully on a computer system using Geographic Information System (GIS) software at the TCEQ, no warranty expressed or implied is made by the TCEQ regarding the use of the spatial data on any other system, nor shall the act of distribution constitute any such warranty. 6.064 http://gis3.tceq.state.tx.us/iWudSpatialEx/Controller/?ccn=&zipCode= May access CCN spatial data from the Water Utilities Map Viewer located at the URL listed above. 20121203 unknown Tracy Harbour TCEQ WSD Project Manager for Water Utilities Map Viewer mailing address
MC-153
P.O. Box 13087
Austin TX 78711-3087 physical address
12100 Park 35 Circle
Bldg. F
Austin TX 78753 512-239-6952 512-239-6972 tracy.harbour@tceq.texas.gov M-F; 9 AM-6 PM If you have any questions about the CCN metadata, you may contact Tracy Harbour by E-mail at: tracy.harbour@tceq.texas.gov FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 local time http://www.esri.com/metadata/esriprof80.html ESRI Metadata Profile en 20251016 13490300 FALSE 20171024 08091400 20171024 08091400 CWAX.DBO.PUC_CCN_Water 002 372962.940700 1610457.125500 412819.562500 1585476.125000 1 0.000 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.5'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1968500.0],PARAMETER[&quot;False_Northing&quot;,6561666.666666666],PARAMETER[&quot;Central_Meridian&quot;,-98.5],PARAMETER[&quot;Standard_Parallel_1&quot;,32.13333333333333],PARAMETER[&quot;Standard_Parallel_2&quot;,33.96666666666667],PARAMETER[&quot;Latitude_Of_Origin&quot;,31.66666666666667],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2276]]</WKT><XOrigin>-123407700</XOrigin><YOrigin>-86123500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102738</WKID><LatestWKID>2276</LatestWKID></ProjectedCoordinateSystem> NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet 1.0 XTools Pro Metadata Version 6.2 (Build 9200) ; Esri ArcGIS 10.5.1.7333 CWAX.DBO.PUC_CCN_Water 372962.9407 1610457.1255 1585476.125 412819.5625 1 -106.970064 -93.213768 36.448875 25.705574 1 1 -106.970064 -93.213768 36.448875 25.705574 ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset 002 withheld Local Area Network File Geodatabase Feature Class Feature Class 0.000 TSMS EPSG 5.3(9.0.0) 0 20171024