Help
 Introduction
 Schema Browser
 Intro to SQL
 How To
 Web Browsers
Archive Intro

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.