[Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Oliver Christen
oliver.christen at camptocamp.com
Tue Jul 3 01:53:09 EDT 2007
im sorry, I have no idea what need to be done.
so I would suggest you ask some php programmer to investigate more indepth the problem, or you can contract us to implement multiline support in the edit plugin
regards
Oliver
----- Original Message -----
From: Broun Uganda
To: Oliver Christen ; cartoweb-users at lists.maptools.org
Sent: Monday, July 02, 2007 6:08 PM
Subject: RE: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Hi Oliver,
I do have the edit plugin in my project, but i have modified it and nothing changes. I have also renamed the edit plugin in the plugins folder so it is not in use,It is apparent the changes need to be made else where.
Broun Uganda
----------------------------------------------------------------------------
From: oliver.christen at camptocamp.com
To: tekuganda at hotmail.com; cartoweb-users at lists.maptools.org
Subject: Re: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Date: Mon, 2 Jul 2007 16:23:27 +0200
maybe try 'edit_geometry_type' 'multilinestring'
----- Original Message -----
From: Broun Uganda
To: Oliver Christen ; cartoweb-users at lists.maptools.org
Sent: Monday, July 02, 2007 3:34 PM
Subject: RE: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Hey,
The layer with its metadata is as below but still giving me the same error:
LAYER # Links lines layer begins here
NAME "Links"
CONNECTIONTYPE POSTGIS
CONNECTION 'dbname=MU_maarten user=postgres password={Guma}no host=localhost'
DATA 'the_geom from (select the_geom, oid, gid, year, material, condition, diameter, from_node, to_node from links) as foo'
TYPE LINE
TEMPLATE "ttt"
CLASS
NAME "Links"
STYLE
COLOR 100 100 100
OUTLINECOLOR 5 5 5
END
END
METADATA
"id_attribute_string""gid"
"query_returned_attributes" "material year condition diameter"
'edit_table' 'links' # PostGIS table
'edit_geometry_column' 'the_geom' # PostGIS geometry column
'edit_geometry_type' 'line' # geometry type, may differ from layer type in mapfile
'edit_srid' '-1'
'edit_attributes' 'gid,id|string,material|string,year|string,condition|string,diameter|string,from_node|string,to_node|string' # list of the editable fields
END
And the constraint is
ALTER TABLE links
ADD CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL);
I changed the returntype to multilinestring.
if (strtoupper($geometryType) == 'LINE')
return 'MULTILINESTRING';
return strtoupper($geometryType);
Broun Uganda
------------------------------------------------------------------------
From: oliver.christen at camptocamp.com
To: tekuganda at hotmail.com; cartoweb-users at lists.maptools.org
Subject: Re: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Date: Mon, 2 Jul 2007 13:59:17 +0200
"delicate" as "there could be side effects".
the geometry definition is $feature->WKTString
that wkt seems to ge generated based on the 'edit_geometry_column' metadata for the related layer or, if it is not set, on the "edit_geometry_type" metadata for the related layer.
what metadata did you set for that problematic multistring layer ?
regards
Oliver
----- Original Message -----
From: Broun Uganda
To: Oliver Christen ; cartoweb-users at lists.maptools.org
Sent: Monday, July 02, 2007 1:46 PM
Subject: RE: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Hey
Could you explain what you mean by delicate,
I just changed the linestring to multilinestring
It still returns the same error.
Broun Uganda
--------------------------------------------------------------------
From: oliver.christen at camptocamp.com
To: tekuganda at hotmail.com; cartoweb-users at lists.maptools.org
Subject: Re: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Date: Mon, 2 Jul 2007 08:32:59 +0200
Hi
most likely because only LINESTRING was implemented in the plugin and not MULTILINESTRING
it should be possible to implemente that, though it may be delicate.
I think the code to modify is in the function getGeometryType (ServerEdit.php)
regards
Oliver
----- Original Message -----
From: Broun Uganda
To: cartoweb-users at lists.maptools.org
Sent: Monday, July 02, 2007 4:17 AM
Subject: [Cartoweb-users] Edit plugin MULTILINESTRING ERROR
Hi all,May some one advise me what the error is in this case. Every time i move a line in my edit i get this error below. why does it return a linestring instead of a multilinestring? The geometry constranint is that it should return a multiline string or null but why does it return a linestring?UPDATE public.links SET the_geom = GeometryFromText('LINESTRING(493630.4177779367 1995850.7688888889,493350.18066688 1995824.71352007)', -1) , id = '53', year = '1978', material = 'Ceramic', condition = 'Fair', diameter = '255', from_node = '18', to_node = '17' WHERE gid = 43 [nativecode=ERROR: new row for relation "links" violates check constraint "enforce_geotype_the_geom"]
Broun Uganda
------------------------------------------------------------------
Live Earth is coming. Learn more about the hottest summer event - only on MSN. Check it out!
------------------------------------------------------------------
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
----------------------------------------------------------------------
Hotmail to go? Get your Hotmail, news, sports and much more! Check out the New MSN Mobile
--------------------------------------------------------------------------
Change is good. See what's different about Windows Live Hotmail. Check it out!
------------------------------------------------------------------------------
Make every IM count. Download Windows Live Messenger and join the i'm Initiative now. It's free. Make it count!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070703/e1f7dbb4/attachment-0001.html
More information about the Cartoweb-users
mailing list