View In:   ArcGIS Online Map Viewer

Parent Layer: Archived Assets

Name: Archived Gravity Mains

Display Field: FacilityID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 6044690.874328613
YMin: 1840466.0986938477
XMax: 1.7320822831115723E7
YMax: 2203221.1876831055
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 127, 127, 255]
Width: 1
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: "" CONCAT [FacilityID] CONCAT "" CONCAT NEWLINE CONCAT ROUND([Shape_Length],0) CONCAT " " CONCAT [Material] CONCAT " " CONCAT [NominalDiameter]
Use Coded Values: true
Symbol:
Color: [255, 127, 127, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• Subtype ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: Subtype )
• AdministrativeArea ( type: esriFieldTypeString, alias: AdministrativeArea, editable: true, nullable: true, length: 60, defaultValue: Unknown, modelName: AdministrativeArea , Coded Values: [ECO: ECO] , [Unknown: Unknown] , [Other: Other] , ...5 more... )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• OperationalArea ( type: esriFieldTypeString, alias: OperationalArea, editable: true, nullable: true, length: 60, defaultValue: Unk, modelName: OperationalArea )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...4 more... )
• WaterType ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 255, defaultValue: Sewage, modelName: WaterType , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 255, defaultValue: PVC, modelName: Material , Coded Values: [DI: Ductile Iron] , [CI: Cast Iron] , [PVC: Poly Vinyl Chloride] , ...8 more... )
• ExteriorCoating ( type: esriFieldTypeString, alias: ExteriorCoating, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ExteriorCoating )
• JointType1 ( type: esriFieldTypeString, alias: JointType1, editable: true, nullable: true, length: 20, defaultValue: Unk, modelName: JointType1 , Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...2 more... )
• JointType2 ( type: esriFieldTypeString, alias: JointType2, editable: true, nullable: true, length: 20, defaultValue: Unk, modelName: JointType2 , Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...2 more... )
• LiningType ( type: esriFieldTypeString, alias: LiningType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LiningType )
• PipeClass ( type: esriFieldTypeString, alias: PipeClass, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PipeClass )
• BarrelCount ( type: esriFieldTypeInteger, alias: BarrelCount, editable: true, nullable: true, defaultValue: null, modelName: BarrelCount )
• CrossSectionShape ( type: esriFieldTypeString, alias: CrossSectionShape, editable: true, nullable: true, length: 20, defaultValue: Circular, modelName: CrossSectionShape , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...1 more... )
• UpstreamInvert ( type: esriFieldTypeDouble, alias: UpstreamInvert, editable: true, nullable: true, defaultValue: null, modelName: UpstreamInvert )
• DownstreamInvert ( type: esriFieldTypeDouble, alias: DownstreamInvert, editable: true, nullable: true, defaultValue: null, modelName: DownstreamInvert )
• Measurement1 ( type: esriFieldTypeInteger, alias: Measurement1, editable: true, nullable: true, defaultValue: 0, modelName: Measurement1 , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...26 more... )
• Measurement2 ( type: esriFieldTypeInteger, alias: Measurement2, editable: true, nullable: true, defaultValue: 0, modelName: Measurement2 , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...26 more... )
• NominalDiameter ( type: esriFieldTypeInteger, alias: NominalDiameter, editable: true, nullable: true, defaultValue: 0, modelName: NominalDiameter , Coded Values: [1: 1 inch] , [2: 2 inch] , [4: 4 inch] , ...26 more... )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
• FROMNODE ( type: esriFieldTypeDouble, alias: FROMNODE, editable: true, nullable: true, defaultValue: null, modelName: FROMNODE )
• TONODE ( type: esriFieldTypeDouble, alias: TONODE, editable: true, nullable: true, defaultValue: null, modelName: TONODE )
• UpStrmMH ( type: esriFieldTypeString, alias: UpStrmMH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UpStrmMH )
• DnStrmMH ( type: esriFieldTypeString, alias: DnStrmMH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DnStrmMH )
• MapPage ( type: esriFieldTypeString, alias: MapPage, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MapPage )
• SourceDoc ( type: esriFieldTypeString, alias: SourceDoc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceDoc )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear, editable: true, nullable: true, defaultValue: null, modelName: InstallYear )
• SourceDoc2 ( type: esriFieldTypeString, alias: SourceDoc2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SourceDoc2 )
• Grid11X17 ( type: esriFieldTypeString, alias: Grid11X17, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Grid11X17 )
• AllCleanFreq ( type: esriFieldTypeDouble, alias: AllCleanFreq, editable: true, nullable: true, defaultValue: null, modelName: AllCleanFreq )
• Capacity_Half ( type: esriFieldTypeDouble, alias: Modeled Capacity (D/d=0.5) (gpd), editable: true, nullable: true, defaultValue: null, modelName: Capacity_Half )
• Capacity_75 ( type: esriFieldTypeDouble, alias: Modeled Capacity (D/d=0.75) (gpd), editable: true, nullable: true, defaultValue: null, modelName: Capacity_75 )
• FlowHeight ( type: esriFieldTypeDouble, alias: Modeled Flow Height (inches), editable: true, nullable: true, defaultValue: null, modelName: FlowHeight )
• FlowRatio ( type: esriFieldTypeDouble, alias: Modeled D/d, editable: true, nullable: true, defaultValue: null, modelName: FlowRatio )
• FlowSpiltFactor ( type: esriFieldTypeDouble, alias: Flow Split Factor (for Parallel Mains), editable: true, nullable: true, defaultValue: 1, modelName: FlowSpiltFactor )
• Roughness ( type: esriFieldTypeDouble, alias: Roughness Coefficient, editable: true, nullable: true, defaultValue: null, modelName: Roughness )
• Capacity_Full ( type: esriFieldTypeDouble, alias: Modeled Capacity (D/d=1) (gpd), editable: true, nullable: true, defaultValue: null, modelName: Capacity_Full )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationDescription )
• ServiceAreaID ( type: esriFieldTypeSmallInteger, alias: ServiceAreaID, editable: true, nullable: true, defaultValue: null, modelName: ServiceAreaID )
• Condition_Debris ( type: esriFieldTypeSmallInteger, alias: Debris Condition Rating, editable: true, nullable: true, defaultValue: null, modelName: Condition_Debris , Coded Values: [0: Zero] , [1: Light] , [2: Moderate] , ...1 more... )
• Condition_Grease ( type: esriFieldTypeSmallInteger, alias: Grease Condition Rating, editable: true, nullable: true, defaultValue: null, modelName: Condition_Grease , Coded Values: [0: Zero] , [1: Light] , [2: Moderate] , ...1 more... )
• Condition_Roots ( type: esriFieldTypeSmallInteger, alias: Roots Condition Rating, editable: true, nullable: true, defaultValue: null, modelName: Condition_Roots , Coded Values: [0: Zero] , [1: Light] , [2: Moderate] , ...1 more... )
• FlowRatioError ( type: esriFieldTypeString, alias: Flow Ratio Calculation Error, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FlowRatioError )
• Flow_Total_Capacity ( type: esriFieldTypeDouble, alias: Total Flow / Capacity, editable: true, nullable: true, defaultValue: null, modelName: Flow_Total_Capacity )
• Flow_Peak ( type: esriFieldTypeDouble, alias: Peak Flow (gpd), editable: true, nullable: true, defaultValue: null, modelName: Flow_Peak )
• Flow_Total ( type: esriFieldTypeDouble, alias: Total Flow (gpd), editable: true, nullable: true, defaultValue: null, modelName: Flow_Total )
• Flow_Average ( type: esriFieldTypeDouble, alias: Flow_Average, editable: true, nullable: true, defaultValue: null, modelName: Flow_Average )
• Inflow ( type: esriFieldTypeDouble, alias: Inflow, editable: true, nullable: true, defaultValue: null, modelName: Inflow )
• Grid11X17_100 ( type: esriFieldTypeString, alias: Grid11X17_100, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Grid11X17_100 )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GIS_Notes ( type: esriFieldTypeString, alias: GIS_Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GIS_Notes )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• Location_Street ( type: esriFieldTypeString, alias: Location_Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location_Street )
• Location_Notes ( type: esriFieldTypeString, alias: Location_Notes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location_Notes )
• InstallDate_Notes ( type: esriFieldTypeString, alias: InstallDate_Notes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InstallDate_Notes )
• Pipe_Line_Surge ( type: esriFieldTypeString, alias: Pipe_Line_Surge, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pipe_Line_Surge , Coded Values: [No: No] , [Yes: Yes] )
• PipeRating ( type: esriFieldTypeSmallInteger, alias: PipeRating, editable: true, nullable: true, defaultValue: null, modelName: PipeRating )

