CWC Flood Forecast - India

From ICTD Asia Wiki
Jump to: navigation, search

About


Source(s): CWC Flood Forecast


Live Site


Source(s): CWC Flood Forecast


Objectives

  • Save the details of each Forecasting Site. (Done. Collecting data since September 1 2010)
  • Archive daily updates of each Flood Forecasting Site (FFS).
  • Archive daily Flood Alerts issued by CWC.
  • Allow interested parties to access the data using API/Feeds/Email.
  • Data visualisation on a Map.
  • Convert the daily Flood Alerts into CAP format.


Source(s): CWC Flood Forecast


List of Tasks (Pending/Completed)

  • Done Current code retrieves data from the source site from September 1, 2010. (Crawl schedule: 10 AM, 12 PM, 4 PM, 7 PM)
  • Done Need to test it and setup cron.
  • Ongoing Testing the code logic for possible flaws.
  • Publish data online with Site Wise/Date Wise search.
  • Sending alerts by email to subscribers.
  • Convert Information to Action: Prepare a list of field based agencies working on Flood Prone areas who could use this information.
  • API
  • Find GeoLocation information for each FFS ID.
  • Publishing Feeds on Twitter/Identica/FB
  • User Interface with Feeds on a map?
  • Prepare a CAP template for daily flood alerts.


Source(s): CWC Flood Forecast


Skills required to help

Currently the code is written in Python 2.4, hosted on CentOS 5, with PostgreSQL 8.1.21, SQLAlchemy.

  • HTML/CSS/JS
  • OpenLayers
  • Graphics Designing
  • Python
  • BeautifulSoup
  • XML/RSS


Source(s): CWC Flood Forecast


For Developers


Source(s): CWC Flood Forecast


Understanding Data Source


Source(s): CWC Flood Forecast


Flood Alert

Steps to see the Daily Flood Alerts issued by CWC

  • Go to this site - http://www.india-water.com/ffs/Reports/RptCurrent.asp
  • Click on any of the one's that are listed to be directed to the site's status page.
  • Alerts issued in two sections based on the type of FFS. Level/Inflow Forecasting Site.
  • Types of Flood Alerts on the status page:
    • No Flood Alerts(or no PWL data available) - No Flood Alert Issued.png
    • Level Forecasting Site:
      • Single Forecast: Flood Alert Issued Daily.png
    • Inflow Forecasting Site:
      • Single Forecast: Flood Alert Issued Daily Inflow I.png
      • Double Forecast: Flood Alert Issued Daily Inflow II.png
      • Cumecs -> [1]
  • Alert contains the following: (Also see structure of Table *site_forecasts* below)
    • Flood Forecast Number
    • Next day's Date/Time when the values are expected to reach the levels.
    • Value - Expected level of water tomorrow.
    • Trend - of the water level.
    • Forecast Legend - Low/High/Medium Level of Flood alert issued.
    • Page updated - when the information on this page was updated.
  • Proposed CAP Message Template for the alert
    • Alert should have site info as well? Like name


Source(s): CWC Flood Forecast


Proposed Design

  • Suggested Markers/Categories: (i.e. information representation using “Keywords” concept or “tags”
    • Flood Alert Type: “Moderate/Low/High”
    • Water Level: “Steady/Rising/Falling”
    • Forecasting Site Type: Level/Inflow
    • Date: “Today/Yesterday/Everything before yesterday”
    • Water Level (Numeric Comparison) - Current: “Over Warning Level/Below WL/Over Danger Level/Below DL”
    • Each Flood Forecasting Site is a “Location” so a “Site” icon for them. Its a site which has measuring equipment manned by a person. So an office’s icon?
  • UI/Mockups
    • Draft I by kamalx -

Mock Up I

  • I like it. Simple and nice :) I'd just remove ICTD ASIA INDIA chapter from the heading and have it in the footer somewhere. It should have the project name like "Flood Alert Portal - India" or India Flood Alert Portal instead. --Ajuonline 16:17, 25 August 2010 (UTC)


Source(s): CWC Flood Forecast


Proposed Data Model

  • Table: site_profile - Structure: Site profile.png
  • Table: site_forecasts - Structure: Site forecasts.png
  • Table: site_updates - Structure: Site updates.png


Source(s): CWC Flood Forecast


API

Table Database API
Profile site_profile Update row when data change (HFL?). profile/id -> json string with data from site_profile
Updates site_updates Add a row if a row with (site_id, somedate?)
  • updates/id -> latest update
  • updates/id/date -> latest update whose date < date
  • updates/id/date1/date2 -> all updates whose dates lie between date1 and date2
Alerts site_alerts Add a row each time the forecast number changes?


Note: The API will provide a dictionary of id->location pairs somewhere. Which the developer will fetch each time. We'll use a Last-Modified header so we won't be wasting bandwidth.


Source(s): CWC Flood Forecast


Contributors


Source(s): CWC Flood Forecast


Acknowledgements


Source(s): CWC Flood Forecast