search

kcigeospatial / Inlet-Field-and-Web-App-Configuration

Tracker for the Inlet Cleaning app
https://arcg.is/1imOaC
0 stars 1 forks source link

Some Cleaned Inlets remain blue in the tracking map #43

Closed talllguy closed 5 years ago

talllguy commented 5 years ago

Good morning Kristin,

I noticed that two inlets I did a few days ago are still blue on the map and haven’t changed to the proper color. I double checked and I see the surveys are in my outbox in Survey123.

Inlet 1601962.01 38.887510°N 76.889315°W

Inlet 1601963.003 38.887540°N 76.888411°W

Let me know if there is anything you need me to do on my end.

All the best, Tyler

talllguy commented 5 years ago

I spoke with @johnshiu about this.

Hi Elliott,

I think it’s because program category ETL is looking for CLI_PIPE_CONDITION to be ‘stable’ and the CLI_CLEAN_STATUS = ‘cleaned’; however, there are several cases where the CLI_CLEAN_STATUS = ‘cleaned’ and the CLI_PIPE_CONDITION is null. When it doesn’t fit any category, it defaults to ‘CLEANING_NEEDED’.

Should we allow CLI_PIPE_CONDITION to be null when setting to RECENT_CLEANED?

Thanks! John

talllguy commented 5 years ago

The issue here is that the pipe condition was null in both cases. Pipe condition is required in the Survey123 form. Therefore, it should be populated in the field.

@klangway please follow up with Tyler to check on the pipe condition for these two. Then we'll have @HollySchuelerKCI make the change in the data.

HollySchuelerKCI commented 5 years ago

This issue has been resolved.