{"id":882,"date":"2014-07-26T16:50:41","date_gmt":"2014-07-26T20:50:41","guid":{"rendered":"http:\/\/blog.uvm.edu\/ctl-projects\/?p=882"},"modified":"2014-07-26T16:50:41","modified_gmt":"2014-07-26T20:50:41","slug":"geology-landscape-change-project-exploded-chapter-3","status":"publish","type":"post","link":"https:\/\/blog.uvm.edu\/waw\/2014\/07\/26\/geology-landscape-change-project-exploded-chapter-3\/","title":{"rendered":"Geology Landscape Change project exploded Chapter 3"},"content":{"rendered":"<p><span style=\"color: #000000\">I spent a lot of hours on this today. I think I\u2019ve nailed it down. Altered general form of Sql to<\/span><br style=\"color: #000000\" \/><br style=\"color: #000000\" \/><span style=\"color: #000000\">SELECT ls, sequence, county, town, title, PHOTOGRAPHER, images.FILENAME, MEDIA, PHOTOYEAR, PHOTOSOURCE, description, keywords, format_extent, DATUM, longitude, latitude, utm_northing, utm_easting, ELEVATION, format_creation, contributor_collector, contributor_scientific_advisor, contributor_reviewer, coverage_periodname, coverage_placename, times_viewed, PUBLIC, (longitude&#8221;&#8221; or utm_northing&#8221;&#8221;) has_location FROM images left join viewcounts on images.FILENAME=viewcounts.FILENAME where MATCH (images.FILENAME, OriginalFileName, ls, title, keywords, description, town, county, PHOTOSOURCE, PHOTODATE, PHOTOYEAR, PHOTOGRAPHER, MEDIA, identifier_citation, title_alternative, publisher) AGAINST (&#8216;+dogs&#8217; IN BOOLEAN MODE) AND (STATUS = &#8216;X&#8217;) ORDER BY title<\/span><br style=\"color: #000000\" \/><br style=\"color: #000000\" \/><span style=\"color: #000000\">Cache results using session variables<\/span><br style=\"color: #000000\" \/><br style=\"color: #000000\" \/><span style=\"color: #000000\">Extract start, limit subsets from session variables<\/span><br style=\"color: #000000\" \/><br style=\"color: #000000\" \/><span style=\"color: #000000\">PLEASE TEST, paint is still wet<\/span><br style=\"color: #000000\" \/><br style=\"color: #000000\" \/><span style=\"color: #000000\">WATCH OUR FOR out of space warnings. Session files getting pretty big<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000\">On Jul 26, 2014, at 1:58 PM, Jim Lawson  wrote:<\/span><br style=\"color: #000000\" \/><br style=\"color: #000000\" \/><\/p>\n<blockquote><p>Yes, glcp ran out of space just now.\u00a0Added 5gb of space to \/.\u00a0Weak network covg from here, so can&#8217;t do detailed troubleshooting &#8230;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>I spent a lot of hours on this today. I think I\u2019ve nailed it down. Altered general form of Sql toSELECT ls, sequence, county, town, title, PHOTOGRAPHER, images.FILENAME, MEDIA, PHOTOYEAR, PHOTOSOURCE, description, keywords, format_extent, DATUM, longitude, latitude, utm_northing, utm_easting, ELEVATION, &hellip; <a href=\"https:\/\/blog.uvm.edu\/waw\/2014\/07\/26\/geology-landscape-change-project-exploded-chapter-3\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41826],"tags":[42758,12386,45193,647],"class_list":["post-882","post","type-post","status-publish","format-standard","hentry","category-wes","tag-boffins","tag-database","tag-geology-landscape-change","tag-php"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/comments?post=882"}],"version-history":[{"count":0,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/882\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/media?parent=882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/categories?post=882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/tags?post=882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}