Label

Books (1) CARTO (3) Fun (21) GBDX (1) geoserver (1) GIS (57) greed (4) memo (4) movie (1) music (2) python (4) R (12) statistics (10) study (20) swim (5) tools (19) Ubuntu (7)

2011/12/05

【PostGIS】ST_COLLECT

to convert multipart to single part and vise versa

ex. ST_CONVEXHULL(ST_COLLECT(the_geom))

ポイント→最外郭 : ポイントはシングルなのでマルチに変換しないと st_convexhullが動かない