View In:   ArcGIS Online Map Viewer

Name: Storm Mains

Display Field: FacilityID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Storm Mains

Service Item Id: e657e3901c294ac29db2ee7ba7fa71e0

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000

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: 476968.48685433716
YMin: 241643.9914700091
XMax: 514074.3489941694
YMax: 296202.4729040116
Spatial Reference: 103453  (8128)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: StormMainType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: 2
  Label: Lead
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: 3
  Label: Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 112, 0, 255]
  Width: 2
• Value: 5
  Label: Drain Tile
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 1
• Value: 4
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 0, 0, 255]
  Width: 4
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2500.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: StormMainType

Fields:

• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: false, nullable: true, length: 25, defaultValue: null, modelName: FacilityID )
• StormMainType ( type: esriFieldTypeInteger, alias: Storm Main Type, editable: false, nullable: true, defaultValue: 1, modelName: StormMainType )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• InstallContractor ( type: esriFieldTypeString, alias: Install Contractor, editable: false, nullable: true, length: 10, defaultValue: null, modelName: InstallContractor , Coded Values: [City: City] , [Fox: RT Fox] , [Henshue: Henshue] , ...12 more... )
• Inspector ( type: esriFieldTypeString, alias: Inspector Name, editable: false, nullable: true, length: 25, defaultValue: null, modelName: Inspector , Coded Values: [JensonS: Steve Jenson] , [JorgensonD: Dewey Jorgenson] , [McLeanP: Pat McLean] , ...22 more... )
• StreetName ( type: esriFieldTypeString, alias: Street Name, editable: false, nullable: true, length: 50, defaultValue: null, modelName: StreetName )
• Source ( type: esriFieldTypeString, alias: Location Source, editable: false, nullable: true, length: 15, defaultValue: null, modelName: Source , Coded Values: [Aerial: Aerial] , [Approximate: Approximate] , [Asbuilt: Asbuilt] , ...6 more... )
• Diameter ( type: esriFieldTypeInteger, alias: Diameter, editable: false, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [12: 12"] , [18: 18"] , [21: 21"] , ...51 more... )
• PipeMaterial ( type: esriFieldTypeString, alias: Pipe Material, editable: false, nullable: true, length: 30, defaultValue: null, modelName: PipeMaterial , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CD: Cast Ductile Iron] , ...18 more... )
• MaterialLabel ( type: esriFieldTypeString, alias: Material Label, editable: false, nullable: true, length: 15, defaultValue: null, modelName: MaterialLabel , Coded Values: [CI STM: CI STM] , [CMP STM: CMP STM] , [CON STM: CON STM] , ...6 more... )
• AsbuiltLength ( type: esriFieldTypeDouble, alias: Asbuilt Length, editable: false, nullable: true, defaultValue: null, modelName: AsbuiltLength )
• UpstreamFacility ( type: esriFieldTypeString, alias: Upstream Facility, editable: false, nullable: true, length: 10, defaultValue: null, modelName: UpstreamFacility )
• UpstreamElevation ( type: esriFieldTypeDouble, alias: Upstream Invert, editable: false, nullable: true, defaultValue: null, modelName: UpstreamElevation )
• DownstreamFacility ( type: esriFieldTypeString, alias: Downstream Facility, editable: false, nullable: true, length: 10, defaultValue: null, modelName: DownstreamFacility )
• DownstreamElevation ( type: esriFieldTypeDouble, alias: Downstream Invert, editable: false, nullable: true, defaultValue: null, modelName: DownstreamElevation )
• DownstreamDirection ( type: esriFieldTypeString, alias: Downstream Direction, editable: false, nullable: true, length: 2, defaultValue: null, modelName: DownstreamDirection , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: false, nullable: true, defaultValue: null, modelName: Slope )
• AsbPlansImages ( type: esriFieldTypeString, alias: Asbuilt Plans Images, editable: false, nullable: true, length: 175, defaultValue: null, modelName: AsbPlansImages )
• AsbNotesImages ( type: esriFieldTypeString, alias: Asbuilt Notes Images, editable: false, nullable: true, length: 175, defaultValue: null, modelName: AsbNotesImages )
• EditorComments ( type: esriFieldTypeString, alias: Editor Comments, editable: false, nullable: true, length: 100, defaultValue: null, modelName: EditorComments )
• LastUpdate ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 25, defaultValue: null, modelName: LastEditor , Coded Values: [BenzK: Kirby Benz] , [BlumerB: Brad Blumer] , [DuerrM: Margaret Duerr] , ...29 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• IsLined ( type: esriFieldTypeSmallInteger, alias: Is Lined, editable: false, nullable: true, defaultValue: null, modelName: IsLined , Coded Values: [0: No] , [1: Yes] )
• LiningType ( type: esriFieldTypeString, alias: Lining Type, editable: false, nullable: true, length: 15, defaultValue: null, modelName: LiningType )
• LiningDate ( type: esriFieldTypeDate, alias: Date Lined, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LiningDate )
• LiningContract ( type: esriFieldTypeString, alias: Lining Contract Number, editable: false, nullable: true, length: 10, defaultValue: null, modelName: LiningContract )
• LiningContractor ( type: esriFieldTypeString, alias: Lining Contractor, editable: false, nullable: true, length: 30, defaultValue: null, modelName: LiningContractor , Coded Values: [City: City] , [Fox: RT Fox] , [Great Lakes: Great Lakes Tv Seal] , ...19 more... )
• LiningComments ( type: esriFieldTypeString, alias: Lining Comments, editable: false, nullable: true, length: 100, defaultValue: null, modelName: LiningComments )
• IsTelevised ( type: esriFieldTypeSmallInteger, alias: Is Televised, editable: false, nullable: true, defaultValue: null, modelName: IsTelevised , Coded Values: [0: No] , [1: Yes] )
• TelevisedDate ( type: esriFieldTypeDate, alias: Date Televised, editable: false, nullable: true, length: 8, defaultValue: null, modelName: TelevisedDate )
• TelevisedContractor ( type: esriFieldTypeString, alias: Televised Contractor, editable: false, nullable: true, length: 30, defaultValue: null, modelName: TelevisedContractor , Coded Values: [City: City] , [Fox: RT Fox] , [Great Lakes: Great Lakes Tv Seal] , ...19 more... )
• TelevisingComments ( type: esriFieldTypeString, alias: Televising Comments, editable: false, nullable: true, length: 100, defaultValue: null, modelName: TelevisingComments )
• MediaReports ( type: esriFieldTypeString, alias: Media Reports, editable: false, nullable: true, length: 15, defaultValue: null, modelName: MediaReports )
• TVSurveyReport ( type: esriFieldTypeString, alias: TV Survey Report, editable: false, nullable: true, length: 175, defaultValue: null, modelName: TVSurveyReport )
• LiningTVReport ( type: esriFieldTypeString, alias: Lining TV Report, editable: false, nullable: true, length: 175, defaultValue: null, modelName: LiningTVReport )
• VideoPath ( type: esriFieldTypeString, alias: Video Path, editable: false, nullable: true, length: 175, defaultValue: null, modelName: VideoPath )
• VideoPath2 ( type: esriFieldTypeString, alias: Video Path 2, editable: false, nullable: true, length: 175, defaultValue: null, modelName: VideoPath2 )
• VideoPath3 ( type: esriFieldTypeString, alias: Video Path 3, editable: false, nullable: true, length: 175, defaultValue: null, modelName: VideoPath3 )
• StructuralPipeRating ( type: esriFieldTypeSmallInteger, alias: Structural Pipe Rating, editable: false, nullable: true, defaultValue: null, modelName: StructuralPipeRating )
• OMPipeRating ( type: esriFieldTypeSmallInteger, alias: O&M Pipe Rating, editable: false, nullable: true, defaultValue: null, modelName: OMPipeRating )
• LastActivity ( type: esriFieldTypeString, alias: Last Activity, editable: false, nullable: true, length: 4, defaultValue: null, modelName: LastActivity , Coded Values: [INSP: Inspection/Maintenance] , [RPR: Repair] , [UPDT: Update Info] , ...1 more... )
• ActivityDate ( type: esriFieldTypeDate, alias: Activity Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: ActivityDate )
• CleanedDate ( type: esriFieldTypeDate, alias: Cleaned Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CleanedDate )
• ActivityBy ( type: esriFieldTypeString, alias: Activity By, editable: false, nullable: true, length: 100, defaultValue: null, modelName: ActivityBy )
• ActivityComments ( type: esriFieldTypeString, alias: Activity Comments, editable: false, nullable: true, length: 200, defaultValue: null, modelName: ActivityComments )
• Sediment ( type: esriFieldTypeString, alias: Sediment, editable: false, nullable: true, length: 4, defaultValue: null, modelName: Sediment , Coded Values: [NONE: None] , [L: Light] , [M: Medium] , ...1 more... )
• FlowDescription ( type: esriFieldTypeString, alias: Flow Description, editable: false, nullable: true, length: 4, defaultValue: null, modelName: FlowDescription , Coded Values: [NONE: None] , [L: Light] , [M: Medium] , ...1 more... )
• Roots ( type: esriFieldTypeString, alias: Roots, editable: false, nullable: true, length: 4, defaultValue: null, modelName: Roots , Coded Values: [NONE: None] , [L: Light] , [M: Medium] , ...1 more... )
• OperationalStatus ( type: esriFieldTypeString, alias: Operational Status, editable: false, nullable: true, length: 4, defaultValue: null, modelName: OperationalStatus , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...7 more... )
• PipeConditionRating ( type: esriFieldTypeString, alias: City Pipe Condition Rating, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PipeConditionRating , Coded Values: [5: 5 - Like New] , [4: 4 - Good] , [3: 3 - Average] , ...3 more... )
• JointConditionRating ( type: esriFieldTypeString, alias: City Joint Condition Rating, editable: false, nullable: true, length: 50, defaultValue: null, modelName: JointConditionRating , Coded Values: [5: 5 - Like New] , [4: 4 - Good] , [3: 3 - Average] , ...3 more... )
• GroundWater ( type: esriFieldTypeString, alias: Ground Water, editable: false, nullable: true, length: 4, defaultValue: null, modelName: GroundWater , Coded Values: [NONE: None] , [L: Light] , [M: Medium] , ...1 more... )
• CrossBore ( type: esriFieldTypeSmallInteger, alias: Cross Bore, editable: false, nullable: true, defaultValue: null, modelName: CrossBore , Coded Values: [0: No] , [1: Yes] )
• NeedRepair ( type: esriFieldTypeSmallInteger, alias: Need Repair, editable: false, nullable: true, defaultValue: null, modelName: NeedRepair , Coded Values: [0: No] , [1: Yes] )
• FieldLinkedDocument ( type: esriFieldTypeString, alias: Field Linked Document, editable: false, nullable: true, length: 500, defaultValue: null, modelName: FieldLinkedDocument )
• SDELinkedDocument ( type: esriFieldTypeString, alias: SDE Linked Document, editable: false, nullable: true, length: 500, defaultValue: null, modelName: SDELinkedDocument )
• LinkedDocument ( type: esriFieldTypeString, alias: Linked Document, editable: false, nullable: true, length: 300, defaultValue: null, modelName: LinkedDocument )
• LinkedDocument2 ( type: esriFieldTypeString, alias: Linked Document 2, editable: false, nullable: true, length: 300, defaultValue: null, modelName: LinkedDocument2 )
• LinkedDocument3 ( type: esriFieldTypeString, alias: Linked Document 3, editable: false, nullable: true, length: 300, defaultValue: null, modelName: LinkedDocument3 )
• LinkedDocument4 ( type: esriFieldTypeString, alias: Linked Document 4, editable: false, nullable: true, length: 300, defaultValue: null, modelName: LinkedDocument4 )
• LinkedDocument5 ( type: esriFieldTypeString, alias: Linked Document 5, editable: false, nullable: true, length: 300, defaultValue: null, modelName: LinkedDocument5 )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape Length, editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• USVerticalOffset ( type: esriFieldTypeDouble, alias: Upstream Vertical Offset, editable: false, nullable: true, defaultValue: null, modelName: USVerticalOffset )
• DSVerticalOffset ( type: esriFieldTypeDouble, alias: Downstream Vertical Offset, editable: false, nullable: true, defaultValue: null, modelName: DSVerticalOffset )
• CleanedFootage ( type: esriFieldTypeDouble, alias: Cleaned Footage, editable: false, nullable: true, defaultValue: null, modelName: CleanedFootage )
• IsPointRepaired ( type: esriFieldTypeSmallInteger, alias: Is Point Repaired, editable: false, nullable: true, defaultValue: null, modelName: IsPointRepaired , Coded Values: [0: No] , [1: Yes] )
• PointRepairDate ( type: esriFieldTypeDate, alias: Date Point Repaired, editable: false, nullable: true, length: 8, defaultValue: null, modelName: PointRepairDate )
• PointRepairContract ( type: esriFieldTypeString, alias: Point Repair Contract Number, editable: false, nullable: true, length: 10, defaultValue: null, modelName: PointRepairContract )
• PointRepairContractor ( type: esriFieldTypeString, alias: Point Repair Contractor, editable: false, nullable: true, length: 30, defaultValue: null, modelName: PointRepairContractor , Coded Values: [City: City] , [Fox: RT Fox] , [Great Lakes: Great Lakes Tv Seal] , ...19 more... )
• PointRepairComments ( type: esriFieldTypeString, alias: Point Repair Comments, editable: false, nullable: true, length: 100, defaultValue: null, modelName: PointRepairComments )
• OwnedBy ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: false, nullable: true, defaultValue: 1, modelName: OwnedBy , Coded Values: [1: City of Janesville] , [2: Alliant Energy] , [3: Rock County Electric] , ...3 more... )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: Creator )
• CreationDate ( type: esriFieldTypeDate, alias: Creation Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 255, defaultValue: null, modelName: Editor )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )

