Name: Monitoring Location Inspections

Display Field: FLOW

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 371f5271d2a74bdfa02ab21ae31d9f9f

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FLOW ( type: esriFieldTypeString, alias: Flow Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• FLOWTYPE ( type: esriFieldTypeString, alias: Flow Description, length: 15 , Coded Values: [Trickle: Trickle] , [Moderate: Moderate] , [Substantial: Substantial] )
• PHYSICALFLOW ( type: esriFieldTypeString, alias: Physical Indicators in Flow?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ODOR ( type: esriFieldTypeString, alias: Odor Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ODORSEWAGE ( type: esriFieldTypeString, alias: Sewage, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ODORSULFIDE ( type: esriFieldTypeString, alias: Sulfide, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ODORRANCIDSOUR ( type: esriFieldTypeString, alias: Rancid/Sour, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ODORPETROLEUM ( type: esriFieldTypeString, alias: Petroleum, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ODOROTHER ( type: esriFieldTypeString, alias: Other Odor, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• ODOROTHERTXT ( type: esriFieldTypeString, alias: Other Odor Description, length: 100 )
• ODORSEVERITY ( type: esriFieldTypeString, alias: Odor Severity Index, length: 50 , Coded Values: [1 - Faint: 1 - Faint] , [2 - Easily Detected: 2 - Easily Detected] , [3 - Noticeable From a Distance: 3 - Noticeable From a Distance] )
• COLOR ( type: esriFieldTypeString, alias: Color Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLORCLEAR ( type: esriFieldTypeString, alias: Clear, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLORGREEN ( type: esriFieldTypeString, alias: Green, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLORBROWN ( type: esriFieldTypeString, alias: Brown, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLORORANGE ( type: esriFieldTypeString, alias: Orange, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLORGRAY ( type: esriFieldTypeString, alias: Gray, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLORRED ( type: esriFieldTypeString, alias: Red, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLORYELLOW ( type: esriFieldTypeString, alias: Yellow, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLOROTHER ( type: esriFieldTypeString, alias: Other Color, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• COLOROTHERTXT ( type: esriFieldTypeString, alias: Other Color Description, length: 100 )
• COLORSEVERITy ( type: esriFieldTypeString, alias: Color Severity Index, length: 50 , Coded Values: [1 - Faint Colors in Sampel Bottle: 1 - Faint Colors in Sampel Bottle] , [2 - Clearly Visible in Sample Bottle: 2 - Clearly Visible in Sample Bottle] , [3 - Clearly Visible in Flow: 3 - Clearly Visible in Flow] )
• TURBIDITY ( type: esriFieldTypeString, alias: Turbitity Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• TURBIDITYSEVERITY ( type: esriFieldTypeString, alias: Turbidity Severity Index, length: 50 , Coded Values: [1 - Slight Cloudiness: 1 - Slight Cloudiness] , [2 - Cloudy: 2 - Cloudy] , [3- Opaque: 3 - Opaque] )
• FLOATABLES ( type: esriFieldTypeString, alias: Floatables Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• FLOATSEWAGE ( type: esriFieldTypeString, alias: Sewage (toilet paper, etc), length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• FLOATPETROL ( type: esriFieldTypeString, alias: Petroleum (oil sheen), length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• FLOATSUDS ( type: esriFieldTypeString, alias: Suds, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• FLOATOTHER ( type: esriFieldTypeString, alias: Other Floatables, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• FLOATOTHERTXT ( type: esriFieldTypeString, alias: Other Floatables Description, length: 100 )
• FLOATSEVERITY ( type: esriFieldTypeString, alias: Floatables Severity Index, length: 50 , Coded Values: [1- Few/Slight; Origin not Obvious: 1- Few/Slight; Origin not Obvious] , [2 - Some; Indications of Origin: 2 - Some; Indications of Origin] , [3 - Some; Origin Obvious: 3 - Some; Origin Obvious] )
• PHYSICALNOTFLOW ( type: esriFieldTypeString, alias: Physical Indicators Not Flow Related?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DAMAGE ( type: esriFieldTypeString, alias: Damage Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DAMAGESPALL ( type: esriFieldTypeString, alias: Spalling/Cracking/Chipping, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DAMAGEPAINT ( type: esriFieldTypeString, alias: Peeling Paint, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DAMAGECORROSION ( type: esriFieldTypeString, alias: Corrosion, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DAMAGEOTHER ( type: esriFieldTypeString, alias: Other Damage, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DAMAGEOTHERTXR ( type: esriFieldTypeString, alias: Other Damage Description, length: 100 )
• DAMAGECOM ( type: esriFieldTypeString, alias: Damage Comments, length: 150 )
• DEPSTAINS ( type: esriFieldTypeString, alias: Deposits/Stains Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DEPSTAINSOILY ( type: esriFieldTypeString, alias: Oily, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DEPSTAINSFLOWLINE ( type: esriFieldTypeString, alias: Flow Line, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DEPSTAINSPAINT ( type: esriFieldTypeString, alias: Paint, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DEPSTAINSOTHER ( type: esriFieldTypeString, alias: Other Deposits/Stains, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• DEPSTAINSOTHERTXT ( type: esriFieldTypeString, alias: Other Deposits/Stains Description, length: 100 )
• DEPSTAINSCOM ( type: esriFieldTypeString, alias: Deposits/Stains Comments, length: 150 )
• VEGETATION ( type: esriFieldTypeString, alias: Abnormal Vegetation Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• VEGETATIONEXC ( type: esriFieldTypeString, alias: Excessive, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• VEGETATIONINHIB ( type: esriFieldTypeString, alias: Inhibited, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• VEGETATIONCOM ( type: esriFieldTypeString, alias: Vegetation Comments, length: 150 )
• POOL ( type: esriFieldTypeString, alias: Poor Pool Quality?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLODORS ( type: esriFieldTypeString, alias: Odors, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLSUDS ( type: esriFieldTypeString, alias: Suds, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLCOLORS ( type: esriFieldTypeString, alias: Colors, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLALGAE ( type: esriFieldTypeString, alias: Excessive Algae, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLFLOAT ( type: esriFieldTypeString, alias: Floatables, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLSHEEN ( type: esriFieldTypeString, alias: Oil Sheen, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLOTHER ( type: esriFieldTypeString, alias: Other Pool Quality Issues?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• POOLOTHERTXT ( type: esriFieldTypeString, alias: Other Pool Quality Issue Description, length: 100 )
• POOLCOM ( type: esriFieldTypeString, alias: Poor Pool Quality Comments, length: 150 )
• PIPEBEN ( type: esriFieldTypeString, alias: Pipe Benthic Growth Present?, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• PIPEBENBROWN ( type: esriFieldTypeString, alias: Brown, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• PIPEBENORANGE ( type: esriFieldTypeString, alias: Orange, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• PIPEBENGREEN ( type: esriFieldTypeString, alias: Green, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• PIPEBENOTHER ( type: esriFieldTypeString, alias: Other Pipe Benthic Growth, length: 5 , Coded Values: [No: No] , [Yes: Yes] )
• PIPEBENOTHERTXT ( type: esriFieldTypeString, alias: Other Pipe Benthic Growth Description, length: 100 )
• PIPEBENCOM ( type: esriFieldTypeString, alias: Pipe Benthic Growth Comments, length: 150 )
• OVERALCHAR ( type: esriFieldTypeString, alias: Overall Monitoring Location Characterization, length: 60 , Coded Values: [Unlikely: Unlikely] , [Potential (presence of 2 or more indicators): Potential (presence of 2 or more indicators)] , [Obvious: Obvious] , ...1 more... )
• COID ( type: esriFieldTypeString, alias: Monitoring Location ID, length: 15 )
• INVESTIGTOR ( type: esriFieldTypeString, alias: Investigator(s), length: 25 )
• TEMP ( type: esriFieldTypeDouble, alias: Temperature (F) )
• Created_By ( type: esriFieldTypeString, alias: Created By, length: 255 )
• Date_Created ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• Edited_By ( type: esriFieldTypeString, alias: Edited By, length: 255 )
• Date_Edited ( type: esriFieldTypeDate, alias: Date of Inspection Edit, length: 8 )
• OVERALLCON ( type: esriFieldTypeString, alias: Overall Concerns/Comments, length: 150 )
• CLOSEDSUB ( type: esriFieldTypeString, alias: Closed Pipe Submerged in Water, length: 15 , Coded Values: [No: No] , [Partially: Partially] , [Fully: Fully] )
• CLOSEDSED ( type: esriFieldTypeString, alias: Closed Pipe Submerged with Sediment, length: 15 , Coded Values: [No: No] , [Partially: Partially] , [Fully: Fully] )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• WEATHER24 ( type: esriFieldTypeString, alias: Rainfall (in) Last 24 Hours, length: 20 , Coded Values: [0 - 0.25: 0 - 0.25] , [0.25 - 0.50: 0.25 - 0.50] , [0.50 - 0.75: 0.50 - 0.75] , ...6 more... )
• WEATHER48 ( type: esriFieldTypeString, alias: Rainfall (in) Last 48 Hours, length: 20 , Coded Values: [0 - 0.25: 0 - 0.25] , [0.25 - 0.50: 0.25 - 0.50] , [0.50 - 0.75: 0.50 - 0.75] , ...6 more... )

Relationships:

• OCGIS.DPW_STM_Monitoring_Location_Sampling (7) -- Related To: Monitoring Location Sampling (22)
• OCGIS.DPW_STM_Monitoring_Locations (6) -- Related To: Monitoring Locations (20)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata