My Day Off

My employer has deemed that I can no longer accumulate any more vacation days until I use some. So, I'm off today and tomorrow. Today was a pretty good day. I filled my entire recycling bin with paper that I shredded. And still have a couple of more bags to put out. I even bought a new shredder to help me since this is a job that I had been putting off for years. And by getting rid of the paper, I made a dent in cleaning up my bedroom. Now I just need to start going through old computer equipment and recycling that.

House-wise, I started on hanging insulation. I put up most of the easy pieces. The next job will be more cutting because the spaces aren't standard sizes. I also found a couple of places that I need to install some wood so we have something to hang the drywall on. Those two jobs will be next. Then, the last things are just to drill the hole for the vent for the oven hood. I'm going to have to rent something to drill through the brick. And I need to finish the heating duct in the kitchen and finish running some pvc pipe to the second floor for my networking stuff.

It's looking good!

photo-1

Back At It

Back to work on my kitchen today. The hood that I ordered came in so I could try to determine where the outlet for it should go. I'm glad I bought it because I had it way too low. I found this out by eyeballing it, since the hood did not come with any installation instructions. I looked online and found that a hood should be 30"-36" above the stove. Then, I measured where the power on the hood was and it was about 10" above the bottom of the hood. I had to move my power outlet about 10" higher. Next I put in a board so I'd have something to screw into to hold the hood up. I'm pretty happy that except for the hole for the vent, I think I have everything done for the hood. I also bought some insulation to put between the 2x4s in the wall. And I finished the wall on the back of the house. All I have to do now is put in an outlet for the dishwasher, which I completely forgot to do. Install the insulation. And cut the breakfast bar area to the right height and I'm READY FOR DRYWALL! Barring any more disasters, I'm thinking this will happen next month. Yay! Here's how things look now.

photo

Today was a pretty good day. I only got hit on the head by a 2x6 once and had to use one bandaid for something else.

Using TileMill

Need to go to http://metro.teczno.com/ and download the osm.pbf file for Chicago. Then import it:

up:~ $ osm2pgsql -U postgres -c -G -d osm -S /usr/local/share/osm2pgsql/default.style ~/Downloads/chicago.osm.pbf 

This will take a while. (Not really, 170s.)

Download a zip archive of the latest version of OSM Bright from https://github.com/mapbox/osm-bright/zipball/master and extract it.

Get these zip files.

http://tilemill-data.s3.amazonaws.com/osm/coastline-good.zip
http://tilemill-data.s3.amazonaws.com/osm/shoreline_300.zip
http://mapbox-geodata.s3.amazonaws.com/natural-earth-1.3.0/physical/10m-land.zip

Put them in the unzipped mapbox-bright directory, but don't unzip them. In this same directory, copy the file configure.py.sample to configure.py. Then edit as necessary. The only thing I needed to do was to change the postgresql user to postgres and put a password for it in. Then, move the entire mapbox-bright directory to the Mapbox working directory, which for me was ~/Documents/MapBox/projects. Lastly, run ./make.py in the mapbox-bright directory. It creates an OSMBright directory, which will come up when you start TileMill. Then, edit away. It's pretty cool!

Here's my first map. I've been screwing around with the fonts, so they don't look right. But still, it's not bad.

OSMBright_0e1544 (PDF File)

OSMBright

Tilemill

I'm trying to make a map for a conference and thought I'd use TileMill. As far as I can tell, the first step (after installing TileMill) is to install postgresql. Here's where I am with that.

up:~ $ sudo port install postgresql93
up:~ $ sudo port install postgresql93-server
up:~ $ sudo port install postgis2
up:~ $ sudo mkdir -p /opt/local/var/db/postgresql93/defaultdb
up:~ $ sudo chown postgres:postgres /opt/local/var/db/postgresql93/defaultdb
up:~ $ sudo su postgres -c '/opt/local/lib/postgresql93/bin/initdb -D /opt/local/var/db/postgresql93/defaultdb'
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /opt/local/var/db/postgresql93/defaultdb ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
creating configuration files ... ok
creating template1 database in /opt/local/var/db/postgresql93/defaultdb/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /opt/local/lib/postgresql93/bin/postgres -D /opt/local/var/db/postgresql93/defaultdb
or
    /opt/local/lib/postgresql93/bin/pg_ctl -D /opt/local/var/db/postgresql93/defaultdb -l logfile start

Once I have postgresql and postgis running, I think I'll be able to download and use street data from OpenStreetMap. At least, that's my plan. We'll see how it goes.

Think I got things started with:

up:~ $ su postgres -c '/opt/local/lib/postgresql93/bin/pg_ctl start -D /opt/local/var/db/postgresql93/defaultdb'
Password:
server starting
up:~ $ LOG:  database system was shut down at 2014-01-02 19:53:01 CST
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

Then get it started with:

up:~ $ psql -U postgres
psql93 (9.3.0)
Type "help" for help.

postgres=# create database osm;
CREATE DATABASE
postgres=# \connect osm
You are now connected to database "osm" as user "postgres".
osm=# create extension postgis;
ERROR:  could not open extension control file "/opt/local/share/postgresql93/extension/postgis.control": No such file or directory

Nuts! Need to figure out where I screwed up.

Think the problem is because postgres92 is installed, so uninstall both postgis2 and postgres92. Then reinstall postgis2.

Hmmm. This just reinstalled postgres92, so I guess I should just use postgres92 instead of postgres93.

up:~ $ sudo port install postgresql92-server
Warning: port definitions are more than two weeks old, consider updating them by running 'port selfupdate'.
--->  Computing dependencies for postgresql92-server
--->  Fetching archive for postgresql92-server
--->  Attempting to fetch postgresql92-server-9.2.4_0.darwin_12.x86_64.tbz2 from http://packages.macports.org/postgresql92-server
--->  Attempting to fetch postgresql92-server-9.2.4_0.darwin_12.x86_64.tbz2.rmd160 from http://packages.macports.org/postgresql92-server
--->  Installing postgresql92-server @9.2.4_0
--->  Activating postgresql92-server @9.2.4_0

To create a database instance, after install do
 sudo mkdir -p /opt/local/var/db/postgresql92/defaultdb
 sudo chown postgres:postgres /opt/local/var/db/postgresql92/defaultdb
 sudo su postgres -c '/opt/local/lib/postgresql92/bin/initdb -D /opt/local/var/db/postgresql92/defaultdb' 
 
To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf

--->  Cleaning postgresql92-server
--->  Updating database of binaries: 100.0%
--->  Scanning binaries for linking errors: 100.0%
--->  No broken files found.
up:~ $ sudo mkdir -p /opt/local/var/db/postgresql92/defaultdb
up:~ $ sudo chown postgres:postgres /opt/local/var/db/postgresql92/defaultdb
up:~ $ sudo su postgres -c '/opt/local/lib/postgresql92/bin/initdb -D /opt/local/var/db/postgresql92/defaultdb'
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

fixing permissions on existing directory /opt/local/var/db/postgresql92/defaultdb ... ok
creating subdirectories ... ok
selecting default max_connections ... 20
selecting default shared_buffers ... 1600kB
creating configuration files ... ok
creating template1 database in /opt/local/var/db/postgresql92/defaultdb/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /opt/local/lib/postgresql92/bin/postgres -D /opt/local/var/db/postgresql92/defaultdb
or
    /opt/local/lib/postgresql92/bin/pg_ctl -D /opt/local/var/db/postgresql92/defaultdb -l logfile start

Try to start the server:

up:~ $ su postgres -c '/opt/local/lib/postgresql92/bin/pg_ctl start -D /opt/local/var/db/postgresql92/defaultdb'
Password:
server starting
up:~ $ LOG:  database system was shut down at 2014-01-02 20:48:40 CST
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

See if can use it:

up:~ $ psql -U postgres
psql93 (9.3.0, server 9.2.4)
Type "help" for help.

postgres=# create database osm;
CREATE DATABASE
postgres=# \connect osm
psql93 (9.3.0, server 9.2.4)
You are now connected to database "osm" as user "postgres".
osm=# create extension postgis;
CREATE EXTENSION

YES!

Getting Started

At this rate, I'll read 365 books this year. 🙂 Anyway, had a lovely New Year's Day, where I watched some hockey and just sat and read. I finished Kafka on the Shore by Haruki Murakami. I don't really understand why, but I liked this book a lot. I guess it's because I liked the characters and the weird things that happened to them, but I can't really say for sure. This is now the second book by Murakami that I've read. I read 1Q84 a couple of years ago and liked that one as well. So I guess I'm going to add Murakami to William Gibson and Isabel Allende as authors that I really like.

