The CEDRA CorporationTM
Bridging Engineering with GISTM
_______________________________

 

CEDRA-DataEditorTM



CEDRA DataEditorTM is an ArcView® GIS and ArcGIS® extension, that is included with all of the CEDRA AVseriesTM software or licensed as a separate extension, which utilizes a customized dialog box enabling the user to edit and maintain data associated with features in a shapefile, personal geodatabase or an enterprise SDE geodatabase. The CEDRA DataEditor extension provides the user the ability to create a customized dialog box with user-specified labels and default values, with absolutely no programming, for any desired theme or themes. As a matter of fact, there is no limit to the number of themes that can be specified.

The user simply creates, with any word processor or text editor, an ASCII based file containing the pertinent information for those attributes in a theme (layer) that can be edited, from which, the CEDRA DataEditor extension builds a customized dialog box. This is an ideal tool for those involved with facility maintenance and/or data capture applications or those who simply wish to enhance ArcView's or ArcMap's native table editing functionality. With the CEDRA-DataEditor software there is no need to start and stop a table editing session. The user simply "points" at a feature, after which a customized dialog box will appear. The appropriate data can then be specified, at which point, the OK button can be selected to update the database.

Using the CEDRA-DataEditor software, the user is able to:

(a) select a value for an attribute from a pull-down list, rather than having to explicitly type the value,
(b) have built in verification that a numerical value for an attribute falls within a valid numerical range,
(c) have the value for an attribute computed based upon the evaluation of an equation which the user defines,
(d) obtain the current calender date in a user-defined format,
(e) generate a unique ID by adding one to the largest value in a field,
(f) have the coordinates of a point feature displayed as northings and eastings or latitudes and longitudes,
(g) have the area of a polygon displayed in square feet (square meters) or acres (hectares),
(h) for ArcGIS users, use the Map Tip tool to display a multi-line map tip, above and to the right of the cursor, and
(i) create single or multi-column, with or without sub-columns, dialog boxes.

This type of data maintenance functionality and more is provided by the CEDRA DataEditor extension and does not require Avenue or Visual Basic programming. Imagine being able to have customized dialog boxes without writing a line of code.

For ArcGIS users, included with the CEDRA-DataEditor software are the CEDRA-DataFrame-Tools and CEDRA-ArcView3-Tools toolbars. These toolbars enhance the interaction of the user with ArcMap by (a) facilitating the printing of maps and (b) the processing of layers and features within the map. Following the CEDRA-DataEditor software description, below, is a description of these toolbars and the functionality they provide.

Click on this link for a color brochure, which can be viewed and/or printed with Adobe Acrobat® ReaderTM. Click on this link for a description on the use and operation of the CEDRA-DataEditor software.



About CEDRA
CEDRA Graphics Engine | CEDRA LAND & CEDRA AVland | CEDRA Lite Modules
CEDRA SEA & CEDRA AVcad | CEDRA-AVcogo | CEDRA AVparcel
CEDRA SAND & CEDRA AVsand | CEDRA WATER & CEDRA AVwater
CEDRA Publications | CEDRA What's Happening | CEDRA Data Capture & Services
CEDRA Demo Packs

 Customized Single Column Dialog Box created using the CEDRA-DataEditor

 Customized Multi-Column Dialog Box created using the CEDRA-DataEditor
   

 ArcGIS Implementation of CEDRA-DataEditor available as an ActiveX DLL (ceddatae.dll)
 

CEDRA-DataEditorTM

CEDRA-DataEditorTM is fully compatible with Versions 3.0, 3.1, 3.2 and 3.3 of ArcView® GIS and Versions 8.2, 8.3, 9.0, 9.1, 9.2 and 9.3 of ArcGIS®.

CEDRA-DataEditorTM is an ArcView® GIS and ArcGIS extension that is an ideal tool for data maintanence and capture applications or for those who simply wish to enhance ArcView's native table editing functionality. The user is able to create a customized dialog box, for a shapefile, Personal geodatabase or enterprise SDE geodatabase, which contains the attributes that can be edited as well as the label describing the attribute. There is no limit to the number of shapefiles, Personal geodatabases or enterprise SDE geodatabases that can be processed or the number of attributes that can be edited. Character (string), numerical and date data types are supported. In addition, the user is also able to control the number of attributes that appear in a customized dialog box.

