tags: beer, programming, TIGER, map, PostgreSQL, PostGIS, database

Action executed in 0.000

Each Tag

beer, programming, TIGER, map, PostgreSQL, PostGIS, database

Common tags - number of posts

brewing (12), OSM (8), GIS (6), brew (4), software (4), TrickleUp (4), ERD (3), tasting (3), planet (3), DC (3), Ommegang (3), blog (3), education (3), nutrition (3), regex (2), index (2), children (2), challenge (2), good and bad (2), Mark (2), geography (2), Brickskeller (2), import (2), recipes (2), brewery (2), tuning (2), Python (2), local (2), up-to-date (2), Akonadi (2), jxapi (1), coffee (1), Washington City Paper (1), devops (1), color (1), Elwing (1), tool (1), bug (1), Mapbox Studio (1), femenism (1), USDA (1), activism (1), model (1), pgsnapshot (1), RAID (1), handling (1), input operator (1), equipment (1), data (1), CHART (1), DC Beer Week 2010 (1), child (1), calorie (1), Big Hunt (1), technology (1), JpGraph (1), day care (1), solstice (1), home brewing (1), library (1), books (1), SBC (1), conference (1), pnorman (1), Belgian beer (1), fermentation (1), review (1), procedural language (1), wrangle (1), Andy (1), Falls Church (1), exception handler (1), math (1), team (1), bailey (1), food (1), user input (1), boundary (1), Metro (1), Halloween (1), Maryland (1), event (1), disk (1), fiction (1), subway (1), render (1), population (1), routing (1), normal form (1), ale (1), changeset (1), comment (1), aggregation (1), story telling (1), cycling (1), KDE (1), PHP (1), forum (1), Google (1), pumpkin (1), Lorton (1), number (1), ITO (1), co2 (1), history (1), Xerces (1), tiles (1), gardening (1), store (1), scrape (1), carbohydrate (1), comparison (1), Long Hammer (1), bubble (1), manufacturer (1), service (1), SpeakeasyDC (1), graph (1), PowerMac G5 (1), export (1), upgrade (1), traffic (1), diy (1), hops (1), community (1), Sun Rye (1), analysis (1), fan (1), _answer (1), C++ (1), exceptions (1), transportation (1), JavaScript (1), Belgian (1), manager (1), can (1), Rare Vos (1), streets (1), kernel (1), query (1), Justin (1), Mapbox (1), recursion (1), speed (1), geo (1), scan (1), WMATA (1), rating (1), friend (1), text (1), citext (1), Java (1), mapnik (1), PostgreQL (1), calculator (1), tutorial (1), volunteer (1), case (1), osm2pgsql (1), interactive (1), Towers of Hanoi (1), wiki (1), demographics (1), comments (1), retail (1), address (1), NYC (1), race (1), open (1), tile (1), Areca (1), Duvel (1), nation (1), pair (1), census (1), craft (1), osmosis (1), density (1), Linux (1), alcohol (1), XAPI (1),

Sub groups 6

Sub groups 5

Sub groups 4

Sub groups 3

Sub groups 2

Akonadi, ERD, PostgreSQL, database (1)

Sub groups 1

beer, brewing (5), beer (3), GIS, PostGIS (2), beer, brewing, software (2), DC, beer (2), PostgreSQL (2), PostgreSQL, index, regex (2), beer, blog (1), PostgreSQL, case, citext, text (1), OSM, map, solstice, streets (1), Belgian, Brickskeller, Duvel, Mark, Ommegang, beer, tasting (1), beer, rating, review (1), OSM, PostGIS, bailey, planet, up-to-date (1), PostGIS, census, density, population (1), Big Hunt, DC Beer Week 2010, SpeakeasyDC, Washington City Paper, beer, story telling (1), child, day care, map (1), beer, brew, software (1), Lorton, beer, brewery (1), database, fiction, interactive (1), programming (1), beer, good and bad (1), calculator, challenge, programming (1), education, geo, geography, map (1), GIS, PostGIS, PostgreQL (1), children, education, map (1), NYC, analysis, map, subway, transportation (1), TrickleUp, beer (1), beer, local, manufacturer (1), SBC, beer (1), database, food, manager, nutrition, recipes, scan (1), PHP, PostgreSQL, procedural language (1), beer, brew, recipes (1), USDA, database, nutrition (1), GIS, map (1), ITO, OSM, cycling, map (1), beer, conference, event (1), Andy, map, service, tiles (1), GIS, PostgreSQL, library (1), Halloween, beer, pair (1), OSM, boundary, data, export, map, wrangle (1), Long Hammer, Sun Rye, ale, beer, brewery (1), activism, beer, brewing, local (1), OSM, Python, changeset, database (1), TrickleUp, blog, database (1), beer, brewing, bubble, co2, fermentation, math (1), beer, gardening, hops (1), beer, can, craft, diy (1), Java, exceptions, handling, programming (1), Google, JavaScript, map (1), OSM, PostgreSQL, XAPI, import, jxapi, osmosis, pgsnapshot, planet, pnorman, tuning (1), Ommegang, Rare Vos, beer, history (1), C++, _answer, input operator, programming (1), TrickleUp, blog, comment, database (1), Elwing, PowerMac G5, database, fan, normal form, upgrade (1), beer, brewing, forum, home brewing, wiki (1), beer, brew (1), Areca, Linux, PostgreSQL, RAID, disk (1), PostgreSQL, aggregation, query (1), map, routing (1), OSM, map, nation, team (1), beer, tasting (1), database, exception handler, number, software, user input (1), DC, GIS, address, database (1), CHART, JpGraph, Xerces, database, graph, scrape, speed, traffic (1), comparison, geography, map, tool (1), PostgreSQL, Python, devops, femenism (1), Falls Church, beer, brew (1), Towers of Hanoi, challenge, programming, recursion (1), Metro, WMATA, color, map (1), OSM, PostgreSQL, import, mapnik, osm2pgsql, planet, render, tile, tuning, up-to-date (1), demographics, map, race (1), books, children, education, map (1), Belgian beer, Brickskeller, Mark, Ommegang, beer, tasting (1), Mapbox, Mapbox Studio, map, tutorial (1), ERD, database, model (1), beer, coffee, good and bad, pumpkin (1), Maryland, beer, brewing, equipment, retail (1), TrickleUp, bug, comments, database, kernel (1), Justin, KDE, beer, friend (1), alcohol, beer, calorie, carbohydrate, nutrition (1), community, open, programming, technology, volunteer (1), beer, brewing, store (1)

Programming

After a long day at work of arduous programming, i come home to do what? Yes more programming. But wait there's a difference. At home, i can sip my beer while waiting for code to compile.

At work today i was able to take the Tiger dataset and draw a map. Tiger comes with only line data, ie. only one dimensional. However for each chain of points there are attributes referring to adjacent polygons. Using tigerpoly.py in the GDAL project i was able to construct the 2 dimensional polygons.

All that data was inserted into a PostgreSQL database with PostGIS installed. PostGIS and GDAL needed a couple patches. Then i wrote a Java program to grab the data using JDBC and drew it using AWT. Sure Java2D is better, but i'm not sure i need it. After all i'm just drawing lines and polygons. Sheesh.

I'm guessing all map data comes from the same source. The Census Bureau. Therefore, even Google (eventually) gets their data from Tiger. How is it different? Well (1) the roads have width proportional to the number of lanes, (2) all the corners are rounded, and (3) their roads are labelled. Those are the major differences in appearance. As for differences in feel, don't get me started.

And on a side note, it's been so long that i almost forgot my password to my own website. Back to dinner (Otter Creek Alpine Ale).