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

Revisar filtro bounding box en servicio POST /:scope/variables/:id_variable/devices_group_timeserie #22

Open
ignaciodomingo opened this issue Feb 1, 2018 · 0 comments
Labels

Comments

@ignaciodomingo
Copy link
Contributor

ignaciodomingo commented Feb 1, 2018

Para POST /:scope/variables/:id_variable/devices_group_timeserie , si se usa el filtro de bounding box, la petición puede fallar con el error column "position" does not exist, si la tabla en cuestión no tiene la posición.

Esto ocurre por ejemplo en Aquagis para la variable aq_cons.sector.flow. Ejemplo:
POST https://urbo-aquagis-backend.geographica.gs/api/aljarafe/variables/aq_cons.sector.flow/devices_group_timeserie

{
   "agg":[
      "SUM"
   ],
   "vars":[
      "aq_cons.sector.flow"
   ],
   "groupagg":true,
   "time":{
      "start":"2018-01-31T11:00:00.000Z",
      "finish":"2018-02-01T11:00:00.000Z",
      "step":"1h"
   },
   "filters":{
      "bbox":[
         -5.9855184218354225,
         37.357065217232204,
         -6.13194557637587,
         37.31584649031966
      ]
   }
}

Habría que modificar el servicio para que haga join con la tabla lastdata para asegurar que la posición se encuentra siempre

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant