Name: SanSewer Manhole

Display Field: lgMH_MHName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SanSewerManhole is a point feature class. The feature class was created before Cartegraph Go Live in November 2019 by Public Works using GPS Trimble units to locate manholes. The SanSewerLegacyManhole feature class, which orginiated in the prod geodatabase under prod.GIS.manholes, was used for spatial reference of the newly geolocated manholes. Adiditionally, atttribute data from SanSewerLegacyManhole was transfered over based on the Cartegraph_ID for all of the new GPS manholes. Abandoned manholes, dead ends, flow splitting, meter station, none, and serlive line under lgMH_ObjectType in SanSewerLegacyManhole were not transferred to this new dataset as they are not needed to preform work against.

Service Item Id: 2287afbf4410489fb752dda871ea1910

Copyright Text: City of Lakewood, Colorado

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 18056

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 3102537.3436115533
YMin: 1668456.8000218123
XMax: 3125531.64440763
YMax: 1700059.9481014758
Spatial Reference: 2877  (2877)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CartID ( type: esriFieldTypeString, alias: Cart ID, length: 15 )
• CoverType ( type: esriFieldTypeString, alias: CoverType, length: 50 , Coded Values: [Bolted: Bolted] , [Gasketed: Gasketed] , [Locking: Locking] , ...2 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [AC: Asbestos Cement (AC)] , [BR: Brick (BR)] , [CAS: Cast Iron (CAS)] , ...21 more... )
• ManholeSize ( type: esriFieldTypeString, alias: ManholeSize, length: 50 )
• SurfaceType ( type: esriFieldTypeString, alias: SurfaceType, length: 50 )
• UseType ( type: esriFieldTypeString, alias: UseType, length: 50 )
• InvertElevation ( type: esriFieldTypeDouble, alias: InvertElevation )
• InvertElevation_unit ( type: esriFieldTypeString, alias: InvertElevation_unit, length: 10 )
• RimtoInvert ( type: esriFieldTypeDouble, alias: RimtoInvert )
• RimtoInvert_unit ( type: esriFieldTypeString, alias: RimtoInvert_unit, length: 10 )
• Retired ( type: esriFieldTypeDate, alias: Retired, length: 8 )
• Replaced ( type: esriFieldTypeDate, alias: Replaced, length: 8 )
• Installed ( type: esriFieldTypeDate, alias: Installed, length: 8 )
• LocatorCity ( type: esriFieldTypeString, alias: LocatorCity, length: 50 )
• LocatorStreet ( type: esriFieldTypeString, alias: LocatorStreet, length: 50 )
• LocatorAddressNumber ( type: esriFieldTypeString, alias: LocatorAddressNumber, length: 15 )
• AddressNumber ( type: esriFieldTypeDouble, alias: AddressNumber )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost )
• ConditionGroup ( type: esriFieldTypeString, alias: ConditionGroup, length: 150 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 35 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 500 )
• EstimatedOCI ( type: esriFieldTypeDouble, alias: EstimatedOCI )
• PredictionGroup ( type: esriFieldTypeString, alias: PredictionGroup, length: 50 )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, length: 500 )
• EstimatedOCR ( type: esriFieldTypeString, alias: EstimatedOCR, length: 50 )
• EstimatedCCR ( type: esriFieldTypeString, alias: EstimatedCCR, length: 50 )
• CriticalityFactor ( type: esriFieldTypeDouble, alias: CriticalityFactor )
• CurrentInspectionID ( type: esriFieldTypeString, alias: CurrentInspectionID, length: 50 )
• EstimatedCCI ( type: esriFieldTypeDouble, alias: EstimatedCCI )
• ActBefore ( type: esriFieldTypeDate, alias: ActBefore, length: 8 )
• County ( type: esriFieldTypeString, alias: County, length: 32 )
• Street ( type: esriFieldTypeString, alias: Street, length: 50 )
• StateValue ( type: esriFieldTypeString, alias: StateValue, length: 50 )
• City ( type: esriFieldTypeString, alias: City, length: 50 )
• CurrentInspectionDate ( type: esriFieldTypeDate, alias: CurrentInspectionDate, length: 8 )
• CurrentInspectionOCI ( type: esriFieldTypeDouble, alias: CurrentInspectionOCI )
• CurrentInspectionOCR ( type: esriFieldTypeString, alias: CurrentInspectionOCR, length: 50 )
• CurrentInspectionNotes ( type: esriFieldTypeString, alias: CurrentInspectionNotes, length: 500 )
• pw_ConeMaterial ( type: esriFieldTypeString, alias: pw_ConeMaterial, length: 50 )
• pw_WallMaterial ( type: esriFieldTypeString, alias: pw_WallMaterial, length: 50 )
• pw_BenchMaterial ( type: esriFieldTypeString, alias: pw_BenchMaterial, length: 50 )
• pw_InvertMaterial ( type: esriFieldTypeString, alias: pw_InvertMaterial, length: 50 )
• pw_Rehabilitated ( type: esriFieldTypeString, alias: pw_Rehabilitated, length: 50 )
• pw_RehabilitationMaterial ( type: esriFieldTypeString, alias: pw_RehabilitationMaterial, length: 50 )
• pw_NearestAddress ( type: esriFieldTypeString, alias: pw_NearestAddress, length: 50 )
• lgMH_ObjectType ( type: esriFieldTypeString, alias: lgMH_ObjectType, length: 24 , Coded Values: [MANHOLE: MANHOLE] , [LAMPHOLE CLEANOUT: LAMPHOLE CLEANOUT] , [DEAD END: DEAD END] , ...6 more... )
• lgMH_MHName ( type: esriFieldTypeString, alias: lgMH_MHName, length: 16 )
• lgMH_MHID ( type: esriFieldTypeDouble, alias: lgMH_MHID )
• lgMH_MHType ( type: esriFieldTypeString, alias: lgMH_MHType, length: 24 , Coded Values: [PRECAST CONCRETE: PRECAST CONCRETE] , [BRICK: BRICK] , [POURED IN PLACE CONCRETE: POURED IN PLACE CONCRETE] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• esrignss_receiver ( type: esriFieldTypeString, alias: esrignss_receiver, length: 50 )
• esrignss_h_rms ( type: esriFieldTypeDouble, alias: esrignss_h_rms )
• esrignss_v_rms ( type: esriFieldTypeDouble, alias: esrignss_v_rms )
• esrignss_latitude ( type: esriFieldTypeDouble, alias: esrignss_latitude )
• esrignss_longitude ( type: esriFieldTypeDouble, alias: esrignss_longitude )
• esrignss_altitude ( type: esriFieldTypeDouble, alias: esrignss_altitude )
• esrignss_pdop ( type: esriFieldTypeDouble, alias: esrignss_pdop )
• esrignss_hdop ( type: esriFieldTypeDouble, alias: esrignss_hdop )
• esrignss_vdop ( type: esriFieldTypeDouble, alias: esrignss_vdop )
• esrignss_fixtype ( type: esriFieldTypeSmallInteger, alias: esrignss_fixtype )
• esrignss_correctionage ( type: esriFieldTypeDouble, alias: esrignss_correctionage )
• esrignss_stationid ( type: esriFieldTypeSmallInteger, alias: esrignss_stationid )
• esrignss_numsats ( type: esriFieldTypeSmallInteger, alias: esrignss_numsats )
• esrignss_avg_h_rms ( type: esriFieldTypeDouble, alias: esrignss_avg_h_rms )
• esrignss_avg_v_rms ( type: esriFieldTypeDouble, alias: esrignss_avg_v_rms )
• esrignss_avg_positions ( type: esriFieldTypeInteger, alias: esrignss_avg_positions )
• esrignss_h_stddev ( type: esriFieldTypeDouble, alias: esrignss_h_stddev )
• esrignss_fixdatetime ( type: esriFieldTypeDate, alias: esrignss_fixdatetime, length: 8 )
• GPS_CGID ( type: esriFieldTypeInteger, alias: GPS_CGID )
• GPS_Notes ( type: esriFieldTypeString, alias: GPS_Notes, length: 255 )
• cgOid ( type: esriFieldTypeString, alias: cgOid, length: 20 )
• cgURL ( type: esriFieldTypeString, alias: cgURL, length: 255 )
• gisURL ( type: esriFieldTypeString, alias: gisURL, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Easement ( type: esriFieldTypeString, alias: Easement, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Bioblocks ( type: esriFieldTypeString, alias: Bioblocks, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• ManholeAccess ( type: esriFieldTypeString, alias: ManholeAccess, length: 255 , Coded Values: [Drop: Drop Exists. Unknown Type] , [Outside Drop: Outside Drop] , [Inside Drop: Inside Drop] , ...1 more... )
• CollarMat ( type: esriFieldTypeString, alias: CollarMat, length: 255 , Coded Values: [Concrete: Concrete] , [Asphalt: Asphalt] , [Asphalt on Concrete: Asphalt on Concrete] , ...1 more... )
• MHDifficultAccess ( type: esriFieldTypeString, alias: MHDifficultAccess, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• MHMissingBuried ( type: esriFieldTypeString, alias: MHMissingBuried, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• MVMScanStatus ( type: esriFieldTypeString, alias: MVMScanStatus, length: 255 , Coded Values: [None: None] , [Pending: Pending] , [Complete: Complete] )
• MVM360Video ( type: esriFieldTypeString, alias: MVM360Video, length: 255 )
• MVMWallAnalysis ( type: esriFieldTypeString, alias: MVMWallAnalysis, length: 255 )
• MVMPtCloud ( type: esriFieldTypeString, alias: MVMPtCloud, length: 255 )
• MVMWallScore ( type: esriFieldTypeString, alias: MVMWallScore, length: 255 )
• MVMWallRating ( type: esriFieldTypeString, alias: MVMWallRating, length: 255 , Coded Values: [Good: Good] , [Fair: Fair] , [Poorest20%: Poorest20%] , ...1 more... )
• Cleanout ( type: esriFieldTypeString, alias: Cleanout, length: 255 , Coded Values: [Yes: Yes] , [No: No] )

Relationships:

• SanSewerMain (0) -- Related To: SanSewer Main (2)
• SanSewerMain (1) -- Related To: SanSewer Main (2)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata