User Tools

Site Tools


api:dk11:net:tatukgis.ndk.tgis_filepixelstorelibpq

TGIS_FilePixelStoreLibpq class

DK11 for .NET | TatukGIS.NDK.TGIS_FilePixelStoreLibpq | Classes | Constructors | Fields | Methods | Properties

Encapsulation of PixelStore layer via PostgreSQL client access library (libpq.dll).

Available also on: Delphi.

Syntax

// C#
public class TGIS_FilePixelStoreLibpq : TGIS_FilePixelStoreAbstract
{
}
' VisualBasic
Public Class TGIS_FilePixelStoreLibpq
  Inherits TGIS_FilePixelStoreAbstract
End Class
// Oxygene
type
  TGIS_FilePixelStoreLibpq = public class( TGIS_FilePixelStoreAbstract )
  end;

Inheritance

→ TGIS_ObjectDisposable → TGIS_FilePixelTGIS_FilePixelStoreAbstract

Constructors

Inherited Overrides Protected
Name Visibility Description
TGIS_FilePixelStoreLibpq() public Create and instance.
TGIS_FilePixelStoreLibpq(string, TGIS_Extent, int, int, TGIS_LayerPixelSubFormat, int, TGIS_CSCoordinateSystem) public Create and open a new pixel file.

Fields

Inherited Protected
Name Visibility Description
FCapabilities protected List of TGIS_PixelCapabilities.
(Inherited from TGIS_FilePixel)
FColor protected Background color of the image.
(Inherited from TGIS_FilePixelStoreAbstract)
FCompressionLevel protected The compression of image.
(Inherited from TGIS_FilePixel)
FCS protected Coordinate system.
(Inherited from TGIS_FilePixel)
FExtent protected Extent of the layer.
(Inherited from TGIS_FilePixelStoreAbstract)
FHeight protected The height of bitmap in pixels.
(Inherited from TGIS_FilePixel)
FImageType protected Type of the image used as a storage.
(Inherited from TGIS_FilePixelStoreAbstract)
FIsGrid protected Is Grid?.
(Inherited from TGIS_FilePixelStoreAbstract)
FLevel protected Level of the hierarchy.
(Inherited from TGIS_FilePixelStoreAbstract)
FMaxLevel protected Maximum level of the hierarchy.
(Inherited from TGIS_FilePixelStoreAbstract)
FName protected Name of the pixel store - used only if opened by TGIS_LayerPixelStore.
(Inherited from TGIS_FilePixelStoreAbstract)
FOnBusy protected Busy event.
(Inherited from TGIS_FilePixel)
FPath protected Path to file with layer data.
(Inherited from TGIS_FilePixelStoreAbstract)
FPixelFormat protected The pixel format of bitmap.
(Inherited from TGIS_FilePixel)
FPixelSize protected Size in of the single pixel in layer units.
(Inherited from TGIS_FilePixelStoreAbstract)
FPpi protected The PPI of image.
(Inherited from TGIS_FilePixel)
FRelativePath protected Relative path to a project file.
(Inherited from TGIS_FilePixelStoreAbstract)
FSQLCommands protected List of sql commands.
(Inherited from TGIS_FilePixelStoreAbstract)
FSQLDialectList protected SQL dialect (list of tokens) attached to the layer.
(Inherited from TGIS_FilePixelStoreAbstract)
FSQLParameters protected Connection parameters.
(Inherited from TGIS_FilePixelStoreAbstract)
FSubFormat protected Current subformat information.
(Inherited from TGIS_FilePixel)
FTable protected Name of the table.
(Inherited from TGIS_FilePixelStoreAbstract)
FWidth protected The width of bitmap in pixels.
(Inherited from TGIS_FilePixel)
FWKT protected WKT projection String.
(Inherited from TGIS_FilePixelStoreAbstract)
FWriteTileHeight protected The height of bitmap tile upon writing.
(Inherited from TGIS_FilePixel)
FWriteTileWidth protected The width of bitmap tile upon writing.
(Inherited from TGIS_FilePixel)
isReadOnly protected Is table read only?
(Inherited from TGIS_FilePixelStoreAbstract)
oGisDb protected Database supporting class handle.
(Inherited from TGIS_FilePixelStoreAbstract)
strCatalog protected Parsed catalog name.
(Inherited from TGIS_FilePixelStoreAbstract)
strName protected Parsed table name.
(Inherited from TGIS_FilePixelStoreAbstract)
strSchema protected Parsed schema name.
(Inherited from TGIS_FilePixelStoreAbstract)

Methods

Inherited Overrides Protected
Name Visibility Description
AddCell public Add a new cell based on a bitmap.
(Inherited from TGIS_FilePixelStoreAbstract)
AddCellEx public Add a new cell based on a bitmap.
(Inherited from TGIS_FilePixelStoreAbstract)
AddCellGrid public Add a new cell based on a bitmap.
(Inherited from TGIS_FilePixelStoreAbstract)
calculateScope protected Calculate the scope that covers a given extent.
(Inherited from TGIS_FilePixelStoreAbstract)
CurrentCell public Get current cell in the scope.
(Inherited from TGIS_FilePixelStoreAbstract)
doCreate protected Called by Create and CreateForWrite methods.
(Inherited from TGIS_FilePixelStoreAbstract)
doCreateForWrite protected Create and open a new PixelStore file.
(Inherited from TGIS_FilePixelStoreAbstract)
doPrerecognize protected Prerecognize PixelStore format.
(Inherited from TGIS_FilePixelStoreAbstract)
Eof public Is the end of the scope?
(Inherited from TGIS_FilePixelStoreAbstract)
FinalizeWrite public Do any operation required to safely finalize write operation like building quad trees for TGIS_FilePixelStore.
(Inherited from TGIS_FilePixelStoreAbstract)
GetAvailableLayers public Get available layers with their types from database.
(Inherited from TGIS_FilePixelStoreAbstract)
getCmd protected Return a SQL command associated with a given identifier.
(Inherited from TGIS_FilePixelStoreAbstract)
getSchemaPrefix protected Get schema prefix.
(Inherited from TGIS_FilePixelStoreAbstract)
InitializeWrite public Do any operation required to safely initialize write operation like batch operations for TGIS_FilePixelStore.
(Inherited from TGIS_FilePixelStoreAbstract)
macroAppendParams protected Return a SQL parametrized append command.
(Inherited from TGIS_FilePixelStoreAbstract)
macroConnect protected Macro for connecting to the database.
(Inherited from TGIS_FilePixelStoreAbstract)
macroDisconnect protected Macro for disconnecting to the database.
(Inherited from TGIS_FilePixelStoreAbstract)
macroMasterCreate protected Macro for creating master table
(Inherited from TGIS_FilePixelStoreAbstract)
macroTableCreate protected Macro for creating table.
(Inherited from TGIS_FilePixelStoreAbstract)
macroTableDrop protected Macro for dropping table.
(Inherited from TGIS_FilePixelStoreAbstract)
MoveFirst public Move to the first cell in the scope.
(Inherited from TGIS_FilePixelStoreAbstract)
MoveNext public Move to the next cell in the scope.
(Inherited from TGIS_FilePixelStoreAbstract)
Open public Open database connection to PixelStore
(Inherited from TGIS_FilePixelStoreAbstract)
parseConfigLayerName protected Parse config.
(Inherited from TGIS_FilePixelStoreAbstract)
passwordCallBack protected Process tokens in a SQLParameters property.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareAppendCmd protected Return a SQL parameterized append command.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareAppendCommand protected Return a SQL parameterized append command.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareAppendParams protected Return a SQL parametrized append command.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareCapabilities protected Prepare capabilities list.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareCommandList protected Copy list from resources into the internal list of commands.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareFilterCell protected Return filter for selected cell
(Inherited from TGIS_FilePixelStoreAbstract)
prepareSelectCommand protected Return a SQL select command.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareUpdateCmd protected Return a SQL parameterized update command.
(Inherited from TGIS_FilePixelStoreAbstract)
prepareUpdateCommand protected Return a SQL parameterized update command.
(Inherited from TGIS_FilePixelStoreAbstract)
Prerecognize public Check if format is supported.
(Overrides TGIS_FilePixelStoreAbstract.Prerecognize)
readCell protected Load a picture from the PixelStore.
(Inherited from TGIS_FilePixelStoreAbstract)
SetScope public Set scope based on scale and extent.
(Inherited from TGIS_FilePixelStoreAbstract)
setScopeQuad protected Select quad for a given cell.
(Inherited from TGIS_FilePixelStoreAbstract)
sqlQueryGetCell protected Read cell data.
(Overrides TGIS_FilePixelStoreAbstract.sqlQueryGetCell)
sqlTableAppend protected Append data to table.
(Overrides TGIS_FilePixelStoreAbstract.sqlTableAppend)
sqlTableOpenWrite protected Update data in table.
(Overrides TGIS_FilePixelStoreAbstract.sqlTableOpenWrite)
sqlTableSetCell protected Write cell data.
(Overrides TGIS_FilePixelStoreAbstract.sqlTableSetCell)
updateDialectList protected Update single parameter on SQLDialectList.
(Inherited from TGIS_FilePixelStoreAbstract)
updateFactor protected Update PixelStore factor
(Inherited from TGIS_FilePixelStoreAbstract)
UpdateSubFormat public Update subformat type.
(Inherited from TGIS_FilePixelStoreAbstract)
Write(int, int, Int32[], TGIS_PixelFormat, int, int) public Write a single chunk of a pixel file.
(Inherited from TGIS_FilePixelStoreAbstract)
Write(TGIS_Extent, int, Int32[], int, int) public Write a single chunk of a pixel file.
(Inherited from TGIS_FilePixelStoreAbstract)
WriteCell public Write current cell content to the database.
(Inherited from TGIS_FilePixelStoreAbstract)
WriteGrid(int, int, float[][]) public Write a single chunk of a grid file.
(Inherited from TGIS_FilePixelStoreAbstract)
WriteGrid(TGIS_Extent, int, int, int, float[][]) public
(Inherited from TGIS_FilePixelStoreAbstract)
writeLine protected Write an image line.
(Inherited from TGIS_FilePixel)
writeWorldFile protected Write extent to the world file (like .tfw, .bpw and .tab file).
(Inherited from TGIS_FilePixel)

