-- 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