I haven't spent an entire day reading in a long time. The first time I did this was a very long time ago, when I stayed up all night reading Cuckoo's Egg by Cliff Stoll. I'm glad I finished this book at a reasonable hour because I do have to go to work in the morning and would be very cranky if I had been reading all night. I'm quite happy that the book sucked me in, since I had been worried that I was no longer able to read an entire book. Now that I mostly read short magazine articles and blog posts, a novel seemed slightly insurmountable. But I'm glad that I can still do it. Happily, I just got email from the library that a book I requested there has arrived, so I can pick that up tomorrow. I shouldn't spend another full day reading, since I have to go to work AND should be working on my kitchen. But I'll see if I can grab a few hours here and there.

To 2014

I'm hoping that 2014 will be as good of a year as 2013 was. But I like to set specific goals/resolutions/whatever you want to call them. So here are some things I'd like to accomplish in the coming year.

  • Finish the kitchen - My desire to cook a meal in my own house is very great. And I've made great progress in the past few months. So, while I'd like to say that it'll be done by the end of February, a more realistic deadline might be by May or so. Whenever the deadline, I want it done this year. I'm committed to hosting Thanksgiving here and possibly Christmas too.
  • Ask for help - Related to the above, I'm going to have to start asking for help with things. And while I like to think that I can do anything by myself, I need to get over my incredible dislike for asking for help.
  • Being active - This is just my generic term for biking, running, skating, etc. I was pretty good last year about keeping moving. I have noticed that in winter I tend to shut down, but as soon as the weather gets a little better, I want to get back outside and moving. And I'd still like to take an overnight bike trip. I should start researching some possibilities.
  • Programming - Specifically, in ruby I want to learn how to write tests and I'd like to learn some javascript.
  • School - I haven't taken a real class in a while and I think I'd like to do that. There are tons of online classes now, so I think I'd like to sign up for one in the fall. Right now, I'm thinking a material science class would be interesting, but that could change.
  • Travel - While I'm really not much of a traveler, I do know it's good for you. So I'd like to get myself out there in uncomfortable situations and see what happens. Now that the kitchen is closer to being finished, I feel like I'm in a better position financially to be able to get out some more.
  • Read - I like to read, but of late have been having problems in concentrating long enough on a book. Since I think specific goals are good, I'd like to try to read at least one novel per month.
  • Make a point of seeing friends - Unfortunately, the main communication method I've been using with most of my friends is texting. This should stop. So I want to make a point to go and see people in person. For a person who tends to prefer to stay home alone, this will be a bit of a challenge. But it'd be good for me and good for my friends. And if any of my friends are reading this, feel free to remind me of this anytime if I'm being a pill.
  • That's probably good for now.

    Here's to 2014! Hope it's a great year!

My Yearly Wrapup

2013 was a pretty good year for me. My health is good, I bought a new car and I'm pretty happy overall. So I have no real complaints. I set some goals for the year, let's take a look at how I did.

  • C programming - As my nephew George would say, 'Epic Fail'. I didn't spend any time on this.
  • Finish the kitchen - While I'm not done, I would call this a great success. I did hold off until I had $10,000 saved, which means I didn't really start anything until June. And I've made great progress, while not done, I do think it will be finished in the first half of this year.
  • Take an overnight bike trip - While I took an overnight train to NYC to do a long bike ride, I'm pretty sure that's not what I was talking about here. So, I failed on this one.
  • Electronics - I didn't work through the Eagle tutorials, but I did buy a robot and played with that. So if not a complete fail, it's close to it.
  • Book - Fail. Didn't do much on this. While I did write some short blog posts, nothing close to a book came out of me.
  • Bicycling - Success! I did bike a lot this year. Possibly I talked about it a bit too much, so I'll try to reign that in. But I'm happy with this one.
  • Ruby - Success, though not in the idea of converting a bunch of my old scripts to ruby. Instead I did a decent job of writing some new sites in ruby.
  • Computational Geometry - This was a neat idea, but I didn't do anything with it. Epic fail.
  • Welding - I did take a one-day welding class, which is a goal I had two years ago. So, it was late, but it got done.

The big one in that list is redoing the kitchen. That is a ridiculous amount of work. And I will say that there were a couple of times during the year when I thought that it really wasn't all worth it...I should have just stayed in the condo...etc. But once I reminded myself that no one held a gun to my head to buy this house, I got back to work. So the kitchen pretty much overwhelmed everything else. And this trend will continue in the new year until I get it finished.