Name: sedaSewerMainHistory
Display Field: workby
Type: Table
Geometry Type: N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount: 3000
Supported Query Formats: JSON, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing 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: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
workby
(
type: esriFieldTypeString, alias: OperatedBy, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OperatedBy
)
-
assetkey
(
type: esriFieldTypeString, alias: PipelineID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PipelineID
)
-
workdate
(
type: esriFieldTypeDate, alias: DateStamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateStamp
)
-
comments
(
type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments
)
-
worktype
(
type: esriFieldTypeString, alias: worktype, editable: true, nullable: true, length: 40, defaultValue: null, modelName: worktype
)
-
attachmentid01
(
type: esriFieldTypeInteger, alias: attachmentid01, editable: true, nullable: true, defaultValue: null, modelName: attachmentid01
)
-
attachmentid02
(
type: esriFieldTypeInteger, alias: attachmentid02, editable: true, nullable: true, defaultValue: null, modelName: attachmentid02
)
-
frommh
(
type: esriFieldTypeString, alias: frommh, editable: true, nullable: true, length: 20, defaultValue: null, modelName: frommh
)
-
tomh
(
type: esriFieldTypeString, alias: tomh, editable: true, nullable: true, length: 20, defaultValue: null, modelName: tomh
)
-
direction
(
type: esriFieldTypeString, alias: direction, editable: true, nullable: true, length: 30, defaultValue: null, modelName: direction
, Coded Values:
[Downstream: Downstream]
, [Upstream: Upstream]
)
-
subsection
(
type: esriFieldTypeString, alias: subsection, editable: true, nullable: true, length: 30, defaultValue: null, modelName: subsection
)
-
feetjetted
(
type: esriFieldTypeDouble, alias: feetjetted, editable: true, nullable: true, defaultValue: null, modelName: feetjetted
)
-
nozzletype
(
type: esriFieldTypeString, alias: nozzletype, editable: true, nullable: true, length: 30, defaultValue: null, modelName: nozzletype
, Coded Values:
[Regular Nozzle: Regular Nozzle]
, [Cutter: Cutter]
)
-
clean
(
type: esriFieldTypeString, alias: clean, editable: true, nullable: true, length: 10, defaultValue: null, modelName: clean
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
rocks
(
type: esriFieldTypeString, alias: rocks, editable: true, nullable: true, length: 10, defaultValue: null, modelName: rocks
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
grit
(
type: esriFieldTypeString, alias: grit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: grit
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
grease
(
type: esriFieldTypeString, alias: Grease, editable: true, nullable: true, length: 10, defaultValue: null, modelName: grease
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
septic
(
type: esriFieldTypeString, alias: septic, editable: true, nullable: true, length: 10, defaultValue: null, modelName: septic
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
mud
(
type: esriFieldTypeString, alias: mud, editable: true, nullable: true, length: 10, defaultValue: null, modelName: mud
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
roots
(
type: esriFieldTypeString, alias: Roots, editable: true, nullable: true, length: 10, defaultValue: null, modelName: roots
, Coded Values:
[Light: Light]
, [Medium: Medium]
, [Heavy: Heavy]
, ...1 more...
)
-
rags
(
type: esriFieldTypeString, alias: rags, editable: true, nullable: true, length: 10, defaultValue: null, modelName: rags
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
trash
(
type: esriFieldTypeString, alias: trash, editable: true, nullable: true, length: 10, defaultValue: null, modelName: trash
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
sticks
(
type: esriFieldTypeString, alias: sticks, editable: true, nullable: true, length: 10, defaultValue: null, modelName: sticks
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
detritus
(
type: esriFieldTypeString, alias: detritus, editable: true, nullable: true, length: 10, defaultValue: null, modelName: detritus
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
otherconditions
(
type: esriFieldTypeString, alias: otherconditions, editable: true, nullable: true, length: 250, defaultValue: null, modelName: otherconditions
)
-
locations
(
type: esriFieldTypeString, alias: locations, editable: true, nullable: true, length: 250, defaultValue: null, modelName: locations
)
-
start
(
type: esriFieldTypeDate, alias: start, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start
)
-
finish
(
type: esriFieldTypeDate, alias: finish, editable: true, nullable: true, length: 8, defaultValue: null, modelName: finish
)
-
timeduration
(
type: esriFieldTypeDouble, alias: timeduration, editable: true, nullable: true, defaultValue: null, modelName: timeduration
)
-
datescheduled
(
type: esriFieldTypeDate, alias: datescheduled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: datescheduled
)
-
datecompleted
(
type: esriFieldTypeDate, alias: datecompleted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: datecompleted
)
-
crewcontractor
(
type: esriFieldTypeString, alias: crewcontractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: crewcontractor
)
-
attachedinvoice
(
type: esriFieldTypeString, alias: attachedinvoice, editable: true, nullable: true, length: 10, defaultValue: null, modelName: attachedinvoice
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
hoursworked
(
type: esriFieldTypeDouble, alias: hoursworked, editable: true, nullable: true, defaultValue: null, modelName: hoursworked
)
-
equipment
(
type: esriFieldTypeString, alias: equipment, editable: true, nullable: true, length: 250, defaultValue: null, modelName: equipment
)
-
totalcost
(
type: esriFieldTypeDouble, alias: totalcost, editable: true, nullable: true, defaultValue: null, modelName: totalcost
)
-
sectionrepaired
(
type: esriFieldTypeString, alias: sectionrepaired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sectionrepaired
, Coded Values:
[I&I: I&I]
, [Sag: Sag]
, [Crack: Crack]
, ...2 more...
)
-
cleaningtype
(
type: esriFieldTypeString, alias: cleaningtype, editable: true, nullable: true, length: 30, defaultValue: null, modelName: cleaningtype
, Coded Values:
[Roots: Roots]
, [Grease: Grease]
, [Silt/Rock/Deposit: Silt/Rock/Deposit]
)
-
lengthrepaired
(
type: esriFieldTypeDouble, alias: lengthrepaired, editable: true, nullable: true, defaultValue: null, modelName: lengthrepaired
)
-
material
(
type: esriFieldTypeString, alias: material, editable: true, nullable: true, length: 250, defaultValue: null, modelName: material
)
-
diameter
(
type: esriFieldTypeDouble, alias: diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter
)
-
repairmethod
(
type: esriFieldTypeString, alias: repairmethod, editable: true, nullable: true, length: 30, defaultValue: null, modelName: repairmethod
, Coded Values:
[Replaced: Replaced]
, [CIP: CIP]
, [Gunite: Gunite]
)
-
smokedyedate
(
type: esriFieldTypeDate, alias: smokedyedate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: smokedyedate
)
-
smokedycrew
(
type: esriFieldTypeString, alias: smokedycrew, editable: true, nullable: true, length: 100, defaultValue: null, modelName: smokedycrew
)
-
smokedyeaddress
(
type: esriFieldTypeString, alias: smokedyeaddress, editable: true, nullable: true, length: 100, defaultValue: null, modelName: smokedyeaddress
)
-
issueconcern
(
type: esriFieldTypeString, alias: issueconcern, editable: true, nullable: true, length: 50, defaultValue: null, modelName: issueconcern
, Coded Values:
[I&I: I&I]
, [Connection/Permit Verification: Connection/Permit Verification]
, [Upstream/Downstream Verification: Upstream/Downstream Verification]
)
-
smokedyeactivity
(
type: esriFieldTypeString, alias: smokedyeactivity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: smokedyeactivity
, Coded Values:
[Flow Monitoring: Flow Monitoring]
, [Flow Isolations: Flow Isolations]
, [Smoke Testing: Smoke Testing]
, ...4 more...
)
-
feetintoline
(
type: esriFieldTypeDouble, alias: feetintoline, editable: true, nullable: true, defaultValue: null, modelName: feetintoline
)
-
cctv_length
(
type: esriFieldTypeDouble, alias: cctv_length, editable: true, nullable: true, defaultValue: null, modelName: cctv_length
)
-
cctv_comments
(
type: esriFieldTypeString, alias: cctv_comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: cctv_comments
)
-
cctv_level
(
type: esriFieldTypeString, alias: cctv_level, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_level
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_roots
(
type: esriFieldTypeString, alias: cctv_roots, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_roots
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_sag
(
type: esriFieldTypeString, alias: cctv_sag, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_sag
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_ini
(
type: esriFieldTypeString, alias: cctv_ini, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_ini
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_rockdeposits
(
type: esriFieldTypeString, alias: cctv_rockdeposits, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_rockdeposits
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_brokenpipe
(
type: esriFieldTypeString, alias: cctv_brokenpipe, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_brokenpipe
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_offsetpipe
(
type: esriFieldTypeString, alias: cctv_offsetpipe, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_offsetpipe
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_grease
(
type: esriFieldTypeString, alias: cctv_grease, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_grease
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cameraunderwater
(
type: esriFieldTypeString, alias: cameraunderwater, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cameraunderwater
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
cctv_leak
(
type: esriFieldTypeString, alias: cctv_leak, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_leak
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
correectiveaction
(
type: esriFieldTypeString, alias: correectiveaction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: correectiveaction
)
-
actionsschedule
(
type: esriFieldTypeDate, alias: actionsschedule, editable: true, nullable: true, length: 8, defaultValue: null, modelName: actionsschedule
)
-
acionstatus
(
type: esriFieldTypeString, alias: acionstatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: acionstatus
)
-
cip_type
(
type: esriFieldTypeString, alias: cip_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cip_type
)
-
maint_type
(
type: esriFieldTypeString, alias: maint_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: maint_type
)
-
noactionreason
(
type: esriFieldTypeString, alias: noactionreason, editable: true, nullable: true, length: 50, defaultValue: null, modelName: noactionreason
)
-
cctv_crack
(
type: esriFieldTypeString, alias: cctv_crack, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cctv_crack
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
jetting_dir
(
type: esriFieldTypeString, alias: jetting_dir, editable: true, nullable: true, length: 20, defaultValue: null, modelName: jetting_dir
, Coded Values:
[With Flow: With Flow]
, [Against Flow: Against Flow]
)
-
camera_dir
(
type: esriFieldTypeString, alias: camera_dir, editable: true, nullable: true, length: 20, defaultValue: null, modelName: camera_dir
, Coded Values:
[With Flow: With Flow]
, [Against Flow: Against Flow]
)
-
wocomments
(
type: esriFieldTypeString, alias: wocomments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: wocomments
)
-
wodescription
(
type: esriFieldTypeString, alias: wodescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: wodescription
)
-
Date
(
type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date
)
-
Crew
(
type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Crew
)
-
Street
(
type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street
)
-
Sub_Basin
(
type: esriFieldTypeString, alias: Sub_Basin, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sub_Basin
)
-
USMH
(
type: esriFieldTypeString, alias: USMH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USMH
)
-
DSMH
(
type: esriFieldTypeString, alias: DSMH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DSMH
)
-
Pipe_Length
(
type: esriFieldTypeString, alias: Pipe_Length, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pipe_Length
)
-
Measure_Code
(
type: esriFieldTypeString, alias: Measure_Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Measure_Code
, Coded Values:
[1 (GIS): 1 (GIS)]
, [2 (Wheeled): 2 (Wheeled)]
, [3 (Tape): 3 (Tape)]
, ...1 more...
)
-
Inspection_Status
(
type: esriFieldTypeString, alias: Inspection_Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspection_Status
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Temperature
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Precipitation
, Coded Values:
[1 (Dry): 1 (Dry)]
, [2 (Drizzle): 2 (Drizzle)]
, [3 (Rain): 3 (Rain)]
)
-
Ground_Condition
(
type: esriFieldTypeString, alias: Ground_Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Ground_Condition
, 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Last_Rain_Event
)
-
Over_All_Comments
(
type: esriFieldTypeString, alias: Over_All_Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Over_All_Comments
)
-
Site_Sketch
(
type: esriFieldTypeInteger, alias: Site_Sketch, editable: true, nullable: true, defaultValue: null, modelName: Site_Sketch
)
-
Site_Sketch2
(
type: esriFieldTypeInteger, alias: Site_Sketch2, editable: true, nullable: true, defaultValue: null, modelName: Site_Sketch2
)
-
Defect_1_Location
(
type: esriFieldTypeString, alias: Defect_1_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_1_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_1_Address
)
-
Defect_1_Type
(
type: esriFieldTypeString, alias: Defect_1_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_1_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_1_Footage_From_USMH
)
-
Defect_1_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_1_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_1_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_1_Tributary_Area
)
-
Defect_1_Comment
(
type: esriFieldTypeString, alias: Defect_1_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_1_Comment
)
-
Defect_1_Photo
(
type: esriFieldTypeInteger, alias: Defect_1_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_1_Photo
)
-
Defect_2_Location
(
type: esriFieldTypeString, alias: Defect_2_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_2_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_2_Address
)
-
Defect_2_Type
(
type: esriFieldTypeString, alias: Defect_2_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_2_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_2_Footage_From_USMH
)
-
Defect_2_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_2_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_2_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_2_Tributary_Area
)
-
Defect_2_Comment
(
type: esriFieldTypeString, alias: Defect_2_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_2_Comment
)
-
Defect_2_Photo
(
type: esriFieldTypeInteger, alias: Defect_2_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_2_Photo
)
-
Defect_3_Location
(
type: esriFieldTypeString, alias: Defect_3_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_3_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_3_Address
)
-
Defect_3_Type
(
type: esriFieldTypeString, alias: Defect_3_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_3_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_3_Footage_From_USMH
)
-
Defect_3_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_3_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_3_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_3_Tributary_Area
)
-
Defect_3_Comment
(
type: esriFieldTypeString, alias: Defect_3_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_3_Comment
)
-
Defect_3_Photo
(
type: esriFieldTypeInteger, alias: Defect_3_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_3_Photo
)
-
Defect_4_Location
(
type: esriFieldTypeString, alias: Defect_4_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_4_Location
, 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_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_4_Address
)
-
Defect_4_Type
(
type: esriFieldTypeString, alias: Defect_4_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_4_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_4_Footage_From_USMH
)
-
Defect_4_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_4_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_4_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_4_Tributary_Area
)
-
Defect_4_Comment
(
type: esriFieldTypeString, alias: Defect_4_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_4_Comment
)
-
Defect_4_Photo
(
type: esriFieldTypeInteger, alias: Defect_4_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_4_Photo
)
-
Defect_5_Location
(
type: esriFieldTypeString, alias: Defect_5_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_5_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_5_Address
)
-
Defect_5_Type
(
type: esriFieldTypeString, alias: Defect_5_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_5_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_5_Footage_From_USMH
)
-
Defect_5_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_5_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_5_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_5_Tributary_Area
)
-
Defect_5_Comment
(
type: esriFieldTypeString, alias: Defect_5_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_5_Comment
)
-
Defect_5_Photo
(
type: esriFieldTypeInteger, alias: Defect_5_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_5_Photo
)
-
Defect_6_Location
(
type: esriFieldTypeString, alias: Defect_6_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_6_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_6_Address
)
-
Defect_6_Type
(
type: esriFieldTypeString, alias: Defect_6_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_6_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_6_Footage_From_USMH
)
-
Defect_6_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_6_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_6_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_6_Tributary_Area
)
-
Defect_6_Comment
(
type: esriFieldTypeString, alias: Defect_6_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_6_Comment
)
-
Defect_6_Photo
(
type: esriFieldTypeInteger, alias: Defect_6_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_6_Photo
)
-
Defect_7_Location
(
type: esriFieldTypeString, alias: Defect_7_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_7_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_7_Address
)
-
Defect_7_Type
(
type: esriFieldTypeString, alias: Defect_7_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_7_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_7_Footage_From_USMH
)
-
Defect_7_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_7_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_7_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_7_Tributary_Area
)
-
Defect_7_Comment
(
type: esriFieldTypeString, alias: Defect_7_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_7_Comment
)
-
Defect_7_Photo
(
type: esriFieldTypeInteger, alias: Defect_7_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_7_Photo
)
-
Defect_8_Location
(
type: esriFieldTypeString, alias: Defect_8_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_8_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_8_Address
)
-
Defect_8_Type
(
type: esriFieldTypeString, alias: Defect_8_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_8_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_8_Footage_From_USMH
)
-
Defect_8_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_8_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_8_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_8_Tributary_Area
)
-
Defect_8_Comment
(
type: esriFieldTypeString, alias: Defect_8_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_8_Comment
)
-
Defect_8_Photo
(
type: esriFieldTypeInteger, alias: Defect_8_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_8_Photo
)
-
Defect_9_Location
(
type: esriFieldTypeString, alias: Defect_9_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_9_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_9_Address
)
-
Defect_9_Type
(
type: esriFieldTypeString, alias: Defect_9_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_9_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_9_Footage_From_USMH
)
-
Defect_9_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_9_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_9_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_9_Tributary_Area
)
-
Defect_9_Comment
(
type: esriFieldTypeString, alias: Defect_9_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_9_Comment
)
-
Defect_9_Photo
(
type: esriFieldTypeInteger, alias: Defect_9_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_9_Photo
)
-
Defect_10_Location
(
type: esriFieldTypeString, alias: Defect_10_Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_10_Location
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_10_Address
)
-
Defect_10_Type
(
type: esriFieldTypeString, alias: Defect_10_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_10_Type
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_10_Footage_From_USMH
)
-
Defect_10_Smoke_Intensity
(
type: esriFieldTypeString, alias: Defect_10_Smoke_Intensity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_10_Smoke_Intensity
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_10_Tributary_Area
)
-
Defect_10_Comment
(
type: esriFieldTypeString, alias: Defect_10_Comment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Defect_10_Comment
)
-
Defect_10_Photo
(
type: esriFieldTypeInteger, alias: Defect_10_Photo, editable: true, nullable: true, defaultValue: null, modelName: Defect_10_Photo
)
Templates:
-
Name: sedaSewerMainHistory
Description:
Prototype:
Defect_10_Comment: null
Defect_10_Photo: null
workby: null
assetkey: null
workdate: null
comments: null
worktype: null
attachmentid01: null
attachmentid02: null
frommh: null
tomh: null
direction: null
subsection: null
feetjetted: null
nozzletype: null
clean: null
rocks: null
grit: null
grease: null
septic: null
mud: null
roots: null
rags: null
trash: null
sticks: null
detritus: null
otherconditions: null
locations: null
start: null
finish: null
timeduration: null
datescheduled: null
datecompleted: null
crewcontractor: null
attachedinvoice: null
hoursworked: null
equipment: null
totalcost: null
sectionrepaired: null
cleaningtype: null
lengthrepaired: null
material: null
diameter: null
repairmethod: null
smokedyedate: null
smokedycrew: null
smokedyeaddress: null
issueconcern: null
smokedyeactivity: null
feetintoline: null
cctv_length: null
cctv_comments: null
cctv_level: null
cctv_roots: null
cctv_sag: null
cctv_ini: null
cctv_rockdeposits: null
cctv_brokenpipe: null
cctv_offsetpipe: null
cctv_grease: null
cameraunderwater: null
cctv_leak: null
correectiveaction: null
actionsschedule: null
acionstatus: null
cip_type: null
maint_type: null
noactionreason: null
cctv_crack: null
jetting_dir: null
camera_dir: null
wocomments: null
wodescription: null
Date: null
Crew: null
Street: null
Sub_Basin: null
USMH: null
DSMH: null
Pipe_Length: null
Measure_Code: null
Inspection_Status: null
Temperature: null
Precipitation: null
Ground_Condition: null
Last_Rain_Event: null
Over_All_Comments: null
Site_Sketch: null
Site_Sketch2: null
Defect_1_Location: null
Defect_1_Address: null
Defect_1_Type: null
Defect_1_Footage_From_USMH: null
Defect_1_Smoke_Intensity: null
Defect_1_Tributary_Area: null
Defect_1_Comment: null
Defect_1_Photo: null
Defect_2_Location: null
Defect_2_Address: null
Defect_2_Type: null
Defect_2_Footage_From_USMH: null
Defect_2_Smoke_Intensity: null
Defect_2_Tributary_Area: null
Defect_2_Comment: null
Defect_2_Photo: null
Defect_3_Location: null
Defect_3_Address: null
Defect_3_Type: null
Defect_3_Footage_From_USMH: null
Defect_3_Smoke_Intensity: null
Defect_3_Tributary_Area: null
Defect_3_Comment: null
Defect_3_Photo: null
Defect_4_Location: null
Defect_4_Address: null
Defect_4_Type: null
Defect_4_Footage_From_USMH: null
Defect_4_Smoke_Intensity: null
Defect_4_Tributary_Area: null
Defect_4_Comment: null
Defect_4_Photo: null
Defect_5_Location: null
Defect_5_Address: null
Defect_5_Type: null
Defect_5_Footage_From_USMH: null
Defect_5_Smoke_Intensity: null
Defect_5_Tributary_Area: null
Defect_5_Comment: null
Defect_5_Photo: null
Defect_6_Location: null
Defect_6_Address: null
Defect_6_Type: null
Defect_6_Footage_From_USMH: null
Defect_6_Smoke_Intensity: null
Defect_6_Tributary_Area: null
Defect_6_Comment: null
Defect_6_Photo: null
Defect_7_Location: null
Defect_7_Address: null
Defect_7_Type: null
Defect_7_Footage_From_USMH: null
Defect_7_Smoke_Intensity: null
Defect_7_Tributary_Area: null
Defect_7_Comment: null
Defect_7_Photo: null
Defect_8_Location: null
Defect_8_Address: null
Defect_8_Type: null
Defect_8_Footage_From_USMH: null
Defect_8_Smoke_Intensity: null
Defect_8_Tributary_Area: null
Defect_8_Comment: null
Defect_8_Photo: null
Defect_9_Location: null
Defect_9_Address: null
Defect_9_Type: null
Defect_9_Footage_From_USMH: null
Defect_9_Smoke_Intensity: null
Defect_9_Tributary_Area: null
Defect_9_Comment: null
Defect_9_Photo: null
Defect_10_Location: null
Defect_10_Address: null
Defect_10_Type: null
Defect_10_Footage_From_USMH: null
Defect_10_Smoke_Intensity: null
Defect_10_Tributary_Area: null
Drawing Tool: esriFeatureEditToolNone
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Supports Query With Historic Moment: false
Supports Coordinates Quantization: false
Supported Operations:
Query
Query Attachments
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata