Name: COLEGEODEV.DBO.Pipe

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Function FindLabel ( [DIAMETER], [MAT_LBL], [DwgNo], [Slope], [PipeLength] ) FindLabel = [DIAMETER] & " " & [MAT_LBL] & " " & [DwgNo] & vbnnewline & [Slope] & " " & [PipeLength] & " ft." End Function

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 6207460.2224233
YMin: 2170612.990450144
XMax: 6267276.81735681
YMax: 2210950.4563629776
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PIPETYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Collector
  Label: Collector
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 5
• Value: Lateral
  Label: Lateral
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [250, 52, 17, 255]
  Width: 1
• Value: TransitionStructure
  Label: TransitionStructure
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 127, 127, 255]
  Width: 1
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: Proposed
  Label: Proposed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [158, 187, 215, 255]
  Width: 3
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

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type , Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...32 more... )
• diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...41 more... )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation )
• slope ( type: esriFieldTypeDouble, alias: Slope )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: Our Agency] , [100: Other] , [2: Private] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• pipeshape ( type: esriFieldTypeSmallInteger, alias: Shape , Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more... )
• type ( type: esriFieldTypeSmallInteger, alias: Type , Coded Values: [0: Unknown] , [1: Gravity] , [2: Perforated] )
• lined ( type: esriFieldTypeSmallInteger, alias: Lined? , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• lineryear ( type: esriFieldTypeSmallInteger, alias: Liner Year , Range: [1800, 2060] )
• linermethod ( type: esriFieldTypeSmallInteger, alias: Liner Method , Coded Values: [0: Unknown] , [1: Cured in Place Pipe - CIP] , [2: Fold and Form or Deform/Reform - FF] , ...11 more... )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Life Cycle Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Proposed - Approved] , ...4 more... )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• MATERIAL ( type: esriFieldTypeString, alias: Material, length: 20 )
• MAINSHAPE ( type: esriFieldTypeString, alias: Main Shape, length: 50 )
• PIPETYPE ( type: esriFieldTypeString, alias: Pipe Type, length: 50 )
• LINEDYEAR ( type: esriFieldTypeString, alias: Year Lined, length: 4 )
• LINERTYPE ( type: esriFieldTypeString, alias: Liner Type, length: 20 )
• FROMMH ( type: esriFieldTypeString, alias: From Manhole, length: 11 )
• TOMH ( type: esriFieldTypeString, alias: To Manhole, length: 11 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary )
• FeatureType ( type: esriFieldTypeString, alias: FeatureType, length: 30 )
• FeatureID ( type: esriFieldTypeString, alias: FeatureID, length: 20 )
• CrossSectionShape ( type: esriFieldTypeString, alias: CrossSectionShape, length: 20 )
• Diameter_Height ( type: esriFieldTypeInteger, alias: Diameter_Height )
• LeftSS ( type: esriFieldTypeString, alias: LeftSS, length: 10 )
• RightSS ( type: esriFieldTypeString, alias: RightSS, length: 10 )
• BaseWidth ( type: esriFieldTypeInteger, alias: BaseWidth )
• Pier ( type: esriFieldTypeDouble, alias: Pier )
• DwgNo ( type: esriFieldTypeString, alias: DwgNo, length: 50 )
• UpStreamInvert ( type: esriFieldTypeDouble, alias: UpStreamInvert )
• DownStreamInvert ( type: esriFieldTypeDouble, alias: DownStreamInvert )
• PipeLength ( type: esriFieldTypeDouble, alias: PipeLength )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 20 )
• Status ( type: esriFieldTypeString, alias: Status, length: 20 )
• Source ( type: esriFieldTypeString, alias: Source, length: 20 )
• GridNo ( type: esriFieldTypeString, alias: GridNo, length: 15 )
• LaserFiche_Scan_No ( type: esriFieldTypeString, alias: LaserFiche_Scan_No, length: 50 )
• Asbuilt ( type: esriFieldTypeSmallInteger, alias: Asbuilt )
• Barcode ( type: esriFieldTypeString, alias: Barcode, length: 255 )
• SheetNo ( type: esriFieldTypeString, alias: SheetNo, length: 255 )
• Offset ( type: esriFieldTypeString, alias: Offset, length: 10 )
• DigitizedMethod ( type: esriFieldTypeSmallInteger, alias: DigitizedMethod )
• DesignFlowRate ( type: esriFieldTypeDouble, alias: DesignFlowRate )
• PipeAge ( type: esriFieldTypeString, alias: PipeAge, length: 4 )
• GeoTiff ( type: esriFieldTypeString, alias: GeoTiff, length: 50 )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 100 )
• Q10 ( type: esriFieldTypeDouble, alias: Q10 )
• Q50 ( type: esriFieldTypeDouble, alias: Q50 )
• Q100 ( type: esriFieldTypeDouble, alias: Q100 )
• sdStormMainType ( type: esriFieldTypeInteger, alias: sdStormMainType )
• MAT_LBL ( type: esriFieldTypeString, alias: MAT_LBL, length: 10 )
• PIPESZ_LBL ( type: esriFieldTypeSmallInteger, alias: PIPESZ_LBL )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength() )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata