View In:   ArcGIS Online map viewer

Name: Sanitary Pressurized 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: 1.3272823947506562E7
YMin: 368149.3963254541
XMax: 1.3284693115813643E7
YMax: 380879.53937007487
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSDash
Color: [255, 0, 0, 255]
Width: 2
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [FACILITYID] CONCAT " - " CONCAT [Diameter_S] CONCAT "''" CONCAT NEWLINE CONCAT [Material_S]
Use Coded Values: true
Symbol:
Color: [0, 0, 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: normal
Font Decoration: none

Min. Scale: 1000.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 )
• Material_S ( type: esriFieldTypeSmallInteger , alias: Material , editable: true , nullable: true , Coded Values: [1: Concrete] , [2: Liner Material] , [3: Plastic] , ...15 more... )
• Diameter_S ( type: esriFieldTypeSmallInteger , alias: Diameter , editable: true , nullable: true )
• Line_Type_S ( type: esriFieldTypeSmallInteger , alias: Line Type , editable: true , nullable: true , Coded Values: [1: Gravity] , [2: Force Main] , [3: Unknown] )
• PDrop_S ( type: esriFieldTypeSmallInteger , alias: PDrop , editable: true , nullable: true , Coded Values: [2: No] , [1: Unknown] , [3: Yes] )
• INSTALLDATE ( type: esriFieldTypeDate , alias: Install Date , editable: true , nullable: true , length: 8 )
• WATERTYPE ( type: esriFieldTypeString , alias: Water Type , editable: true , nullable: true , length: 30 , Coded Values: [Combined: Combined Waste Water] , [Effluent: Waste Water Effluent] , [0: N/A] , ...7 more... )
• 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] )
• LASTUPDATE ( type: esriFieldTypeDate , alias: Last Update Date , editable: true , nullable: true , length: 8 )
• LASTEDITOR ( type: esriFieldTypeString , alias: Last Editor , editable: true , nullable: true , length: 50 )
• Legacy_ID ( type: esriFieldTypeString , alias: Legacy ID , editable: true , nullable: true , length: 50 )
• District ( type: esriFieldTypeString , alias: District , editable: true , nullable: true , length: 50 )
• CCTV_ID ( type: esriFieldTypeString , alias: CCTV_ID , editable: true , nullable: true , length: 20 )
• Rehab_Date ( type: esriFieldTypeString , alias: Rehab Date , editable: true , nullable: true , length: 6 )
• US_Measure ( type: esriFieldTypeDouble , alias: US_Measure , editable: true , nullable: true )
• DS_Measure ( type: esriFieldTypeDouble , alias: DS_Measure , editable: true , nullable: true )
• US_Invert ( type: esriFieldTypeDouble , alias: US_Invert , editable: true , nullable: true )
• DS_Invert ( type: esriFieldTypeDouble , alias: DS_Invert , editable: true , nullable: true )
• US_Rim_Elev ( type: esriFieldTypeDouble , alias: US_Rim_Elev , editable: true , nullable: true )
• DS_Rim_Elev ( type: esriFieldTypeDouble , alias: DS_Rim_Elev , editable: true , nullable: true )
• US_ID ( type: esriFieldTypeString , alias: US_ID , editable: true , nullable: true , length: 50 )
• DS_ID ( type: esriFieldTypeString , alias: DS_ID , editable: true , nullable: true , length: 50 )
• US_DS_ID ( type: esriFieldTypeString , alias: US_DS_ID , editable: true , nullable: true , length: 50 )
• Comments ( type: esriFieldTypeString , alias: Comments , editable: true , nullable: true , length: 150 )
• Televising_Report ( type: esriFieldTypeString , alias: Televising_Report , editable: true , nullable: true , length: 50 )
• cctv_report_Num ( type: esriFieldTypeString , alias: cctv_report_Num , editable: true , nullable: true , length: 50 )
• cctv_Date ( type: esriFieldTypeString , alias: cctv_Date , editable: true , nullable: true , length: 30 )
• cctv_US_MH ( type: esriFieldTypeString , alias: cctv_US_MH , editable: true , nullable: true , length: 25 )
• cctv_DS_MH ( type: esriFieldTypeString , alias: cctv_DS_MH , editable: true , nullable: true , length: 25 )
• cctv_Street ( type: esriFieldTypeString , alias: cctv_Street , editable: true , nullable: true , length: 50 )
• cctv_Material ( type: esriFieldTypeString , alias: cctv_Material , editable: true , nullable: true , length: 50 )
• cctv_Diameter ( type: esriFieldTypeString , alias: cctv_Diameter , editable: true , nullable: true , length: 15 )
• cctv_Length ( type: esriFieldTypeString , alias: cctv_Length , editable: true , nullable: true , length: 15 )
• cctv_Num_Connections ( type: esriFieldTypeString , alias: Num_Connections , editable: true , nullable: true , length: 10 )
• cctv_Quick_Str ( type: esriFieldTypeString , alias: cctv_Quick_Str , editable: true , nullable: true , length: 30 )
• cctv_Quick_OM ( type: esriFieldTypeString , alias: cctv_Quick_OM , editable: true , nullable: true , length: 30 )
• cctv_Str_Rating ( type: esriFieldTypeString , alias: cctv_Str_Rating , editable: true , nullable: true , length: 20 )
• cctv_Str_Index ( type: esriFieldTypeString , alias: cctv_Str_Index , editable: true , nullable: true , length: 20 )
• cctv_OM_Rating ( type: esriFieldTypeString , alias: cctv_OM_Rating , editable: true , nullable: true , length: 20 )
• cctv_OM_Index ( type: esriFieldTypeString , alias: cctv_OM_Index , editable: true , nullable: true , length: 20 )
• cctv_Overall_Rating ( type: esriFieldTypeString , alias: cctv_Overall_Rating , editable: true , nullable: true , length: 20 )
• cctv_Overall_Index ( type: esriFieldTypeString , alias: cctv_Overall_Index , editable: true , nullable: true , length: 20 )
• cctv_Primary_Str_Defect ( type: esriFieldTypeString , alias: cctv_Primary_Str_Defect , editable: true , nullable: true , length: 50 )
• cctv_Primary_OM_Defect ( type: esriFieldTypeString , alias: cctv_Primary_OM_Defect , editable: true , nullable: true , length: 50 )
• cctv_Engineer_Cond_Rating ( type: esriFieldTypeString , alias: cctv_Engineer_Cond_Rating , editable: true , nullable: true , length: 50 )
• Work_Orders ( type: esriFieldTypeSmallInteger , alias: Work Orders , editable: true , nullable: true )
• WO_Last_Date ( type: esriFieldTypeDate , alias: WO Last Date , editable: true , nullable: true , length: 8 )
• WO_Reason ( type: esriFieldTypeString , alias: WO Reason , editable: true , nullable: true , length: 100 )
• cctv_Report ( type: esriFieldTypeString , alias: cctv_Report , editable: true , nullable: true , length: 70 , Coded Values: [Yes: Yes] , [No: No] , [Proposed: Proposed] )
• 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 )
• Assumed_Matl ( type: esriFieldTypeString , alias: Assumed_Matl , editable: true , nullable: true , length: 50 , Coded Values: [Precast Concrete: Precast Concrete] , [Concrete: Concrete] , [Brick: Brick] , ...11 more... )
• Status ( type: esriFieldTypeString , alias: Status , editable: true , nullable: true , length: 30 , Coded Values: [Complete: Complete] , [Not Found: Not Found] , [Unable to Open: Unable to Open] , ...2 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] )
• US_Severity ( type: esriFieldTypeString , alias: US_Severity , editable: true , nullable: true , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• DS_Severity ( type: esriFieldTypeString , alias: DS_Severity , editable: true , nullable: true , length: 25 , Coded Values: [Small/Light: Small/Light] , [Medium/Moderate: Medium/Moderate] , [Large/Heavy: Large/Heavy] , ...2 more... )
• US_Defect ( type: esriFieldTypeString , alias: US_Defect , editable: true , nullable: true , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 more... )
• DS_Defect ( type: esriFieldTypeString , alias: DS_Defect , editable: true , nullable: true , length: 25 , Coded Values: [None: None] , [Cracked: Cracked] , [Loose: Loose] , ...10 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 )
• Critical ( type: esriFieldTypeString , alias: Critical , editable: true , nullable: true , length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• Default_WO_Cat ( type: esriFieldTypeString , alias: Default_WO_Cat , editable: true , nullable: true , length: 10 )
• Remaining_Useful_Life_Per ( type: esriFieldTypeDouble , alias: Remaining Useful Life % , editable: true , nullable: true )
• Install_Year_D ( type: esriFieldTypeDouble , alias: Install Year , editable: true , nullable: true )
• EEL ( type: esriFieldTypeSmallInteger , alias: EEL , editable: true , nullable: true )
• POF_Age ( type: esriFieldTypeSmallInteger , alias: POF_Age , editable: true , nullable: true , Coded Values: [0: NA] , [2: > 50% RUL] , [4: 10% - 50% RUL] , ...1 more... )
• POF_Material ( type: esriFieldTypeSmallInteger , alias: POF_Material , editable: true , nullable: true , Coded Values: [0: DI, HDPE] , [2: CI] )
• POF_WO ( type: esriFieldTypeSmallInteger , alias: POF_WO , editable: true , nullable: true , Coded Values: [0: None] , [2: Previous Work Order] )
• COF_Size ( type: esriFieldTypeSmallInteger , alias: COF_Size , editable: true , nullable: true , Coded Values: [0: NA] , [2: 4"] , [4: 6"] )
• COF_Surface_Water ( type: esriFieldTypeSmallInteger , alias: COF_Surface_Water , editable: true , nullable: true , Coded Values: [0: NA] , [2: < 50' of water or 100 year floodplain] , [4: Crossing beneath water body] )
• COF_Trans ( type: esriFieldTypeSmallInteger , alias: COF_Trans , editable: true , nullable: true , Coded Values: [0: NA] , [2: Crosses beneath railroad tracks] )
• 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 )
• LucityAutoID ( type: esriFieldTypeInteger , alias: LucityAutoID , editable: true , nullable: true )
• LucitySyncDate ( type: esriFieldTypeDate , alias: LucitySyncDate , editable: true , nullable: true , length: 8 )
• LucityCategory ( type: esriFieldTypeString , alias: LucityCategory , editable: true , nullable: true , length: 5 )
• InLucityFlag ( type: esriFieldTypeSmallInteger , alias: In Lucity Flag , editable: true , nullable: true )
• LastModBy ( type: esriFieldTypeString , alias: Last Modified By , editable: true , nullable: true , length: 50 )
• LastModDate ( type: esriFieldTypeDate , alias: Last Modified Date , editable: true , nullable: true , length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• Pump_Station ( type: esriFieldTypeString , alias: Pump_Station , editable: true , nullable: true , length: 25 , Coded Values: [PS-02: Brighton Mall PS] , [PS-09: Woodfield Square PS] , [PS-04: Rickert Road PS] , ...8 more... )
• Length_ft_Temp ( type: esriFieldTypeDouble , alias: Length_ft_Temp , editable: true , nullable: true )

Templates:

• Name: Sanitary Pressurized Mains
  Description:
  Prototype:
  WATERTYPE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  Length_ft_Temp: null
  FACILITYID: null
  Material_S: null
  Diameter_S: null
  Line_Type_S: null
  PDrop_S: null
  INSTALLDATE: null
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  Legacy_ID: null
  District: null
  CCTV_ID: null
  Rehab_Date: null
  US_Measure: null
  DS_Measure: null
  US_Invert: null
  DS_Invert: null
  US_Rim_Elev: null
  DS_Rim_Elev: null
  US_ID: null
  DS_ID: null
  US_DS_ID: null
  Comments: null
  Televising_Report: null
  cctv_report_Num: null
  cctv_Date: null
  cctv_US_MH: null
  cctv_DS_MH: null
  cctv_Street: null
  cctv_Material: null
  cctv_Diameter: null
  cctv_Length: null
  cctv_Num_Connections: null
  cctv_Quick_Str: null
  cctv_Quick_OM: null
  cctv_Str_Rating: null
  cctv_Str_Index: null
  cctv_OM_Rating: null
  cctv_OM_Index: null
  cctv_Overall_Rating: null
  cctv_Overall_Index: null
  cctv_Primary_Str_Defect: null
  cctv_Primary_OM_Defect: null
  cctv_Engineer_Cond_Rating: null
  Work_Orders: null
  WO_Last_Date: null
  WO_Reason: null
  cctv_Report: null
  US_Photo: null
  DS_Photo: null
  Assumed_Matl: null
  Status: null
  Crew: null
  US_Severity: null
  DS_Severity: null
  US_Defect: null
  DS_Defect: null
  US_Comment: null
  DS_Comment: null
  Critical: null
  Pump_Station: null
  LastModDate: null
  LastModBy: null
  InLucityFlag: null
  Default_WO_Cat: null
  Remaining_Useful_Life_Per: null
  Install_Year_D: null
  EEL: null
  POF_Age: null
  POF_Material: null
  POF_WO: null
  COF_Size: null
  COF_Surface_Water: null
  COF_Trans: null
  POF: null
  COF: null
  BRE: null
  LucityAutoID: null
  LucitySyncDate: null
  LucityCategory: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Update,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

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