ff6347
commented
4 years ago Some Insight into the issue and its data
From my logs for the middlelayer I can see the following request several times
2020-03-09 13:37:50 [32minfo[39m [index.js]: request body
{
"spot_id": 43,
"user_id": 8
}With the following error response
2020-03-09 13:37:55 [32minfo[39m [index.js]: response passed back from opencpu
{
"event": "response",
"payload": {
"data": {},
"success": [
false
],
"message": [
"Error in api_get_bathingspot(user_id) : length(data) == 1 is not TRUE\n"
]
},
"sessionID": "2db79bbc-1df2-4a46-9bc1-9abb025e6937"
}@hsonne This seems to be an issue with fhpredcit?
Bathingspot
SELECT "name",
"updatedAt",
"apiEndpoints",
"influenceRainwater",
"influenceAgriculture",
"influencePurificationPlant"
from bathingspot WHERE id = 43;| Key | Value |
|---|---|
| name | kleine Badewiese |
| updatedAt | 2020-03-09 10:44:59.029918 |
| apiEndpoints | {"dischargesUrl":"https://raw.githubusercontent.com/KWB-R/flusshygiene/gh-pages/q_tw.json"} |
| influenceRainwater | yes |
| influenceAgriculture | no |
| influencePurificationPlant | yes |
Predictions
SELECT * from bathingspot_prediction where "bathingspotId" = 43;Models
SELECT * from bathingspot_model WHERE "bathingspotId" = 43;| id | createdAt | version | updatedAt | rmodel | parameter | comment | evaluation | bathingspotId |
|---|---|---|---|---|---|---|---|---|
| 9 | 2020-02-20 15:36:27.791669 | 2 | 2020-02-20 15:36:27.795098 | Deprecated. Binary model file has been uploaded. | conc_ec | {"formula":"log_e.coli ~ q_mean_abs_1 + r_mean_mean_12","N":0.0002,"BP":0.0696,"R2":0.4928,"n_obs":160,"stat_correct":false,"in50":5,"below90":5,"below95":5,"in95":5} | 43 | |
| 13 | 2020-03-09 10:44:56.431728 | 2 | 2020-03-09 10:44:56.43549 | Deprecated. Binary model file has been uploaded. | conc_ec | {"formula":"log_e.coli ~ q_mean_abs_1 + r_mean_mean_12","N":0.0005,"BP":0.0874,"R2":0.4903,"n_obs":160,"stat_correct":false,"in50":5,"below90":5,"below95":5,"in95":5} | 43 |
Rain
SELECT count(*) from rain WHERE "bathingspotId" = 43; | count |
|---|
| 912 |
Measurements
SELECT count(*) from bathingspot_measurement WHERE "bathingspotId" = 43;| count |
|---|
| 248 |
Discharges
SELECT count(*) from discharge where "bathingspotId" = 43;| count |
|---|
| 4747 |
PurificationPlants
SELECT * from purification_plant WHERE "bathingspotId" = 43;| id | name | createdAt | updatedAt | bathingspotId | url |
|---|---|---|---|---|---|
| 9 | Ruhleben | 2020-01-06 15:30:28.699472 | 2020-01-22 14:25:11.383426 | 43 | https://kwb-r.github.io/flusshygiene/ka_ruh.json |
PPlant Measurements
SELECT count(*) from p_plant_measurement WHERE "purificationPlantId" = 9;| count |
|---|
| 3471 |
hsonne
Für Badestelle 43, User 8 sollten eigentlich alle Daten vorhanden sein um aktuelle Vorhersagen zu machen. Druck auf Vorhersage für zur Meldung "your request is being processed", führt jedoch zu keinem (sichtbaren) Ergebnis.