Skip to content

Instantly share code, notes, and snippets.

Avatar

Tim Martin TimJMartin

View GitHub Profile
View gist:d679b161f49c6137873a0b02f79fc3c5
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
View gist:b7168272513f296ca4c48344b4a0b2ed
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"
View gist:22b9bafd386f1dc7332ad80498aec865
<!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 Nov 29, 2017
Building GDAL on Docker Amazon Linux Image
View gist:d2863fd815ff975c25fda4d985771557
# 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
View gist:7b96fb8b94c36418e86dc17ab2da6ee7
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.
View gist:bba3b74b857c9e8aa003225ede6fad02
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 Aug 9, 2016
Some very useful PostgreSQL/PostGIS queries and functions
View A Useful PostGIS queries and functions
The following is a set of useful PostGIS queries and functions
@TimJMartin
TimJMartin / index.js
Created Apr 28, 2016
NodeJS Script for finding just zip files from a path
View index.js
//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 Mar 8, 2016
POI Classifications SQL
View POI Classifications
--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
View Configure node-gdal and electron
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