I have used PostGIS raster to store data in database. This data needs to be updated several times a day. So far I am using approach with this query:
UPDATE data_tbl SET raw_data = (''::raster) WHERE id = 1; are my raw data converted to WKB using code from PostGIS WKB
I can also change only single value via this
UPDATE data_tbl SET raw_data = ST_SetValue(raw_data, , ,, ) WHERE id = 1;The second option is used only for small updates.
Is this a right approach, or should I use something else? I dont think, that running the second query for every x, y is a good idea, but maybe I am wrong and it is better than WKB. Or is there some 3rd option?
أكثر...
UPDATE data_tbl SET raw_data = (''::raster) WHERE id = 1; are my raw data converted to WKB using code from PostGIS WKB
I can also change only single value via this
UPDATE data_tbl SET raw_data = ST_SetValue(raw_data, , ,, ) WHERE id = 1;The second option is used only for small updates.
Is this a right approach, or should I use something else? I dont think, that running the second query for every x, y is a good idea, but maybe I am wrong and it is better than WKB. Or is there some 3rd option?
أكثر...