You should talk with Alessandro Furieri a.furi...@lqt.it who is currently working on adding Raster support to spatialite. http://www.gaia-gis.it/spatialite/
It may be more efficient to store the data separately in well used raster formats and attach them to the database as needed for queries. Alex P Kishor wrote: > I have a grid of 1000 x 1000 cells with their own data as well as 20 > years of daily weather data (20 * 365 = 7300 rows) for each contiguous > group of 50 x 50 cell. > > CREATE TABLE cells ( > cell_id INTEGER PRIMARY KEY, > other cell attributes, > lat, > lon, > met_grid_id INTEGER > ); > > cell_id met_grid_id > ------- ------------ > 0 0 > 1 0 > .. > 2499 0 > 2500 1 > 2501 1 > .. > 4999 1 > > CREATE TABLE met ( > met_id INTEGER PRIMARY KEY, > other met attributes, > met_grid_id INTEGER > ); > > met_id met_grid_id > ------ ----------- > 0 0 > 1 0 > .. > 7299 0 > 7300 1 > 7301 1 > .. > > CREATE VIRTUAL TABLE cell_index USING rtree ( > cell_id INTEGER, > minx REAL, > maxx REAL, > miny REAL, > maxy REAL > ) > > The db is about 350 MB with the cell table with 1000,000 rows and the > met table with 2,920,000 rows and the R*Tree index. > > Is there any other better way that jumps out at any of you? > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
