View In:   ArcGIS Online Map Viewer

Name: Monthly Inspection Data

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9664ec8c2248439da70105c2c444a4d9

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 16000

Max Record Count Factor: 1

Standard MaxRecord Count: 16000

Tile Max Record Count: 4000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -115.74893789999999
YMin: 0.0
XMax: 0.0
YMax: 45.63714656000002
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [153, 82, 70, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: true

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( modelName: objectid, nullable: false, defaultValue: N/A, editable: false, length: 4, alias: objectid, type: esriFieldTypeOID )
• globalid ( modelName: globalid, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• start_time ( modelName: start_time, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: start_time, type: esriFieldTypeDate )
• elapsed_time ( modelName: elapsed_time, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: elapsed_time, type: esriFieldTypeString )
• end_time ( modelName: end_time, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: end_time, type: esriFieldTypeDate )
• name ( modelName: name, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Inspector Name, type: esriFieldTypeString )
• email ( modelName: email, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: email, type: esriFieldTypeString )
• username ( modelName: username, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: username, type: esriFieldTypeString )
• regions ( modelName: regions, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Select your UDOT Region., type: esriFieldTypeString , Coded Values: [R1: Region 1] , [R2: Region 2] , [R3: Region 3] , ...1 more... )
• station_name ( modelName: station_name, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Select your Maintenance Station., type: esriFieldTypeString )
• station_notlisted ( modelName: station_notlisted, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: If the Facility is not listed in the selection above, please write the shed number and name here:, type: esriFieldTypeString )
• spills_leaks_defic ( modelName: spills_leaks_defic, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Did this facility have any spill(s), leak(s), or other deficiencies?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• deficiency_type ( modelName: deficiency_type, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Please select the type of deficiency that occurred., type: esriFieldTypeString )
• descrip_spills_leaks ( modelName: descrip_spills_leaks, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Describe the spill(s), leak(s), or other deficiencies identified., type: esriFieldTypeString )
• quantity ( modelName: quantity, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What was the approximate quantity of spilled or leaked material?, type: esriFieldTypeString )
• contained_spills_leaks ( modelName: contained_spills_leaks, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is the spill, leak, or other deficiency contained on-site?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• yes_corrective_actions ( modelName: yes_corrective_actions, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What corrective actions were taken to immediately remedy the spill, leak, or other deficiencies?, type: esriFieldTypeString )
• no_corrective_actions ( modelName: no_corrective_actions, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What circumstances prevented immediate corrective actions to be taken to remedy the spill, leak, or other deficiency?, type: esriFieldTypeString )
• no_follow_up ( modelName: no_follow_up, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What corrective actions were later taken to remedy the spill, leak, or other deficiency?, type: esriFieldTypeString )
• photo_y_n ( modelName: photo_y_n, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Please upload a photo of the spill, leak, or deficiency or any cleanup efforts, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• oil_containment ( modelName: oil_containment, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is there a used oil containment area, disposal container or tank that is used at this station?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• oil_contain_stain ( modelName: oil_contain_stain, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Are there oil stains or spills surrounding the used oil disposal area or container?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• oil_contain_sec ( modelName: oil_contain_sec, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Are there used oil containers outside of a secondary containment area?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• descip_sec_oil_con ( modelName: descip_sec_oil_con, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: If yes, please describe why secondary containment is not being used and take a photo of the container in question., type: esriFieldTypeString )
• oil_containment2 ( modelName: oil_containment2, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is there an additional used oil containment area, disposal container or tank that is used at this station?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• oil_contain_stain2 ( modelName: oil_contain_stain2, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Are there oil stains or spills surrounding the used oil disposal area or container?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• salt_shed1 ( modelName: salt_shed1, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is salt managed onsite at this location?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• salt_shed2 ( modelName: salt_shed2, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is the area surrounding the salt shed swept clean?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• ow_inspect ( modelName: ow_inspect, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Select "Yes" to continue with your monthly oil/water separator inspection; if there is no oil/water separator onsite, select "N/A" to skip. Reach out to your Region Stormwater Coordinator with any questions or concerns on this process or requirements for oil/water separators., type: esriFieldTypeString , Coded Values: [yes: Yes] , [na: N/A (This facility has no oil/water separators)] )
• ow_number ( modelName: ow_number, nullable: true, editable: true, defaultValue: N/A, alias: How many oil/water separators are at this site?, type: esriFieldTypeInteger )
• ow_photo1_loc ( modelName: ow_photo1_loc, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Where is this oil/water separator located? (i.e. wash bay, mechanic bay #1, etc.), type: esriFieldTypeString )
• ow_photo2_loc ( modelName: ow_photo2_loc, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Location of Oil/Water Separator #2, type: esriFieldTypeString )
• ow_photo3_loc ( modelName: ow_photo3_loc, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Location of Oil/Water Separator #3, type: esriFieldTypeString )
• ow_photo4_loc ( modelName: ow_photo4_loc, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Location of Oil/Water Separator #4, type: esriFieldTypeString )
• ow_photo5_loc ( modelName: ow_photo5_loc, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Location of Oil/Water Separator #5, type: esriFieldTypeString )
• owmaint_req ( modelName: owmaint_req, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: From visual inspection, do any of the oil/water separators require maintenance and/or cleaning at this time?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• clean_6mos ( modelName: clean_6mos, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Have all of the oil/water separators at this station been cleaned out or maintained in the last 6 months?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• who_maint ( modelName: who_maint, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Who will perform this maintenance or cleaning on the oil/water separator?, type: esriFieldTypeString , Coded Values: [UDOT: UDOT] , [contractor: Contracted O/W Cleanout Company] , [other: Other] )
• who_maint_other ( modelName: who_maint_other, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: If other, please describe., type: esriFieldTypeString )
• truck_wash ( modelName: truck_wash, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Does this facility have a retention pond used to collect truck wash water?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• yes_truck_wash ( modelName: yes_truck_wash, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: If yes, Is water overflowing out of the retention pond or is the pond close to overflowing?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• overflow_rent_pond ( modelName: overflow_rent_pond, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What percent of the pond is filled with water? Give your best estimate., type: esriFieldTypeString , Coded Values: [0: 0% (none)] , [1_10: 1 - 10%] , [11_25: 11 - 25%] , ...3 more... )
• pondinsp_yn ( modelName: pondinsp_yn, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Would you like to perform your Annual pond inspection at this time?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [na: N/A (This facility has no retention ponds)] )
• pondwater_yn ( modelName: pondwater_yn, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is there water left in this pond?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• waterinpond ( modelName: waterinpond, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: In order to complete this inspection, water must be fully evaporated or pumped from this pond., type: esriFieldTypeString )
• sedimentpct ( modelName: sedimentpct, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What percent of the pond is filled with dirt, sediment, or other debris?, type: esriFieldTypeString , Coded Values: [0: 0% (none)] , [1_10: 1 - 10%] , [11_25: 11 - 25%] , ...3 more... )
• linertype ( modelName: linertype, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Please select the type of Pond Liner(s) used at this facility., type: esriFieldTypeString )
• linertype_other ( modelName: linertype_other, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: If other Liner Type, please describe:, type: esriFieldTypeString )
• linercondition ( modelName: linercondition, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Please pick the statement that best describes the current condition of the pond liner., type: esriFieldTypeString , Coded Values: [immediate_repair: Extremely poor condition.
  Repairs are needed as soon as possible. Cracks or other damages to the liner(s) are significant and causing the pond to leak.] , [poor: Poor condition.
  Numerous, deep cracks or other noticeable damages. Without repair, the damages will likely cause leaks.] , [fair: Fair condition.
  Some small cracks or minor damages that are unlikely to cause issues with the pond leaking.] , ...2 more... )
• leakdetect_yn ( modelName: leakdetect_yn, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Does this pond have a leak detection device?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• leakdetect_condition ( modelName: leakdetect_condition, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Please select the statement(s) that best refelect the condition of the leak detection device., type: esriFieldTypeString )
• mainttype ( modelName: mainttype, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Over the last year which of the following types of maintenance have been performed on the pond at this facility?, type: esriFieldTypeString )
• mainttype_other ( modelName: mainttype_other, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Please describe any other maintenance performed on this pond., type: esriFieldTypeString )
• maintdate ( modelName: maintdate, nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: Please select the most recent date when maintenance was performed., type: esriFieldTypeDate )
• maintnotes ( modelName: maintnotes, nullable: true, editable: true, defaultValue: N/A, length: 1000, alias: If you have any additional notes on the maintenance performed, please add them below., type: esriFieldTypeString )
• discharge_point ( modelName: discharge_point, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What type of discharge point exists at this facility?, type: esriFieldTypeString , Coded Values: [OutfallPipeBox: Outfall Pipe/Box] , [SheetFlow: Sheet Flow] )
• training ( modelName: training, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Has your station completed its monthly training on a stormwater-related topic or SOP?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• descr_training ( modelName: descr_training, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: What stormwater-related topic or SOP did the training cover?, type: esriFieldTypeString )
• training_tracker ( modelName: training_tracker, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Has it been recorded in the Training Tracker Survey123 Form?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• reviewed_swppp ( modelName: reviewed_swppp, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Have you reviewed your facility's SWPPP for this inspection?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• info_correct ( modelName: info_correct, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is the information contained in the SWPPP correct?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• info_notcorrect ( modelName: info_notcorrect, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: If no, describe any necessary changes or reach out to your Region Stormwater Coordinator for help in correcting your SWPPP., type: esriFieldTypeString )
• signature_initial ( modelName: signature_initial, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: I acknowledge, to the best of my knowledge, that the information provided is correct., type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: N/A, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: N/A, length: 128, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: N/A, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: N/A, length: 128, alias: Editor, type: esriFieldTypeString )
• outfall_yes ( modelName: outfall_yes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is there an outfall pipe/box?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• sheetflow_yes ( modelName: sheetflow_yes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Is there a sheet flow, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• deficiency_note ( modelName: deficiency_note, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: It is required that all deficiencies found during this inspection are corrected within 30 days or a schedule for when they will be completed must be provided if it cannot be accomplished within 30 days. For any deficiencies noted during this inspection, please note when they were corrected or describe the plan to correct them., type: esriFieldTypeString )
• annual_sweeping ( nullable: true, editable: true, defaultValue: N/A, length: 256, alias: Did you perform your annual station sweeping of paved surfaces in the past month?, type: esriFieldTypeString )
• sub_date ( nullable: true, editable: true, defaultValue: N/A, precision: 1, length: 29, alias: Submission Date, type: esriFieldTypeDate )
• damage ( nullable: true, editable: true, defaultValue: N/A, length: 3, alias: Are any stormwater infrastructure components at the facility missing, damaged, or in need of repair?, type: esriFieldTypeString )
• damage_notes ( nullable: true, editable: true, defaultValue: N/A, length: 256, alias: Describe the deficient stormwater infrastructure components, type: esriFieldTypeString )
• latitude ( nullable: true, quotesRequired: true, editable: true, defaultValue: N/A, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( nullable: true, quotesRequired: true, editable: true, defaultValue: N/A, alias: Longitude, type: esriFieldTypeDouble )

Templates:

• Name: Monthly Inspection Data
  Description:
  Prototype:
  waterinpond: null
  ow_photo2_loc: null
  discharge_point: null
  spills_leaks_defic: null
  salt_shed2: null
  salt_shed1: null
  no_follow_up: null
  oil_containment2: null
  sheetflow_yes: null
  descip_sec_oil_con: null
  overflow_rent_pond: null
  ow_photo1_loc: null
  reviewed_swppp: null
  oil_contain_stain: null
  yes_corrective_actions: null
  longitude: null
  station_name: null
  ow_number: null
  deficiency_note: null
  leakdetect_condition: null
  maintdate: null
  mainttype: null
  owmaint_req: null
  descrip_spills_leaks: null
  leakdetect_yn: null
  start_time: null
  clean_6mos: null
  who_maint_other: null
  oil_contain_stain2: null
  name: null
  yes_truck_wash: null
  damage: null
  regions: null
  truck_wash: null
  linertype: null
  latitude: null
  sub_date: null
  training: null
  oil_contain_sec: null
  info_correct: null
  no_corrective_actions: null
  elapsed_time: null
  ow_photo5_loc: null
  email: null
  ow_inspect: null
  linercondition: null
  photo_y_n: null
  quantity: null
  ow_photo4_loc: null
  linertype_other: null
  descr_training: null
  end_time: null
  annual_sweeping: null
  outfall_yes: null
  training_tracker: null
  ow_photo3_loc: null
  pondinsp_yn: null
  oil_containment: null
  mainttype_other: null
  maintnotes: null
  pondwater_yn: null
  contained_spills_leaks: null
  signature_initial: null
  deficiency_type: null
  who_maint: null
  sedimentpct: null
  damage_notes: null
  info_notcorrect: null
  username: null
  station_notlisted: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• (1) -- Related To: outfallcondition (3)
• (2) -- Related To: sheetflow (5)

Capabilities: Query,Create,Update,Editing,Sync,Extract,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Date Bins   Query Bins   Apply Edits   Add Features   Update Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata