Manhole Inspection Schema

Workspace

Key	Value
Name	ManholeInspectionSchema_4164808c698d4ddab5015c8379cd98f0
Workspace Type	Remote Database
Workspace Factory	Feature Service DB
Geodatabase Release
Date Exported	2025-05-29 09:30:29
Path	/

Domain Name	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
Condition_Score	Short Integer	Coded Value	Default Value	Default Value	5	7
Cover_Issues	String	Coded Value	Default Value	Default Value	5	1
Direction	String	Coded Value	Default Value	Default Value	8	1
Flow	String	Coded Value	Default Value	Default Value	5	1
Issues	String	Coded Value	Default Value	Default Value	4	5
No_Yes	String	Coded Value	Default Value	Default Value	2	4
Obstructions	String	Coded Value	Default Value	Default Value	4	1
Weather_Conditions	String	Coded Value	Default Value	Default Value	5	1

Datasets

ManholeInspectionSchema

Properties

Key	Value
Name	ManholeInspectionSchema
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	ManholeInspectionSchema
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	True
Editor Tracking UTC	True
Creator Field	Creator
Create Date Field	CreationDate
Editor Field	Editor
Edit Date Field	EditDate
Catalog ID	{B413CC57-3DA0-47A1-BF42-C26C7B6710E7}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Precision	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False		0	0	False	True	Unique identifier for each record
weather_conditions	Weather Conditions	String		True	Weather_Conditions	0	50	True	False	Describes the weather conditions during the inspection
location_inspection	Location	String		True		0	255	True	False	Specifies the location of the inspection
ponding	Ponding	String		True	No_Yes	0	50	True	False	Indicates if there was ponding during the inspection
cover_issue	Cover Issue	String		True	Cover_Issues	0	50	True	False	Describes issues with the cover
cover_condition	Cover Condition	Short Integer		True	Condition_Score	0	0	True	False	Rates the condition of the cover
frame_issue	Frame Issue	String		True	Issues	0	50	True	False	Describes issues with the frame
frame_condition	Frame Condition	Short Integer		True	Condition_Score	0	0	True	False	Rates the condition of the frame
ring_issue	Ring Issue	String		True	Issues	0	50	True	False	Describes issues with the ring
ring_condition	Ring Condition	Short Integer		True	Condition_Score	0	0	True	False	Rates the condition of the ring
chimney_issue	Chimney Issue	String		True	Issues	0	50	True	False	Describes issues with the chimney
chimney_condition	Chimney Condition	Short Integer		True	Condition_Score	0	0	True	False	Rates the condition of the chimney
cone_issue	Cone Issue	String		True	Issues	0	50	True	False	Describes issues with the cone
cone_condition	Cone Condition	Short Integer		True	Condition_Score	0	0	True	False	Rates the condition of the cone
barrel_issue	Barrel Issue	String		True	Issues	0	50	True	False	Describes issues with the barrel
barrel_condition	Barrel Condition	Short Integer		True	Condition_Score	0	0	True	False	Rates the condition of the barrel
step_condition	Step Condition	Short Integer		True	Condition_Score	0	0	True	False	Rates the condition of the steps
inlets	Number of Inlets	Short Integer		True		0	0	True	False	Number of inlets into the manhole
effluent_direction	Effluent Direction	String		True	Direction	0	50	True	False	Direction of the effluent flow
surcharge	Evidence of Surcharge	String		True	No_Yes	0	50	True	False	Indicates if there is evidence of surcharge
surcharge_depth	Surcharge Depth	Double		True		0	0	True	False	Depth of the surcharge
infiltration	Evidence of Infiltration	String		True	No_Yes	0	50	True	False	Indicates if there is evidence of infiltration
obstruction	Obstruction	String		True	Obstructions	0	50	True	False	Describes any obstructions
flow	Flow Description	String		True	Flow	0	50	True	False	Describes the flow rate
needsrepair	Needs Repair	String		True	No_Yes	0	50	True	False	Indicates if the manhole needs repair
assetguid	Asset Guid	GUID		True		0	38	True	False	Unique identifier used to relate a table to a feature
GlobalID	GlobalID	Global ID	Index	False		0	38	False	True	Globally unique identifier for the asset
CreationDate	CreationDate	Date	Created;Index	True		1	8	False	True	Date the record was created
Creator	Creator	String	Creator;Index	True		0	128	False	True	User who created the record
EditDate	EditDate	Date	Edited;Index	True		1	8	False	True	Date the record was last edited
Editor	Editor	String	Editor;Index	True		0	128	False	True	User who last edited the record
relate_notes	Notes	String		True		0	255	True	False	Notes related to the inspection
assigned_to	Inspected By	String		True		0	50	True	False	Inspector who conducted the inspection
inspect_date	Inspected On	Date		True		1	8	True	False	Date of the inspection

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__ManholeI__F4B70D859429D946	True	True	OBJECTID
GlobalID_Index	True	False	GlobalID
CreationDateIndex	False	True	CreationDate
CreatorIndex	False	False	Creator
EditDateIndex	False	True	EditDate
EditorIndex	False	False	Editor

