Page Comparison

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Features:

• Simple to setup for basic operation
  Configure the id, label and entity and Weave will do the rest.
• Customisable for advanced operation
  Refine geometry setting and input parameters, and provide pre-defined lists of values for input.
• Supports editing on an entity with multiple spatial layers
  A single entity that is composed of separate point, line and/or polygon tables is transparently handled by Weave.
• Creation and updating on an entity in the client can be initiated from URL parameters
  The Weave client can be started with parameters in the URL to immediately begin the editing process for a specific entity for the user.
• Auditing of editing operations
  Custom auditing can be setup to write a new log records to a database table for each edit operation performed by a user.
• Snapping of geometry
  Configurable snapping is available to help with drawing geometry.
• I18n support
  All of the text/labels for the editing components can be customized for multiple languages or even just having the default text changed.
• "Identity" columns
  It's possible to specify that an attribute for a new record is based on incrementing the previous highest value of the column, or that the column will be automatically generated by the underlying database system.
• Read-only columns
  It's possible to specify that an attribute can be displayed but not changed (readonly), can only be changed when the entity is created (readonlyonupdate) or can only be changed when an entity is updated (readonlyoncreate).
• Hidden columns
  It's possible to specify attributes that aren't visible to the user but are still written when an edit is performed, using either a fixed value or one of a number of supported functions.
• Formula columns
  It's possible to specify a number of in-built formulas as the value for a column, including things like userid(), datetime(), entity(), area() and length(). These can be used for both the spatial and audit tables.
• Restrictions on the number and types of geometry
  Geometry input can be constrained to indicate a minimum and maximum number of geometries that can be entered when creating an entity and the types of geometries can be specified.
• Customization of client view
  The display of the input panel can be customized via the configuration. Some things that can be customized are if text and/or icons are display in buttons, which buttons are displayed (hiding the polygon button for example) and the locations of some of the buttons.

Limitations:

...

The spatial editing extension for Weave provides a means to edit geometry and attributes for an entity.

Features:

• Simple to setup for basic operation
  Configure the id, label and entity and Weave will do the rest.
• Customisable for advanced operation
  Refine geometry setting and input parameters, and provide pre-defined lists of values for input.
• Supports editing on an entity with multiple spatial layers
  A single entity that is composed of separate point, line and/or polygon tables is transparently handled by Weave.
• Creation and updating on an entity in the client can be initiated from URL parameters
  The Weave client can be started with parameters in the URL to immediately begin the editing process for a specific entity for the user.
• Auditing of editing operations
  Custom auditing can be setup to write a new log records to a database table for each edit operation performed by a user.
• Snapping of geometry
  Configurable snapping is available to help with drawing geometry.
• I18n support
  All of the text/labels for the editing components can be customized for multiple languages or even just having the default text changed.
• "Identity" columns
  It's possible to specify that an attribute for a new record is based on incrementing the previous highest value of the column, or that the column will be automatically generated by the underlying database system.
• Read-only columns
  It's possible to specify that an attribute can be displayed but not changed (readonly), can only be changed when the entity is created (readonlyonupdate) or can only be changed when an entity is updated (readonlyoncreate).
• Hidden columns
  It's possible to specify attributes that aren't visible to the user but are still written when an edit is performed, using either a fixed value or one of a number of supported functions.
• Formula columns
  It's possible to specify a number of in-built formulas as the value for a column, including things like userid(), datetime(), entity(), area() and length(). These can be used for both the spatial and audit tables.
• Restrictions on the number and types of geometry
  Geometry input can be constrained to indicate a minimum and maximum number of geometries that can be entered when creating an entity and the types of geometries can be specified.
• Customization of client view
  The display of the input panel can be customized via the configuration. Some things that can be customized are if text and/or icons are display in buttons, which buttons are displayed (hiding the polygon button for example) and the locations of some of the buttons.

Limitations:

• Only attributes directly attached to the spatial table can be edited
  Weave will only write to the spatial table when editing an entity, currently having some attributes written to the spatial table and other attributes written to separate database tables is not supported. Audit tables may provide enough functionality to support the required workflow though.
• Spatial mapper for entity must have <dynamic> set to true and <cache> set to false
  But this is generally the case for any entity that can have its underlying data altered on the fly.
