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: 6e0b5dee06df452bbbdfdb6dbe2cf17b

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• SystemID ( type: esriFieldTypeInteger, alias: SystemID )
• ParentSystemID ( type: esriFieldTypeString, alias: ParentSystemID, length: 1073741822 )
• Date_Received ( type: esriFieldTypeDate, alias: Date_Received, length: 8 )
• Date_of_Incident ( type: esriFieldTypeDate, alias: Date_of_Incident, length: 8 )
• Name_of_Claimant ( type: esriFieldTypeString, alias: Name_of_Claimant, length: 1073741822 )
• Address ( type: esriFieldTypeString, alias: Address, length: 1073741822 )
• Location_of_Overflow ( type: esriFieldTypeString, alias: Location_of_Overflow, length: 1073741822 )
• Notified_By ( type: esriFieldTypeString, alias: Notified_By, length: 1073741822 , 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, length: 1073741822 )
• Pipe_Size ( type: esriFieldTypeString, alias: Pipe_Size, length: 1073741822 )
• Main_Material ( type: esriFieldTypeString, alias: Main_Material, length: 1073741822 , 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, length: 8 )
• Sewer_Service_Area ( type: esriFieldTypeString, alias: Sewer_Service_Area, length: 1073741822 )
• Type_of_Inspection ( type: esriFieldTypeString, alias: Type_of_Inspection, length: 1073741822 , 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, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Previous_Blockage_Date ( type: esriFieldTypeString, alias: Previous_Blockage_Date, length: 1073741822 )
• Major_Industries__Schools__Rest ( type: esriFieldTypeString, alias: Major_Industries__Schools__Rest, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Rat_Control ( type: esriFieldTypeString, alias: Rat_Control, length: 1073741822 )
• Has_Overflow_Reached_Surface_Wa ( type: esriFieldTypeString, alias: Has_Overflow_Reached_Surface_Wa, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Overflow_Comments ( type: esriFieldTypeString, alias: Overflow_Comments, length: 1073741822 )
• Superintendent_Notification ( type: esriFieldTypeString, alias: Superintendent_Notification, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Notification_Date_Time ( type: esriFieldTypeString, alias: Notification_Date_Time, length: 1073741822 )
• Blockage_in_Main ( type: esriFieldTypeString, alias: Blockage_in_Main, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Main_Jetted ( type: esriFieldTypeString, alias: Main_Jetted, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Blockage_in_Lateral ( type: esriFieldTypeString, alias: Blockage_in_Lateral, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Cause_of_Blockage ( type: esriFieldTypeString, alias: Cause_of_Blockage, length: 1073741822 )
• Date_Time_Jetting_Completed ( type: esriFieldTypeDate, alias: Date_Time_Jetting_Completed, length: 8 )
• Plumber_on_Site ( type: esriFieldTypeString, alias: Plumber_on_Site, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• List_Plumber_Company ( type: esriFieldTypeString, alias: List_Plumber_Company, length: 1073741822 )
• Comments_by_City_Personnel ( type: esriFieldTypeString, alias: Comments_by_City_Personnel, length: 1073741822 )
• Comments_by_Claimant ( type: esriFieldTypeString, alias: Comments_by_Claimant, length: 1073741822 )
• Was_Weather_a_Factor_in_Overflo ( type: esriFieldTypeString, alias: Was_Weather_a_Factor_in_Overflo, length: 1073741822 , Coded Values: [Yes: Yes] , [No: No] )
• Total_Precipitation ( type: esriFieldTypeString, alias: Total_Precipitation, length: 1073741822 )
• Fieldwork_Completed_By ( type: esriFieldTypeString, alias: Fieldwork_Completed_By, length: 1073741822 , 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, length: 8 )
• Form_Completed_By ( type: esriFieldTypeString, alias: Form_Completed_By, length: 1073741822 )
• Form_Completion_Date ( type: esriFieldTypeDate, alias: Form_Completion_Date, length: 8 )
• Work_Reviewed_By ( type: esriFieldTypeString, alias: Work_Reviewed_By, length: 1073741822 )
• Leadman_Signature ( type: esriFieldTypeString, alias: Leadman_Signature, length: 1073741822 )
• Supervisor_Signature ( type: esriFieldTypeString, alias: Supervisor_Signature, length: 1073741822 )
• Status ( type: esriFieldTypeString, alias: Status, length: 1073741822 , Coded Values: [OPEN: Open] , [CLOSED: Closed] )
• Created_By ( type: esriFieldTypeString, alias: Created_By, length: 1073741822 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, length: 8 )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CreateBy ( type: esriFieldTypeString, alias: CreateDate, length: 50 )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: EditBy, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• PreviousBlockageDate ( type: esriFieldTypeDate, alias: PreviousBlockageDate, length: 8 )
• Last_Main_Jetting ( type: esriFieldTypeDate, alias: Last_Main_Jetting, length: 8 )
• SanitaryArea ( type: esriFieldTypeString, alias: SanitaryArea, length: 50 )
• FieldworkSecondary ( type: esriFieldTypeString, alias: FieldworkSecondary, length: 50 , Coded Values: [1 N Schanno: N Schanno] , [4 Tyler Popp: Tyler Popp] , [5 Shawn Soucheck: Shawn Soucheck] , ...23 more... )
• TimeReported ( type: esriFieldTypeDate, alias: TimeReported, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FieldWorker3 ( type: esriFieldTypeString, alias: Field Worker 3, length: 50 , 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, length: 50 , Coded Values: [1 N Schanno: N Schanno] , [4 Tyler Popp: Tyler Popp] , [5 Shawn Soucheck: Shawn Soucheck] , ...23 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata