on February 20, 2023

Raster2pgsql with GDAL Virtual File System /vsis3/

Geographic Information Systems

What is vsis3?

/vsis3/ is a file system handler that allows on-the-fly random reading of (primarily non-public) files available in AWS S3 buckets, without prior download of the entire file. It requires GDAL to be built against libcurl. It also allows sequential writing of files.

How do I import raster into PostGIS?

raster2pgsql is the default tool for importing rasters to PostGIS.



-d|a|c|p : These options are mutually exclusive:

  1. d : Drops and creates a table.
  2. a : Appends data to an existing table.
  3. c : Creates a new table.
  4. p : Turns on prepare mode. So no importing is done; only a table is created.


What is raster2pgsql?

The raster2pgsql is a raster loader executable that loads GDAL supported raster formats into sql suitable for loading into a PostGIS raster table. It is capable of loading folders of raster files as well as creating overviews of rasters.

Can you store raster in PostGIS?

The raster data type in PostGIS can be used to store any kind of raster data: images, elevation grids, model outputs, and more. One band, four band, multi-band and anything in between. This flexibility leads some beginners to dump all their imagery into the database as “step one” in a system design.
 

Is PostGIS faster than QGIS?

PostGIS = very fast. Barcharts don’t lie. As you can see from the graph earlier, it took PostGIS less than 10 % of the time to do the same analysis compared to QGIS and a Shapefile. If you are a GIS analyst and do processes like this every day, that can save you quite a lot of time in a year.
 

How do I import a raster image?

A global raster image is imported using the operation Import Raster in the sub-menu Import of the GPlates File menu. This will show a dialog requesting the user to choose the raster image file to be loaded.

How do I import raster data?

In ArcCatalog or the Catalog window, right-click the geodatabase, and click Import > Raster Datasets. to navigate to the raster datasets you want to import. Select the raster dataset you want to import and click Add. You can use the SHIFT or CTRL keys to select more than one raster dataset.

How do I load a raster dataset?

In ArcCatalog or the Catalog window, right-click the empty geodatabase raster dataset, point to Load, then click Load Data. and navigate to the location of the Input raster dataset you want to load, then select it. You can add more than one.