-- sparql clear graph -- DB.DBA.TTLP (' "POINT(1 3)"^^ . "POINTZM(0 1 2 3)"^^ . "BOX(0 0, 2 3)"^^ . "LINESTRING(10 21, 12 23, 10 25)"^^ . "POLYGON((1 3,2 4,1 5,0 4,1 3))"^^ . "POLYGON((1.5 3.5,2.5 4.5,1.5 5.5,0.5 4.5,1.5 3.5))"^^ . # "POLYGON((1 3,2 4,1 5,0 4,1 3),(1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))"^^ . "MULTIPOLYGON(((1 3,2 4,1 5,0 4,1 3)),((1 2,2 1,1 0,0 1,1 2)))"^^ . "GEOMETRYCOLLECTION(POINT(0 0),MULTILINESTRING((1 5,0 1,4 0,5 4),(1 5,1 0,4 0,4 5)),MULTIPOLYGON(((1 3,2 4,1 5,0 4,1 3)),((1 2,2 1,1 0,0 1,1 2))))"^^ . ', 'http://geo-api-demo/', 'http://geo-api-demo/', 0) -- sparql select ?s, ?p, ?o, bif:st_xmin(?o) as ?xmin, bif:st_xmax(?o) as ?xmax, bif:st_ymin(?o) as ?ymin, bif:st_ymax(?o) as ?ymax from where { ?s ?p ?o } s p o xmin xmax ymin ymax VARCHAR VARCHAR VARCHAR DOUBLE PRECISION DOUBLE PRECISION DOUBLE PRECISION DOUBLE PRECISION _______________________________________________________________________________ http://geo-api-demo/linestring http://geo-api-demo/shape LINESTRING(10.000000 21.000000,12.000000 23.000000,10.000000 25.000000) 10 12 21 25 http://geo-api-demo/polygon2 http://geo-api-demo/shape POLYGON((1.500000 3.500000,2.500000 4.500000,1.500000 5.500000,0.500000 4.500000,1.500000 3.500000)) 0.5 2.5 3.5 5.5 http://geo-api-demo/collection http://geo-api-demo/shape GEOMETRYCOLLECTION(POINT(0.000000 0.000000),MULTILINESTRING((1.000000 5.000000,0.000000 1.000000,4.000000 0.000000,5.000000 4.000000),(1.000000 5.000000,1.000000 0.000000,4.000000 0.000000,4.000000 5.000000)),MULTIPOLYGON(((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)),((1.000000 2.000000,2.000000 1.000000,1.000000 0.000000,0.000000 1.000000,1.000000 2.000000)))) 0 5 0 5 http://geo-api-demo/multipolygon http://geo-api-demo/shape MULTIPOLYGON(((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)),((1.000000 2.000000,2.000000 1.000000,1.000000 0.000000,0.000000 1.000000,1.000000 2.000000))) 0 2 0 5 http://geo-api-demo/box1 http://geo-api-demo/shape BOX2D(0.000000 0.000000,2.000000 3.000000) 0 2 0 3 http://geo-api-demo/point4d http://geo-api-demo/shape POINTZM(0.000000 1.000000 2.000000 3.000000) 0 0 1 1 http://geo-api-demo/point2d http://geo-api-demo/shape POINT(1 3) 1 1 3 3 http://geo-api-demo/polygon1 http://geo-api-demo/shape POLYGON((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)) 0 2 3 5 -- sparql select ?s1 ?s2 from where { ?s1 ?p1 ?o1 . ?s2 ?p2 ?o2 filter (bif:st_intersects (?o1, ?o2)) } order by asc(str(?s1)) asc(str(?s2)) *** Error 42000: VD VS GEO..: for after check of geo intersects, some shape types (e.g., polygon rings and curves) are not yet supported at XXX of load 'GeoApiSparql.sql': sparql select ?s1 ?s2 from where { ?s1 ?p1 ?o1 . ?s2 ?p2 ?o2 filter (bif:st_intersects (?o1, ?o2)) } order by asc(str(?s1)) asc(str(?s2)) -- sparql select ?s1 ?s2 from where { ?s1 ?p1 ?o1 . ?s2 ?p2 ?o2 filter (bif:st_may_intersect (?o1, ?o2)) } order by asc(str(?s1)) asc(str(?s2)) s1 s2 VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/box1 http://geo-api-demo/box1 http://geo-api-demo/box1 http://geo-api-demo/collection http://geo-api-demo/box1 http://geo-api-demo/multipolygon http://geo-api-demo/box1 http://geo-api-demo/point2d http://geo-api-demo/box1 http://geo-api-demo/point4d http://geo-api-demo/box1 http://geo-api-demo/polygon1 http://geo-api-demo/collection http://geo-api-demo/box1 http://geo-api-demo/collection http://geo-api-demo/collection http://geo-api-demo/collection http://geo-api-demo/multipolygon http://geo-api-demo/collection http://geo-api-demo/point2d http://geo-api-demo/collection http://geo-api-demo/point4d http://geo-api-demo/collection http://geo-api-demo/polygon1 http://geo-api-demo/collection http://geo-api-demo/polygon2 http://geo-api-demo/linestring http://geo-api-demo/linestring http://geo-api-demo/multipolygon http://geo-api-demo/box1 http://geo-api-demo/multipolygon http://geo-api-demo/collection http://geo-api-demo/multipolygon http://geo-api-demo/multipolygon http://geo-api-demo/multipolygon http://geo-api-demo/point2d http://geo-api-demo/multipolygon http://geo-api-demo/point4d http://geo-api-demo/multipolygon http://geo-api-demo/polygon1 http://geo-api-demo/multipolygon http://geo-api-demo/polygon2 http://geo-api-demo/point2d http://geo-api-demo/box1 http://geo-api-demo/point2d http://geo-api-demo/collection http://geo-api-demo/point2d http://geo-api-demo/multipolygon http://geo-api-demo/point2d http://geo-api-demo/point2d http://geo-api-demo/point2d http://geo-api-demo/polygon1 http://geo-api-demo/point4d http://geo-api-demo/box1 http://geo-api-demo/point4d http://geo-api-demo/collection http://geo-api-demo/point4d http://geo-api-demo/multipolygon http://geo-api-demo/point4d http://geo-api-demo/point4d http://geo-api-demo/polygon1 http://geo-api-demo/box1 http://geo-api-demo/polygon1 http://geo-api-demo/collection http://geo-api-demo/polygon1 http://geo-api-demo/multipolygon http://geo-api-demo/polygon1 http://geo-api-demo/point2d http://geo-api-demo/polygon1 http://geo-api-demo/polygon1 http://geo-api-demo/polygon1 http://geo-api-demo/polygon2 http://geo-api-demo/polygon2 http://geo-api-demo/collection http://geo-api-demo/polygon2 http://geo-api-demo/multipolygon http://geo-api-demo/polygon2 http://geo-api-demo/polygon1 http://geo-api-demo/polygon2 http://geo-api-demo/polygon2 -- sparql select ?s1 ?s2 from where { ?s1 ?p1 ?o1 . ?s2 ?p2 ?o2 filter (bif:st_contains (?o1, ?o2)) } order by asc(str(?s1)) asc(str(?s2)) *** Error 42000: VD VS GEO..: for geo contains, only "shape contains point" case is supported in current version at XXX of load 'GeoApiSparql.sql': sparql select ?s1 ?s2 from where { ?s1 ?p1 ?o1 . ?s2 ?p2 ?o2 filter (bif:st_contains (?o1, ?o2)) } order by asc(str(?s1)) asc(str(?s2)) -- sparql select ?s1 ?s2 from where { ?s1 ?p1 ?o1 . ?s2 ?p2 ?o2 filter (bif:st_may_contain (?o1, ?o2)) } order by asc(str(?s1)) asc(str(?s2)) s1 s2 VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/box1 http://geo-api-demo/box1 http://geo-api-demo/box1 http://geo-api-demo/point2d http://geo-api-demo/box1 http://geo-api-demo/point4d http://geo-api-demo/collection http://geo-api-demo/box1 http://geo-api-demo/collection http://geo-api-demo/collection http://geo-api-demo/collection http://geo-api-demo/multipolygon http://geo-api-demo/collection http://geo-api-demo/point2d http://geo-api-demo/collection http://geo-api-demo/point4d http://geo-api-demo/collection http://geo-api-demo/polygon1 http://geo-api-demo/linestring http://geo-api-demo/linestring http://geo-api-demo/multipolygon http://geo-api-demo/box1 http://geo-api-demo/multipolygon http://geo-api-demo/multipolygon http://geo-api-demo/multipolygon http://geo-api-demo/point2d http://geo-api-demo/multipolygon http://geo-api-demo/point4d http://geo-api-demo/multipolygon http://geo-api-demo/polygon1 http://geo-api-demo/point2d http://geo-api-demo/point2d http://geo-api-demo/point4d http://geo-api-demo/point4d http://geo-api-demo/polygon1 http://geo-api-demo/point2d http://geo-api-demo/polygon1 http://geo-api-demo/polygon1 http://geo-api-demo/polygon2 http://geo-api-demo/polygon2 -- DB.DBA.TTLP (' "POLYGON((1 3,2 4,1 5,0 4,1 3),(1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))"^^ . ', 'http://geo-api-demo/', 'http://geo-api-demo/', 0) -- select earth_radius() earth_radius VARCHAR _______________________________________________________________________________ 6367.43568 -- select haversine_deg_km (-90,0,90,0) haversine_deg_km VARCHAR _______________________________________________________________________________ 20003.88915449353 -- select haversine_deg_km (0,0,0,180) - haversine_deg_km (-90,0,90,0) temp VARCHAR _______________________________________________________________________________ 33.61918829571368 -- select dist_from_point_to_line_segment (5, 5, 0, 3, 4, 0) dist_from_point_to_line_segment VARCHAR _______________________________________________________________________________ 4.6 -- select dist_from_point_to_line_segment (5, 0, 0, 3, 4, 0) dist_from_point_to_line_segment VARCHAR _______________________________________________________________________________ 1 -- select dist_from_point_to_line_segment (5, -1, 0, 3, 4, 0) dist_from_point_to_line_segment VARCHAR _______________________________________________________________________________ 1.414213562373095 -- select dist_from_point_to_line_segment (5, -5, 0, 3, 4, 0) dist_from_point_to_line_segment VARCHAR _______________________________________________________________________________ 5.099019513592784 -- select st_point (10, 20) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POINT(10 20) -- select st_point (10, 20, 30) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POINTZ(10.000000 20.000000 30.000000) -- select st_point (10, 20, 30, 40) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POINTZM(10.000000 20.000000 30.000000 40.000000) -- select st_point (10, 20, NULL, NULL) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POINT(10 20) -- select st_point (10, 20, NULL, 40) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POINTM(10.000000 20.000000 40.000000) -- select st_linestring (st_point (11,22), st_point (13, 24), st_point (13,24), st_point (15,26), st_point (17,28)) unnamed VARCHAR NOT NULL _______________________________________________________________________________ LINESTRING(11.000000 22.000000,13.000000 24.000000,15.000000 26.000000,17.000000 28.000000) -- select st_linestring (st_linestring (vector(vector (11,22), vector (13, 24))), st_linestring (vector (13,24), vector(vector (15,26), vector (17,28)))) st_linestring VARCHAR _______________________________________________________________________________ LINESTRING(11.000000 22.000000,13.000000 24.000000,15.000000 26.000000,17.000000 28.000000) -- select st_distance (st_point(0, 3), st_point (4, 0)) unnamed DOUBLE PRECISION NOT NULL _______________________________________________________________________________ 555.5009871161514 -- select st_distance (st_setsrid (st_point(0, 3), 0), st_setsrid (st_point (4, 0), 0)) st_distance VARCHAR _______________________________________________________________________________ 5 -- sparql select ?o where { ?s ?p ?o . filter (bif:isgeometry (?o)) } order by asc(str(?s)) limit 3 o VARCHAR _______________________________________________________________________________ BOX2D(0.000000 0.000000,2.000000 3.000000) GEOMETRYCOLLECTION(POINT(0.000000 0.000000),MULTILINESTRING((1.000000 5.000000,0.000000 1.000000,4.000000 0.000000,5.000000 4.000000),(1.000000 5.000000,1.000000 0.000000,4.000000 0.000000,4.000000 5.000000)),MULTIPOLYGON(((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)),((1.000000 2.000000,2.000000 1.000000,1.000000 0.000000,0.000000 1.000000,1.000000 2.000000)))) LINESTRING(10.000000 21.000000,12.000000 23.000000,10.000000 25.000000) -- select st_srid (st_point(0, 3)) unnamed INTEGER NOT NULL _______________________________________________________________________________ 4326 -- sparql select ?s, ?p, ?o, bif:st_get_bounding_box(?o) from where { ?s ?p ?o } order by asc(str(?s)) s p o callret-3 VARCHAR VARCHAR VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/box1 http://geo-api-demo/shape BOX2D(0.000000 0.000000,2.000000 3.000000) BOX2D(0.000000 0.000000,2.000000 3.000000) http://geo-api-demo/collection http://geo-api-demo/shape GEOMETRYCOLLECTION(POINT(0.000000 0.000000),MULTILINESTRING((1.000000 5.000000,0.000000 1.000000,4.000000 0.000000,5.000000 4.000000),(1.000000 5.000000,1.000000 0.000000,4.000000 0.000000,4.000000 5.000000)),MULTIPOLYGON(((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)),((1.000000 2.000000,2.000000 1.000000,1.000000 0.000000,0.000000 1.000000,1.000000 2.000000)))) BOX2D(0.000000 0.000000,5.000001 5.000001) http://geo-api-demo/linestring http://geo-api-demo/shape LINESTRING(10.000000 21.000000,12.000000 23.000000,10.000000 25.000000) BOX2D(9.999999 20.999997,12.000001 25.000003) http://geo-api-demo/multipolygon http://geo-api-demo/shape MULTIPOLYGON(((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)),((1.000000 2.000000,2.000000 1.000000,1.000000 0.000000,0.000000 1.000000,1.000000 2.000000))) BOX2D(0.000000 0.000000,2.000000 5.000001) http://geo-api-demo/point2d http://geo-api-demo/shape POINT(1 3) BOX2D(1.000000 3.000000,1.000000 3.000000) http://geo-api-demo/point4d http://geo-api-demo/shape POINTZM(0.000000 1.000000 2.000000 3.000000) BOXZM(0.000000 1.000000 2.000000 3.000000,0.000000 1.000000 2.000000 3.000000) http://geo-api-demo/polygon1 http://geo-api-demo/shape POLYGON((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)) BOX2D(0.000000 3.000000,2.000000 5.000001) http://geo-api-demo/polygon2 http://geo-api-demo/shape POLYGON((1.500000 3.500000,2.500000 4.500000,1.500000 5.500000,0.500000 4.500000,1.500000 3.500000)) BOX2D(0.500000 3.500000,2.500000 5.500001) http://geo-api-demo/polygon3 http://geo-api-demo/shape POLYGON((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000),(1.000000 3.500000,1.500000 4.000000,1.000000 4.500000,0.500000 4.000000,1.000000 3.500000)) BOX2D(0.000000 3.000000,2.000000 5.000001) -- sparql select ?s, bif:geometrytype(?o), bif:st_numgeometries(?o) from where { ?s ?p ?o } order by asc(str(?s)) s callret-1 callret-2 VARCHAR VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/box1 BOX2D 1 http://geo-api-demo/collection GEOMETRYCOLLECTION 3 http://geo-api-demo/linestring LINESTRING 1 http://geo-api-demo/multipolygon MULTIPOLYGON 2 http://geo-api-demo/point2d POINT 1 http://geo-api-demo/point4d POINTZM 1 http://geo-api-demo/polygon1 POLYGON 1 http://geo-api-demo/polygon2 POLYGON 1 http://geo-api-demo/polygon3 POLYGON 1 -- select st_geometryn (st_geometryn (st_ewkt_read ('GEOMETRYCOLLECTION(POINT(0 0),MULTILINESTRING((1 5,0 1,4 0,5 4),(1 5,1 0,4 0,4 5)),MULTIPOLYGON(((1 3,2 4,1 5,0 4,1 3)),((1 2,2 1,1 0,0 1,1 2))))'),3),1) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POLYGON((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)) -- sparql select ?s bif:st_numinteriorrings (?o) from where { ?s ?p ?o } order by asc(str(?s)) s callret-1 VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/box1 NULL http://geo-api-demo/collection NULL http://geo-api-demo/linestring NULL http://geo-api-demo/multipolygon 0 http://geo-api-demo/point2d NULL http://geo-api-demo/point4d NULL http://geo-api-demo/polygon1 0 http://geo-api-demo/polygon2 0 http://geo-api-demo/polygon3 1 -- sparql select ?s, bif:st_interiorringn (?o, bif:st_numinteriorrings (?o)) from where { ?s ?p ?o . filter (bif:st_numinteriorrings (?o) > 0)} order by asc(str(?s)) s callret-1 VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/polygon3 RING(1.000000 3.500000,1.500000 4.000000,1.000000 4.500000,0.500000 4.000000,1.000000 3.500000) -- select st_interiorringn (st_ewkt_read ('POLYGON((1 3,2 4,1 5,0 4,1 3),(1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))'), 1) unnamed VARCHAR NOT NULL _______________________________________________________________________________ RING(1.000000 3.500000,1.500000 4.000000,1.000000 4.500000,0.500000 4.000000,1.000000 3.500000) -- select st_astext (st_ewkt_read ('GEOMETRYCOLLECTION(POINT(0 0),MULTILINESTRING((1 5,0 1,4 0,5 4),(1 5,1 0,4 0,4 5)),MULTIPOLYGON(((1 3,2 4,1 5,0 4,1 3)),((1 2,2 1,1 0,0 1,1 2))))')) unnamed VARCHAR NOT NULL _______________________________________________________________________________ GEOMETRYCOLLECTION(POINT(0.000000 0.000000),MULTILINESTRING((1.000000 5.000000,0.000000 1.000000,4.000000 0.000000,5.000000 4.000000),(1.000000 5.000000,1.000000 0.000000,4.000000 0.000000,4.000000 5.000000)),MULTIPOLYGON(((1.000000 3.000000,2.000000 4.000000,1.000000 5.000000,0.000000 4.000000,1.000000 3.000000)),((1.000000 2.000000,2.000000 1.000000,1.000000 0.000000,0.000000 1.000000,1.000000 2.000000)))) -- sparql select ?s, bif:st_translate(?o, 0.1, 0.2) from where { ?s ?p ?o } order by asc(str(?s)) s callret-1 VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/box1 BOX2D(0.100000 0.200000,2.100000 3.200000) http://geo-api-demo/collection GEOMETRYCOLLECTION(POINT(0.100000 0.200000),MULTILINESTRING((1.100000 5.200000,0.100000 1.200000,4.100000 0.200000,5.100000 4.200000),(1.100000 5.200000,1.100000 0.200000,4.100000 0.200000,4.100000 5.200000)),MULTIPOLYGON(((1.100000 3.200000,2.100000 4.200000,1.100000 5.200000,0.100000 4.200000,1.100000 3.200000)),((1.100000 2.200000,2.100000 1.200000,1.100000 0.200000,0.100000 1.200000,1.100000 2.200000)))) http://geo-api-demo/linestring LINESTRING(10.100000 21.200000,12.100000 23.200000,10.100000 25.200000) http://geo-api-demo/multipolygon MULTIPOLYGON(((1.100000 3.200000,2.100000 4.200000,1.100000 5.200000,0.100000 4.200000,1.100000 3.200000)),((1.100000 2.200000,2.100000 1.200000,1.100000 0.200000,0.100000 1.200000,1.100000 2.200000))) http://geo-api-demo/point2d POINT(1.1 3.2) http://geo-api-demo/point4d POINTZM(0.100000 1.200000 2.000000 3.000000) http://geo-api-demo/polygon1 POLYGON((1.100000 3.200000,2.100000 4.200000,1.100000 5.200000,0.100000 4.200000,1.100000 3.200000)) http://geo-api-demo/polygon2 POLYGON((1.600000 3.700000,2.600000 4.700000,1.600000 5.700000,0.600000 4.700000,1.600000 3.700000)) http://geo-api-demo/polygon3 POLYGON((1.100000 3.200000,2.100000 4.200000,1.100000 5.200000,0.100000 4.200000,1.100000 3.200000),(1.100000 3.700000,1.600000 4.200000,1.100000 4.700000,0.600000 4.200000,1.100000 3.700000)) -- sparql select ?s, bif:st_transscale(?o, 0.1, 0.2, 0.1, 0.1) from where { ?s ?p ?o } order by asc(str(?s)) s callret-1 VARCHAR VARCHAR _______________________________________________________________________________ http://geo-api-demo/box1 BOX2D(0.010000 0.020000,0.210000 0.320000) http://geo-api-demo/collection GEOMETRYCOLLECTION(POINT(0.010000 0.020000),MULTILINESTRING((0.110000 0.520000,0.010000 0.120000,0.410000 0.020000,0.510000 0.420000),(0.110000 0.520000,0.110000 0.020000,0.410000 0.020000,0.410000 0.520000)),MULTIPOLYGON(((0.110000 0.320000,0.010000 0.420000,0.110000 0.520000,0.210000 0.420000,0.110000 0.320000)),((0.110000 0.220000,0.010000 0.120000,0.110000 0.020000,0.210000 0.120000,0.110000 0.220000)))) http://geo-api-demo/linestring LINESTRING(1.010000 2.120000,1.210000 2.320000,1.010000 2.520000) http://geo-api-demo/multipolygon MULTIPOLYGON(((0.110000 0.320000,0.010000 0.420000,0.110000 0.520000,0.210000 0.420000,0.110000 0.320000)),((0.110000 0.220000,0.010000 0.120000,0.110000 0.020000,0.210000 0.120000,0.110000 0.220000))) http://geo-api-demo/point2d POINT(0.11 0.32) http://geo-api-demo/point4d POINTZM(0.010000 0.120000 2.000000 3.000000) http://geo-api-demo/polygon1 POLYGON((0.110000 0.320000,0.010000 0.420000,0.110000 0.520000,0.210000 0.420000,0.110000 0.320000)) http://geo-api-demo/polygon2 POLYGON((0.160000 0.370000,0.060000 0.470000,0.160000 0.570000,0.260000 0.470000,0.160000 0.370000)) http://geo-api-demo/polygon3 POLYGON((0.110000 0.320000,0.010000 0.420000,0.110000 0.520000,0.210000 0.420000,0.110000 0.320000),(0.110000 0.370000,0.060000 0.420000,0.110000 0.470000,0.160000 0.420000,0.110000 0.370000)) -- select st_translate (st_ewkt_read ('POLYGON((1 3,2 4,1 5,0 4,1 3),(1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))'), 0.1, 0.2) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POLYGON((1.100000 3.200000,2.100000 4.200000,1.100000 5.200000,0.100000 4.200000,1.100000 3.200000),(1.100000 3.700000,1.600000 4.200000,1.100000 4.700000,0.600000 4.200000,1.100000 3.700000)) -- select st_transscale (st_ewkt_read ('POLYGON((1 3,2 4,1 5,0 4,1 3),(1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))'), 0.1, 0.2, 0.1, 0.1) unnamed VARCHAR NOT NULL _______________________________________________________________________________ POLYGON((0.110000 0.320000,0.010000 0.420000,0.110000 0.520000,0.210000 0.420000,0.110000 0.320000),(0.110000 0.370000,0.060000 0.420000,0.110000 0.470000,0.160000 0.420000,0.110000 0.370000)) -- select st_transform_by_custom_projection ( st_ewkt_read ('POLYGON((1 3,2 4,1 5,0 4,1 3),(1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))'), 'OLAEAPS', 20, 45) unnamed VARCHAR NOT NULL _______________________________________________________________________________ SRID=0;POLYGON((-0.352161 -0.627582,-0.332392 -0.617674,-0.348956 -0.599730,-0.368752 -0.609534,-0.352161 -0.627582),(-0.351386 -0.620657,-0.341498 -0.615717,-0.349784 -0.606732,-0.359678 -0.611647,-0.351386 -0.620657)) -- -- exit