Parent Layer: Lines

Name: WVC LINES

Display Field: LINETYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This storm drain network dataset was derived from an original storm drain dataset and invert data kept in a separate database. The datasets were combined in order to calculate slope for each pipe. Calculations for Slope, Bearing, Direction :SLOPE:F_ELEV IS NOT NULL AND F_INVERT >0 AND T_ELEV IS NOT NULL AND T_INVERT >0(((F_ELEV-F_INVERT) - (T_ELEV-T_INVERT))/Length)*100BEARING:WHERE:"FX" = X coordinate of starting point of line "FY" = Y coordinate of starting point of line "TX" = X coordinate of ending point of line "TY" = Y coordinate of ending point of lineIn QGIS(atan(("TX"-"FX")/("TY"-"FY"))) * 180/3.14159 + (180 *((("TY"-"FY") 0)*2)))DIRECTION:CASE WHEN "BEARING" >337.5 THEN 'N'WHEN "BEARING" >=0 AND "BEARING"22.5 AND "BEARING"67.5 AND "BEARING"112.5 AND "BEARING"157.5 AND "BEARING"202.5 AND "BEARING"247.5 AND "BEARING"292.5 AND "BEARING"<337.5 THEN 'NW'END

Service Item Id: e99e5ed671d7440187f8de370ce85cb2

Copyright Text: Chad Bunn, Robert Zito

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 30000.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: 1462701.5508498847
YMin: 7398953.61588898
XMax: 1523365.017449215
YMax: 7440482.132569313
Spatial Reference: 102743  (3566)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNER_LINE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: WVC SD
  Label: WVC Storm Drain
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: WVC OC
  Label: WVC Open Channel
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: WVC IRR
  Label: WVC IRR
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 112, 255, 255]
  Width: 2
• Value: WVC SUB
  Label: WVC Subdrain
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: WVC RD
  Label: WVC RD
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 112, 255, 255]
  Width: 0
• Value: WVC LD
  Label: WVC LD
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 112, 255, 255]
  Width: 2
• Value: WVC SEWER
  Label: WVC SEWER
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [PIPE_SIZE] CONCAT " : " CONCAT [PIPETYPE]
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: 9
Font Family: Arial
Font Style: italic
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• PIPE_ID ( type: esriFieldTypeInteger, alias: PIPE_ID )
• LINETYPE ( type: esriFieldTypeString, alias: LINETYPE, length: 25 )
• FLOWDIR ( type: esriFieldTypeString, alias: FLOWDIR, length: 2 )
• PIPETYPE ( type: esriFieldTypeString, alias: PIPETYPE, length: 25 )
• DATE ( type: esriFieldTypeString, alias: DATE, length: 10 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 10 )
• PIPE_SIZE ( type: esriFieldTypeString, alias: PIPE_SIZE, length: 8 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 10 )
• Cond_Date ( type: esriFieldTypeDate, alias: Cond_Date, length: 8 )
• OWNER_LINE ( type: esriFieldTypeString, alias: OWNER_LINE, length: 50 )
• QUESTIONS ( type: esriFieldTypeString, alias: QUESTIONS, length: 250 )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, length: 38 )
• FROM_TO ( type: esriFieldTypeString, alias: FROM_TO, length: 20 )
• FBOXID ( type: esriFieldTypeString, alias: FBOXID, length: 254 )
• FLIDAR_ELE ( type: esriFieldTypeDouble, alias: FLIDAR_ELE )
• F_ELEV ( type: esriFieldTypeDouble, alias: F_ELEV )
• F_INVERT ( type: esriFieldTypeString, alias: F_INVERT, length: 254 )
• TBOXID ( type: esriFieldTypeString, alias: TBOXID, length: 254 )
• TLIDAR_ELE ( type: esriFieldTypeDouble, alias: TLIDAR_ELE )
• T_ELEV ( type: esriFieldTypeDouble, alias: T_ELEV )
• T_INVERT ( type: esriFieldTypeString, alias: T_INVERT, length: 254 )
• SLOPE ( type: esriFieldTypeDouble, alias: SLOPE )
• SLOPE_LIDR ( type: esriFieldTypeDouble, alias: SLOPE_LIDR )
• SLOPE_DIFF ( type: esriFieldTypeDouble, alias: SLOPE_DIFF )
• BEARING ( type: esriFieldTypeDouble, alias: BEARING )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, length: 10 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OnBase ( type: esriFieldTypeString, alias: OnBase, length: 254 )
• 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 )
• QualityControl ( type: esriFieldTypeString, alias: QualityControl, length: 255 )
• GNET_UID ( type: esriFieldTypeString, alias: GNET_UID, length: 50 )
• GNET_SIZE ( type: esriFieldTypeInteger, alias: GNET_SIZE )
• GNET_LENGTH ( type: esriFieldTypeDouble, alias: GNET_LENGTH )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )

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

  Iteminfo   Thumbnail   Metadata