|  www.ecodb.com |  Contact Us  |  Register | License Holder Login |   Help |   Public Listing

Help Text - Ecodb concepts

Ecodb concepts

Welcome to ecodb, the global infomediary for environmental and ecosystem data.

The ecodb database provides an inexpensive means to obtain access to a sophisticated database system that has been designed specifically for the management of data concerning our environment. This represents a diverse range of users:

  • Industrial plant managers who need to comply with emissions permits (licenses), and monitor operating parameters;
  • Engineers who need to monitor dam levels, river flows, rainfall, drinking water salinity levels, and pump start stops;
  • Environmentalists who need to monitor a watershed or wetland area as part of a remediation program;
  • Environmental health agencies who monitor the health of recreational swimming areas for pathogen levels;
  • Agriculturalists who must ensure fertilizer is cost effectively applied, and that excess nutrient run-off is minimized.

All have the requirement of needing to store data that is comprised of measurements over time, transposing these data measurements into data sets with various measurement units, and transforming them into datasets representing different parameters based on calibration relationships. Ecodb provides a growing spectrum of data manipulation and reporting facilities.

Our cloud based service is referred to as an Application Service Provider (ASP) business model. Which means that this service is accessible via the Internet and the same functions are available to all license holders, however they have complete security over their own data.

One of the major benefits of this approach is that we can offer sophisticated functions that allow organizations to readily share their data if desired, both within their organization and with other entities.

The central concept is that data values are measurements over time, i.e. a data set, concerning a specific parameter usually identified by a data collection unit and possibly a location. These data sets are measurements of a specific parameter (e.g. rainfall, amount of gas discharged, dam levels, pump start/stops etc); and have a unit of measurement applied to them.

Once represented within the ecodb database, these data sets can be mathematically manipulated so that they are recalibrated into different units of measurement; or even transposed into measurement of a different parameter based on pre-defined 'calibration relationships'.

We are then able to provide an increasing range of sophisticated reporting functions, data search facilities, regulatory reporting, data sharing, and even a market for trading data sets that is available on a global basis.

License Administration

In addition to the two-week interim evaluation license (extended while we are in soft launch), we offer four ongoing categories of license which will support a diverse range of requirements:

  1. Corporate licenses are designed for organizations that have a requirement for significant environmental data storage and comprehensive evaluation and review functions. These requirements may range from having a legal requirement to store and report on environmental data (e.g., emissions compliance); a need to monitor the efficiencies of diverse manufacturing plant; Associations that support a wide scale and potentially geographically spread user base with well-defined data needs; through to government entities responsible for geographic areas that have the mandate to collect large amounts of data to accomplish their mission and who wish to support 'open government policies'. Ecodb is designed to replace the requirement for in-house data storage and most analytical systems.
  2. Retail licenses are optimal for the professional environmentalist; consultant; citizen scientist; farmer; hobbyist; or private contractor to support a project or client and where typically a single user access is required. These licenses are also useful for 'specific project' needs where the data is required to be more clearly segregated for management reasons, and where the project may have a limited term requirement before integration with a primary corporate or academic license.
  3. Academic licenses are designed for academic or research institutions that tend to use smaller volumes of data sourced from other organizations or collected themselves, but require more comprehensive analytical functions. Full access is provided to the sophisticated data manipulation, search and data acquisition facilities; as well as the ability to publicly list and freely share data. Particularly appropriate for supporting social media of e-projects.
  4. A particularly low cost Ecodb license that can be used as a single user, or can be expanded at minimal cost to include unlimited sub-accounts for team based collaborative projects.
  5. Re-seller's licenses or "VAR" for Value Added Reseller are for eco-entrepreneurs who can add value to either their own or another entities' data and re-sell this data through a market enabled by ecodb. Other license categories could acquire a VAR license, even on just an interim basis, as a mechanism to sell their data.

Ecodb also supports a 'Public Domain' for optionally publishing your data sets. This public domain is free to access by the public, and provides extensive search, data set review, and download facilities. Only ecodb licensees can publish to this Public Domain.

Emissions Permits

Emissions Permit (License) Establishment

  1. Many license holders will be utilizing ecodb to track their emissions permits (licenses). This screen provides the ability to establish basic permit information, and is a prelude to entering data measurements on an ongoing basis.
  2. There may be more than one permit for a facility, or there may be a facility wide permit (e.g. 'Title V' in USA).
  3. Regardless of whether permit information is to be entered, it is mandatory that the equipment or "data collection unit"(DCU) location is identified (either here or via the 'environmental projects screen'). All data set samples collected need to have their location of data collection identified.
  4. For all DCU, we need to identify what the "parameters" are that we are measuring, together with their "units of measurement". This function establishes the data set for all future sample data entry.
  5. Now that the data set(s) have been established, data entry of sample values can commence.
  6. Some license holders will go to this screen a number of times to enter additional permit information or to establish new data sets. As soon as a data set's samples have been entered, the data set can be recalibrated into different 'units of measurement' and/or a different 'parameter'.

