Web interface for data search and download from CUAHSI Hydrology Information System (HIS).

1. CUAHSI Conference on Hydrologic Data and Information Systems June 22-24, 2011Utah State University, Logan Utah Web interface for data search and download from CUAHSI Hydrology Information System (HIS). Enterprise IT solutions generally have a major emphasis on the enterprise-wide geospatial information systems and internet in general and web in particular is its significant constituent. Geospatial tools are becoming smarter and concise front-end source for vast amount of operational data resting on the back-servers. With advent of Google maps, Bing maps and OpenLayers maps, web-mapping is surely becoming a dominant and preferred tool for creating browser-based graphical user interfaces thus enabling organizations or users collect, process and analyze data with ease. Consortium of Universities for the Advancement of Hydrologic Science, Inc. (CUAHSI) HIS consists of large sets of real-time and legacy time-series hydrology data built on complex hierarchies of keywords, nested in multiple servers at multiple locations and accessible through webservices. The paradigm shift in creating the graphical user interface (GUI) for accessing this data from desktop-installable software driven interface to the Silverlight-Bing map driven browser-based interface will enable user to access the data at any place and at any time. The Silverlight driven web interface technology will bring this large amount of information to the browser based tables or grid for easy downloading and analysis. A prototype website (http://www.hydroweb.info) has been developed for searching data from HIS and making it available in the data-grids nested in the web browsers. The web-driven GUI using various web technologies like Silverlight, PHP, Bing Maps and XML can facilitate easy management and analysis of time-series and point observation data of HIS with geospatial perspective. Dinesh Grover Dr. Daniel Ames 1Consortium of Universities for the Advancement of Hydrologic Science, Inc.

2. Positioning Statement • Frame of Reference For (target audience), (westerconsortium.org/his/ or HydroWeb.info) is the (frame of reference) that delivers (benefit/point of difference) because only (westerconsortium.org/his/ or HydroWeb.info) is reason to believe). 2 Key Components of CUAHSI-HIS 3 2Positioning Statement Format courtesy website http://www.brandeo.com/positioning%20statement 3 HIS triangle image courtesy website http://his.cuahsi.org

3. The development of the idea (Search Module). Data discovery search and download of time-series data

4. Positioning of Search Module in HydroDesktop

5. Functional Specifications outline for HydroDesktop New Search Module Search Parameters Search Results Search Validation Search Summary (XML)

6. Technical specification outline for new Search control Interface

7. Functional outline for creating web-based HIS data search/download module: Westernconsortium.org/hisor Hydroweb.info

8. Functional Specification Outline for Westernconsortium.org/hisor Hydroweb.info

9. Technical Specification Outline for Westernconsortium.org/hisor Hydroweb.info

10. WebclientHttpRequest Formation… <?xml version="1.0" encoding="utf-8"?> <access-policy> <cross-domain-access> <policy> <allow-from http-request-headers="*"> <domain uri="*"/> </allow-from> <grant-to> <resource path="/" include-subpaths="true"/> </grant-to> </policy> </cross-domain-access> </access-policy>

11. PHP 5.0: conduit sitting on web-server… <?php header("Content-type: text/xml\n\n"); $query = $_SERVER['QUERY_STRING']; $catalogsite = "http://hiscentral.cuahsi.org/webservices/hiscentral.asmx/ GetSeriesCatalogForBox2?"; $url = $catalogsite . $query; $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_HEADER, false); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); $xml = curl_exec($curl); curl_close($curl); echo($xml); ?>

12. Challenges for all Role-players….

13. Westernconsortium.org/hisor Hydroweb.info : Build the Search

14. Westernconsortium.org/hisor Hydroweb.info : Download the time-series data

15. Westernconsortium.org/hisor Hydroweb.info : Check the data in Tables

16. Westernconsortium.org/hisor Hydroweb.info : Check the data in Graph (Line-series)

17. Westernconsortium.org/hisor Hydroweb.info : Live Demo http://www.westernconsortium.org/his/

