Nathan Rzepecki lionslair

randomecho / australian-postcodes.sql

Last active January 16, 2025 03:34

Australian postcodes (with states and suburb names) geocoded with latitude and longitude.

	/*
	Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod

	May contain errors where latitude and longitude are off. Use at own non-validated risk.
	*/

	SET NAMES utf8;
	SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

	DROP TABLE IF EXISTS postcodes_geo;

mnem / git_fetch_pull_all_subfolders.sh

Created December 6, 2011 14:35

Simple bash script for fetching and pulling all repos in the executed folder to the latest of the branch they are on

	#!/bin/bash

	################
	# Uncomment if you want the script to always use the scripts
	# directory as the folder to look through
	#REPOSITORIES="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
	REPOSITORIES=`pwd`

	IFS=$'\n'