SELECT 'ndims01', ST_ndims(ST_geomfromewkt('MULTICURVE((
5 5 1 3,
3 5 2 2,
3 3 3 1,
0 3 1 1)
,CIRCULARSTRING(
0 0 0 0,
0.26794919243112270647255365849413 1 3 -2,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 1 2))'));
SELECT 'geometrytype01', geometrytype(ST_geomfromewkt('MULTICURVE((
5 5 1 3,
3 5 2 2,
3 3 3 1,
0 3 1 1)
,CIRCULARSTRING(
0 0 0 0,
0.26794919243112270647255365849413 1 3 -2,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 1 2))'));
SELECT 'ndims02', ST_ndims(ST_geomfromewkt('MULTICURVE((
5 5 1,
3 5 2,
3 3 3,
0 3 1)
,CIRCULARSTRING(
0 0 0,
0.26794919243112270647255365849413 1 3,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 1))'));
SELECT 'geometrytype02', geometrytype(ST_geomfromewkt('MULTICURVE((
5 5 1,
3 5 2,
3 3 3,
0 3 1)
,CIRCULARSTRING(
0 0 0,
0.26794919243112270647255365849413 1 3,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 1))'));
SELECT 'ndims03', ST_ndims(ST_geomfromewkt('MULTICURVEM((
5 5 3,
3 5 2,
3 3 1,
0 3 1)
,CIRCULARSTRING(
0 0 0,
0.26794919243112270647255365849413 1 -2,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 2))'));
SELECT 'geometrytype03', geometrytype(ST_geomfromewkt('MULTICURVEM((
5 5 3,
3 5 2,
3 3 1,
0 3 1)
,CIRCULARSTRING(
0 0 0,
0.26794919243112270647255365849413 1 -2,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 2))'));
SELECT 'ndims04', ST_ndims(ST_geomfromewkt('MULTICURVE((
5 5,
3 5,
3 3,
0 3)
,CIRCULARSTRING(
0 0,
0.26794919243112270647255365849413 1,
0.5857864376269049511983112757903 1.4142135623730950488016887242097))'));
SELECT 'geometrytype04', geometrytype(ST_geomfromewkt('MULTICURVE((
5 5,
3 5,
3 3,
0 3)
,CIRCULARSTRING(
0 0,
0.26794919243112270647255365849413 1,
0.5857864376269049511983112757903 1.4142135623730950488016887242097))'));
CREATE TABLE public.multicurve (id INTEGER, description VARCHAR,
the_geom_2d GEOMETRY(MULTICURVE),
the_geom_3dm GEOMETRY(MULTICURVEM),
the_geom_3dz GEOMETRY(MULTICURVEZ),
the_geom_4d GEOMETRY(MULTICURVEZM));
INSERT INTO public.multicurve (
id,
description
) VALUES (
1, 'multicurve');
UPDATE public.multicurve
SET the_geom_4d = ST_Geomfromewkt('MULTICURVE((
5 5 1 3,
3 5 2 2,
3 3 3 1,
0 3 1 1)
,CIRCULARSTRING(
0 0 0 0,
0.26794919243112270647255365849413 1 3 -2,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 1 2))');
UPDATE public.multicurve
SET the_geom_3dz = ST_Geomfromewkt('MULTICURVE((
5 5 1,
3 5 2,
3 3 3,
0 3 1)
,CIRCULARSTRING(
0 0 0,
0.26794919243112270647255365849413 1 3,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 1))');
UPDATE public.multicurve
SET the_geom_3dm = ST_Geomfromewkt('MULTICURVEM((
5 5 3,
3 5 2,
3 3 1,
0 3 1)
,CIRCULARSTRING(
0 0 0,
0.26794919243112270647255365849413 1 -2,
0.5857864376269049511983112757903 1.4142135623730950488016887242097 2))');
UPDATE public.multicurve
SET the_geom_2d = ST_Geomfromewkt('MULTICURVE((
5 5,
3 5,
3 3,
0 3)
,CIRCULARSTRING(
0 0,
0.26794919243112270647255365849413 1,
0.5857864376269049511983112757903 1.4142135623730950488016887242097))');
SELECT 'asbinary01', encode(ST_AsBinary(the_geom_2d, 'xdr'), 'hex') FROM public.multicurve;
SELECT 'asbinary02', encode(ST_AsBinary(the_geom_3dm, 'ndr'), 'hex') FROM public.multicurve;
SELECT 'asbinary03', encode(ST_AsBinary(the_geom_3dz, 'xdr'), 'hex') FROM public.multicurve;
SELECT 'asbinary04', encode(ST_AsBinary(the_geom_4d, 'ndr'), 'hex') FROM public.multicurve;
SELECT 'asewkb01', encode(ST_AsEWKB(the_geom_2d, 'ndr'), 'hex') FROM public.multicurve;
SELECT 'asewkb02', encode(ST_AsEWKB(the_geom_3dm, 'xdr'), 'hex') FROM public.multicurve;
SELECT 'asewkb03', encode(ST_AsEWKB(the_geom_3dz, 'ndr'), 'hex') FROM public.multicurve;
SELECT 'asewkb04', encode(ST_AsEWKB(the_geom_4d, 'xdr'), 'hex') FROM public.multicurve;
SELECT 'ST_CurveToLine-201', ST_AsText(ST_CurveToLine(the_geom_2d, 2), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine-202', ST_AsText(ST_CurveToLine(the_geom_3dm, 2), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine-203', ST_AsText(ST_CurveToLine(the_geom_3dz, 2), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine-204', ST_AsText(ST_CurveToLine(the_geom_4d, 2), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine-401', ST_AsText(ST_CurveToLine(the_geom_2d, 4), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine-402', ST_AsText(ST_CurveToLine(the_geom_3dm, 4), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine-403', ST_AsText(ST_CurveToLine(the_geom_3dz, 4), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine-404', ST_AsText(ST_CurveToLine(the_geom_4d, 4), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine01', ST_AsText(ST_CurveToLine(the_geom_2d), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine02', ST_AsText(ST_CurveToLine(the_geom_3dm), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine03', ST_AsText(ST_CurveToLine(the_geom_3dz), 8) FROM public.multicurve;
SELECT 'ST_CurveToLine04', ST_AsText(ST_CurveToLine(the_geom_4d), 8) FROM public.multicurve;
SELECT 'astext01', ST_AsText(the_geom_2d) FROM public.multicurve;
SELECT 'astext02', ST_AsText(the_geom_3dm) FROM public.multicurve;
SELECT 'astext03', ST_AsText(the_geom_3dz) FROM public.multicurve;
SELECT 'astext04', ST_AsText(the_geom_4d) FROM public.multicurve;
SELECT 'asewkt01', ST_AsEWKT(the_geom_2d) FROM public.multicurve;
SELECT 'asewkt02', ST_AsEWKT(the_geom_3dm) FROM public.multicurve;
SELECT 'asewkt03', ST_AsEWKT(the_geom_3dz) FROM public.multicurve;
SELECT 'asewkt04', ST_AsEWKT(the_geom_4d) FROM public.multicurve;
SELECT 'isValid01', ST_IsValid(the_geom_2d) FROM public.multicurve;
SELECT 'isValid02', ST_IsValid(the_geom_3dm) FROM public.multicurve;
SELECT 'isValid03', ST_IsValid(the_geom_3dz) FROM public.multicurve;
SELECT 'isValid04', ST_IsValid(the_geom_4d) FROM public.multicurve;
SELECT 'dimension01', ST_dimension(the_geom_2d) FROM public.multicurve;
SELECT 'dimension02', ST_dimension(the_geom_3dm) FROM public.multicurve;
SELECT 'dimension03', ST_dimension(the_geom_3dz) FROM public.multicurve;
SELECT 'dimension04', ST_dimension(the_geom_4d) FROM public.multicurve;
SELECT 'numGeometries01', ST_numGeometries(the_geom_2d) FROM public.multicurve;
SELECT 'numGeometries02', ST_numGeometries(the_geom_3dm) FROM public.multicurve;
SELECT 'numGeometries03', ST_numGeometries(the_geom_3dz) FROM public.multicurve;
SELECT 'numGeometries04', ST_numGeometries(the_geom_4d) FROM public.multicurve;
SELECT 'geometryN-201', ST_AsEWKT(ST_geometryN(the_geom_2d, 2)) FROM public.multicurve;
SELECT 'geometryN-202', ST_AsEWKT(ST_geometryN(the_geom_3dm, 2)) FROM public.multicurve;
SELECT 'geometryN-203', ST_AsEWKT(ST_geometryN(the_geom_3dz, 2)) FROM public.multicurve;
SELECT 'geometryN-204', ST_AsEWKT(ST_geometryN(the_geom_4d, 2)) FROM public.multicurve;
SELECT 'geometryN-301', (ST_AsEWKT(ST_geometryN(the_geom_2d, 3)) is null) FROM public.multicurve;
SELECT 'geometryN-302', (ST_AsEWKT(ST_geometryN(the_geom_3dm, 3)) is null) FROM public.multicurve;
SELECT 'geometryN-303', (ST_AsEWKT(ST_geometryN(the_geom_3dz, 3)) is null) FROM public.multicurve;
SELECT 'geometryN-304', (ST_AsEWKT(ST_geometryN(the_geom_4d, 3)) is null) FROM public.multicurve;
SELECT DropGeometryColumn('public', 'multicurve', 'the_geom_2d');
SELECT DropGeometryColumn('public', 'multicurve', 'the_geom_3dm');
SELECT DropGeometryColumn('public', 'multicurve', 'the_geom_3dz');
SELECT DropGeometryColumn('multicurve', 'the_geom_4d');
DROP TABLE public.multicurve;