Sets points lat,lng to lng,lat which is the prefferred format for postgis
UPDATE "Locations" SET geo = point(geo[1], geo[0]);
corban baxter corbanb
corbanb
/ cities.json
Created
October 16, 2017 21:39
— forked from Miserlou/cities.json
1000 Largest US Cities By Population With Geographic Coordinates, in JSON
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
| [ | |
| { | |
| "city": "New York", | |
| "growth_from_2000_to_2013": "4.8%", | |
| "latitude": 40.7127837, | |
| "longitude": -74.0059413, | |
| "population": "8405837", | |
| "rank": "1", | |
| "state": "New York" | |
| }, |
corbanb
/ gist:fb652d43939423e3f4d95cae0c3e347c
Created
February 24, 2017 00:49
— forked from bento-n-box/gist:694981de8b248f7e001c4bebab5df6ed
Open git pull request alias
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
| function create_branch_pr { | |
| branch=$(git symbolic-ref HEAD | sed -e 's,.*/\(.*\),\1,') | |
| remote=$(git config remote.origin.url | cut -d. -f1-2) | |
| echo "$remote/compare/develop...updates/$branch" | |
| } | |
| alias opr='open -a /Applications/Google\ Chrome.app $(create_branch_pr)' |
corbanb
/ pre-request-jwt.js
Last active
July 22, 2024 13:12
JWT tokenize - Postman Pre-Request Script
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
| function base64url(source) { | |
| // Encode in classical base64 | |
| encodedSource = CryptoJS.enc.Base64.stringify(source); | |
| // Remove padding equal characters | |
| encodedSource = encodedSource.replace(/=+$/, ''); | |
| // Replace characters according to base64url specifications | |
| encodedSource = encodedSource.replace(/\+/g, '-'); | |
| encodedSource = encodedSource.replace(/\//g, '_'); |
corbanb
/ post-merge
Created
May 20, 2016 23:59
— forked from sindresorhus/post-merge
git hook to run a command after `git pull` if a specified file was changed. In this example it's used to run `npm install` if package.json changed and `bower install` if `bower.json` changed. Run `chmod +x post-merge` to make it executable then put it into `.git/hooks/`.
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
| #/usr/bin/env bash | |
| # MIT © Sindre Sorhus - sindresorhus.com | |
| # git hook to run a command after `git pull` if a specified file was changed | |
| # Run `chmod +x post-merge` to make it executable then put it into `.git/hooks/`. | |
| changed_files="$(git diff-tree -r --name-only --no-commit-id ORIG_HEAD HEAD)" | |
| check_run() { | |
| echo "$changed_files" | grep --quiet "$1" && eval "$2" |
corbanb
/ profanity.csv
Created
May 9, 2016 22:56
— forked from tjrobinson/profanity.csv
Profanity list for use with content filters
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
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
| amcik | |
| arse | |
| arsehole | |
| arserape | |
| arsewipe | |
| ass | |
| asses | |
| asshole | |
| assholes | |
| assramer |
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
| # Opens the bitbucket page for the current git repository in your browser | |
| function bit() { | |
| giturl=$(git config --get remote.origin.url) | |
| if [ "$giturl" == "" ] | |
| then | |
| echo "Not a git repository or no remote.origin.url set" | |
| exit 1; | |
| fi |
corbanb
/ cleanup-ssh.sh
Created
January 3, 2016 22:39
— forked from fiznool/cleanup-ssh.sh
Private Repository Deployment. As seen at http://fiznool.com/blog/2015/05/20/an-alternative-to-npm-private-modules/
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
| #!/bin/bash | |
| if [ "$GIT_SSH_KEY" != "" ]; then | |
| echo "Cleaning up SSH config" >&1 | |
| echo "" >&1 | |
| # Now that npm has finished running, | |
| # we shouldn't need the ssh key/config anymore. | |
| # Remove the files that we created. | |
| rm -f ~/.ssh/config | |
| rm -f ~/.ssh/deploy_key |
Below is a quick start guide to developing node.js on OSX. These tools and settings will give you just about everything you would need on a clean install of OSX 10.10.X to get setup and coding.
Source - Here
Here's the query that will return the names of the tables defined in the current database:
NewerOlder