View In:   ArcGIS Online map viewer

Name: Storm Mains

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: -107138600
YMin: -97193800
XMax: 1.3285153042650923E7
YMax: 383050.36384513974
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 170, 0, 255]
Width: 1
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [FACILITYID] CONCAT " - " CONCAT [DIAMETER] CONCAT "''" CONCAT NEWLINE CONCAT [MATERIAL]
Use Coded Values: false
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: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
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: 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 )
• FACILITYID ( type: esriFieldTypeString , alias: Facility Identifier , editable: true , nullable: true , length: 20 )
• INSTALLDATE ( type: esriFieldTypeDate , alias: Install Date , editable: true , nullable: true , length: 8 )
• MATERIAL ( type: esriFieldTypeString , alias: Material , editable: true , nullable: true , length: 20 )
• DIAMETER ( type: esriFieldTypeDouble , alias: Diameter , editable: true , nullable: true )
• MAINSHAPE ( type: esriFieldTypeString , alias: Main Shape , editable: true , nullable: true , length: 50 , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more... )
• PIPETYPE ( type: esriFieldTypeString , alias: Pipe Type , editable: true , nullable: true , length: 50 )
• LINEDYEAR ( type: esriFieldTypeString , alias: Year Lined , editable: true , nullable: true , length: 4 )
• LINERTYPE ( type: esriFieldTypeString , alias: Liner Type , editable: true , nullable: true , length: 20 , Coded Values: [NONE: None] , [OTH: Other] , [SW: Spiral Wound] , ...4 more... )
• DOWNELEV ( type: esriFieldTypeDouble , alias: Downstream Elevation , editable: true , nullable: true )
• UPELEV ( type: esriFieldTypeDouble , alias: Upstream Elevation , editable: true , nullable: true )
• SLOPE ( type: esriFieldTypeDouble , alias: Slope , editable: true , nullable: true )
• FROMMH ( type: esriFieldTypeString , alias: From Manhole , editable: true , nullable: true , length: 11 )
• TOMH ( type: esriFieldTypeString , alias: To Manhole , editable: true , nullable: true , length: 11 )
• ENABLED ( type: esriFieldTypeSmallInteger , alias: Enabled , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger , alias: Active Flag , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger , alias: Owned By , editable: true , nullable: true , Coded Values: [-2: Other] , [-1: Private] , [1: City of Brighton] , ...1 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger , alias: Managed By , editable: true , nullable: true , Coded Values: [-1: Private] , [-2: Other] , [1: City of Brighton] )
• SUMFLOW ( type: esriFieldTypeDouble , alias: Flow Summary , editable: true , nullable: true )
• Status ( type: esriFieldTypeString , alias: Status , editable: true , nullable: true , length: 30 , Coded Values: [Remote Inspection: Remote Inspection] , [Not Found: Not Found] , [Not Opened: Not Opened] , ...6 more... )
• Crew ( type: esriFieldTypeString , alias: Crew , editable: true , nullable: true , length: 25 , Coded Values: [Crew 1: Crew 1] , [Crew 2: Crew 2] , [Crew 3: Crew 3] )
• Material_1 ( type: esriFieldTypeString , alias: Material , editable: true , nullable: true , length: 25 , Coded Values: [Block: Block] , [Liner Material: Liner Material] , [Plastic: Plastic] , ...10 more... )
• Pipe_Diameter ( type: esriFieldTypeDouble , alias: Pipe_Diameter , editable: true , nullable: true )
• US_Severity ( type: esriFieldTypeString , alias: US_Severity , editable: true , nullable: true , length: 25 , Coded Values: [0: 0 Unknown] , [1: 1- Excellent] , [2: 2 - Good] , ...3 more... )
• DS_Severity ( type: esriFieldTypeString , alias: DS_Severity , editable: true , nullable: true , length: 25 , Coded Values: [0: 0 Unknown] , [1: 1- Excellent] , [2: 2 - Good] , ...3 more... )
• US_Measure ( type: esriFieldTypeDouble , alias: US_Measure , editable: true , nullable: true )
• DS_Measure ( type: esriFieldTypeDouble , alias: DS_Measure , editable: true , nullable: true )
• US_Defect ( type: esriFieldTypeString , alias: US_Defect , editable: true , nullable: true , length: 25 , Coded Values: [Grease: Grease] , [Mineral Deposits: Mineral Deposits] , [Collapsed Pipe: Collapsed Pipe] , ...13 more... )
• DS_Defect ( type: esriFieldTypeString , alias: DS_Defect , editable: true , nullable: true , length: 25 , Coded Values: [Grease: Grease] , [Mineral Deposits: Mineral Deposits] , [Collapsed Pipe: Collapsed Pipe] , ...13 more... )
• US_Comment ( type: esriFieldTypeString , alias: US_Comment , editable: true , nullable: true , length: 150 )
• DS_Comment ( type: esriFieldTypeString , alias: DS_Comment , editable: true , nullable: true , length: 150 )
• US_Photo ( type: esriFieldTypeString , alias: US_Photo , editable: true , nullable: true , length: 125 )
• DS_Photo ( type: esriFieldTypeString , alias: DS_Photo , editable: true , nullable: true , length: 125 )
• P_Drop ( type: esriFieldTypeString , alias: P_Drop , editable: true , nullable: true , length: 10 , Coded Values: [1: Yes] , [0: No] )
• Pipe_Width ( type: esriFieldTypeDouble , alias: Pipe_Width , editable: true , nullable: true )
• PipeAge ( type: esriFieldTypeString , alias: PipeAge , editable: true , nullable: true , length: 24 )
• CCTV ( type: esriFieldTypeString , alias: CCTV , editable: true , nullable: true , length: 8 )
• US_MH ( type: esriFieldTypeString , alias: US_MH , editable: true , nullable: true , length: 24 )
• DS_MH ( type: esriFieldTypeString , alias: DS_MH , editable: true , nullable: true , length: 24 )
• created_user ( type: esriFieldTypeString , alias: created_user , editable: false , nullable: true , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , editable: false , nullable: true , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , editable: false , nullable: true , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , editable: false , nullable: true , length: 8 )
• DS_Owner ( type: esriFieldTypeString , alias: DS_Owner , editable: true , nullable: true , length: 24 , Coded Values: [Waters of State: Waters of State] , [GCDC: Genesee County Drain Commission] , [Private: Privately Owned/Managed System] , ...4 more... )
• PipeOwner ( type: esriFieldTypeString , alias: PipeOwner , editable: true , nullable: true , length: 24 , Coded Values: [GCRC: Genesee County Road Commission] , [GCDC: Genesee County Drain Commission] , [Unk: Unknown] )
• Environmental_Impact ( type: esriFieldTypeSmallInteger , alias: Environmental_Impact , editable: true , nullable: true , Coded Values: [0: Not in Close Proximity to a Known Hazardous Site] , [1: Within 500' of a Known Hazardous Site] )
• PublicSafety_Impact ( type: esriFieldTypeSmallInteger , alias: PublicSafety_Impact , editable: true , nullable: true , Coded Values: [0: Greater than 500' from a Hospital] , [1: Within 500' of a Hospital] )
• Year_Installed ( type: esriFieldTypeSmallInteger , alias: Year_Installed , editable: true , nullable: true )
• EEL ( type: esriFieldTypeSmallInteger , alias: EEL , editable: true , nullable: true )
• RUL ( type: esriFieldTypeDouble , alias: %RUL , editable: true , nullable: true )
• ConditionRating ( type: esriFieldTypeSmallInteger , alias: ConditionRating , editable: true , nullable: true )
• POF_AgeFactor ( type: esriFieldTypeSmallInteger , alias: POF_AgeVAlue , editable: true , nullable: true , Coded Values: [0: NA] , [1: > 50% RUL] , [2: 10% - 50% RUL] , ...1 more... )
• POF_Material ( type: esriFieldTypeSmallInteger , alias: POF_Material , editable: true , nullable: true , Coded Values: [0: DIP, Concrete, PVC] , [2: Cast Iron] , [3: VCP] )
• COF_SizeFactor ( type: esriFieldTypeSmallInteger , alias: COF_SizeFactor , editable: true , nullable: true , Coded Values: [0: <= 10"] , [1: 11" - 15"] , [3: > 15"] )
• COF_SurfaceWaterImpact ( type: esriFieldTypeSmallInteger , alias: COF_SurfaceWaterImpact , editable: true , nullable: true , Coded Values: [0: Not Near Water Body] , [1: Within 50' River/100 Floodplain] , [3: Beneath River/Floodplain] )
• COF_TransportationImpact ( type: esriFieldTypeSmallInteger , alias: COF_TransportationImpact , editable: true , nullable: true , Coded Values: [0: Not under pavement] , [1: Under pavement] , [2: In commercial roadway] )
• COF_EnironmentalImpact ( type: esriFieldTypeSmallInteger , alias: COF_EnironmentalImpact , editable: true , nullable: true , Coded Values: [0: Not Close to Known Hazardous Site] , [2: Within 500' of Known Hazardous Site] , [1: Within 500' of Know NonHazardous Site] )
• POF ( type: esriFieldTypeDouble , alias: POF , editable: true , nullable: true )
• COF ( type: esriFieldTypeDouble , alias: COF , editable: true , nullable: true )
• BRE ( type: esriFieldTypeDouble , alias: BRE , editable: true , nullable: true )
• Replacement_Costs ( type: esriFieldTypeDouble , alias: Replacement_Costs , editable: true , nullable: true )
• Inspection_Costs ( type: esriFieldTypeDouble , alias: Inspection_Costs , editable: true , nullable: true )
• Rehab_Costs ( type: esriFieldTypeDouble , alias: Rehab_Costs , editable: true , nullable: true )
• Future_Costs ( type: esriFieldTypeDouble , alias: Future_Costs , editable: true , nullable: true )
• Length_ft_Temp ( type: esriFieldTypeDouble , alias: Length_ft_Temp , editable: true , nullable: true )
• POF_Condition ( type: esriFieldTypeSmallInteger , alias: POF_Condition , editable: true , nullable: true , Coded Values: [0: No Data or CA 1/CA2] , [1: CA 3] , [2: CA 4] , ...1 more... )
• POF_Capacity ( type: esriFieldTypeSmallInteger , alias: POF_Capacity , editable: true , nullable: true , Coded Values: [0: NA] , [1: Under Capacity/Surcharged] )
• XStart ( type: esriFieldTypeDouble , alias: XStart , editable: true , nullable: true )
• YStart ( type: esriFieldTypeDouble , alias: YStart , editable: true , nullable: true )
• XYStart ( type: esriFieldTypeString , alias: XYStart , editable: true , nullable: true , length: 50 )
• XEnd ( type: esriFieldTypeDouble , alias: XEnd , editable: true , nullable: true )
• YEnd ( type: esriFieldTypeDouble , alias: YEnd , editable: true , nullable: true )
• XYEnd ( type: esriFieldTypeString , alias: XYEnd , editable: true , nullable: true , length: 50 )
• JET_CLEAN_DATE ( type: esriFieldTypeDate , alias: Jet Cleaning Date , editable: true , nullable: true , length: 8 )
• LucityAutoID ( type: esriFieldTypeInteger , alias: Link to Lucity , editable: true , nullable: true )
• InLucity ( type: esriFieldTypeSmallInteger , alias: In Lucity? , editable: true , nullable: true )
• LastModBy ( type: esriFieldTypeString , alias: Last Modified By , editable: true , nullable: true , length: 40 )
• LastModDate ( type: esriFieldTypeDate , alias: Last Modified date , editable: true , nullable: true , length: 8 )
• LastSynDate ( type: esriFieldTypeDate , alias: Last Synchronized Date , editable: true , nullable: true , length: 8 )

Templates:

• Name: Storm Mains
  Description:
  Prototype:
  TOMH: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  LastSynDate: null
  FACILITYID: null
  INSTALLDATE: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  PIPETYPE: null
  LINEDYEAR: null
  LINERTYPE: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  FROMMH: null
  MAINTBY: 1
  SUMFLOW: null
  Status: null
  Crew: null
  Material_1: null
  Pipe_Diameter: null
  US_Severity: null
  DS_Severity: null
  US_Measure: null
  DS_Measure: null
  US_Defect: null
  DS_Defect: null
  US_Comment: null
  DS_Comment: null
  US_Photo: null
  DS_Photo: null
  P_Drop: null
  Pipe_Width: null
  PipeAge: null
  CCTV: null
  US_MH: null
  DS_MH: null
  LastModDate: null
  LastModBy: null
  InLucity: null
  LucityAutoID: null
  DS_Owner: null
  PipeOwner: null
  Environmental_Impact: null
  PublicSafety_Impact: null
  Year_Installed: null
  EEL: null
  RUL: null
  ConditionRating: null
  POF_AgeFactor: null
  POF_Material: null
  COF_SizeFactor: null
  COF_SurfaceWaterImpact: null
  COF_TransportationImpact: null
  COF_EnironmentalImpact: null
  POF: null
  COF: null
  BRE: null
  Replacement_Costs: null
  Inspection_Costs: null
  Rehab_Costs: null
  Future_Costs: null
  Length_ft_Temp: null
  POF_Condition: null
  POF_Capacity: null
  XStart: null
  YStart: null
  XYStart: null
  XEnd: null
  YEnd: null
  XYEnd: null
  JET_CLEAN_DATE: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Update,Uploads,Editing

Sync Can Return Changes: false

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

Supported Operations:   Query   Apply Edits   Update Features   Validate SQL   Generate Renderer   Return Updates