Shoaib Burq sabman

CartoDB's MVT service + Mapbox GL

Check index.html for some examples. These use a beta feature of CartoDB's Maps API: fixed URLs. So there is no need to use cartodb.js and tiles can be consumed using a named map name.

cartodb.js example

Check cartodb.js.html to see the integration with cartodb.js and in particular with cartodb.core.js.

Mapbox GL resources

API reference

Nocturnal bird migration forward trajectory classified by airspeed into songbirds and waterbirds - Night of April 7-8, 2013

https://inbo.cartodb.com/u/lifewatch/viz/88c30be4-1063-11e5-a9ae-0e853d047bba/public_map

SQL

SELECT *,
	CASE
		WHEN airspeed = 0 THEN 0

Libraries for a modern geospatial workflow

Distribution

Numpy

Apache Spark installation + ipython/jupyter notebook integration guide for macOS

Tested with Apache Spark 2.1.0, Python 2.7.13 and Java 1.8.0_112

For older versions of Spark and ipython, please, see also previous version of text.

Install Java Development Kit

This small subclass of the Pandas sqlalchemy-based SQL support for reading/storing tables uses the Postgres-specific "COPY FROM" method to insert large amounts of data to the database. It is much faster that using INSERT. To acheive this, the table is created in the normal way using sqlalchemy but no data is inserted. Instead the data is saved to a temporary CSV file (using Pandas' mature CSV support) then read back to Postgres using Psychopg2 support for COPY FROM STDIN.

	# For a local environment
	# Install hadoop and apache-spark via homebrew

	# Apache Spark conf file
	# libexec/conf/spark-defaults.conf
	# Make the AWS jars available to Spark
	spark.executor.extraClassPath /usr/local/Cellar/hadoop/2.7.1/libexec/share/hadoop/tools/lib/aws-java-sdk-1.7.4.jar:/usr/local/Cellar/hadoop/2.7.1/libexec/share/hadoop/tools/lib/hadoop-aws-2.7.1.jar
	spark.driver.extraClassPath /usr/local/Cellar/hadoop/2.7.1/libexec/share/hadoop/tools/lib/aws-java-sdk-1.7.4.jar:/usr/local/Cellar/hadoop/2.7.1/libexec/share/hadoop/tools/lib/hadoop-aws-2.7.1.jar

	# Add file

	function commarize()
	{
	// 1e6 = 1 Million, begin with number to word after 1e6.
	if (this >= 1e6)
	{
	var units =
	[
	"Million",
	"Billion",
	"Trillion",

	systems({
	"my-app": {
	image: {"docker": "azukiapp/php-fpm"},
	provision: [
	// "composer install",
	],
	workdir: "/azk/#{manifest.dir}",
	mounts: {
	'/azk/#{manifest.dir}': path("."),
	'/etc/nginx/sites-enabled/nginx_public.conf': path("./nginx_public.conf")

	class Bob
	def reply_to(statement)
	public_send("reply_to_#{statement.class}".downcase.to_sym)
	rescue NoMethodError
	default_reply
	end

	def reply_to_silence
	"Fine. Be that way!"
	end