Document Actions
Links Between GISDB and IEDB
Up one level
3. LINKS BETWEEN GISDB AND IEDB
The geoinformation database provides the capability of exporting coordinated information to the International Environmental Database (IEDB).
3.1. International information exchange is represented by the following files:
- Tabular information (DBF format):
- Table of categories of water quality indicators CATS.DBF;
- Water quality indicators table ELEMS.DBF;
- Monitoring stations description table STATIONS.DBF;
- Water quality data table VALUES.DBF;
- Waste water discharge table ESCAPES.DBF;
- Table of qualitative discharge indicators data POLLUTIONS.DBF;
- Water flow data table EXPENSES.DBF;
- Table of categories of waste water discharge indicators ESCCATS.DBF;
- Water objects description table OBJECTS.DBF;
- Political units description table REGIONS.DBF.
- Geocoverage (SHAPE format):
- State and administrative borders, boundaries of conservation areas – ADMLIN;
- Territories of political units – ADMPOL;
- Drainage network objects not expressed in area (rivers, brooks, canals, drains) – DNL;
- Boundaries of areal objects (lakes, storage reservoirs, rivers, islands) – DNAR_LN;
- Drainage network objects expressed in area (lakes, storage reservoirs, rivers, islands) – DNAR;
- Centers of population and individual buildings not expressed in the map’s scale (towns, settlements, individual households (farmsteads), individual buildings) – PPT;
- Hot points – HOT_POINT;
- Protected natural territories of federal status – OOPT;
- Contains Russia’s Dnipro basin – BAS;
- The Dnipro’s sub-basins, including first-order tributaries within Russia’s Dnipro basin – BAS_5;
- The Dnipro’s sub-basins, including first-order tributaries within Russia’s Dnipro basin, by oblasts – BAS_5_TER;
- The Dnipro’s sub-basins, including first- and second-order tributaries within Russia’s Dnipro basin – BAS_13;
- The Dnipro’s sub-basins, including first- and second-order tributaries within Russia’s Dnipro basin, by oblasts – BAS_13_TER.
- Graphics files (JPEG, BMP, TIFF formats).
3.2. Detailed structure and description of data exchange files are presented below.
3.2.1. Structure of “dbf” data exchange files
3.2.1.1. Links between exchange tables
3.2.1.2. General directories.
OBJECTS.DBF
Water objects
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of water object |
|
PARENT_ID |
NUMBER(20) |
Water object’s codifier determining the nesting of water objects (see OBJECTS.DBF) |
|
SHAPE_ID |
NUMBER(20) |
Object’s index in the SHAPE file (see DNL.SHP, field HDRLIN_ID) |
REGIONS.DBF
Political units – oblasts and rayons
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of oblast (rayon) |
|
PARENT_ID |
NUMBER(20) |
Territory codifier determining the rayon’s nesting in the oblast (see REGIONS.DBF) |
|
SHAPE_ID |
NUMBER(20) |
Object’s index in the SHAPE file (see ADMPOL.SHP, field ADMPOL_ID) |
3.2.1.3. Surface water quality.
CATS.DBF
Categories of water quality indicators (directory)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
CNAME |
CHARACTER(100) |
Name of indicator category |
ELEMS.DBF
Water quality indicators (directory)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of indicator category (Russian) |
|
NAME_E |
CHARACTER(100) |
Name of indicator (English) |
|
CAT_ID |
NUMBER(20) |
Codifier of indicator category (see CATS.DBF) |
|
UNITS |
CHARACTER(10) |
Unit measure of indicator (Russian) |
|
UNITS_E |
CHARACTER(10) |
Unit measure of indicator (English) |
|
PDK_R |
NUMBER(20,5) |
MPC for fish-breeding |
|
PDK_R_MAX |
NUMBER(20,5) |
MPC for fish-breeding (max) |
|
PDK_R_DESC |
CHARACTER(100) |
MPC for fish-breeding (description) |
|
PDK_P |
NUMBER(20,5) |
MPC for drinking water |
|
PDK_P_MAX |
NUMBER(20,5) |
MPC for drinking water (max) |
|
PDK_P_DESC |
CHARACTER(100) |
MPC for drinking water (description) |
|
ACCESS |
NUMBER(20) |
Access level |
STATIONS.DBF
Monitoring stations (directory)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
BASIN_ID |
NUMBER(20) |
Sub-basin’s index in the SHAPE file (see BAS_13.SHP, field ID) |
|
REGION_ID |
NUMBER(20) |
Station’s territory codifier (see REGIONS.DBF) |
|
OBJECT_ID |
NUMBER(20) |
Station’s river or water object codifier (see OBJECTS.DBF) |
|
STATION |
CHARACTER(100) |
Name of station (Russian) |
|
STATION_E |
CHARACTER(100) |
Name of station (English) |
|
RIVERX |
NUMBER(20,5) |
Distance from mouth (river coordinate), km |
|
LON |
NUMBER(20,5) |
Longitude, degrees |
|
LAT |
NUMBER(20,5) |
Latitude, degrees |
|
YEAR0 |
NUMBER(20) |
Beginning of observations at the station (year) |
|
YEAR1 |
NUMBER(20) |
Closing of the station (year) |
|
NSTV |
NUMBER(20) |
Number of sites |
|
DESCRIPT |
CHARACTER(254) |
Brief description of the sites’ location |
|
SHAPE_ID |
NUMBER(20) |
Object’s index in the SHAPE file (see PPT.SHP, field ID) |
|
Yellow indicates blank fields of transferred table. |
||
VALUES.DBF
Surface water quality data
|
Field name |
Field type |
Description |
|
F_YEAR |
NUMBER(20) |
Year |
|
F_MONTH |
NUMBER(20) |
Month |
|
STAT_ID |
NUMBER(20) |
Station codifier, see table STATIONS.DBF |
|
ELEM_ID |
NUMBER(20) |
Indicator codifier, see table ELEMS.DBF |
|
F_VALUE |
NUMBER(20,5) |
Value of indicator |
|
Yellow indicates blank fields of transferred table. |
||
3.2.1.4. Surface water resources.
POINTS.DBF
Observation stations (directory)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
BASIN_ID |
NUMBER(20) |
Sub-basin’s index in the SHAPE file (see BAS_13.SHP, field ID) |
|
OBJECT_ID |
NUMBER(20) |
Station’s river or water object codifier (see OBJECTS.DBF) |
|
POINT |
CHARACTER(100) |
Name of station (Russian) |
|
POINT _E |
CHARACTER(100) |
Name of station (English) |
|
RUSTJ |
NUMBER(20,5) |
Distance from mouth (river coordinate), km |
|
PLWODOS |
NUMBER(20,5) |
Drainage area, km2 |
|
OTM |
NUMBER(20,5) |
Station’s altitude above sea level, m |
|
PDO1 |
NUMBER(20) |
Beginning of observations at the station (year) |
|
PDO2 |
NUMBER(20) |
Reopening of the station (year) |
|
PDZ |
NUMBER(20) |
Closing of the station (year) |
|
LON |
NUMBER(20,5) |
Longitude, degrees |
|
LAT |
NUMBER(20,5) |
Latitude, degrees |
|
SHAPE_ID |
NUMBER(20) |
Object’s index in the SHAPE file (see PPT.SHP, field ID) |
|
Yellow indicates blank fields of transferred table. |
||
HYDRO.DBF
Water flow data
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Station codifier, see table POINTS.DBF |
|
YEAR |
NUMBER(20) |
Year |
|
MONTH |
NUMBER(20) |
Month |
|
CHARG |
NUMBER(20,5) |
Value of indicator, km3/sec. |
|
LEV |
NUMBER(20,5) |
Average monthly levels, сm |
|
Yellow indicates blank fields of transferred table. |
||
3.2.1.5. Water use.
WASTECATS.DBF
Categories of waste water discharge indicators (directory)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of discharge indicator category |
WASTEWATERS.DBF
Waste water discharge data
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
YEAR |
NUMBER(20) |
Year |
|
CAT_ID |
NUMBER(20) |
Codifier of discharge indicator category (see WASTECATS.DBF) |
|
OBJECT_ID |
NUMBER(20) |
Water object codifier (see OBJECTS.DBF) |
|
REGION_ID |
NUMBER(20) |
Territory codifier (see REGIONS.DBF) |
|
VALUE |
NUMBER(20,5) |
Value of indicator, millions of m3 |
POLLUTIONS.DBF
Qualitative discharge indicators data
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
YEAR |
NUMBER(20) |
Year |
|
ELEM_ID |
NUMBER(20) |
Codifier of discharge indicator category (see ELEMS.DBF) |
|
OBJECT_ID |
NUMBER(20) |
Water object codifier (see OBJECTS.DBF) |
|
REGION_ID |
NUMBER(20) |
Territory codifier (see REGIONS.DBF) |
|
VALUE |
NUMBER(20,5) |
Value of indicator, thousands of tons |
3.1.2.6. Protected natural territories.
OOPTCATS.DBF
PNT category as determined in the law (directory)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of PNT category |
OOPTMSOP.DBF
PNT category as determined in ОТ МСОП (directory)
(a PNT may have more than one ОТ МСОП category, see)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of PNT category as determined in ОТ МСОП |
OOPTPROF.DBF
PNT profile (directory)
(a PNT may have more than one profile, see)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of PNT profile |
OOPTCONV.DBF
International conventions (directory)
(a PNT may participate in more than one convention, see)
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(254) |
Name of convention |
|
SHORT |
CHARACTER(10) |
Accepted abbreviation |
OOPT.DBF
Data on protected natural territories
|
Field name |
Field type |
Description |
|
ID |
NUMBER(20) |
Unique codifier |
|
NAME |
CHARACTER(100) |
Name of PNT |
|
LOCATION |
CHARACTER(100) |
Situation affixment |
|
YEAR1 |
NUMBER(20) |
Year of creation |
|
YEAR2 |
NUMBER(20) |
Year of closing (for future) |
|
SQUARE |
NUMBER(20,5) |
Area, hectares |
|
STATUS |
CHARACTER(1) |
PNT status (Ф – federal, Р – regional, М – local) |
|
CAT_ID |
NUMBER(20) |
PNT category codifier (see OOPTCATS.DBF) |
|
NOTE |
CHARACTER(254) |
Brief PNT description ООПТ |
|
SHAPE_ID |
NUMBER(20) |
PNT index in the SHAPE file (see OOPT.SHP, field N) |
REL_OOPTREG.DBF
PNT affixment to territory
|
Field name |
Field type |
Description |
|
OOPT_ID |
NUMBER(20) |
PNT codifier (see OOPT.DBF) |
|
REGION_ID |
NUMBER(20) |
Territory codifier (see REGIONS.DBF) |
REL_OOPTMSOP.DBF
PNT affixment to ОТ МСОП categories
|
Field name |
Field type |
Description |
|
OOPT_ID |
NUMBER(20) |
PNT codifier (see OOPT.DBF) |
|
MSOP_ID |
NUMBER(20) |
ОТ МСОП category codifier (see OOPTMSOP.DBF) |
REL_OOPTPROF.DBF
PNT affixment to profiles
|
Field name |
Field type |
Description |
|
OOPT_ID |
NUMBER(20) |
PNT codifier (see OOPT.DBF) |
|
PROF_ID |
NUMBER(20) |
Profile codifier (see OOPTPROF.DBF) |
REL_OOPTCONV.DBF
PNT affixment to international conventions
|
Field name |
Field type |
Description |
|
OOPT_ID |
NUMBER(20) |
PNT codifier (см. OOPT.DBF) |
|
CONV_ID |
NUMBER(20) |
International convention codifier (see OOPTCONV.DBF) |
3.2.2. Structure of SHAPE files
3.2.2.1. The Russian Dnipro basin’s political division and borders
|
coverage ADMLIN |
object class – line |
||
|
contains state and administrative borders, boundaries of conservation areas |
|||
|
table ADMLIN.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
type |
C-70 |
Object class type |
|
coverage ADMPOL |
object class – polygon |
||
|
contains territories of political units |
|||
|
table ADMPOL. DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
name_cntr |
C-30 |
Own name of state |
|
2 |
name_adm1 |
C-30 |
Own name of oblast |
|
3 |
name_adm2 |
C-30 |
Own name of rayon (т.п.г. – territories subordinate to a town т.о.г. – territories of towns subordinate to the oblast) |
3.2.2.2. Hydrography
|
coverage DNL |
object class – line |
||
|
contains drainage network objects not expressed in area: rivers, brooks, canals, drains |
|||
|
table DNL.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
name |
C-30 |
Own name |
|
2 |
type |
C-50 |
Object class type |
|
coverage DNAR_LN |
object class – line |
|
contains boundaries of areal objects: lakes rivers islands |
|
|
coverage DNAR |
object class – polygon |
||
|
contains drainage
network objects expressed in area: |
|||
|
table HDRPOL.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
name |
C-30 |
Own name |
|
2 |
type |
C-16 |
Object class type |
3.2.2.3. Centers of population
|
coverage PPT |
object class – point |
||
|
contains centers
of population and individual buildings not expressed in the map’s scale: hydrological and hydrochemical observation sites (id: 101-107) affixment points of PNTs (id: 11-21) of federal status |
|||
|
table PPP.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
id |
I-16,0 |
Identifier of hydrological and hydrochemical observation sites (id: 101-107) and affixment points of PNTs (id: 11-21) of federal status |
|
2 |
name |
C-30 |
Own name |
|
3 |
Descripto |
C-50 |
Administrative status |
|
4 |
Desc_data |
C-63 |
Object class type |
|
coverage HOT_POINT |
object class – point |
||
|
contains hot points not expressed in the map’s scale |
|||
|
table HOT_POINT.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
name |
C-30 |
Name of center of population |
|
2 |
obl |
C-25 |
Name of oblast |
|
3 |
region |
C-40 |
Name of rayon |
|
4 |
hot_p |
C-150 |
Name of hot point |
|
coverage OOPT |
object class – polygon |
||
|
contains protected natural territories of federal status |
|||
|
table OOPT. DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
n |
I-16,0 |
PNT number |
|
2 |
n_uch |
I-16,0 |
Section number |
|
3 |
name |
C-50 |
PNT’s own name |
3.2.2.4. Basins
|
coverage BAS |
object class – polygon |
||
|
contains Russia’s Dnipro basin |
|||
|
table BAS.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
name_pbas |
C-10 |
Own name |
|
coverage BAS_5 |
object class – polygon |
||
|
contains the Dnipro’s sub-basins, including first-order tributaries within Russia’s Dnipro basin |
|||
|
table BAS_5.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
bs_num |
I-16,0 |
Sub-basin identifier |
|
2 |
name_pbas |
C-10 |
Own name of sub-basin |
|
coverage BAS_5_TER |
object class – polygon |
||
|
contains the Dnipro’s sub-basins, including first-order tributaries within Russia’s Dnipro basin, by oblasts |
|||
|
table BAS_5_TER.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
id |
I-16,0 |
Sub-basin identifier |
|
2 |
name_pbas |
C-10 |
Own name of river |
|
3 |
n_obl |
C-20 |
Own name of oblast |
|
coverage BAS_13 |
object class – polygon |
||
|
contains the Dnipro’s sub-basins, including first- and second-order tributaries within Russia’s Dnipro basin |
|||
|
table BAS_13.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
id |
I-16,0 |
User identifier |
|
2 |
name_bas |
C-20 |
Own name of river |
|
coverage BAS_13_TER |
object class – polygon |
||
|
contains the Dnipro’s sub-basins, including first- and second-order tributaries within Russia’s Dnipro basin, by oblasts |
|||
|
table BAS_13_TER.DBF |
|||
|
# |
Field name |
Type |
Content |
|
1 |
id |
I-16,0 |
User identifier |
|
2 |
name_bas |
C-20 |
Own name of river |
|
3 |
n_obl |
C-20 |
Own name of oblast |
3.3. Tabled information is exported to the DBF format by standard Microsoft Access export means using requests filtering the information stored in the initial database.
Geocoverage files (SHAPE files) are prepared in ArcView.
Graphics files (JPEG, BMP, TIFF) are prepared in Adobe Photoshop.
3.4. Exported data are archived in a file named DDMMYYYY.ZIP (information export date: DD – day, MM – month, YYYY – year) and stored in a special catalogue on the web server (http://www.dnepros.ru). Access to this information is limited and is granted to registered users by means of a standard Internet browser.
