Name: WaterburyGIS.GISEDITOR.sedaPipeHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• leaktype ( type: esriFieldTypeString, alias: LeakType, length: 50 )
• reporteddate ( type: esriFieldTypeDate, alias: ReportedDate, length: 8 )
• repaireddate ( type: esriFieldTypeDate, alias: RepairedDate, length: 8 )
• pipeclamp ( type: esriFieldTypeString, alias: PipeClamp, length: 50 )
• feetreplaced ( type: esriFieldTypeDouble, alias: FeetReplaced )
• sampledate ( type: esriFieldTypeDate, alias: SampleDate, length: 8 )
• publicnotified ( type: esriFieldTypeString, alias: PublicNotified, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• cl2residual ( type: esriFieldTypeDouble, alias: Cl2Residual )
• streetpatchtype ( type: esriFieldTypeString, alias: StreetPatchType, length: 50 )
• squarefeetpatched ( type: esriFieldTypeDouble, alias: SquareFeetPatched )
• streetpatchdate ( type: esriFieldTypeDate, alias: StreetPatchDate, length: 8 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, length: 8 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 50 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• short_measurement ( type: esriFieldTypeString, alias: short_measurement, length: 1000 )
• long_measurement ( type: esriFieldTypeString, alias: long_measurement, length: 1000 )
• meter_information ( type: esriFieldTypeString, alias: meter_information, length: 1000 )
• labor_entry ( type: esriFieldTypeString, alias: labor_entry, length: 1000 )
• equipment_used ( type: esriFieldTypeString, alias: equipment_used, length: 1000 )
• material_used ( type: esriFieldTypeString, alias: material_used, length: 1000 )
• excavation_details ( type: esriFieldTypeString, alias: excavation_details, length: 1000 )
• pipe_depth ( type: esriFieldTypeDouble, alias: pipe_depth )
• pavement_thickness ( type: esriFieldTypeDouble, alias: pavement_thickness )
• corrosion_details ( type: esriFieldTypeString, alias: corrosion_details, length: 1000 )
• report_prepared_by ( type: esriFieldTypeString, alias: report_prepared_by, length: 100 )
• report_prepared_date ( type: esriFieldTypeDate, alias: report_prepared_date, length: 8 )
• est_waterloss ( type: esriFieldTypeDouble, alias: est_waterloss )
• outage_id ( type: esriFieldTypeString, alias: outage_id, length: 50 )
• event_time ( type: esriFieldTypeDate, alias: event_time, length: 8 )
• valves_closed_time ( type: esriFieldTypeDate, alias: valves_closed_time, length: 8 )
• flow_rate ( type: esriFieldTypeDouble, alias: flow_rate )
• pipe_diameter ( type: esriFieldTypeDouble, alias: pipe_diameter )
• estimated_pressure ( type: esriFieldTypeDouble, alias: estimated_pressure )
• break_type ( type: esriFieldTypeString, alias: break_type, length: 50 )
• break_width ( type: esriFieldTypeDouble, alias: break_width )
• break_height ( type: esriFieldTypeDouble, alias: break_height )
• comments ( type: esriFieldTypeString, alias: comments, length: 2000 )
• start ( type: esriFieldTypeDate, alias: start, length: 8 )
• finish ( type: esriFieldTypeDate, alias: finish, length: 8 )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• Crew ( type: esriFieldTypeString, alias: Crew, length: 50 )
• Street ( type: esriFieldTypeString, alias: Street, length: 50 )
• Sub_Basin ( type: esriFieldTypeString, alias: Sub_Basin, length: 50 )
• USMH ( type: esriFieldTypeString, alias: USMH, length: 50 )
• DSMH ( type: esriFieldTypeString, alias: DSMH, length: 50 )
• Pipe_Length ( type: esriFieldTypeString, alias: Pipe_Length, length: 50 )
• Measure_Code ( type: esriFieldTypeString, alias: Measure_Code, length: 50 , Coded Values: [1 (GIS): 1 (GIS)] , [2 (Wheeled): 2 (Wheeled)] , [3 (Tape): 3 (Tape)] , ...1 more... )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection_Status, length: 50 , Coded Values: [1 (C.N.L): 1 (C.N.L)] , [2 (D.N.E): 2 (D.N.E)] , [3 (Buried MH): 3 (Buried MH)] , ...4 more... )
• Temperature ( type: esriFieldTypeString, alias: Temperature, length: 50 , Coded Values: [1 (110-90 degrees): 1 (110-90 degrees)] , [2 (90-80): 2 (90-80)] , [3 (80-70): 3 (80-70)] , ...1 more... )
• Precipitation ( type: esriFieldTypeString, alias: Precipitation, length: 50 , Coded Values: [1 (Dry): 1 (Dry)] , [2 (Drizzle): 2 (Drizzle)] , [3 (Rain): 3 (Rain)] )
• Ground_Condition ( type: esriFieldTypeString, alias: Ground_Condition, length: 50 , Coded Values: [1 (Dry): 1 (Dry)] , [2 (Moist): 2 (Moist)] , [3 (Wet): 3 (Wet)] , ...1 more... )
• Last_Rain_Event ( type: esriFieldTypeDate, alias: Last_Rain_Event, length: 8 )
• Over_All_Comments ( type: esriFieldTypeString, alias: Over_All_Comments, length: 50 )
• Site_Sketch ( type: esriFieldTypeInteger, alias: Site_Sketch )
• Site_Sketch2 ( type: esriFieldTypeInteger, alias: Site_Sketch2 )
• Defect_1_Location ( type: esriFieldTypeString, alias: Defect_1_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_1_Address ( type: esriFieldTypeString, alias: Defect_1_Address, length: 50 )
• Defect_1_Type ( type: esriFieldTypeString, alias: Defect_1_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_1_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_1_Footage_From_USMH, length: 50 )
• Defect_1_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_1_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_1_Tributary_Area ( type: esriFieldTypeString, alias: Defect_1_Tributary_Area, length: 50 )
• Defect_1_Comment ( type: esriFieldTypeString, alias: Defect_1_Comment, length: 50 )
• Defect_1_Photo ( type: esriFieldTypeInteger, alias: Defect_1_Photo )
• Defect_2_Location ( type: esriFieldTypeString, alias: Defect_2_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_2_Address ( type: esriFieldTypeString, alias: Defect_2_Address, length: 50 )
• Defect_2_Type ( type: esriFieldTypeString, alias: Defect_2_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_2_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_2_Footage_From_USMH, length: 50 )
• Defect_2_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_2_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_2_Tributary_Area ( type: esriFieldTypeString, alias: Defect_2_Tributary_Area, length: 50 )
• Defect_2_Comment ( type: esriFieldTypeString, alias: Defect_2_Comment, length: 50 )
• Defect_2_Photo ( type: esriFieldTypeInteger, alias: Defect_2_Photo )
• Defect_3_Location ( type: esriFieldTypeString, alias: Defect_3_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_3_Address ( type: esriFieldTypeString, alias: Defect_3_Address, length: 50 )
• Defect_3_Type ( type: esriFieldTypeString, alias: Defect_3_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_3_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_3_Footage_From_USMH, length: 50 )
• Defect_3_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_3_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_3_Tributary_Area ( type: esriFieldTypeString, alias: Defect_3_Tributary_Area, length: 50 )
• Defect_3_Comment ( type: esriFieldTypeString, alias: Defect_3_Comment, length: 50 )
• Defect_3_Photo ( type: esriFieldTypeInteger, alias: Defect_3_Photo )
• Defect_4_Location ( type: esriFieldTypeString, alias: Defect_4_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_4_Address ( type: esriFieldTypeString, alias: Defect_4_, length: 50 )
• Defect_4_Type ( type: esriFieldTypeString, alias: Defect_4_, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_4_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_4_Footage_From_USMH, length: 50 )
• Defect_4_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_4_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_4_Tributary_Area ( type: esriFieldTypeString, alias: Defect_4_Tributary_Area, length: 50 )
• Defect_4_Comment ( type: esriFieldTypeString, alias: Defect_4_Comment, length: 50 )
• Defect_4_Photo ( type: esriFieldTypeInteger, alias: Defect_4_Photo )
• Defect_5_Location ( type: esriFieldTypeString, alias: Defect_5_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_5_Address ( type: esriFieldTypeString, alias: Defect_5_Address, length: 50 )
• Defect_5_Type ( type: esriFieldTypeString, alias: Defect_5_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_5_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_5_Footage_From_USMH, length: 50 )
• Defect_5_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_5_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_5_Tributary_Area ( type: esriFieldTypeString, alias: Defect_5_Tributary_Area, length: 50 )
• Defect_5_Comment ( type: esriFieldTypeString, alias: Defect_5_Comment, length: 50 )
• Defect_5_Photo ( type: esriFieldTypeInteger, alias: Defect_5_Photo )
• Defect_6_Location ( type: esriFieldTypeString, alias: Defect_6_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_6_Address ( type: esriFieldTypeString, alias: Defect_6_Address, length: 50 )
• Defect_6_Type ( type: esriFieldTypeString, alias: Defect_6_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_6_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_6_Footage_From_USMH, length: 50 )
• Defect_6_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_6_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_6_Tributary_Area ( type: esriFieldTypeString, alias: Defect_6_Tributary_Area, length: 50 )
• Defect_6_Comment ( type: esriFieldTypeString, alias: Defect_6_Comment, length: 50 )
• Defect_6_Photo ( type: esriFieldTypeInteger, alias: Defect_6_Photo )
• Defect_7_Location ( type: esriFieldTypeString, alias: Defect_7_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_7_Address ( type: esriFieldTypeString, alias: Defect_7_Address, length: 50 )
• Defect_7_Type ( type: esriFieldTypeString, alias: Defect_7_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_7_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_7_Footage_From_USMH, length: 50 )
• Defect_7_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_7_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_7_Tributary_Area ( type: esriFieldTypeString, alias: Defect_7_Tributary_Area, length: 50 )
• Defect_7_Comment ( type: esriFieldTypeString, alias: Defect_7_Comment, length: 50 )
• Defect_7_Photo ( type: esriFieldTypeInteger, alias: Defect_7_Photo )
• Defect_8_Location ( type: esriFieldTypeString, alias: Defect_8_, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_8_Address ( type: esriFieldTypeString, alias: Defect_8_Address, length: 50 )
• Defect_8_Type ( type: esriFieldTypeString, alias: Defect_8_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_8_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_8_Footage_From_USMH, length: 50 )
• Defect_8_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_8_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_8_Tributary_Area ( type: esriFieldTypeString, alias: Defect_8_Tributary_Area, length: 50 )
• Defect_8_Comment ( type: esriFieldTypeString, alias: Defect_8_Comment, length: 50 )
• Defect_8_Photo ( type: esriFieldTypeInteger, alias: Defect_8_Photo )
• Defect_9_Location ( type: esriFieldTypeString, alias: Defect_9_, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_9_Address ( type: esriFieldTypeString, alias: Defect_9_Address, length: 50 )
• Defect_9_Type ( type: esriFieldTypeString, alias: Defect_9_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_9_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_9_Footage_From_USMH, length: 50 )
• Defect_9_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_9_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_9_Tributary_Area ( type: esriFieldTypeString, alias: Defect_9_Tributary_Area, length: 50 )
• Defect_9_Comment ( type: esriFieldTypeString, alias: Defect_9_, length: 50 )
• Defect_9_Photo ( type: esriFieldTypeInteger, alias: Defect_9_Photo )
• Defect_10_Location ( type: esriFieldTypeString, alias: Defect_10_Location, length: 50 , Coded Values: [1 (Public Pipe): 1 (Public Pipe)] , [2 (USMH): 2 (USMH)] , [3 (DSMH): 3 (DSMH)] , ...4 more... )
• Defect_10_Address ( type: esriFieldTypeString, alias: Defect_10_Address, length: 50 )
• Defect_10_Type ( type: esriFieldTypeString, alias: Defect_10_Type, length: 50 , Coded Values: [1 (Downspout): 1 (Downspout)] , [2 (Uncapped Cleanout): 2 (Uncapped Cleanout)] , [3 (Driveway Drain): 3 (Driveway Drain)] , ...17 more... )
• Defect_10_Footage_From_USMH ( type: esriFieldTypeString, alias: Defect_10_Footage_From_USMH, length: 50 )
• Defect_10_Smoke_Intensity ( type: esriFieldTypeString, alias: Defect_10_Smoke_Intensity, length: 50 , Coded Values: [1 (Light): 1 (Light)] , [2 (Medium): 2 (Medium)] , [3 (Heavy): 3 (Heavy)] )
• Defect_10_Tributary_Area ( type: esriFieldTypeString, alias: Defect_10_Tributary_Area, length: 50 )
• Defect_10_Comment ( type: esriFieldTypeString, alias: Defect_10_Comment, length: 50 )
• Defect_10_Photo ( type: esriFieldTypeInteger, alias: Defect_10_Photo )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata