pg_gserialzed文档详解,为geometry数据结构组织(不包括sql)

GSERIALIZED是一种用于PostGIS的几何对象的序列化形式,它是一个字节数组,包含了LWGEOM的所有信息。设计考虑了大小、数据对齐和访问便利性之间的权衡。它支持递归读写,允许无限深度的嵌套集合,并且在结构前面包含SRID、维度信息和边界框。GSERIALIZED的版本2增加了更多可选元素和扩展标志,以适应未来可能的扩展。
摘要由CSDN通过智能技术生成
GSERIALIZED FORM
=================

The serialized form is a byte array, that holds all the information
stored in an LWGEOM, but in a flat structure, rather than an
in-memory tree. As with all such formats, trade-offs much be
made between size, data alignment, and convenience of access.

* It is understood that GSERIALIZED is to be used primarily (only)
  by PostGIS. Other users of the geometry library (for example, the
  loaders and dumpers) will serialize to WKB or EWKB or various text
  representations. Therefore, GSERIALIZED includes the uint32 "size"
  field at the top used by PostgreSQL for varlena types.
* GSERIALIZED is built to be read and written recursively, so that
  nested collections of collections (of ...) are possible without
  restrictions on depth.
* GSERIALIZED preserves double alignment of ordinate arrays. This will
  allow coordinate access without memcpy.
* GSERIALIZED includes a mandatory SRID, in recognition of the fact
  that most production use of PostGIS does actually use an SRID.
* GSERIALIZED places the dimensionality information, the SRID
  information and the bounding boxes at the front of the structure,
  and all sub-components inherit from those parent values.
* GSERIALIZED retains the idea of optional bounding boxes, so that small
  features do not carry the extra storage overhead of a largely redundant
  bounding box.

STRUCTURE
---------

Most of the internals of GSERIALIZED are anonymous. The start of the
"data" member can be the type number, or the bounding box, or an extended
flags area. Or some combination of the above.

typedef struct
{
  uint32 size; /* Use LWSIZE_SET() and LWSIZE_GET() macros to manipulate. */
  uchar srid[3]; /* 21 bits of SRID (and 3 spare bits) */
  uchar flags; /* High priority information */
  uchar data[1]; /* See gserialized.txt */
} GSERIALIZED;

SIZE
----

The first four bytes in the "size" member are meant to be compatible with
the PostgreSQL VARLENA header. Use SIZE_SET() and SIZE_GET() macros to
manipulate the "size". Be careful not to mis-set the size, or operations
in PostgreSQL will end up scribbling on memory it should not.

FLAGS (V1)
----------

In the v1 serialization we have used up all of our flags except the version
bits.

* HasZ        (0x01)
* HasM        (0x02)
* HasBBox     (0x04)
* IsGeodetic  (0x08)
* ReadOnly    (0x10)
* IsSolid     (0x20)
* VersionBit1 (0x40)
* VersionBit2 (0x80)

FLAGS (V2)
----------

The v2 serialization recovers the flag space used by less-important flags
and moves those flags to a new optional flag area.

* HasZ             (0x01)
* HasM             (0x02)
* HasBBox          (0x04)
* IsGeodetic       (0x08)
* Reserved         (0x10)
* HasExtendedFlags (0x20)
* VersionBit1      (0x40)
* VersionBit2      (0x80)

Potential uses of the reserved flag:

* IsLightPoint: signals that the geometry type is point, and that the
  double coordinates will begin immediately in the "data" member without
  the usual type number and padding bytes. Allows 2D points to be
  represented in a minimum of 24 bytes, rather than the current 32.

OPTIONAL ELEMENTS (V1)
----------------------

If the HasBBox flag is set, the serialization contains the optional BBox
section, which is 2*ndims*sizeof(float) in size, and consists of the
bounding box. Since the box consists of pairs of floats, the presence
or absence of the box does not affect the double alignment of the
geometry coordinates.

* 2D:  <xmin><xmax><ymin><ymax>
* 3D:  <xmin><xmax><ymin><ymax><zmin><zmax>
* 3DM: <xmin><xmax><ymin><ymax><mmin><mmax>
* 4D:  <xmin><xmax><ymin><ymax><zmin><zmax><mmin><mmax>

OPTIONAL ELEMENTS (V2)
----------------------

The v2 serialization has a lot more flag space, and therefor a lot of
extra room to flag potential optional elements in the serialization.

In order to keep the double coordinates in the geometry section
double aligned, optional elements should themselves be multiples of
8 bytes.

* ExtendedFlags: If the HasExtendedFlags flag is set, then 8 bytes
  of extra flag space (uint64_t) are inserted prior to the (optional) BBox
* BBox: See V1 above.

EXTENDED FLAGS (V2)
-------------------

The extended flags are not heavily used at present, but can be used
to expand the serialization with options in the future. Extended flags
use 8 bytes of space, to ensure that that the coordinates in the
geometry section (see below) remain double-aligned for direct
memory access.

* IsSolid (0x01)

Potential extra uses of extended flags are:

* IsValidChecked/IsValid: a pair of flags used to cache validity state
  in the serialization to make ST_IsValid() checks blindingly fast.
* HasGeometryHash: signals presence of optional hash value that provides
  a small identity check that can be used in prepared geometry cache
  management to determine of the cache is dirty without requiring
  a full read and comparison of the geometry.

GEOMETRY (V1 & V2)
------------------

After the header and optional elements comes the recursively
searchable geometry representations. Each type is double aligned,
so any combination is double aligned, and we start after a double
aligned standard header, so we are golden:

<pointype>
<npoints>       /* 0 if empty, 1 otherwise */
[double]
[double]
[double]

<linestringtype>
<npoints>      /* 0 if empty, N otherwise */
[double]
...
[double]

<polygontype>
<nrings>        /* 0 if empty, N otherwise */
<npointsring1>
<npointsring2>
<?pad?>         /* pad if nrings % 2 > 0 */
[double]
...
[double]

<collectiontype>
<ngeoms>        /* 0 if empty, N otherwise */
[geom]
...
[geom]

<circularstringtype>
<npoints>       /* 0 if empty, N otherwise */
[double]
...
[double]

<compoundstringtype>
<ngeoms>        /* 0 if empty, N otherwise */
[geom]
...
[geom]


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值