ST_UNARYUNION
📄字数 4.3K
👁️阅读量 加载中...
功能描述
计算单个几何体的并集。ST_Union 的单输入形式。
语法格式
sql
GEOMETRY ST_UNARYUNION(GEOMETRY geom, DOUBLE gridSize = -1);参数说明
- geomA：第一个目标 GEOMETRY 对象。
- geomB：第二个目标 GEOMETRY 对象。
- gridSize：指定大小的网格，可选。
函数返回类型
GEOMETRY 类型
使用说明
- 输入可以是单个几何图形、MultiGeometry 或 GeometryCollection。
- 并集应用于输入的各个元素。
- 此函数可用于修复由于重叠组件而无效的多重多边形。 但是，每个输入组件都必须有效。 无效的输入组件（例如领结多边形）可能会导致错误。 因此，最好使用 ST_MakeValid。
- 此函数可用于对交叉或重叠的线串集合进行节点化和分解，以使它们简单。
- 可以将 ST_UNARYUNION 与 ST_COLLECT 结合起来，以微调一次组合的几何图形数量。 这允许在内存使用和计算时间之间进行权衡，从而在 ST_UNION 和 ST_MEMUNION 之间取得平衡。
- 如果指定 gridSize 参数，则输入将捕捉到给定大小的网格，并在同一网格上计算结果顶点。
- 该函数支持 3d 并且不会丢失 z-index。 但是，结果仅使用 XY 计算。 结果 Z 值被复制、平均或插值。
示例
sql
SQL> select ST_AsText(ST_UnaryUnion('CIRCULARSTRING(220268 150415,220227 150505,220227 150406)' :: geometry));
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPR1 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| LINESTRING(220268 150415,220269.95064912012 150416.53936422797,220271.82341557532 150418.17258804003,220273.61378770717 150419.89573685703,220275.31745235244 150421.70465946247,220276.93030523375 150423.59499800342,220278.4484608472 150425.5621984887,220279.868261823 150427.60152176008,220281.18628773623 150429.70805490916,220282.39936334698 150431.87672311306,220283.50456624987 150434.10230186017,220284.49923391434 150436.37942953626,220285.38097009883 150438.7026203414,220286.14765062364 150441.06627750542,220286.7974284882 150443.46470677113,220287.3287383208 150445.89213011245,220287.74030014945 150448.34269965385,220288.0311224857 150450.8105117587,220288.20050471305 150453.28962125146,220288.24803877485 150455.77405574024,220288.17361015742 150458.25783000473,220287.9773981658 150460.7349604152,220287.6598754919 150463.19947934747,220287.22180707558 150465.6454495596,220286.6642482621 150468.06697849513,220285.9885422594 150470.45823247873,220285.19631690253 150472.81345077007,220284.28948073168 150475.12695944207,220283.27021839464 150477.39318504962,220282.14098538368 150479.60666805677,220280.90450211999 150481.7620759891,220279.56374740007 150483.85421628007,220278.1219512195 150485.8780487805,220276.58258699154 150487.8286979006,220274.94936317948 150489.7014643558,220273.22621436248 150491.49183648766,220271.41729175704 150493.19550113293,220269.5269532161 150494.80835401424,220267.5597527308 150496.3265096277,220265.52042945943 150497.74631060348,220263.41389631035 150499.06433651672,220261.24522810645 150500.27741212747,220259.01964935934 150501.38261503036,220256.74252168325 150502.37728269483,220254.4193308781 150503.25901887933,220252.0556737141 150504.02569940413,220249.65724444838 150504.6754772687,220247.22982110706 150505.20678710128,220244.77925156566 150505.61834892994,220242.3114394608 150505.9091712662,220239.83232996805 150506.07855349354,220237.34789547927 150506.12608755534,220234.86412121478 150506.0516589379,220232.3869908043 150505.85544694628,220229.92247187204 150505.5379242724,220227.4765016599 150505.09985585607,220225.05497272438 150504.5422970426,220222.66371874078 150503.8665910399,220220.30850044944 150503.07436568302,220217.99499177744 150502.16752951217,220215.7287661699 150501.14826717513,220213.51528316273 150500.01903416417,220211.3598752304 150498.78255090048,220209.26773493944 150497.44179618056,220207.24390243902 150496,220205.2932533189 150494.46063577203,220203.4204868637 150492.82741195997,220201.63011473184 150491.10426314297,220199.92645008658 150489.29534053753,220198.31359720527 150487.40500199658,220196.79544159182 150485.4378015113,220195.37564061602 150483.39847823992,220194.0576147028 150481.29194509084,220192.84453909204 150479.12327688694,220191.73933618914 150476.89769813983,220190.74466852468 150474.62057046374,220189.86293234018 150472.2973796586,220189.09625181538 150469.93372249458,220188.4464739508 150467.53529322887,220187.91516411823 150465.10786988755,220187.50360228957 150462.65730034615,220187.21277995332 150460.1894882413,220187.04339772597 150457.71037874854,220186.99586366417 150455.22594425976,220187.0702922816 150452.74216999527,220187.26650427323 150450.2650395848,220187.58402694712 150447.80052065253,220188.02209536344 150445.3545504404,220188.57965417692 150442.93302150487,220189.2553601796 150440.54176752127,220190.0475855365 150438.18654922993,220190.95442170734 150435.87304055793,220191.97368404438 150433.60681495038,220193.10291705534 150431.39333194323,220194.33940031903 150429.2379240109,220195.68015503895 150427.14578371993,220197.1219512195 150425.1219512195,220198.66131544748 150423.1713020994,220200.29453925954 150421.2985356442,220202.01768807654 150419.50816351234,220203.82661068198 150417.80449886707,220205.71694922293 150416.19164598576,220207.68414970822 150414.6734903723,220209.7234729796 150413.25368939652,220211.83000612867 150411.93566348328,220213.99867433257 150410.72258787253,220216.22425307968 150409.61738496964,220218.50138075577 150408.62271730517,220220.82457156092 150407.74098112067,220223.18822872493 150406.97430059587,220225.58665799064 150406.3245227313,220227 150406) |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
(1 row)