Skip to content

Instantly share code, notes, and snippets.

@ashaw

ashaw/jankycs.sh

Last active March 21, 2018 15:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ashaw/0628b395a3ffd693e46b387cf725d03c to your computer and use it in GitHub Desktop.
Save ashaw/0628b395a3ffd693e46b387cf725d03c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
jankycs.sh
jankycs() {
echo "select st_astext(st_transform(st_setsrid(st_point($2, $1), 4326), 3857));" | psql houston-rain -t | perl -pe 's/[^\d\.\- ]//g' | perl -pe 's/^ //g';
printf '\n'
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment