tag:blogger.com,1999:blog-4953008377950396317.post1642173475495223115..comments2024-03-28T18:39:59.184-07:00Comments on SearchReSearch: Answer: Where's the lake with the... Dan Russellhttp://www.blogger.com/profile/13603209997260423532noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-4953008377950396317.post-66936173782637344822015-01-21T05:32:46.386-08:002015-01-21T05:32:46.386-08:00That's right. This is one of the data-wrangli...That's right. This is one of the data-wrangling issues that comes up. <br />Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-52374820455879341022015-01-21T05:31:53.208-08:002015-01-21T05:31:53.208-08:00I would have dug deeper. I used the Horseshoe Lak...I would have dug deeper. I used the Horseshoe Lake as an example, but I actually checked several other lakes and found similar problems. This is one of the points of this Challenge--when doing complex data analysis tasks, you ALWAYS have to double (and triple) check your work.Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-6939204314725274632015-01-21T05:30:25.633-08:002015-01-21T05:30:25.633-08:00This is a real problem (making sure all of the nam...This is a real problem (making sure all of the names of the lakes are the same). I'd hoped to tackle this question using OpenRefine, but will cover this topic in a future post. (Not this week!) Dan Russellhttps://www.blogger.com/profile/13603209997260423532noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-19075125683754195462015-01-17T11:55:35.029-08:002015-01-17T11:55:35.029-08:00Ok just had a thought. Thinking back to my navigat...Ok just had a thought. Thinking back to my navigating skills when using legends at the bottom of topographical maps and the settings required for gps units you needed to know which datum has been used. Datums such as NAD27, NAD83 & WGS84. Heres a wiki article on the subject. http://en.wikipedia.org/wiki/North_American_Datum<br /><br />As well declinations (magnetic vs true north) are always changing which is why before planning a trip you need up to date declinations to get accurate bearings which is available online.<br /><br />I don’t think any of this has a bearing on our results. Or does it?<br />Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-66931103540988082502015-01-17T11:18:40.671-08:002015-01-17T11:18:40.671-08:00Nice to see Ramón still working on the challenge. ...Nice to see Ramón still working on the challenge. I spent some time yesterday & I was going to wait and see what Dr.Dan had for us. But perhaps he has discovered the same problem I have seen. As you may recall I ignored the “inconsistencies” for lakes that didn’t fit the criteria we needed. But going back I looked again at Cunningham Lake. Here is a link http://cartographic.info/usa/map.php?id=258988 Specifically I refer you to the coordinates, the name and the map. If you check the List of Lakes provided by Dr. Dan you will see the degree coordinates match. If you check the Fish plantings table you’ll see decimal coordinates don’t match. If you zoom in on the map you’ll see the lake is Lockwood Lake not Cunningham Lake. What is going on? It doesn’t seem possible that CDFW would have the wrong coordinates because fishermen using this database would use their gps & these coordinates. I am absolutely stumped. Any ideas?<br />Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-19147662299222646642015-01-17T10:23:14.624-08:002015-01-17T10:23:14.624-08:00I noticed that your merged FT already has the two ...I noticed that your merged FT already has the two values for "Lat/Latitude" I am working on the formula to get the result in Spreadsheet. Did you, Dr. Russell, created the function or you downloaded results with both data on it?<br /><br />As already mentioned by Rosemary, Fish and Wildlife gives us DEC degrees. USGS for downloading gives DMS, and if we click on any name on the page shows both, but no way to download both. Ramon Gonzalezhttps://www.blogger.com/profile/16129830563029534511noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-80643516510660598082015-01-16T14:52:51.272-08:002015-01-16T14:52:51.272-08:00…is Big Jim bank fishing, trolling or setting a 32...…is Big Jim bank fishing, trolling or setting a 32 mile modified drift net for Goldens on <a href="http://www.hikingwalking.com/destinations/ca/ca_ses/lone_pine/cottonwood_lakes/cottonwood_lakes_fullpagemap" rel="nofollow">Cottonwood number 3…?</a> I feel like I've been banging my head at the 5.9' elevation at the base of the Dawn Wall with this prolonged sear…zzzzZZZzzzzch.<br /><a href="http://news.nationalgeographic.com/news/2015/01/150114-climbing-yosemite-caldwell-jorgeson-capitan/" rel="nofollow">NatGeo - i became distracted…</a><br /><a href="http://news.nationalgeographic.com/news/2015/01/150115-yosemite-climbers-caldwell-jorgeson-dawn-wall-adventure/?utm_source=Twitter&utm_medium=Social&utm_content=link_twngm20150115after-el-cap-climb&utm_campaign=Content&sf6956233=1" rel="nofollow">TC or KJ may have had a fish in their pockets?</a><br /><a href="http://www.nytimes.com/2015/01/15/sports/el-capitans-dawn-wall-climbers-near-top-yosemite.html?_r=0" rel="nofollow">afterwards, NYT</a><br /><a href="http://i.dailymail.co.uk/i/pix/2015/01/15/24B9740300000578-2911580-image-a-14_1421336700139.jpg" rel="nofollow">9.5 fingers</a><br /><a href="http://www.dailymail.co.uk/news/article-2911580/Shocking-toll-taken-El-Capitan-Yosemite-conquerors-hands.html" rel="nofollow">good visuals</a><br />…where did I leave my Fission Table in Fig 14? …is today tomorrow yet?remmijhttps://www.blogger.com/profile/17985809654574916217noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-59160487906823623482015-01-15T17:09:45.221-08:002015-01-15T17:09:45.221-08:00Whether we use a batch coordinate converter http:/...Whether we use a batch coordinate converter http://www.earthpoint.us/BatchConvert.aspx<br />or if a function can be completed within Google Sheets I would say this can be done without one by one conversions. That being said, I haven't tried. Its getting both sets of data using one definite common reference that makes each row of data unique & cross-matched. At least I think that may be the necessary step required.Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-17080596905278425722015-01-15T13:49:29.508-08:002015-01-15T13:49:29.508-08:00You are right, Rosemary. We can add a column with ...You are right, Rosemary. We can add a column with coordinates in the same unit Decimal or "degrees minutes and seconds". My approach was different. I believe it is easier to find match between lakes planted and elevation and with those search for coordinates. Other option is select in USGS only North part of California.Ramon Gonzalezhttps://www.blogger.com/profile/16129830563029534511noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-64373112786953146682015-01-15T10:59:18.839-08:002015-01-15T10:59:18.839-08:00Tim brings up an excellent example of how difficul...Tim brings up an excellent example of how difficult managing the data can be. In your merged table first we have the list of lakes data and to the right we have the fish planting data merged. The list of lakes uses the DMS coordinates (degrees minutes and seconds) and to the right we see coordinates lat/long. The list of lakes DMS coordinates are different for each record but to the right through merging we get lat/long repeats exactly the same. I think that occurred based on how the sheets are merged by Fusion. We likely need to use the same coordinates systems to get true merging. Names alone are not sufficient. Ideally we would have a single reference that matched in both sets of data but this is not the case as is. <br />Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-54318353030085981422015-01-15T10:12:55.741-08:002015-01-15T10:12:55.741-08:00I have on a few occasions tackled a similar type o...I have on a few occasions tackled a similar type of challenge to this, comparing data on First Nation reserves in Canada, for example mapping the communities that have boil water advisories. It reminds me of this challenge because each reserve can have multiple different names with multiple different spelling, or sometimes be referred to by a number, and their are unassociated communities in different parts of Canada that have the same name. <br /><br />In these cases doing a merge by name, gives you some very messy results. I cleaned the data I was using manually, by looking for results that didn't have any coordinates in my merged table and looking at each of those communities one by one to find their Lat/Long. I am curious to see how you tackled this lake data. Anonymoushttps://www.blogger.com/profile/05771391220758627361noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-16074806271821245302015-01-15T05:40:22.356-08:002015-01-15T05:40:22.356-08:00Good morning, Dr. Russell.
I'm rereading the ...Good morning, Dr. Russell.<br /><br />I'm rereading the first answer. It is very interesting all your work and how you are solving it.<br /><br />I have some technical questions:<br />A) When you downloaded lakes, why you didn't select only the ones with elevation 8000 or more?<br />B)In fish planting, you selected announced date, that is data not just for the 15 time window, right? Why you first created a spreadsheet and not directly a FT? I did first in all cases spreadsheet first, and now I noticed that I can avoid that.<br /><br />About your questions, I think that maybe coordinates only give one specific point not all the space that Lakes and Reservoirs have. In the fishing planting, maybe it needs a special entry point and that is why coordinates vary so much.<br /><br />Looking forward for answer part 2 and 3. Have great day Ramon Gonzalezhttps://www.blogger.com/profile/16129830563029534511noreply@blogger.comtag:blogger.com,1999:blog-4953008377950396317.post-31940632164160988342015-01-14T17:35:04.833-08:002015-01-14T17:35:04.833-08:00I came upon the same issue when I had identified P...I came upon the same issue when I had identified Pyramid, Little Lake, Cunningham Lake. Not Horseshoe Lake because no planting had been done in our time frame and in fact that still is in the future. When I checked Google map the lakes above were low elevations and small lakes. I didn’t understand it but they didn’t seem to impact my results. One of them was even, I believe, in a municipal park. Had any lakes been of interest I would have dug deeper. If you had not seen the fish planting at Horselake would you have dug deeper? <br />Rosemary Mhttps://www.blogger.com/profile/12291661159622665464noreply@blogger.com