To load vector and raster layers into a PostGIS database built on PostgreSQL, you must configure the FEXPORT parameters in a specific way. The following table describes this configuration.
Parameter | Description |
---|---|
FILI | Specify the name of the file containing the layer(s) to be loaded. |
FILO | For raster layers, specify the connection information and the table name that will be used when the image channel or channels are loaded into the database as a record of the pci_raster table. The format of this string should be:
PG://username:password@server:portnumber/pci_raster?d=databasename&w=layer_name=rastername For vector layers, specify the connection information and table name that will be used when the vector layer is loaded into the database as a table. The format of this string should be: PG://username:password@server:portnumber/tablename?d=databasename&s=geometryfieldname Note:
|
DBIW | Leave blank. The entire layer will be processed by default. |
DBIC | For rasters, specify the channel number(s). Leave blank for vector layers (not applicable). |
DBIB | Not applicable. Leave blank. |
DBVS | For vector layers, specify the layer number. Leave blank for raster layers (not applicable). |
DBLUT | Not applicable. Leave blank. |
DBPCT | Not applicable. Leave blank. |
FTYPE | Use "PG" for the PostGIS format. |
FOPTIONS | Not applicable. Leave blank. |
The following EASI example demonstrates how to configure FEXPORT to load raster layers into PostGIS.
EASI>FILI=”C:\v103\demo\irvine.pix” EASI>FILO=”PG://user:pass@myserver:5286/pci_raster?d=mydatabasename” EASI>DBIW= EASI>DBIC=2 EASI>DBIB= EASI>DBVS= EASI>DBLUT= EASI>DBPCT= EASI>FTYPE=”PG” EASI>FOPTIONS= EASI>r FEXPORT
The following EASI example demonstrates how to configure FEXPORT to load vector layers into PostGIS:
EASI>FILI=”C:\v103\demo\irvine.pix” EASI>FILO=”PG://user:pass@myserver:5286/mytablename?d=mydatabase” EASI>DBIW= EASI>DBIC= EASI>DBIB= EASI>DBVS=25 EASI>DBLUT= EASI>DBPCT= EASI>FTYPE=”PG” EASI>FOPTIONS= EASI>r FEXPORT
© PCI Geomatics Enterprises, Inc.®, 2024. All rights reserved.