Catch Basin Inspection Schema

Workspace

Key	Value
Name	InspectionTablesExtendSchema_1d1855192b944ea0b7f6f6fac295f92c
Workspace Type	Remote Database
Workspace Factory	Feature Service DB
Geodatabase Release
Date Exported	2025-04-24 08:59:28
Path	/

Domain Name	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
AssetCondition	String	Coded Value	Default Value	Default Value	4	3
Catch Basin Inspection Extend Schema_action_433d97650c404df29ab0ae6c63340fa3	Short Integer	Coded Value	Default Value	Default Value	2	1
Catch Basin Inspection Extend Schema_ckshlsprsnt_e9ec139256294863b231a76780378529	Short Integer	Coded Value	Default Value	Default Value	3	1
Catch Basin Inspection Extend Schema_flow_e9b06de3367d4eb18daa3f83e11f7065	Short Integer	Coded Value	Default Value	Default Value	2	1
Catch Basin Inspection Extend Schema_flowcolor_f023f79e781e49a9b294728bfb978fc7	Short Integer	Coded Value	Default Value	Default Value	4	1
Catch Basin Inspection Extend Schema_IDact_62beec751aa84533a1e501950a5ee75f	Short Integer	Coded Value	Default Value	Default Value	2	1
Catch Basin Inspection Extend Schema_marker_837311d68af24a65b4e4c52626882505	Short Integer	Coded Value	Default Value	Default Value	2	1
Catch Basin Inspection Extend Schema_mrkreplc_84c16b22f5f44d76a075e4006534b47c	Short Integer	Coded Value	Default Value	Default Value	2	1
Catch Basin Inspection Extend Schema_odordesc_1ea03eadb0874853b22542ca3dcc02e0	Short Integer	Coded Value	Default Value	Default Value	5	1
Catch Basin Inspection Extend Schema_precip48hrs_f973933d93ee4b6e95deb4fcdd2ff0e7	Short Integer	Coded Value	Default Value	Default Value	2	1
Catch Basin Inspection Extend Schema_triphaz_5ac20e2b24bf4bbcaa36d0e94456b6e9	Short Integer	Coded Value	Default Value	Default Value	3	1
Catch Basin Inspection Extend Schema_weather_5e7e71d19b52458eb8ee9f9b261c544b	Short Integer	Coded Value	Default Value	Default Value	4	1
colordesc	Short Integer	Coded Value	Default Value	Default Value	6	1
crksev	Short Integer	Coded Value	Default Value	Default Value	3	1
flowdesc	Short Integer	Coded Value	Default Value	Default Value	5	1
ID_potsorc	Short Integer	Coded Value	Default Value	Default Value	4	1
ID_Status	Short Integer	Coded Value	Default Value	Default Value	4	1
InspectResult	Short Integer	Coded Value	Default Value	Default Value	5	0
MarkerType	Short Integer	Coded Value	Default Value	Default Value	3	1
NegResponse	Short Integer	Coded Value	Default Value	Default Value	3	1
odordesc	Short Integer	Coded Value	Default Value	Default Value	5	0
odorsvr	Short Integer	Coded Value	Default Value	Default Value	3	1
Outfall Inspection_floatabledesc_f4084c76-9cc5-4219-8e9e-8bacafb8cd1b	Short Integer	Coded Value	Default Value	Default Value	5	0
Outfall Inspection_flowrate_9d13b7ea-c8e1-4358-84a7-fda2a4fd55d1	Short Integer	Coded Value	Default Value	Default Value	5	0
Outlet Inspections Extend Schema_abveg_589969aac9874a2ca1dce169e286908e	Short Integer	Coded Value	Default Value	Default Value	2	0
Outlet Inspections Extend Schema_action_6920b0cb32a546ba96611e7796d648f3	Short Integer	Coded Value	Default Value	Default Value	2	0
Outlet Inspections Extend Schema_depstain_2ad3cc30dd5f4a6b8b5b9713642fcf22	Short Integer	Coded Value	Default Value	Default Value	3	0
Outlet Inspections Extend Schema_enderos_9a44de5f8aa94f8e92707b84f4008a25	Short Integer	Coded Value	Default Value	Default Value	2	0
Outlet Inspections Extend Schema_flow_eafa9d4cf47e4c24bc1e14c4653e2a5c	Short Integer	Coded Value	Default Value	Default Value	4	0
Outlet Inspections Extend Schema_flowcolor_c0dc7b992e5f46f593203e3e4da3a1f6	Short Integer	Coded Value	Default Value	Default Value	4	0
Outlet Inspections Extend Schema_flowfloat_193474911ab4411d8329fe3991b67933	Short Integer	Coded Value	Default Value	Default Value	4	0
Outlet Inspections Extend Schema_IDact_223790c64f06485d95b8e8167fa59e2d	Short Integer	Coded Value	Default Value	Default Value	2	0
Outlet Inspections Extend Schema_located_bd81a27a14ef459081b416f789c94661	Short Integer	Coded Value	Default Value	Default Value	2	0
Outlet Inspections Extend Schema_odor_9a9db9ec5f514f6a86d015857356476f	Short Integer	Coded Value	Default Value	Default Value	4	0
Outlet Inspections Extend Schema_precip48hrs_7c4208f7288d4f4a91446a4c9b3e5c48	Short Integer	Coded Value	Default Value	Default Value	2	0
Outlet Inspections Extend Schema_sampcol_bc68e4529c664e18a7d4a13b23aca70b	Short Integer	Coded Value	Default Value	Default Value	4	0
PosResponse	Short Integer	Coded Value	Default Value	Default Value	3	0
submerged	Short Integer	Coded Value	Default Value	Default Value	3	0
turbidity	Short Integer	Coded Value	Default Value	Default Value	5	0
Weather	Short Integer	Coded Value	Default Value	Default Value	4	0
Yes_No	Short Integer	Coded Value	Duplicate	Default Value	4	1

