The API Briefing: The Fun Finder – The Recreation Information Database

Nov 12, 2014

Back in 2000, I worked at a dot-com building website applications such as a real-time stock ticker ribbon and a real estate listings search engine. One of my favorite applications was an app for mobile phones. At that time, I used the Wireless Access Protocol (WAP), which displayed information using a special version of XHTML. Using the Kentucky Golf.com database, a user could search for information on a specific golf course by entering a ZIP code or using drop-down lists to search by county or course name. The major challenge was creating a speedy user-friendly app that could quickly search the big database and return the relevant data.

Fourteen years later, creating a speedy user-friendly app that can quickly search and retrieve information from a massive database is still a major concern of app developers. This is the challenge facing developers who may want to create an app from the Recreation Information Database (RID). RID is a one-stop database that aggregates information on recreational activities offered by federal lands, historic sites, museums, and similar facilities. You can sample the data provided by using the online search interface.

Recreation Information Database results for Puerto Rico

Developers can access the same data using a Web service Uniform Resource Locator (URL). In this example, select “Department of Agriculture” as the organization and click “Go.” A list of URLs will appear. Click on any of these and be prepared to wait. Once the query has been completed, you will see a listing of facilities along with a link to an XML file and a JSON file. The data consists of the recreation area’s name, location, email, phone, and recreational activities (see the manual for specifics).

So, how can an app developer best use RID to build an app (or apps)? One strategy is to download all of the data through the API into a database. Segment the data into several parts by organization, recreational facilities, geography, and so on. Then, use a series of successive selections to search only the most relevant section of the database. An app can also do an automated search using the geographical positioning system (GPS) function of the smartphone. There is an amazing amount of useful data in RID, which only needs a smart and responsive user interface to realize RID’s value fully.*API – Application Programming Interface. How software programs and databases share data and functions with each other. Check out APIs in Government for more information. Each week in “The API Briefing,” I will showcase government APIs and the latest API news and trends. Visit this blog every week to learn how government APIs are transforming government and improving government services for the American people. If you have ideas for a topic or have questions about APIs, please contact me via email.

Dr. William A. Brantley, is the HRIS Branch Chief in the USDA’s Rural Development Human Resources Office. You can find out more about his work in this space at BillBrantley.com. All opinions are his own and do not reflect the opinions of the USDA and GSA.