Skip to content

Instantly share code, notes, and snippets.

View keithamoss's full-sized avatar

Keith Moss keithamoss

  • Perth, Australia
View GitHub Profile
CREATE TABLE test (
id SERIAL PRIMARY KEY,
"StateCo" character varying,
"StateAb" character varying,
"DivName" character varying,
"DivId" character varying,
"DivCo" character varying,
"PPName" character varying,
"Status" character varying,
"PremisesName" character varying,
We can't make this file beautiful and searchable because it's too large.
StateCo,StateAb,DivName,DivId,DivCo,PPName,Status,PremisesName,Address1,Address2,Address3,Locality,AddrStateAb,Postcode,PPId,AdvPremisesName,AdvAddress,AdvLocality,AdvBoothLocation,AdvGateAccess,EntrancesDesc,Lat,Long,CCD,WheelchairAccess,OrdVoteEst,DecVoteEst,NoOrdIssuingOff,NoOfDecIssuingOff
"2","NSW","Banks","103","1","Allawah","Current","P J Ferry Hall","cnr Bellevue Pde & Blakesley Rd","","","ALLAWAH","NSW","2218","31","P J Ferry Hall","cnr Bellevue Pde & Blakesley Rd","ALLAWAH","","","Blakesley Rd Bellevue Pde","-33.9767897","151.1148974","1137911","Assisted","1443","211","4","2"
"2","NSW","Banks","103","1","Allawah South","Current","St Raphael's Church Hall","84 George St","","","SOUTH HURSTVILLE","NSW","2221","67","St Raphael's Church Hall","84 George St","SOUTH HURSTVILLE","","","George St","-33.9756000","151.1110000","1137414","Assisted","997","106","3","1"
"2","NSW","Banks","103","1","Beverly Hills North (Banks)","Current","Beverly Hills North Public School","1-3 Shorter Ave","","","BEVERLY HILLS",
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width,initial-scale=1.0">
<title>Example</title>
</head>
<body>
<h1>Example</h1>
</body>
{
"id": 45458,
"name": "b5222",
"tableinfo_id": 376,
"metadata_json": {
"kind": "Semi-detached\\ row or terrace house\\ townhouse etc.",
"type": "Mortgage repayment not stated Dwelling structure Semi detached row or terrace house townhouse etc"
},
"geomlinkage": {
"id": null,
@keithamoss
keithamoss / convert.py
Created November 27, 2016 12:01
Convert GeoScience Australia XBM files to SVG for QGIS users.
import os
from wand.image import Image
xbm_path = os.path.join(os.getcwd(), "xbm")
for infile in os.listdir(xbm_path):
infile_path = os.path.join(xbm_path, infile)
if os.path.isfile(infile_path):
print infile
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@keithamoss
keithamoss / small-geom-first.json
Created October 14, 2016 04:46
A GeoJSON dataset with two polygons (small polygon first, large polygon second)
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Heatmaps</title>
<style>
html, body {
height: 100%;
margin: 0;
padding: 0;
// controls: ol.control.defaults({
// attributionOptions: /** @type {olx.control.AttributionOptions} */ ({collapsible: false})
// }),
controls: [
new ol.control.Rotate(),
new ol.control.Attribution({collapsible: false})
],