Joshua Kemmerling joshuakemmerling
joshuakemmerling
/ sql-geo.sql
Last active
May 25, 2018 12:43
This is a SQL query for nearest places using latitude and longitude. Uses “as the crow flies” equation.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT id, name, latitude, longitude, (3959 * acos(cos(radians({$this->lat})) * cos(radians(latitude)) * cos(radians(longitude) - radians({$this->lng})) + sin(radians({$this->lat})) * sin(radians(latitude)))) AS distance | |
| FROM trailers | |
| WHERE latitude IS NOT NULL | |
| ORDER BY distance |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| module.exports = function (grunt) { | |
| grunt.initConfig({ | |
| connect: { | |
| server: { | |
| options: { | |
| port: 8080, | |
| hostname: '*', | |
| keepalive: true, | |
| onCreateServer: function (server, connect, options) { }, | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://petapixel.com/2015/02/21/a-practical-guide-to-creating-superresolution-photos-with-photoshop/ | |
| Camera Settings | |
| - Handheld | |
| - f/5.6 to f/11 | |
| - Hand holdable shutter speed – 1/(2*focal length) recommended | |
| - Lower ISOs are preferable, set as f/number and shutter dictate for a neutral exposure or set Auto ISO | |
| - Continuous burst mode – minimum of 20 images | |
| - RAW |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # http://rubular.com/ | |
| def shortcode (input) | |
| regex = /\[([a-zA-Z0-9]+\s.+)\]/i | |
| matches = regex.match(input) | |
| splits = matches[1].split(" ") | |
| attrs = Hash.new | |
| splits[1, splits.length].each do |attr| | |
| attr = attr.strip().split("=") |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var BrowserDetect = | |
| { | |
| init: function () | |
| { | |
| this.browser = this.searchString(this.dataBrowser) || "Other"; | |
| this.version = this.searchVersion(navigator.userAgent) || this.searchVersion(navigator.appVersion) || "Unknown"; | |
| }, | |
| searchString: function (data) | |
| { | |
| for (var i = 0; i < data.length; i++) { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <style> | |
| .scrollbox { | |
| overflow: auto; | |
| width: 200px; | |
| max-height: 200px; | |
| margin: 50px auto; |
NewerOlder