BMP Inspection Schema

Workspace

Key	Value
Name	BMPInspection_ExtendSchema
Workspace Type	Remote Database
Workspace Factory	Feature Service DB
Geodatabase Release
Date Exported	2025-06-06 12:48:59
Path	/

Domain Name	Field Type	Domain Type	Split Policy	Merge Policy	# of Codes	# of Assignments
BMPInspection_ExtendSchema_accessed	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_clean	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_eroscontrol	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_illicitdis	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_maintained	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_other	String	Coded Value	Default Value	Default Value	2	1
BMPInspection_ExtendSchema_protect	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_rained24hours	String	Coded Value	Default Value	Default Value	2	1
BMPInspection_ExtendSchema_rainfall	String	Coded Value	Default Value	Default Value	6	1
BMPInspection_ExtendSchema_replaced	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_trash	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_vegetation	String	Coded Value	Default Value	Default Value	3	1
BMPInspection_ExtendSchema_weather	String	Coded Value	Default Value	Default Value	5	1

Datasets

BMPInspection_ExtendSchema

Properties

Key	Value
Name	BMPInspection_ExtendSchema
Dataset Type	Table
Dataset ID	-1
Minimum Client Version	10.0
Alias	BMPInspection_ExtendSchema
OID Field	OBJECTID
GlobalID Field	GlobalID
Editor Tracking Enabled	False
Catalog ID	{099F9D2C-753A-4365-B4C9-0719830E63B8}
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
GlobalID	GlobalID	Global ID	Index	False		38	False	True	Globally unique identifier for the record
weather	Current weather	String		True	BMPInspection_ExtendSchema_weather	25	True	False	Describes the current weather conditions during the inspection
rained24hours	Rained in the last 24 hours	String		True	BMPInspection_ExtendSchema_rained24hours	5	True	False	Indicates whether it rained in the last 24 hours
rainfall	How much rainfall	String		True	BMPInspection_ExtendSchema_rainfall	255	True	False	Specifies the amount of rainfall observed in the last 24 hours
accessed	Accessible	String		True	BMPInspection_ExtendSchema_accessed	5	True	False	Indicates whether the BMP site is accessible for inspection
replaced	Needs to be replaced	String		True	BMPInspection_ExtendSchema_replaced	5	True	False	Indicates if the BMP needs to be replaced
maintained	Needs to be maintained	String		True	BMPInspection_ExtendSchema_maintained	5	True	False	Indicates if the BMP requires maintenance
trash	Trash or debris	String		True	BMPInspection_ExtendSchema_trash	5	True	False	Indicates if there is the presence of trash or debris at the BMP site
vegetation	Vegetation needs maintenance	String		True	BMPInspection_ExtendSchema_vegetation	5	True	False	Indicates if vegetation at the BMP site needs maintenance
eroscontrol	Needs erosion control	String		True	BMPInspection_ExtendSchema_eroscontrol	5	True	False	Indicates whether erosion control measures are required
clean	Cleaning needed	String		True	BMPInspection_ExtendSchema_clean	5	True	False	Indicates if cleaning is needed at the BMP site
protect	Additional protection needed	String		True	BMPInspection_ExtendSchema_protect	5	True	False	Indicates if additional protection measures are necessary
illicitdis	Signs of illicit discharge	String		True	BMPInspection_ExtendSchema_illicitdis	5	True	False	Indicates signs of illicit discharge at the BMP site
notes	Inspection notes	String		True		255	True	False	Provides space for general notes about the inspection
other	Other needs	String		True	BMPInspection_ExtendSchema_other	5	True	False	Identifies other needs or issues not covered by specific fields
othernotes	Other notes	String		True		255	True	False	Allows for additional notes related to other needs or observations

Indexes

Name	Is Unique	Is Ascending	Field Name
PK__BMPInspe__F4B70D859F2960C8	True	True	OBJECTID
FDO_GlobalID	True	True	GlobalID

Domains

BMPInspection_ExtendSchema_accessed

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			accessed

BMPInspection_ExtendSchema_clean

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			clean

BMPInspection_ExtendSchema_eroscontrol

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			eroscontrol

BMPInspection_ExtendSchema_illicitdis

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			illicitdis

BMPInspection_ExtendSchema_maintained

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			maintained

BMPInspection_ExtendSchema_other

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

Code	Description	Details
Yes	Yes
No	No

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			other

BMPInspection_ExtendSchema_protect

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			protect

BMPInspection_ExtendSchema_rained24hours

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

Code	Description	Details
Yes	Yes
No	No

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			rained24hours

BMPInspection_ExtendSchema_rainfall

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

Code	Description	Details
0.00"	0.00"
0.01" < 0.25"	0.01" < 0.25"
0.25" < 0.50"	0.25" < 0.50"
0.50" < 0.75"	0.50" < 0.75"
0.75" < 1.00"	0.75" < 1.00"
1.00+"	1.00+"

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			rainfall

BMPInspection_ExtendSchema_replaced

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			replaced

BMPInspection_ExtendSchema_trash

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			trash

BMPInspection_ExtendSchema_vegetation

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

Code	Description	Details
Yes	Yes
No	No
NA	NA

Dataset	Subtype Code	Subtype Name	Field Name
BMPInspection_ExtendSchema			vegetation

BMPInspection_ExtendSchema_weather

Code	Description	Details
Sunny	Sunny
Cloudy	Cloudy
Raining	Raining
Snowing	Snowing
Windy	Windy