Tool để đưa ảnh Viễn Thám vào PostGIS Tình cờ là mình đang có việc cần làm việc với ảnh Viễn Thám nên cần đưa ảnh Raster vào PostGIS để có thể truy vấn, xem thêm bài dưới để rõ […]
Tag: raster
[draft] Một số truy vấn Raster trong PostGIS
Lưu nháp Một số truy vấn raster trong PostGIS –intersects with polygon CREATE TABLE public.intersects AS SELECT a.rast, b.* FROM public.t1 AS a, public.polygon AS b WHERE ST_Intersects(a.rast, b.geom); –intersects with point CREATE TABLE public.intersects_point AS SELECT a.rast, b.* FROM […]
Import Raster to PostgreSQL/PostGIS and View in QGIS
Import Raster to PostgreSQL/PostGIS and View in QGIS http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/raster2pgsql.html
|
1 |
<span class="go">raster2pgsql -I -C -s <SRID> <PATH/TO/RASTER FILE> <SCHEMA>.<DBTABLE> | psql -d <DATABASE></span> |
The command parameters are: <SRID>—Spatial reference identifier <PATH/TO/RASTER FILE>—Full path to the raster file (such as C:\MyData\land\landuse.tif) <SCHEMA>—Target schema where the new raster table will be created <DBTABLE>—New database table to be […]
[Note] Install GeoServer PGRaster community module
Posted on Posted in GIS, Tài liệuLeave a Comment on [Note] Install GeoServer PGRaster community module
Note lại để tìm hiểu tiếp =)) Previous setup We already have srtm_1arc_v3.tif raster on the postgis_raster database, in the rasters.dem table. The import was done using:
|
1 |
raster2pgsql -s 3763 -N -32767 -t 100x100 -I -C -M -d srtm_1arc_v3.tif rasters.dem <span class="pl-k">|</span> psql -d postgis_raster -h localhost -U geobox -p 5432 |
[Note] Querying PostGIS Raster Data in PosstgreSQL Install GeoServer PGRaster community module We will need the GeoServer PGRaster community […]
[Note] Querying PostGIS Raster Data in PosstgreSQL
Posted on Posted in Tài liệu, Viễn thám3 Comments on [Note] Querying PostGIS Raster Data in PosstgreSQL
Note lại để tìm hiểu :v Workshop PostGIS Raster This workshop aims to explain and exemplify the usage of PostGIS raster. Create and restore the database In order to start the workshop we will load an existing database. Using pgAdmin […]