Templates:

• Name: Archived Gravity Mains
  Description:
  Prototype:
  Pipe_Line_Surge: null
  Enabled: 1
  Subtype: 1
  InstallDate: null
  OperationalArea: Unk
  LifecycleStatus: Active
  WaterType: Sewage
  ExteriorCoating: null
  JointType1: Unk
  BarrelCount: null
  DownstreamInvert: null
  Measurement1: 0
  Measurement2: 0
  FlowRatio: null
  AdministrativeArea: CMSD
  FacilityID: null
  Material: VCP
  JointType2: Unk
  LiningType: null
  PipeClass: null
  CrossSectionShape: Circular
  UpstreamInvert: null
  NominalDiameter: 0
  Slope: null
  FROMNODE: null
  TONODE: null
  UpStrmMH: null
  DnStrmMH: null
  MapPage: null
  SourceDoc: null
  InstallYear: null
  SourceDoc2: null
  Grid11X17: null
  AllCleanFreq: null
  Capacity_Half: null
  Capacity_75: null
  FlowHeight: null
  FlowSpiltFactor: 1
  Roughness: null
  Capacity_Full: null
  LocationDescription: null
  ServiceAreaID: null
  Condition_Debris: null
  Condition_Grease: null
  Condition_Roots: null
  FlowRatioError: null
  Flow_Total_Capacity: null
  Flow_Peak: null
  Flow_Total: null
  Flow_Average: null
  Inflow: null
  Grid11X17_100: null
  InstallDate_Notes: null
  Location_Notes: null
  Location_Street: null
  Location: null
  PipeRating: null
  GIS_Notes: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• CCTV_Inspections (0) -- Related To: Sewer.DBO.CCTV_Inspections (24)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata