Skip to content

Instantly share code, notes, and snippets.

View TimJMartin's full-sized avatar

Tim Martin TimJMartin

10 followers · 2 following
  • Ordnance Survey
View GitHub Profile
@TimJMartin
TimJMartin / gist:d679b161f49c6137873a0b02f79fc3c5
Last active September 16, 2020 13:54
PyGeoAPI Example Config
server:
bind:
host: 0.0.0.0
port: 5000
url: http://localhost:5000
mimetype: application/json; charset=UTF-8
encoding: utf-8
language: en-US
# cors: true
pretty_print: true
@TimJMartin
TimJMartin / gist:b7168272513f296ca4c48344b4a0b2ed
Created February 18, 2019 11:52
Export PostGIS schema to GPKG
ogr2ogr --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES -f "GPKG" GPKG_Filename.gpkg -progress PG:"dbname=xxx user=xxx password=xxx active_schema=xxx schemas=xxx port=xxx host=xxx" -gt 1000000 -a_srs "EPSG:27700"
@TimJMartin
TimJMartin / gist:22b9bafd386f1dc7332ad80498aec865
Created February 5, 2019 19:47
API Workshop
<!DOCTYPE html>
<html>
<head>
<title>API Workshop</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
<link rel="stylesheet" href="http://cdnjs.cloudflare.com/ajax/libs/leaflet/1.3.1/leaflet.css" />
<style>
body { margin:0; padding:0; }
#map { position:absolute; top:0; bottom:0; width:100%; }
@TimJMartin
TimJMartin / gist:d2863fd815ff975c25fda4d985771557
Created November 29, 2017 08:48
Building GDAL on Docker Amazon Linux Image
# Base Image
FROM amazonlinux:latest
MAINTAINER Tim Martin
RUN yum update -y
RUN yum upgrade -y
RUN yum install wget -y
RUN yum install gcc -y
RUN yum install gcc-c++ -y
@TimJMartin
TimJMartin / gist:7b96fb8b94c36418e86dc17ab2da6ee7
Last active November 29, 2017 08:47
Docker Notes
To copy a file from an image to the host
docker run the-image cat path/to/container/file.txt > path/to/host/file.txt
Amazon Linux
This image can be used to replicate EC2 and AWS Lambdas so anything that needs to be built from source can be done on this docker image.
@TimJMartin
TimJMartin / gist:bba3b74b857c9e8aa003225ede6fad02
Created September 19, 2017 09:22
Swagger Example
swagger: '2.0'
info:
version: 1.0.0
title: Building Geospatial APIs
description: Getting started with OpenAPI Specification
schemes:
- http
- https
paths:
/message:
@TimJMartin
TimJMartin / A Useful PostGIS queries and functions
Last active August 9, 2016 06:59
Some very useful PostgreSQL/PostGIS queries and functions
The following is a set of useful PostGIS queries and functions
@TimJMartin
TimJMartin / index.js
Created April 28, 2016 08:53
NodeJS Script for finding just zip files from a path
//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
TimJMartin / POI Classifications
Created March 8, 2016 08:33
POI Classifications SQL
--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
TimJMartin / Configure node-gdal and electron
Created October 19, 2015 19:57
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