The CEDRA-DataEditorTM provides a tool that enables the user to select a feature, afterwhich, a dialog box similar to the one shown above is displayed. The user has the option of creating a single column or multi-column dialog box. The information displayed in the dialog box is based upon the data in the Theme Attribute Data file. This file contains a list of all of the themes and their attributes that the user can edit. The order in which the attributes are listed in the Theme Attribute Data file will dictate how they appear in the dialog box.

The Theme Attribute Data file is a sequential ASCII based file that contains a list of all of the themes and their attributes, which the user can edit with the Edit Feature Attributes tool. The CEDRA-DataEditor extension supports two types of database designs for a theme.

The first is one where all of the attributes are stored in the theme, while,

The second is one where some attributes are stored in the theme and some are stored in associated tables. Under this design, there are two attributes in the theme which link to the appropriate associated table. The first attribute contains a unique identifier (ID) that links a record in the theme with a record in the associated table, while the second, contains an attribute whose value points to the associated table. There is no limit to the number of associated tables that a theme can have.

Note that it is possible for the Theme Attribute Data file to contain a mixture of these database designs. That is, the Theme Attribute Data file does not have to contain themes of a single database design type, but rather, can contain both types, if need be. The user also has the ability to display a mixture of single and multi-column dialog boxes. That is, some layers can be displayed using a single column dialog box, while others can be displayed using a multi-column dialog box.

In addition, the user is able to: (a) explicitly specify the default value for specific attibutes, (b) have the default value computed as the feature's area, perimeter or length or (c) have the default value be the current date. The area can be in terms of square feet or square meters, or in terms of acres or hectares, while the current date can be formatted to user specifications.

The user also has the ability to specify a numerical range indicating the allowable values for an attribute, as well as the ability to specify an equation in which the result of the computation will be used as the attribute value. The syntax for specifying equations in the CEDRA-DataEditor is similar to that offered in the Microsoft Excel software. In essence the CEDRA-DataEditor is like a "mini" spreadsheet program.