• A database table will require a primary key
  If you're editing data in a database and are unable to edit the table, ensure that it has a primary key.
• Does not support ESRI GeoDatabase enabled databases
  Once you've edited a table with Weave the objectid generation might get out of sync with ArcGIS and stop you from being able to edit the table within ArcGIS. Non-geodatabase enabled databases are fine. Update: 2.5.27.14, 2.5.28.10 and 2.5.29.4 now support GeoDatabases editing on SQL Server (other databases to be supported in the future)other databases to be supported in the future). Note: Versioned, Archived and Edit Tracking require special attention to setup in Weave, ensure you're familiar with these before attempting to editing them in Weave, and Branch Versioning is not supported at all.

Installation

Currently, the Weave editing sub-system is provided as a single bundle, com.cohga.spatial.edit. This bundle must be copied to the weave\platform\plugins directory and the server restarted for it to be available.

...

<?xml version="1.0" encoding="UTF-8"?>

<config xmlns="urn:com.cohga.server.config#1.0" xmlns:client="urn:com.cohga.html.client#1.0">

  <client:config id="edit">
    <!-- more config items here -->

    <!-- Add the Edit panel to the client -->
    <view id="com.cohga.client.panel.edit">
      <label>Edit</label>
      <location>west</location>
    </view>

    <view id="com.cohga.html.client.map.mapView">
      <label>Map</label>
      <location>center</location>

      <!-- Register the edit plugin with the map view -->
      <plugin id="weave.edit"/>

      <!-- more config items here -->
    </view>

    <!-- more config items here -->
  </client:config>

</config>

This view also provides the actions required to initiate editing and the tools required to perform the spatial edit operations.

Image Removed

Client panel buttons

...

name

...

description

...

Create

...

Insert a new entity.
Will be disabled if editing is in progress.

...

Update

...

Change the currently selected entity.
Will be disabled if no entity is selected or if there is more than one entity selected or editing is in progress.

...

Delete

...

Remove the currently selected entity.
Will be disabled if no entity is selected or if there is more than one entity selected or editing is in progress.

...

Reset

...

Reset the form fields back to their original values.
Will be disabled if editing is not in progress.

...

Submit

...

Complete the edit process and save the current changes.
Will be disabled when editing isn't in process or if the current state isn't value, for example if a polygon geometry is required but hasn't been added yet.

...

Cancel

...

Abort the edit process and abandon the current changes.
Will be disabled when editing isn't in process.

...

Modify

...

</config>

This view also provides the actions required to initiate editing and the tools required to perform the spatial edit operations.

Image Added

Client panel buttons

Customising the client edit view

There are a number of customisation options available to alter the display of the edit view

Customising the client edit view

There are a number of customisation options available to alter the display of the edit view

...

Button display based on showIcon and showText values

Edit View with showText set to false and showIcon set to true

Server Edit Configuration

...

<?xml version="1.0" encoding="UTF-8"?>

<config xmlns="urn:com.cohga.server.config#1.0" xmlns:edit="urn:com.cohga.spatial.edit#1.0">

  <edit:config id="custom.edit">
    <entity>graffiti</entity>
    <label>Grafitti</label>
    <description>Report graffiti for removal</description>
    <geometry>
      <point minimum="1" maximum="1"/>
    </geometry>
    <parameter id="description">
      <label>Description</label>
      <controlType>text-area<<controlType>textarea</controlType>
      <column>DESCRIPTION</column>
    </parameter>
  </edit:config>

</config>

...

A few things to not note about the properties that can be applied to parameters:

...

  <edit:config id="custom.edit">
    <entity>graffiti</entity>
    <label>Grafitti</label>
    <description>Report graffiti for removal</description>
    <geometry>
      <point minimum="1" maximum="1"/>
    </geometry>
    <parameter id="description">
      <label>Description</label>
      <controlType>text-area<<controlType>textarea</controlType>
      <column>DESCRIPTION</column>
    </parameter>
    <!-- Hidden parameters to record audit information -->
    <parameter id="createdby">
      <hidden>true</hidden>
      <column>CREATEDBY</column>
      <value>userid()</value>
      <updatable>false</updatable>
    </parameter>
    <parameter id="createdon">
      <hidden>true</hidden>
      <column>CREATEDON</column>
      <value>datetime()</value>
      <updatable>false</updatable>
    </parameter>
    <parameter id="modifiedby">
      <hidden>true</hidden>
      <column>MODIFIEDBY</column>
      <value>userid()</value>
    </parameter>
    <parameter id="modifiedon">
      <hidden>true</hidden>
      <column>MODIFIEDON</column>
      <value>datetime()</value>
    </parameter>
  </edit:config>

