Danny S. nygeog

Installing CartoDB on Ubuntu Server 12.04

Get CartoDB Rails application source

sudo apt-get update

sudo apt-get install git

cd ~

git clone --recursive https://github.com/CartoDB/cartodb20.git

This line chart is constructed from a TSV file storing the daily average temperatures of New York, San Francisco and Austin over the last year. The chart employs conventional margins and a number of D3 features:

d3.tsv - load and parse data
d3.time.format - parse dates
d3.time.scale - x-position encoding
d3.scale.linear - y-position encoding
d3.scale.category10, a d3.scale.ordinal - color encoding
d3.extent, d3.min and d3.max - compute domains
[d3.k

	import pandas as pd
	#https://data.medicare.gov/Hospital-Compare/Readmissions-and-Deaths-Hospital/ynj2-r877

	inCSV = 'Readmissions_and_Deaths_-_Hospital.csv'

	df = pd.read_csv(inCSV)

	df.head(10)

	df['latitude'] = (df.Location.str.split('(',1).str[1]).str.split(',',1).str[0]

	import os
	import zipfile
	import glob

	#EDIT ONLY THESE TWO VARIABLES
	cdbU = <cartoDBusername>
	cdbK = <cartoDBapikey>

	shpFolder = 'data'


	def nearJoin(inFeature,nearFeature,nearDistance,outFileLocation,outFeature):
	### Normal Near Function doesn't carry over all the attributes of inFeature or nearFeature.
	### To Do:
	### Error handling in try: except: should handle OBJECTID vs. FID issues.
	### Example:
	### inF = wd+"input/fulcrum.gdb/street_segment_questions_v2_prj"
	### nrF = wd+"processing/gar.gdb/gar_roads_ftl"
	### nrD = "20 Meters"
	### ouL = wd+"processing/fulcrum.gdb"

	<!DOCTYPE html>
	<meta charset="utf-8">
	<style>

	.states {
	fill: none;
	stroke: #fff;
	stroke-linejoin: round;
	}

	<!DOCTYPE html>
	<meta charset="utf-8">
	<style>

	.counties {
	fill: none;
	stroke: black;
	opacity:0.2;
	}

	geoidCalc = df['UID'].str[2:]
	df['geoid'] = geoidCalc