[postgis-users] Linestring 3DM?

paallen at attglobal.net paallen at attglobal.net
Fri Mar 23 14:30:43 PDT 2007


Thanks for the tip Julio.  I also have discovered
that the srid has to come first.

The correct commands are:
CREATE TABLE line3d_test
(
  id integer NOT NULL,
  name character varying,
  CONSTRAINT line3d_test_id_pkey PRIMARY KEY (id)

) ;
SELECT AddGeometryColumn('public,', 'line3d_test',
'gline3dm', 32618, 'LINESTRING', 4);
INSERT INTO public.line3d_test (id, name,
gline3dm) VALUES ( 2, 'second-line',
GeomFromEWKT('SRID=32618;LINESTRING(200050 900050
2050 0, 200051 900051 1950 100, 200052 900052 1850
200)'));


thanks again.

Phil





More information about the postgis-users mailing list