18. Definitions GeoRSS-Simple is meant as a very lightweight format that developers and users can quickly and easily add to their existing feeds with little effort. It supports basic geometries (point, line, box, polygon) and covers the typical use cases when encoding locations. GeoRSS GML is a formal GML Application Profile, and supports a greater range of features, notably coordinate reference systems other than WGS-84 latitude/longitude • GeoRSS-Simple • <georss:point>45.256 -71.92</georss:point> • GeoRSS-GML • <georss:where> • <gml:Point> • <gml:pos>45.256 -71.92</gml:pos> • </gml:Point> • </georss:where> KML is a file format used to display geographic data in an earth browser, such as Google Earth, Google Maps, and Google Maps for mobile. A KML file is processed in much the same way that HTML (and XML) files are processed by web browsers. Like HTML, KML has a tag-based structure with names and attributes used for specific display purposes. Thus, Google Earth and Maps act as browsers for KML files. You can use KML to: •Specify icons and labels to identify locations on the planet surface •Create different camera positions to define unique views for each of your features •Use image overlays attached to the ground or screen •Define styles to specify feature appearance •Write HTML descriptions of features, including hyperlinks and embedded images •Use folders for hierarchical grouping of features •Dynamically fetch and update KML files from remote or local network locations •Fetch KML data based on changes in the 3D viewer •Display COLLADA textured 3D objects <?xml version="1.0" encoding="UTF-8"?> <kmlxmlns="http://earth.google.com/kml/2.2"> <Placemark> <name>Stonehenge, England</name> <description>Stonehenge was built about 2500BC </description> <Point> <coordinates>-1.826752,51.179045 </coordinates> </Point> </Placemark> </kml> Silverlight is a powerful development platform for creating rich media applications and business applications for the Web, desktop, and mobile devices. Silverlight is a free plug-in powered by the .NET framework that is compatible across multiple browsers, devices and operating systems to bring a new level of interactivity wherever the Web works. With support for advanced data integration, multithreading, HD video using IIS Smooth Streaming, and built in content protection, Silverlight enables online and offline applications for a broad range of business and consumer scenarios.

19. References • Ames, D. P., Horsburgh, J., Goodall, J., Whiteaker, T., Tarboton, D., Maidment, D. (2009). "Introducing the Open Source CUAHSI Hydrologic Information System Desktop Application (HIS Desktop)": AMES_MODSIM_HIS_Desktop.pdf. 18th World IMACS/MODSIM Congress, Cairns, Australia 13-17 July 2009. http://mssanz.org.au/modsim09 • Horsburgh, J. S., D. G. Tarboton, K. A. T. Schreuders, D. R. Maidment, I. Zaslavsky, and D. Valentine (2010), HydroServer: A platform for publishing space-time hydrologic datasets, in Proceedings of the AWRA Spring Specialty Conference on GIS and Water Resources, Orlando, FL, March 29 – 31. http://jeffh.usu.edu/files/JSH_AWRA_GISWR_2010.pdf • Horsburgh, J. S., D. G. Tarboton, M. Piasecki, D. R. Maidment, I. Zaslavsky, D. Valentine, and T. Whitenack (2009), An integrated system for publishing environmental observations data, Environmental Modeling and Software, 24, 879-888, http://dx.doi.org/10.1016/j.envsoft.2009.01.002. • Oliver Arafat (Siemens AG), Dirk Riehle (SAP Labs), The Commenting Practice of Open Source, http://dirkriehle.com/wp-content/uploads/2009/08/oni0017-arafat.pdf • MSDN Microsoft, DataGridView Class (System.Windows.Forms) .Net Framework4, http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx The link represents web-page validity as on 29-Nov-2010 Web References as on 3/22/2011 • http://msdn.microsoft.com/en-us/library/cc221403(v=vs.95).aspx How to: Use a Background Worker • http://forums.silverlight.net/forums/p/204505/478696.aspx Easy Dynamic Data Binding to a Silverlight 4 Datagrid • http://bea.stollnitz.com/blog/?p=344 Data Virtualization in Silverlight and WPF • http://blogs.msdn.com/b/silverlight_sdk/archive/2008/04/01/using-webclient-and-httpwebrequest.aspx Using Webclient and HttpWebRequest • http://msdn.microsoft.com/en-us/library/cc197947(v=vs.95).aspx Accessing HTTP and REST-Based Services Directly • http://msdn.microsoft.com/en-us/library/cc879136.aspx Developing a Silverlight Application Using Bing Maps SOAP Services • http://rbrundritt.wordpress.com/2010/05/02/custom-pushpins-in-bing-maps-silverlight/ Custom Pushpins in Bing Maps Silverlight • http://www.silverlightshow.net/items/Consuming-ASMX-Web-Services-with-Silverlight-2.aspx Consuming ASMX Web Services with Silverlight • http://articles.sitepoint.com/article/php-silverlight A Beginner’s Guide to Silverlight with PHP By Jordan Knight • http://www.davidezordan.net/blog/?p=1231 Using Silverlight to consume a simple php service with WebClient