The URL can be used to link to this page

Home My WebLink About; ; SEWER GIS SUBMITTAL; 2003-02-01C C C .. I .. .. .. I,., ... .. .. .. .. .. .. .. Ill CITY OF CARLSBAD SEWER GIS SUBMITTAL Prepared For: City of Carlsbad 1635 Faraday Avenue Carlsbad, California 92008 Prepared By: DUDEK & ASSOCIATES, INC . 605 Third Street Encinitas, CA 92024 TEL (760) 942-5147 February 2003 r .. C C C C C C ... "" lo, .. .. SEWER GIS SUBMITTAL The Scope of Work for the City of Carlsbad Water and Sewer Master Plan Updates dated October 31, 2001 includes a task for Dudek and Associates, Inc. to develop a Geographical Information System (GIS) for the City of Carlsbad sewer system. A hydraulic model of the sewer interceptor system was created from the sewer system GIS and used in the hydraulic analysis performed as part of the 2003 Sewer Master Plan Update. This separate submittal documents the GIS development process and includes an attributed shape file of the completed sewer system GIS on the included compact disk. 1.1 PROJECT DEFINITION A sewer system GIS for the City of Carlsbad was prepared based on information obtained from available construction and as-built drawings. Per the project scope, information was input based on drawings dated up to December 31, 2001 and including the 2001-2002 Vista/Carlsbad Sewer Replacement Project. An additional services contract included a task to add pipelines in the Sand Shell Lift Station service area based on 2002 drawings. 1.2 DATA COLLECTION Construction drawings were located for gravity pipelines, siphons and forcemains using the City's data management system (DMS) and searching through drawing files at the City offices. Signed as-built drawings were used. If as-built drawings could not be located, the most recent signed construction drawings were used. An extensive joint effort by Dudek and City of Carlsbad staff was required to locate many of the drawings. Several drawings were ultimately located at the Carlsbad Municipal Water District offices and Encina WPCF lift station sites (force main drawings). Construction drawings could not be located for several areas of the system, primarily in the older "village" area of Carlsbad. At the direction of City Staff, information for pipelines in these areas was input based on data provided in the City's existing sewer atlas book. For pipelines and manholes with data collected from the Sewer Atlas Books, only available data was entered. Therefore, attribute data will be missing for some fields. 1.3 GIS DAT A FIELDS Physical data was collected and input for pipelines and manholes. Several meetings were held with City Staff to determine the required fields and data format. The following table summarizes the GIS data fields. City of Carlsbad SEWER SYSTEM GIS Dudek & Associates, Inc. February 2003 ... ~ ... ~ CARLSBAD SEWER GIS DAT A FIELDS '"' ii. Data Field Name Units Field Type Comments C PIPELINE INFORMATION: C ID no. Pipe_ID Number Unique number assigned to each section of pipe MHUpstream MH_Up Number Manhole ID on upstream section of pipe MH Downstream MH Dn Number Manhole ID on downstream section of ~ pipe i. IE Upstream IE_Up ft Number Elevation where pipe exits upstream manhole; at center or edge ofMH, C depending what is shown on sewer profile IE Downstream IE Dn ft Number Elevation where pipe enters downstream manhole; at center or edge C ofMH, depending what is shown on sewer profile Ground Elev. Up Gmd_Up ft Number Rim elevation of manhole upstream; C estimated to the nearest+/-0.5' if not labeled on profile Ground Elev. Down Gmd Dn ft Number Rim elevation of manhole downstream; estimated to the nearest+/-0.5' ifnot ... labeled on profile ii. Station Up STA UP Number Included on Interceptor Systems only: Station information from Improvement C Plans Station Down STA DN Number Included on Interceptor Systems only: Station information from Improvement Plans ... Distribution Type DistrType String Designate as Interceptor or Collector ~ pipeline Interceptor System INT SYS String Designate V/C, NAH, Vallecitos, ... Buena, NB or Leucadia as downstream interceptor ~ Type LineType String Type of pipeline (gravity, forcemain or siphon) ... Diameter Diam inches Number Pipeline diameter shown on plans ' Reach Length Length ft Number Length of pipe section from center line ~ of MHs; determined from stationing data or callout on sewer profile ... ~ Slope Slope Number Slope of pipe section. Calculated field (IE_ Up -IE_ Dn)/Length Material PipeType String Standard material abbreviations* ... Survey Information SURV_IN String Survey Information from plans ~ indicating direction ofline, or radius and delta of curve As Built Date BuiltDate Date Latest "As-Built" stamped date on the ... title page or revision box ' i. Signature Date SignDate Date Included only if there is no As-Built data; latest signed date ~ City of Carlsbad Dudek & Associates, Inc. '"' SEWER SYSTEM GIS 2 February 2003 .. "" .. C "" .. r ... C C C ,.. I.. ( C C CARLSBAD SEWER GIS DATA FIELDS (continued) Data Field Name Units PIPELINE INFORMATION (continued) Street Segment Eng_ID CMWDNo . CMWDNO Project No. ProjNo Drawing No. DwgNo Sheet No. SheetNo Easement Info EASMNT Atlas Sheet No. Map_Key Notes Notes MANHOLE INFORMATION: Manhole ID Interceptor System Manhole Type Manhole Diameter Invert Elevation In Invert Elevation Center Invert Elevation Out Rim Elevation City of Carlsbad SEWER SYSTEM GIS MH ID INT SYS MH TYPE MH DIAM IE IN IE_CEN IE_OUT RIME ft ft ft ft ft Field Type Comments Number Street within 50' of Pipe Segment (populated from in intersection with the street centerline files provided by Carlsbad); Blank if Segment contains Easement information String Carlsbad Municipal Water District project Number; Provided if shown on plans String Project number of plans String Drawing number of plans String Sheet number in the plans String Easement width obtained from plans String Sheet in Sewer Atlas book (populated from an intersection with the Carlsbad atlas sheet index file) String Lists any relevant information to the sewer line, Data obtained from Sewer Atlas Books marked as "ATLAS" in Notes field. Number Unique number assigned to each mahole. Used for Topology creation String Designate V /C, NAH, Vallecitos, Buena, NB or Leucadia as downstream interceptor String Type of Manhole -Standard; Drop; Special; MH is identified as a Drop MH if the I.E.s from connecting pipelines differ by more than 3 feet. Number Inside Diameter at Base ofMH; determined from profile info or standard drawing reference Number Invert Elevation of Pipe entering manhole. Value of999 entered if no upstream pipe exists. Number Calculated field (IE_ Up+ IE_ Dn)/2 unless MH _ Type is "Drop". For dropped MHs, IE_ CEN ~ IE_ Out Number Lowest Invert Elevation of pipe leaving manhole. Value of999 entered ifno downstream pipe exists. Number Elevation at Top of Manhole; estimated to the nearest+/-0.5' ifnot labeled on profile. Dudek & Associates, Inc. 3 February 2003 ,. .. C C C ,. ' ii. C C C C CARLSBAD SEWER GIS DATA FIELDS (continued) Data Field Name Units Field Type Comments MANHOLE INFORMATION (continued) Depth DEPTH Atlas Page MAP KEY As-Built Date BUILTDATE Signature Date SIGNDATE ft Number String date Date date Date Calculated field (RIME -IE_ OUT); accurate to the nearest+/-0.5'. Value of999 entered if Rim Elevation~ 0. Sheet in Sewer Atlas book (populated from an intersection with the Carlsbad atlas sheet index file) Latest "As-Built" stamped date on the title page or revision box Included only if there is no As-Built data; latest signed date Street Segment ID ENG ID Number Street within 50' of Pipe Segment (populated from in intersection with the street centerline files provided by Carlsbad); Blank if Segment contains Easement information CMWDNumber CMWDNO Project Number PROJNO Drawing Number DWGNO Sheet Number SHEETNO Notes Notes String String String String String Carlsbad Municipal Water District project number; Provided if shown on plans Project Number from Improvement Plans Drawing Number from Improvement Plans Sheet Number from Improvement Plans Lists any relevant information to the sewer line, Data obtained from Sewer Atlas Books marked as "ATLAS" in Notes field. * Material abbreviations used in the "PipeType" field: ACP CIP CIBJ CIMJ CMLC DIP ESVCP Hobas HDPE PVC RCP T-Lock VCES VCP City of Carlsbad SEWER SYSTEM GIS Asbestos Cement Pipe, Transite Cast in Place Cast Iron Bell Joint Cast Iron Mechanical Joint Concrete Mortar Lined Coated Steel Ductile Iron Pipe Extra Strength Vitrified Clay Pipe Trade name for centrifugally cast fiberglass reinforced plastic mortar (CCFRPM) pipe High Density Polyethylene Polyvinyl Chloride Reinforced Concrete Pipe Trade name for PVC liner used with RCP pipe Vitrified Clay Extra Strength Vitrified Clay Pipe 4 Dudek & Associates, Inc. February 2003 C C C C C C C C ,. L. C C 1.4 DATA QUALITY CHECKS GIS fields were populated by either manually entering data into a GIS database (i.e. elevations, diameters, drawing numbers, etc.), deriving data from database calculations (ie. pipeline slope, MH invert center elevation) or performing intersections with other data files (i.e. street segment name, atlas book page, etc). For data fields that were manually input, default values were used and set where appropriate to minimize input errors. A series of quality checks were also performed to identify and correct input errors. The QA/QC performed on the GIS fields include the following data input checks: -Check for unique Pipe_ID, and Manhole ID. -Check for empty Fields in Manhole Type, Manhole Diameter, DistrType, INT_ SYS, LineType, Pipe Diameter, Length, Slope, Pipe Type, Sheet No, and MapKey fields. -Check to make sure that all dates in the BuiltDate and SignDate fields are in the correct format. -Check for consistency in the DistrType Field, as far as capitalization and naming conventions. Also check for naming conventions in the Interceptor System fields and LineType fields. -Check for consistency in Manhole Type field. -Check for RIME of Manhole Less than IE CEN. -Check for IE OUT of Manhole Greater than IE IN. -- -Check for extreme values in DEPTH of Manhole. -Check for IE_DN of Pipeline Greaterthan IE_ UP. -Check for negative numbers in Slope field. -Auto calculation for Drop Manhole designation. If difference between IE_ UP and IE_ DN is greater than specified amount, Manhole Type will be changed to Drop. -Check for non-standard values in Pipe Length field. -Check for non-standard values in Pipe Diameter, Invert and Ground Elevation Fields. 1.5 FINAL PRODUCT The City of Carlsbad Sewer GIS is provided on the attached CD and illustrated on the included exhibit. The exhibit indicates which pipelines in the sewer GIS have information collected from record drawings, and which pipelines have information obtained from the City Sewer Atlas. The CD also includes the exhibit image file, and a Microsoft Word file of this document. The sewer GIS consists of two ESRI shapefiles. One shapefile contains pipeline facilities, and the other contains manholes. These files are compatible with ESRI's ArcGIS 8.x suite of GIS software. They may also be imported for use in AutoCad. The files are in the State Plane Coordinate System: NAD 83, California Zone 6, US Feet. City of Carlsbad SEWER SYSTEM GIS 5 Dudek & Associates, Inc. February 2003 I ' ' N 1,500 0 1,500 1" = 1500' Legend □ SE\/1/ER SERVICE AREA [ 7 PARCELS 0 LIFT STATIONS BUENA VISTA LIFT STATION 3,000 -GRAVITY SE\/1/ER · INFO FROM CONSTRUCTION DRAWINGS -GRAVITY SE\/1/ER · INFO FROM CITY ATLAS BOOKS -FORCEMAIN l._I __ _ J ---- CITY OF CARLSBAD # KELLY;RANCH LIFT TATION / \ ( ) ' \ \ \ \ ' \ \ \ I \ I \\ \\ I ' \\ \\ ' ,··'1 '' \) I ---; I I CITY OF CARLSBAD SEWER GIS ! ' / l I I I r· ( J I I \ I _./ )I , ,..-·l '-'\ I I /j \ C: ...L -· POINSETTIA LI_ET STATION ,. \ / " ~ /-I , ' ' I 1. I ' ' \I ) \ ' i \-\ \ \ I ' \ ·,. \\ -\J. I I I \ I i \ I I \ DUDEK & ASSOCIATES, INC. l'ro(~,1onc1! 'nmn1 fo• Complex PmJ~u& 00.-2003 030211-GISChecksetmxd