Datasets

Catch_Basin_Inspection_Extend_Schema

Properties

Key	Value
Name	Catch_Basin_Inspection_Extend_Schema
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	Catch Basin Inspection Extend Schema
OID Field	OBJECTID
Editor Tracking Enabled	False
Catalog ID	{D5BA16BA-2052-4AEC-B0A1-9F291CA7AECE}
Class ID	{7A566981-C114-11D2-8A28-006097AFF44E}

Fields

Name	Alias	Type	Usage	Nullable	Domain	Length	Editable	Required	Details
OBJECTID	OBJECTID	OID	Index	False		0	False	True	Unique identifier for each record
weather	Current Weather Conditions	Short Integer		True	Catch Basin Inspection Extend Schema_weather_5e7e71d19b52458eb8ee9f9b261c544b	0	True	False	Represents the current weather conditions during inspection
precip48hrs	Precipitation in past 48 hours	Short Integer		True	Catch Basin Inspection Extend Schema_precip48hrs_f973933d93ee4b6e95deb4fcdd2ff0e7	0	True	False	Indicates if there was precipitation in the past 48 hours
gratecond	Grate Condition	String		True	AssetCondition	255	True	False	Describes the condition of the grate
framecond	Frame Condition	String		True	AssetCondition	255	True	False	Describes the condition of the frame
wallcond	Wall Condition	String		True	AssetCondition	255	True	False	Describes the condition of the wall
sedtrshveg	Sediment/Trash/Vegetation Build up	Short Integer		True	NegResponse	0	True	False	Indicates if there is a build-up of sediment, trash, or vegetation
ckshlsprsnt	Cracks or holes present	Short Integer		True	Catch Basin Inspection Extend Schema_ckshlsprsnt_e9ec139256294863b231a76780378529	0	True	False	Indicates if there are cracks or holes present
ckshlssev	Cracks or holes severity	Short Integer		True	crksev	0	True	False	Describes the severity of the cracks or holes
triphaz	Trip Hazard?	Short Integer		True	Catch Basin Inspection Extend Schema_triphaz_5ac20e2b24bf4bbcaa36d0e94456b6e9	0	True	False	Indicates if there is a trip hazard
marker	Marker present	Short Integer		True	Catch Basin Inspection Extend Schema_marker_837311d68af24a65b4e4c52626882505	0	True	False	Indicates if a marker is present
mrktype	Marker type	Short Integer		True	MarkerType	0	True	False	Describes the type of marker
mrkreplc	Marker needs replacement	Short Integer		True	Catch Basin Inspection Extend Schema_mrkreplc_84c16b22f5f44d76a075e4006534b47c	0	True	False	Indicates if the marker needs replacement
notes	Inspection Notes	String		True		255	True	False	Contains any additional inspection notes
flow	Flow present	Short Integer		True	Catch Basin Inspection Extend Schema_flow_e9b06de3367d4eb18daa3f83e11f7065	0	True	False	Indicates if there is a flow present
flowdesc	Flow description	Short Integer		True	flowdesc	0	True	False	Describes the flow
odor	Odor present	Short Integer		True	Yes_No	0	True	False	Indicates if there is an odor present
odorsrv	Odor severity	Short Integer		True	odorsvr	0	True	False	Describes the severity of the odor
odordesc	Odor description	Short Integer		True	Catch Basin Inspection Extend Schema_odordesc_1ea03eadb0874853b22542ca3dcc02e0	0	True	False	Describes the type of odor
flowcolor	Flow contain color	Short Integer		True	Catch Basin Inspection Extend Schema_flowcolor_f023f79e781e49a9b294728bfb978fc7	0	True	False	Indicates if the flow contains color
colordesc	Color description	Short Integer		True	colordesc	0	True	False	Describes the color of the flow
IDpotential	Potential illicit discharge	Short Integer		True	ID_Status	0	True	False	Indicates the potential for illicit discharge
IDsource	Source of potential illicit discharge	Short Integer		True	ID_potsorc	0	True	False	Describes the potential source of illicit discharge
IDact	Corrective action taken	Short Integer		True	Catch Basin Inspection Extend Schema_IDact_62beec751aa84533a1e501950a5ee75f	0	True	False	Indicates if corrective action was taken related to the illicit discharge
IDnotes	Illicit discharge notes	String		True		255	True	False	Contains any notes about the illicit discharge
action	Further action needed	Short Integer		True	Catch Basin Inspection Extend Schema_action_433d97650c404df29ab0ae6c63340fa3	0	True	False	Indicates if further action is needed
actnotes	Action Notes	String		True		255	True	False	Contains any notes about the action needed

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__Inspecti__F4B70D85355288DA	True	True	OBJECTID