A portion of a sample Theme Attribute Data file is shown below. Note that the /* characters denote a comment line, which the user can insert freely within the Theme Attribute Data file. Comment lines can be used to improve the readability of the file, as well as, explain the rationale in how attributes are edited.

/* Identify the Theme to be defined
THEME
WW_SEWERSpn.shp
/* Identify the attributes for editing
/* Attribute 1 : numeric data line item
WW_NODE_KEY
WW_NODE_KEY:
DEFAULT 0
/* Attribute 2 : string data line item
ENG_NUM
ENG_NUM (max 5 chars.):
REMEMBER_LAST
/* Attribute 3 : string combo box item
/* with seven possible choices
WW_NODE_TYPE
WW_NODE_TYPE (DROP, MH, LS, ...):
CHOICES
AVLV
BEND
CO
CROS
DROP
MH
LS
END
DEFAULT MH
REMEMBER_LAST
/* Attribute 4 : numeric data line item
WIDTH 2
WIDTH - in (mm):
DEFAULT 0.0
/* Attribute 5 : value computed from equation
SLOPE
Pipe Slope (%):
ATTRIBUTE_EQUATION
((EZ-SZ)/LEN)*100.0
/* End of Theme definition
END
/* Continue with other themes

For ArcGIS users, the CEDRA-DataEditor Map Tip tool enables the user to display multi-line map tips for those layers which appear in the Theme Attribute Data File. By simply moving the cursor over a desired feature, the Map Tip tool will display in the form of a map tip, the values for the attributes that are defined in the Theme Attribute Data File. In so doing, the user is able to quickly display attribute values without having to pick or select a feature. In addition to the attribute value, the map tip will contain the user-defined label, as it appears in the Theme Attribute Data File, to facilitate the identification of the attribute value. For example, rather than seeing the number 8, the map tip would contain the string Pipe Size: 8.

Printing Capability for ArcGIS

ArcGIS® users have the ability to print the active data frame using the Print Data Frame command, which is available in the CEDRA-DataFrame-Tools toolbar. The Print Data Frame command differs from conventional ArcGIS printing in that the user is able to control: (a) the map scale, (b) the map area to be printed, (c) the location of the map on the paper and (d) optionally, whether a data frame, which contains a map sheet border, should be included or not in the map.

As most ArcMap users have realized, within an ArcMap document file (.mxd) all data frames share the same layout. This causes the difficulty of when the layout view is activated all of the data frames in the document file appear in the layout, which for some applications is not what the user wants. The Print Data Frame command will print the active data frame, from data or layout view, ensuring that: (a) the desired map scale is preserved, and (b) all other data frames do not appear on the plot. This is achieved by programmatically positioning all data frames, other than the active data frame, in the document file outside of the user specified sheet limits (Paper Size parameters). In so doing, when the layout view is activated the only data frame that appears in the layout view is the active data frame.

This capability allows the user to have a single document file that contains many data frames with each data frame containing a complete drawing sheet. Without the Print Data Frame command the user would have to: (a) create separate document files for each drawing sheet or (b) manually reposition all data frames, other than the active data frame, outside of the sheet limits.

 Data Frame Printing Dialog Box

 Positioning of the Active Data Frame on a Map Sheet Border
   

In addition, users have the ability to operate in another mode of map preparation. The first mode, which was described above, is when a single data frame contains the entire map to be printed. The second mode is where one data frame contains the map contents, while another data frame contains the map border (title block, sheet border, etc.).

The Print Data Frame command accommodates this scenario by providing the Include Data Frame matching the Paper Size option. When this option is checked the Print Data Frame command will position the active data frame according to the specifications in the Data Frame Size and Position parameters area and will include in the plot the data frame whose name is either 11"x17", 24"x36" or Custom, depending upon which Paper Size is active. This approach enables the user to create a single map border, placing it in a data frame using one of the following; 11"x17", 24"x36" or Custom as the name of the data frame, and generate multiple maps without having to load the map border into multiple data frames.

ArcView 3.x Tools for ArcGIS

ArcGIS users who have worked with ArcView GIS will notice that the commands shown below: (a) do not operate the same in ArcMap as they did in ArcView or (b) are just not a part of core ArcGIS. These commands did not provide GIS functionality but they were an essential part of how ArcView GIS users operated in the ArcView 3.x environment. To ease the transition to ArcGIS, CEDRA's ArcGIS based software includes the CEDRA-ArcView3 Tools toolbar. This toolbar enables ArcGIS users to interact with ArcMap in a manner similar to how ArcView GIS users operated in the ArcView 3.x environment. For users who have never worked with ArcView GIS, these tools provide an easier and more flexible means of interacting with the map.

 CEDRA-ArcView3 Tools toolbar
 

Functionality offered in the CEDRA-ArcView3 Tools toolbar

To download a color brochure, which can be viewed and/or printed with Adobe Acrobat® ReaderTM, click on the following link CEDRA Software Information.

CEDRA-DataEditor is licensed as per the terms of the CEDRA Software License Agreement.


For more information on CEDRATM software and services contact The CEDRA Corporation at 151 Sully's Trail - Suite 6, Pittsford, New York 14534, phone: 585-232-6998, fax: 585-262-2042 or Send E-mail to CEDRA: cedra@cedra.com

Go Back to the CEDRA Homepage

CEDRA, CEDRA 2010, AVseries, CEDRA Lite, CEDRA-SEA, CEDRA-LAND, CEDRA-SAND, CEDRA-WATER, CEDRA-AVseries, CEDRA-AVcad, CEDRA-AVcogo, CEDRA-AVparcel, CEDRA-AVland, CEDRA-AVsand, CEDRA-AVwater, CEDRA-DataEditor, CEDRA-DxfExport, CEDRA-AGSTools, The CEDRA System, The CEDRA AVseries and The CEDRA Corporation logos are all trademarks of The CEDRA Corporation, Rochester, New York. ArcView GIS, ArcGIS, ArcMap, 3D Analyst and Arc/Info are registered trademarks of Environmental Systems Research Institute, Inc. Redlands, California. Acrobat is a registered trademark and Acrobat Reader is a trademark of Adobe Systems Incorporated, San Jose, California.

© Copyright 1985 - 2010