download the new Data File Converter 5.3.4

(-F) Include a field called filename to hold the name of the file the tiles were cut from. Break up the rasters into 128x128 pixel tiles and apply raster constraints. Load rasters Massachusetts state plane meters aerial tilesĪnd create a full view, 2 and 4 level overview tables, use copy mode for inserting (no intermediary file just straight to db), and -e don't force everything in a transaction (good if you want to see data in tables right away without waiting). Raster2pgsql -s 4326 -I -C -M *.tif -F -t 100x100 melevation | psql -d gisdb Raster2pgsql -s 4326 -I -C -M *.tif -F -t 100x100 melevation > elev.sqlĪ conversion and upload can be done all in one step using UNIX pipes: The raster table will be created in the default schema of the database or user Only 0 is supported at this time.Īn example session using the loader to create an input file and uploading it chunked in 100x100 tiles might look like this: Use copy statements instead of insert statements.Įxecute each statement individually, do not use a transaction.Ĭontrol endianness of generated binary output of raster specify 0 for XDR and 1 for NDR (default) only NDR output is supported now This applies to the primary key and the spatial index if the Specify the tablespace for the table's new index. The default tablespace unless the -X flag is also used. Note that indices (including the primary key) will still use Specify the tablespace for the new table. Skip NODATA value checks for each raster band. Implies -F.Ĭreate a GiST index on the raster column. Specify name of destination raster column, default is 'rast' Optional parameters used to manipulate database objects NODATA value to use on bands without a NODATA value. Note that your generated sql file will contain both the main table and overview tables. Stored in the database and is not affected by -R. Is a placeholder for numerical overview factor and Only the metadata of the raster and path location to the raster is stored in the database (not the pixels).Ĭreate overview of the raster. Register the raster as a filesystem (out-db) raster. Pad right-most and bottom-most tiles to guarantee that all tiles Is expressed as WIDTHxHEIGHT or set to the value 'auto' to allow the loader to compute an appropriate tile size using the first raster and applied to all rasters. If unspecified,Ĭut raster into tiles to be inserted one per table row.

For more than one band index, separate with comma (,). Index (1-based) of band to extract from raster.

If not provided or is zero, raster's metadata will be checked to determine an appropriate SRID. Assign output raster with specified SRID.

Download the new Data File Converter 5.3.4