Layers:

Layer: Cleanout (0)

Name: Cleanout

Display Field: LASTINSPECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 232012.76700526103
YMin: 83980.54825465381
XMax: 519836.8499681838
YMax: 509213.6764561981
Spatial Reference: 102730  (3438)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling 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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Created_User ( type: esriFieldTypeString , alias: Created User , length: 150 )
• Created_Date ( type: esriFieldTypeDate , alias: Created Date , length: 8 )
• Last_Edited_User ( type: esriFieldTypeString , alias: Last Edited User , length: 150 )
• Last_Edited_Date ( type: esriFieldTypeDate , alias: Last Edited Date , length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• LEGACYID ( type: esriFieldTypeInteger , alias: Legacy ID )
• STRUCTUREID ( type: esriFieldTypeInteger , alias: Structure ID )
• STRUCTURETYPE ( type: esriFieldTypeString , alias: Structure Type , length: 30 , Coded Values: [Bridge Scupper: Bridge Scupper] , [Catch Basin- General: Catch Basin- General] , [CB_Inlet: Catch Basin with Gutter Inlet] , ...12 more... )
• STRUCTURE_MATERIAL ( type: esriFieldTypeString , alias: Structure Material , length: 30 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [High-Density Polyethylene: High-Density Polyethylene] , ...6 more... )
• ACCESS ( type: esriFieldTypeString , alias: Access , length: 10 , Coded Values: [Grate: Grate] , [Manhole: Manhole] , [Other: Other] , ...1 more... )
• COVERSIZE_IN ( type: esriFieldTypeString , alias: Cover Size (Inches) , length: 30 )
• GRATETYPE ( type: esriFieldTypeString , alias: Grate Type , length: 30 , Coded Values: [High Capacity: High Capacity] , [High Capacity Bicycle Safe: High Capacity Bicycle Safe] , [Round: Round] , ...6 more... )
• OUTFALL_ID ( type: esriFieldTypeString , alias: Outfall ID , length: 8 )
• RIMELEVATION ( type: esriFieldTypeDouble , alias: Rim Elevation NAVD88 )
• INVERTELEVNAVD88 ( type: esriFieldTypeDouble , alias: Invert Out Elevation NAVD88 )
• BOTTOMELEVNAVD88 ( type: esriFieldTypeDouble , alias: NAVD88 Bottom Elevation of Structure )
• STRUCTUREDEPTH_FT ( type: esriFieldTypeDouble , alias: Structure Depth (Feet) )
• INVERTOUTDEPTH_FT ( type: esriFieldTypeDouble , alias: Invert Out Depth (Feet) )
• SUMPDEPTH_FT ( type: esriFieldTypeDouble , alias: Sump Depth (Feet) )
• NUMBEROFPIPES ( type: esriFieldTypeSmallInteger , alias: Total Number of Pipes )
• OILHOOD ( type: esriFieldTypeString , alias: Oil Hood , length: 8 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• OWNER ( type: esriFieldTypeString , alias: System Responsibility , length: 20 , Coded Values: [RIDOT: RIDOT] , [Another State Agency: Another State Agency] , [Municipality: Municipality] , ...5 more... )
• OWNER_VERIFIED ( type: esriFieldTypeString , alias: Responsibility Verified , length: 15 , Coded Values: [Survey Plat: Survey Plat] , [Other: Other] , [RIGL: RIGL] , ...2 more... )
• MAINTAINER ( type: esriFieldTypeString , alias: Maintained By , length: 20 , Coded Values: [RIDOT: RIDOT] , [Another State Agency: Another State Agency] , [Municipality: Municipality] , ...5 more... )
• MAINTAGREEMENT ( type: esriFieldTypeString , alias: Maintenance Agreement , length: 8 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• INSTALLYEAR ( type: esriFieldTypeDate , alias: Year Installed , length: 8 )
• NOTES ( type: esriFieldTypeString , alias: Notes , length: 254 )
• INTERCONNECTION ( type: esriFieldTypeString , alias: Interconnection , length: 8 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• INTERCONNECTDIRECT ( type: esriFieldTypeString , alias: Interconnection Direction , length: 30 , Coded Values: [Unknown: Unknown] , [From RIDOT: From RIDOT] , [To RIDOT: To RIDOT] )
• INTERCONNECTOWNER ( type: esriFieldTypeString , alias: Non-RIDOT System Owner , length: 20 , Coded Values: [RIDOT: RIDOT] , [Another State Agency: Another State Agency] , [Municipality: Municipality] , ...5 more... )
• CITY_TOWN ( type: esriFieldTypeString , alias: City or Town , length: 50 )
• STREET ( type: esriFieldTypeString , alias: Street Name , length: 50 )
• LIMITEDACCESS ( type: esriFieldTypeString , alias: Limited Access? , length: 8 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• LOCATION ( type: esriFieldTypeString , alias: Location/Access Notes , length: 100 )
• LRS_ID ( type: esriFieldTypeString , alias: LRS ID , length: 50 )
• WBID ( type: esriFieldTypeString , alias: Waterbody ID , length: 30 , Coded Values: [RI0001002L-09: RI0001002L-09] , [RI0001002R-01A: RI0001002R-01A] , [RI0001002R-01B: RI0001002R-01B] , ...315 more... )
• SUBWATERSHED ( type: esriFieldTypeString , alias: Waterbody Name , length: 75 )
• IMPAIRED ( type: esriFieldTypeString , alias: Flows to Impaired Watershed? , length: 8 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• EDITNOTES ( type: esriFieldTypeString , alias: Edit Notes , length: 150 )
• DATASOURCE ( type: esriFieldTypeString , alias: Asset Location Method , length: 20 , Coded Values: [Desktop Review: Desktop Review] , [Mapping GPS: Mapping GPS] , [Other: Other] , ...3 more... )
• FEATURESTATUS ( type: esriFieldTypeString , alias: Feature Status , length: 20 , Coded Values: [Abandonded: Abandonded] , [Active: Active] , [Child: Child] , ...6 more... )
• LASTIDDEINSPECTION ( type: esriFieldTypeDate , alias: Last IDDE Inspection Date , length: 8 )
• IDDESTATUS ( type: esriFieldTypeString , alias: IDDE Status , length: 35 , Coded Values: [Not Reviewed: Not Reviewed] , [Investigation Needed: Investigation Needed] , [Investigation On-going: Investigation On-going] , ...2 more... )
• CONDITION ( type: esriFieldTypeString , alias: Latest Condition , length: 20 )
• CONDITIONINDEX ( type: esriFieldTypeSmallInteger , alias: Latest Condition Index )
• LASTINSPECTIONDATE ( type: esriFieldTypeDate , alias: Last Condition Inspection Date , length: 8 )
• LASTCLEANDATE ( type: esriFieldTypeDate , alias: Last Cleaning Date , length: 8 )
• LASTREPAIRDATE ( type: esriFieldTypeDate , alias: Last Repair Date , length: 8 )
• INSPECTIONFREQ ( type: esriFieldTypeSmallInteger , alias: Inspection Frequency )
• LASTINSPECTNAME ( type: esriFieldTypeString , alias: Last IDDE Inspector Name , length: 30 )
• ParentID ( type: esriFieldTypeInteger , alias: ParentID )
• CCTV_STATUS ( type: esriFieldTypeString , alias: CCTV Status , length: 15 , Coded Values: [Complete: Complete] , [Scheduled: Scheduled] , [Incomplete: Incomplete] , ...1 more... )
• CCTV_FINDINGS ( type: esriFieldTypeString , alias: CCTV Findings , length: 50 , Coded Values: [No Issues: No Issues] , [Suspected IDDE: Suspected IDDE] , [Repairs Needed: Repairs Needed] , ...2 more... )
• CCTV_LIBRARY ( type: esriFieldTypeString , alias: CCTV Library , length: 254 )
• XCOORDINATE ( type: esriFieldTypeDouble , alias: XCoordinate )
• YCOORDINATE ( type: esriFieldTypeDouble , alias: YCoordinate )
• last_edited_user_nonFME ( type: esriFieldTypeString , alias: last_edited_user_nonFME , length: 250 )
• last_edited_date_nonFME ( type: esriFieldTypeDate , alias: last_edited_date_nonFME , length: 8 )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )
• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
Relationships:
• IDDE_Inspection_Form_Structures (0) -- Related To: Cleanout - IDDE Inspection Form (1)

Tables:

Table: Cleanout - IDDE Inspection Form (1)

Name: Cleanout - IDDE Inspection Form

Display Field: INSPECTOR

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• DATEINSPECT ( type: esriFieldTypeDate , alias: Inspection Date , length: 8 )
• INSPECTOR ( type: esriFieldTypeString , alias: Inspector Name , length: 30 )
• STRUCTUREFOUND ( type: esriFieldTypeString , alias: Structure Found , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• ACCESSIBLE ( type: esriFieldTypeString , alias: Accessible for Sampling , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• ACCESS_NOTES ( type: esriFieldTypeString , alias: Accessibility Notes , length: 250 )
• WEATHER ( type: esriFieldTypeString , alias: Weather Conditions , length: 15 , Coded Values: [Dry Weather: Dry Weather] , [Wet Weather: Wet Weather] )
• LASTRAIN ( type: esriFieldTypeDate , alias: Last Rain Event , length: 8 )
• RAINDURATION ( type: esriFieldTypeDouble , alias: Rain Event Duration (HRS) )
• RAINAMOUNT ( type: esriFieldTypeDouble , alias: Rain Event Amount (inches) )
• FLOW ( type: esriFieldTypeString , alias: Flow , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CLARITY ( type: esriFieldTypeString , alias: Clarity of Flow , length: 10 , Coded Values: [Clear: Clear] , [Cloudy: Cloudy] , [Opaque: Opaque] )
• ODOR ( type: esriFieldTypeString , alias: Odor , length: 15 , Coded Values: [Laundry: Laundry] , [None: None] , [Oil/gas: Oil/gas] , ...3 more... )
• COLOR ( type: esriFieldTypeString , alias: Color of Flow , length: 15 , Coded Values: [Brown: Brown] , [Green: Green] , [None: None] , ...4 more... )
• SEDIMENT ( type: esriFieldTypeString , alias: Sedimentation , length: 45 , Coded Values: [Failing - requires immediate action: Failing - requires immediate action] , [Poor - requires maintenance: Poor - requires maintenance] , [Good - inspect within 2 years: Good - inspect within 2 years] , ...1 more... )
• FLOATABLES ( type: esriFieldTypeString , alias: Floatables , length: 20 , Coded Values: [Laundry/Soap Suds: Laundry/Soap Suds] , [None: None] , [Oil Sheen: Oil Sheen] , ...2 more... )
• STAINING ( type: esriFieldTypeString , alias: Staining , length: 10 , Coded Values: [Black: Black] , [Brown: Brown] , [None: None] , ...4 more... )
• VISUALEVIDENCE ( type: esriFieldTypeString , alias: Visual Evidence of Illicit Discharge , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• NOTES ( type: esriFieldTypeString , alias: Notes , length: 1000 )
• FIELD_DUPLICATE ( type: esriFieldTypeString , alias: QA/QC Duplicate Field Sample , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• TEMP ( type: esriFieldTypeDouble , alias: Temperature (C) )
• TEMP_EXCEED ( type: esriFieldTypeString , alias: Temp abnormal , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_TEMP ( type: esriFieldTypeDouble , alias: dup Temperature (C) )
• DUP_TEMP_EXCEED ( type: esriFieldTypeString , alias: dup Temp abnormal , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CONDUCTIVITY ( type: esriFieldTypeDouble , alias: Conductivity (uS/cm) )
• CONDUCT_EXCEED ( type: esriFieldTypeString , alias: Conductivity >1000 uS/cm , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_CONDUCT ( type: esriFieldTypeDouble , alias: dup Conductivity (uS/cm) )
• DUP_CONDUCT_EXCEED ( type: esriFieldTypeString , alias: dup Conductivity >1000 uS/cm , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• PH ( type: esriFieldTypeDouble , alias: pH )
• PH_EXCEED ( type: esriFieldTypeString , alias: pH < 6 or pH > 8 , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_PH ( type: esriFieldTypeDouble , alias: dup pH )
• DUP_PH_EXCEED ( type: esriFieldTypeString , alias: dup pH < 6 or pH > 8 , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SALINITY ( type: esriFieldTypeDouble , alias: Salinity (ppt) )
• SALINITY_EXCEED ( type: esriFieldTypeString , alias: Salinity > 10 ppt , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_SALINITY ( type: esriFieldTypeDouble , alias: dup Salinity (ppt) )
• DUP_SALINITY_EXCEED ( type: esriFieldTypeString , alias: dup Salinity > 10 ppt , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• AMMONIA ( type: esriFieldTypeDouble , alias: Ammonia (mg/L) )
• AMMONIA_EXCEED ( type: esriFieldTypeString , alias: Ammonia => 0.5 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_AMMONIA ( type: esriFieldTypeDouble , alias: dup Ammonia (mg/L) )
• DUP_AMMONIA_EXCEED ( type: esriFieldTypeString , alias: dup Ammonia => 0.5 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CHLORINE ( type: esriFieldTypeDouble , alias: Chlorine (mg/L) )
• CHLORINE_EXCEED ( type: esriFieldTypeString , alias: Chlorine > 0.02 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_CHLORINE ( type: esriFieldTypeDouble , alias: dup Chlorine (mg/L) )
• DUP_CHLORINE_EXCEED ( type: esriFieldTypeString , alias: dup Chlorine > 0.02 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SURFACTANTS ( type: esriFieldTypeDouble , alias: Surfactants (mg/L) )
• SURFACTANTS_EXCEED ( type: esriFieldTypeString , alias: Surfactants => 0.25 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_SURFACTANTS ( type: esriFieldTypeDouble , alias: dup Surfactants (mg/L) )
• DUP_SURFACTANTS_EXCEED ( type: esriFieldTypeString , alias: dup Surfactants => 0.25 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• FIELD_NOTES ( type: esriFieldTypeString , alias: Field Sampling Notes , length: 250 )
• BACTERIA_SAMPLE ( type: esriFieldTypeString , alias: Bacteria Sample Collected , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• BACTERIA_SAMPLE_DATE ( type: esriFieldTypeDate , alias: Bacteria Sample Date , length: 8 )
• LAB_DUPLICATE ( type: esriFieldTypeString , alias: QA/QC Duplicate Lab Sample , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• LAB_SAMPLE_NO ( type: esriFieldTypeString , alias: Lab Sample No. , length: 20 )
• DUP_LAB_SAMPLE_NO ( type: esriFieldTypeString , alias: dup Lab Sample No. , length: 20 )
• FECAL_COLIFORM ( type: esriFieldTypeDouble , alias: Fecal Coliform (CFU/100mL) )
• FC_EXCEED ( type: esriFieldTypeString , alias: FC Results > 400 CFU/100 mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_FC ( type: esriFieldTypeDouble , alias: dup Fecal Coliform (CFU/100mL) )
• DUP_FC_EXCEED ( type: esriFieldTypeString , alias: dup FC Results > 400 CFU/100 mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• ENTERO ( type: esriFieldTypeDouble , alias: Enterococci (CFU/100mL or MPN/100mL) )
• ENTERO_EXCEED ( type: esriFieldTypeString , alias: Entero Results >61 (Fresh) or >104 (marine) CFU/100 mL or MPN/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_ENTERO ( type: esriFieldTypeDouble , alias: dup Enterococci (CFU/100mL or MPN/100mL) )
• DUP_ENTERO_EXCEED ( type: esriFieldTypeString , alias: dup Entero Results >61 (Fresh) or >104 (marine) CFU/100 mL or MPN/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• COLIPHAGE ( type: esriFieldTypeDouble , alias: Coliphage (PFU/100mL) )
• COLIPHAGE_EXCEED ( type: esriFieldTypeString , alias: Coliphage Results => 50 PFU/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_COLIPHAGE ( type: esriFieldTypeDouble , alias: dup Coliphage (PFU/100mL) )
• DUP_COLIPHAGE_EXCEED ( type: esriFieldTypeString , alias: dup Coliphage Results => 50 PFU/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• LAB_NOTES ( type: esriFieldTypeString , alias: Analysis Notes , length: 200 )
• INVESTIGATION_NEEDED ( type: esriFieldTypeString , alias: Investigation NEEDED , length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Pending: Pending] )
• GUID ( type: esriFieldTypeGUID , alias: GUID , length: 38 )
• PIPEID ( type: esriFieldTypeString , alias: PipeID , length: 15 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• created_user ( type: esriFieldTypeString , alias: created_user , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , length: 8 )
• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• LAB ( type: esriFieldTypeString , alias: Lab , length: 25 , Coded Values: [BAL: BAL] , [RIDOT: RIDOH] , [NETLab: NETLab] , ...6 more... )
• SURFACTANT_TEST_TYPE ( type: esriFieldTypeString , alias: Surfactant Test Type , length: 50 , Coded Values: [Optical Method: Optical Method] , [Singal Analyte Photometer: Single Analyte Photometer] )
• CONSULTANT ( type: esriFieldTypeString , alias: Consultant , length: 50 , Coded Values: [Beta Group, Inc.: Beta Group, Inc.] , [CDM Smith, Inc.: CDM Smith, Inc.] , [Crossman Engineering, Inc.: Crossman Engineering, Inc.] , ...16 more... )
• STRUCTUREID ( type: esriFieldTypeInteger , alias: Structure ID )
• QAQC_OVERRIDE ( type: esriFieldTypeString , alias: QAQC Override , length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• INSPECTION_REASON ( type: esriFieldTypeString , alias: Inspection Reason , length: 50 , Coded Values: [SCP Screening/Sampling: SCP Screening/Sampling] , [IDDE Investigation: IDDE Investigation] , [Monitoring: Monitoring] , ...3 more... )
• COTININE ( type: esriFieldTypeDouble , alias: Cotinine (ng/L) )
• ACETAMINOPHEN ( type: esriFieldTypeDouble , alias: Acetaminophen (ng/L) )
• PARAXANTHINE ( type: esriFieldTypeDouble , alias: Paraxanthine (ng/L) )
• ATENOLOL ( type: esriFieldTypeDouble , alias: Atenolol (ng/L) )
• CAFFEINE ( type: esriFieldTypeDouble , alias: Caffeine (ng/L) )
• METOPROLOL ( type: esriFieldTypeDouble , alias: Metoprolol (ng/L) )
• DIPHENHYDRAMINE ( type: esriFieldTypeDouble , alias: Diphenhydramine (ng/L) )
• CARBAMAZEPINE ( type: esriFieldTypeDouble , alias: Carbamazepine (ng/L) )
• PHARMA_EXCEED ( type: esriFieldTypeString , alias: Pharmaceutical Exceedance? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
Relationships:
• SWStructures (0) -- Related To: Cleanout (0)