search

USACE / cwms-data-api

Corps Water Management System RESTful Data Service
MIT License
14 stars 14 forks source link

implement has data for TimeSeries and Location #360

Open MikeNeilson opened 1 year ago

MikeNeilson commented 1 year ago

This should assume at_ts_extents is up-to-date or the query will take forever.

rma-rripken commented 6 months ago

For timeseries could this be achieved by joining with extents and excluding rows where AV_TS_EXTENTS_UTC.VERSION_TIME AV_TS_EXTENTS_UTC.EARLIEST_TIME AV_TS_EXTENTS_UTC.LATEST_TIME AV_TS_EXTENTS_UTC.LAST_UPDATE are all null ?
Or is there a better way? This flag would be on the catalog calls -right?

rma-rripken commented 6 months ago

For the Location Catalog does hasData still refer to the timeseries extents?

MikeNeilson commented 6 months ago

That's a good question. Technically I think would only be one part of the equation. There's also the location levels.

@perrymanmd is there an equivalent to the extents for the location levels?

perrymanmd commented 6 months ago

No - there is no equivalent for location levels.