1POLYGONIZE - simple polygon 2:memory: #use in-memory database 3SELECT AsText(Polygonize(GeomFromText('LINESTRING(0 0, 1 1, 0 2, -1 1, 0 0)'))); 41 # rows (not including the header row) 51 # columns 6AsText(Polygonize(GeomFromText('LINESTRING(0 0, 1 1, 0 2, -1 1, 0 0)'))) 7POLYGON((0 0, -1 1, 0 2, 1 1, 0 0)) 8 9 10 11