Domains

AssetCondition

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

Code	Description	Details
Repair	Repair
Replace	Replace
NoAction	No action required
NA	Not applicable

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			gratecond
Catch_Basin_Inspection_Extend_Schema			framecond
Catch_Basin_Inspection_Extend_Schema			wallcond

Catch Basin Inspection Extend Schema_action_433d97650c404df29ab0ae6c63340fa3

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_action_433d97650c404df29ab0ae6c63340fa3
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	2
# of Assignments	1

Code	Description	Details
1	Yes
2	No

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			action

Catch Basin Inspection Extend Schema_ckshlsprsnt_e9ec139256294863b231a76780378529

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_ckshlsprsnt_e9ec139256294863b231a76780378529
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	3
# of Assignments	1

Code	Description	Details
1	Yes
2	No
3	Not applicable

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			ckshlsprsnt

Catch Basin Inspection Extend Schema_flow_e9b06de3367d4eb18daa3f83e11f7065

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_flow_e9b06de3367d4eb18daa3f83e11f7065
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	2
# of Assignments	1

Code	Description	Details
1	Yes
2	No

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			flow

Catch Basin Inspection Extend Schema_flowcolor_f023f79e781e49a9b294728bfb978fc7

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_flowcolor_f023f79e781e49a9b294728bfb978fc7
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	4
# of Assignments	1

Code	Description	Details
1	Yes
2	No
4	Not Inspected
5	Unknown

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			flowcolor

Catch Basin Inspection Extend Schema_IDact_62beec751aa84533a1e501950a5ee75f

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_IDact_62beec751aa84533a1e501950a5ee75f
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	2
# of Assignments	1

Code	Description	Details
1	Yes
2	No

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			IDact

Catch Basin Inspection Extend Schema_marker_837311d68af24a65b4e4c52626882505

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_marker_837311d68af24a65b4e4c52626882505
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	2
# of Assignments	1

Code	Description	Details
1	Yes
2	No

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			marker

Catch Basin Inspection Extend Schema_mrkreplc_84c16b22f5f44d76a075e4006534b47c

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_mrkreplc_84c16b22f5f44d76a075e4006534b47c
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	2
# of Assignments	1

