tag:blogger.com,1999:blog-24034205848142424852024-02-07T03:09:41.984-08:00FlatMerge BlogFlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-2403420584814242485.post-30376261194184226102014-04-15T17:38:00.001-07:002014-04-15T17:38:08.044-07:00The New Flatmerge BlogThe Flatmerge Blog has moved to<br />
<br />
<a href="http://flatmerge.blogspot.com/">http://flatmerge.blogspot.com</a><br />
<br />
Oh yeah, and check out our <a href="https://www.kickstarter.com/projects/701181373/flatmerge-an-api-for-sharing-excel-and-other-data" target="_blank">Kickstarter project</a>. Back it and get some storage space and support.FlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.com0tag:blogger.com,1999:blog-2403420584814242485.post-78039315210671901222013-04-11T20:35:00.002-07:002013-04-11T21:20:26.924-07:00Exploring Hospital Patient Survey Data With Excel GeoFlowAs we add more <a href="http://odata.org/" target="_blank">OData</a> features to FlatMerge, we are having fun discovering new ways to work with data. This post highlights 3 interesting things:<br />
<ol>
<li>The newly added FlatMerge <b><a href="http://www.odata.org/2010/04/queryable-odata-metadata/" target="_blank">OData $metadata</a></b> support enables opening FlatMerge data directly into Excel Data Explorer. (note that FlatMerge offers minimal, but essential bits of support for $metadata currently)</li>
<li>Some interesting data that is geocoded using Bing in Excel! Survey of Patients’ Hospital Experiences (HCAHPS) from data.gov<span style="color: #333333; font-family: Arial, sans-serif;"><span style="font-size: 12px; line-height: 12px;">.</span></span></li>
<li><a href="http://www.neowin.net/news/microsoft-launches-geoflow-preview-for-excel-2013-3d-visuals-for-data" target="_blank">GeoFlow for Excel</a>. From Microsoft: "GeoFlow lets you plot geographic and temporal data visually, analyze that data in 3D, and create interactive "tours" to share with others."</li>
</ol>
<div>
Here's how we loaded data from FlatMerge into Excel and used GeoFlow to see which hospitals are recommended by (sampled) patients, exploring using 3D maps!</div>
<div>
<br /></div>
<div>
First, we grabbed the text data from <a href="https://data.medicare.gov/Hospital-Compare/Survey-of-Patients-Hospital-Experiences-HCAHPS-/rj76-22dk" target="_blank">data.gov</a> and changed the column names (they were way too long, like sentences). We also replaced "Not Available" to empty so calculations will be happy. Numbers were text percentages appended with %, so we removed that too.</div>
<div>
<br /></div>
<div>
Get the data and OData link here</div>
<div>
<a href="http://flatmerge.com/Data/Details/9548f35f-7c02-4bca-a2e9-61d2b407fe92">http://flatmerge.com/Data/Details/9548f35f-7c02-4bca-a2e9-61d2b407fe92</a></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgG4fupSo0ZxaLm715pjS9fL4AVp5LOZUOiRgAUHbytULLFdgWZwc3tITe6UGaL3C-77MjIUB3rGrKdtxa58HAmNqwfXxTEiIJm_1xxxweMGCKnBvh0OdWgpiU1qEa4WjIknnCk7-XaEhyphenhyphenY/s1600/details.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="199" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgG4fupSo0ZxaLm715pjS9fL4AVp5LOZUOiRgAUHbytULLFdgWZwc3tITe6UGaL3C-77MjIUB3rGrKdtxa58HAmNqwfXxTEiIJm_1xxxweMGCKnBvh0OdWgpiU1qEa4WjIknnCk7-XaEhyphenhyphenY/s320/details.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Then we copied the OData link (<a href="http://flatmerge.com/Data/odata/9548f35f-7c02-4bca-a2e9-61d2b407fe92" rel="nofollow" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #c7d1d6; color: #333333; font-size-adjust: none; font-stretch: normal; font: 14px/normal "Segoe UI", Verdana, Helvetica, sans-serif; letter-spacing: normal; padding-left: 3px; padding-right: 3px; text-decoration: underline; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;" target="_blank">http://flatmerge.com/Data/odata/9548f35f-7c02-4bca-a2e9-61d2b407fe92</a>) and pasted it into the Excel Data Explorer -> From Other Sources -> From OData Feed</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgB3IFVhuF9AtgDRIb7LHE_lSrEvyHRwiCFKUrorqRpOidhCiB9afX8kn4zvdqrtOW0cG7800fV7DLUyxlYFgboIztGnZ0_20qQxjoekEZ0VL3uIe4X35Lm5JWQVL97a5JHFasWjW4W3Huy/s1600/getodata.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgB3IFVhuF9AtgDRIb7LHE_lSrEvyHRwiCFKUrorqRpOidhCiB9afX8kn4zvdqrtOW0cG7800fV7DLUyxlYFgboIztGnZ0_20qQxjoekEZ0VL3uIe4X35Lm5JWQVL97a5JHFasWjW4W3Huy/s320/getodata.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
After clicking Apply, Excel queries the metadata about this OData feed, which just includes this one data feed (the survey data we've uploaded to FlatMerge). In FlatMerge, we provide one OData URL for each data file. So, choose the only table in the feed, which is identified by the GUID assigned by FlatMerge. Click that and Excel queries the data to pull the top 100 rows ($top=100).</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDb04CFraZ8dnIrL6KP_9jdQgwQMwUvxDhw9EGUpMSNhalFYGD2xpl8KxE74lsDI0qhO57XCSPP7K_I7iknG0dpiompwcgiDC2jG-Ej9KH7rKqBl0XLiUZq9_9U9Q6Hg3gBPTMvy4ko_xO/s1600/top100.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDb04CFraZ8dnIrL6KP_9jdQgwQMwUvxDhw9EGUpMSNhalFYGD2xpl8KxE74lsDI0qhO57XCSPP7K_I7iknG0dpiompwcgiDC2jG-Ej9KH7rKqBl0XLiUZq9_9U9Q6Hg3gBPTMvy4ko_xO/s320/top100.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Click Done to let DataExplorer get the rest of your data. Once DataExplorer finishes downloading the rest of your data, click Insert tab -> Map (Map is the GeoFlow launcher, download it and install it here <a href="http://office.microsoft.com/en-us/download-geoflow-for-excel-FX104036784.aspx" target="_blank">http://office.microsoft.com/en-us/download-geoflow-for-excel-FX104036784.aspx</a>).</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLBHWUSQSvoUP4ztMjPvhTo__jsHLyTfz3T21HiRcrA35FX_szgU6sNgbqV5jDRa4liWybwPNuXr_xyf7QTrW0GzfAnwaV30UvEmyif9aZUcd2j7-ENH_stH0Y9PqvFaY208mIaWH-LnmC/s1600/mapclick.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLBHWUSQSvoUP4ztMjPvhTo__jsHLyTfz3T21HiRcrA35FX_szgU6sNgbqV5jDRa4liWybwPNuXr_xyf7QTrW0GzfAnwaV30UvEmyif9aZUcd2j7-ENH_stH0Y9PqvFaY208mIaWH-LnmC/s320/mapclick.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
Start invstigating the data, visually, in 3D! One of the coolest things about GeoFlow is that you can make time series interactive tours of your data. This hospital survey that we grabbed is just one survey (there may be more), so no time series tour here, but the 3D navigation is still pretty cool. </div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
Select "State" column for the Geography, then click Map It. GeoFlow calls Bing and geocodes the States' geographic centroids. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPwFdDXvkmDbGfYwOk_w-o-0mLR3HbKyBO4FV9skjNB8XzmV_scheWdK0tV3zxkTkcfY3tHrTXRIAPcdBL_nZp3Ws_K1ngT-mR90dtCMchX2sDPD3BRecko3m5lFwFogyE8sg6lXGcvdjK/s1600/state.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPwFdDXvkmDbGfYwOk_w-o-0mLR3HbKyBO4FV9skjNB8XzmV_scheWdK0tV3zxkTkcfY3tHrTXRIAPcdBL_nZp3Ws_K1ngT-mR90dtCMchX2sDPD3BRecko3m5lFwFogyE8sg6lXGcvdjK/s320/state.png" width="320" /></a></div>
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #efeeef; color: #333333; display: inline !important; float: none; font-size-adjust: none; font-stretch: normal; font: 14px/normal "Segoe UI", Verdana, Helvetica, sans-serif; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="color: black; font-family: Times New Roman; font-size: small;"></span></span><br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #efeeef; color: #333333; display: inline !important; float: none; font-size-adjust: none; font-stretch: normal; font: 14px/normal "Segoe UI", Verdana, Helvetica, sans-serif; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"><span style="color: black; font-family: Times New Roman; font-size: small;">Then, to keep things simple , we add just one interesting data point, so select/click the PctRpt_YES_would_definitely_recommend_the_hospital column. That column appears in the Height dropdown. Select that Height again and choose "Average" to get the average respondent percentage who chose that that would definitely recommend the hospital.</span></span><br />
<br />
We also clicked the "Chart" button to get a chart of the values. Drag around the map and have fun!<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_hN5eTqE7Hc1UwHBFosu2i0Gi-nyFVKA23DXOtdEpthgnR3akNwNvqOaRQgou0Bg0N8_2kQS5tgL0y9zPYehvvn0c6nljTIwyydKTXytLig6RE3o9_4l0GjndcSpTgGVxo1t4pk898CAl/s1600/mapandchart.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_hN5eTqE7Hc1UwHBFosu2i0Gi-nyFVKA23DXOtdEpthgnR3akNwNvqOaRQgou0Bg0N8_2kQS5tgL0y9zPYehvvn0c6nljTIwyydKTXytLig6RE3o9_4l0GjndcSpTgGVxo1t4pk898CAl/s320/mapandchart.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
We hope this shows some interesting features of FlatMerge's OData support and how easy this functionality makes it to use with other tools like Excel and it's new toys like GeoFlow. <br />
<div>
<br /></div>
FlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.com0tag:blogger.com,1999:blog-2403420584814242485.post-40740440234597732462013-03-18T05:35:00.000-07:002013-03-18T05:35:40.280-07:00New Feature: Get OData Output From FlatMergeWe've added OData output through FlatMerge. Now if you have a rectangular data file you have OData too! This is an addition to the current output formats of plain XML and JSON.<br />
<br />
We'll be doing a series of posts about the many cool things you can do with this new feature. Today, we demonstrate the usefulness of OData and FlatMerge by loading some data into Excel 2013 directly from a FlatMerge URL.<br />
<br />
Since earthquake data is so interesting, we've grabbed the freshest earthquake data from data.gov (<a href="https://explore.data.gov/Geography-and-Environment/Worldwide-M1-Earthquakes-Past-7-Days/7tag-iwnu" target="_blank">https://explore.data.gov/Geography-and-Environment/Worldwide-M1-Earthquakes-Past-7-Days/7tag-iwnu</a>), and uploaded it to FlatMerge <a href="http://flatmerge.com/Data/Details/fa05d620-96fc-4e18-8d7f-e9ba0ec59c75">http://flatmerge.com/Data/Details/fa05d620-96fc-4e18-8d7f-e9ba0ec59c75</a>. (<b>You can upload data for free to FlatMerge too!</b>)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxJQmiL2SPdXndZvM3nObURbg73HLkxswOr5sBdZ3zilbTU7_yDvqaIAEd31gngdz0Rup8SctQGw1G9DJMXCVNg_SWyYP7HiWA1OhYURiR1ij5gfrb2uG7q2qZV-WNPQzR9Q-Fv-AjweMd/s1600/eq.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="109" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxJQmiL2SPdXndZvM3nObURbg73HLkxswOr5sBdZ3zilbTU7_yDvqaIAEd31gngdz0Rup8SctQGw1G9DJMXCVNg_SWyYP7HiWA1OhYURiR1ij5gfrb2uG7q2qZV-WNPQzR9Q-Fv-AjweMd/s320/eq.gif" width="320" /></a></div>
<br />
<br />
To get OData from FlatMerge, use the proper HTTP Accept header, like this<br />
<span style="font-family: Courier New, Courier, monospace;">Accept: application/atom+xml</span><br />
or add the querystring parameter <span style="font-family: Courier New, Courier, monospace;">&format=odata</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
Excel automatically does this (adds the Accept header) when you choose to add OData. So, to import FlatMerge OData into Excel:<br />
<br />
1. Go to the FlatMerge details page of the data you've uploaded or are interested in and copy the OData URL as circled in red in the above image. Open Excel and navigate to Data->From Other Sources->From OData Feed (or PowerPivot->Manage->Get External Data->From Data Service->From OData Data Feed), and paste that URL into the Location Field.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4AMaohCtGJtkKSKKm1Mi0RbWot2nTZAXKap8RHxPS9UMPRtMayBKtHKeMZnWCXt-QxcZ7yI2p1Uw0Lv_8QoPRpECI_2EGtxljErevl0gkZVMFLEZGyySEKasqBQ46XqqU-d8OTDcuqplQ/s1600/location.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4AMaohCtGJtkKSKKm1Mi0RbWot2nTZAXKap8RHxPS9UMPRtMayBKtHKeMZnWCXt-QxcZ7yI2p1Uw0Lv_8QoPRpECI_2EGtxljErevl0gkZVMFLEZGyySEKasqBQ46XqqU-d8OTDcuqplQ/s320/location.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
2. Select the one and only table listing. This is the original file name that was uploaded to FlatMerge.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgypeKVfII-BjCsZNbjCKB0qzjRnAIClvN9lRX7u6cik8jKIygFwbTilVZysGquUKQDb-mvsHAvTenTZHoCNBuNjk-Jgpukyo1CbLR2Zqfs-FaWa7YjQAXNR4gL4OlVh0dqYXrbgyJor8_x/s1600/eqtable.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgypeKVfII-BjCsZNbjCKB0qzjRnAIClvN9lRX7u6cik8jKIygFwbTilVZysGquUKQDb-mvsHAvTenTZHoCNBuNjk-Jgpukyo1CbLR2Zqfs-FaWa7YjQAXNR4gL4OlVh0dqYXrbgyJor8_x/s320/eqtable.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
3. Click Next and save the connection if you'd like. Select how to view the data (we've only tested with Table) and where to put it.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3UI1YVAtUhtb0W487oMpxuwC6ronEtp4KzR4mUB-1Ywt1OkjvEh8PiAq47fX1KqUAkPjlvm_oscby38E5MCDNpX9YjWmT3uFU4sZuxM1PTQmY9jehZOnjrDUMAXm8MmN6ZT77CqTvttId/s1600/cells.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="241" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3UI1YVAtUhtb0W487oMpxuwC6ronEtp4KzR4mUB-1Ywt1OkjvEh8PiAq47fX1KqUAkPjlvm_oscby38E5MCDNpX9YjWmT3uFU4sZuxM1PTQmY9jehZOnjrDUMAXm8MmN6ZT77CqTvttId/s320/cells.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
4. Data is imported! (Depending on the size of your data, this may take just a second, or hours).</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLVbHLmx5sGpC8KQaVNbDTMvEIc0frJBqzLKnN1e_DtPq_Ptj5CCsb9-O1mHOlHXsSMcUNThGGyfGRACEGRTUCcF70z2vIVFgGjEXR4rc3oJxNos6PZK_d2GX5RAEI7OVFtj-gjg7OsfDq/s1600/data.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLVbHLmx5sGpC8KQaVNbDTMvEIc0frJBqzLKnN1e_DtPq_Ptj5CCsb9-O1mHOlHXsSMcUNThGGyfGRACEGRTUCcF70z2vIVFgGjEXR4rc3oJxNos6PZK_d2GX5RAEI7OVFtj-gjg7OsfDq/s320/data.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Please try it out and <a href="http://flatmerge.com/Home/Contact">let us know how you like it</a>.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
FlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.com0tag:blogger.com,1999:blog-2403420584814242485.post-48746439939287613892013-03-04T19:21:00.000-08:002013-03-04T19:43:13.904-08:00What's in my data?<h4>
One of the coolest things about FlatMerge is that it tells you types and lengths of your data. We're relying heavily on this feature as we build in dynamic OData output (coming soon!). So, browsing around data.gov, we found some interesting raw data about Congressional campaign expenditures <a href="https://explore.data.gov/Elections/2009-2010-Candidate-Summary-File/38zs-22s9" target="_blank">https://explore.data.gov/Elections/2009-2010-Candidate-Summary-File/38zs-22s9</a></h4>
<br />
Loading this data into FlatMerge (<a href="http://flatmerge.com/Data/Details/77e6b770-8ef6-4658-912a-a771d159f270" rel="nofollow">http://flatmerge.com/Data/Details/77e6b770-8ef6-4658-912a-a771d159f270</a>) shows some interesting things...<br />
<br />
The description of the data on data.gov says that ZIP Code (can_zip) is 5 digits. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRhm_3fi7rOzudEU3U97zcLhtNukYME73RUPhyG7PGUanqtD00Ayc49wXlWnbHKTJg44UvitK34CPBnOtY2jwDGgXfcdOwJ-m2oj0-1qo-05LY0-dUNpooVXwIu29vbIcXSbayeOhw6VKg/s1600/zip.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="14" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRhm_3fi7rOzudEU3U97zcLhtNukYME73RUPhyG7PGUanqtD00Ayc49wXlWnbHKTJg44UvitK34CPBnOtY2jwDGgXfcdOwJ-m2oj0-1qo-05LY0-dUNpooVXwIu29vbIcXSbayeOhw6VKg/s320/zip.png" width="320" /></a></div>
<br />
<br />
FlatMerge found some ZIP codes to be 9 digits... is this ZIP+4?<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjotRYZAMLva9R3zLHmGxZUUTzOq4uqzlb96KH2Qw5z0dqHzwcXYWPwU43YznFytfK7k8WnvjPcEwf2UgjYisIWDtR1r09b8Gyj6WG4ZHFp8Llr1zGJEP6eEPyZZKAxsuFYv3Tpzx4RL0gz/s1600/Snap2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjotRYZAMLva9R3zLHmGxZUUTzOq4uqzlb96KH2Qw5z0dqHzwcXYWPwU43YznFytfK7k8WnvjPcEwf2UgjYisIWDtR1r09b8Gyj6WG4ZHFp8Llr1zGJEP6eEPyZZKAxsuFYv3Tpzx4RL0gz/s320/Snap2.png" width="267" /></a></div>
<br />
Also, it seems strange that the <em>Candidate Incumbent Challenger Open Seat </em>(can_inc_cha_ope_sea) field indicates that it is a 10 character field, but has an explanation for some letter abbreviations. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_6cWJoFGaUcgayxe0kNFrxKkBfbEAJstk7IjwtApWuOLSElh8t7hVh_d-G51jsmIRn7SwCeR9my7imSeSsb8h6jMkTWIE9zlPlo3D91cNSX11tHvuBTq8WM76ET4n4Nz4UBTZSAkgPFze/s1600/Snap3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="13" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_6cWJoFGaUcgayxe0kNFrxKkBfbEAJstk7IjwtApWuOLSElh8t7hVh_d-G51jsmIRn7SwCeR9my7imSeSsb8h6jMkTWIE9zlPlo3D91cNSX11tHvuBTq8WM76ET4n4Nz4UBTZSAkgPFze/s320/Snap3.png" width="320" /></a></div>
<br />
Turns out, the explanation of the abbreviated data is not needed, because the data contains the full text.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiD2UykctCB8ZGcBk0xM87POsXdqqTAou3LoxSfeExiWeQnvVzvDBBM66s0hNh-OxpgZXik2XnJnW1rPh5efPKvENib4qsE44qho8TWlkGvEm9iDPjadGkurgQZByCo87cpvY-Jg_VpYvZO/s1600/Snap4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiD2UykctCB8ZGcBk0xM87POsXdqqTAou3LoxSfeExiWeQnvVzvDBBM66s0hNh-OxpgZXik2XnJnW1rPh5efPKvENib4qsE44qho8TWlkGvEm9iDPjadGkurgQZByCo87cpvY-Jg_VpYvZO/s320/Snap4.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMukAkCrBodXSApX3PKMb_ltFeWZmwmseRnFbPlSIcXf-kKNkYPU9tEYru3JTyt0UeQcUEi4vVMkO5ofINVotpSvKEHwYVCCzyaE0tsMV85tbNUrxKeiYk-xYnhyphenhyphen6uB8L86fwvxpv-Fhpx/s1600/Snap5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="116" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMukAkCrBodXSApX3PKMb_ltFeWZmwmseRnFbPlSIcXf-kKNkYPU9tEYru3JTyt0UeQcUEi4vVMkO5ofINVotpSvKEHwYVCCzyaE0tsMV85tbNUrxKeiYk-xYnhyphenhyphen6uB8L86fwvxpv-Fhpx/s320/Snap5.png" width="320" /></a></div>
<br />
So, the documentation does not exactly match what's truly in the data.FlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.com0tag:blogger.com,1999:blog-2403420584814242485.post-47127375577586612442013-02-24T19:51:00.000-08:002013-03-04T19:44:14.282-08:00Use Excel 2013 with FlatMerge
In Excel, click Data tab -> From Other Sources -> From XML Data Import<br />
<div>
<br /></div>
<div>
Select the <i>Data query location</i> from FlatMerge, here we open the most recent Earthquakes and choose format=xml</div>
<div>
<a href="http://flatmerge.com/Data/Query/ad884c41-c29a-4eb3-a06a-60a489800768?format=xml" rel="nofollow">http://flatmerge.com/Data/Query/ad884c41-c29a-4eb3-a06a-60a489800768?format=xml</a></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDnIXDT9scOw_m7987sRPgRZWBJXwYsyFVYSynL4sNFq6MnqKvjnX3J2pqH3noAFzcYL5oLmJvtL0D1QOFfJUUyZbL3kwKUQJScPnroYYgh3qiEeJP-y-uT7NseZMtOSiswEQ-kvbtDWGz/s1600/Snap1.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="56" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDnIXDT9scOw_m7987sRPgRZWBJXwYsyFVYSynL4sNFq6MnqKvjnX3J2pqH3noAFzcYL5oLmJvtL0D1QOFfJUUyZbL3kwKUQJScPnroYYgh3qiEeJP-y-uT7NseZMtOSiswEQ-kvbtDWGz/s320/Snap1.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Excel 2013 is ready for import</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijrsq7Ifq2W69uAPAadd5OoeBAtul8SUbavRE34cw97ZeVOllXW4bJy6hi1typyVNY_SYM0di2UQbg2nmjsumAcX2HJQ8Re0s_8iqoP3fy8IH37H1LBAm74gty7W8wb-TgT3hwFEh3hUdo/s1600/Snap2.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijrsq7Ifq2W69uAPAadd5OoeBAtul8SUbavRE34cw97ZeVOllXW4bJy6hi1typyVNY_SYM0di2UQbg2nmjsumAcX2HJQ8Re0s_8iqoP3fy8IH37H1LBAm74gty7W8wb-TgT3hwFEh3hUdo/s320/Snap2.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Have some Excel 2013 fun!</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQPnJbVDWFm0DTYnz-1PYrYrT3C_Pa0vaZu5Bo7Ge5P_VjM70s7pxjZraoKMU1HIsUlgyDPOXH83YN4BE7e-Y4N5vs1dEE1kggA20hLwrlghDmsqy4BwXVP2VcdjHmad6t9tXUj0WdWHLK/s1600/Snap3.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQPnJbVDWFm0DTYnz-1PYrYrT3C_Pa0vaZu5Bo7Ge5P_VjM70s7pxjZraoKMU1HIsUlgyDPOXH83YN4BE7e-Y4N5vs1dEE1kggA20hLwrlghDmsqy4BwXVP2VcdjHmad6t9tXUj0WdWHLK/s320/Snap3.gif" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
FlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.com0tag:blogger.com,1999:blog-2403420584814242485.post-13637105105810423542013-01-11T18:27:00.003-08:002013-03-04T19:45:34.164-08:00Farmer's Market MapWe've created a <a href="http://flatmerge.com/markets.html">Google Map of Farmer's Markets</a> using data in FlatMerge. This post shows how FlatMerge makes it simple.<br />
<br />
<br />
<br />
1. Grab the csv data from <a href="https://explore.data.gov/Agriculture/Farmers-Markets-Geographic-Data/wfna-38ey" target="_blank">data.gov</a> and <a href="http://flatmerge.com/Data/Upload">upload</a> it to FlatMerge.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZMHLIss4tPCuI52NS948ZTzuJGmEbmdLlF5nE1IDKIW-NOxiS1D6uv6vWZiIbzpKMmaR8z2OQ9MNfK9e20LdVEhxAa_-FNLDzyO3b0ZzMTgBnfjVRDD-WdjHjCg_Leg-4jnLxT9rPPYpI/s1600/upload.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="56" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZMHLIss4tPCuI52NS948ZTzuJGmEbmdLlF5nE1IDKIW-NOxiS1D6uv6vWZiIbzpKMmaR8z2OQ9MNfK9e20LdVEhxAa_-FNLDzyO3b0ZzMTgBnfjVRDD-WdjHjCg_Leg-4jnLxT9rPPYpI/s320/upload.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
2. See what's in the data. X, Y (longitude and latitude coordinates, cool!), and website are good for now.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVJuaINwwHTWLghPyzIgFrtne7CMTpob-UfDR20OTk_JuigusSAXbU0kfaMpNioYqb5buZPDNtcKqswmtjxAjNmQmoZLUa6RYOVKM24H_OHokR4EdENc-YQllltrfY95Caugu8JA_6lpW-/s1600/meta.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="269" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVJuaINwwHTWLghPyzIgFrtne7CMTpob-UfDR20OTk_JuigusSAXbU0kfaMpNioYqb5buZPDNtcKqswmtjxAjNmQmoZLUa6RYOVKM24H_OHokR4EdENc-YQllltrfY95Caugu8JA_6lpW-/s320/meta.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<span style="text-align: center;"><br /></span>
<span style="text-align: center;">2. Browse </span><a href="https://developers.google.com/maps/documentation/javascript/examples/" style="text-align: center;">Google Maps API</a><span style="text-align: center;"> examples for some cool ways to make maps.</span><br />
<span style="text-align: center;"><br /></span>
<span style="text-align: center;">3. Create a lean OData query to get the fields I need.<br /><a href="http://flatmerge.com/Data/Query/31974ef9-5a62-420d-a6c3-945b3ab8e6d4?$select=x,y,website" rel="nofollow" target="_blank">http://flatmerge.com/Data/Query/31974ef9-5a62-420d-a6c3-945b3ab8e6d4?$select=x,y,website</a></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiawQWXpybfq-O_4kNhT8SJkn3Y30YTfolrAIOoBq9A6j0mgpOoxuSbbtoJxfNu0RBQvqtQkIpRylYLjIRuhQsw6jpsGJEKp1CZzR33Q2g-PEDAAlVYSlXY_XvVT34UhgWt8Mn-MNKLFueE/s1600/dq.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiawQWXpybfq-O_4kNhT8SJkn3Y30YTfolrAIOoBq9A6j0mgpOoxuSbbtoJxfNu0RBQvqtQkIpRylYLjIRuhQsw6jpsGJEKp1CZzR33Q2g-PEDAAlVYSlXY_XvVT34UhgWt8Mn-MNKLFueE/s320/dq.jpg" width="320" /></a></div>
<div style="text-align: left;">
Load markers on the map using the x/y coordinates from the JSON returned by FlatMerge query:<br />
<table><tbody>
<tr><td class="webkit-line-content"><span style="font-size: x-small;">$.getJSON("http://flatmerge.com/Data/Query/31974ef9-5a62-420d-a6c3-945b3ab8e6d4?$select=x,y,website", function (data) {</span></td></tr>
<tr><td class="webkit-line-number"></td><td class="webkit-line-content"><span style="font-size: x-small;">for (var i = 0; i < data.length; i++) {</span></td></tr>
<tr><td class="webkit-line-number"></td><td class="webkit-line-content"><span style="font-size: x-small;">var market = data[i];</span></td></tr>
<tr><td class="webkit-line-number"></td><td class="webkit-line-content"><span style="font-size: x-small;">var myLatLng = new google.maps.LatLng(market.y, market.x); </span></td></tr>
</tbody></table>
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
4. Check it out <a href="http://flatmerge.com/markets.html" target="_blank">http://flatmerge.com/markets.html</a>! View the source code to see how simple it is. (Note that the code won't work using a local .html file, it must be on a real web server or localhost.)</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<h4>
Mobile app and how-to post coming soon...</h4>
<br />FlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.com0tag:blogger.com,1999:blog-2403420584814242485.post-6141494017108277282012-12-09T18:41:00.002-08:002013-09-30T11:00:11.689-07:00Earthquake list for the past 7 days<i><span style="font-size: x-small;">(Quick Note: direct link to this data:<br /><a href="http://flatmerge.com/Data/Details/8ef2ad73-660a-4228-bb8f-eedeae821c1c">http://flatmerge.com/Data/Details/8ef2ad73-660a-4228-bb8f-eedeae821c1c</a>, <br />or another interesting set of data about Farmers Markets:<br /><a href="http://flatmerge.com/Data/Details/31974ef9-5a62-420d-a6c3-945b3ab8e6d4">http://flatmerge.com/Data/Details/31974ef9-5a62-420d-a6c3-945b3ab8e6d4</a>)</span></i><br />
<br />
For the first FlatMerge post, we've shared some data with you about earthquakes. From data.gov:<br />
<a href="https://explore.data.gov/Geography-and-Environment/Worldwide-M1-Earthquakes-Past-7-Days/7tag-iwnu" target="_blank">https://explore.data.gov/Geography-and-Environment/Worldwide-M1-Earthquakes-Past-7-Days/7tag-iwnu</a><br />
<br />
Since this is the first data loaded into FlatMerge by anyone, this post is also a how-to for getting started with FlatMerge.<br />
<br />
<h3>
Upload</h3>
<a href="http://flatmerge.com/Data/Upload">http://flatmerge.com/Data/Upload</a><br />
Uploading your data is simple. The file source (currently supported) is a comma-delimited text file with column names in the first row.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg99h2aKiHnJ1T_FnoohK64DWcRlB0w6Ti56Ay2k2nfClLS36plCfTOG5qxp7WOBNFs37ql0t1N0ycfPdlA6UBJGoYo-CS1QC0EwoF-BfvpjhDZ876y0nTYa-G3DmwTDaTpti0YUdiuqBJl/s1600/upload.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg99h2aKiHnJ1T_FnoohK64DWcRlB0w6Ti56Ay2k2nfClLS36plCfTOG5qxp7WOBNFs37ql0t1N0ycfPdlA6UBJGoYo-CS1QC0EwoF-BfvpjhDZ876y0nTYa-G3DmwTDaTpti0YUdiuqBJl/s1600/upload.jpg" width="320" /></a></div>
<br />
FlatMerge ingests the file then sends you to your data list page. Your new data's status will say "<b>Analyzing</b>" while FlatMerge detects the exact data types and width's of each column.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLNnkkm-dtM1YY_h8Eqc4uXdc-rt-HDC-0TXuH8ESWjLsURLXWAl1e90y80fWu_GVnj7iVT0Gm7xnl9I_xRi1zMxu_LXpilm3U1s2uCGQ1xcxOGFxcy_QFz4tnhQPX-7q4RE6v319Dtrgl/s1600/list.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="95" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLNnkkm-dtM1YY_h8Eqc4uXdc-rt-HDC-0TXuH8ESWjLsURLXWAl1e90y80fWu_GVnj7iVT0Gm7xnl9I_xRi1zMxu_LXpilm3U1s2uCGQ1xcxOGFxcy_QFz4tnhQPX-7q4RE6v319Dtrgl/s1600/list.jpg" width="320" /></a></div>
Refresh the data index page until your data status is "<b>Complete</b>". The number of rows and columns are also listed on this page. To get into your data, click the Details link.<br />
<a href="http://flatmerge.com/Data/Details/0ab76037-a214-460c-ab66-1ffa5398bb92" target="_blank">http://flatmerge.com/Data/Details/8ef2ad73-660a-4228-bb8f-eedeae821c1c</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAoSMOzJo-_JpTMCUXP5BsVe1ge6W_xNPGoXuxkzQeWb2VZIsIj_HFUugZEkOtAOW7HpGweyUA6gq-EPlzx0jtOFTxcRWtp9suAkdL47sGk71QI-jZcy5AxehmwKUf_E93ayxdX0xBuoqI/s1600/Details1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="80" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAoSMOzJo-_JpTMCUXP5BsVe1ge6W_xNPGoXuxkzQeWb2VZIsIj_HFUugZEkOtAOW7HpGweyUA6gq-EPlzx0jtOFTxcRWtp9suAkdL47sGk71QI-jZcy5AxehmwKUf_E93ayxdX0xBuoqI/s320/Details1.jpg" width="320" /></a></div>
<br />
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.<br />
<br />
<br />
<h4>
Three links will also be listed:</h4>
<div>
<br /></div>
<div>
<b>Location</b>: this is the location of your data details<br />
<div>
<a href="http://flatmerge.com/Data/Details/0ab76037-a214-460c-ab66-1ffa5398bb92">http://flatmerge.com/Data/Details/</a><a href="http://flatmerge.com/Data/Details/0ab76037-a214-460c-ab66-1ffa5398bb92" target="_blank">8ef2ad73-660a-4228-bb8f-eedeae821c1c</a></div>
<div>
<br />
<b>Data query location</b>: 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. </div>
<div>
<br /></div>
<div>
<a href="http://flatmerge.com/Data/QueryMeta/8ef2ad73-660a-4228-bb8f-eedeae821c1c" rel="nofollow" target="_blank">http://flatmerge.com/Data/Query/8ef2ad73-660a-4228-bb8f-eedeae821c1c</a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuJzgiuWL-96cegfwT4ow_CnoNvc7uAEqjF6tOR9xRC0CShNLRdMqdSr1oJTfJ7ld6z8JoVfHkE9_X16T-xu_3BRxmlqn2d7XcGc1xkS-pHyZL2PmKNafxyybxVXfn2eFRYSCaNa6E63pv/s1600/dataquerytop100.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="131" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuJzgiuWL-96cegfwT4ow_CnoNvc7uAEqjF6tOR9xRC0CShNLRdMqdSr1oJTfJ7ld6z8JoVfHkE9_X16T-xu_3BRxmlqn2d7XcGc1xkS-pHyZL2PmKNafxyybxVXfn2eFRYSCaNa6E63pv/s1600/dataquerytop100.jpg" width="320" /></a></div>
<div>
<br /></div>
<div>
The data can be queried using <a href="http://www.odata.org/documentation/uri-conventions#QueryStringOptions" target="_blank">OData</a> URL conventions and returned in JSON or XML. (Currently, the supported queries are: <span style="background-color: #efeeef; color: #333333; font-family: 'Segoe UI', Verdana, Helvetica, sans-serif; font-size: 14px;">top, orderBy, Select, Skip).</span></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkZHqdJQk9GIpn3FipuR6rLAn96YxkYH6BQr1vIa2gnZFhvZmVZJi2EO0IE72Xqm7t6S3wHRdQBWFlk8LfVrMHn3tL_zpCrIEmHadtbFLyE73FXfEquwJSRLnSWLoTaJhAxsxyLZbPv3Mq/s1600/dataquerytop5recent.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="37" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkZHqdJQk9GIpn3FipuR6rLAn96YxkYH6BQr1vIa2gnZFhvZmVZJi2EO0IE72Xqm7t6S3wHRdQBWFlk8LfVrMHn3tL_zpCrIEmHadtbFLyE73FXfEquwJSRLnSWLoTaJhAxsxyLZbPv3Mq/s1600/dataquerytop5recent.jpg" width="320" /></a></div>
<div>
<br /></div>
<div>
<br />
<b>Metadata location</b>: 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 <a href="http://www.odata.org/documentation/uri-conventions#QueryStringOptions" target="_blank">OData</a><span id="goog_916816304"></span><span id="goog_916816305"></span><a href="https://www.blogger.com/"></a> URLs.<br />
<div>
<br /></div>
<div>
<a href="http://flatmerge.com/Data/QueryMeta/8ef2ad73-660a-4228-bb8f-eedeae821c1c" rel="nofollow" target="_blank">http://flatmerge.com/Data/QueryMeta/8ef2ad73-660a-4228-bb8f-eedeae821c1c</a></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-jRhsOItt03fBSDRcv-yTmReky4klm25UsAAiRZ6hf2FGnwbXE0OCnjKGERWiCukxVTlPPD7-hxzcz74OdW3diywzNrzUrYa0RzpJyst1Pg1qybzWOBsmHQg2Le-hdxPeYEiYaDUGFUaY/s1600/metadataquery.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="115" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-jRhsOItt03fBSDRcv-yTmReky4klm25UsAAiRZ6hf2FGnwbXE0OCnjKGERWiCukxVTlPPD7-hxzcz74OdW3diywzNrzUrYa0RzpJyst1Pg1qybzWOBsmHQg2Le-hdxPeYEiYaDUGFUaY/s1600/metadataquery.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
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 <a href="http://demos.kendoui.com/web/grid/index.html" target="_blank">Kendo UI Grid</a>.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipiJQH3qRwJYf6SvdC4VW3ihYOGSQP5QBzMAljhR5XTPsztye9MKINQCLYuxV4LxCULjnk-CbePs6-p0UmrZx8Y3x1rVvEE8Ai48773n8raTxxFrA5OZnzCTGT8N1gv7SmYjV4OyqaCbvC/s1600/Details2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="97" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipiJQH3qRwJYf6SvdC4VW3ihYOGSQP5QBzMAljhR5XTPsztye9MKINQCLYuxV4LxCULjnk-CbePs6-p0UmrZx8Y3x1rVvEE8Ai48773n8raTxxFrA5OZnzCTGT8N1gv7SmYjV4OyqaCbvC/s1600/Details2.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
And below the data grid is a table of metadata discovered.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioavGckCSP2E-gf8me9sWa8dPSnU-STcjUDRmpUN6uhQSURKIwP-fZ7NQa-8gwzaQF5CZE0U1oFXvwf1X_YD5Cd_xxKY8H55PgYoGbMG0pq0buRaJjJZkMbyixEGDCvCwOcbz5zYvXBNmP/s1600/metadata.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioavGckCSP2E-gf8me9sWa8dPSnU-STcjUDRmpUN6uhQSURKIwP-fZ7NQa-8gwzaQF5CZE0U1oFXvwf1X_YD5Cd_xxKY8H55PgYoGbMG0pq0buRaJjJZkMbyixEGDCvCwOcbz5zYvXBNmP/s1600/metadata.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div>
<h4>
Share</h4>
</div>
<div>
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.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0QSrRBA0boBYSh6Edi_TOX3GWxTI2BlIK-3p9Fhj_32f8AhjFvmj-ByKLICj7QyY1AtLM4WMNbvGrh6xXQsTT1h6RUBt0_sX10zZ7oFu8p8qM-Xw9olvnCVxOCWCrrzx2zV2DdBW3VwQB/s1600/share.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0QSrRBA0boBYSh6Edi_TOX3GWxTI2BlIK-3p9Fhj_32f8AhjFvmj-ByKLICj7QyY1AtLM4WMNbvGrh6xXQsTT1h6RUBt0_sX10zZ7oFu8p8qM-Xw9olvnCVxOCWCrrzx2zV2DdBW3VwQB/s1600/share.gif" width="320" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
The social media sharing links point directly to your data's details.</div>
</div>
</div>
FlatMergehttp://www.blogger.com/profile/09241194909151565550noreply@blogger.com0