Types:

ID: 1
Name: Main
Domains:
• InstallContractor:
  Inherited
• Inspector:
  Inherited
• Source:
  Inherited
• Diameter:
  Inherited
• PipeMaterial:
  Inherited
• MaterialLabel:
  Inherited
• DownstreamDirection:
  Inherited
• LastEditor:
  Inherited
• IsLined:
  Inherited
• IsTelevised:
  Inherited
• OwnedBy:
  Inherited
Templates:
• Name: Main
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Main (1)
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Lead
Domains:
• InstallContractor:
  Inherited
• Inspector:
  Inherited
• Source:
  Inherited
• Diameter:
  Inherited
• PipeMaterial:
  Inherited
• MaterialLabel:
  Inherited
• DownstreamDirection:
  Inherited
• LastEditor:
  Inherited
• IsLined:
  Inherited
• IsTelevised:
  Inherited
• OwnedBy:
  Inherited
Templates:
• Name: Lead
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Lead (1)
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Culvert
Domains:
• InstallContractor:
  Inherited
• Inspector:
  Inherited
• Source:
  Inherited
• Diameter:
  Inherited
• PipeMaterial:
  Inherited
• MaterialLabel:
  Inherited
• DownstreamDirection:
  Inherited
• LastEditor:
  Inherited
• IsLined:
  Inherited
• IsTelevised:
  Inherited
• OwnedBy:
  Inherited
Templates:
• Name: Culvert
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Culvert (1)
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Drain Tile
Domains:
• InstallContractor:
  Inherited
• Inspector:
  Inherited
• Source:
  Inherited
• Diameter:
  Inherited
• PipeMaterial:
  Inherited
• MaterialLabel:
  Inherited
• DownstreamDirection:
  Inherited
• LastEditor:
  Inherited
• OwnedBy:
  Inherited
Templates:
• Name: Drain Tile
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Drain Tile (1)
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Private
Domains:
• InstallContractor:
  Inherited
• Inspector:
  Inherited
• Source:
  Inherited
• Diameter:
  Inherited
• PipeMaterial:
  Inherited
• MaterialLabel:
  Inherited
• DownstreamDirection:
  Inherited
• LastEditor:
  Inherited
• OwnedBy:
  Inherited
Templates:
• Name: Private
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Private (1)
  Description:
  Prototype:
  isvariable: 0
  activeflag: 1
  qcflag: 0
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata