View In:   ArcGIS Online Map Viewer

Name: Overflows

Display Field: Name_of_Claimant

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This feature class was created on 10/29/2018 by andrew.bartell@sheboyganwi.gov from data that originated in Mobile MMS. Data was exported from Mobile MMS in Excel format, and then brought into ArcGIS Pro and converted to XY Point data class. Schema was then used to create this data class, and finally data was imported using the Load Data tool in ArcCatalog. </SPAN></P><P><SPAN>This data class will be updated and editing as of the creation data of 10/29/2018. Overflow data will no longer be added to the Mobile MMS application. </SPAN></P></DIV></DIV></DIV>

Service Item Id: 927c8c7a0be94a2097d771986509176b

Copyright Text: City of Sheboygan

Default Visibility: true

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: 206695.9080726616
YMin: 156586.7168275714
XMax: 222846.4865275917
YMax: 189612.05103924125
Spatial Reference: 103458  (103458)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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:

• SystemID ( type: esriFieldTypeInteger, alias: SystemID, editable: true, nullable: true, defaultValue: null, modelName: SystemID )
• ParentSystemID ( type: esriFieldTypeString, alias: ParentSystemID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ParentSystemID )
• Date_Received ( type: esriFieldTypeDate, alias: Date_Received, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Received )
• Date_of_Incident ( type: esriFieldTypeDate, alias: Date_of_Incident, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_of_Incident )
• Name_of_Claimant ( type: esriFieldTypeString, alias: Name_of_Claimant, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Name_of_Claimant )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Address )
• Location_of_Overflow ( type: esriFieldTypeString, alias: Location_of_Overflow, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Location_of_Overflow )
• Notified_By ( type: esriFieldTypeString, alias: Notified_By, editable: true, nullable: true, length: 1073741822, defaultValue: Brandon Munnik, modelName: Notified_By , Coded Values: [David Biebel: David Biebel] , [DPW Office: DPW Office] , [Plumbing Company: Plumbing Company] , ...15 more... )
• Age_of_Sewer ( type: esriFieldTypeString, alias: Age_of_Sewer, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Age_of_Sewer )
• Pipe_Size ( type: esriFieldTypeString, alias: Pipe_Size, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Pipe_Size )
• Main_Material ( type: esriFieldTypeString, alias: Main_Material, editable: true, nullable: true, length: 1073741822, defaultValue: Clay Pipe, modelName: Main_Material , Coded Values: [Armco Truss Pipe: Armco Truss Pipe] , [Clay Pipe: Clay Pipe] , [Concrete Pipe: Concrete Pipe] , ...3 more... )
• Date_of_Last_Inspection ( type: esriFieldTypeDate, alias: Date_of_Last_Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_of_Last_Inspection )
• Sewer_Service_Area ( type: esriFieldTypeString, alias: Sewer_Service_Area, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Sewer_Service_Area )
• Type_of_Inspection ( type: esriFieldTypeString, alias: Type_of_Inspection, editable: true, nullable: true, length: 1073741822, defaultValue: Route Jetting, modelName: Type_of_Inspection , Coded Values: [Grease Treatment: Grease Treatment] , [Mineral Deposit: Mineral Deposit] , [Root Control: Root Control] , ...3 more... )
• Previous_Blockage_Issues ( type: esriFieldTypeString, alias: Previous_Blockage_Issues, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Previous_Blockage_Issues , Coded Values: [Yes: Yes] , [No: No] )
• Previous_Blockage_Date ( type: esriFieldTypeString, alias: Previous_Blockage_Date, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Previous_Blockage_Date )
• Major_Industries__Schools__Rest ( type: esriFieldTypeString, alias: Major_Industries__Schools__Rest, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Major_Industries__Schools__Rest , Coded Values: [Yes: Yes] , [No: No] )
• Rat_Control ( type: esriFieldTypeString, alias: Rat_Control, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Rat_Control )
• Has_Overflow_Reached_Surface_Wa ( type: esriFieldTypeString, alias: Has_Overflow_Reached_Surface_Wa, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Has_Overflow_Reached_Surface_Wa , Coded Values: [Yes: Yes] , [No: No] )
• Overflow_Comments ( type: esriFieldTypeString, alias: Overflow_Comments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Overflow_Comments )
• Superintendent_Notification ( type: esriFieldTypeString, alias: Superintendent_Notification, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Superintendent_Notification , Coded Values: [Yes: Yes] , [No: No] )
• Notification_Date_Time ( type: esriFieldTypeString, alias: Notification_Date_Time, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Notification_Date_Time )
• Blockage_in_Main ( type: esriFieldTypeString, alias: Blockage_in_Main, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Blockage_in_Main , Coded Values: [Yes: Yes] , [No: No] )
• Main_Jetted ( type: esriFieldTypeString, alias: Main_Jetted, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Main_Jetted , Coded Values: [Yes: Yes] , [No: No] )
• Blockage_in_Lateral ( type: esriFieldTypeString, alias: Blockage_in_Lateral, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Blockage_in_Lateral , Coded Values: [Yes: Yes] , [No: No] )
• Cause_of_Blockage ( type: esriFieldTypeString, alias: Cause_of_Blockage, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Cause_of_Blockage )
• Date_Time_Jetting_Completed ( type: esriFieldTypeDate, alias: Date_Time_Jetting_Completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Time_Jetting_Completed )
• Plumber_on_Site ( type: esriFieldTypeString, alias: Plumber_on_Site, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Plumber_on_Site , Coded Values: [Yes: Yes] , [No: No] )
• List_Plumber_Company ( type: esriFieldTypeString, alias: List_Plumber_Company, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: List_Plumber_Company )
• Comments_by_City_Personnel ( type: esriFieldTypeString, alias: Comments_by_City_Personnel, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Comments_by_City_Personnel )
• Comments_by_Claimant ( type: esriFieldTypeString, alias: Comments_by_Claimant, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Comments_by_Claimant )
• Was_Weather_a_Factor_in_Overflo ( type: esriFieldTypeString, alias: Was_Weather_a_Factor_in_Overflo, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Was_Weather_a_Factor_in_Overflo , Coded Values: [Yes: Yes] , [No: No] )
• Total_Precipitation ( type: esriFieldTypeString, alias: Total_Precipitation, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Total_Precipitation )
• Fieldwork_Completed_By ( type: esriFieldTypeString, alias: Fieldwork_Completed_By, editable: true, nullable: true, length: 1073741822, defaultValue: Brandon Munnik, modelName: Fieldwork_Completed_By , Coded Values: [1 N Schanno: N Schanno] , [4 Tyler Popp: Tyler Popp] , [5 Shawn Soucheck: Shawn Soucheck] , ...23 more... )
• Work_Completion_Date ( type: esriFieldTypeDate, alias: Work_Completion_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Completion_Date )
• Form_Completed_By ( type: esriFieldTypeString, alias: Form_Completed_By, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Form_Completed_By )
• Form_Completion_Date ( type: esriFieldTypeDate, alias: Form_Completion_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Form_Completion_Date )
• Work_Reviewed_By ( type: esriFieldTypeString, alias: Work_Reviewed_By, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Work_Reviewed_By )
• Leadman_Signature ( type: esriFieldTypeString, alias: Leadman_Signature, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Leadman_Signature )
• Supervisor_Signature ( type: esriFieldTypeString, alias: Supervisor_Signature, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Supervisor_Signature )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Status , Coded Values: [OPEN: Open] , [CLOSED: Closed] )
• Created_By ( type: esriFieldTypeString, alias: Created_By, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Created_By )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Created_Date )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• CreateBy ( type: esriFieldTypeString, alias: CreateDate, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateBy )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• EditBy ( type: esriFieldTypeString, alias: EditBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• PreviousBlockageDate ( type: esriFieldTypeDate, alias: PreviousBlockageDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PreviousBlockageDate )
• Last_Main_Jetting ( type: esriFieldTypeDate, alias: Last_Main_Jetting, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Last_Main_Jetting )
• SanitaryArea ( type: esriFieldTypeString, alias: SanitaryArea, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SanitaryArea )
• FieldworkSecondary ( type: esriFieldTypeString, alias: FieldworkSecondary, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FieldworkSecondary , Coded Values: [1 N Schanno: N Schanno] , [4 Tyler Popp: Tyler Popp] , [5 Shawn Soucheck: Shawn Soucheck] , ...23 more... )
• TimeReported ( type: esriFieldTypeDate, alias: TimeReported, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TimeReported )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FieldWorker3 ( type: esriFieldTypeString, alias: Field Worker 3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FieldWorker3 , Coded Values: [1 N Schanno: N Schanno] , [4 Tyler Popp: Tyler Popp] , [5 Shawn Soucheck: Shawn Soucheck] , ...23 more... )
• FieldWorker4 ( type: esriFieldTypeString, alias: Field Worker 4, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FieldWorker4 , Coded Values: [1 N Schanno: N Schanno] , [4 Tyler Popp: Tyler Popp] , [5 Shawn Soucheck: Shawn Soucheck] , ...23 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Overflows
  Description:
  Prototype:
  FieldWorker4: null
  SystemID: null
  ParentSystemID: null
  Date_Received: null
  Date_of_Incident: null
  Name_of_Claimant: null
  Address: null
  Location_of_Overflow: null
  Notified_By: Brandon Munnik
  Age_of_Sewer: null
  Pipe_Size: null
  Main_Material: Clay Pipe
  Date_of_Last_Inspection: null
  Sewer_Service_Area: null
  Type_of_Inspection: Route Jetting
  Previous_Blockage_Issues: null
  Previous_Blockage_Date: null
  Major_Industries__Schools__Rest: null
  Rat_Control: null
  Has_Overflow_Reached_Surface_Wa: null
  Overflow_Comments: null
  Superintendent_Notification: null
  Notification_Date_Time: null
  Blockage_in_Main: null
  Main_Jetted: null
  Blockage_in_Lateral: null
  Cause_of_Blockage: null
  Date_Time_Jetting_Completed: null
  Plumber_on_Site: null
  List_Plumber_Company: null
  Comments_by_City_Personnel: null
  Comments_by_Claimant: null
  Was_Weather_a_Factor_in_Overflo: null
  Total_Precipitation: null
  Fieldwork_Completed_By: Brandon Munnik
  Work_Completion_Date: null
  Form_Completed_By: null
  Form_Completion_Date: null
  Work_Reviewed_By: null
  Leadman_Signature: null
  Supervisor_Signature: null
  Status: null
  Created_By: null
  Latitude: null
  Created_Date: null
  Longitude: null
  FieldWorker3: null
  TimeReported: null
  FieldworkSecondary: null
  SanitaryArea: null
  PreviousBlockageDate: null
  Last_Main_Jetting: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreateBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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