The LifeUnderYourFeet Archive (LUYF) provides access to the data from
the wireless sensor network (WSN) collected by our group at JHU. The LUYF
uses a Microsoft SQL Server database to store and serve the data. Users
can access this data by a number of methods.
The concept and the tools of this archive have been derived from its
astronomy equivalent, the SDSS SkyServer.
The LUYF Archive provides a variety of
methods to retrieve data:
-
SQL web form.
Users can enter Structured Query Language (SQL) queries in a form,
and the query will be executed. The query is limited in duration to
5 minutes, or 10,000 rows. This query type allows selection of various
columns, and the application of complex constraints. Users new to SQL
will want to read our SQL help and the
description of the data model and the
parameters stored in the various tables.
-
In addition, the archive provides a tool called the
Schema Browser, with
which users can browse the various tables, views, and
functions available for SQL queries, as well as the different
columns available in each. All of the archive interfaces allow
data to be returned in HTML, XML, or CSV (comma separated variable)
format.
-
In addition to these database access tools, we have developed some simple
visual interfaces to retrieve our data in various graphic forms.
|