Layer: RIDOT_SCP_Data (ID:1)

View In: Map Viewer

Name: RIDOT_SCP_Data

Display Field: WB_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[201,252,220,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

WBID (type: esriFieldTypeString, alias: Waterbody ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [RI0001002L-09: RI0001002L-09], [RI0001002R-01A: RI0001002R-01A], [RI0001002R-01B: RI0001002R-01B], ... 298 more ...)
WB_NAME (type: esriFieldTypeString, alias: Waterbody Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
IMPAIRMENT (type: esriFieldTypeString, alias: Impairments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
TMDLS_FOR (type: esriFieldTypeString, alias: TMDLs, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
WATERTYP (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Fresh: Fresh], [Salt: Salt])
SCPGRPID (type: esriFieldTypeString, alias: SCP Group ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1050100: 1050100], [3020200: 3020200], [3020600: 3020600], ... 31 more ...)
SCPGRPNAME (type: esriFieldTypeString, alias: SCP Group Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SCP_STATUS (type: esriFieldTypeString, alias: Current SCP Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [To Be Completed: To Be Completed], [In Progress: In Progress], [Submitted: Submitted], ... 2 more ...)
CONSDEC (type: esriFieldTypeString, alias: Included in Consent Decree, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
PROPCHANGE (type: esriFieldTypeString, alias: Proposed Change, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Removal: Removal], [Addition: Addition], [Category Change: Category Change], ... 1 more ...)
REASON (type: esriFieldTypeString, alias: Reasoning, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Delisted: Delisted], [Newly listed: Newly listed], [No stormwater-related impairments: No stormwater-related impairments], ... 2 more ...)
CHANGEREQ_DATE (type: esriFieldTypeDate, alias: Requested Change Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CHANGEAPP_DATE (type: esriFieldTypeDate, alias: Approved Change Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DUE_DATE (type: esriFieldTypeDate, alias: SCP Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SUB_DATE (type: esriFieldTypeDate, alias: SCP Submittal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
APP_DATE (type: esriFieldTypeDate, alias: SCP Approval Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
RIDOT_PM (type: esriFieldTypeString, alias: RIDOT PM, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Joe Baker: Joe Baker], [Alisa Richardson: Alisa Richardson], [Allison Hamel: Allison Hamel], ... 3 more ...)
SCPCONSLT (type: esriFieldTypeString, alias: SCP Consultant, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Beta Group, Inc.: Beta Group, Inc.], [CDM Smith, Inc.: CDM Smith, Inc.], [Crossman Engineering, Inc.: Crossman Engineering, Inc.], ... 10 more ...)
SCPRESULTS (type: esriFieldTypeString, alias: Current SCP Results, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [No RIDOT roads: No RIDOT roads], [< 10% IC and no TMDL: < 10% IC and no TMDL], [Target met under existing conditions: Target met under existing conditions], ... 2 more ...)
TMDLMETHOD (type: esriFieldTypeString, alias: TMDL Method, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
ICMETHOD (type: esriFieldTypeString, alias: IC Method, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
ICBACTERIA (type: esriFieldTypeString, alias: IC Method for Bacteria Only, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
WSMOD (type: esriFieldTypeString, alias: Watershed Boundary Modification, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
WSMOD_SUB (type: esriFieldTypeDate, alias: Watershed Modification Submittal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
WSMOD_APP (type: esriFieldTypeDate, alias: Watershed Modification Approval Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PCTIMPER (type: esriFieldTypeDouble, alias: WS Percent Impervious, SQL Type: sqlTypeOther, nullable: true, editable: true)
WATERSHED_AREA (type: esriFieldTypeDouble, alias: Watershed Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
APPENDIX11 (type: esriFieldTypeString, alias: Appendix 11, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
SCP_PROP_SWEEP (type: esriFieldTypeString, alias: SCP Proposed Street Sweeping?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
CREDIT_CAP (type: esriFieldTypeDouble, alias: EPA Approved Percent NonRIDOT Credit, SQL Type: sqlTypeOther, nullable: true, editable: true)
St_Sweep_Notes (type: esriFieldTypeString, alias: Street Sweeping Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Potential_Site (type: esriFieldTypeString, alias: Potential Site, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Coastal (type: esriFieldTypeString, alias: Coastal, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Border_CT (type: esriFieldTypeString, alias: Bordering CT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Town (type: esriFieldTypeString, alias: Town/City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Barrington: Barrington], [Bristol: Bristol], [Burrillville: Burrillville], ... 35 more ...)
St_Sweep_Note (type: esriFieldTypeString, alias: Street Sweeping Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PotentialSite (type: esriFieldTypeString, alias: Potential Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Curbed (type: esriFieldTypeString, alias: Curbed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Adj_Land_Use (type: esriFieldTypeString, alias: Adjacent Land Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Agriculture: Agriculture], [Commercial: Commercial], [Forest: Forest], ... 5 more ...)
ClosedDrainage (type: esriFieldTypeString, alias: Closed Drainage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Street_Trees (type: esriFieldTypeString, alias: Street Trees/Cover, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/1/2023 3:33:52 AM

Schema Last Edit Date: 3/1/2023 3:33:52 AM

Data Last Edit Date: 2/18/2023 8:01:23 AM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat