| #!/bin/sh | |
| # Homebrew Script for OSX | |
| # To execute: save and `chmod +x ./brew-install-script.sh` then `./brew-install-script.sh` | |
| echo "Installing brew..." | |
| /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" | |
| echo "Installing brew cask..." | |
| brew tap homebrew/cask |
| #!/usr/bin/env bash | |
| # Install command-line tools using Homebrew. | |
| # Ask for the administrator password upfront. | |
| sudo -v | |
| # Keep-alive: update existing `sudo` time stamp until the script has finished. | |
| while true; do sudo -n true; sleep 60; kill -0 "$$" || exit; done 2>/dev/null & |
| RAL | RGB | HEX | German | English | French | Spanish | Italian | Nederlands | |
|---|---|---|---|---|---|---|---|---|---|
| RAL 1000 | 190-189-127 | #BEBD7F | Grünbeige | Green beige | Beige vert | Beige verdoso | Beige verdastro | Groenbeige | |
| RAL 1001 | 194-176-120 | #C2B078 | Beige | Beige | Beige | Beige | Beige | Beige | |
| RAL 1002 | 198-166-100 | #C6A664 | Sandgelb | Sand yellow | Jaune sable | Amarillo arena | Giallo sabbia | Zandgeel | |
| RAL 1003 | 229-190-001 | #E5BE01 | Signalgelb | Signal yellow | Jaune de sécurité | Amarillo señales | Giallo segnale | Signaalgeel | |
| RAL 1004 | 205-164-052 | #CDA434 | Goldgelb | Golden yellow | Jaune or | Amarillo oro | Giallo oro | Goudgeel | |
| RAL 1005 | 169-131-007 | #A98307 | Honiggelb | Honey yellow | Jaune miel | Amarillo miel | Giallo miele | Honinggeel | |
| RAL 1006 | 228-160-016 | #E4A010 | Maisgelb | Maize yellow | Jaune maïs | Amarillo maiz | Giallo polenta | Maisgeel | |
| RAL 1007 | 220-156-000 | #DC9D00 | Narzissengelb | Daffodil yellow | Jaune narcisse | Amarillo narciso | Giallo narciso | Narcissengeel | |
| RAL 1011 | 138-102-066 | #8A6642 | Braunbeige | Brown beige | Beige brun | Beige pardo | Beige marrone | Bruinbeige |
| #!/usr/bin/env python | |
| #based off this gist https://gist.github.com/benallard/8042835 | |
| #modified it a little so it worked for my needs. (mainly encoding issues and bigger file chunks) | |
| import os | |
| import xml.parsers.expat | |
| from xml.sax.saxutils import escape | |
| from optparse import OptionParser | |
| from math import log10 |
| LAcode | geog_LA | Ecode | |
|---|---|---|---|
| E06000001 | Hartlepool | E0701 | |
| E06000002 | Middlesbrough | E0702 | |
| E06000003 | Redcar and Cleveland | E0703 | |
| E06000004 | Stockton-on-Tees | E0704 | |
| E06000005 | Darlington | E1301 | |
| E06000006 | Halton | E0601 | |
| E06000007 | Warrington | E0602 | |
| E06000008 | Blackburn with Darwen | E2301 | |
| E06000009 | Blackpool | E2302 |
| E06000001 | Hartlepool | E0701 | |
|---|---|---|---|
| E06000002 | Middlesbrough | E0702 | |
| E06000003 | Redcar and Cleveland | E0703 | |
| E06000004 | Stockton-on-Tees | E0704 | |
| E06000005 | Darlington | E1301 | |
| E06000006 | Halton | E0601 | |
| E06000007 | Warrington | E0602 | |
| E06000008 | Blackburn with Darwen | E2301 | |
| E06000009 | Blackpool | E2302 |
The instructions in the official getting started are tailored to Windows and AddressBase premium. This is a simple guide for those working on mac using Addressbase Plus.
You should received a zip file with the following folder structure when unzipped;
ABFLGB_CSV
|
+-- data
| |-- AddressBasePlus_FULL_2018-03-19_001.csv
| #!/bin/sh | |
| ### BEGIN INIT INFO | |
| # Provides: GeoServer | |
| # Required-Start: $local_fs $network $named $time $syslog | |
| # Required-Stop: $local_fs $network $named $time $syslog | |
| # Default-Start: 2 3 4 5 | |
| # Default-Stop: 0 1 6 | |
| # Description: Starts and stops the GeoServer, which should be located at /usr/share/geoserver | |
| ### END INIT INFO |
At the time of writing, Python v3.6 and PIP v19.0.3 were available on AWS EC2.
sudo yum update -y
sudo yum install python36 -y
| --Head to doogal and get the data you need | |
| --https://www.doogal.co.uk/PostcodeDownloads.php | |
| --then create the table as below, metadata as | |
| --https://www.doogal.co.uk/PostcodeCsvFields.php | |
| CREATE TABLE doogal_data.postcodes ( | |
| postcode character varying(8) PRIMARY KEY, | |
| in_use character varying(3), | |
| latitude numeric(9,6), | |
| longitude numeric(9,6), |