Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

fix FKdb & FWCdb_STL river timestamps #31

Open
7yl4r opened this issue Jun 10, 2021 · 15 comments
Open

fix FKdb & FWCdb_STL river timestamps #31

7yl4r opened this issue Jun 10, 2021 · 15 comments
Assignees
Labels
bug Something isn't working client-fwc

Comments

@7yl4r
Copy link
Member

7yl4r commented Jun 10, 2021

@dotis: I think the river data is not showing up on the dashboard because the timestamps in the .csv files are incorrect. Compare file contents for the working river (FWCdb_EFL) vs two not working:

[root@seashell imars-objects]# tail fk/DISCH_CSV_USGS/USGS_disch_FWCdb_EFL.csv 
1622246400,0.856,0.861,-0.004
1622332800,0.853,0.860,-0.007
1622419200,0.850,0.859,-0.009
1622505600,0.847,0.859,-0.011
1622592000,0.856,0.858,-0.002
1622678400,0.893,0.857,0.036
1622764800,0.911,0.857,0.055
1622851200,0.908,0.856,0.052
1622937600,0.902,0.855,0.047
1623024000,0.899,0.855,0.045

[root@seashell imars-objects]# tail fk/DISCH_CSV_USGS/USGS_disch_FKdb.csv 
738305,-50.074,33.995,-84.069
738306,18.528,35.353,-16.825
738307,67.863,36.711,31.152
738308,50.968,38.069,12.899
738309,-10.276,39.427,-49.703
738310,-0.832,40.785,-41.617
738311,25.210,42.143,-16.933
738312,32.403,43.501,-11.097
738313,28.357,44.859,-16.502
738314,0.000,46.217,-46.217

[root@seashell imars-objects]# tail fk/DISCH_CSV_USGS/USGS_disch_FWCdb_STL.csv 
738305,0.408,0.434,-0.026
738306,0.396,0.433,-0.037
738307,0.387,0.433,-0.046
738308,0.472,0.432,0.040
738309,0.506,0.432,0.074
738310,0.479,0.431,0.048
738311,0.354,0.430,-0.077
738312,0.338,0.430,-0.091
738313,0.299,0.429,-0.130
738314,0.293,0.428,-0.136

The db and grafana seem to be working - there are points for unix 738314 (Jan 1970) showing in the dash.

Let me know when you have updated the files and I will trigger the csv ts ingest again.

@7yl4r 7yl4r added this to the FWC deliverables due milestone Jun 10, 2021
@7yl4r 7yl4r added bug Something isn't working client-fwc labels Jun 10, 2021
@dotis
Copy link
Collaborator

dotis commented Jun 10, 2021 via email

@dotis
Copy link
Collaborator

dotis commented Jun 10, 2021 via email

@dotis
Copy link
Collaborator

dotis commented Jun 10, 2021 via email

@dotis
Copy link
Collaborator

dotis commented Jun 10, 2021 via email

@7yl4r
Copy link
Member Author

7yl4r commented Jun 10, 2021

ingesting now. give it an hr or so.

@dotis
Copy link
Collaborator

dotis commented Jun 11, 2021 via email

@7yl4r
Copy link
Member Author

7yl4r commented Jun 11, 2021 via email

@dotis
Copy link
Collaborator

dotis commented Jun 11, 2021 via email

@7yl4r
Copy link
Member Author

7yl4r commented Jun 11, 2021 via email

@dotis
Copy link
Collaborator

dotis commented Jun 11, 2021 via email

@7yl4r
Copy link
Member Author

7yl4r commented Jun 11, 2021 via email

@dotis
Copy link
Collaborator

dotis commented Jun 11, 2021 via email

@7yl4r
Copy link
Member Author

7yl4r commented Jun 11, 2021 via email

@dotis
Copy link
Collaborator

dotis commented Jun 11, 2021 via email

@7yl4r
Copy link
Member Author

7yl4r commented Jun 11, 2021 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working client-fwc
Projects
None yet
Development

No branches or pull requests

2 participants