PG WORKSHOP

Geometry editors

Geometry editors kan også manipulere geometrier.

Eksempler

Flyt alle børnehaver 100 meter i hver retning

SELECT st_astext(wkb_geometry), st_astext(ST_Translate(wkb_geometry, 100,100) )FROM buf.boernehaver

Transformér til geografiske koordinater

SELECT st_astext(wkb_geometry), st_astext(ST_Transform(wkb_geometry, 4326) ) as latlon FROM buf.boernehaver

Snap geomtrierne så det følger et regulært grid

SELECT ogc_fid, ST_SnapToGrid(wkb_geometry, 100,100) FROM trafik.beboerzone

Simplificér geometrierne

SELECT ogc_fid, ST_Simplify(wkb_geometry,100) FROM trafik.beboerzone

--

[HANDS-ON]: Prøv selv at transformere geometrierne