Domains

Condition_Score

Key	Value
Owner
Domain Name	Condition_Score
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	5
# of Assignments	7

Code	Description	Details
1	1 - Excellent
2	2 - Good
3	3 - Average
4	4 - Fair
5	5 - Poor

Dataset	Subtype Code	Subtype Name	Field Name
ManholeInspectionSchema			cover_condition
ManholeInspectionSchema			frame_condition
ManholeInspectionSchema			ring_condition
ManholeInspectionSchema			chimney_condition
ManholeInspectionSchema			cone_condition
ManholeInspectionSchema			barrel_condition
ManholeInspectionSchema			step_condition

Cover_Issues

Key	Value
Owner
Domain Name	Cover_Issues
Description
Field Type	String
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	5
# of Assignments	1

Code	Description	Details
None	None
Cracked	Cracked
Broken	Broken
Corroded	Corroded
Missing	Missing

Dataset	Subtype Code	Subtype Name	Field Name
ManholeInspectionSchema			cover_issue

Direction

Key	Value
Owner
Domain Name	Direction
Description
Field Type	String
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	8
# of Assignments	1

Code	Description	Details
N	N
NE	NE
E	E
SE	SE
S	S
SW	SW
W	W
NW	NW

Dataset	Subtype Code	Subtype Name	Field Name
ManholeInspectionSchema			effluent_direction

Flow

Key	Value
Owner
Domain Name	Flow
Description
Field Type	String
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	5
# of Assignments	1

Code	Description	Details
Pulsing	Pulsing
Sluggish	Sluggish
Steady	Steady
Surcharging	Surcharging
Turbulent	Turbulent

Dataset	Subtype Code	Subtype Name	Field Name
ManholeInspectionSchema			flow

Issues

Key	Value
Owner
Domain Name	Issues
Description
Field Type	String
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	4
# of Assignments	5

Code	Description	Details
Broken	Broken
Corroded	Corroded
Cracked	Cracked
None	None

Dataset	Subtype Code	Subtype Name	Field Name
ManholeInspectionSchema			frame_issue
ManholeInspectionSchema			ring_issue
ManholeInspectionSchema			chimney_issue
ManholeInspectionSchema			cone_issue
ManholeInspectionSchema			barrel_issue

No_Yes

Key	Value
Owner
Domain Name	No_Yes
Description
Field Type	String
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	2
# of Assignments	4

Code	Description	Details
No	No
Yes	Yes

Dataset	Subtype Code	Subtype Name	Field Name
ManholeInspectionSchema			ponding
ManholeInspectionSchema			surcharge
ManholeInspectionSchema			infiltration
ManholeInspectionSchema			needsrepair

Obstructions

Key	Value
Owner
Domain Name	Obstructions
Description
Field Type	String
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	4
# of Assignments	1

Code	Description	Details
Debris	Debris
Roots	Roots
Structural Defect	Structural Defect
None	None

Dataset	Subtype Code	Subtype Name	Field Name
ManholeInspectionSchema			obstruction

Weather_Conditions

Code	Description	Details
Dry	Dry
Wet	Wet
Standing Water	Standing Water
Frozen	Frozen
Other	Other