[Cartoweb-users] Edit plugin MULTILINESTRING ERROR

[Oliver Christen]

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! 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070702/b3b14468/attachment.html