Home

User Manual RFIS

1. a 23 TA Adding User Group User Category 23 L2 e ele e E ger s PN sad 24 ZS Addie USER TO GROWS usada 24 Development of Quality Control Procedure 25 8 1 Adding LIMIT CHECK to a parameter Parameter Rule 25 8 2 Adding STEP CHECK to a Parameter Parameter Rule 2 8 3 Adding CONSTANT CHECK t a paramet r Ju LULU ab kek tate pal b eka bank kaye k ak a k is pita a 28 8 4 Applying rules to Networks and OU pyi adye soda ou oka is p pa e n fo pl kn pl ko a op pk pan kk ak a a ia a 29 Data ASere co Meri 30 d Ne O 31 LO JEE 32 D Content Management System CMsS 34 2 EMS DADA ia 34 3 TES INS e u u an be an e nn ee mn one 35 4 Adding PASS Content sc u u u u l ie kn id id ke bois ke de kasa 37 5 a e s As AS asas 37 SE COMPONEN ER rt a tnt tonton rere 37 52 Tex Formatines TOO Susa SAS 43 6 Ad dinae NEWS aNd EVEN O 44 7 AMIRAS U aO eee e e a eee n aac anc 45 HL Change PassWord cessed ee aie tea a is 45 TZ O EE 45 E Some useful SQL for easy data extraction directly from datab
2. Quality Check Engine Agent Data Sharing Data Correction Import Export Monitoring Data Management Device Configuration RFIS Database Data Visualization 1 Page Regional Flood Information System Components of RFIS The RFIS software intact different modules to provide a platform for the information exchange Remote Device Configuration Data Acquisition Module Data Management Module Data Visualization Module Content Document Management Module mom WwW gt A Remote Device Configuration It is a web based device configuration application operated through internet It provides an interface to configure data loggers and sensors Data Logger Request for Setting Provides Setting RFIS Database Remote Device Configuration System B Data Acquisition Module Data Acquisition Module is a gateway for weather data into RFIS database It receives data from field device through internet via HTTP protocol Other Data Data Logger Sources SMS to WEB a Gateway Data Acquisition Module 2 Page Regional Flood Information System C Data Management Module The Data Management Module comprises of following components e Data Entry It is a manual data observation entry interface that is intended for addition of Station and its metadata e Quality Control Quality Control is a mechanism for data validation Data validation is based on user definable rules
3. characters Parameter Unit RH Parameter Interval Defines units Is Parameter Group No minutes hours days months years in If set to yes this parameter will not be treated as actual parameter it will be used to group other real parameters which values are to be displayed in web Parent Parameter Specifies the parameter from which the current parameter is derived Parameter Unit Indicates unit of measurement for the parameter wu B Parameters Is Parameter Group If Yes is selected it will amp Parameters not be treated as the actual parameter rather a W water Group as a group with set of real parameters a Waterlevel 2 Gal Daily Water Level Minimum 3 In the figure alongside parameter Water Daily Water Level Maximum 4 Group is not an actual parameter it is used to I Rainfall Group group other real parameter like Waterlevel D Humidity Group Daily Water Level Minimum Daily Waterlevel Maximum EB wing Speed Group Click Save Parameter 14 Page Regional flood Information System Data Management System DMS To View saved parameter click on list parameter or click on parameter s Data Management System coda Ver 20 Home Configuration Data Sync a M Communication Group E LiPrajects Configuration gt Parameters ES Networks Add Parameter X Delete Parameter Reload Configuration Data s roups ia Data Sources Parameter Name Short Name Cod
4. user_id INT 11 transtar date TIMESTAMP gt created_date TIMESTAMP gt interval INT 11 gt read_ptr INT 11 gt write ptr INT 11 source ip VARCHAR 16 2 nat found INT 1 id BIGINT 20 P wa_observation_id BIGINT 20 raw log id BIGINT 20 station parameter ki INT 11 obs_time TIMESTAMP gt obs_value FLOAT gt severity INT 11 data source id INT 11 245 processed NT 1 gt user_id INT 11 processing start time TIMESTAMP processing end time TIMESTAMP lag time TIMESTAMP Y ki BIGINT 20 raw log id BIGINT 20 station parameter ki INT 11 0bs_time TIMESTAMP wobs value FLOAT severity INT 11 data source id INT 11 gt is processed INT 1 user_id INT 11 w processing start time TIMESTAMP wa observation audit id BIGINT 20 gt wa rula id INT 11 rule type VARCHAR 128 gt severity INT 11 gt rule failure NIT processing start time TIMESTAMP processing end time TIMESTAMP gt status VARCHAR 50 La wa rue id INT 11 wa obsemation kd BIGINT 20 gt rule type VARCHAR 128 gt severity INT 11 rule failure INT 1 processing start time TIMESTAMP gt processing end time TIMESTAMP gt status VARCHAR 50 paused INT 1 processing end time TIMESTAMP dis processed INT 1 transfer_to_auelit INT 1 gt remarks VARCHAR 255 lag time TIMESTAMP gt retry_count INT 11 gt syne INT 11 processing start_time
5. amp Add Parameter Rule Title Add Title for the rule Select Rule Type CONSTANT CHECK Le Select Rule Type as CONSTANT CHECK Check in Data Interval 1 Hours M Min required Samples Tolerance Include Suspicious YES Check in Data Interval Indicates ABSOLUTE MAX data ABSOLUTE MIN data gt Tolerance time duration of which data is to be Start Date End Date constant checked For example If 1 Hours is entered QC Select Month Select All Deselect All Y Jan VI Feb 7 Mar Z Apr will apply rules to past 1 hour data for Y May Y Jun di Jul W Aug constant check Y oc VI Nov E Sep s ei csi Min required Samples Indicates Severity NONE w Execution Order 0 required number of samples within selected time interval in Check in Rule on failure CONTINUE 7 Alert Frequency minutes 30 D falnt l ata interva Send alert on 8 Rule failure TE era YES ll severity CONTINUE NONE Ea Tolerance Tolerance must be greater IS E than the difference between Group maximum value and minimum value LISFR GROUP MAITI ING LIST amongst data selected within the 28 Page Regional flood Information System Data Management System DMS selected time duration Include Suspicious Indicates whether to include suspicious data among sample data to apply constant check Other fields are similar to those rules described above Here checks if the value being received for a parameter is changing To per
6. 2 e Ejpata Source Station Name Code e Ml Parameters E Hongtsho 8201 stations users El Sumpa 8203 Fl Mailing List 15 Page Regional flood Information System Data Management System DMS Station Name Enter station name it must be unique Station Code lt must be unique and can contain alpha numeric characters Installation Date Date when station was setup Status Current status of the station If it s in operation select Active else Inactive Active Date If Status is Active provide date from when it came into operation If Inactive provide date from which station became inactive Visibility Indicates whether station is to be made visible publicly or limited to certain groups Configuration gt Stations List Station Reload Configuration Data f Add Station Station Ci Code 2806 Name Installation 2012 04 26 Status Active Date cae 2013 06 23 Visibility Public Date Latitude Deg 27 Min 36 Sec 36 Longitude Deg 87 Min 54 EEN 2800 Timezone Bhutan Asia Thimpu meter NT Measuring Hydrological Project Hydrological Cycle Observi B P Hydrological gt Others Save Station Latitude Longitude Altitude Provide stations latitude longitude and altitude Time Zone Time zone should be same asitis in the field device installed in the station Type Select station type Automatic Manned Automatic Manned Measuring
7. Add a prameter in RTU Kathmandu Sensor OTT Compact Bubbler Sensor CBS Le Parameter Waterlevel Mame Offset 0 Sampling Interval 10 minutes wl Logging Interval 10 mins Measurement Unit meters rm Save Cancel Select the sensor for which parameter s is are to be added Select its corresponding Parameter Provide a Name for the selected parameter Provide Sampling Interval Logging Interval and Measurement Unit accordingly If saving is successful you will see the parameter in the list 3 Communication Setting Modem setting e To setup the communication press button Communication 1 image below Kathmandu gt 8 RTDL 11 Add Sensor Add Parameter Edt RTU Parameters RTU 1 Sensor Last Received Value OTT Compact Bubbler Sensor CBS Water level Wat rl vel Select the Type M2MCGI or M2MGGI depending on the use of CDMA GSM or GSM GSM respectively for data transmission 8 Page Regional flood Information System Data Management System DMS Communication parameters for RTU Kathmandu Type M2MCGI 11 D coma El APN WEB Communication parameters for RTU Kathmandu Username WEB Type M2MCGI 11 gt Password WEB Priority Medium APN Logging Disabled gelt kee Username WEB Password WEB Priority High EN Logging Disabled Lei Save Cancel Provide APN Username and Password provided by the mobile service provider Priority The modem ha
8. User Manual RFIS Regional Flood Information System ICIMOD MINISTRY FOR FOREIGN AFFAIRS OF FINLAND Table of Contents A 1 2 O A W N OH WwW A W 8 9 Jidd A RU a a a l aa kk a suns e a ao a ek klas 1 Remote D evic eConriguratiohuu EE 4 Ree 4 Contigcurine Project Station af RTO anat dra rte its 4 e NEE elle te ER De 4 22 e en E 5 23 Adding remote terminal unit RTU Joe bb n kd n bb ki de a ds did lo 6 2 4 AS O 7 Communication Setting Modem Setting I u a 8 AU Ina alg u era eee cece ena e ap ba ks e kos e S eme no 9 AU fe RS AUS al uu n eter ko a n a uu Oman Tn Su Wee a igen oer ake kon a eee pe en Ta 10 AUN NOUN on re ee a unum s uuu tus ea Sma 10 Data Management System vive sis os sk se paosebo sons sissson savkoassosobsesssyoksssasdstesonsvobsos savave paosebssssoUIsssoubakksssssSosde ake 11 OPUS pk kata ka RAT 11 Creating Projects Stations Networks and Groups 11 2 Aadne ProgJeegku 2 aun n kon kk on ka n ke e a ka e an u kota da nasa 11 220 eet 12 eer E ere uuu O na fa fa O nu sait ana 13 24 Adding Parametros IO 14 Za AA SS TION A 15 AddINE SS Ee EE 19 AY e IR SAONE NA OT AAA da 20 Ada NE CO WNC A WONN u u u uu uy va n a n a ve e a a e an E uns dec an unku on kn alex aa su 20 Adal PAP ANNO U Pu fl et oti e tan is 22 User Management and Access Control
9. raw_log for this data point as processed yes is severity k m Get real time aggregation rule for Current data point from Table wa_aggregation check if current data point is input to any real time Aggregation rule bulld the real time aggregation and insert into wa_aggregaton_queue rule execution men Insert the fules that has been executed in table wa_observatipn_rule exec uted for current data point update insert into table wa_latest_observation this action Is executed through trigger defined on table wa observation Is data Available 65 Page Regional flood Information System Flow Chart Aggregation Engine Weekly Monthly Yearly Hourl r lon Daily a ion generator generator generator Generate and store the aggregation on timely basis Read some amount of rows from table wa_aggregation_queue amp its associated rule from table wa_aggregation 1 a read a single a EE row from aggregation queue and rule cache one at a time yes is data ue avallable yes rule has error no no Need to send alert yes does it require Indate iber Mess robe no to compute E wa_aggregation q ueue saying error gaa occurred Register the alert z which will be processed read the required later by alert processor amount of data yes email alert registered in from tab
10. Regional flood Information System Data Management System DMS 2 3 Adding Groups 1 Clickon Sroups or navigate to Configuration gt gt Groups 2 Click on Add Group 3 enter the given fields e Data Management System Weed Mer 200 Projects Configuration gt Groups ES Networks Add Group PX Delete Group Reload Configuration Data E e H Data Sources Group Name Code Description El BB Parameters B station Configuration gt Groups users List Groups Reload Configuration Data Mailing List Add Group Group Name Low Land Group Code GP LL Enter the description Group Description Save Group Group Name Group name can be anything it s another way if classification of Station So you can classify your group on the basis station attributes of common or physical location or basins like high land low land SYNOP etc whatever suits your requirement Group name must be unique For hydrological station you can create groups according to basin for meteorological station you can create group according to altitude Group Code Group code must be unique and can contain alpha numeric characters Group Description Briefly describe group name though it s not mandatory but recommended Click Save Group To view your saved groups click on Groups link in a tree view Home Configuration Data E al Projects I Configuration gt Groups D
11. Sirajgunj Station 00 00 0000 00 00 laa RTS Training Hycos Test Project 0000 00 00 0000 00 00 la Napa kel SAARC Storm Program MA RTS TEST O RTS QQrts test G Users ae Groups 2 2 Adding Station W Wscada Configuration In the project list page image above o sss Projects Hycos Test Project QO click on the project 1 or click on S gj HKH HYCOS Nepal 4 P 8 AR Hs Mulghat Projects in the left panel to expand 4 AWS Dhankuta HS Bohrobise the tree and click on the project 2 8 ke Regional Training ICIMOD Bubbler Test Station 8 ke RND Testing RTS Office jh Kurigram To edit this project 3 click on button Edit Project 2 8 ke Interface Testing M Test Station M Test Station 2 ad HKH HYCOS W Gupis ke HKH HYCOS Bangaldesh To add a station click on button Add Station 1 under the project 3 Hycos Test Project Station Provide Station Code Must be unique Vue eis and numeric Name ee Provide Station Name Ku Hydrological a Select Station Type Location Leave other fields blank and click Description ld f saving is successful you will see the a mama station in the station list page Juration gt E Projects Projects gt Hycos Test Project 8 Q HKH HYCOS Nepal Regional Training Add Station Edit Project Add Project RRND Ten Code Name Type location Description
12. This also provides interface to configure alerts warning based on observations received and the rules defined QC helps to check correlation between observations for same station or multiple stations Further it provides timely information for errors in sensor and system e Data Aggregation Data Aggregation is a mechanism for generating derived parameters from basic parameters The data aggregation is based on specific rules data quality and availability The aggregated data can also be handled by the QC engine e Monitoring Data Management System also provides a web interface to monitor remote devices This generally includes Data monitoring Power and Battery usage monitoring which helps in fault finding and trouble shooting of remote devices Automatic notification is generated for any error communication error device error etc e Data Rectification Processing DMS provides an interface for correcting observations audit trail and data download and upload This module also facilitates manual execution of rule engine and aggregation engine e User Management D Data Visualization Module RFIS provides a large set of components for visualization of data in different standards and formats such as e Basic tabular view and graph view for all the parameters e Virtual instruments on websites for specific parameters for real time display e Map view with Google map integration The data visualization module provides highly customizable
13. ki Interface Testing Hydrological 8 HKH HYCOS 0001 Kathmandu Hydrological gj HKH HYCOS Bangaldesh KA Sirajgunj Station Si hkh bangladesh 8 M Hycos Test Project Sr Kathmandu 5 Page Regional flood Information System Data Management System DMS 2 3 Adding remote terminal unit RTU e Inthe station list page image above click on the station 1 or click on Hycos Test Project in the left panel to expand the tree and click on the station 2 W Wscada Configuration El Projects Hycos Test Project 4 Kathmandu jag HKH HYCOS Nepal D jad Regional Training 8 GB RNO Testing be Interface Testing DD je HKH HYCOS 8 be HKH HYCOS Bangaldesh laa Sirajqunj Station ad hkh bangladesh kas la Hycos Test Project kathmandu e To edit this station 3 click on button Edit Station 2 e Toadd RTU click on button Add RTU 1 under the station 3 General Tab stat al PH AS Select type RTDL 11 Provide RTU name and code code must be Type RTDL 11 unique and numeric Mame RTU Kathmandu re i Provide Primary Server device will Primary Server ICIMOD die sa communicate to this server and also Secondary Server ICIMOD sends parameter readings Encryption AES AES Key W s s Provide Secondary Server device Confirm AES Key will not communicate with this server but send parameter readings f you want to enable data encryption select Enc
14. navigate to Administration gt Sign out 45 Page Regional flood Information System Some useful SQL for easy data extraction directly from database Station and parameter station audit v 7 station parameter audit Y _ station v id INT id INT 7 station parameter v id INT P station id INT station_parameter_id INT id INT scope id INT gt name VARCHAR 64 gt name VARCHAR 64 P station id INT sync_out_unique_id VARCHAR 16 gt code VARCHAR 16 short_name VARCHAR 32 4 parameter_id INT D deleted_timestamp TIMESTAMP installed_on DATE description TINYTEXT user_id INT gt sync_change_detected INT latitude VARCHAR 24 gt code VARCHAR 32 deleted_timestamp TIMESTAMP user_id INT longitude VARCHAR 24 gt interval DECIMAL 4 1 P altitude VARCHAR 16 interval_frequency ENUM V M gata receive blocking INT unit VARCHAR 8 mama AFT UPDATE tgr station deleted date address TINYTEXT gt visibility BOOL F accessibility TINYTEXT gt parameter type BOOL LLLLLLLLLIT 1 landmark TINYTEXT property BOOL ToT Ae sensors_used TINYTEXT gt inherit_qc_rule BOOL station_type VARCHAR 64 2 inherit_aggregation_definition BOOL 9 measuring_type VARCHAR 64 gt data receive blocking INT parameter audit Y parameter bi timezone VARCHAR 32 user_id INT id INT Y id INT project id INT timestamp TIMESTAMP o parameter id INT ni SECHER status BOOL
15. Add Group for Station 2 5 1 Defining Station Network Select Network Select Network name from a list Provide Network Code Add code which must be unique and can contain alpha numeric characters Begin End Date Enter network begin and end date These fields are not mandatory you can leave it blank Inherit QC Rule Select YES or NO for QC rule Status Current status of a network If it s in operation select Active else Inactive AA Save Network Click to save 17 Page Regional flood Information System Data Management System DMS 2 5 2 Defining Station Group Provide group for the station that you are currently working Station can belong to multiple groups Select Groups Select station group from the list Station Group Code Provide station group code lt must be unique and can have alpha numeric characters Begin End Date Add begin and end date for group These fields are not mandatory Inherit QC Rules Indicates whether to inherit rules defined for selected group to station under consideration Status Select group status if the group is in operation select Active else Inactive A Save Group Click to save these settings To view saved station click on station name from hierarchical arrangement on the left 2 5 3 Viewing Station panel Data Management System cada Ver 2 0 Home Configuration Data Sync Projects
16. Content Editor e Next click on RSS Feed from Insert Component tool bar e Click on Edit tool from the tool bar that appears next to Insert e Set the properties for RSS Feed in the RSS Feed Properties dialog box that appears RSS Feed Properties x Title RSS Feed Title Add title for the RSS Feed Description Add description for Add description for feed i RSS Feed if any else leaves it Description blank penin EE Feed URL Add feed url to retrieve Maximum Items 4 a feed List Type Box Maximum Items Enter the number of feeds to display at a time List Type Select list type to display RSS Feed It can be either displayed in a box numbered list or in a bulleted list List Class Indicates HTML CSS Class which would be used for styling the output for this Feed Box List Class Note Make sure to save and publish any changes that you have made in a page 41 Page Regional flood Information System Content Management System Resources Panel You can use Resources panel to upload and share any information a Select an area to insert Resources Panel on a page and then click on Insert Component gt Resources Panel Resources panel will appear on the selected place to insert it Next click on Text tool from the tool bar that appears for Resources Panel and properties for resources panel Main Title Add main title for Resource panel This will appear mo as a panel name Box Style
17. Default Box Style Select box style to Title Title display resources add description if any Title Add title for the resources Description if any else leave it blank Description Add description for the resources else leave it blank Click OK button to save the added properties b Add resources to a panel by clicking on Add Items tool bar name Resource Early Warning System File upload a file to add in a File EMS 116 KB Change resources panel Display Title Early Warning System Display Title Display title will be same as resources This title will be displayed as a link in a resources panel Click on OK button to save the added resources Click on Save and then on Publish icon Page Options New w Administrator ES c Similarly clickon Remove Items to remove any added resources Select the file to remove and then click OK button Early Warning System PDF 116KB Note Make sure to save and publish any changes that you have made in a page 42 Page Regional flood Information System Content Management System 5 2 Text Formatting Tools The table below describes the various text formatting tools Style Add style to your headings Add font size for page content LE Bold tool enables you to give your text bold appearance kg Italic tool enables you to give your text italic appearance Superscript tool enables you to position your text slightly higher than the
18. INSERT INTO wa latest observation wa last observation id wa latest observation id station parameter id last severity last obs time Last obs value latest severity latest obs TIME latest obs value last error obs ervation id last exftor obs time last error obs value VALUES NEW 1d NEW id NEW station parameter id NEW severity NEW obs time NEW obs value NEW severity NEW obs time NEW obs value NULL NU LL NULL ELSE INSERT INTO wa latest observation wa last observation 1d wa latest observation 1d station parameter id last severity Last 60 Page Regional flood Information System obs time last obs value latest severity latest obs time lat st obs value last error obs ervatrion LA last error obs time last error Obs value VALUES NULL NULL NEW station parameter id NUL L NULL NULL NULL NULL NULL NEW id NEW obs time NEW obs value END IF ELSE IF NEW severity 1 THEN IF latestObservationTime NEW obs time THEN UPDATE wa latest observation SET wa last observation id NEW id last severity NEW severity last obs time NEW obs time last obs value NEW obs value latest Severity NEWsseverity latest obs value NEW obs value WHERE station parameter 1d NEW station parameter id ELSEIF latestObservationTime lt NEW obs time THEN UPDATE wa latest observation SET last severity NEW severity wa last observation id NEW id last obs time NEW obs time last obs value NEW obs value latest
19. Short name WG WL e Code 2 Rat al Group i A Interval minutes Hat zl RG RE Unit m Precipitation RG_PC Group a W water Group Rain Intensity RG_RN_INT Is Group No Description 25 Page Regional flood Information System Data Management System DMS Let s take an example to define Limit check where ma ara er Ku temperature must be between 5 to 30 C Title Woe LIMIT CHECK Select Rule Type as LIMIT CHECK Lower Limit Upper Limit x S 8 Provide Lower Limit and Upper Limit must be wee la numeric value Check the lower and upper Select Month Select All Deselect All thresholds for a parameter V Jan V Feb V Mar V Apr V May V Jun Yi Jul Y Aug Di sep 7 oct FI Nov VI Dec Select Start and End date Severity NONE E Execution Order 0 Select Month The applied rule will be executed Rule on failure CONTINUE Alert Frequency minutes 30 for selected months only For e g if you select Jan Send alert m Rule fail ruletailure YES Ll severitliCONTINUB NONE l and Feb rules will be executed for these months Select Alert Group only USER GROUP MAILING LIST N aa ama d amd GDA Sor Severity If the value that DMS receives for this parameter exceeds the limit than it will be flagged as the severity you select NONE Indicates there is no error in value ERROR Indicates value as Error and such value will not be visible in public domain SUSPICIOUS Value is fla
20. Time Value Observation Time Ve 2013 11 15 00 00 00 12 4676 2013 11 15 00 30 00 12 4221 2013 11 1501 00 00 12 4221 on 1 2013 11 1502 30 00 14 243 2013 11 15 03 00 00 14 2886 2013 11 15 03 30 00 14 243 2013 11 15 04 00 00 1 2013 11 15 05 00 00 13 8561 2013 11 15 05 30 00 2013 11 15 06 00 00 2013 11 15 06 30 00 2013 11 15 07 30 00 2013 11 15 08 00 00 i 2013 11 15 08 30 00 2013 11 15 09 00 00 Data Upload Helps manually uploading data Data gt Data Upload Select Template You can select the Invalid values Su File rua template if it has been created Ciimport Data already If No create one by filling Gan the below fields Template pak e Select file type as Excel or Csv which needs to be uploaded xcel Csv Data start row Indicates start row number of the file which is to be Description uploaded Exclude row Indicates rows to be Data start Row 1 excluded Exclude Row Sheet number to process Specifies eg 10 20 40 70 75 85 95 total number of sheets in your file sheet number to process 1 which needs to be processed 9 1 2 4 9 10 Treat empty cell as null Indicates IPAP Cente Seb ae put de whether to treat empty cell in the file as null or not 23 N A n a V gt 1 AND V 50 TIM TV age sis Invalid values Specifies types of Treat invalid value as null YES EN value to treat ae invalid Select File Choose File No file chosen Treat invalid value as null Data Timezo
21. appear VA lez AAA Cranfini iratinn W Wscada Configuration e a l E Projects Wscada Configuration Home Projects a Users _ Add Project sas Groups AE IE ASIA y HKH HYCOS Pilot Project sa HKH HYCOS Nepal 2012 04 28 Regional Training List of projects RND Testing Interface Testing 2012 04 2 2013 04 21 Project for Interface Testing Purpose Only 1 HKH HYCOS HKH HYCOS Bangaldesh Sirajgunj Station hkh bangladesh e Provide Name of the project Project Details e Provide Start Date Completion Date Jame Hycos Test Project and Description of the project these Start Date fields are not mandatory Completion Date e Save your project by clicking on Save button Description Save Cancel 4 Page Regional flood Information System Data Management System DMS e If saving is successful you will see the project in the project list Wi Wscada Configuration ea Projects Wscada Configuration Home Projects i HKH HYCOS Nepal Add Project la Regional Training os Completed E RND Testing E HKH HYCOS Nepal 2012 04 28 0000 00 00 HKH HYCOS Pilot Project Weise Testing Regional Training 2012 04 16 2012 04 21 EI HKH HYCOS RND Testing 0000 00 00 0000 00 00 a HKH HYCOS Bang interface Testing 2012 04 22 2013 04 21 Project for Interface Testing Purpose Only 1 Ga Hycos Test Project HKH HYCOS 2012 04 22 0000 00 00 HKH HYCOS Bangaldesh 2012 06 09 0000 00 00 laa Test Project
22. components for user specific requirements and it is scalable to add further visualization components E Content Document Management Module The Content Management Module is an interface in DMS to manage additional documents reports publications news etc related to station and observations This module can be integrated with data visualization component to create customizable web pages to display on public web sites Further this module provides basic search and document management system for repository Note There are separate links for Remote Device Configuration Data Management System and Content Management System Please contact Real Time Solutions for the links 3 Page Regional flood Information System Data Management System DMS B Remote Device Configuration This section familiarizes several web based tools associated with remote device configuration viz configuration of data logger and sensors and Setting its parameters 1 Login VIC A A W WSCADA Enter your credentials to login Username Password Remember me on this computer Log In 2012 Real Time Solutions Pvt Ltd www wscada net In the web browser enter the link provided by RTS Provide you username and password If login is successful you will see an interface like below 2 Configuring Project Station and RTU 2 1 Adding a Project Click on Project and then on Add Project on the right pane A project details dialog box will
23. human intervention is applied process data otherwise O processing_start_time begin time of processing the data point processing_end_time end time of processing the data point including all rules execution time user_id if the data is inserted by any user set it to respective user id otherwise NULL wa_observation_audit table log_time time data inserted into wa_observation sync if setto 1 data point is eligible to be synchronized otherwise not 54 Page Regional flood Information System User Management Y id INT 11 usemame VARCHAR 32 name VARCHARI SO gt password VARCHAR 512 description TINYTEXT blocked TINYINT 1 group email VARCHAR 150 forgot_token YARCHAA 50 forgot_timestamp TIMESTAMP deleted_timestamp TIMES TAMP P id INT 11 role ENUM O deleted_timestamp TIMES TAMP vid INT 11 user_id INT 11 full_name VARCHAR 128 organization VARCHAR 1 28 country VARCHAR 64 S city VARCHAR 64 user_group_id INT 11 designation VARCHAR 64 station_id INT 11 contact address TINYTEXT privilege SET T c d gt landline_no VARCHAR 32 ko mobile no VARCHAR 32 gt Each and every user should belong to minimum one user group User privilege is inherited from user group privilege Table user username must be valid email address password must be md5 hash blocked if set to 1 user is not allowed to acce
24. is set to the corresponding station parameter if rule of is station parameter otherwise this is set to NULL 5 parameter id this field is set to the corresponding parameter global parameter if rule ofis parameter otherwise this is set to NULL 6 network_id this field is set to the corresponding network if rule_of is network otherwise this is set to NULL 7 group type this field is set to the corresponding group if rule ofis group otherwise this is set to NULL 8 rule_type type of rule limit_check step_check constant_check 9 start_date rule execution begin date 10 end_date rule expiry date 11 severity 0 ok 1 error 2 Suspicious 12 user_group_ids comma separated user group ids 13 mailing_lis ids comma separated mailing_list ids 14 subject alert subject 15 msg alert body 16 alert frequency numeric minutes after which next alert will be send 17 rule_on_failure halt or continue In case rule fails to run 18 rule failure severity only applicable if rule on failure is continue O 1 or 2 19 rule failure alert send alter if rule fails to run 20 month select 13 character long Each character position reflects to the month and character can only be O and 1 except first character 1st character will always be example 100100000000 2st position character is set to 1 means January 5th position character is set to 1 means April this means rule is application to run only for J
25. other text on the line Select the character to superscript and click on superscript tool Subscript tool enables you to position your text slightly lower than the other text on the line Select the character to subscript and click on subscript tool Numbered paragraph tool enables you to arrange information s in list in numbers E Bulleted Paragraph tool enables you to arrange information s in list in bullets ka Indent tool enables you to add indentation to a paragraph Outdent tool enables you to remove indentation from a paragraph Insert Image tool enables you to insert image in a text box Click on Insert Image tool and select an image to insert or upload a new image Insert a link tool enables you Create link x to add link to any external URL Text Type a text to hyperlink or internal pages It also Internal Page add internal page name to link enables you to create email External URL add a URL to link address as a link L Email add email address to link 7 Open link in new window Ok Remove link tool enables you to delete created link from a page Select the link to delete from dialog box and click OK button Clear Formatting tool allows you to clear the formatting that you have applied to any text Select the text and the click on Clear Formatting tool Highlight Tool enables you to highlight the content in a text area Height Tool enables you to define the height of a tex
26. real time if Real Time Posting is selected If saving is successful you will see the RTU in RTU list page as shown below V Wscada Configuration i Projects E a HEH HYCOS5 Nepal Hycos Test Project gt Kathmandu Add RTU Edit Station E Z Regional Training E Se END Testing D ki Interface Testing E 3 HKH HYCOS 3 HKH HYCOS Bangaldesh laa Sirajgunj Station la hkh bangladesh S M Hycos Test Project i Kathmandu O a a RTDL 11 2 4 Adding RTU Sensors Inthe RTU list page image above click on the RTU 1 or click on station in the left panel to expand the tree and click on the newly added RTU 2 W Wscada Configuration n Kathmandu 8 11 e D HKH HYCOS Nepal Or E Regional Training E jag AND Testing Parameters Name E jeg Interface Testing E HKH HYCOS 8 gg HKH HYCOS Bangaldesh lewd Sirajqunj Station lag hkh bangladesh ken H ke Hycos Test Project h E A Kathmandu es RTDL 11 To edit this RTU 3 click on button Edit RTU 2 7 Page Regional flood Information System Data Management System DMS To add a sensor click on button Add Sensor 1 under the RTU 3 Add a sensor in RTU Kathmandu Type OTT Compact Bubbler Sensor CBS EN SDI Address 0 Save Cancel Select the type of sensor Settings are provided accordingly to the type of sensor selected Click Add Parameter 4
27. 3 Oct 28 Mon ay ges Ww Sumpa News and Events Administrator 12 26 2013 Oct 28 Mon Mew Pages Recent Pages W Dorakha News and Events Administrator 14 16 2013 Oct 28 Mon Bookmarked Pages z Dorakha Hydrology Administrator 15 59 2013 May 17 Fri daa Yz Uzorong Hydrology Administrator 15 56 2013 May 17 Fri k Resources GES TI Notices Hydrology Administrator 15 51 2013 May 17 Fri Navigation TI Tenders Meteorology Administrator 15 53 2013 May 17 Fri The right pane on the page list all the new pages created booked marked pages recent pages etc The left pane displays the list of all the pages Web Content Editor Dashboard All Pages Displays the list of all the pages You can bookmark the page by clicking on thelial icon Displays the list of all the newly created pages Recent Pages Displays the list of recently visited pages It lists the details of who visited the certain page and at what date and time Bookmarked Pages Displays the list of pages that were bookmarked in All Pages Resources List outs all the files that were uploaded using the Image gallery or Resources Panel You can edit or delete any uploaded files form this Resources page Navigation is a link using which you will create and design page 34 Page Regional flood Information System Content Management System 3 Create New Page To create a new page click on Navigation link on the right pane OR Web Content Editor KL Uzorong n Li Sum
28. ATA LOGGER RTS DATA LOGGER RTS DATA LOGGER RTS DATA LOGGER RTS DATA LOGGER 2015 05 27 05 50 1 2013 05 21 05 50 2013 0522 05 50 2013 05 22 O5 46 5 2015 05 27 05431 AOL TSF DS RE Processed Data t System W cada Ver 2 0 Sync Severity Allows selecting from the list to display only those data that has been flagged as OK SUSPICIOUS or ERROR Latest Data Display recent data received in the server Data gt Latest Received Data Timezone Bangaladesh Asia Dhaka gt View Sarajganj Additonal Supply Voltage 2013 05 22 05 00 00 13 59 EA 2013 06 22 050000 13 59 Sanagganj Moden 250 13 03 22 05 00 00 19 2013 05 22 05 00 00 19 Siragganj Modemil Recent Error 2013 05 22 05 00 00 13 2013 05 22 050000 13 Saragganj Modem CSO 2013 05 22 05 00 00 99 2013 05 22 05 00 00 sa Sarapganj Moderni Recent Error 2013 05 22 05 00 00 EN 2013 05 22 05 00 00 Sira gan Modem CS 2013 05 22 05 00 00 2013 05 22 05 00 00 32 Page Regional flood Information System Data Management System DMS Feed Edit Data Helps to manually feed and edit data Data gt Feed Correct Data gt Hongtsho gt Device Supply Voltage Interval 30 Minu gt Timezone Default UTC Source Process sl Start Date 2013 11 15 00 00 End Date 2013 11 15 23 59 Human Qc ed Yes y Pass to System QC No gt Devcle RTDL 11 D Insert character N to indicate N A or invalid value Observation Time Value Observation Time Value Observation
29. C Reload Configuration Data is GI croup a 69 Data Sources Group Name Configuration gt Groups be a Parameters E Low Land GP LL Add Group s List Groups Reload Configuration Data el e Stations users NH nd GP HL Group Information pe Mailing List Fl wmo GP WMO Narne Low Land Edi Code GP LL Description 29 Page Regional flood Information System Data Management System DMS An interface is diplayed with list of applied rule on left 1 and a form to add rule on the right 2 with Add Network Rule or Add Group Rule Configuration gt Groups gt Low Land gt Rules Add Group List Group G Reload Configuration Data Add Rule Delete Rule Title Rule Type Para Title Select Rule Type Lower Limit Start Date Select Month Jan E May Y Sep Severity Add Group Rule LIMIT CHEd Select Parameter Waterlevel Pa Upper Limit End Date Select Al Deselect All Fi Feb NI Mar Y Apr V Jun V Jul Y Aug Y Oct Y Nov Y Dec NONE SX Execution Order 0 Steps for applying different rules LIMIT CHECK STEP CHECK and CONSTANT CHECK have already been described Here parameter for which rule is to be applied has to be selected under Select Parameter Data Aggregation To apply data aggregation on any data Home Configuration Data Sync Click on station on left panel for 2 Pro
30. E ai poca ki e deleted timestamp TIMESTAMP ees gt name VARCHAR 64 bt Sus INT inactive_date DATE short_name VARCHAR 50 P Geer description TINYTEXT e gt timestamp TIMESTAMP gt code VARCHAR 32 user id INT parameter_interval ENUM ELLE p unit VARCHAR 8 e timestamp TIMESTAMP AFT INSERT tgr_station_audit_insert gt user_id INT Station information is stored in two tables station and station audit The main purpose of creating two table is to record all the changes there is no provision of update or deletion Every time user inserts the station information a new row is added in station audit table preserving the previous entry While fetching the station information latest record from the station audit table is Supplied to the user Code SELECT s sa FROM station INNER JOIN SELECT max id group by Station idas saa ON 8 INNER JOIN station audit as as s as max id station id FROM station audit id g a Station id sa ON saa max id sa id Note same storing principle is followed for parameter and station_parameter 46 Page Regional flood Information System Station network and group id INT id INT station network id INT station group id INT station gou group station code VARCHARS2 id INT id INT network station code VARCHAR 32 start date DATE gt end_ date DATE gt start_date DATE station id INT sd t a Ode
31. END tgr_wa_observation_insert BEGIN DECLARE stationParameterld INT DEFAULT NULL DECLARE latestObservationTime DATETIME DEFAULT NULL SET Gime Zone 4 00 00 SELECT station parameter id latest obs time FROM wa latest observation WHERE station parameter 1d NEW station parameter id INTO stationParameterld latestObservationTime IF stationParameterld IS NULL THEN IF NEW severity 1 THEN INSERT INTO wa latest observation wa last observation id wa latest observation id station parameter 1d last severi ty last obs time last obs value latest severity latest obs time latest obs value LASE error observation ad last error obs time last error obs Value VALUES NEW id NEW id NEW station parameter id NEW severity NEW obs time NEW obs value NEW severity NEW obs time NEW obs value NULL NULL NULL ELSE INSERT INTO wa latest observation wa last observation id wa latest observation id station parameter id last Severi ty last obs time last obs value latest severity latest obs time latest obs value last error Observation 1d Last error obps tame last error obps value VALUES NULL NULL NEW station parameter id NULL NUL L NULL NULL NULL NULL NEW id NEW obs time NEW obs value 59 Page Regional flood Information System END IF ELSE IF NEW severity 1 THEN IF latestObservationTime NEW obs time THEN UPDATE wa latest observation SET wa last observation id NEW id last severity NEW severity last obs t
32. GIN DECLARE sid INT DEFAULT NULL SELECT station id FROM station min WHERE station id NEW station id INTO sid IF sid IS NULL THEN INSERT INTO station min station 1d c de vis1b111ty name project 1d Station audit 1d VALUES NEW station id NEW code NEW visibility NEW name NEW project id NEW id ELSE UPDATE Station min SET code NEW code name NEW name project id NEW project id station audit id NEW id visibili ty NEW visibility WHERE station id sid END IF END tgr_station_parameter_deleted_date BEGIN IF NEW deleted timestamp IS NOT NULL THEN DELETE FROM station parameter min WHERE station parameter id NEW id END IF END 58 Page Regional flood Information System tgr_station_parameter_audit_insert BEGIN DECLARE sid INT DEFAULT NULL DECLARE spid INT DEFAULT NULL SELECT station id FROM station parameter WHERE id NEW station parameter id INTO sid IF sid IS NOT NULL THEN SELECT station parameter id FROM station parameter min WHERE station parameter 1d NEW station parameter id INTO spid IF spid IS NULL THEN INSERT INTO station parameter min station parameter 1d station 1d c de visibility name station parameter audit id VALUES NEW station parameter 1d sid NEW code NEW visibility NEW name NEW id ELSE UPDATE station parameter min SET code NEW code name NEW name station id sid station parameter audit id NEW id visibilit y NEW visibility WHERE station parameter id spid END IF END IF
33. HECK Interval 1 Allowed increment Hours Include Suspicious the difference betwe n two consecutive value PONT B and POINT A is greater than 0 3 so POINT B is an erroneous data point Le YES ABSOULTE PREVIOUSDATA ABSOLUTE RECEIVEDDATA lt Allowed increment Start Date Select Month V Jan iv May V Sep Severity Rule on failure Send alert on rule failure Select Alert Group Select All V Feb WI Jun d Oct NONE Le CONTINUE Le YES 2 Rule on Failure execute End Date Deselect All Y Mar Y Jul Y Nov Execution Order Alert Frequency minutes Rule failure severity CONTINUE Y Apr Y Aug Y Dec E Insert Title for the rule to be applied Select Rule Type as STEP CHECK Increment It indicates the maximum amount of deviation allowed between two consecutive values lt must be a numeric value Include Suspicious Enter Start Date and End Date for which the rule is applicable Select Month This rule will be month only E g If Jan and Feb executed for selected are selected then the rules will be applicable only for these two months It indicates action to be taken If no data is available for this rule to If Continue is selected this will execute with the severity as selected in Rule failure severity Continue If Halt is selected this rule will halt and further r
34. O O O O 5 727 E Y Hydrological Lu Created 2013 05 22 0 2013 05 22 0 2013 05 22 0 2013 05 22 05 00 31 2013 05 22 05 16 51 2013 05 22 05 16 51 a a AF 1 AP An Fa Data Managemen Home Configuration Project ZU12472 VX AMIE 2013 05 22 05 18 52 2013 05 22 05 18 52 a a Y AP 45 AT Aa PA Raw Data Latest Data Feed Edit Data Data Upload KID VAIA Luc RTS DATA LOGGER RTS DATA LOGGER NTF mare i m t e Not Found Lists every data which are not mapped to the station here mapping means in terms of Device Code and Parameter Code e Paused e Retry Lists data that has been stopped for procession due to error in rule execution Lists all data points that has been processed more than 10 times e Processed Displays all processed data that has been passed through QC rules e Unprocessed Displays unprocessed data Processed Data Displays all processed data that passed through QC rule Data gt Processed Log Displaying records 1 250 of 526 DIER dd Mahon 629636 Sirajgan 625647 sirajgarij 62645 Sirajganj 629644 Laien Shah Bridge 679642 Lalon Shah Bridge AREAS Siraiaani Doromeder Precipitation vMesdesel Precipitation Precipitation Precipitation Precipitation Tuma 2013 05 22 05 45 00 EAS KAN 2013 05 22 05 40 00 2013 05 22 05 40000 2013 05 22 05 36 00 2013 05 22 05 35 00 a EA 8 771 a a a Sower RTS DATA LOGGER RTS D
35. Output Parameter Indicates the parameter formed after aggregation Status Indicates whether to enable or disable the aggregation Enable Alerts Indicates whether to enable alert if aggregation fails or generate alert on every aggregation Alert is sent to the selected group at certain interval defines at Alert Frequency minutes 9 1 Aggregation Type Aggregation type can be broadly classified into i Delayed Calculation Applies aggregation to a set of data data within an hour day week month or year to create hourly daily weekly monthly or yearly value BJ Add Aggregation Rule Title Primary Input vou Aggregation E k Parameter X Relative Humidity EN Type Hourly Include Null NO gt Include Suspicious YES Ea E Min No of required samples 0 Agg function SUM EN means ignore Time Offset 0 minute sl ca Value Filter Example V gt 20 AND V lt 10 V gt 1 AND V lt 10 V 9 OR V 7 AND V 5 V IN 20 45 55 Output meant Device Supply Voltage EN New fields are generated if any of the Delayed Calculation Aggregation Type is selected Include Null Suspicious Indicates whether to include null suspicious values in data aggregation Agg Function Indicates the type of aggregation Sum minimum maximum average or count to apply on data Number of data for which aggregation is to be applied is entered in Min No of required samples Time Offset Includes data that lies within the time o
36. Read some amount of data points from Get rules from table wa_rule table raw log Start y Run time rule cache y Run time data cache Is data no Read a single Available EXIT rol Si data cache yes Get rules for current data point Insert the rules that has been gxecuted in table faw log paused executed rule for current data point ontinue halt t update the table van raw log set continue necessary flag not found paused cflag SUSPICIOUS Register the alert which will be processed later by alert processor email alert registered in table email queue Severity Is ERROR gt yes Execute rule one at a time E O pflag initially pflag is not set yes Rule has error pflag yes Need to ii send alert left to execute flag cfla ST no ER a no rule severity execution complete is error 64 Page Regional flood Information System severity enor Check in table wa_ observation Check if data point already exists copy previous data point from table wa_observation to wa_observation_audit and rules from table wa_observation_rule_executed To wa_observation_audit_rule_executed insert Into table wa_observation with current data point and update raw_log for this data point as processed update table wa_observation with current data point and update
37. Rules can be applied to individual parameter s network and groups There are 4 types of rules can be applied to each parameter Limit Check Step Check Constant Check and Parameter Cross Check Data Acquisition Raw Comply Comply Comply Data Parameter Network Group Station Rules Rules Rules Rules Comply Invalid Invalid Flag Data Trigger Notification Aggregate Store Data Processed Data 8 1 Adding LIMIT CHECK to a parameter Parameter Rule This rule checks if a parameter exceeds a certain SC s Data Management System th reshold limit ni MWicodo Ver 2 0 Home Configuration Data Sync Dar j Projects FRET Click on Parameters from tree view or navigate to reeds kwa Projects S Networks Networks ees Configuration gt gt Parameters amp Groups Delete Project Data Sources A Data Sources Click on parameter for which rule is to be applied l prs DATA Loccen Parameters cle Observing Syst from the list of Parameters ai Stations Parameter Users S a enn Marling List Click on Rules from Parameter Information E Configuration gt Parameters Configuration gt Parameters Add Parameter List Parameters a Reload Configuration Data Add Parameter Delete Parameter Reload Configuration Data Parameter Information Parameter Name Short Name _ w Name Waterlevel 12 Edif Rules Water Group n Fl Waterlevel WG WL
38. S vefity NEW Sseverlty wa latest observation id NEW id latest obs time NEW obs time latest obs value NEW obs value WHERE station parameter 1d NEW station parameter id ELSE UPDATE wa latest observation SET wa last observation 1d NEW id last severity NEW severity last obs time NEW obs time last obs value NEW obs value WHERE station parameter 1d NEW station parameter id END IF ELSE UPDATE wa latest observation SET last error observation id NEW id last error obs time NEW obs time last error obs value NEW obs value WHERE station parameter id NEW station parameter id END IF END IF TF NEW transfer to audit 1 THEN INSERT INTO wa observation audit wa observation id raw log id station parameter id obs time obs value severity data sour ce id user 1d processing start tame processing end time log tim 15 processed VALUES OLD id OLD raw log id OLD station paramete r 1d OLD obs time OLD 0ps value OLD s v rity OLD data source 1d 0LD user id OLD processi ng Start time OLD processing end time UTC TIMESTAMP Pr OLD is processed SET lastinsertld LAST INSERT ID INSERT INTO wa observation audit rule executed Wa ObS TVation audit Td wa rule id rule type severity rule failure processing start tim e processing end timeystatus SELECT last inserta Wa rule id rule type severity rule failure processing start time processing end time status FROM wa observation rule executed WHERE wa ob
39. Saa Networks O Add Group Reload Configuration Data E Group A ad 1 O ske Code Descript High Land ane wna Low Land GP LL Ger High Land GP HIL ie Mid Land WMO GP WMO a Data Sources D Jy Parameters E GIS GP GTS B Stations Mid Land GP ML 13 Page Regional flood Information System Data Management System DMS 2 4 Adding Parameter Template Click Bl Parameters or navigate to Configuration gt gt Parameters A list of pre defined parameters will be listed on a right pane Click Add Parameter to add a new parameter we Data Management System besos Mer 2 0 Projects Configuration gt Parameters gt Networks Add Parameter RA Delete Parameter Reload Configuration Data a Groups an Data Sources Parameter Name Short Name Code Unit E Water Group aaa E Stations ONNOQUrATION arameters CT Waterlevel m Users s List Parameters Reload Configuration Data F Mailing List E Rainfall Group ei Add Parameter Parameter Name Parameter name A nana must be unique Short Name HG_RH briefly describe parameter Parameter Short Name Enter parameter short name not mandatory Parameter Description Parameter Description Briefly describe parameter You can leave it blank but Parameter Code 8 recommended i n Parameter Code Parameter code must Parameter Interval Minutes be unique and can contain alpha numeric Parent Parameter SELECT
40. Solutions Group Email E Administrator Al oc Role Super Administrator Le T Data Download Save Group CT Alert Group e First Pane 1 lists all groups that were created e Second Pane 2 lists users in a particular group e Third Panel 3 displays form for adding a group and a user 7 2 Adding Group 1 To add a new group click on Y Add Group displayed in first panel 2 Form for adding a new group will be in third panel x 3 Click to save 7 3 Adding User to Groups 1 Select Group Name for which you want to add user CL on Add User on group QC 3 Fill the form to add user in a group Add User on group QC Add Group 2 Add User Group Name Group Email Name Organization Full name Organization C Undefined En City F Administrator Designation Status Unblock Landline no Mobile no Contact Address Username Password Select User Group Administrator E qc 24 Page Regional flood Information System Data Management System DMS Development of Quality Control Procedure This section familiarizes with data quality control process and how to apply quality rules on data from station This section will enable one to design quality control to validate data from field devices Le by applying rules Rules can be simple mathematical operation and or user defined function based on time and data Note
41. StartDate Edit i Parametefs L s Bi parameters z por StationDevice Sensors 3 S stations E List Aggregation Devices Y Communication Hongtsho 8201 ER Wee Sumpa 8203 Active since 2012 04 26 Sensors Korilla 8202 llati Dat 2012 04 26 Dd ri als a a C gt Uzorong 8204 Installation Date me f gd Cod Add Station Edit Station KSLCi Patan Baitadi Add Parameter Reload Configuration Data ap e LAP Gunitsawa 8206 n Q Add Sensor Delete Sensor QC Reload Sensors 4Add Station Sensor Mus Measensor Name Sn Sensor Name ae Undefined Basi asi 1 Administrator SN mailing List ee Undefined Cata Installation Date Purchase Date Manufacturing Company Sensor Name Specify the sensor being used Next Calibration Date Displays list of Connected Device added sensors Protocol SN Field to enter Serial Number of the sensor Interface Select Calibration Alert Group Installation Date Indicates USER GROUP date of installation Alert Before Days Purchase Date Indicates date of purchase of sensor Remark Manufacturing Company Indicates manufacturer of the o m sensor A A III III II II II III A ES SELECT SELECT SELECT MAILING LIST Next Calibration Date Indicates the date when the sensor is to be calibrated Notification is sent through email to various
42. TIMESTAMP Le processing end tima TIMESTAMP F da Table raw log Every point of data that needs to be processed should be in this table This is the only table from where DMS QC processes the data Following are the attributes and its use obs time data received time station timezone not utc obs value observed value device code device unique identifier from where the observation is sent Alphanumeric parameter code parameter unique identifier Alohanumeric This code recognize the observed value to which parameter its belongs to pass ac set to 1 if it needs to pass through qc otherwise 0 data_source_id respective data source table data_source This defines the data originated domain 7 user id if the data is inserted by any user set it to respective user id otherwise NULL 8 transfer date time when the data is transferred to processed log table wa observation A aa Sa SE 9 pi 53 Page 10 read ptr applicable only when data send by RTS data logger 12 13 14 15 Table Regional flood Information System created_ date time at which the data point is stored in the table interval applicable only when data send by RTS data logger Parameter received interval write_ ptr applicable only when data send by RTS data logger source ip applicable only for data send by RTS data logger IP address of the source at the time data is received not_found set to 1 if d
43. Type This means type of data this station will provide If it measures Water level measuring type will be Hydrological If it measures weather parameters measuring type will be Climatology and so on Project Select Project Name Other meta data of the station viz contact person number address accessibility and landmark can be entered under Others If Hydrological is selected for Measuring Type then provide the following additional information Y Hydrological Basin Name Catchment area meter River name Y Others Contact Person Contact Person Number Address Accessibility Landmark y Save Station 16 Page Sec zl H 325 lt lt H A Regional flood Information System Data Management System DMS If saving is successful you will be redirected to an interface as shown below where further information for station can be provided Add Station List Station List Gunitsawa parameters Reload Configuration Data d Guia Code a Coda Start Date o Add network for Gunitsawa Visibility Public e YES Active Le Add Group on Gunitsawa X Delete Group Reload Group gt Hydrological Code Star Date Add group for Gunitsawa P Others Select Group Y save Station AO Station Group Code Begin Date End Date Inherit QC Rule YES Pa Status Active gt 4 m t Y save Group O Detail Network for Station
44. a numeric characters Indicates type of data Continuous or Accumulated Unit of measurement of the parameter Indicates whether to make parameter visible publicly or to certain group Select the sensor name providing this parameter E g Water level is given by Rader Level Sensor Indicates interval of display of parameter Indicates whether the parameter provides real time data or aggregated data Indicates whether to inherit QC rule applied to that particular parameter Provides upper threshold for the parameter Provides upper threshold for the parameter Click Save Parameter to save above station parameter User Management and Access Control Users are grouped in category A single user must have at least one category 7 1 Adding User Group User Category Click on di Users Data Managem SBS PI Projects E Networks f py Groups Data Sources in a tree view or navigate to Configurations gt gt Users E a ig Parameters Stations Mailing List DI E Parameters aX Mailing List 23 Page Regional flood Information System Data Management System DMS An interface with list of groups and user groups will be displayed Configuration gt Users Reload User Data Reload Configuration Data g Add Group Add User on group Administrator 1s Add User Group Group Name Group Email Username Name Organiza Group Name E Undefined Ej e admin rts com np Real Time
45. ameter Daily Rainfall aggregation_type can be one of the following hourly delayed calculation daily delayed calculation weekly delayed calculation monthly delayed calculation yearly delayed calculation 51 Page Regional flood Information System e table Interpolation T able real time calculation delayed calculation aggregation rule will be executed after the specified time real time calculation aggregation rule will be executed as soon as the input parameter is received 5 status 1 enable 0 disable 6 user group ids comma separated user group ids 7 mailing_lis_ids comma separated mailing_list ids 8 subject alert subject 9 msg alert body 10 enable_alert 1 yes 0 no need to send alert when aggregation fails to execute 11 alert frequency numeric minutes after which next alert will be send Fields applicable to delayed calculation only e include null 1 yes 0 no e include suspicious 1 yes 0 no e value filter expression to rule to filter the input parameter values while calculation example V gt 20 AND V lt 10 V gt 1 AND V lt 10 V 9 OR V 7 AND V 5 V IN 20 45 55 where V is the input value e aggregation function can be sum min max avg count e min samples minimum no of required samples of input parameter if O is supplied this field is ignored The aggregation rule will use all the available samples for calculation If aggregation_type is hourly e time offset min
46. an Hydrological Cycle Observing System ns Networks Configuration gt Stations 9 Add Station s List Stations C Reload Configuration Data croup Station Information Run Rule Manually pata sot StartDate 2013 06 23 00 00 EndDate y Edit Parameters Sensors Logs y Bl parameters i I l m Dees StationDevice RTDL 11 8206 gt StationParameter ALL Y List Aggregation Devices Communication gt Hongtsho 8201 Name e Gunitsawa gt Sumpa 8203 i r ctive si Y Korilla 8202 ciai gt Uzorong 8204 Installation Date 2012 04 26 W Undefined Sensor Parameter PTrashiyangtse 8205 Code 8206 Gunitsawa 8206 Station Type Automatic M users Measurement Type Hydrological Mailing List Hil taxing us Basin Name River Name Catchment Area Timezone Asia Thimphu Latitude 27 36 3 60 Longitude Altitude 2800m Project Hydrological Cycle Observing System Visibility Public 18 Page 2013 06 23 23 59 Regional flood Information System Data Management System DMS 3 Adding Sensor To add sensor select Station on which you want to add sensor and then click on Data Management System VWSCGGG Ver ZO Home Configuration Data Sync Projects Configuration gt Stations ES Hydrological Cycle Observing System Add Station List Stations Reload Configuration Data ES Networks Gi Groups Station Information Run Rule Man Data Sources E
47. anuary and april If rule type is limit_check parameter1 upper limit parameter2 lower limit include suspicious NOT SET NOT REQUIRED data interval NOT SET NOT REQUIRED data interval type NOT SET NOT REQUIRED SA P ai KE If rule type is step check parameter1 Allowed increment Numeric parameter2 NOT SET NOT REQUIRED include suspicious 1 for yes 0 for no data interval Check in data interval Numeric data interval type hour or minute hip Tee If rule type is Constant check parameter1 Min required samples parameter2 tolerance include suspicious 1 for yes 0 for no data_interval Check in data interval Numeric data interval type hour or minute OT Ee 50 Page Regional flood Information System Aggregation Rule Jager parameter v as id INT 11 gt sync out unique id VARCHAR 16 Ssync change detected INT 1 0 Firrr ri al station_id INT 11 scope_id INT 1 1 gt sync_out_unique_id VARCHAR 16 be et SI change detected INT 1 deleted_timestamp TIMESTAMP gt parameter id INT Ie sagregtion v gt user_id INT 11 vid INT 11 deleted_timestamp TIMESTAMP Ti gt user_id INT 11 title VARCHAR 255 gt station id INT 11 input_parameter_id INT 11 output parameter id INT 11 gt aggregation type VARCHARI64 gt indude_null TINYINT 1 L E ya include_suspi
48. ase 46 SE TOMA a uu u n a E NT sa ie a ener ey ener ane ene tet rey tery er ere ret mer rey ak ere e en ee a 46 staton network and CLOUD u u A aaa a e ko ke ken aaa asss 47 A O A n aa O OO IS kn ke dette qa fake eki ta kata sun 56 S Oleg Procedures cae ou aa ua a Cau tt uqa ua ua lia al e De 57 SSSR nn nuna amana A TEE a PEE E E EE E TE E EEEE E T E EE TEE TEE a A TE 58 F System COMPONEN Lunnis ka w w la ji l kb at kt l D l a a kk EEN 62 Acronyms AES Advanced Encryption Standard APN Access Point Name CDMA Code Division Multiple Access CMS Content Management System DMS Data Management System GUI Graphical User Interface NTP Network Time Protocol QC Quality Control RFIS Regional Flood Information System RTU Remote Terminal Unit SMS Short Message Service Regional Flood Information System A Introduction The RFIS Regional Flood Information system is a time series software that provides a platform for timely exchange of flood data and information The RFIS is developed with the objective of flood observation network in Hindu Kush Region with the development of regional database for hydrological and meteorological information thus providing a common data sharing format for easy dissemination of weather information in the region RFIS HYCOS Field Devices Data Acquisition Data entry Rule Engine Other Data e Aggregation Sources Engine
49. at you have made in a page Page Formatting You can add various components and formatting tools to your page content by using the tool bar at the top Components Text Formattina Tools 5 1 Components Page Options x Page Properties With Page Properties component add properties for page Editor Administrator 2013 11 15 11 26 52 Publisher Administrator 2013 11 15 11 26 53 Title Career Code add page code add page tad D Page Preview Clicking on Page Tags Preview will provide an actual view of Module Content B Module Type Content EN Status Unlisted L Protected Save Regional flood Information System Content Management System how the page would look like be publishing This enables you to copy all the component of an existing page Paste Components This enables you paste the copied components to a new page Copy Components Insert Components Insert vou can add various components such as text image navigation etc to a page The various page components are described below a Container To add a new container for a page click on Insert Component gt Containers b Text To insert a new text area on a page navigate to Insert Components gt Text This will insert a text area on a page SR Web Content Editor E insert Container Style Size All Pages A S SAS MANIE D CIS MAS New Pages Text 574345 lt I RecentPa
50. bbreviation of youn d Stations roject users Short Name Hycos proj 7 Mailing List Start and End Date Enter the End Date start and end date of your Enter project description project Project Description Project Description Enter description of the project Save Project button to save Next click on Note Only the fields marked are mandatory 2 2 Adding Network 1 Clickon Networks or navigate through Configuration gt gt Networks 2 Click Add Network Data Management System Wi rode bier 2 A Wicoda Ver 20 Home Data Sync E Projects Configuration gt Networks 9 Add Network M Delete Network Reload Configuration Data a Groups mme mm a ES Data Sources Network Name d s e Parameters Add Network E stations S FB Users Network Name Nepal Mailing List Network Code NP NT 01 Enter Network Description Network Description Save Network Network Name Provide name to the network you want to create Network name can be anything It is just a way of classification of station For example you can classify your network on the basis of station type like Hydrological Meteorological Agro Met etc Network name must be unique Network Code Network code must be unique and it can have alpha numeric characters Network Description Provides a brief description of the network Click Save Network to save and create the network 12 Page
51. ccess permission for a page 36 Page Regional flood Information System Content Management System Adding Page Content To add content in a created page follow All Pages Home the following steps New Pages El About Us Recent Pages DI Meteor 1 Click on Navigation link on the left ology D Hydrology A News and Events a News 25 D Events 26 O Bookmarked Pages panel Unlinked Pages k Resources 2 From the list of pages that appears click a page for which you want to add edit its content Navigation 3 From tools that appear click on Edit Page tool 4 Clicking on the Edit Page tool will redirect you to Page Option where you can add your page content 5 Click on the page content area and add page content Web Content Editor t f Insert All Pages New Pages Recent Pages Bookmarked Pages Unlinked Pages Resources Navigation no Page Options I levy ee ee a e A Z F tk FASIAN TAN ANAL AIN Qa Department of Hydro Met Services Eee Ministry of Economie Affairs e Nationale mt weather elite and water resources Pa d A m e EN ef ll gt 0 tuer a Be Home AboutUs Meteorology Hydrology Early Warning News and Events Contact Us News and Events Page Title gt News Page Content gt Events Add your page content bere Career Click and add page content a Note Make sure to save and publish any changes th
52. cious TINYINT 1 value_filter VARCHAR 1024 gt week_start_ day INT 1 T id BIGINT 20 table_values VARCHAR 102 4 wa_aggregation_id INT 11 time_offset VARCHARIE disc w obs_time TIMESTAMP 2 min samples INT 11 data start_time TIMESTAMP aggregation function VARCHARIG A w data end time TIMESTAMP enable alert INT 1 created date TIMESTAMP status INT 1 transter_ date TIMESTAMP 4 2 user group ids VARCHAR 1024 H i k pt CE CO SU SU A O O y processing start time TIMESTAMP gt mailing_list_ids VARCHAR 1024 2 processing end time TIMESTAMP subject VARCHARI ZO48 retry_count INT 11 gt msg TEXT alert_frequency INT 11 gt last_alert_time TIMESTAMP generation_source ENUM agg_type ENUM gt value FLOAT last_generated_time TIMESTAMP 2 remarks VARCHAR 1024 deleted timestamp DATETIME Aggregation rules can be defined on station basis only and stored in table wa_aggregation Following are the attributes and its use e e e o e E station_id this field is set to the corresponding station input_parameter_id this field is set to corresponding station parameter This is the input parameter for the aggregation rule output parameter id this field is set to corresponding station parameter This is the parameter for which this aggregation rule will be executed using input parameter example Input parameter Rainfall Output par
53. e Gunitsawa lt Add Station Edit Station Gunitsawa Add Parameter e Reload Configuration Data In Q Add X Delete Reload Add Communication Means cl a Type 5n Protocal Provider EN Modem M Modem Type GSM Data transfer protocal HTTP Sn a a Purchase Date Installation Date Manufacturer Name Sim Number Sim Activation Date It indicates the type of means used by data logger to transmit data Different means of communication are i Modem i Acquisition Script iii Manual SMS iv Manual Form Entry i If Modem is selected given interface is displayed Modem Type GSM CDMA Iridium Add Communication Means Communication Modem Modem Type Data transfer protocal Sn Purchase Date Data Transfer Protocol It indicates the type of protocol used by the modem to communicate with the server E g GSM and CDMA use HTTP whereas Iridium uses SBD Enter the SN Purchase Date Installation Date Manufacturer Name Sim Number Sim Activation Date Network Provider and Remarks Click Save Installation Date Manufacturer Name Sim Number Sim Activation Date Network Provider Remarks 21 Page 6 Regional flood Information System Data Management System DMS Add Communication Means li If Acquisition Script is selected you will have to provide the Source Domain through which data is being Comm
54. e HTML Panel Select the area to insert HTML Panel and then click on Insert Components gt HTML Panel In the YouTube Browser dialog box that appear paste the embed code of a video and click OK button YouTube Browser Paste the Embed code here lt iframe width 420 height 315 Note Make sure to save and publish any changes that you have made in a page External Links External Link enables you to link to any other external link To add external link to a page i Click and select the area where you want to add the External link page iii for an external link box External Links x Navigate to External Link from Insert Component tool A link box will appear ona Next click on Text tool from the tool bar and set the title description and style Box Title Add box title Box Style Select box style from drop down box Title Add title for the links if any else leave it blank Description Add description for the links if any else leave it blank Click OK from the tool bar that appears for External Links and Add a link x Text Link Link http www rts com np Box Title Links Box Style Default B Title Some useful links Description iv Click on Add Link tool add link e Text Enter a text that will OK be displayed as a hyperlink e Link Enter a link URL to which to redirect when it is clicked e Click OK button after you are done The link that you ju
55. e Unit Interval Bi Parameters E Water Group FWGF seconds a W water Group E Waterlevel Wo WI 2 m minutes a W rainfall Group a M Humidity Group E Rainfall Group RG seconds relative Humidity 8 El Rainfall RG_RF 1 mm minutes a wind Speed Group n F F Frecipitation RG PC 21 mm minutes a Wind Direction Group e WB pressure Gr oup E Rain Intensity REG RN INT 111 mm minutes a Temperature Group E Rain Quantity RG_RN_QNT 113 men minutes E Rain Quantity RT NRT RG_RN_QNT_RT_NRT 112 mm minutes a Mvoitage Group a W tatus Gin E Rain Quantity Total NRT EG EN ONT TTL NRT 114 mm minutes e W Error Gro up E Bucket Content NRT Rp BKT CONT NRT 116 mm minutes amp W solar Radiation Group PI Bucket Content RT ane E Se enn a dew Point Group B stations E Humidity Group AGE seconds EB users F1 Mailing List E Wind Speed Group WSG dE 2 5 Adding Station e Click Stations e Click Add Station on left panel or navigate through Configuration gt gt Stations M codoa Ver 20 Data Management System Projects Configuration gt Projects gt Reload Configuration Data Data Management System coda Ver 20 ES Networks D Groups E a Data Sources E A D ters Stations Home Configuration Data Sync m Projects Configuration gt Stations Users amp Networks Fa x a I Add Station JM Delete Station Reload Configuration Data E Mailing List Group
56. evice_code and or parameter_code mapping is not found otherwise O paused set to 1 if rule has not enough data to run the rule or rule execution is incomplete otherwise 0 In this case all the rules executed till the failure will be inserted in table raw log paused executed rule IS processed set to 1 if human intervention is applied process data otherwise 0 retry count Number of times QC engine tries to process the data point processing start time begin time of processing the data point processing end time end time of processing the data point wa observation After processing data from raw log data is then inserted into wa observation table and the all the rule executed for the data is inserted into table wa observation rule executed In case if data already exists for the station parameter for a specified time the system copies the previous data to wa observation audit and rules to wa observation audit rule executed Following are the attributes and its use O O SN O OEA 10 transfer to audit if set to 1 on update previous data point is copied to 12 13 id auto increment number raw_log_id associated raw log id from table raw_log obs time observation time in UTC obs value observation value severity data error category Can be O ok no error 1 error 2 suspicious data_source_id respective data source table data_source This defines the data originated domain IS processed set to 1 if
57. ffset defined Value Filter Indicates what data to filter so that no aggregation is applied on it Data is defined as a formula rule li Real Time Calculation Applies aggregation to real time data This aggregation can be applied to interpolate data Add Aggregation Rule Title Primary Input 7 w Aggregation me Parameter X Relative Humidity E Type Interpolation Table 8 Add Row x Reading Y atve din x Remove 31 Page 10 Data Visualization Regional flood Information System Data Management System DMS There are three types of data visualization available Raw Data Processed Date and Latest Data Raw Data Displays all the data received from field device Data gt Raw Log Displaying records 1 250 of 1089 DDR id Device 666597 5303 Lalon Shah Bridge 665598 8302 Sirajganj 666595 8203 Lalon Shah Bridge 646596 8302 Sirajganj 655597 8303 talon Shah Bridge 666591 8303 Lalon Shah Bridge Deg ww AAS a Parameter 21 Precipitation 21 Precipitation 21 Precipitation 21 Precipitation 21 Precipitation 2 Watertevel ni me Time zone displays the country Start and End Date indicates duration between which data is to be viewed Flag e Show All Time Stotion timezone 2013 05 22 11 25 00 2013 05 22 11 25 00 2013 05 22 11 20 00 2013 05 22 11 20 00 2013 05 22 11 15 00 2013 05 22 11 15 00 Aaa AF 45 sa na Displays all available data Reoding
58. form the constant check the system requires value that we just received that needs to be checked and the precious values values that has already been check and stored number of previous value required is determined by no of samples The system will calculate the absolute mean from the no of samples If the difference between these two values calculated mean value and received value is greater than the tolerance you provided the value will be flagged as the severity you selected If you select NONE it means there is no error in the value if ERROR it means error and this value will not be visible in public domain if SUSPICIOUS this value is flagged as suspicious but it s still visible in public domain Now click If saving is successful you will see the rule on left pane 8 4 Applying rules to Networks and Data Management System E Wseada Mer 20 Groups As stated rules can be applied to Projects Networks Data Sources Projects networks and groups too B M Ne orks On the left panel click Networks or coo Grou ps m Data Sources Parameters Parameters stations Stations m Users Users F mailing List Mailing List A list of networks or groups is listed Click on a network or group name to which rule is to be applied D s Rules Next click on sr link see an image below Projects Configuration gt Groups DI amp Networks Add Group M Delete Group L
59. ges Image Department of Hydro Met Services Bookmarked Page HTML Panel Ministry of Economie Affairs i i wo The Nati tale or weather climate and water resource Unlinked Pages External Links ji uku gt ad a Resources pueda p TC E ge Gi Navigation Z W e Dr assqa Navigation Tagged List Home AboutUs Meteorology Hydrology Early Warning News and Events RSS Feeds Resources Panel News and Events News Home Page Home Panel gt News Page Content Text area that you inserted gt Events iii Career Note Make sure to save and publish any changes that you have made in a page c Image To add image to a page click on Image from the Insert Component tool Container All Pages Text New Pages Recent Pages From the image gallery dialog box that Bookmarked Page HTML Panel appears click on Choose File button and Unlinked Pages select the picture to add from your PC Resources and close the box Navigation External Links Navigation Tagged List RSS Feeds Resources Panel Image Galery Home Panel The uploaded file will appear in 1456 x 1964 1669 x 2164 262 x 192 the Image Gallery and in a page Note Make sure to save and pace Bi publish any changes that you have Choose File No file chosen made in a page 38 Page Regional flood Information System Content Management System HTML Panel If you are to add any video file on a page us
60. gged as suspicious but is still visible in public domain Rules on Failure Indicates what action is to be taken if data is not available for this rule to execute If Continue is selected this rule will execute with severity as selected in Rule failure severity Continue If Halt is selected this rule will halt and further rule execution is seized Execution Order Indicates priority of the rule execution if the parameter has more than one rule applied O means higher priority larger the numbers lower the priority Select Alert Group Sends an alert through E mail to selected group whenever the applied rule fails Provide the subject and message of the alert email ae en EE em Alert Frequency Indicates time after which USER GROUP MAILING LIST next alert is to be generated It must be a ET Administrator others gt numeric value Fl ac a Subject Click Save Parameter Rule Msg The applied rule is displayed on left panel of list of parameters Save Parameter Rule 26 Page Regional flood Information System Data Management System DMS 8 2 Adding STEP CHECK to a Parameter Parameter Rule This rule verifies whether the rate of change of instantaneous value is within a limit or not Let s take an example where two consecutive temperature value differences cannot be more than 0 3 C 15 value 10 es Add Parameter Rule Title Select Rule Typ Check in data e STEP C
61. gory Data Logger EN 2 Undefined i E Purchase Date Installation Date Description Device Name Specify the name given to the device Device Code Must be unique for each device and can contain Y Save Device alpha numeric characters SN Specifies the serial number of the device Device Category Specifies the type of device Note For Device Category as Data logger Device Code must exist in order to map the station with data being sent by the data logger and must match with the one set to data logger Manufacturing Company Specifies the manufacturer of the device Purchase Date Indicates the purchase date of installation of the device Description Field to enter description related to the device Adding Communication Communication here indicates means by which data logger transmits data to central server that can be through modem manual SMS manual form etc 1 Select Station to add communication parameters 2 Click Communication 20 Page Regional flood Information System Data Management System DMS s Data Management System Woda Ver 20 Home Configuration Data Sync a Projects A Hydrological Cycle Observing System ina Networks a Groups a Data Sources Gi parameters a Stations Hongtsho 8201 i Sumpa 8203 st Korilla 8202 Communication Configuration Stations Add Station List Stations Run Rule Ma O StartDate StationDevice Nam
62. groups before the date set as Alert Before Days Connected Device Indicates device to which sensor is connected e g data logger from specific manufacturer Protocol Communication protocol between sensor and device data logger Interface Indicates the type of interface sensor uses to communicate with the data logger 19 Page 4 5 Regional flood Information System Data Management System DMS Adding device Devices To add device select Station and then click on Data Management System lt Wscada Ver 2 0 Home Configuration Data Sync Projects Configuration gt Stations ES Hydrological Cycle Observing System a Add Station s List Stations Reload Configuration Data Networks GB Groups Station Information Run Rule Man GData Sources StartDate Edit s Parameters Se Lo s P Parameters Ge s lt StationDevice 3 E Stations T List Aggregatiorf Devices Communication Hongtsho 8201 Na gt Sumpa 8203 Add Station 2 Edit Station Gunitsawa Add Parameter e Reload Configuration Data Ac Y Korilla 8202 8 k Add Device Delete Device QC Reload Device jada Device 2 Uzorong 8204 D 05 Co Name Code Device Name RTDL 11 S Gunitsawa 8206 Mus Device Code 8206 ae Undefined SN 1 201103 34 D SS Administrator Lists added devices po 7 mailing List Cate
63. hosen canner Choose a banner to State E Protected GES Y Visible State Select the state which can Link To Not linked to any page gt either be Protected or Visible or ker Gate Carer both Make sure to select the state as visible else the navigation will External URL not be displayed Prefix the url with gt to open on a new window Ex gt q 2084 Link outside of icimod org domain will always open Link To Select a page from in a new window pag dropdown menu if you want to link Save Te n to any specific page else select Not linked to any page User Code Add user code External URL Enter the external URL link if you want to redirect a link to any outside domain The link should be prefixed with gt sign After you are done with adding information s for the page click on Tools Description Edit Tool Clicking on this tool will enable you to edit page setting Insert new navigation below Clicking on this tool will enable you to add new navigation page The page created will be a main page Insert new child navigation Clicking on this tool will enable you to add a child page The page created will be a child page of main page Remove navigation Click to remove navigation Edit Page Clicking on this tool will redirect you to page where you can edit the select page content Refresh Clicking on this will refresh the navigation page Access Control Using this tool you can set a
64. hreshold Lower Hysteresis 9 Pa ge Save Cancel 5 6 Regional flood Information System Data Management System DMS upper threshold and upper hysteresis e Similarly If alarm is to be enabled for lower limit of selected parameter enable it and must be enabled in Communication as described in section 3 e Select Group to whom SMS is to be sent if SMS is selected as Type e If alarm is to be enabled for upper limit of selected parameter enable it and provide provide lower threshold and lower hysteresis Remember Above settings sensor parameters communication alerts are not yet synchronized with the device rather these are just saved into the database Press Download 3 button to synchronize these settings to device When device establishes a communication with the server these setting are then saved into the device Adding Users W Wscada Configuration e E Projects Registered Users a Users 2 Nishant Agrawal oe Sudat Tuladhar Beptien S Ranjan Shrestha nishant Nishant Agrawal sudat Sudat Tuladhar A Jayaram Dhakal I ranjan Ranjan Shrestha a ki fa Administrator jayaram Jayaram Dhakal Sazzad admin Administrator Sandeep Paudel sazzad Sazzad Mukunda Baidy sandeep Sandeep Paudel WIUEUNOd Dadya E mukunda Mukunda Baidya da pema Pema pema S li Groups I RTS amp Bhutan Click on Add User to add a new user e Specify the type of user as General Operato
65. ime NEW obs time last obs value NEW obs value latest severity NEW severity latest obs value NEW obs value WHERE station parameter id NEW station parameter id ELSEIF latestObservationTime lt NEW obs time THEN UPDATE wa latest observation SET last severity NEW severity wa last observation id NEW id last obs time NEW obs time Last OOS valus NEW Obs value latest Severity NEW severity wa latest observation id NEW id latest obs time NEW obs time latest obs value NEW obs value WHERE station parameter 1d NEW station parameter id ELSE UPDATE wa latest observation SET wa last observation id NEW id last severlity NEW Severuty last obs time NEW obs time last obs value NEW obs value WHERE station parameter 1d NEW station parameter id END IF ELSE UPDATE wa latest observation SET Last error observation LO NEW id last error obs time NEW obs im last error obs value NEW obs value WHERE station parameter 1d NEW station parameter id END IF END IF END 6 tgr_wa_observation_update BEGIN DECLARE lastinsertid BIGINT DEFAULT NULL DECLARE stationParameterld INT DEFAULT NULL DECLARE latestObservationTime DATETIME DEFAULT NULL SET timer zone DEES BERT A SELECT Station parameter id latest obs time FROM wa latest observation WHERE station parameter id NEW station parameter id INTO stationParameterld latestObservationTime IF stationParameterld IS NULL THEN IF NEW severity 1 THEN
66. jects amp Networks W Nepal 56 Groups Low Land amp Data Sources B Parameters which the parameter needs to be aggregated Click List Aggregation f Stations Data Aggregation orm is e Hongtsho 8201 displayed on the right panel ori 202 a Sumda 8203 Add Aggregation Rule 4 Title Primary Input Parameter SELECT PARAMETE gt ee Output Parameter Status Enabled EN Enable Alert Alert frequency 30 minutes Select Alert Group USER GROUP MAILING LIST Administrator Others QC Data Download Alert Group Subject N 5 g Uzorong 8204 YES on failure m Delayed Calculation Configuration gt Stations Add station e List Stations a Reload Configuration Data Station Information Ges Sensors s Logs Name e Hongtsho Active since Installation Date 2012 05 20 Title Enter Title for the E aggregated data e g Discharge Dew Point 5 Primary Input Parameter X Select primary parameter which is to be aggregated to create derived parameter Aggregation Type Offers different types of aggregation to be applied to the parameter Aggregation Type is broadly classified into Delayed Calculation and Real Time Calculation It will be discussed at the end of the topic 30 Page Jr Run F StartDat StationD LaSensc gt OTTI P Unde Regional flood Information System Data Management System DMS
67. le wa_observation table email_queue and execute the rule nsufficient dat Or error occurred insert the generated value into table raw_log and update the row in table EE 66 Page Regional flood Information System Alert Engine Email Aggregation Engin Generate alert Read some amount of rows from table email_queue A email queue msg EXIT read a single row from run time email alert cache queue process vit Update table email queue set send date field 67 Page
68. llation_date DATE remarks TEXT next_calibration_date DATE 2 user_group_ids VARCHAR 1024 mailing_list_ids VARCHAR 1024 alert_before_days INT 3 station_device_id INT 1 1 w data transfer protocal VARCHAR 64 9 interlace VARCHAR 64 station_id INT 11 communication means VARCHAR 64 modem type ENUM data transfer protocal ENUM acquisition source domain VARCHAR 1024 gt modem sn VARCHAR 128 gt modem purchase date DATE 9 modem installation date DATE sim number VARCHAR 32 lt gt modem manufacturer VARCHAR 255 sim activation date DATE sim service provider name VARCHAR 512 remarks TEXT P id INT 11 sync_out_unique_id VARCHAR 16 syne change _ detected INT 1 station_id INT 11 category VARCHAR 255 start_date DATE end_date DATE description TEXT 48 Page Regional flood Information System QC Rule id INT 11 O sync out unique id VARCHAR 16 sync change detected INT 1 tid INT 11 scope id INT 11 dsync out unique id VARCHAR 16 m de ki Gsyne change detected INT T rule of ENMIM O deleted ti amp TIMEST 2 station_parameter_id INT 11 a gt user_id INT 11 parameter INT 11 SS id INT 11 gt network_id INT 11 group_id INT 11 rule type ENLMI gt Sum out unique id VARCHAR 16 sync change detected INT 1 station ki INT 11 star da
69. minutes Parameter z ye Code Type Continuo J 4 Rules Modemi Recent Error 30 minutes Parameter Unit Visibility Public m 8 4 gute Moden C5Q 30 minutes Sensor E Rutes Modem Recent Error 30 minutes f Parameter SELECT gt 22 Page 7 Regional flood Information System Data Management System DMS Parent Parameter Select from the list of parameters These are pre defined parameter list that were added earlier in Section 2 4 Selection of any parameter auto fills most of the fields Default values can be modified as per the requirement Also a new parameter can be created instead of selecting from the list You can toggle parameter from a list and creating a new one by clicking on button Parameter Name change name of parameter but the parameter name should not match Add Station Parameter he SELECT Parameter 4 Parameter dis Name Description Parameter Tune conti Code ype Continuous Parameter Unit Visibility Public between selectin Sensor _ SE ECT 8 Parameter SELECT gt Interval Frequency Minutes e Inherit OC Property Sensor parameter Rec gt na Q YES El Lower You can Upper threshold dE y Save Parameter parent parameter name Parameter Code Type Parameter Unit Visibility Sensor Parameter Interval amp Frequency Property Inherit QC Rule Upper Threshold Lower Threshold Must be unique and can contain alph
70. n network audit table is supplied to the user Code SELECT S Sa PROM Station network as s INNER JOIN SELECT max id as max 1d station network id FROM station network audit group by station network id as saa ON S lt 10 sad station network id INNER JOIN station network audit as sa ON saa max id sa id Note same storing principle is followed for network group and station group 47 Page Station device sensor and communication id INT 11 sync_out_unique_id VARCHAR 16 em Change detected INT 1 station_id INT 11 device code VARCHAR 16 gt name VARCHAR 128 sn VARCHAR 128 device_type VARCHAR 64 installation_date DATE manufacturing company VARCHAR 128 purchase_date DATE description VARCHAR 2048 user_id INT 11 deleted_timestamp TIMESTAMP P id INT 11 station_sensor_id INT 11 calibration_date DATE calibration_test_certificate VARCHAR 128 id INT 11 scope_id INT 1 1 Regional flood Information System P id INT 11 sync_out_unique_id VARCHAR 16 sync_change_detected INT 1 sync_out_unique_id VARCHAR 16 sync_change detected INT 1 deleted_timestamp TIMESTAMP user_id INT 11 id INT 11 sync_out_unique_id VARCHAR 16 syne change detected INT 1 station_id INT 11 sensor_name VARCHAR 255 sn VARCHAR 128 manufacturing_company VARCHAR 255 purchase_date DATE 9 insta
71. ne Default UTC EN Indicates whether to treat invalid i vie am value as null or not Select File Browse for the file to be uploaded Data Timezone Specifies timezone of data in the file Need to QC Indicates whether to apply QC on data or not Human Processed Indicates whether data of the file is human processed or not Data Source Indicates source of data Select Station Indicates station of which the data is No of columns Indicates total number of columns in the file According to the number of columns entered fields for column number and corresponding value are generated Click Verify This entry is saved as a template Next time this template can be selected from Select Template 33 Page Regional flood Information System Content Management System D Content Management System CMS Content Management System CMS is a web based application that provides a Graphical User Interface GUI This section familiarizes with several server tools associated with content management system that helps one to manage content for the website 1 Login Login into the CMS admin page with the link and credentials provided by RTS 2 CMS Dashboard The first page that you see after a successful login is a dashboard Dashboard is an interface which displays all the possible links needed for an effective website esa Web Content Editor All Page All Pages W Uzorong News and Events Administrator 14 51 201
72. on UNT gt end date DATE group id INT status BOOL status BOOL gt user_id INT imest inherit_qc_rule BOOL D con gt deleted_ti amp TIMESTAMP Q inherit_qc_rule BOOL a a 2 deleted_timest TIMESTAMP inherit_aggregation_definition BOOL _ eg SE usor_ki INT inherit_aggregation_definition BOOL Scope _ gt user_id INT id INT sync out unique id VARCHAR 16 y y 9 user_id timestamp TIMESTAMP timestamp TIMESTAMP gt deleted timestamp TIMESTAMP sync_change_detected INT gt user_id INT id INT gt id INT id INT id INT scope_id INT e scope id INT network id INT I name VARCHAR 50 gt deleted_timestamp TIMESTAMP AFT UPDATE tgr_station_deleted_date gt deleted timestamp TIMESTAMP l name VARCHAR 50 code VARCHAR 32 user_id INT code VARCHAR 32 m gt gt L 2 description TINYTEXT 2 description TINYTEXT KEE wp group id INT user_id INT gt user_id INT timestamp TIMESTAMP timestamp TIMESTAMP gt gt was ws Station network is stored in two tables station network and station network audit The main purpose of creating two table is to record all the changes there is no provision of update or deletion Every time user inserts the station network information a new row is added in station network audit table preserving the previous entry While fetching the station information latest record from the statio
73. pa Hydrology Recent Pages Dorakha Hydrology Bookmarked Fages Gi Dorakha Meteorology Unlinked Pages TI Uzorong Hydrology k Resources TI Notices News and Events LI Tenders News and Events Navigation link will display a list of all the navigations created previously To create a new page 1 Click on the link where you want to create a new page A tool box appears with an option to create and edit page delete refresh and access control 2 Click on Insert new navigation below tool to create a new link or click on Insert new child navigation tool t te child igation n all eZ Web Content Editor O Home About Us D Meteorology D Hydrology A News and Events All Pages New Pages Recent Pages Bookmarked Pages Unlinked Pages Resources Navigation Tenders 27 Notices 28 le new navigation below E Insert new child navigation Let s for instance create a new child page with a name Career in News and Events So click on News and Events and then click on Insert new child navigation button All Pages H Home New Pages D About Us Recent Pages D Meteorology Bookmarked Pages D Hydrology Unlinked Pages k Resources Navigation 35 Page Regional flood Information System Content Management System A navigation dialog box appears where we are to provide the page information Title Enter the title name of a page to appear Title Career Banner Choose File No file c
74. r or Admin e Enter new user details and save it A newly entered user will be displayed in a user description list Adding Group Click Groups on the left panel Click Add Group Add a new Group of users Name Description Users Hycos Group Add group description Nishant Agrawal FlSudat Tuladhar Ranjan Shrestha V Jayaram Dhakal E Administrator Sazzad z Sandeep Paudel I Mukunda Baidya Save 9802034152 nishant rts com np 9841783167 sudat tuladhar rts com np 9802034150 ranjan wscada com 9841060149 jayaram rts com np 9999999999 admin rts com np 11892312 infombmd aow hel 98 Add a new User DL 17 Type General Username Sazia Mame Sazia Khan Mobile 9801000021 Admin Admin Admin Admin General General Email sazialExyz com Adding a new User Description Save Cancel Enter group name Add description to the group K Select users to be included in this group Click Save button When a group is successfully added it will be listed in a Registered Group l ca Cancel 10 Page Regional flood Information System Data Management System DMS C Data Management System Data Management System DMS is a web based application that provides a Graphical User Interface GUI to manage Stations field devices quality control rules aggregation rules metadata and data 1 Login Log in to DMS with the provided link Da
75. red Procedures 1 proc update latest data CREATE PROCEDURE proc update latest data IN deviceld INT IN categoryld INT IN value DOUBLE IN valueTime DATETIME MODIFIES SQL DATA DETERMINISTIC BEGIN DECLARE prevTime DATETIME DEFAULT NULL DECLARE prevValue DOUBLE DEFAULT NULL DECLARE CUE Latest CURSOR FOR SELECT time value FROM wscada latest data WHERE wscada device id deviceld AND wscada data category id categoryld DECLARE CONTINUE HANDLER FOR NOT FOUND SET no more rows TRUE OPEN Gur latest loop into LOOP FECT Cur latest UNTO previimey prevyValue IF no more rows THEN CLOSE curo latest LEAVE loop into END IF END LOOP loop into IF prevTime IS NULL AND value IS NOT NULL THEN INSERT INTO wscada latest data wscada device id wscada data category id latest value latest time VALUES deviceld category id value valueTime ELSEIF prevTime IS NOT NULL THEN IF prevTime valueTime AND value IS NOT NULL THEN UPDATE wscada latest data SET latest value value latest time valueTime WHERE wscada device id deviceld AND wscada data category id categoryld END LF END IF END 57 Page 1 Regional flood Information System Triggers tgr_station_deleted_date AFTER UPDATE oeste sas AFTERUPONTE a conan tgr_station_deleted_date BEGIN IF NEW deleted timestamp IS NOT NULL THEN DELETE FROM station min WHERE station id NEW id END IF END tgr_station_audit_insert BE
76. ryption AES or else None Time Tab This tab is used to enable time synchronization for the device Reeg Enable Auto Sync Time Add new RTU in Kathmandu e Provide NTP Network Time General Time MIE I ge Protocol time server address Auto Sync Time Enabli p A ds a El Usually time windows com NTP Time Server time windows com es ee This is the location from where the Sync Interval 1 hr ooo device synchronizes its time Time Zone GMT 00 00 EN Select Sync Interval must be Time Zone Device will provide data in the time zone you specified 6 Page Regional flood Information System Data Management System DMS Advance Tab If you enable Auto Firmware Add new RTU in Kathmandu Update it will check for the updates Time Advanced for the software that is running on Auto Firmware Update Enable the device Checking frequency IS Update Check Intevak Ir determined by the Update Check Power Supply Records Enable A Interval and it must be numeric supply Sampling Interval min Supply Logging Interval a gi If you want to record the supply Data Transfer Frequency PowerSaving le voltage enable Power Supply Records save Cancel Provide Supply Sampling Interval and Supply Logging Interval If Power Saving is selected as Data Transfer Frequency then data will be posted in long interval of time whereas data posting is at
77. servation id OLD id DELETE FROM wa observation rule executed WHERE wa observation id OLD Td END IF END 61 Page Regional flood Information System n elen F System Component 99IA9P eyed Aggregation Engine 62 Page Regional flood Information System 1 DMS frontend GWT 2 user interface for Data Management System DMS backend PHP 2 business process insert update delete BULL rts build php operation in DMS framework QC Engine run rules on data Scheduler 4 Aggregation Engine PHP 2 run aggregation rule on data Scheduler Alert Engine Email PHP 2 send email alert Scheduler Flow Chart of DMS DMS is a tool to configure the data management system is the place when we configure station its parameter and define rules on these parameters This tool includes two component the frontend and the backend The frontend user interface is developed in GWT and the backend interface is developed in PHP Front end servers user to insert update and delete the configuration whereas the backend provides the frontend the data required to present to the user Backend is also responsible for saving updating and deleting the configuration as supplied by the user through frontend interface Apart from the configuration this system can be used to view upload and manipulate the data received in DMS 63 Page Flow Chart QC Engine Regional flood Information System
78. ss DMS forget_token token to reset password forgot_timestamp time when user request to reset password table user info contains general user details user group privilege user group id corresponding user group station_id corresponding station privilege can be r read and or c create and or d delete This privilege is applied to the station selected 55 Page Regional flood Information System Alert Email P id BIGINT 20 email queue msq id BIGINT 20 email address VARCHAR 25 Li id BIGINT 20 created date DATETIME 4 A msg TEXT gt send date DATETIME gt subject VARCHAR 1024 P v s All emails generated by the system is stored in this table these email will be processed by Alert Engine on timely basis DB Views 1 vw_global_parameter Lists allthe parameters which has not been deleted 2 vw device station List all the station devices which has not been deleted 3 vw mailing list List all the users on the mailing list d vw observation List processed data points with station name and parameter name D vw raw log List raw data that has not been processed by QC with station and parameter name 6 vw station group List station along with group name 7 vw station network List station along with network name 8 vw station parameter List station parameter 9 vw user group List user along with user group 56 Page Regional flood Information System Sto
79. st added will appear in an External Link box LINKS lee Some useful links WM 39 Page We Click to delete External Link box A mam wm ESE da oy A LI i Regional flood Information System Content Management System Ez V In order to delete any link click on Remove Links from the External Link tool bar vi Select the link you want to delete and Remove Links click OK button Link http wwaw rts com np vii You also have an option to rearrange the link To rearrange the link click on the link you want to rearrange and then click on Move Up or Move Down button to PE from the box that PEA appears Text Link 2 Link http IIA MS o Some useful links i Diet DiGokz Link 2 lt lt lt lt lt Note Make sure to save and publish any changes that you have made in a page f Navigation Navigation enables you to place the navigation on any page position By default itis displayed on the left side of a page To position the navigation on the right side of a page select the area to place it and then click on Navigation for Insert Components Save and publish the page Home AboutUs Meteorology Hydrology Early Warning News and Events Contact Us News and Events Events Only N d Event I News and Events k News Es navigation ke pe placed on bi n the right Events ws side of a Tenders Notices page Motices Career Career g Tagged Lis
80. t Tagged list is for displaying pages that has been tagged same as in the Tagged List For example let s create a section for display news i Select the area to display Tagged List Navigate to Insert Components gt Tagged List Query Add tag to display in Title Add title for Tagged List Description Add description for the tagged lists if any else leave it blank 40 Page Regional flood Information System Content Management System Tagged List Properties x Query news Empty List Replacement Html Add text to replace the empty spaces if there is no Title Latest News add description page to display matching Description with the tag Replace empty list Style Select the ordering style for the list of pages to Empty List Replacement Html display Style Class Select the class color Class for the list of pages to Limit 5 display Sort By Default Sort Order Ascending Limit Limit the number of cia None il lists to display in a tagged list Filter Tolerance Sort By Select the displaying OK order of the list You can display list either by title publication date or by expiry date Sort Order Select the sorting order of lists ascending or descending Date Filter Select how lists will be filtered Filter Tolerance Limit the number of list to display h RSS Feed To add a RSS Feed on a page click and select an area on a page to place an RSS Feed box die Web
81. t and set the Example 53 properties to visible RTS NEws 74 EJ E m D Events 26 Career 60 Station Title Enter the station title Navigation Location Select the navigation location Hydrological Network or Meteorological Network Station Code Select station code from dropdown list Station Type Select station type Hydrology 44 Page Regional flood Information System Content Management System D Home D About Us Meteorology Hydrology Flood Warning 21 All Pages Save and publish the New Pages station that is created by dd Bookmarked Pages clicking on the icons at the Unlinked Pages top Resources gege GLOF 22 Navigation The station that is created AI B104 37 i n th will be placed on the Dorakha 42 station type that was Sumpa 45 Click on edit and set the selected and is invisible properties to visible You will have to change its properties to visible to display it on the site D News and Events 7 Administration 7 1 Change Password To change password for administration click on Administration gt Change password Page Options Administrator Change Password Sign out Enter old password new password confirm password in the Change Password dialog box that appears and click on Change button Change Password d Old Password ee New Password 7 2 Sign out To log off from the DHMS Web Content Editor
82. t area The height of a text area is defined in pixels 43 Page Regional flood Information System Content Management System 6 Adding News and Events News Title ICIMOD connects the Himalayas to the Arctic Home Page Title Date 15 Nov 2013 Author type author name Ex John Doe ICIMOD connects the Himalayas to the Arctic Ex http newscenter lbl gov feature stories 2010 02 03 black carbon himalayan External Link glaciers Content Content Here Title Enter the title of news Home Page Title Enter the title of news to display in Home page External Link Content Enter the URL of news to display if it is from any other resource Add content for news if there is no external link The content field is same as the Web content editor page that is for any normal page Save and publish the news that is created by clicking on the icons at the top All Pages New Pages Recent Pages The news that is created will be placed first in News and Events section and is not visible lts property needs to be changed to visible to display it on the site Unlinked Pages Resources Navigation Station Info Templates Station Info Template Station Title Uzorong Navigation Location Hydrological Network Station Code Hongtsho Station Type Meterology or Meteorology Bookmarked Pages D About Us D Meteorology D Hydrology A News and Events D News 25 Test page 54 Click on edi
83. ta Management System Login Panel Username admin rts com np Password TTT Once authenticated you are directed to following page Data Management System Home Configuration Data Sync J Projects Configuration gt Projects na Networks Groups Q Add Project Delete Project Reload Configuration Data Data Sources Project Name Bl Parameters D S Stations E Users Mailing List 2 Creating Projects Stations Networks and Groups 2 1 Adding Project Click Projets or navigate to Configuration gt gt Projects Data Management System Wscada Ver 20 Configuration Data Sync J Projects Configuration gt Projects ms Networks MO Add Project le Delete Project Reload Configuration Data Groups e emm lt a P Fl Hydrological Cycle Observing System Data Sources Project Name Short Name a Parameters a L Stations E Users E Mailing List C Hydrological Cycle Observing System Hycos 11 Page Regional flood Information System Data Management System DMS s Data Management System Click Add Project H Configurati Data S e E apo Project Name Enter your J Projects Configuration gt Projects I ES project name List Projects G Reload Configuration Data croups e pata Sources Ada Project Short Name Enter a short Bip t kane a ai Project Name Hydrological Cycle Observation System name or a
84. te DATE 2 parameter INT 11 end date DATE IT WA O l ll l 2user_id INT 11 parameter VARCHAR 10 parameter VARCHAR 10 severity INT 11 O user qroup_kis VARCHAR 1024 deleted_timestamp TIMESTAMP Po Fi gt mailing bei ids VARCHAR 1024 Pid INT 11 gt subject VARCHAR 1024 scope_id INT 11 A msg TEXT ri 2 deleted timestamp TIMESTAMP alert_frequency MII 1 Q user id INT 11 gt data interval INT 11 gt data interval type VARCHARI25 date fime oder VARCHAR 25 gt indude_suspicious VARCHAR 25 Y id INT 11 scope id INT 11 ge O deleted_timestamp TIMESTAMP month_select VARCHAR 13 kleeder gege gt user_id INT 11 nie Bwe sen INT 1 rule_tailure severity INT 11 sync INT 1 deleted timestamp DATETIME All rules defined will be stored in table wa rule Following are the attributes and its use sync_out_unique_id auto generated 16 character length unique id Generated when rule is created This id will be used while synchronization of the rule in multiple domain 1 sync change detected set to 1 when user update the rule definition So that the system Knows to sync the changes to other domain if the rule has been synchronized 2 order rule execution order 3 rule of to whom this rule belongs to parameter network group station parameter 49 Page Regional flood Information System 4 station_parameter_id this field
85. ule execution is seized Severity Step Check checks if two consecutive values received for a parameter from a station do not deviate much To perform the step check the system requires two 27 Page 8 3 Regional flood Information System Data Management System DMS parameter values values that we received value that needs to be checked and the previous value value that has already been checked and stored If the difference between these two values is greater than the increment you provided the value will be flagged as the severity you select Severity NONE denotes there is no error in the value Severity ERROR denotes error in the value and this value will not be visible in public domain If SUSPICIOUS is selected this value is flagged as suspicious but will still be visible in public domain Execution Order Indicates priority of rule execution if more than one rule is applied to a parameter 0 means higher priority larger the numbers lower the priority Select Alert Group Generates an alert email whenever the rule applied to a parameter fails Provide subject and message to generate as alert Alert Frequency Indicates time for generation of next alert It must be a numeric value Click Save Parameter Rule to apply the set rule to the parameter Adding CONSTANT CHECK to a parameter Let s take an example where temperature cannot be same for a period of time 15 temperature is same A from Ato B
86. unication Acquisition Script Source Domain received Remarks Save Add Communication Means Communication Manual Sms iii If Manual SMS is selected then provide the Sender Name Sender Name Remarks Add Communication Means iv If Manual Form Entry is selected Communication Manual Form Entry EN then provide Feeder Name who is responsible for entering data to the system Feeder Name Remarks Adding Parameter Select Station for which you want to add a parameter D f s Parameters Click on Data Management System lt Ws5cada Ver 2 0 Home Configuration Data Sync Projects Configuration gt Stations ina Networks Q Add Station List Stations Reload Configuration Data a Groups Data Sources Station Information Run Rule Manually Mi Parameters StartDate 2013 06 23 06 JE Parameters Be Sensors s Lo s a S stations 2 af Les A s 0g Y Hongtsho 8201 S StationDevice RTDL 11 8206 Y List Aggregation W Devices Communication 4 Sumpa 8203 Y Korilla 8202 Pl Add Station Parameter Parameter Name Unit Interval Parent nn Parameter SELECT gt Gunitsawa 820 Station O JN Rules Waterlevel m 15minutes parameter Hame Short Name m e x Rules Device Supply Voltage C 30 minutes F 4 Rules Additional Supply Voltage 2 C 60 minutes Description m 8 4 Rules Modeml1 CSQ 30
87. ute offset to add subtract to hour example lets suppose the date is 2013 01 01 00 00 00 12 is the offset then it will aggregate data from 2013 01 01 00 12 2013 01 01 1 11 2013 01 01 1 12 2013 01 01 2 12 and so on 12 is the offset then it will aggregate data from 2012 12 31 23 48 2013 01 01 00 47 2013 01 01 00 48 2013 01 01 1 47 and so on e table value NOT SET NOT REQUIRED e week start day NOT SET NOT REQUIRED If aggregation type is daily monthly yearly e time offset hour minute offset to add subtract to hour e table value NOT SET NOT REQUIRED e week start day NOT SET NOT REQUIRED If aggregation type is weekly e time offset hour minute offset to add subtract to hour e table value NOT SET NOT REQUIRED e week start day range from 0 6 Sunday Saturday If aggregation type is table e time offset NOT SET NOT REQUIRED e table value comma separated key value pair eg 10 20 20 30 30 40 e week start day NOT SET NOT REQUIRED 52 Page Regional flood Information System Data Storage gt nila type VARCHAR 128 b raw lq id BIGINT 20 gt wa_rule_id INT 11 2 severity INT 11 rule failure NI w processing start time TIMESTAMP processing end time TIMESTAMP gt status VARCHAR 50 gt obs time DATETIME obs_value DOUBLE device code VARCHAR 25 parameter_code VARCHAR 25 pass q INT 1 pass aggregation INT 1 gt data source id INT 11
88. ving higher priority High will post data to server first If the higher priority modem could not send data next priority Medium modem tries posting data Logging If Enabled data logger logs modem status parameters like CSQ signal strength modem error Iridium Tab Iridium Modem can be operated in four different modes e Disabled Device does not use Iridium to post data e Regular Modem Sets Iridium to post regular data as general modems CDAM 8 GSM kuda EE E e Special Log Iridium posts minimum Iridium maximum and average of each Mode parameter once in a day e Alarm Only Sends data whenever an Se ses alarm condition is triggered Communication parameters for RTU Kathmandu Click Save to save these communication settings as configured Adding alert Alerts can be incorporated into the system for parameters to generate alarm for any alarming condition For example setting warning and danger levels for water level to generate alert for flooding situation To setup alert click Add Alert 2 Add a alert in RTU Kathmandu I e Select parameter for which alarm is to be Parameter Waterlevel kel Type SMS al eet Tes s Select alert type ita Buesa al o SMS Alert is sent through SMS to all Upper Threshold 7 the users defined in Group Upper Hysteresis o Iridium Alert is sent via Iridium to Alarm on lower limit Enabled kel server To use iridium iridium modem Lower T

User Manual RFIS

Contents

Download Pdf Manuals

Related Search

Related Contents