Changes between Version 95 and Version 96 of WKTRasterTutorial01
- Timestamp:
- Sep 29, 2010, 7:30:31 AM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
WKTRasterTutorial01
v95 v96 118 118 The -I option tells the loader to create a spatial index on the raster tile table. The index is very important as it allow PostGIS WKT Raster to restrict his computing efforts only to the tiles involved in a spatial operation. In this tutorial for example, the intersection operations will be performed only on the tiles that actually intersects with the caribou points and it is much faster to search for those tiles if they are spatially indexed than try them one after the other sequentially in the raster table. 119 119 120 The result of the gdal2wktraster.py command is a 1.8 GB .sql file produced in about one minute (on my brand new Lenovo X201 la btop - Intel Core i5, 1.17 GHz, 3GB of RAM :-).120 The result of the gdal2wktraster.py command is a 1.8 GB .sql file produced in about one minute (on my brand new Lenovo X201 laptop - Intel Core i5, 1.17 GHz, 3GB of RAM :-). 121 121 122 122 The same way we loaded the caribou point sql command file, we will load this sql file using "psql":
