Layers:

Layer: Catch Basins (0)

Name: Catch Basins

Display Field: SSCBID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4000

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: 788787.0899999999
YMin: 1131168.2543750033
XMax: 833693.5956249982
YMax: 1185638.5956249982
Spatial Reference: 102671  (3435)  VCSWkid(115702)  LatestVCSWkid(115702)



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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• NORTHING ( type: esriFieldTypeDouble, alias: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: EASTING )
• ORTH_HEIG ( type: esriFieldTypeDouble, alias: Ortho Height )
• GEOID_SEPA ( type: esriFieldTypeDouble, alias: Geoid Separation )
• QUALITY_PO ( type: esriFieldTypeDouble, alias: Quality Position )
• QUALITY_HG ( type: esriFieldTypeDouble, alias: Quality Height )
• QUALITY_1 ( type: esriFieldTypeDouble, alias: Quality Delta )
• SSCBID ( type: esriFieldTypeString, alias: Catch Basin ID No_, length: 20 )
• PKEY ( type: esriFieldTypeString, alias: Primary Key, length: 20 )
• GPSTIME ( type: esriFieldTypeString, alias: GPS Time, length: 30 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 6 , Coded Values: [DUP: Duplicate - Delete] , [CONVCB: Convert to Catch Basin] , [CONVMH: Convert to Manhole] , ...10 more... )
• SYSOWNER ( type: esriFieldTypeString, alias: SYSOWNER, length: 5 , Coded Values: [MZ: Mt. Zion] , [FH: Forsyth] , [COD: City of Decatur] , ...4 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• 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 )

Layer: Cleanouts (1)

Name: Cleanouts

Display Field: SSCOID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4000

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: 793307.9993750006
YMin: 1143174.5231250003
XMax: 832867.0618750006
YMax: 1182782.0143750012
Spatial Reference: 102671  (3435)  VCSWkid(115702)  LatestVCSWkid(115702)



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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• NORTHING ( type: esriFieldTypeDouble, alias: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: EASTING )
• ORTH_HEIG ( type: esriFieldTypeDouble, alias: Ortho Height )
• GEOID_SEPA ( type: esriFieldTypeDouble, alias: Geoid Separation )
• QUALITY_PO ( type: esriFieldTypeDouble, alias: Quality Position )
• QUALITY_HG ( type: esriFieldTypeDouble, alias: Quality Height )
• QUALITY_1 ( type: esriFieldTypeDouble, alias: Quality Delta )
• SSCOID ( type: esriFieldTypeString, alias: CleanOut ID No., length: 20 )
• PKEY ( type: esriFieldTypeString, alias: Primary Key, length: 20 )
• GPSTIME ( type: esriFieldTypeString, alias: GPS Time, length: 30 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 6 , Coded Values: [DUP: Duplicate - Delete] , [CONVCB: Convert to Catch Basin] , [CONVMH: Convert to Manhole] , ...10 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• 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 )

Layer: Manholes (2)

Name: Manholes

Display Field: GPSTIME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 788530.5018749982
YMin: 1128226.840625003
XMax: 835778.629999999
YMax: 1191375.2281249985
Spatial Reference: 102671  (3435)  VCSWkid(115702)  LatestVCSWkid(115702)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: MHUSE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: SS
  Label: Sanitary
  Description: N/A
  Symbol:
  