Properties

Inherited Protected
Name Visibility Description
Capabilities public List of TGIS_PixelCapabilities.
(Inherited from TGIS_FilePixel)
CellSize public Size in pixels of a single cell.
(Inherited from TGIS_FilePixelStoreAbstract)
Color public Color of unfilled space of the image.
(Inherited from TGIS_FilePixelStoreAbstract)
CompressionLevel public The compression level of image.
(Inherited from TGIS_FilePixel)
Extent public Extent of the layer.
(Inherited from TGIS_FilePixelStoreAbstract)
Height public The height of bitmap in pixels.
(Inherited from TGIS_FilePixel)
ImageType public Type of the image used as a storage.
(Inherited from TGIS_FilePixelStoreAbstract)
IsGrid public Is Grid.
(Inherited from TGIS_FilePixelStoreAbstract)
Level public Level of the hierarchy.
(Inherited from TGIS_FilePixelStoreAbstract)
Name public Name of the pixel store - used only if opened by TGIS_LayerPixelStore.
(Inherited from TGIS_FilePixelStoreAbstract)
Path public Path to file with layer data; can contain also TGIS_FilePixelStoreAbstract.SQLParameters separated by CRLF or '\n'.
(Inherited from TGIS_FilePixelStoreAbstract)
PixelFormat public The pixel format of bitmap.
(Inherited from TGIS_FilePixel)
PixelSize public Size in of the single pixel in layer units.
(Inherited from TGIS_FilePixelStoreAbstract)
PPI public The PPI of image.
(Inherited from TGIS_FilePixel)
RelativePath public Relative path to a project file.
(Inherited from TGIS_FilePixelStoreAbstract)
SQLCommands public SQL Commands used for database operations.
(Inherited from TGIS_FilePixelStoreAbstract)
SQLDialectList public Dialect list in a form "token=replacement".
(Inherited from TGIS_FilePixelStoreAbstract)
SQLParameter public Connection parameters.
(Inherited from TGIS_FilePixelStoreAbstract)
SubFormat public Current subformat information.
(Inherited from TGIS_FilePixel)
Table public Name of the table.
(Inherited from TGIS_FilePixelStoreAbstract)
TableMaster public Name of the master table.
(Inherited from TGIS_FilePixelStoreAbstract)
Width public The width of bitmap in pixels.
(Inherited from TGIS_FilePixel)
WKT public Level of the hierarchy.
(Inherited from TGIS_FilePixelStoreAbstract)
WriteTileHeight public The height of bitmap tile upon writing.
(Inherited from TGIS_FilePixel)
WriteTileWidth public The width of bitmap tile upon writing.
(Inherited from TGIS_FilePixel)

Remarks

This layer can be opened by opening the file name_of_layer.ttkps or embeding all parameters to Path property as CRLF or '\n' delimited string.

Structure of this file must be:

[TatukGIS Layer]
Storage=PixelStore2
Layer=name|name;schema|name;schema;catalog
Dialect=POSTGRESQL
ReadOnly=True|False
Libpq=LIBPQ connection string

For example:

[TatukGIS Layer]
Storage=PixelStore
Layer=aerial;public;postgis
Dialect=POSTGRESQL
Libpq=host=machine_name port=5432 dbname=postgis user=postgres password=postgres client_encoding=WIN1250

This PixelStore2 can also be opened by providing SQLParameters property.

2019/06/26 01:14