mvexel

mvexel

states = {
    "01": ["Alabama", "AL"],
    "02": ["Alaska", "AK"],
    "60": ["American Samoa", "AS"],
    "04": ["Arizona", "AZ"],
    "05": ["Arkansas", "AR"],
    "81": ["Baker Island", ""],
    "06": ["California", "CA"],
    "08": ["Colorado", "CO"],
    "09": ["Connecticut", "CT"],

mvexel

12:26 $ rake test:db
[Coveralls] Set up the SimpleCov formatter.
[Coveralls] Using SimpleCov's 'rails' settings.
Run options: --seed 7757

# Running:

.........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

mvexel

I use this series of queries to get all nodes that should represent motorway_junction nodes:

-- create temp table to store all motorway nodes
create table motorway_nodes as (select (st_dump(st_points(linestring))).geom geom, id from ways where tags->'highway' = 'motorway');
-- create temp table to store all motorway_link start nodes
create table motorway_link_start_nodes as (select st_pointn(linestring, 1) geom, id from ways where tags->'highway' = 'motorway_link');
-- create temp table with the intersection between these two
create table offramp_starts as (select l.id lid, m.id mid, l.geom from motorway_nodes m, motorway_link_start_nodes l where st_equals(m.geom, l.geom));
-- select the OSM nodes at these locations

mvexel

Mr [SENATOR],

My name is [NAME] and I live in [CITY], [STATE]. I am calling to express my grave concerns about Ms DeVos, the current candidate for Secretary of Education. Her confirmation hearings showed to me that she lacks basic knowledge about our public education system. A system that Ms DeVos seems intent on dismantling in favor of privately run schools. There is no precedent for such a change working to benefit the quality of education at scale. Our education system is already fragile, and many measures could be taken to improve it, but navigating down this uncharted and ill-informed path that will be impossible to backtrack from is not one that we should take. Therefore, Ms DeVos is not a suitable person to lead education policy, and I ask of you in the strongest possible terms to not support her candidacy.

Thank you for listening.

mvexel

mvexel

# Get stock quote from command line
# Call with `sq yhoo`
# By default only last trade price shown
# add extra info in optional second parameter
# for available data see http://vikku.info/codetrash/Yahoo_Finance_Stock_Quote_API
# like so: `sq yhoo c1` will give you % change for the day
function sq() {
	curl -s "http://download.finance.yahoo.com/d/quotes.csv?s=$1&f=l1$2"
}

mvexel

CA:AB:primary
CA:QC:A
CA:QC:A
CA:ON:county
CA:ON:primary
CA:ON:primary
CA:ON:primary
CA:ON:primary
CA:ON:primary
CA:ON:primary

mvexel

This is a draft

---

layout: post title: "Here is how I failed in 2016. And why I should be on the OSM US board in 2017." excerpt: "My manifesto for the 2016 OSM US board elections" tags: [osm, elections, board] comments: false

mvexel

• Install Java JDK 8 from here
  • Set JAVA_HOME environment variable according to install instructions
• Download and extract the Lightbend Activator from here
• Add the Activator bin directory to your Windows path.
• Install PostgreSQL 9.5 from here
  • When asked, choose osm as the database superuser password
• Run the PostgreSQL StackBuilder to install PostGIS 2.3.0
• Install git for windows from here
• Open a PSQL console from the PostgreSQL program menu
• In the PSQL consile, create the MapRoulette database: