KML Mashup Experiment

Aug 24, 2008 @ 9:48 PM by Kumiko Yamazaki -- google maps:

Here’s a kml experiment I did over the weekend — annual precipitation of California, 1961-1990.

(This is only a screenshot, click for actual map.)

Some tweaking and headaches involved but I’m satisfied with the result. Rule #1 as a cartographer is to make every map created here look pretty.

The data was originally for the entire US which bloated into a 22 MB kml file. Rather than simplifying and sacrificing such good data, I clipped out California. The kml is currently at 2.4 MB and still loads a bit slow but at least I now have a better understanding of how well Google Maps handles data. (Not great, though it sure looks nice!)

leave a comment


Editing DBFs on a Mac OSX

Aug 21, 2008 @ 9:35 PM by Kumiko Yamazaki -- apps:

Free open source GIS applications are often excellent viewers, but have only limited capabilities when editing data. For example, merging and analyzing multiple datasets are basic functionalities to GIS, yet, many do not support such features.

A common workaround is to dive directly into the database (the .dbf file) and edit it using a spreadsheet application. Excel can easily handle this but Excel is not free, and this website? It’s all about FREE.. unless I say otherwise. And be warned, I found out last night that Excel 2007 can no longer save as .dbf files.

So when expensive proprietary software can’t get the job done, turn to Open Office. From here, you can merge/copy/add data to your existing table and create your final database.

The next step is to inform Open Office which cells need to be saved. Highlight only the cells you need and go to Insert -> Names -> Define. Call it Database and hit OK.

Save as a .dbf file and write over the previous version. If everything was done correctly, the newly edited attribute table should be available for your geowebbing pleasure. I skipped through some steps so please don’t hesitate to ask questions!

leave a comment


Starting mapkist

Aug 18, 2008 @ 8:29 PM by Kumiko Yamazaki -- general:

So much I hope to do here — designing maps using various platforms, sharing, coding, networking, and most importantly, learning!

leave a comment