The "Alpha" version of the spatial query system for the Catalog of Florida Monitoring Programs is now available for review. The system was created using ArcGIS Viewer for Flex, an open source, configurable web mapping application. It supports both tabular and spatial search of the available metadata.

The system may be accessed at this URL: http://water-cat.usf.edu/map/

System Requirements

A web browser with Adobe Flash Player 11.1 or higher is required to view this mapping application. Install Flash Player from Adobe (free download).

The spatial viewer will be updated with newer versions throughout the Alpha testing lifecycle. Each new version will include enhanced functionality, bug fixes and overall performance improvements. The table below records each significant version update, noting the date and improvements that were made within each. The current version number of the viewer can be found within the top bar of the application (e.g. "version 0.8.5")

Version Date Details
0.8.5 21 May 2015 Active and Inferred Active stations are now filtered out in the main searchable stations dataset. These stations are classified as those that have monitoring activity within the previous 4 years. A secondary layer consisting of all stations (active and inactive) is available to view in the layer list and is searchable within the Advanced Search Tool options.
0.8.4 27 March 2014 Florida Department of Environmental Protection WBID and WBID Name added as searchable fields for the monitoring locations. "View Full Details" link now available in pop-up when you identify individual monitoring points.
0.8.3 17 February 2014 Florida Department of Environmental Protection WBIDS (Run 47) added to the mapping application and available as a spatially searchable layer. "View Full Details" link now available in the datagrid results for a sample site which redirects users to a page containing a complete set of sample site information. Informational popups now available for NHD features when clicked on. Bing Maps added to available basemap options.
0.8.2 13 December 2013 National Hydrography Dataset added to mapping application and is available as a queryable layer. New Basic and Advanced searching options introduced.
0.8.1 05 December 2013 Station Name added to list of queryable fields.
0.8 19 November 2013 Initial Alpha mapping application launched

Basic Functions & Tools

toolbar image    

The map viewer supports functions common to interactive maps, including:

  • Zoom In/Out – Changes the map extent to decrease/increase the scale (show less/more area).

  • Pan – Changes the area of the map that is visible on the screen, without changing the scale.

The toolbar (shown at left) may be used to change the extent of the map.

Viewing Station Information

Initially a map of the entire state of Florida is displayed, with no station icons visible. Once the user "zooms in" to a particular area, small yellow dots will appear, each representing the location of one or more monitoring stations:

Clicking on one of these will display basic information in a popup window, including a link to a page with complete metadata for the station. If there are multiple stations at the same location, the popup window will allow the user to step through the metadata for all stations by clicking on the Full Site Details link. Example:

Search Overview

 To access the search menu, click on the "binoculars" icon.

The system allows users to search for stations based on their attributes. It highlights selected stations by showing them as red dots. Where there is more than one station at a point, the dot will be darker red. Basic information about the selected stations will appear in the search results pane on the search menu and, if tabular display of search results is enabled, a table at the bottom of the screen will show more detailed metadata about selected stations.

 Click the icons at the top of the search menu to switch between spatial search, tabular search, and search results.

Spatial searches use graphical map tools to select stations within one or more geographic areas. Tabular searches select stations by searching the contents of the database. To clear the results of all previous searches, click the "Clear" link. To change the extent of the map to so that it includes just the area around the selected stations, click the "Zoom" link.

The results of successive searches of both types may be combined. By using the dropdown in the search menu, successive search results may be combined in an additive or subtractive manner, by adding to or removing from the current selection.

Spatial Searches

A point, line, rectangle, or irregular polygon may be specified by the user to select those stations that fall within a geographic area of interest.

To select a single point, click on the point tool and then click once on the map. Select the checkbox provided if you would like to expand the search area to include a fixed, six-pixel search tolerance around the point.

To select a line, click on the line tool and then click once on the map for each point along the line. For the last point on the line, double-click.

To select a rectangle, click on the rectangle tool and then click and drag on the map.

To select a polygon, click on the polygon tool and then click once for each vertex on the polygon except the last, for which you should double-click. Note: the polygon’s sides may not intersect one other.

You can expand the search area around a line, rectangle, or polygon by selecting the "Buffer Graphic" checkbox and then selecting an expansion amount and units.

