Parent Layer: Sewer

Name: SewerMains

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This data contains the Sewer mains for the City of McKinney, Texas

Copyright Text: McKinney GIS and Water department

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 2498331.772697419
YMin: 7096061.500029296
XMax: 2569459.1499156654
YMax: 7169125.409857348
Spatial Reference: 102738  (2276)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: RuleID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: MCKINNEY
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 0
• Value: 2
  Label: MELISSA
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 0
• Value: 3
  Label: NTMWD
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [137, 90, 68, 255]
  Width: 0
• Value: 4
  Label: PRIVATE
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 255, 223, 255]
  Width: 0
• Value: 5
  Label: FRISCO
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [AssetID] CONCAT NEWLINE CONCAT [Size] CONCAT "'" CONCAT "'" CONCAT " " CONCAT " " CONCAT [SHAPE.STLength()] CONCAT "'"
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: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Feature Draw Order:

N/A

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 )
• AssetID ( type: esriFieldTypeString, alias: ASSETID, length: 35 )
• Street ( type: esriFieldTypeString, alias: STREET, length: 35 )
• Size ( type: esriFieldTypeDouble, alias: SIZE )
• Material ( type: esriFieldTypeString, alias: MATERIAL, length: 35 , Coded Values: [PVC: PVC] , [CI: CI] , [CP: CP] , ...13 more... )
• VID ( type: esriFieldTypeString, alias: VID, length: 35 )
• CRC ( type: esriFieldTypeDouble, alias: CRC )
• OID ( type: esriFieldTypeInteger, alias: OID )
• Type ( type: esriFieldTypeString, alias: TYPE, length: 50 , Coded Values: [Gravity: Gravity] , [Force: Force] , [Lateral: Lateral] , ...3 more... )
• Status ( type: esriFieldTypeString, alias: Status, length: 25 )
• Reversal ( type: esriFieldTypeString, alias: Reversal, length: 10 , Coded Values: [Yes: Yes] , [NA: NA] , [Needed: Needed] , ...1 more... )
• Reason ( type: esriFieldTypeString, alias: Reason, length: 50 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 100 )
• QSR ( type: esriFieldTypeString, alias: QSR, length: 4 )
• QMR ( type: esriFieldTypeString, alias: QMR, length: 4 )
• SPR ( type: esriFieldTypeString, alias: SPR, length: 3 )
• MPR ( type: esriFieldTypeString, alias: MPR, length: 3 )
• SPRI ( type: esriFieldTypeString, alias: SPRI, length: 3 )
• MPRI ( type: esriFieldTypeString, alias: MPRI, length: 3 )
• OPRI ( type: esriFieldTypeString, alias: OPRI, length: 3 )
• AcousticDate ( type: esriFieldTypeDate, alias: AcousticDate, length: 8 )
• CleanSchedule ( type: esriFieldTypeDate, alias: CleanSchedule, length: 8 )
• CleanComplete ( type: esriFieldTypeDate, alias: CleanComplete, length: 8 )
• TVSchedule ( type: esriFieldTypeDate, alias: TV_Schedule, length: 8 )
• TVInspected ( type: esriFieldTypeDate, alias: TV_Inspected, length: 8 )
• RootControl ( type: esriFieldTypeDate, alias: RootControl, length: 8 )
• AcousticGrade ( type: esriFieldTypeString, alias: AcousticGrade, length: 3 )
• RuleID ( type: esriFieldTypeInteger, alias: RuleID , Coded Values: [1: MCKINNEY] , [2: MELISSA] , [3: NTMWD] , ...3 more... )
• Override ( type: esriFieldTypeBlob, alias: Override )
• USMH ( type: esriFieldTypeString, alias: USMH, length: 10 )
• DSMH ( type: esriFieldTypeString, alias: DSMH, length: 10 )
• SCVConn ( type: esriFieldTypeInteger, alias: SCVConn )
• HotSpot ( type: esriFieldTypeString, alias: HotSpot, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• CapacityIssue ( type: esriFieldTypeString, alias: CapacityIssue, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear )
• SurveyedLength ( type: esriFieldTypeDouble, alias: Surveyed Length )
• Project ( type: esriFieldTypeString, alias: Project, length: 255 )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, length: 35 , Coded Values: [FRISCO: FRISCO] , [MELISSA: MELISSA] , [NTMWD: NTMWD] , ...3 more... )
• Rehab ( type: esriFieldTypeString, alias: Rehab, length: 200 , Coded Values: [Completed: Completed] , [Proposed: Proposed] , [Scheduled: Scheduled] , ...1 more... )
• LifeCycle ( type: esriFieldTypeString, alias: LifeCycle, length: 50 , Coded Values: [Active: Active] , [Abandoned: Abandoned] , [Removed: Removed] , ...1 more... )
• CWAssetID ( type: esriFieldTypeString, alias: CWAssetID, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Notes2 ( type: esriFieldTypeString, alias: Notes2, length: 250 )
• RehabDate ( type: esriFieldTypeDate, alias: RehabDate, length: 8 )
• OffsiteEasements ( type: esriFieldTypeString, alias: OffsiteEasements, length: 3 , Coded Values: [1: Sewer Mains within ROW] , [2: Offsite Sewer Mains (w/ Easements)] , [3: Offsite Sewer Mains (w/o Easements)] )
• AerialCrossing ( type: esriFieldTypeString, alias: AerialCrossing, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Encasement ( type: esriFieldTypeString, alias: Encasement, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• EncasementType ( type: esriFieldTypeString, alias: EncasementType, length: 255 )
• LF ( type: esriFieldTypeDouble, alias: LF )
• OpMaintRating ( type: esriFieldTypeSmallInteger, alias: OpMaintRating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• MilesOfPipe ( type: esriFieldTypeDouble, alias: MilesOfPipe )
• Basin ( type: esriFieldTypeString, alias: Basin, length: 10 )
• District ( type: esriFieldTypeString, alias: District, length: 10 )
• StructuralRating ( type: esriFieldTypeSmallInteger, alias: StructuralRating )
• RepairMethod ( type: esriFieldTypeString, alias: RepairMethod, length: 20 , Coded Values: [CIP: CIP] , [OpenCut: Open Cut] , [Lining: Lining] , ...1 more... )
• YearsLastTelevised ( type: esriFieldTypeString, alias: YearsLastTelevised, length: 10 )
• PreviousTVInspected ( type: esriFieldTypeDate, alias: PreviousTVInspected, length: 8 )
• LinerType ( type: esriFieldTypeString, alias: LinerType, length: 50 , Coded Values: [CIPP: CIPP] , [Felt: Felt] , [Old Liner: Old Liner] , ...1 more... )
• RepairReason ( type: esriFieldTypeString, alias: RepairReason, length: 255 )
• RepairProject ( type: esriFieldTypeString, alias: RepairProject, length: 255 )
• WarrantyAccepted ( type: esriFieldTypeString, alias: WarrantyAccepted, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PreviousCleaningDate ( type: esriFieldTypeDate, alias: PreviousCleaningDate, length: 8 )
• RehabContractor ( type: esriFieldTypeString, alias: RehabContractor , length: 150 , Coded Values: [Fuquay: Fuquay] , [Insituform: Insituform] , [WarrenEpoxy: Warren Epoxy] , ...3 more... )
• SubBasin ( type: esriFieldTypeString, alias: SubBasin, length: 20 )
• HotSpotFrequency ( type: esriFieldTypeDouble, alias: HotSpotFrequency )

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

  Iteminfo   Thumbnail   Metadata