View In:   ArcGIS Online Map Viewer

Name: Storm Drain Mains - Abandoned

Display Field: Material

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 843675033281497bb730f92f96478d66

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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: true

Supports Datum Transformation: true

Extent:

XMin: 1588779.7143755257
YMin: 7185779.338826358
XMax: 1627221.3159698546
YMax: 7230098.267904848
Spatial Reference: 102743  (3566)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FlowCheck
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [215, 215, 158, 255]
Width: 3
Default Label: Other
UniqueValueInfos:
• Value: No
  Label: Flow Check - No
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [215, 215, 158, 255]
  Width: 3
• Value: Yes
  Label: Flow Check - Yes
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [168, 168, 0, 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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: FlowCheck

Fields:

• HasRoots ( type: esriFieldTypeString, alias: Has Roots?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: HasRoots , Coded Values: [Yes: Yes] , [No: No] )
• DateRootsTreated ( type: esriFieldTypeDate, alias: Date Roots Treated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateRootsTreated )
• RootsTreatedBy ( type: esriFieldTypeString, alias: Roots Treated By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RootsTreatedBy , Coded Values: [On-Call: On-Call] , [Tyler Argyle: Tyler Argyle] , [Brandon Johnson: Brandon Johnson] )
• LinkedFiles ( type: esriFieldTypeString, alias: Linked Files, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LinkedFiles )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MATERIAL , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Concrete: Concrete] , ...14 more... )
• MaterialAcronym ( type: esriFieldTypeString, alias: Material Acronym, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MATERIALSY , Coded Values: [C: C] , [CMP: CMP] , [ADS: ADS] , ...14 more... )
• FlowDirection ( type: esriFieldTypeString, alias: Flow Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Flow_Dir , Coded Values: [N: N] , [S: S] , [E: E] , ...6 more... )
• FlowCheck ( type: esriFieldTypeString, alias: Flow Check, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Flow_Check , Coded Values: [Yes: Yes] , [No: No] )
• Videoed ( type: esriFieldTypeString, alias: Videoed?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Video , Coded Values: [Yes: Yes] , [No: No] )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Hyperlink )
• Capacity ( type: esriFieldTypeDouble, alias: Capacity, editable: true, nullable: true, defaultValue: null, modelName: Capacity )
• Ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FromMH , Coded Values: [Public: Public] , [Private: Private] , [Mapleton: Mapleton] , ...2 more... )
• MHFlowLineUp ( type: esriFieldTypeDouble, alias: MH FlowLine Up, editable: true, nullable: true, defaultValue: null, modelName: Pipe1Elev )
• MHFlowLineDown ( type: esriFieldTypeDouble, alias: MH FlowLine Down, editable: true, nullable: true, defaultValue: null, modelName: Pipe2Elev )
• ElevationChange ( type: esriFieldTypeDouble, alias: Elevation Change, editable: true, nullable: true, defaultValue: null, modelName: ElevChange )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
• CFS ( type: esriFieldTypeDouble, alias: CFS, editable: true, nullable: true, defaultValue: null, modelName: CFS )
• MainType ( type: esriFieldTypeString, alias: Main Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Trunk , Coded Values: [TrunkLine: TrunkLine] , [Collector: Collector] , [LID Connector: LID Connector] )
• addfeats_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: addfeats_user )
• addfeats_date ( type: esriFieldTypeDate, alias: Date Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: addfeats_date )
• editfeats_user ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: editfeats_user )
• editfeats_date ( type: esriFieldTypeDate, alias: Date Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: editfeats_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Abandoned ( type: esriFieldTypeString, alias: Abandoned, editable: true, nullable: true, length: 10, defaultValue: No, modelName: Ownership , Coded Values: [Yes: Yes] , [No: No] )
• LastCleanedBy ( type: esriFieldTypeString, alias: Last Cleaned By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CleanedBy , Coded Values: [On-Call: On-Call] , [Tyler Argyle: Tyler Argyle] , [Brandon Johnson: Brandon Johnson] )
• LastDateCleaned ( type: esriFieldTypeDate, alias: Last Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCleaned )
• NotesConcerns ( type: esriFieldTypeString, alias: Notes & Concerns, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NotesConcerns )
• YearInstalled ( type: esriFieldTypeSmallInteger, alias: Year Installed, editable: true, nullable: true, defaultValue: null, modelName: YearInstalled )
• VideoDate ( type: esriFieldTypeDate, alias: Video Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VideoDate )
• UpdateMaps ( type: esriFieldTypeString, alias: Update Maps?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: UpdateMaps , Coded Values: [Yes: Yes] , [No: No] )
• UID ( type: esriFieldTypeString, alias: UID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UID )
• PACPCode ( type: esriFieldTypeString, alias: PACP Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PACPCode , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...23 more... )
• PipeShape ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PipeShape , Coded Values: [A: Arched (with flat bottom)] , [B: Barrel (e.g. beer barrel shape)] , [C: Circular] , ...8 more... )
• LastDateVideoed ( type: esriFieldTypeDate, alias: Last Date Videoed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastDateVideoed )
• LastVideoedBy ( type: esriFieldTypeString, alias: Last Videoed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastVideoedBy , Coded Values: [On-Call: On-Call] , [Tyler Argyle: Tyler Argyle] , [Brandon Johnson: Brandon Johnson] )
• LengthInFeet ( type: esriFieldTypeDouble, alias: Length In Feet, editable: true, nullable: true, defaultValue: null, modelName: LengthInFeet )
• LengthFt ( type: esriFieldTypeDouble, alias: LengthFt, editable: true, nullable: true, defaultValue: null, modelName: LengthFt )
• DateInstalled ( type: esriFieldTypeDate, alias: DateInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: No
Name: Flow Check - No
Domains:
• HasRoots:
  Inherited
• RootsTreatedBy:
  Inherited
• Material:
  Inherited
• MaterialAcronym:
  Inherited
• FlowDirection:
  Inherited
• FlowCheck:
  Inherited
• Videoed:
  Inherited
• Ownership:
  Inherited
• MainType:
  Inherited
• Abandoned:
  Inherited
• LastCleanedBy:
  Inherited
• UpdateMaps:
  Inherited
• PACPCode:
  Inherited
• PipeShape:
  Inherited
• LastVideoedBy:
  Inherited
Templates:
• Name: Flow Check - No
  Description:
  Prototype:
  LengthFt: null
  FlowDirection: null
  VideoDate: null
  DateInstalled: null
  HasRoots: No
  DateRootsTreated: null
  RootsTreatedBy: null
  LinkedFiles: null
  Diameter: null
  Material: null
  MaterialAcronym: null
  FlowCheck: No
  Videoed: null
  Hyperlink: null
  Capacity: null
  Ownership: null
  MHFlowLineUp: null
  MHFlowLineDown: null
  ElevationChange: null
  Slope: null
  CFS: null
  MainType: null
  LengthInFeet: null
  LastVideoedBy: null
  LastDateVideoed: null
  PipeShape: null
  Abandoned: No
  LastCleanedBy: null
  LastDateCleaned: null
  NotesConcerns: null
  YearInstalled: null
  UpdateMaps: No
  UID: null
  PACPCode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Yes
Name: Flow Check - Yes
Domains:
• HasRoots:
  Inherited
• RootsTreatedBy:
  Inherited
• Material:
  Inherited
• MaterialAcronym:
  Inherited
• FlowDirection:
  Inherited
• FlowCheck:
  Inherited
• Videoed:
  Inherited
• Ownership:
  Inherited
• MainType:
  Inherited
• Abandoned:
  Inherited
• LastCleanedBy:
  Inherited
• UpdateMaps:
  Inherited
• PACPCode:
  Inherited
• PipeShape:
  Inherited
• LastVideoedBy:
  Inherited
Templates:
• Name: Flow Check - Yes
  Description:
  Prototype:
  LengthFt: null
  FlowDirection: null
  VideoDate: null
  DateInstalled: null
  HasRoots: No
  DateRootsTreated: null
  RootsTreatedBy: null
  LinkedFiles: null
  Diameter: null
  Material: null
  MaterialAcronym: null
  FlowCheck: Yes
  Videoed: null
  Hyperlink: null
  Capacity: null
  Ownership: null
  MHFlowLineUp: null
  MHFlowLineDown: null
  ElevationChange: null
  Slope: null
  CFS: null
  MainType: null
  LengthInFeet: null
  LastVideoedBy: null
  LastDateVideoed: null
  PipeShape: null
  Abandoned: No
  LastCleanedBy: null
  LastDateCleaned: null
  NotesConcerns: null
  YearInstalled: null
  UpdateMaps: No
  UID: null
  PACPCode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• Utilities.DBO.StormDrainMainCleaningsRT (5) -- Related To: StormDrainMainCleaningsRT (2158)

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: addfeats_date
• Creator Field: addfeats_user
• Edit Date Field: editfeats_date
• Editor Field: editfeats_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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