PostGIS 是一种扩展功能,适用于 PostgreSQL 对象关系数据库系统,它允许将 GIS(地理信息系统)对象存储在数据库中。PostGIS 包含对基于 GiST 的 R-Tree 空间索引的支持,以及用于分析和处理 GIS 对象的功能。
本手册的版本是 3.5.0dev
本作品已获得创作共用署名-相同方式共享 3.0 许可。。请随意使用这份材料,任何您喜欢的方式,但我们要求您将荣誉归于 PostGIS 项目,尽可能提供返回https://postgis.net的链接。
geometry_dump
行。geometry_dump
行。geometry_dump
行。geometry_dump
行。valid_detail
行,说明几何图形是否有效或无效,说明原因和位置。ST_Length
的别名ST_Perimeter
的别名。 ValidateTopology
的返回类型。schema_name
中名为 table_name
的表中删除拓扑几何列,并从 topology.layer 表中取消注册这些列。alinestring
定义的孤立边添加到连接两个现有孤立节点anode
和anothernode
的拓扑,并返回新边的边id。apoint
几何对象已存在作为一个节点,则会抛出错误。返回移动的描述。aface
。topoelementarray
。topoelementarray
(包含拓扑元素的数组),其中包含给定TopoGeometry的拓扑元素和类型(原始元素)。 topoelement
对象,其中包含给定 TopoGeometry(原始元素)的拓扑 element_id、element_type。exclude_nodata_value
设置为 false,则所有像素都被认为与 nodata
像素相交并返回其值。如果未传递参数 exclude_nodata_value
,则从栅格的元数据中读取该值。 NODATA
值或以与栅格相同的空间参考坐标系表示的几何点。 NODATA
值的二维双精度数组,该给定波段像素由 columnX 和 rowY 或以与栅格相同的空间参考坐标系表示的几何点指定。 crop
is not specified or TRUE, the output raster is cropped.TRUE
if A's bounding box intersects B's bounding box.TRUE
if A's bounding box is to the left of B's.TRUE
if A's bounding box is to the right of B's.TRUE
if A's bounding box is the same as B's. Uses double precision bounding box.TRUE
if A's bounding box is contained by B's. Uses double precision bounding box.TRUE
。TRUE
if A's bounding box is contains B's. Uses double precision bounding box.tiger_data
if no schema is specified.county_all
, state_all
or state code followed by county
or state
.tiger_data
if no schema is specified.normalized_address
(addy) for each location, and the rating. The lower the rating the more likely the match. Results are sorted by lowest rating first. Can optionally pass in maximum results, defaults to 10. Uses Tiger data (edges, faces, addr), PostgreSQL fuzzy string matching (soundex, levenshtein).tiger_data
schema. Each state script is returned as a separate record.tiger_data
schema. Each state script is returned as a separate record. Latest version supports Tiger 2010 structural changes and also loads census tract, block groups, and blocks tables.norm_addy
type that has road suffix, prefix and type standardized, street, streetname etc. broken into separate fields. This function will work with just the lookup data packaged with the tiger_geocoder (no need for tiger census data).norm_addy
type that has road suffix, prefix and type standardized, street, streetname etc. broken into separate fields. This function will work with just the lookup data packaged with the tiger_geocoder (no need for tiger census data). Requires address_standardizer extension.norm_addy
composite type object, returns a pretty print representation of it. Usually used in conjunction with normalize_address.