...

  <edit:config id="custom.edit">
    <entity>graffiti</entity>
    <label>Grafitti</label>
    <description>Report graffiti for removal</description>
    <geometry>
      <point minimum="1" maximum="1"/>
    </geometry>
    <parameter id="id">
      <hidden>true</hidden>
      <column>ID</column>
      <value>nextval()</value>
    </parameter>
    <parameter id="description">
      <label>Description</label>
      <controlType>text-area<<controlType>textarea</controlType>
      <column>DESCRIPTION</column>
    </parameter>
  </edit:config>

...

  <edit:config id="custom.edit">
    <entity>graffiti</entity>
    <label>Grafitti</label>
    <description>Report graffiti for removal</description>
    <geometry>
      <point minimum="1" maximum="1"/>
    </geometry>
    <parameter id="id">
      <hidden>true</hidden>
      <column>ID</column>
      <value>nextval()</value>
    </parameter>
    <parameter id="description">
      <label>Description</label>
      <controlType>text-area<<controlType>textarea</controlType>
      <column>DESCRIPTION</column>
    </parameter>
    <parameter id="status">
      <label>Status</label>
      <controlType>list-box<<controlType>listbox</controlType>
      <column>STATUS</column>
      <defaultValue>N</defaultValue>
      <list value="N" label="New"/>
      <list value="V" label="Verified"/>
      <list value="S" label="Scheduled"/>
      <list value="R" label="Removed"/>
    </parameter>
    <parameter id="reporter">
      <label>Reporter</label>
      <controlType>list-box</controlType>
      <dataSet>staff</dataSet>
      <allowNewValues>true</allowNewValues>
      <column>REPORTEDBY</column>
    </parameter>
  </edit:config>

...

  <edit:config id="custom.edit">
    <entity>graffiti</entity>
    <label>Grafitti</label>
    <description>Report graffiti for removal</description>
    <geometry>
      <point minimum="1" maximum="1"/>
    </geometry>
    <parameter id="id" hidden="true" label="Id" column="ID" value="auto()"/>
    <parameter id="description" label="Description" controlType="text-areatextarea"/>
  </edit:config>

  <edit:audit id="custom.audit">
    <mode>create,update,delete</mode> <!-- specify when audit records are written. create,update,delete is the default so this isn't really needed here -->
    <edit>custom.edit</edit>
    <datasource>datasource.main</datasource>
    <table>EDIT_AUDIT</table>
    <parameter column="ID" value="id()"/>
    <parameter column="DESC" parameter="description"/>
    <parameter column="GEOM" value="geometry()"/> <!-- at the moment this is text, not actual Geometry, in WKT format -->
    <parameter column="USER" value="userid()"/>
    <parameter column="MODIFIED" value="datetime()"/>
  </edit:audit>

...

 <edit:config id="edit.view">
    <entity>graffiti</entity> <!-- this entity is backed by a DB view that can't be edited directly -->
    <spatialEngine>oracle</spatialEngine> <!-- set the spatial engine that contains the table that should be edited instead, could be the same as the spatial mapper, but might not be -->
    <table>GRAFITTI</table> <!-- set the name of the table in the spatial engine that should be edited instead, this should be different than the spatial mapper, since that's the whole point of this -->
    <key>OID</key> <!-- set the column that uniquely identifies the rows in the table that should be used instead, generally this would be the same as the spatial mapper -->
    <label>Grafitti</label>
    <description>Report graffiti for removal</description>
    <geometry>
      <point minimum="1" maximum="1"/>
    </geometry>
    <parameter id="id" hidden="true" label="Id" column="ID" value="auto()"/>
    <parameter id="description" label="Description" controlType="text-areatextarea"/>
  </edit:config>