CACHE LA POUDRE SOURCE WATER ASSESSMENT EPA NATIONAL PILOT WITH CDPH&E CENTER FOR COMMUNITY DEVELOPMENT AND DESIGN AUDIENCE =========== General public with no previous technical understanding Engineers Politicians Other SWA planners across the country DESIGN GOALS =========== Base Map [Letter-portrait & Web-ready JPEG] [Scale of approximately 1:250000] [Full color] Hillshaded DEM - Relief Map Roads Minor Roads Highways Interstates Mountain Peaks Lakes Rivers High-order only States Counties Cities Watershed possibly merged from USGS, FCU, and ARNF [Keep data for entire USGS Hydro Unit area - possible future use] Area of Interest Map [Letter-landscape & Web-ready JPEG] [Scale of approximately 1:250000] ?[Full color] States Roads Highways Interstates Cities Major only Lakes Rivers Very high-order only When seeking data always try to find coverages that extend over your entire area of interest and have come from a consistant source. Whenever possible, collect the highest detail format of the data available and use the internal coding to scale down as needed. Never blindly trust feature coding (i.e., Tiger/Line CFCC coding etc) as much data originally comes from many sources. DATA SOURCES AND MANIPULATION ================ Obtained FCU Watershed Boudaries (faxed coordinate path) from Fort Collins Utilities Ben Alexander - used Delorme Mapping software to create with his understanding of the area Enterred coordinates (Excel spreadsheet) ?Plotted coordinates using ArcView (line shapefile) (as several linear segments circumscribing the watershed) ?Manually cleaned up data entry errors ?Imported and projected into UTM 13 using SHAPEARC and PROJECT Obtained FCU Watershed N-S Division (faxed coordinate path) from Fort Collins Utilities Ben Alexander - used Delorme Mapping software to create with his understanding of the area Enterred coordinates (Excel spreadsheet) ?Plotted coordinates using ArcView (line shapefile) ?Manually cleaned up data entry errors ?Imported and projected into UTM 13 using SHAPEARC and PROJECT Appended Watershed Boudaries with N-S Division Manually cleaned up original anomalies (i.e., precisely connected each segment) Built Watershed (poly coverage) with N and S regions ?Obtained Hydrologic Units from USGS ?Selected out and saved the Unit of interest (poly shapefile) using ArcView ?Imported and projected into UTM 13 using SHAPEARC and PROJECT Merged Watershed with Hydrologic Unit using UNION Identified the transbasin diversions using the difference Followed the Watershed's western boundary half for its additional accuracy Saved resulting six regions as Watershed (Merged version) (poly shapefile) Obtained 1-degree Digital Elevation Map (DEM) from USGS Imported (grid/lattice) using DEMLATTICE Merged them (six adjacent areas) together using LATTICEMERGE Projected into UTM 13 - NAR_C method THREE (ie., NAD83) using PROJECT GRID Clipped down using LATTICECLIP Computed Hillshade using ArcView Combined to make relief image using ArcView Obtained Source Water Intakes (emailed coordinates) from Fort Collins Utility CAUTION: High Security Data - display only low accuracy (big) markers!!! Obtained Roads (line shapeFiles) for each state from ESRI Data CDs Colorado Wyoming Imported and projected each into UTM 13 using SHAPEARC and PROJECT Appended them together using APPEND Clipped them down using CLIP AOI = (448599.25,4574085.5) - (542777.75,4456429) in UTM 13 (Slightly broader than earlier) Selected out and saved Interstates (line shapefile) Obtained States (poly shapefile) from ESRI Data CDs Selected out and saved nearby states (poly shapefile) to reduce file size Imported and projected into UTM 13 using SHAPEARC and PROJECT Obtained Counties (poly shapefile) from ESRI Data CDs Selected out and saved nearby counties (poly shapefile) to reduce file size (for project location map) Imported and projected into UTM 13 using SHAPEARC and PROJECT Converted to a grid using ArcView Obtained Cites (points) from ESRI Data CDs Imported and projected into UTM 13 using SHAPEARC and PROJECT Obtained Populated Places from ESRI Data CDs Imported and projected into UTM 13 using SHAPEARC and PROJECT Obtained Mountain Summits from ESRI Data CDs Imported and projected into UTM 13 using SHAPEARC and PROJECT Obtained detailed Major Water features from ESRI Data CDs Imported and projected into UTM 13 using SHAPEARC and PROJECT FAILED TO BUILD Obtained general Lakes from ESRI Data CDs Imported and projected into UTM 13 using SHAPEARC and PROJECT FAILED TO BUILD Obtained Hydrological linear features (rivers) from EPA Region 8 web site. Imported and projected them into UTM 13 using IMPORT and PROJECT (Not given a original datum so no change) Found that features were shifted (like datum error) Obtained TIGER/Line 97 files for each county within AOI 08069 Larimer, CO 08057 Jackson, CO 08123 Weld, CO 08049 Grand, CO 56021 Laramie, WY 56001 Albany, WY Imported and projected each into UTM 13 using TIGERTOOL Appended them together using APPEND (only the line features which include rivers, roads, etc.) Clipped Tiger line features using CLIP Note: Found that Tiger/97 features (e.g., linear hydrology) were poorly coded. Some areas had notably lower order features displayed and/or coded with higher order features. This seemed to be less of an issue at the higher orders. Extracted Tiger line features having CFCC = "H*" (Rivers, Creeks, Ditches, etc) Saved as a ShapeFile Selected out notable river, creek, and canal features (CFCC="H11", fename="*River" or "*Creek", and others from inspection) Corrected some data errors regarding H11 coding - manually. Selected out major (high-order) rivers by comparison with 1:2M Scale Hydrology features (manually) Resulting file has added the field, Order 1 Low order 2 Mid order (notable) 3 High order (major) Cleaned Tiger line hydro boundaries (CFCC="H01" or "H02") Obtained Hydrologic Unit Coverage (HUC) from State GIS Resource Website 10 14 Projected them into UTM 13 using PROJECT Rebuilt polygon coverage using BUILD Selected out the HUCs that made up enough of the east side of the Continental Divide to extend beyond the map as a Shape File Merged them into a second Shape File Imported into ArcInfo (line) using SHAPEARC Converted back into Shape File (line) Manually editted to delete extra boundaries leaving just the Continental Divide Note: Dr. Monero's files (and contract area) were clipped slightly within Ben's watershed boundary! Rebuilt. TO BE DONE =============== as of 8/23/99 STORET - does modernized ver include historical? GIS? Want Class A, B, C contaminants only. STORET - needs software to convert, right? Email Matt for UST and leaking ST data. Find Businesses (Gas Stations, Airports, Shops, etc) <- BusinessMap PRO IN PROGRESS - Talk to Dennis Dean - data consortium Talk to Troy @ Eco Search - quote for watershed - want's a map of area for quote Forest service PSOC data (maint sheds, camp sites, etc) Make a land cover map from BASINS data Add Managed Lands theme to Political Map Tweek basemap issues Add places and railroads to all maps (basemap) Make a land use map from Kunis' data (Also talk to Kunis for rural subdivisions - septics) Make a zoning map from Kunis' data Make a water quality (monitoring?) sites map from BASINS data BASE MAP Clean up workspace - organize directories, remove old work, relink in map views Backup to ZIP / tape [When plotting hard copy in lab] create extra page margin to avoid clipping [When plotting hard copy in lab] play with different color schemes and corrections (paper=Opaque Bond) DELAYED-Reconstruct Continental Divide to follow Watershed (at smaller scale) [major undertaking] DELAYED-Smaller Legend typeface (Can't be done using live linked legend!) NO(Another map)-Label and delineate the transbasin diversions - Seperate colored areas NO(Another map)-Add State and County Name Labels (important) NO(Another map)-Can't see county boundary under Watershed Make JPEG page margins consistant (using Photoshop) Drop data box for web version Add SWAP logo to data box Reformat legend titles Add Managed Lands boundaries to Political Map Consider moving markers outside the SWAA Consider using markers for County Hwys Add railroads (clearly) DONE- Put big dots on Fort Collins and Greeley intake and add to legend (for point of reference) DONE- Matched populated places to Yahoo listed places DONE- Locational Map PILOT RECOMMENDATIONS =========== Always collect data for an area that includes a margin around the proposed delineation. In the national pilot, we found that an adjustment was required to one of the transbasin diversions that required us to recollect and import several sets of data that had been clipped too tightly! Have a cartographer look over maps to ensure that they are easy to use for the general public. Be careful not to create tools that are so technical that only the technicians can understand them! Get more detailed DEMs and River network from same sources used in CGS Mining data sets. Maybe use in concert with lower resolution data at smaller scales. Create a hillshade grid with a hole opening up the SWAA. Lay this over top of other data to avoid having to query out the data of interest each time. Use a buffer and grid to create a boundary that does not obstruct the SWAA but just surrounds it.