PostGis部分时空索引函数

1. 转换函数
   #1.合并geom：ST_Union(geometry)
   #2.geom转WKT： ST_AsText(geometry)
   #3.WKT转geom：ST_GeomFromText(text,4326)
   #4.获取点对象x、y坐标值：st_x(geometry)、st_y(geometry)
   #5.获取线/面对象四角点坐标：st_xmin(geometry)、st_ymin(geom)、st_xmax(geometry)、st_ymax(geometry)
   #6.计算两点之间距离：st_distance(geometry,geometry)、st_distance(wkt,wkt)
   #7.计算线的长度：st_length(geometry)、st_length(wkt)
   #8.计算面积：st_area(geometry)、st_area(wkt)
   #9.geo转WKB：ST_AsBinary(geometry)
   #10.抽稀geom：ST_Simplify(geometry geomA, float tolerance, boolean preserveCollapsed)
   #11.获取几何对象的空间参考ID：ST_SRID(geometry)
   #12.获取几何对象的边界范围：ST_Envelope(geometry)
   #13.判断几何对象是否为空：ST_IsEmpty(geometry)
   #14.判断几何对象是否闭合：ST_IsClosed(geometry)
   #15.获取多几何对象中的对象个数：ST_NumGeometries(geometry)
   #16.获取多几何对象中第N个对象：ST_GeometryN(geometry,int)
   #17.获取几何对象中的点个数：ST_NumPoints(geometry)
   #18.获取几何对象的第N个点：ST_PointN(geometry,integer)
   #19.获取多边形的外边缘：ST_ExteriorRing(geometry)
   #20.获取多边形内边界个数：ST_NumInteriorRings(geometry)
   #21.同上：ST_NumInteriorRing(geometry)
   #22.获取多边形的第N个内边界：ST_InteriorRingN(geometry,integer)
   #23.获取线的终点：ST_EndPoint(geometry)
   #24.获取线的起始点：ST_StartPoint(geometry)
   #25.使geom合法：ST_MakeValid(geometry)

---

2. 对象关系函数
   #1.判断两个geom是否相交：ST_Intersects(geometry,geometry)
   #2.判断两个geom是否分离：ST_Disjoint(geometry,geometry)
   #3.判断两个geom的边缘是否接触：ST_Touches(geometry,geometry)
   #4.判断两个geom是否互相穿过：ST_Crosses(geometry,geometry)
   #5.判断A是否被B包含：ST_Within(geometry A, geometry B)
   #6.判断两个几何对象是否是重叠：ST_Overlaps(geometry, geometry)
   #7.判断A是否包含B：ST_Contains(geometry A, geometry B)
   #8.判断A是否覆盖 B：ST_Covers(geometry A, geometry B)
   #9.判断A是否被B所覆盖：ST_CoveredBy(geometry A, geometry B)

---

3. 获取对象信息
   ST_GeometryType(geometry) —— 返回几何图形的类型