TimJMartin

#-------------------------------------------------------------------------------
# Name:        `AddressBase Premium Create Table SQL
# Purpose:     `This SQL code is to be used along side the Getting Started Guide
#				to setup the AddressBase Premium tables within a database
# Created:     `12/08/2014
# Copyright:   `Crown Copyright (c) Ordnance Survey 2014
# Licence:     `THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
#               "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
#               LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
#               FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE

TimJMartin

#!/usr/bin/env python
"""
PREREQUISITE

	Python 2.7 - this script has only been tested against Python 2.7

SYNOPSIS

    To run script: python AddressBasePremium_RecordSplitter.py

TimJMartin

#-------------------------------------------------------------------------------
# Name:        `AddressBase Premium Lookup Table SQL
# Purpose:     `This SQL code can be used to create a new lookup table which contains
#		the core attributes of AddressBase Premium. This code will work if
#		the user has the same table names/structure as described in the Getting
#		Started Guide found on the AddressBase Premium product page.
# Created:     `12/08/2014
# Copyright:   `Crown Copyright (c) Ordnance Survey 2014
# Licence:     `THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
#               "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT

TimJMartin

#-------------------------------------------------------------------------------
# Name:        `AddressBase Premium GAWK Script
# Purpose:     `This code is to be used along side the Getting Started Guide
#		which explains the process to use GAWK to split the CSV files
#		by record identifier.
# Created:     `12/08/2014
# Copyright:   `Crown Copyright (c) Ordnance Survey 2014
# Licence:     `THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
#               "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
#               LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS

TimJMartin

Installing NodeJS
http://blog.izs.me/post/87525128203/how-to-install-node-js-and-npm-on-ubuntu-14-04
sudo add-apt-repository ppa:chris-lea/node.js
sudo apt-get update
sudo apt-get install nodejs

Install Unzip
sudo apt-get install unzip

TimJMartin

Install node 4.2.1
Use HTML and main.js from electron getting started guide
Configure package.json to include:
 "dependencies": {
    "gdal": "naturalatlas/node-gdal#win-node-4.2.1"
  }
  
  Then install electron rebuild which recompiles native node modules.
  
  npm install --save-dev electron-rebuild

TimJMartin

--SQL to create POI Classifications Table

DROP TABLE IF EXISTS poi.classifications;
COMMIT;

CREATE TABLE IF NOT EXISTS poi.classifications(
   CLASSIFCATION_CODE   VARCHAR(8) NOT NULL PRIMARY KEY
  ,GROUP_ID             VARCHAR(2) NOT NULL
  ,GROUP_DESCRIPTION    VARCHAR(34) NOT NULL
  ,CATEGORY_ID          VARCHAR(2) NOT NULL

TimJMartin

//Code snipped to use recursive-readdir to provide a list of required file types.
var path = require('path');
var recursive = require('recursive-readdir');

function ignoreFunc(file, stats) {
  // `file` is the absolute path to the file and we can use extname to look at the file extension
  return stats.isFile() && path.extname(file) != ".zip";
}

// Ignore files using the ignroeFunc

TimJMartin

The following is a set of useful PostGIS queries and functions

TimJMartin

swagger: '2.0'
info:
  version: 1.0.0
  title: Building Geospatial APIs
  description: Getting started with OpenAPI Specification
schemes:
  - http
  - https
paths:
  /message: