Skip to content

Instantly share code, notes, and snippets.

@tomay
tomay / all_trackers.csv
Last active March 15, 2016 03:22
Coal sankey
We can't make this file beautiful and searchable because it's too large.
Location ID,Wiki page,Sort code,Unit,Plant,Other names,Chinese name,Sponsor,Parent,Capacity (MW),Status,Status (detail),Year,Combustion technology,Coal type,Coal source,Location,"Local area (taluk, county)","Major area (prefecture, district)","Subnational unit (province, state)",Country,Region,Latitude,Longitude,Accuracy,Permits,Lifetime CO2 (million tonnes),RETIRED,Planned Retire,reference
0,http://bit.ly/1oOPh4K,,CPI Baiyinhua Industrial Park Self-Supply Power Plant Unit 1,Baiyinhua Industrial Park Self-Supply power station,,中电投白音华工业园自备电厂,China Power Investment,CPI,,Announced,,,,,,Baiyinhua,West Ujimqin,Xilingol,Inner Mongolia,China,East Asia,44.718,118.396,approximate,,,,,
0,http://bit.ly/1oOPh4K,,CPI Baiyinhua Industrial Park Self-Supply Power Plant Unit 2,Baiyinhua Industrial Park Self-Supply power station,,中电投白音华工业园自备电厂,China Power Investment,CPI,,Announced,,,,,,Baiyinhua,West Ujimqin,Xilingol,Inner Mongolia,China,East Asia,44.718,118.396,approximate,,,,,
0,http://bit.ly/1qHiEqD,,Baolixiexin Zhongnenggu
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" ; Content-Type: text/html; charset=utf-8/>
<title>
Karte der Kita Rabauken und Trompeten
</title>
<script type='text/javascript' src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
@tomay
tomay / Issues.md
Last active August 29, 2015 14:16 — forked from rclark/Issues.md

There are a bunch of reasons why this is convoluted, mostly in building the URL to make the request:

  1. You have to rely on an AJAX request, this example uses jQuery
  2. To make a GetFeatureInfo request, you must provide a BBOX for a image, and the pixel coordinates for the part of the image that you want info from. A couple of squirrely lines of Leaflet code can give you that.
  3. Output formats. The info_format parameter in the request. We don't know a priori which will be supported by a WMS that we might make a request to. See Geoserver's docs for what formats are available from Geoserver. That won't be the same from WMS to WMS, however.
  4. WMS services return XML docs when there's a mistake in the request or in processing. This sends an HTTP 200, which jQuery doesn't think is an error.
@tomay
tomay / L.Mask.js
Last active August 29, 2015 14:06 — forked from wboykinm/L.Mask.js
L.Mask = L.Rectangle.extend({
options: {
stroke: false,
color: '#333',
fillOpacity: 0.5,
clickable: true,
outerBounds: new L.LatLngBounds([-90, -360], [90, 360])
},

Apache, PostgreSQL/PostGIS, PhP

misc

sudo apt-get install python-software-properties

apache

sudo apt-get update

sudo apt-get install apache2

Cartodb install on Digital Ocean ubuntu 12.04 64-bit

based on https://github.com/CartoDB/cartodb with additions as necessary
11/2013 to 02/2014

Install git

sudo apt-get install git-core

Clone project

https://github.com/tomay/ar-student-schema/commit/d48fb240e89cdb8f983b502e523c080b351c5c77
edited migration to create students table...