Tabular Searches

Two simple searches are provided in the drop-down menu. The Water Resource Name search will find stations assigned to any water body whose name contains the character string provided; it is not case sensitive. The Sampling Date Range search requires both a beginning and ending date, and will return a list of stations whose period of record overlaps the date range specified. Dates should be specified in the form MM/DD/YYYY or YYYY.

To search any other metadata field, or a combination of fields, select "Search All Fields" from the dropdown menu and choose values for those fields of interest. Those stations that satisfy ALL of the search conditions will be selected, equivalent to a boolean "AND" search. To perform a boolean "OR" search, use the "Add to current selection" option to combine the results of multiple successive searches. Similarly, the "Remove from current selection" option may be used to effect an "AND NOT" search.

Note that specifying starting and ending dates in the Search All Fields menu will give different results than specifying dates to the Sampling Date Range menu. The former will return those stations whose period of record falls entirely within, and only within the range specified, while the latter uses more complex logic to return all those stations whose period of record overlaps the specified date range, even if some of the dates in the period of record fall outside that range.

The database has been constructed to include all Station Metadata Element fields specified in the current release of the CFMP requirements document. The "Search All Fields" drop-down menu lists those fields that are most likely to be searched. The "Open SQL" option allows the user to search any field, or combination of fields, in the database by constructing a query string in the Transact-SQL (T-SQL) computer language. The field names are below. Those with an * are searchable using the "Search All Fields" option. For details on definitions, data types, and domains for Metadata Elements, please refer to the Functional Requirements Document for the Monitoring Catalog.

Field Name Data Type Description
ORG_ID*StringInternally generated; primary key field for Organization data type
ORG_NAME*StringOrganization overseeing monitoring project collecting information at the station.
STATION_NAME*StringFull name of the site or station.
STATION_ID*StringCode or identifier used as the station identifier within the data provider's internal database.
STATION_DESCRIPTIONStringDescription of the site of station; associated address or parcel number may be entered here.
LATITUDEDoubleThe decimal degree latitude of the station.
LONGITUDEDoubleThe decimal degree longitude of the station.
PROXIMITY_TO_SAMPLING_ACTIVITYStringIndicates how close the latitude/longitude are to point of actual sampling activity.
XY_DATUMStringHorizontal reference for measuring locations on the earth's surface.
Z_DATUMStringVertical reference for measuring locations on the Earth's surface.
LOCATION_COLLECTION_METHODStringMethod/mechanism for deriving location measurements.
COUNTY*StringName of the Florida county in which the station is located.
DRAINAGE_BASIN*StringThe 8-digit USGS Hydrologic Unit Code (HUC) where the station is located.
WATER_RESOURCE_NAME*StringThe name of the waterbody that the station is located in. For groundwater, name of aquifer.
STATION_TYPE*StringType of station that data collection occurs at/in. (Atmosphere, bay, facility, spring, etc.)
START_DATE*DateDate monitoring activity started at the station.
END_DATE*DateDate monitoring activity ended, or is anticipated to end, at the station. For ongoing monitoring, "Active".
SAMPLING_FREQUENCYStringTime interval between sampling events.
PARAMETERS*StringParameters/variables/information collected at the station, including STORET/WQX names when possible.
DATA_URLStringInternet address for web page or FTP site where station data may be obtained.
DATA_SOURCE_NAMEStringName of data source/providers of data, whether within or outside the organization conducting monitoring at the station.
CONTACT_NAMEStringName of contact person affiliated with the data source.
CONTACT_ADDRESSStringMailing address of contact person affiliated with the data source.
CONTACT_PHONEStringTelephone number of contact person affiliated with the data source.
CONTACT_EMAILStringEmail address of contact person affiliated with the data source.
TOTAL_DEPTH DoubleTotal depth, in feet. (For wells only)
CASING_DEPTH DoubleDepth, in feet, of the well casing. (For wells only)
MATRIXStringMatrix/material from which the sample is taken: Water, Sediment, Air, Rock, Soil, Hardbottom, Other
KEYWORDSStringAdditional information to further characterize monitoring effort, including but not limited to 'abundance', 'distribution', 'growth', etc.

Open SQL Search

The greatest search flexibility can be achieved by performing an advanced search using the Open SQL search capability. The condition specified should follow the syntax for the search target portion of the SQL "WHERE" clause, in the form field_name operator value.

Details:

  • The search target is not case sensitive.
  • Field names may include any of the Catalog Metadata Elements.
  • Single quotes, not double quotes, should be used to surround text values.
  • An underscore ("_") may be used as a wild card for single characters, and a percent sign ("%") for multiple characters.
  • Dates should be specified as text strings in the form MM/DD/YYYY (for a specific date) or YYYY if only the year is of interest. Leading zeroes may be omitted when specifying month or day, but not year. Wild card characters may not be used in dates.
  • Parentheses may be used to construct complex query strings, as well as the logical operators AND and OR.
  • The PARAMETERS field contains a character string listing the parameters/variables/information collected at the station. The best way to search it is using the "LIKE" operator. See example query strings below.
SQL Operators
= Equal
<> or != Not equal
> Greater than
< Less than
>= Greater than or equal to
<= Less thanor equal to
BETWEEN Within a range. For dates, the ending date is not included. Date format is a text string with the format MM/DD/YYYY or YYYY.
LIKE Search for a pattern (best to use wild cards)
IN To specify multiple possible values for a column. (List possible values, separated by commas and surrounded by parentheses. Wild card characters are not allowed.)

Examples:

  • COUNTY='FLAGLER' AND START_DATE>'1970'
  • (COUNTY='HILLSBOROUGH' OR COUNTY='PASCO') AND (STATION_TYPE='LAKE')
  • PARAMETERS LIKE '%CHROMIUM%'
  • (COUNTY IN ('LEON', 'WAKULLA', 'GADSDEN')) AND (ORG_NAME='FLORIDA LAKEWATCH')
  • (PARAMETERS LIKE '%OXYGEN%' OR PARAMETERS LIKE '%BOD%') AND (COUNTY='LEE') AND (START_DATE>'1990') AND (END_DATE<'2000')

For more information about the SQL WHERE clause, refer to http://www.w3schools.com/sql/sql_where.asp

Combined Tabular/Spatial Search

A tabular search of a limited geographic area may be performed by doing the following:

  1. Specifying tabular search parameters in the spatial search menu for one or more fields, either by making choices from the drop-down menus provided, or by entering a SQL query string.
  2. Checking the "Include text query in selection criteria" box on the spatial search menu.
  3. Using the graphical search tools to select the geographic area of interest.

Example: Select monitoring sites in the Panhandle with data between 2006 and 2009.

  1. On the Tabular Search menu, select Search by Sampling Date Range and enter the dates 1/1/2006 and 1/1/2010.
  2. On the Spatial Search menu, check the "Include text query in selection criteria" box. Select the Rectangle tool and draw a box around the Panhandle.

View Search Results

When information about a single monitoring location is desired, its may be viewed by clicking on the site's icon to open a popup with summary information, then clicking on the "View Details" link to open the station’s metadata page. If there is more than one station at the same location, this will be indicated in the popup. Click the arrow to page through summary data for each station.

When one or more stations have been selected via a spatial/tabular search, their information will be available both in the Advanced Search Tool's results window and in the Search Results table at the bottom of the screen. The information in the Advanced Search Tool window is a very brief summary, while the table is more detailed. The two displays track each other and the map: when the cursor is hovered over a station in one display, information about the same station is highlighted in the other display as well, and a popup for that station appears in the map. (Note that while clicking on a station on the map opens a window with its information, it does not cause corresponding data to be highlighted in either of the search results displays.) The metadata in the Search Results table is a subset of the full metadata record, which can be accessed by clicking the "View Full Details" link.

Exporting Metadata

The metadata fields shown in the Search Results table may be exported to a text file (.TXT) or to a comma separated values (.CSV) file. Fields in the text file will be surrounded by double quotes (") and separated by tab characters. Fields in the comma-delimited file will be surrounded by double quotes and separated by commas. Use the radio button to select the desired format, then click the Export… button and select a folder and filename where you wish to save the file.