Tim Martin TimJMartin

GDAL and Elasticsearch examples

Shapefile

Import shapefile into Elasticsearch

ogr2ogr -f ElasticSearch \
-lco NOT_ANALYZED_FIELDS={ALL} \
http://elastic:changeme@localhost:9200 \

How to setup AWS lambda function to talk to the internet and VPC

I'm going to walk you through the steps for setting up a AWS Lambda to talk to the internet and a VPC. Let's dive in.

So it might be really unintuitive at first but lambda functions have three states.

No VPC, where it can talk openly to the web, but can't talk to any of your AWS services.
VPC, the default setting where the lambda function can talk to your AWS services but can't talk to the web.
VPC with NAT, The best of both worlds, AWS services and web.

OGR GFS Geometry Values

The geometry type of a feature class can be specified in a .gfs file used by OGR to map from a GML document to a simple feature schema. The following numbers can be used to specify a specific geometry type:

-2147483647 Point25D
-2147483646 LineString25D
-2147483645 Polygon25D
-2147483644 MultiPoint25D
-2147483643 MultiLineString25D

-2147483642 MultiPolygon25D

	sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main"
	wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc \| sudo apt-key add -
	sudo apt-get update
	sudo apt-get install postgresql-9.6

	sudo apt-get install postgresql-9.6-postgis-2.3
	sudo apt-get install postgresql-9.6-pgrouting

	sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
	sudo apt-get update

	/*
	by Martin Güther @magegu

	just call it:

	uploadFile(absoluteFilePath, callback);
	*/

	var path = require('path');
	var async = require('async');

	<!DOCTYPE html>
	<html>
	<head>
	<title>Leaflet.draw drawing and editing tools</title>
	<link
	rel="stylesheet"
	href="http://cdn.leafletjs.com/leaflet-0.7/leaflet.css"
	/>
	<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/themes/css/cartodb.css" />
	<link

	CREATE OR REPLACE FUNCTION public.json_append(data json, insert_data json)
	RETURNS json
	IMMUTABLE
	LANGUAGE sql
	AS $$
	SELECT ('{'\|\|string_agg(to_json(key)\|\|':'\|\|value, ',')\|\|'}')::json
	FROM (
	SELECT * FROM json_each(data)
	UNION ALL
	SELECT * FROM json_each(insert_data)

	--PART 2
	-- a.
	SELECT * FROM tornados
	SELECT cartodb_id FROM tornados
	-- b.
	SELECT * FROM tornados LIMIT 1
	SELECT * FROM tornados LIMIT 1 OFFSET 1
	SELECT * FROM tornados ORDER BY damage DESC LIMIT 10
	-- c.
	SELECT * FROM tornados WHERE cartodb_id < 30

	require 'active_support/core_ext/string/filters'

	module PostgresTimestampDefaults
	def add_timestamp_defaults(table_name)
	add_default_now(table_name, :created_at)
	add_default_now(table_name, :updated_at)
	add_updated_at_trigger(table_name)
	end

	def add_default_now(table_name, column_name)

	<!doctype html>
	<html>
	<head>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.4/leaflet.css" />
	<link rel="stylesheet" href="http://asset.geosprocket.com/leaflet/cluster/MarkerCluster.Default.css" />
	<!--[if lte IE 8]>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.6.4/leaflet.ie.css" />
	<link rel="stylesheet" href="http://asset.geosprocket.com/leaflet/cluster/MarkerCluster.Default.ie.css" />
	<![endif]-->
	<style type="text/css">