• Value: SW
  Label: Stormwater
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [MHID]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GPSTIME ( type: esriFieldTypeString, alias: GPS Time, length: 30 )
• RehProjNum ( type: esriFieldTypeString, alias: Rehabilitation Project Number, length: 36 )
• LinerDate ( type: esriFieldTypeDate, alias: Liner Date, length: 8 )
• COVSHP ( type: esriFieldTypeString, alias: Cover Shape, length: 2 , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
• COVMAT ( type: esriFieldTypeString, alias: Cover Material, length: 4 )
• COVFRAMEF ( type: esriFieldTypeString, alias: Cover Frame Fit, length: 50 )
• ADJRINGH ( type: esriFieldTypeDouble, alias: Adjustment Ring Height , Range: [0, 96] )
• FRAMEMAT ( type: esriFieldTypeString, alias: Frame Material, length: 4 )
• FRAMESI ( type: esriFieldTypeString, alias: Frame Seal Inflow, length: 2 , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• CHMMAT ( type: esriFieldTypeString, alias: Chimney Material, length: 3 )
• CHMINFLW ( type: esriFieldTypeString, alias: Chimney I / I, length: 3 , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• CHMLINERI ( type: esriFieldTypeString, alias: Chimney Lining Interior, length: 3 )
• CONETYP ( type: esriFieldTypeString, alias: Cone Type, length: 3 , Coded Values: [FT: Flattop] , [CC: Conical Centered] , [CO: Conical Off-Centered] )
• CONEMAT ( type: esriFieldTypeString, alias: Cone Material, length: 3 )
• CONELINEI ( type: esriFieldTypeString, alias: Cone Liner Interior, length: 3 )
• WALLDIA ( type: esriFieldTypeDouble, alias: Wall Dia (length / width) , Range: [0, 96] )
• WALLSIZE ( type: esriFieldTypeDouble, alias: Wall by Size (width) , Range: [0, 96] )
• WALLMAT ( type: esriFieldTypeString, alias: Wall Material, length: 3 )
• WALLLINEI ( type: esriFieldTypeString, alias: Wall Lining Interior, length: 3 )
• BENCHYN ( type: esriFieldTypeString, alias: Bench Present, length: 3 , Coded Values: [Y: Yes] , [P: Partial] )
• BENCHMAT ( type: esriFieldTypeString, alias: Bench Material, length: 3 )
• CHANINST ( type: esriFieldTypeString, alias: Channel Installed, length: 3 , Coded Values: [Y: Yes] , [P: Partial] )
• CHANTYP ( type: esriFieldTypeString, alias: Channel Type, length: 3 , Coded Values: [P: Pipe] , [F: Formed] , [R: Precast] , ...1 more... )
• CHANEXP ( type: esriFieldTypeString, alias: Channel Exposure, length: 3 , Coded Values: [F: Fully Open] , [P: Partially Open] )
• STEPSNO ( type: esriFieldTypeSmallInteger, alias: Step Number )
• STEPSMAT ( type: esriFieldTypeString, alias: Step Material, length: 3 , Coded Values: [M: Metal] , [P: Plastic] , [B: Brick] , ...1 more... )
• MHID ( type: esriFieldTypeString, alias: Manhole No., length: 50 )
• SURVBY ( type: esriFieldTypeString, alias: Surveyed By, length: 50 )
• CERTNUM ( type: esriFieldTypeString, alias: Cerificate Number, length: 50 )
• CUSTMR ( type: esriFieldTypeString, alias: Customer, length: 50 )
• PONO ( type: esriFieldTypeString, alias: Purchase Order Number, length: 50 )
• RIMTOINV ( type: esriFieldTypeDouble, alias: Rim to Invert , Range: [0, 96] )
• RIMTOGRD ( type: esriFieldTypeDouble, alias: Rim to Grade , Range: [0, 96] )
• PURSURV ( type: esriFieldTypeString, alias: Purpose, length: 1 , Coded Values: [A: Maintenance related] , [B: Infiltration and Inflow investigation] , [C: Post rehabilitation survey] , ...6 more... )
• PRECLEANING ( type: esriFieldTypeString, alias: Pre-Cleaning, length: 1 , Coded Values: [J: Jetting] , [H: Heavy cleaning] , [N: No pre-cleaning] , ...1 more... )
• WEATHER ( type: esriFieldTypeSmallInteger, alias: Weather , Coded Values: [1: Dry] , [2: Heavy Rain] , [3: Light Rain] , ...4 more... )
• ADDINFO ( type: esriFieldTypeString, alias: Additional Information, length: 100 )
• SURFTYPE ( type: esriFieldTypeString, alias: Surface Type, length: 50 )
• POTRUNOFF ( type: esriFieldTypeString, alias: Potential for Runoff, length: 50 , Coded Values: [N: None] , [S: Sheeting] , [P: Ponding] , ...1 more... )
• ACCTYPE ( type: esriFieldTypeString, alias: Access Type, length: 50 )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 50 )
• INSPDATE ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• INSPSTATUS ( type: esriFieldTypeString, alias: Inspection Status, length: 50 )
• ADDRESS ( type: esriFieldTypeString, alias: Street (No. & Name), length: 50 )
• CITY ( type: esriFieldTypeString, alias: City, length: 50 )
• MHUSE ( type: esriFieldTypeString, alias: MH Use, length: 4 )
• TAPENO ( type: esriFieldTypeString, alias: Media Label, length: 24 )
• ADJRINGM ( type: esriFieldTypeString, alias: Adjustment Ring Material, length: 4 )
• ADJRINGT ( type: esriFieldTypeString, alias: Adjustment Ring Type, length: 2 )
• COVTYP ( type: esriFieldTypeString, alias: Cover Type, length: 20 )
• BENCHL ( type: esriFieldTypeString, alias: Bench Lining, length: 3 )
• XCOORD ( type: esriFieldTypeString, alias: Easting, length: 12 )
• YCOORD ( type: esriFieldTypeString, alias: Northing, length: 12 )
• ZCOORD ( type: esriFieldTypeString, alias: Elevation, length: 12 )
• FRAMECON ( type: esriFieldTypeString, alias: Frame Condition, length: 20 )
• FRAMESCON ( type: esriFieldTypeString, alias: Frame Seal Condition, length: 20 )
• GPSACC ( type: esriFieldTypeString, alias: GPS Accuracy, length: 3 )
• DRAINAREA ( type: esriFieldTypeString, alias: Drainage Area, length: 50 )
• HOLEDIA ( type: esriFieldTypeString, alias: Hole Diameter (Vent), length: 3 )
• HOLENO ( type: esriFieldTypeSmallInteger, alias: Hole Number (No. Vent Holes) )
• SHEETNO ( type: esriFieldTypeSmallInteger, alias: Sheet No. )
• SURVTIME ( type: esriFieldTypeString, alias: Time (ex: 1520), length: 4 )
• LOCDET ( type: esriFieldTypeString, alias: Location Details, length: 100 )
• GRADINV ( type: esriFieldTypeDouble, alias: Grade to Invert , Range: [0, 96] )
• YEARBLT ( type: esriFieldTypeSmallInteger, alias: Year Built (YYYY) )
• YEARREN ( type: esriFieldTypeSmallInteger, alias: Year Renewed (YYYY) )
• LOCCODE ( type: esriFieldTypeString, alias: Location Code, length: 1 , Coded Values: [A: Main highway- urban] , [B: Mian highway- suburban/ rural] , [C: Light highway] , ...12 more... )
• CATEGOR ( type: esriFieldTypeString, alias: Category, length: 1 )
• EVSURCH ( type: esriFieldTypeString, alias: Evidence of Surcharge, length: 4 )
• COORDSYS ( type: esriFieldTypeString, alias: Coordinate System, length: 20 )
• COVSIZE ( type: esriFieldTypeDouble, alias: Cover Size , Range: [0, 96] )
• COVSIZEW ( type: esriFieldTypeDouble, alias: Cover Size Width , Range: [0, 96] )
• COVBSD ( type: esriFieldTypeDouble, alias: Cover Bearing Surface Dia , Range: [0, 96] )
• COVBSDW ( type: esriFieldTypeDouble, alias: Cover Bearing Surface Dia Width , Range: [0, 96] )
• COVCOND ( type: esriFieldTypeString, alias: Cover Condition, length: 30 )
• COVINSTYP ( type: esriFieldTypeString, alias: Cover Insert Type, length: 2 )
• COVINSCON ( type: esriFieldTypeString, alias: Cover Insert Condition, length: 30 )
• ADJRINGC ( type: esriFieldTypeString, alias: Ring Condition, length: 22 )
• FRAMEBSW ( type: esriFieldTypeDouble, alias: Frame Bearing Surface Width , Range: [0, 96] )
• FRAMEBSD ( type: esriFieldTypeDouble, alias: Frame Bearing Surface Depth , Range: [0, 96] )
• FRAMECOD ( type: esriFieldTypeDouble, alias: Frame Clear Opening Dia , Range: [0, 96] )
• FRAMEOSD ( type: esriFieldTypeDouble, alias: Frame Offset Distance , Range: [0, 96] )
• FRAMEDEP ( type: esriFieldTypeDouble, alias: Frame Depth , Range: [0, 96] )
• CHMLINERE ( type: esriFieldTypeString, alias: Chimney Lining Exterior, length: 3 )
• CONELINEE ( type: esriFieldTypeString, alias: Cone Lining Exterior, length: 3 )
• CHMCLOP ( type: esriFieldTypeDouble, alias: Chimney Clear Opening , Range: [0, 96] )
• CHMDEP ( type: esriFieldTypeDouble, alias: Chimney depth , Range: [0, 96] )
• CONEDEP ( type: esriFieldTypeDouble, alias: Cone Depth , Range: [0, 96] )
• WALLDEP ( type: esriFieldTypeDouble, alias: Wall Depth , Range: [0, 96] )
• WALLLINEE ( type: esriFieldTypeString, alias: Wall Lining Exterior, length: 3 )
• CHANMAT ( type: esriFieldTypeString, alias: Channel Material, length: 50 )
• INSPLEV ( type: esriFieldTypeSmallInteger, alias: Inspection Level )
• CLNDATE ( type: esriFieldTypeDate, alias: Date Cleaned (YYYY/MM/DD), length: 8 )
• SURVDATE ( type: esriFieldTypeDate, alias: Date (YYYY/MM/DD), length: 8 )
• PKEY ( type: esriFieldTypeString, alias: PKEY, length: 20 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• 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 )

Relationships:

• MH_Components (0) -- Related To: MH Components (7)
• MH_Inspections (1) -- Related To: MH Inspections (5)
• MH_Defects (2) -- Related To: MH Defects (6)

Layer: Mains (3)

Name: Mains

Display Field: PIPEUSE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 788530.5018749982
YMin: 1128226.840625003
XMax: 835778.629999999
YMax: 1191470.9293750003
Spatial Reference: 102671  (3435)  VCSWkid(115702)  LatestVCSWkid(115702)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: PIPEUSE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CB
  Label: Combined
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: SS
  Label: Sanitary
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: SW
  Label: Stormwater
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIA]
Use Coded Values: true
Symbol:
Color: [38, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Verdana
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 6000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIA]
Use Coded Values: true
Symbol:
Color: [168, 56, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Verdana
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 6000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIA]
Use Coded Values: true
Symbol:
Color: [230, 0, 169, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Verdana
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 6000.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PIPEUSE ( type: esriFieldTypeString, alias: Use of Sewer, length: 20 , Coded Values: [SS: Sanitary] , [SW: Stormwater] , [PR: Processes] , ...7 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Pipe Material, length: 5 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CROSXSHAP ( type: esriFieldTypeString, alias: Pipe Shape, length: 20 , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
• SPCOND ( type: esriFieldTypeString, alias: Pipe Special Condition, length: 4 , Coded Values: [OU: Outside Drop Upper] , [OL: Outside Drop Lower] , [IU: Inside Drop Upper] , ...4 more... )
• PINVU ( type: esriFieldTypeDouble, alias: Upstream Elevation )
• PINVD ( type: esriFieldTypeDouble, alias: Downstream Elevation )
• PSCONDU ( type: esriFieldTypeString, alias: Pipe Seal Condition US, length: 4 , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• PSCONDD ( type: esriFieldTypeString, alias: Pipe Seal Condition DS, length: 4 , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• SYSOWNER ( type: esriFieldTypeString, alias: System Owner, length: 4 , Coded Values: [MZ: Mt. Zion] , [FH: Forsyth] , [COD: City of Decatur] , ...4 more... )
• PIPEID ( type: esriFieldTypeString, alias: Pipe Segment Reference, length: 20 )
• MHNOUS ( type: esriFieldTypeString, alias: Upstream manhole number, length: 20 )
• MHNODS ( type: esriFieldTypeString, alias: Downstream manhole number, length: 20 )
• RIMINVUS ( type: esriFieldTypeDouble, alias: Upstream Rim to Invert )
• RIMINVDS ( type: esriFieldTypeDouble, alias: Downstream Rim to Invert )
• INSTLDATE ( type: esriFieldTypeDate, alias: Year Constructed, length: 8 )
• REHBDATE ( type: esriFieldTypeDate, alias: Year Rehabilitated, length: 8 )
• APN ( type: esriFieldTypeSmallInteger, alias: Asset Priority Number )
• LROOTCUT ( type: esriFieldTypeDate, alias: Last Root Cut, length: 8 )
• LJETDATE ( type: esriFieldTypeDate, alias: Last Jet Date, length: 8 )
• LHRBDATE ( type: esriFieldTypeDate, alias: Last Herbicide Date, length: 8 )
• LDGRDATE ( type: esriFieldTypeDate, alias: Last Degrease Date, length: 8 )
• LTELDATE ( type: esriFieldTypeDate, alias: Last Televise Date, length: 8 )
• TAPENO ( type: esriFieldTypeString, alias: Tape / Media No_, length: 24 )
• POF ( type: esriFieldTypeDouble, alias: Probability of Failure )
• COF ( type: esriFieldTypeDouble, alias: Criticality of Failure )
• PIPEDIA ( type: esriFieldTypeString, alias: Pipe Diameter, length: 7 , Coded Values: [1: 1"] , [2: 2"] , [4: 4"] , ...40 more... )
• LCLNDATE ( type: esriFieldTypeDate, alias: Last Cleaned Date, length: 8 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 50 )
• REHBMAT ( type: esriFieldTypeString, alias: REHBMAT, length: 4 )
• REHBCNTR ( type: esriFieldTypeString, alias: REHBCNTR, length: 35 )
• HERBICIDE ( type: esriFieldTypeString, alias: HERBICIDE, length: 4 )
• FLOWTYPE ( type: esriFieldTypeString, alias: Flow Type, length: 15 )
• OM_SCORE ( type: esriFieldTypeDouble, alias: OM Score )
• SURFCOND ( type: esriFieldTypeString, alias: Surface Condition, length: 50 )
• TVLENGTH ( type: esriFieldTypeDouble, alias: Televised Length )
• PIPEWIDTH ( type: esriFieldTypeDouble, alias: Pipe Width )
• ASSETSPLIT ( type: esriFieldTypeString, alias: Asset Split, length: 1 )
• SPLITDATE ( type: esriFieldTypeDate, alias: Split Date, length: 8 )
• SUCCESSORASSET ( type: esriFieldTypeString, alias: Successor Assets, length: 20 )
• OLDSPLITASSET ( type: esriFieldTypeString, alias: Old Split Asset, length: 20 )
• PACP_QUICK ( type: esriFieldTypeString, alias: PACP Quick Rating, length: 10 )
• PACP_PIPE ( type: esriFieldTypeDouble, alias: PACP Pipe Rating )
• CUES_TOTAL ( type: esriFieldTypeDouble, alias: CUES Total Pipe Rating )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• 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 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• Deferred ( type: esriFieldTypeString, alias: Deferred, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Deferred_Date ( type: esriFieldTypeDate, alias: Deferred Date, length: 8 )
• Defer_Reason ( type: esriFieldTypeString, alias: Reason for Deferment, length: 24 , Coded Values: [BlindTap: Blind Tap] , [DiameterPipeSize: Diameter/Pipe Size] , [OffRoad: Off Road] , ...3 more... )
• def_other_reason ( type: esriFieldTypeString, alias: Other Reason, length: 255 )
• Sewer_Basin ( type: esriFieldTypeString, alias: Basin, length: 7 , Coded Values: [1: Basin 1] , [2: Basin 2] , [3: Basin 3] , ...2 more... )
• VERIFIED_CLEAN_DATE ( type: esriFieldTypeDate, alias: Verified Clean Date, length: 8 )
• TYPE_OF_VERIFICATION ( type: esriFieldTypeString, alias: Type of Verification, length: 24 , Coded Values: [CCTV: CCTV] , [Sounding: Sounding] , [MH Visual: MH Visual] , ...6 more... )

Layer: Private Mains (4)

Name: Private Mains

Display Field: PIPEUSE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 788530.5018749982
YMin: 1128226.840625003
XMax: 835778.629999999
YMax: 1191470.9293750003
Spatial Reference: 102671  (3435)  VCSWkid(115702)  LatestVCSWkid(115702)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: PIPEUSE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CB
  Label: Combined
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: SS
  Label: Sanitary
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: SW
  Label: Stormwater
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIA]
Use Coded Values: true
Symbol:
Color: [38, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Verdana
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 6000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIA]
Use Coded Values: true
Symbol:
Color: [168, 56, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Verdana
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 6000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPEDIA]
Use Coded Values: true
Symbol:
Color: [230, 0, 169, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Verdana
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 6000.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PIPEUSE ( type: esriFieldTypeString, alias: Use of Sewer, length: 20 , Coded Values: [SS: Sanitary] , [SW: Stormwater] , [PR: Processes] , ...7 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Pipe Material, length: 5 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CROSXSHAP ( type: esriFieldTypeString, alias: Pipe Shape, length: 20 , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
• SPCOND ( type: esriFieldTypeString, alias: Pipe Special Condition, length: 4 , Coded Values: [OU: Outside Drop Upper] , [OL: Outside Drop Lower] , [IU: Inside Drop Upper] , ...4 more... )
• PINVU ( type: esriFieldTypeDouble, alias: Upstream Elevation )
• PINVD ( type: esriFieldTypeDouble, alias: Downstream Elevation )
• PSCONDU ( type: esriFieldTypeString, alias: Pipe Seal Condition US, length: 4 , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• PSCONDD ( type: esriFieldTypeString, alias: Pipe Seal Condition DS, length: 4 , Coded Values: [S: Sound] , [H: Hole] , [IW: Weeper] , ...5 more... )
• SYSOWNER ( type: esriFieldTypeString, alias: System Owner, length: 4 , Coded Values: [MZ: Mt. Zion] , [FH: Forsyth] , [COD: City of Decatur] , ...4 more... )
• PIPEID ( type: esriFieldTypeString, alias: Pipe Segment Reference, length: 20 )
• MHNOUS ( type: esriFieldTypeString, alias: Upstream manhole number, length: 20 )
• MHNODS ( type: esriFieldTypeString, alias: Downstream manhole number, length: 20 )
• RIMINVUS ( type: esriFieldTypeDouble, alias: Upstream Rim to Invert )
• RIMINVDS ( type: esriFieldTypeDouble, alias: Downstream Rim to Invert )
• INSTLDATE ( type: esriFieldTypeDate, alias: Year Constructed, length: 8 )
• REHBDATE ( type: esriFieldTypeDate, alias: Year Rehabilitated, length: 8 )
• APN ( type: esriFieldTypeSmallInteger, alias: Asset Priority Number )
• LROOTCUT ( type: esriFieldTypeDate, alias: Last Root Cut, length: 8 )
• LJETDATE ( type: esriFieldTypeDate, alias: Last Jet Date, length: 8 )
• LHRBDATE ( type: esriFieldTypeDate, alias: Last Herbicide Date, length: 8 )
• LDGRDATE ( type: esriFieldTypeDate, alias: Last Degrease Date, length: 8 )
• LTELDATE ( type: esriFieldTypeDate, alias: Last Televise Date, length: 8 )
• TAPENO ( type: esriFieldTypeString, alias: Tape / Media No_, length: 24 )
• POF ( type: esriFieldTypeDouble, alias: Probability of Failure )
• COF ( type: esriFieldTypeDouble, alias: Criticality of Failure )
• PIPEDIA ( type: esriFieldTypeString, alias: Pipe Diameter, length: 7 , Coded Values: [1: 1"] , [2: 2"] , [4: 4"] , ...40 more... )
• LCLNDATE ( type: esriFieldTypeDate, alias: Last Cleaned Date, length: 8 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 50 )
• REHBMAT ( type: esriFieldTypeString, alias: REHBMAT, length: 4 )
• REHBCNTR ( type: esriFieldTypeString, alias: REHBCNTR, length: 35 )
• HERBICIDE ( type: esriFieldTypeString, alias: HERBICIDE, length: 4 )
• FLOWTYPE ( type: esriFieldTypeString, alias: Flow Type, length: 15 )
• OM_SCORE ( type: esriFieldTypeDouble, alias: OM Score )
• SURFCOND ( type: esriFieldTypeString, alias: Surface Condition, length: 50 )
• TVLENGTH ( type: esriFieldTypeDouble, alias: Televised Length )
• PIPEWIDTH ( type: esriFieldTypeDouble, alias: Pipe Width )
• ASSETSPLIT ( type: esriFieldTypeString, alias: Asset Split, length: 1 )
• SPLITDATE ( type: esriFieldTypeDate, alias: Split Date, length: 8 )
• SUCCESSORASSET ( type: esriFieldTypeString, alias: Successor Assets, length: 20 )
• OLDSPLITASSET ( type: esriFieldTypeString, alias: Old Split Asset, length: 20 )
• PACP_QUICK ( type: esriFieldTypeString, alias: PACP Quick Rating, length: 10 )
• PACP_PIPE ( type: esriFieldTypeDouble, alias: PACP Pipe Rating )
• CUES_TOTAL ( type: esriFieldTypeDouble, alias: CUES Total Pipe Rating )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• 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 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• Deferred ( type: esriFieldTypeString, alias: Deferred, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Deferred_Date ( type: esriFieldTypeDate, alias: Deferred Date, length: 8 )
• Defer_Reason ( type: esriFieldTypeString, alias: Reason for Deferment, length: 24 , Coded Values: [BlindTap: Blind Tap] , [DiameterPipeSize: Diameter/Pipe Size] , [OffRoad: Off Road] , ...3 more... )
• def_other_reason ( type: esriFieldTypeString, alias: Other Reason, length: 255 )
• Sewer_Basin ( type: esriFieldTypeString, alias: Basin, length: 7 , Coded Values: [1: Basin 1] , [2: Basin 2] , [3: Basin 3] , ...2 more... )
• VERIFIED_CLEAN_DATE ( type: esriFieldTypeDate, alias: Verified Clean Date, length: 8 )
• TYPE_OF_VERIFICATION ( type: esriFieldTypeString, alias: Type of Verification, length: 24 , Coded Values: [CCTV: CCTV] , [Sounding: Sounding] , [MH Visual: MH Visual] , ...6 more... )

Tables:

Table: MH Inspections (5)

Name: MH Inspections

Display Field: SURVNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID )
• SURVNAME ( type: esriFieldTypeString, alias: Surveyor / Operator Name, length: 50 , Coded Values: [Ryan Owens: Ryan Owens] , [Mike Bruner: Mike Bruner] , [John Latshaw: John Latshaw] , ...6 more... )
• CERTNUM ( type: esriFieldTypeString, alias: Cerificate number, length: 50 , Coded Values: [U-907-5672: U-907-5672] , [U-907-5671: U-907-5671] , [U-907-5670: U-907-5670] , ...6 more... )
• SURVCSTMR ( type: esriFieldTypeString, alias: Survey Customer, length: 50 , Coded Values: [MZ: Mt. Zion] , [FH: Forsyth] , [COD: City of Decatur] , ...4 more... )
• PONO ( type: esriFieldTypeString, alias: Purchase Order Number, length: 50 )
• OUTRIMTOINV ( type: esriFieldTypeDouble, alias: Outgoing Rim to Invert )
• RIMTOGRD ( type: esriFieldTypeDouble, alias: Rim to Grade )
• PURSURV ( type: esriFieldTypeString, alias: Purpose of Survey, length: 1 , Coded Values: [A: Maintenance related] , [B: Infiltration and Inflow investigation] , [C: Post rehabilitation survey] , ...6 more... )
• PRECLEANING ( type: esriFieldTypeString, alias: Pre-Cleaning, length: 1 , Coded Values: [J: Jetting] , [H: Heavy cleaning] , [N: No pre-cleaning] , ...1 more... )
• WEATHER ( type: esriFieldTypeSmallInteger, alias: Weather , Coded Values: [1: Dry] , [2: Heavy Rain] , [3: Light Rain] , ...4 more... )
• LOCCODE ( type: esriFieldTypeString, alias: Location Code, length: 1 , Coded Values: [A: Main highway- urban] , [B: Mian highway- suburban/ rural] , [C: Light highway] , ...12 more... )
• ADDINFO ( type: esriFieldTypeString, alias: Additional Information, length: 100 )
• MHSURFTYPE ( type: esriFieldTypeString, alias: Manhole Surface Type, length: 50 , Coded Values: [Asphalt: Asphalt] , [Concrete Pavement: Concrete Pavement] , [Concrete Collar: Concrete Collar] , ...3 more... )
• POTRUNOFF ( type: esriFieldTypeString, alias: Potential for Runoff, length: 50 , Coded Values: [N: None] , [S: Sheeting] , [P: Ponding] , ...1 more... )
• ACSPTTYPE ( type: esriFieldTypeString, alias: Access Point Type, length: 50 , Coded Values: [AMH: Manhole] , [AWA: Wastewater access] , [AM: Meter] , ...8 more... )
• SYSOWNER ( type: esriFieldTypeString, alias: System Owner, length: 50 , Coded Values: [MZ: Mt. Zion] , [FH: Forsyth] , [COD: City of Decatur] , ...4 more... )
• INSPDATE ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• INSPSTATUS ( type: esriFieldTypeString, alias: Inspection Status, length: 50 , Coded Values: [SI: Surface Inspection] , [DI: Descent Inspection] , [RI: Remote Inspection] , ...6 more... )
• FLD ( type: esriFieldTypeString, alias: Further Location Details, length: 200 )
• LOCATION ( type: esriFieldTypeString, alias: Location (No. & Name), length: 50 )
• LOCATION2 ( type: esriFieldTypeString, alias: Locality / City Name, length: 50 )
• EOS ( type: esriFieldTypeDouble, alias: Evidence of Surcharge )
• POF ( type: esriFieldTypeSmallInteger, alias: Probability of Failure )
• TAPENO ( type: esriFieldTypeString, alias: Tape / Media No., length: 24 )
• FKEY ( type: esriFieldTypeString, alias: Foreign Key, length: 20 )
• MHID ( type: esriFieldTypeString, alias: Manhole ID No., length: 20 )
• USE_ ( type: esriFieldTypeString, alias: Use of Sewer, length: 4 , Coded Values: [SS: Sanitary] , [SW: Stormwater] , [PR: Processes] , ...7 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• ssMHInspections (1) -- Related To: Manholes (2)

Table: MH Defects (6)

Name: MH Defects

Display Field: FKEY

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FKEY ( type: esriFieldTypeString, alias: Foreign Key, length: 20 )
• DEFECT ( type: esriFieldTypeString, alias: Defect, length: 4 , Coded Values: [HVV: Hole with void visible] , [H: Hole in structure] , [DB: Displaced Brick] , ...11 more... )
• SDIST ( type: esriFieldTypeDouble, alias: Start Distance )
• EDIST ( type: esriFieldTypeDouble, alias: End Distance )
• SCORE ( type: esriFieldTypeSmallInteger, alias: SCORE )
• POTENTIAL ( type: esriFieldTypeSmallInteger, alias: Inflow & Infiltration , Coded Values: [0: False] , [1: True] )
• MHID ( type: esriFieldTypeString, alias: MH ID No., length: 20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• ssMHDefects (2) -- Related To: Manholes (2)

Table: MH Components (7)

Name: MH Components

Display Field: CSHAPE

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e7517d90368a4826a3a7b67366d1ce75

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CSHAPE ( type: esriFieldTypeString, alias: Cover Shape, length: 2 , Coded Values: [A: Arched] , [B: Barrel] , [C: Circular] , ...8 more... )
• CMATERIAL ( type: esriFieldTypeString, alias: Cover Material, length: 4 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CTYPE ( type: esriFieldTypeSmallInteger, alias: Cover Type , Coded Values: [1: Solid] , [2: Vented/Slots] , [3: Gasketed] , ...4 more... )
• CFF ( type: esriFieldTypeString, alias: Cover / Frame Fit, length: 50 , Coded Values: [O: Oversized] , [G: Good] , [U: Undersized] , ...1 more... )
• MHARC ( type: esriFieldTypeSmallInteger, alias: MH Cover Adjustment Ring Condition , Coded Values: [1: Sound] , [2: Cracked] , [3: Broken] , ...3 more... )
• MHARH ( type: esriFieldTypeDouble, alias: MH Adjustment Ring Height , Range: [0, 96] )
• FRAMEM ( type: esriFieldTypeString, alias: Frame Material, length: 4 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• FRAMEC ( type: esriFieldTypeSmallInteger, alias: Frame Condition , Coded Values: [1: Sound] , [2: Cracked] , [3: Broken] , ...3 more... )
• FRAMESC ( type: esriFieldTypeSmallInteger, alias: Frame Seal Condition , Coded Values: [1: Sound] , [2: Cracked] , [3: Loose / Not Attached] , ...1 more... )
• FRAMESI ( type: esriFieldTypeString, alias: Frame Seal Infiltration / Inflow, length: 2 , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• CMATERIAL1 ( type: esriFieldTypeString, alias: Chimney Material 1, length: 3 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CINFLOW ( type: esriFieldTypeString, alias: Chimney Infiltration / Inflow, length: 3 , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• CCOATLINER1 ( type: esriFieldTypeString, alias: Int. Chim. Coating / Liner, length: 3 , Coded Values: [NC: No coating] , [C: Cementitious] , [E: Epoxy] , ...7 more... )
• CONETYPE ( type: esriFieldTypeString, alias: Cone Type, length: 3 , Coded Values: [FT: Flattop] , [CC: Conical Centered] , [CO: Conical Off-Centered] )
• CONEMATERIAL ( type: esriFieldTypeString, alias: Cone Material, length: 3 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CONELINER1 ( type: esriFieldTypeString, alias: Int Cone Coating / Liner, length: 3 , Coded Values: [NC: No coating] , [C: Cementitious] , [E: Epoxy] , ...7 more... )
• WALLDL ( type: esriFieldTypeDouble, alias: Wall Dia Length , Range: [0, 96] )
• WALLDW ( type: esriFieldTypeDouble, alias: Wall Dia Width , Range: [0, 96] )
• WALLM ( type: esriFieldTypeString, alias: Wall Material, length: 3 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• WALLCOAT1 ( type: esriFieldTypeString, alias: Int. Wall Coating / Liner, length: 3 , Coded Values: [NC: No coating] , [C: Cementitious] , [E: Epoxy] , ...7 more... )
• BENCH ( type: esriFieldTypeString, alias: Bench Present?, length: 3 , Coded Values: [Y: Yes] , [P: Partial] )
• BENCHM ( type: esriFieldTypeString, alias: Bench Material, length: 3 , Coded Values: [AC: Asbestos concrete] , [BR: Brick] , [CAS: Cast iron] , ...21 more... )
• CHANNEL ( type: esriFieldTypeString, alias: Channel Installed, length: 3 , Coded Values: [Y: Yes] , [P: Partial] )
• CHANNELT ( type: esriFieldTypeString, alias: Channel Type, length: 3 , Coded Values: [P: Pipe] , [F: Formed] , [R: Precast] , ...1 more... )
• CHANNELE ( type: esriFieldTypeString, alias: Channel Exposure, length: 3 , Coded Values: [F: Fully Open] , [P: Partially Open] )
• STEPSN ( type: esriFieldTypeSmallInteger, alias: Number of Steps )
• STEPSM ( type: esriFieldTypeString, alias: Step Material, length: 3 , Coded Values: [M: Metal] , [P: Plastic] , [B: Brick] , ...1 more... )
• MHID ( type: esriFieldTypeString, alias: Manhole No., length: 20 )
• CWINFLOW ( type: esriFieldTypeString, alias: Cone & Wall Infiltration and Inflow, length: 50 , Coded Values: [IW: Weeper] , [ID: Dripper] , [IR: Runner] , ...3 more... )
• EPIPES ( type: esriFieldTypeSmallInteger, alias: External Pipes , Range: [1, 20] )
• MHMATERIAL ( type: esriFieldTypeSmallInteger, alias: Manhole Material , Coded Values: [0: Concrete] , [1: Brick] )
• INWHELLLANE ( type: esriFieldTypeSmallInteger, alias: Casting in Wheel Lane , Coded Values: [0: False] , [1: True] )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, length: 20 , Coded Values: [SS: Sanitary] , [SW: Stormwater] , [PR: Processes] , ...7 more... )
• RECOVERY_ ( type: esriFieldTypeString, alias: Recovery, length: 4 , Coded Values: [B: Buried] , [R: Recovered] , [O: Original] )
• STATUS ( type: esriFieldTypeString, alias: Edit Status, length: 30 , Coded Values: [DUP: Duplicate - Delete] , [CONVCB: Convert to Catch Basin] , [CONVMH: Convert to Manhole] , ...10 more... )
• FKEY ( type: esriFieldTypeString, alias: Foreign Key, length: 20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• ssMHComponents (0) -- Related To: Manholes (2)