-
Notifications
You must be signed in to change notification settings - Fork 2
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
Raster calc functions #45
Comments
Hi @strk . Working on this little problem, quite difficult for me, perhaps very simple for you? So, to explain the query that I need to make: We have a set of rasters (aka datasets in a cube) for which I need to query the The problem with querying I'm currently experimenting with this: SELECT rid, band, (stats).* FROM (SELECT rid, band, ST_SummaryStats(rast, band) As stats FROM file_pszjkuicfjvxvizbygbq CROSS JOIN generate_series(1,1) As band ) As foo; Another problem with this approach, is that the raster is cut (due to pretiling) into 640 rows. So I'm getting results per row, and not for the whole. The end result should simply be the If you have time, @strk, could you help point me in the right direction? (By the way, will get back to you in the end of the week with some exciting developments with Systemapic...) References
|
Making progress on this, so no worries. :) |
We need to implement a few raster calculations:
1. min, max, avg per raster
In order to create this graph, we need to pull
min, max, avg
of each day (ie. each raster):Also need to create a js wrapper fn to concat all raster stats into one array (for each year, or for give range).
2. min, max, avg per raster, by geojson mask
Same as above, but instead of whole raster, only over an area (geojson mask).
The text was updated successfully, but these errors were encountered: