NewGraphEnvironment / fish_passage_elk_2022_reporting

https://newgraphenvironment.github.io/fish_passage_elk_2022_reporting/
Creative Commons Zero v1.0 Universal
0 stars 1 forks source link

add discharge data summary table to report along with locations to map #42

Closed NewGraphEnvironment closed 1 year ago

NewGraphEnvironment commented 1 year ago

will put seperate table in each memo. Important to show the difference between upstream and downstream. really interesting actually.... Of note - the table below was copied and pasted straight up from the email. cool that the html is converted to markdown automatically

Streams Hydrometric Flow Data (m3/S) dd/mm/yy & time UTM (NAD 83/11U)
Brule upstream 0.016 m3/S 18/10/2022 & 10:30 650707 E, 5528331 N
Brule downstream 0.036 m3/S 18/10/2022 & 11:30 651833 E, 5528789 N
Weigert upstream 0.183 m3/S 18/10/2022 & 13:35 649110 E, 5531723 N
Weigert downstream 0.252 m3/S 18/10/2022 & 14:10 650657 E, 5532197 N
NewGraphEnvironment commented 1 year ago

@Mateo9569 - where is the script and csv that was used to load the data to the sqlite? If we don't have one thats not a big deal but if we do I can't seem to find it. In an ideal world the raw object has tidy column names and it takes seconds to alter the csv and reload to the sqlite reorganized.....

Mateo9569 commented 1 year ago

The csv is right here. And the script to import and load to the sqlite is at the end of the tables script. Maybe I should have put it somewhere else. I commented it out so it doesn't drop and reload the object to the sqlite everytime the report is run.

Mateo9569 commented 1 year ago

Looks like there was a mix up with Brule and Weigert in the csv. Weigert should be Brule and vice versa. I'll fix, re load to sqlite and close this issue. image