Monthly Archive for October, 2007

Improved MySQL GIS functions

MySQLThe Russian developer Alexey “Holyfoot” Botchkov improved MySQL’s built-in GIS functions in order to use precise operations instead of MBR-based operations. Binary packages of a MySQL release containing his work are available for public testing here (FTP).

According to the GIS Functions wiki entry following MySQL GIS functions have been added to the MySQL 5.1.23 beta GIS release:

  • BUFFER
  • DIFFERENCE
  • DISTANCE
  • INTERSECTION
  • SYM_DIFFERENCE
  • UNION

I haven’t had the chance to test it yet, but I remember being very excited when I first read about the MySQL spatial extension a couple of years ago, followed by disappointment because of the MBR limits. Finally I decided to go with PostgreSQL/PostGIS back then.

However, if this functions make it into the official release it would be a good tool for proper storage and inclusion of geospatial data in (lightweighted) mapping applications like map mashups, compared to file based XML (KML) storage for instance. MySQL is supported by every other shared hosting plan, so the install base would be quite considerable I guess. [via heise]

P.Rank games

SchwanzvergleichWhat a bad day for the (male) blogosphere…

I wish some *bloggers* would care as much about their content as they do about that magic number. PageRank is good, but content is still king.

Besides, isn’t it somehow alarming when a single company flexes its muscles and lets a considerable part of the media landscape tremble?

Pics on spots

Tupalo, my favorite socialyellowpagesthing, recently added Flickr integration. Just like as known from Upcoming or a couple of other sites, you can now use Flickr-tags to assign your photos to a particular spot on Tupalo.

Inoperable

It’s pretty simple: copy and paste the tag provided on every Tupalo spot-page to your Flickr photo tags. I guess Tupalo will crawl Flickr in given intervals to find newly-tagged images. Mine were found and showed up on Tupalo within a few minutes.

Tupalo tags follow the de-facto machine tag standard on Flickr and look like tupalo:spot=316, whereas 316 is the spot id in that case.

I’m a person who loves photos, but generally speaking, I think it’s is a great addition to Tupalo. What’s better than visual impressions of a spot you’re reading reviews about?

Even though there are now more images on the site, the new feature doesn’t interfere with the clean – white space forever! – user interface at all. In fact, Tupalo is one of the few sites my boss could immediately deal with, and this means something like olympic gold for usability. It seems like every button, link or information is where it should be on this site.

Great work guys!

Viennale tickets

Due to my fabulous time management I can’t go to the movies next weekend and have to give away following two Viennale tickets:

LYNCH, Fr 26.10 16:00
BLADE RUNNER: THE FINAL CUT, Sa 27.10 1:00

Any takers?

Morning movie

Paranoid ParkA good day starts with a good movie.

It was quite unusual to leave at 6am in the morning for the movie theater, but the film was worth to get up that early. Paranoid Park from Gus Van Sant is a movie I’d definitely recommend watching.

Basically it’s a simple plot, if there wouldn’t be the jumps back and forth in time, telling the teenage story of a young skater who got accidentally involved in a killing and struggles with that incident.

I especially enjoyed the fantastic cinematography, the use of different film materials to match moods and underline the story. In terms of images, visuals and sounds it’s an excellent work and reason enough to go and see it.

Out for a Picnik

m-dorfIt took a TechCrunch post to direct my attention to Picnik, an amazing online photo editor. Among other photo services, it already integrates very well with Flickr using the Flickr authentication API. You can retrieve from Flickr, edit in Picnik and save back to Flickr seamlessly. Apparently the Flickr user interface will get another button soon to make the editing process with Picnik even more easier.

My first thought was that I won’t need iPhoto anymore. Ever since I bought the DSLR I only use iPhoto to manage the snapshots I take with my smaller camera. If I’m going to upload directly from my smaller camera to Flickr and do rudimentary editing like cropping and basic color adjustments there in Picnik, which does an excellent job as I found out last weekend, I could skip iPhoto entirely. The Flickr-Picnik workflow should work at least as good as the workflow in iPhoto.

Technically no problem but there would still be this unpleasant feeling in my stomach region of giving the control over my images totally out of my hands. Stomach says no, so I rather stay some more time with the local iPhoto library as primary library and the Flickr account as secondary “fun” library.

However, Picnik will be a great addition to Flickr and I’m pretty looking forward to it!

Mac OS X Leopard Amazon discounts

Amazon (.de) is giving away 10 EUR discounts if you order Mac OS X Leopard v10.5 before 1.11.2007. Just go there and enter following code to your order: AMZNLPRDAPPL.

It’s Amazon Germany and the code is probably only valid there.

I personally will wait until all the “Leopard shredded my disk and drank all my beer” whining is gone and the system is stable and ready for productive use. So let’s say starting with 10.5.2.

Facebook lies!

Facebook lies

Or Blog Friends, a Facebook application for your friend’s blogs. Strangely Michaela isn’t even registered at Facebook… well, never trust the friend finder!

Interactive light map

The project that kept me awake over the last couple of weeks was a mapping installation we did for the 50th year anniversary of our institute.

Imagining Europe

I don’t want to brag, but I think this thing is pretty cool: it’s a horizontal map projection on a table, where users interact with the projection, with the light, itself by moving little backgammon tokens around. That way visitors can explore the map and selected spatial and regional indicators.

It’s based on a video tracking system, set up by Emanuel, together with a light-weighted mapping application responding to those incoming video signals by querying a database and visualizing geographic data. The concept is rather simple, but as so often, the devil is in the details. Proper handling of the video signals was pretty tricky in our case and made us stay late at the office. Even though we couldn’t implement every planned feature, it was the first time we used video tracking for user interaction, we are very satisfied with our first release. The response from our visitors was great and we definitely see potential and will keep on working on that project.

However, I observed one noteworthy point while watching some visitors interacting with the map: several people standing around the table started instantly talking about the map, the shown maps triggered communication and people started discussing the presented indicators. Unlike clean paper printouts or maps on screens, people could touch the map, grab the tokens, place the tokens, touch and point with their hands and fingers onto the map without fearing canapé-greasy finger prints. Although it was only light, it seemed like they had a tool in their hands they could play with.

One visitor told me that the installation reminds him of the old large plotted paper maps and plans.

Another point for this vivid communication is the distance to the screen I think. If the projection would be vertical, every visitor would be at another distance, standing on another level, to the image. While standing around a table, where the image is in the center, the distance from the image to every visitor is constant. Maybe that makes visitors feel more equal and makes it easier for them to join the discussion. Nobody is standing behind, everybody can access – view, grab, touch – the information the same way.

If I remember correctly Microsoft had a research project or something about making the virtual PC desktop real. After I’ve seen what you can achieve with “grabbing & touching” I definitely think that’s the future. The mouse is a 30 year old idea. Isn’t that almost ancient in the world of technology?

Nothing to say so blog