tag:blogger.com,1999:blog-4953008377950396317.post6332783368016685362..comments2024-03-28T12:31:21.785-07:00Comments on SearchReSearch: Answer: Earthquake data?Dan Russellhttp://www.blogger.com/profile/13603209997260423532noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-4953008377950396317.post-18934990092525162742014-08-12T17:07:19.215-07:002014-08-12T17:07:19.215-07:00I changed coordinates. I used West = -128, North =...I changed coordinates. I used West = -128, North = 30, East = -62, South = 16. I did that to cover all Mexico and not just part as in my previous post in which I did a mistake. Total earthquakes 1946.<br /><br /><a href="https://drive.google.com/file/d/0B9uTWQGfExsWcjBFMGI5UU83eDQ/edit?usp=sharing" rel="nofollow">Heat Map</a><br /><br /><a href="https://drive.google.com/file/d/0B9uTWQGfExsWS2FkaDdrRHFnWFU/edit?usp=sharing" rel="nofollow">Histogram </a> Ramon Gonzalezhttps://www.blogger.com/profile/16129830563029534511noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-85574401142923571252014-08-12T15:11:42.932-07:002014-08-12T15:11:42.932-07:00Hello Dr. Russell. I just did a Heat map with the ...Hello Dr. Russell. I just did a Heat map with the same coordinates. Just changed South from 20 to 18. I need to verify data because no earthquakes are shown for Guerrero or Michoacan in 2013 and 2014 in the USGS data. I have from 2004 to 2014 (filtering shows only until 2012) in those two states only 357 earthquakes. <br /><br /><a href="https://drive.google.com/file/d/0B9uTWQGfExsWQ0JmN0kxNGpyZVU/edit?usp=sharing" rel="nofollow"> Heat map south 18 instead of 20</a><br /><br />I'll keep you posted.<br /><br /><br />Ramon Gonzalezhttps://www.blogger.com/profile/16129830563029534511noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-84608826497704605072014-08-12T14:27:21.639-07:002014-08-12T14:27:21.639-07:00Hi Dan -- I would love to learn ""how (y...Hi Dan -- I would love to learn ""how (you did) that spreadsheet trick with the USGS data" by watching your video.<br /><br />-- Mikealmadenmikehttps://www.blogger.com/profile/12636400853368185828noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-58599659257156739652014-08-12T13:45:07.765-07:002014-08-12T13:45:07.765-07:00The issue appears to be the USGS application doesn...The issue appears to be the USGS application doesn't work well with Chromebook. It won't download more than 2000 on "my device". In fact I am unable to download directly from the CSV option. The only way I got it to work previously is by using the "map & list" option & restricting it to 2000 rows. <br /><br />I've discovered the issue with Google Drive is the 'new' google drive is not working well on my chromebook. I can work with the table using the old Drive format. I will get it sorted.<br /><br />Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-30321342547099426972014-08-12T11:33:31.668-07:002014-08-12T11:33:31.668-07:00I just tried =split(E2,",") on the "...I just tried =split(E2,",") on the "cleaned up data" on my copy of your data. It seemed to work, but then began giving errors where the place is just listed as Northern California or just Wyoming when there was no comma to act as the delimiter. krossbowhttps://www.blogger.com/profile/07877826327758153784noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-75942377591501538162014-08-12T11:23:10.125-07:002014-08-12T11:23:10.125-07:00Excellent. That's a nice way to do it as well...Excellent. That's a nice way to do it as well. (And better than what I suggest above!) <br /><br />The SPLIT function is much more robust than using string manipulation functions. <br /><br />Note, though , that I wasn't able to figure out a way to use SPLIT to get to the state in the "location" column. (I could do that in AppScript, but I was trying to stay out of that....) <br />Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-7616231812103944732014-08-12T11:21:44.841-07:002014-08-12T11:21:44.841-07:00You're probably correct--it's the injectio...You're probably correct--it's the injection that's causing the issues. (But where does that waste liquid come from? Fracking...) <br />Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-80014065704932551062014-08-12T11:21:08.764-07:002014-08-12T11:21:08.764-07:00See my post on Tuesday (8/12/14) See my post on Tuesday (8/12/14) Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-68876979581528075652014-08-12T11:20:56.937-07:002014-08-12T11:20:56.937-07:00If you use Google Spreadsheets, you shouldn't ...If you use Google Spreadsheets, you shouldn't have any "row limit" problems. I've got spreadsheets with more than 10K rows. (And Fusion Tables can be gigantic!) <br />Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-43828095633028128382014-08-12T11:19:35.571-07:002014-08-12T11:19:35.571-07:00I think that I just didn't include ALL of Mexi...I think that I just didn't include ALL of Mexico in my data pull from USGS. You should give it the proper coordinates for Mexico, re-run the analysis, and tell us what you find! <br />Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-6116677584991927612014-08-12T11:18:45.010-07:002014-08-12T11:18:45.010-07:00See my video. The short answer is that I'd us...See my video. The short answer is that I'd use a spreadsheet function (something like =mid(n3, 7, 12) ) to pull out the date. You can then use that same method to pull out month, etc. <br /><br />I haven't yet done the summer/month graph. Will get around to it soon. <br />Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-46085668182777128492014-08-12T08:07:42.456-07:002014-08-12T08:07:42.456-07:00Thanks Fred! Looks great.
I was just thinking abo...Thanks Fred! Looks great.<br /><br />I was just thinking about <i> Split and Concatenate </i> Functions. Dr. Russell's way to separate data from columns is better and also more not basic. It is great to learn new tricks and functions. <br /><br />Rosemary you can use the Split function as Fred mentions to un-merge data from columns. You need =Split (A2, ";") for example in the cell and the necessary clear and free columns next to separate the values. You can change " " for space, period, or other. Here is an <a href="https://sites.google.com/a/slu.edu/tips/home/combiningandsplittingdatainspreadsheets" rel="nofollow">example</a><br /><br />Also I learned why I couldn't make it work the LAT/LONG rectangle and why Dr. Russell's heat map doesn't show Mexico. In the first case I entered wrong the coordinates. I didn't add the correct set of values. We need in some Lat and others Long, I just took one. In the second. Mexico City is at 19.43 N. Ramon Gonzalezhttps://www.blogger.com/profile/16129830563029534511noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-8631424226654264742014-08-12T06:13:55.991-07:002014-08-12T06:13:55.991-07:00I went ahead and pulled out the month data because...I went ahead and pulled out the month data because I was curious. I made a copy of your sheets. <br />For each of the state data I used the SPLIT function to separate Year-Month-Day into separate columns. <br />Used COUNTIF for each month. <br /><br />Changed the Summary page to graph the number of quakes per month. <br /><br /><a href="https://docs.google.com/spreadsheets/d/1RxdpxbPcumfNE7YqEqmMnAl7AcR-wSpi5L9WRrrrrws/edit?usp=sharing" rel="nofollow">Copy of Dr. Russell's Earthquake Data</a>krossbowhttps://www.blogger.com/profile/07877826327758153784noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-84686039266680845422014-08-11T18:58:04.710-07:002014-08-11T18:58:04.710-07:00PUBLISH failed yet again..................this is ...PUBLISH failed yet again..................this is PREVIEW<br /><br />Dan, Sign me up to see just what you did with the CSV data. I got that far myself but then had no idea how to proceed from there.<br /><br />Did I get this right ? It's not the fracking causing the EQs but the massive waste water injections. Four in particular in OK.<br /><br />Good pertinent topic for me.<br /><br />jon tUjonhttps://www.blogger.com/profile/06450649073262987652noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-8425103578683523232014-08-11T14:39:32.503-07:002014-08-11T14:39:32.503-07:00Just got this link to "merge values" I a...Just got this link to "merge values" I am guessing we need to "unmerge". How you can look in a cell and separate with a comma the data, amazing to me. http://goo.gl/GlmPf3Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-84810546316697970662014-08-11T13:02:58.979-07:002014-08-11T13:02:58.979-07:00Of course I would like to see how you did your mag...Of course I would like to see how you did your magic. I created a copy of your table & explored the funciton & filter aspects but I don't know how you extracted the state which you may recall is where I got stuck with the challenge. My chromebook is not powerful enough to handle a file that size I discovered. When I downloaded the data originally from USGS I was limited to 2000 rows (not sure what was not included in the limited data & what was excluded). For anyone else facing limitations when I copy Dr. Dan's table to Google Drive it overwhelmed my Chromebook & the only way I found to delete that file was reverting back to the old Google Drive. While the old Google Drive seems to better handle the file, I still don't know how to do the magic.<br /><br />The question I have relates to what I was trying to accomplish. Could a scatter chart (or perhaps trend chart) be created showing seasonality ie. # of earthquakes, month of occurrence, over a ten year period and what would it look like? For example we see the numbers in California in the past ten years are significant especially in 2010. Maybe in Fusion Tables, a heatmap using "buckets" to show what month & where. I'd give it a try but because I had issues with the file size in Google Drive I will hold off.<br /><br />And as a side note this weekend we had an earthquake & its the first over 4.0 since 2001. Not huge but definitely unusual for our area. http://goo.gl/5TSPK4 http://goo.gl/dS8T5J Interesting timing!<br /><br />Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-55795542475741631732014-08-11T11:41:46.910-07:002014-08-11T11:41:46.910-07:00Please, show us more details on "how did you ...Please, show us more details on "how did you do that spreadsheet trick with the USGS data?"DeltaCubedhttps://www.blogger.com/profile/07167385778499681085noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-70475815809965888552014-08-11T08:25:05.337-07:002014-08-11T08:25:05.337-07:00Hello Dr. Russell. Good Morning!
I tried the way ...Hello Dr. Russell. Good Morning!<br /><br />I tried the way you did it. I always had problems inserting the coordinates. Then looked for another way. I'd love to see the video of how you did it. Your explanation is very clear and a video is a way to keep it in mind easy and to verify if I understood right.<br /><br />In your heat map, just a curiosity. I thought Mexico City and Guerrero will had more color in the heat map. Never thought that in those years Chihuahua and Monterrey could had the color.<br /><br />I am sure that in this year (2014) heat map will show center of Mexico in red. Too many earthquakes and not fracking...yet. <a href="http://www.eastbayexpress.com/oakland/how-fracking-causes-earthquakes/Content?oid=3868227" rel="nofollow">How Fracking Causes Earthquakes</a><br /><br />Also related to that. I recently read that places that had big hurricanes or big amount of water flood; the next year most likely will have an earthquake. [hurricane AROUND(3) earthquakes] results have more information.<br /><br />Thanks for the tip of the metadata and of course for the SearchResearch Challenge and lesson. <br />Ramon Gonzalezhttps://www.blogger.com/profile/16129830563029534511noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-24937498706159176722014-08-11T08:20:52.863-07:002014-08-11T08:20:52.863-07:00How did you do that spreadsheet trick with the USG...How did you do that spreadsheet trick with the USGS data?<br /><br />Specifically, how would you pull out and graph the months that the earthquakes happen? Would we see the correlation of more earthquakes during the summer months? krossbowhttps://www.blogger.com/profile/07877826327758153784noreply@blogger.com