<div>Hi Phillip,</div>
<div> </div>
<div>Note that you have defined a 2D LINESTRING on AddGeometryColumn statement and you must use 4D because you are inserting 4D data</div>
<div> </div>
<div>Regards,</div>
<div> </div>
<div>Julio<br><br> </div>
<div><span class="gmail_quote">On 3/23/07, <b class="gmail_sendername"><a href="mailto:paallen@attglobal.net">paallen@attglobal.net</a></b> <<a href="mailto:paallen@attglobal.net">paallen@attglobal.net</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi all,<br><br>I am very new with PostGIS and I am trying to<br>build a database to manage bore-holes for mineral
<br>exploration.<br><br>I want to store the curved 3d curved bore-hole<br>trace with the m (survey distances on the nodes)<br>values. Is this possible.<br><br>My following experiment has fail.<br>CREATE TABLE public.line3d_test
<br> id integer,<br> name varchar,<br> CONSTRAINT line3d_test_id_pkey PRIMARY KEY (id);<br>SELECT AddGeometryColumn('public', 'line3d_test',<br>'gline3dm', 32618, 'LINESTRING', 2);<br>INSERT INTO public.line3d_test
(id, name,<br>gline3dm) VALUES ( 1, 'first-line',<br>GeomFromEWKT('LINESTRING(200000 900000 2000 0,<br>200001 900001 1900 100)', 32618));<br><br>If I use "GeomFromText" I get this error:<br>WARNING: OGC WKT expected, EWKT provided - use
<br>GeomFromEWKT() for this<br>CONTEXT: SQL function "geomfromtext" statement 1<br><br>ERROR: new row for relation "line3d_test" violates<br>check constraint "enforce_dims_gline3dm"<br>SQL state: 23514
<br><br>Then if I use "GeomFromEWKT()" I get this error:<br>ERROR: function geomfromewkt("unknown", integer)<br>does not exist<br>SQL state: 42883<br>Hint: No function matches the given name and<br>argument types. You may need to add explicit type
<br>casts.<br>Character: 81<br><br>What I have I done wrong? Or is this even<br>possible? I know EWKT or EWKB is an extension of<br>OGC but I am working in 3D so I sort of need it.<br><br>thanks,<br><br>Phillip J. Allen
<br>Consulting Geochemist<br><br><br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br>