Code	Description	Details
1	Yes
2	No

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			mrkreplc

Catch Basin Inspection Extend Schema_odordesc_1ea03eadb0874853b22542ca3dcc02e0

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_odordesc_1ea03eadb0874853b22542ca3dcc02e0
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	5
# of Assignments	1

Code	Description	Details
1	Sewage
2	Sulfide
3	Rancid/Sour
4	Petroleum/Gas
5	Unknown

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			odordesc

Catch Basin Inspection Extend Schema_precip48hrs_f973933d93ee4b6e95deb4fcdd2ff0e7

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_precip48hrs_f973933d93ee4b6e95deb4fcdd2ff0e7
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	2
# of Assignments	1

Code	Description	Details
1	Yes
2	No

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			precip48hrs

Catch Basin Inspection Extend Schema_triphaz_5ac20e2b24bf4bbcaa36d0e94456b6e9

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_triphaz_5ac20e2b24bf4bbcaa36d0e94456b6e9
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	3
# of Assignments	1

Code	Description	Details
1	Yes
2	No
3	Not applicable

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			triphaz

Catch Basin Inspection Extend Schema_weather_5e7e71d19b52458eb8ee9f9b261c544b

Key	Value
Owner
Domain Name	Catch Basin Inspection Extend Schema_weather_5e7e71d19b52458eb8ee9f9b261c544b
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	4
# of Assignments	1

Code	Description	Details
1	Dry
2	Light Rain
3	Heavy Rain
4	Snow or Winter Weather

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			weather

colordesc

Key	Value
Owner
Domain Name	colordesc
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	6
# of Assignments	1

Code	Description	Details
0	Brown
1	Green
2	Gray
3	Orange
4	Red
5	Yellow

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			colordesc

crksev

Key	Value
Owner
Domain Name	crksev
Description
Field Type	Short Integer
Domain Type	Coded Value
Split Policy	Default Value
Merge Policy	Default Value
# of Codes	3
# of Assignments	1

Code	Description	Details
1	Low
2	Medium
3	High

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			ckshlssev

flowdesc

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

Code	Description	Details
1	Trickle
2	Moderate
3	Substantial
4	Not Inspected
5	Unknown

Dataset	Subtype Code	Subtype Name	Field Name
Catch_Basin_Inspection_Extend_Schema			flowdesc

ID_potsorc

ID_Status

InspectResult

MarkerType

NegResponse

odordesc

odorsvr

Outfall Inspection_floatabledesc_f4084c76-9cc5-4219-8e9e-8bacafb8cd1b

Outfall Inspection_flowrate_9d13b7ea-c8e1-4358-84a7-fda2a4fd55d1

Outlet Inspections Extend Schema_abveg_589969aac9874a2ca1dce169e286908e

Outlet Inspections Extend Schema_action_6920b0cb32a546ba96611e7796d648f3

Outlet Inspections Extend Schema_depstain_2ad3cc30dd5f4a6b8b5b9713642fcf22

Outlet Inspections Extend Schema_enderos_9a44de5f8aa94f8e92707b84f4008a25

Outlet Inspections Extend Schema_flow_eafa9d4cf47e4c24bc1e14c4653e2a5c

Outlet Inspections Extend Schema_flowcolor_c0dc7b992e5f46f593203e3e4da3a1f6

Outlet Inspections Extend Schema_flowfloat_193474911ab4411d8329fe3991b67933

Outlet Inspections Extend Schema_IDact_223790c64f06485d95b8e8167fa59e2d

Outlet Inspections Extend Schema_located_bd81a27a14ef459081b416f789c94661

Outlet Inspections Extend Schema_odor_9a9db9ec5f514f6a86d015857356476f

Outlet Inspections Extend Schema_precip48hrs_7c4208f7288d4f4a91446a4c9b3e5c48

Outlet Inspections Extend Schema_sampcol_bc68e4529c664e18a7d4a13b23aca70b

PosResponse

submerged

turbidity

Weather

Yes_No

Code	Description	Details
1	Low potential
2	Medium potential
3	High potential
4	Not illicit discharge

Code	Description	Details
1	No problem
2	Monitor
3	Routine maintenance needed
4	Immediate repair needed
0	Not applicable