Name: Oakland Sanitary Sewer 2024

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This feature class is comprised of polyline features representing the City of Oakland's Sanitary Sewer Pipes system. The current iteration of this layer has been created from GISADMIN.SanitarySewerPipesMaster and is updated nightly through CityWorks, and monthly via edits made by a GIS editor. It acts a source of data for CityWorks, GraniteXP, and InfoMaster. The following fields will be populated nightly using CItyWorks data and will not be manually edited by the GIS editor/Users;REHABDATE WARRANTYDATESSOCIWQSSSO_EVENTSSO_DATESSO_CAUSESSO_CATEGORYSSO_2IN3_YEARSHIGH_FREQSPOT_REPAIRSPOTREPAIR_DATEROOTS_FOUNDROOTS_OBSERVATIONROOTS_DATEROOTFOAMROOT_FOAM_DATECLEANEDDATCLEANEDTELEVISEDTELEVISEDD

Copyright Text: Wastewater Engineering Management Division | Bureau of Design and Construction City of Oakland | Oakland Public Works Department | GIS Information Technologoy Department (ITD)

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6032056.26475625
YMin: 2091006.76908758
XMax: 6094336.60836625
YMax: 2143518.2595685
Spatial Reference: 102643 (2227)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[47,144,168,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• GXP_ID (type: esriFieldTypeString, alias: GXP ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• UPGXP_ID (type: esriFieldTypeString, alias: Upstream GXP ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DOWNGXP_ID (type: esriFieldTypeString, alias: Downstream GXP ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LOCALITY (type: esriFieldTypeString, alias: Locality, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CR_STREET1 (type: esriFieldTypeString, alias: First cross street, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CR_STREET2 (type: esriFieldTypeString, alias: Second cross Street, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BLOCK_NO (type: esriFieldTypeDouble, alias: Block Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EASEMENT (type: esriFieldTypeDouble, alias: Easement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GRID (type: esriFieldTypeDouble, alias: Grid Number , SQL Type: sqlTypeOther, nullable: true, editable: true)
• ITA (type: esriFieldTypeString, alias: ITA, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SUBBASIN (type: esriFieldTypeString, alias: Sub-basin, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UPNODE (type: esriFieldTypeString, alias: Up stream structure, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• UP_RIM_ELEV (type: esriFieldTypeDouble, alias: Up Rim Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNNODE (type: esriFieldTypeString, alias: Downstream structure, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• DOWN_RIM_ELEV (type: esriFieldTypeDouble, alias: Down rim elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Year installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ABANDONDATE (type: esriFieldTypeDate, alias: Date abandoned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Pipe Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPE_DIMENSION (type: esriFieldTypeString, alias: Dimension of pipe, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PIPE_SHAPE (type: esriFieldTypeString, alias: Shape of the pipe, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [C: Circular], [E: Egg Shaped], [H: Horseshoe], ... 6 more ...)
• CAPACITY (type: esriFieldTypeDouble, alias: Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: Pipe Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Main: Main], [Abandoned: Abandoned], [ForceMain: Force Main], ... 6 more ...)
• MATERIAL (type: esriFieldTypeString, alias: NASSCO pipe material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AC: Asbestos cement], [BR: Brick], [CAS: Cast iron], ... 23 more ...)
• MATERIAL_HOST (type: esriFieldTypeString, alias: Pipe material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [VCP: Vitrified Clay Pipe], [CI: Cast Iron], [DIP: Ductile Iron Pipe], ... 11 more ...)
• MATERIAL_LINED (type: esriFieldTypeString, alias: Rehab material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CIPP: Cured In Place Pipe], [VCP: Vitrified Clay Pipe], [HDPE SDR 17: High Density PolyEthylene SDR 17], ... 3 more ...)
• UP_INVERT_ELEV (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWN_INVERT_ELEV (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LENGTH (type: esriFieldTypeDouble, alias: Pipe Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REHABMETHOD (type: esriFieldTypeString, alias: Rehab Method, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [RH1-CIPP: RH1-CIPP], [RH2-Pipe Expanding: RH2-Pipe Expanding], [RH3-Open Trench: RH3-Open Trench], ... 3 more ...)
• REHABSTATUS (type: esriFieldTypeString, alias: Rehab Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Design: Design], [Construction: Construction], [Completed: Completed])
• REHABDATE (type: esriFieldTypeDate, alias: Rehab Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WARRANTYDATE (type: esriFieldTypeDate, alias: Warranty Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROJECT (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• EDITED_SOURCE (type: esriFieldTypeString, alias: Source of edit, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• EDITEDBY (type: esriFieldTypeString, alias: Edited by, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• EDITEDDATE (type: esriFieldTypeDate, alias: Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REHAB_FY (type: esriFieldTypeString, alias: Fiscal year of rehab, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [2015-16: 2015-16], [2016-17: 2016-17], [2017-18: 2017-18], ... 14 more ...)
• PROPOSED_REHAB_REASON (type: esriFieldTypeDouble, alias: Proposed rehab reason, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROPOSEDREHABFY (type: esriFieldTypeString, alias: Proposed Rehab Fiscal Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2015-16: 2015-16], [2016-17: 2016-17], [2017-18: 2017-18], ... 14 more ...)
• PROPOSED_PROJECT (type: esriFieldTypeString, alias: Proposed project, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• FLOW_SUMMARY (type: esriFieldTypeDouble, alias: Flow summary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FLOW_TYPE (type: esriFieldTypeString, alias: Flow type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RELIEF (type: esriFieldTypeString, alias: Relief, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CONDITIONDATE (type: esriFieldTypeDate, alias: CONDITIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SSOCIWQS (type: esriFieldTypeInteger, alias: SSOCIWQS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SSO_EVENT (type: esriFieldTypeString, alias: SSO Event, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SSO_DATE (type: esriFieldTypeDate, alias: Date of SSO, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SSO_CAUSE (type: esriFieldTypeString, alias: Cause of SSO, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• SSO_CATEGORY (type: esriFieldTypeString, alias: SSO_CATEGORY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HIGH_FREQ (type: esriFieldTypeString, alias: High Frequency, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SSO_2IN3_YEARS (type: esriFieldTypeString, alias: SSO 2 in 3 Years, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPOT_REPAIR (type: esriFieldTypeString, alias: Spot repair, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPOTREPAIR_DATE (type: esriFieldTypeDate, alias: Date of spot repair, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CLEANED (type: esriFieldTypeString, alias: Is pipe cleaned, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CLEANEDDAT (type: esriFieldTypeDate, alias: Date of cleaning, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CLEAN_TYPE (type: esriFieldTypeString, alias: CLEAN_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Hydro: Hydro], [Hand Rod: Hand Rod], [Power Rod: Power Rod])
• ROOTS_FOUND (type: esriFieldTypeString, alias: Is roots found, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ROOTS_OBSERVATION (type: esriFieldTypeInteger, alias: Roots observation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROOTS_DATE (type: esriFieldTypeDate, alias: Date roots found, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROOTFOAM (type: esriFieldTypeString, alias: Root Foam, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROOT_FOAM_DATE (type: esriFieldTypeDate, alias: Root foam treatment date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROOTFOAM_PROPOSED_FY (type: esriFieldTypeString, alias: Root foaming proposed FY, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [2015-16: 2015-16], [2016-17: 2016-17], [2017-18: 2017-18], ... 14 more ...)
• ROOT_FOAM_FY (type: esriFieldTypeString, alias: Root foam fiscal year, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [2015-16: 2015-16], [2016-17: 2016-17], [2017-18: 2017-18], ... 14 more ...)
• TELEVISED (type: esriFieldTypeString, alias: Televised, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TELEVISEDD (type: esriFieldTypeDate, alias: Televised Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LATERAL_QUANTITY (type: esriFieldTypeDouble, alias: Number of PSL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: Created date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATED_USER (type: esriFieldTypeString, alias: Created user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LINK1 (type: esriFieldTypeString, alias: Link 1, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LINK2 (type: esriFieldTypeString, alias: Link 2, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• FUTURETEXT (type: esriFieldTypeString, alias: Future Text, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FUTUREDATE (type: esriFieldTypeDate, alias: Future Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FUTUREDOUBLE (type: esriFieldTypeDouble, alias: Future Double, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Oakland Sanitary Sewer 2024
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• PIPE_SHAPE: C

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/1/2024 10:50:42 PM

Schema Last Edit Date: 10/1/2024 10:50:42 PM

Data Last Edit Date: 8/14/2024 11:32:37 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat