1 / 19

The Russian National Station Database

Team on OSCAR Development (TT-OD) 26-28 November 2018, Geneva. The Russian National Station Database. Evgenii Viazilov RIHMI-WDC of Roshydromet NODC of Russia vjaz@meteo.ru. Outline. I. History of development II. Basic solutions III. Functions IV. Some results of system exploitation

gaildon
Télécharger la présentation

The Russian National Station Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Team on OSCAR Development (TT-OD) 26-28 November 2018, Geneva The Russian National Station Database Evgenii Viazilov RIHMI-WDC of Roshydromet NODC of Russia vjaz@meteo.ru

  2. Outline I. History of development II. Basic solutions III. Functions IV. Some results of system exploitation V. Interaction with other systems VI. Suggestions for interaction with OSCAR

  3. History of development of national Automated Accounting System for keeping record of Observation Units (AASOU) • 1987 – publication of the normative Guidance document 52.04.107-1986. Manual of hydrometeorological stations and posts. Issues1. – Leningrad: Hydrometeoizdat. 1987. – 183 pp. • 1989 – creation of the first version of AASOU for a large computer of the Unified Series • 1999 - creation of the version of AASOU for DBMS ACCESS • 2009 – development of AASOU as web version for access to centralized DB • 2017 - development of AASOU as web version for remote input of information and for access to centralized DB: OC - LinuxCentOS 6 x86_64; DBMS PostgreSQL v.9.3; Language – J2EE; Middleware- GateIn v. 3.6, SSO JOSSO v. 1.8.3; Development tools - Sun JDK 1.7, JBossPortalPlatformv. 6.1; Monitoring hardware and software - Zabbixv. 2.4

  4. Basic solutions • The using of the new scheme for organizing the accounting of observation units (OU) • The development of the logical structure of the AASOU DB • Inclusion of information on staffing and funding – cost of transport, communication, salary's and others costs • Remote input of information in DB • Increasing the completeness and quality of information on OU • Providing of standardized reporting on established forms of reports • Monitoring of the system functioning

  5. Accounting scheme of OU

  6. Logical structure of the DB schema 6

  7. Functions forusers • Search of information about observation networks by web-interface • Cartographic and table-graphical visualization of information • Assessment of the state and dynamics of changes in networks • Data aggregation on Roshydromet, regional offices, types of observations • Calculation of the cost of observing programs for different observations type • Access to standardized reporting • Export information in csv format • Monitoring and reporting on the operation of the system

  8. Search of OU, OP and stations • Fast search by key words for one or several attributes • Advanced Search: • Objects (OU, or OP, or stations) • Location (Federal district, Subject of Russian Federation, Antarctica, AZRF, rivers basins) • Network type (M, MRL, A, H, Marine, Agro, Geophysics, Pollution) • Observation program (8, 4, 2 times in day) • Station type (Hydro river, Lake, Coastal, RVs, VOS, ….) • Station inaccessibility (polar stations, taiga, mountains) • Status of station, OP (opened, closed, conserved, acting) • Period for opened, conserved, closed stations

  9. State of the observation networks: • Basic information about each stations • List of closed and conserved stations • List of opened stations • Number of stations by main types of observations • Number of stations for status (open, conserved, closed) • Number of stations for status by years • Number of stations for status by main types of observations • ……. • Information on staffing and funding: • Cost of OU, stations, OP for the every year • Costs of observations for regional offices on the every year • Cost of regional offices structural units for the every year • Costs for main networks and observing programs type, regional office, Roshydromet for the every year Reporting of the AASOU

  10. Cost ofthe main networks and programs observations for Roshydromet In general, for Roshydromet: The number of OU - 2591, OP - 13857, the total cost - 5.698 billion rubles, the average cost of one measurement for one parameter is 73.57 rubles.

  11. Rules for check of the attributes values • The AASOU have 31 rules. • Description of the error: There is no hydrological code, but the presence of a hydrologicalnetwork and the code of the water object. What to do: Check and edit the hydrological code. 2.Error description: Missing a station opening date. What to do: Find the opening date of the station and edit DB. • 3. Description of the error: The total cost of the OP must be greater than or equal to the sum of the costs of the salary + cost of transport + cost of communication. What to do: Check and edit DB.

  12. The jobs control of DB editing The state AASOU DB: • Organizations (33 regional office and research institute) • State of OU • Funding of OU • Funding of regional offices Roshydromet Information for jobs control: • Number updated OU • Number editing OU • Number sent OU on check to DB administrator • Number approved OU of DB administrator • Number rejected OU of DB administrator

  13. Monitoring of observation networks AASOU have the 90 indicators – general, and for every from 10 main observing networks

  14. Monitoring of AASOU operation Metrics: • Numberofusers • Numberofrecordsin DB • Numberofupdaterecordsin DB • Numberof OU, OP, stations, posts • Numbervisitors • Numbersessionsofusers • Numberuniquehosts

  15. Interaction with other systems National system the spatial and territorial planning in Russian Federation: • The geographical service (WMS) - layer «Location of OP» • Web-service – information on observation points in JSON formats • National system ESIMO (http://esimo.ru) : • The geographical service (WMS) - layer «Location of costal stations» • The information resource of part AASOU DB - information on costal stations for use together with operational and climatic data Result of web service in JSON format

  16. Some suggestions for interactions AASOU and OSCAR 1) AASOU Organizations – supportingobservation networks : The classifier of organizations OSCAR for Russia are only a few organizations: Roshydromet, CAO and MGO.Suggestions: Include 30 organizations of Roshydromet in the OSCAR Organization classifier. 2) Station class. We have a list for 50 types of observing stations. Suggestions: RIHMI-WDC to give proposals for the extension of Station class (observation point for pollution, geophysical station, marsh station, etc.). 3) Country / Territory. There is a problem for reflecting the territories of unrecognized republics (Abkhazia, North Ossetia, Pridneprovskaia republic, Donetsk republic). 4) The name of the station. Suggestions: 1. AASOU – to use English names of stations from the OSCAR DB. 2. OSCAR – to use station names (in national languages) as attribute “Station alias”. 5) The method of determining the coordinates: AASOU: put Survey or From map. 6) Location method - to add a new value “GLONASS” in the classifier

  17. AASOU features • The number of observation networks – 30, observations programs - 70 • Staffing and funding • Three levels of the organization of the account system “OU – Stations – OP” • Monitoring of observational networks - 90 indicators • Rules for check of the values of the different attributes - 31 rules • Jobs control for editing the DB • Creation of personal pages for DB editing - each organization have own list of OP • Search by main station identifiers - synoptic index, coordinate number, hydrological code • Search by territory – Federal district, Subject of RF, Antarctica, AZRF, river basins • Reporting on state of observational networks - 12 reports and the financial support - 4 reports • GIS - additional layers: Federal Districts, Subjects of Russian Federation, areas of responsibility of the regional offices for Roshydromet, AZRF, specially protected natural areas, polar projections for Arctic and Antarctica • Can change a basic layers - to select contour map, electronic map - basis with a set of basic layers, Open Street Map • Legend for visualization of various types of stations and OP

  18. Perspective • Attraction of information on observation points of other ministries - Agency of Water resources, Agency for fisheries, Ministry of EMERCOM, Ministry of transport, RAS, Agency of AutoDor, others • Description of stations for other countries • Development AASOU DB in field “Activities stations, regional officers for collection, transfer, processing, forecasting, exchange, using data” • Adding of section “Stations state ” the new tables - information on: • - legal status of observation point (right on land) • - methodical inspections (audit) • - instruments, using on hydrometeorological stations • Interaction with OSCAR: • - translate to English • - mapping AASOU classifiers • - including new attributes to AASOU from OSCAR • - using in AASOU the same identification of stations • - combining the content of two systems (the data in the AASOU and OSCAR are differ, as they are prepared at different times, by various experts, received from various sources)

  19. Thank you vjaz@meteo.ru

More Related