Sunday, December 9, 2012

Earthquake list for the past 7 days

(Quick Note: direct link to this data:
http://flatmerge.com/Data/Details/8ef2ad73-660a-4228-bb8f-eedeae821c1c,
or another interesting set of data about Farmers Markets:
http://flatmerge.com/Data/Details/31974ef9-5a62-420d-a6c3-945b3ab8e6d4)


For the first FlatMerge post, we've shared some data with you about earthquakes. From data.gov:
https://explore.data.gov/Geography-and-Environment/Worldwide-M1-Earthquakes-Past-7-Days/7tag-iwnu

Since this is the first data loaded into FlatMerge by anyone, this post is also a how-to for getting started with FlatMerge.

Upload

http://flatmerge.com/Data/Upload
Uploading your data is simple. The file source (currently supported) is a comma-delimited text file with column names in the first row.


FlatMerge ingests the file then sends you to your data list page. Your new data's status will say "Analyzing" while FlatMerge detects the exact data types and width's of each column.

Refresh the data index page until your data status is "Complete".  The number of rows and columns are also listed on this page. To get into your data, click the Details link.
http://flatmerge.com/Data/Details/8ef2ad73-660a-4228-bb8f-eedeae821c1c


Here you will see your data details in FlatMerge. Listed are: date/time created (GMT), the original file name, number of rows, and storage space used. Since FlatMerge optimizes your data, the size (Kb) will be much less than the actual file size uploaded.


Three links will also be listed:


Location: this is the location of your data details

Data query location: this is the location of the actual data. This URL can be used from other clients for use in applications, web pages, or any way you wish to share or use your data. 


The data can be queried using OData URL conventions and returned in JSON or XML. (Currently, the supported queries are: top, orderBy, Select, Skip).



Metadata location: this is the URL of the metadata that FlatMerge created. After uploading, FlatMerge analyzes your data and discovers the true data types and widths (for number and character columns). If numeric, the whole number and decimal parts are discovered.  The metadata can also be queried using OData URLs.



Also on the data details page is a grid that displays the first 1,000 rows of data. For this grid, we used the open source Kendo UI Grid.

And below the data grid is a table of metadata discovered.

Share

Most importantly, share your data! We want to make it easy to share data in a way that assures others of data quality and transparency.



The social media sharing links point directly to your data's details.