Facility Permit

  1. This function will provide key date information concerning the permit. This will be subsequently utilized to generate reminders concerning permit renewals.
  2. Some organizations may wish to establish their permit information from various locations and generate a consolidated permit information system.
  3. Within each facility, there may be many items of equipment that are to be monitored. Each DCU must be uniquely identifiable, and the serial number or other comment must be utilized.

Environmental & Engineering Projects

Equipment Location

  1. DCU may be spread around the plant, or throughout a watershed. The screen enables the license holder to enter their location utilizing a description that may also include the GPS coordinates; the latter information will subsequently provide the ability to generate searches for data sets within geographic boundaries.

Code Maintenance

Code Maintenance

  1. There are two groups of codes that require maintenance within the system, 'parameters' and 'units of measurement'. The former are what the datasets are measuring, and the latter are the metrics that they are measured in.
  2. Ecodb has defined a range of commonly used parameters and units of measurement each grouped into common catalogs.

Identify Monitored Parameters

  1. For each data set we need to establish the parameters that are to be monitored, eg turbidity, Nitrous Oxide, fish species etc.
  2. The DCU is first selected (from the list of DCU that have already been established for this license holder).
  3. The user selects the parameter to be monitored. This is selected from various lists of parameter groups. The license holder will select which parameter category is most appropriate, e.g. from the category of 'Hazardous Air Pollutants (HAP) codes'.
  4. After the Parameter category is selected, the list of parameters from that parameter category is displayed for selection. User defined parameters can also be selected from.
  5. Similarly, the 'units of measurement' are selected from various categories of 'standard units of measurement'. Note that user defined units of measurement may also be selected from.

Parameter Maintenance

  1. This is one of the foundations of ecodb, the identification to the system of the parameters of a data collection unit that are to be monitored. When creating new data sets to be monitored for each DCU, the license holder selects from the list of available parameters to create a data set.
  2. Ecodb has created a range of parameter catalogs, however if you know of additional catalogs that would be generally useful to other licensees then please contact us and preferably e-mail that list to us.
  3. The 'parameter' option enables the listing of all parameters known to the system, and if permission granted, the addition, editing and deletion of parameters.

Catalog of Parameter Group List

  1. All catalogs of parameters known to ecodb or owned by the license holder are listed and which are accessible to the license holder. You cannot access other license holder catalogs of parameter.
  2. The screen provides a link to jump to the next logical function that lists individual parameters.

Catalog of Units of Measurement Menu

  1. All units of measurement that are available to you are grouped and listed for ease in locating. Ecodb provides standard units of measurement, however you may also add your own.
  2. If you have permission, you can add, edit and delete your own catalog.

Units of Measurement

  1. All units of measurement that are available to the license holder are listed within this catalog of unit of measurement groups.
  2. Within this screen you can also define your own units of measurement that will only be accessible to your license and sub-account holders.
  3. Please advise us of units of measurement that you feel would be of value to other users so that we may include them as system wide facilities.

Calibration relationships

Calibration Relationship Menu

  1. An essential feature of ecodb is the ability to be able to re-calibrate data sets. This menu provides information on standard calibration relationships available as well as enables the creation of user defined calibration relationships that are only available to the license holder.
  2. Calibration relationships are grouped by catalogs for ease of searching. The 'Catalog of Calibration Relationships' lists all catalogs available whether they are provided by ecodb or have been defined by you. You will not see any other license holder's catalogs.
  3. The 'Calibration Relationships' option will enable you to view individual calibration relationships grouped by calibration catalog. Here you will have the ability to view, and if permitted, edit and delete them. You will also be able to add new calibration relationships.
  4. Calibration range will provide the ability to view the precise formula used and the ranges of data over which this formula is valid, e.g. re-calibrating samples values in Centigrade into Fahrenheit where the sample value are valid from minus 273 degrees Centigrade upwards.

Catalog of Calibration Groups List

  1. This screen provides a listing of all defined catalogs of calibration relationships that are accessible by the license holder.
  2. The license holder will also be able to add their own calibration catalogs that will then be available to their license only (i.e. includes all of their sub-accounts).
  3. The screen then provides a link to then next logical step, which is to define the 'calibration relationships' for this catalog.

Calibration Relationships

  1. All calibration relationships that are available to the license holder are listed alphabetically by version.
  2. The details of each can be viewed, and if permitted, the sub-account can delete or edit this information.
  3. The next step of defining the mathematical relationship between two parameters for various ranges of parameter sample values is established.

Calibration Range Create

  1. For each calibration relationship (i.e. calibration id and version, the ranges over which conversions of data are valid must be established. Then for each range the formula to be used to convert the data is entered.
  2. Enter the 'range number'; you can check which existing range numbers are in use via the drop down box immediately following.
  3. Now enter the range value inequality. Check the negative and/or positive infinity boxes as required, e.g. "-273.15 <= X < infinity" would be the range that Centigrade values can be converted to Fahrenheit.
  4. The formula for this conversion would be Fahrenheit values would become equal to 32 plus 1.8 times the Centigrade value, i.e. Y = 32 +1.8 X.
  5. As this is one of the many standard calibration relationships already entered and available for you there is no need to create another one, but you may wish to experiment and create your own specialized calibration conversion relationships.
  6. Ranges of data values to convert cannot overlap. However you may want to use a different formula for a different range of data values, e.g. when calibrating the profile of a stream against a height of river against a pole, to generate the cross sectional area.

Management of data sets

Management of Data Sets

  1. This screen will be a common entry point for managing existing data sets.
  2. The first function provides a list of all existing data sets owned by the license holder, and allows for the data set modification or deletion of whole data sets.
  3. Data set establishment walks through the steps of creating a data set i.e. selecting the Data Collection Unit to be used, the parameter to be monitored by the DCU, selection of the units of measurement. A number of data sets can be established prior to commencing the data entry of ample data for each.
  4. Once a data set's sample values have been entered, the user can recalibrate the data set into either different units of measurement and/or different parameters to monitor e.g. conductivity recalibrated into salinity sample values.

Recalibrate a data set's units of measurement

  1. This function can change a data set's units of measurement e.g. from Centigrade to Fahrenheit.
  2. There are four steps involved:
  3. 1. First the selection of the data set to recalibrate;
    2. Next the selection of the calibration relationship to apply;
    3. Then the conversion of the data set to a 'derived data set' for review;
    4. Finally the confirmation and storing of this derived data set, which can potentially replace an existing data set that had previously been defined using the same keys.
  4. The new 'derived data set' can then be further re-calibrated, as well have new sample values added using the new units of measurement. For example, the original data set may have samples in Centigrade, it is then converted to a Fahrenheit data set by applying the calibration relationship for converting Centigrade values to Fahrenheit values. The user can then continue entering sample values to the 'derived data set' but now as Fahrenheit values. The original Centigrade data set will remain available.

Public Listing

All ecodb commercial licenses have the option of selectively publishing their valuable data sets to the Public Domain supported by ecodb. Licensees can simply access their data sets and check, or un-check, whether to publish or not. Their data set then becomes immediately available, or removed, from public access.

The Public Listing web page is primarily comprised of three panes of content, and the size of each pane can be adjusted by dragging the border of the pane. The 'reset page' button provides for a rapid reset to the originally sized panes.

    The left pane, titled 'directory/ map data selection' has two drop down menus for selecting data sets by:
  • Directory listing
  • Google maps

The directory listing provides various selection criteria for generating a data grid listing of available data sets, e.g. by country, or by 'recently added' etc. Whichever selection criteria is chosen, the data grid is then populated with the results of that selection and displayed in the pane on the right. Drag the pane border to fully display this listing. Selecting an individual dataset will have options for generating its output detail displayed in the bottom pane.

Selecting the pre-selected option of 'graphically display the dataset' will generate the line graph of this data set in Modula form, i.e. as a page above the web site. Other output options are provided such as download the selected dataset to a spreadsheet.

Select 'reset page' to rebalance the web page, and possibly drag the pane divider to expand the left pane. Now select the menu 'Google maps', and select a country. The country will now display in the right pane, using Google maps, and any data sets for that country will be represented by a red pin. You may have to zoom out to fit the country into the pane; as well as drag the pane boundary to expand the pane.

Scrolling over the red pin will provide a title of the environmental project (note that not all data sets will have an e-project established by their owner, and consequently not all data sets will be represented on a Google Map). Selecting the red pin for a data set will generate the e-project description, which can be cancelled by clicking the 'close' icon.

The bottom pane will again have the selected dataset's output options (you may need to expand the bottom pane to view all of these output options).