Wiki code for State Water Resources Control Board

Hide Line numbers

1: 1 State Water Resources Control Board
2: 
3: 1.1.1 Introduction
4: The goal of this space is to show how a water-related agency can link its database to CalSWIM and make it public using CalSWIM’s wiki features. The data is out-dated and are provided by "State Water Resources Control Board". The data is hosted on another server and is registered in CalSWIM under nickname [TrungDB>Database.Trung Database].
5: 
6: 1.1.1 Sampling Stations
7: The following map shows location of sampling stations. You can zoom the map for better views. In addition, by clicking on each of the stations you would see its name.
8: <div align="center">
9: #mapFromDB("TrungDB", "Select Name, Latitude, Longitude FROM Station")
10: </div>
11: 
12: \\
13: \\
14: \\
15: The following is the list of the *first 30* stations. By clicking on each of them you would be redirected to the details page of that station:
16: 
17: <div align="center">
18: #set($codes = $xwiki.DBPlugin.getArrayListFromQuery("TrungDB", "SELECT Distinct(Code) FROM Station Limit 0, 30"))
19: 
20: {table}
21: Name | Code
22: #foreach($code in $codes)
23: #set($name = $xwiki.DBPlugin.getStringValue("TrungDB", "SELECT Name From Station WHERE Code = ’$code’"))
24: [$name > Station?code=$code] | $code
25: #end
26: {table}
27: </div>

State Water Resources Control Board

Top Menu

Wiki code for State Water Resources Control Board

Search

Quick Links