On a project I’m working on at the moment (Meedan) we need to be able search for content by geographic area as well as by topic …. e.g. give me all the blog articles from the Middle east that relate to the Iraq war.

Luckily we already have a means to geo-locate all this content (handy eh ? ) so we’ve assigned latitude and longitude values to each article/ blog post /conversation participant.

All thats needed then is a means to search by Geographic area.

We’re using PostgreSQL a pretty heavy weight database baring a much closer resemblance to Db2 rather than MySQL. It has some pretty neat geographic search features courtesy of the PostGIS extension. This allows you to perform searches inside lat/lon boundaries of varying complexity as well as many other neat geo functions. These boundaries are defined in a markup called Well Known Text (WKT), for our purpose we search by polygons that are made up of lat/lon points that mark out the geographic search areas, both PostGIS and DB2 spatial extender uses this format.

So that’s all the big pieces in place, the only missing piece is a set of lat/lon points that define the areas we wish to search. I may have been blind or searching for the wrong terms but i couldnt find a set of this data anywhere on the Internet (please point me to a source if you know one). As we only needed the rough continent outlines I decided it would be a fairly trivial effort to make a tool to create the sets of lat/lon points in the correct WKT format for our searches.

Basically you click around the area you want to define and the hit ‘generate polygon’ this will give a nice WKT formatted polygon ready to use in an SQL query. If you want to delete a point just click on it a second time.

At the moment you just create an area generate the polgon and do the next one.

Next up I may add some storage so that people can share these datasets with each other or come back and change them at a later date.

For now here is the mapping tool. buy cialisbuy cialisbuy levitrabuy levitrabuy propeciabuy propeciabuy somabuy somabuy levitrabuy cialisbuy propeciabuy levitrabuy somabuy cialisbuy propeciabuy levitrabuy somabuy cialisbuy levitrabuy propeciabuy soma

I just received this email from one of the two OpenID providers I signed up with

This is a notice that [XXXXXX] will be having a maintenance
outage starting at 08:00 on 2007/09/12, Pacific Time.
The outage may last as long as 60 minutes, but is expected
to be considerably shorter.

The reason for this outage is:

     Database upgrade

During the outage, the [XXXXXX]website may be unavailable or
unresponsive, and users will be unable log into OpenID-enabled
websites using their [XXXXXX]accounts.  The latest information about
this and other [XXXXXX]vents can always be found on....

I know it’s early days on the OpenID front, but this does illustrate a prime limitation that has to be addressed carefully. If a large percentage of sites adopted the OpenID scheme without an alternative means of authentication then a few well placed DDOS attacks on registrars could essentially block out access to thosuands of sites.

Proceed with caution and make sure you allow users to login to your site with a secret stored locally if you’re implementing OpenID.

John Tolva let out a quick request the other week on twitter for a Flickr photostream timeline, it sounded like a quick hack was possible using Simile and the Flickr API; both of which I wanted to have a play with for investigative purposes. It turned out to be nice and straightforward, the Simile API from MIT is flexible and simple to use, so much so that I should really spend a bit more tweaking my Flickr timeline to make it look prettier, but hey this is just a quickie

Well I haven’t done any machinima posts of late, but I can feel a few in the offing having just completed one concept video for a client and with the promise of a few more lurking not too far in the distant future.

The machinima I’ve been doing has generally been of the type you use when you can’t do a live demonstration of SecondLife, it’s been produced to either illustrate potential scenarios/concepts or show case existing business aspects of secondlife. The venue for displaying this machinima has been at trade shows or during large presentations.

Video and particularly Machinima seems to keep cropping up in my day to day job at the moment, a client I’m currently working for has a need for a streamed video service for use at events. We want something reliable but cheap that we can use for the occasional streaming of a live event etc. into Second Life (any suggestions welcome

The one service I have been playing with at the moment is a startup called Veodia (veodia.com) which is currently in beta. It’s very similar to another beta startup
called ustream (ustream.tv) the one distinct and important difference (with my SL oriented slant) is that it makes available the video stream in quicktime format. Meaning that it can be streamed straight into Second Life with no conversion faffing or trouble finding dedicated servers to run a Darwin streaming server on.

Ian pointed me at Veodia a few weeks ago, however it took my account registration email some time to materialise (it was trapped in Hotmails spam catcher) so I was a bit slow off the mark in checking out what format the streaming was done in. Kevin Aires as ever the video streaming investigator got in there and found it was quicktime compatible and blogged within IBM about getting a Veodia stream into SL.

After finally getting into my account yesterday I started up my softcam desktop streaming app, set up a quick feed on veodia, grabbed the rtsp link from a view source and set the media url for my land parcel in Ukanipo.

Here’s the result a slightly disturbing world within world effect…

.

So what you are seeing here is the result of softcam capturing my desktop video display output, streaming it up to veodia and then it being streamed into SecondLife. Infinite loop complete. (ps the quality is better when you don’t go for this wheels within wheels effect)

So whats this useful for ?

-video conferencing: pipe your webcam into SL without the need to host your own streaming server.
- live demos:   do desktop sharing to a crowd in SL so you can do demonstrations from other apps (shared browsing or 3d app tutorials anyone?), simutaneously visible on the web stream too.
- world tours: get all your guests into one place with a screen in SL and then disapear off streaming your secondlife journey back to the assembled SL crowd.
- video link parts of SL: running a live event over several islands ? then provide video linkups between each of the islands so everyone can see what’s going on.

best of all veodia which is in beta is currently free, oh and it records too

A nice post on Social Networking sites over here at wisdump, it does however make some assumptions that largely the same groups of users float from one networking site to the next leaving the others behind for dead. This may be true in some cases, but it doesn’t take account of the increasingly large number of broadband connected always on users and the increasing uptake of web communication as the de facto way of keeping in touch. True there are a finite number of users, so super rapid growth can’t be sustained in the long term, however this doesnt also equate to an equally speedy up and leave mentality. I think we’re still way way off the peak of adoption in social networking sites, and there are countless scores more to emerge and challenge for a place among the frontrunners.

Facebook is going along the right route to stay ahead at the moment, their new portlet like application integration APIs mean they can function as an aggregator for data from other networking sites. This level of flexibility is whats needed to stay in the front runner position, I’m wondering if they’re now the first fully social networked enabled portal site ?

Google recently acquired a company called Neven Vision whos description on Googles blog is as follows

Neven Vision comes to Google with deep technology and expertise around automatically extracting information from a photo. It could be as simple as detecting whether or not a photo contains a person, or, one day, as complex as recognizing people, places, and objects. This technology just may make it a lot easier for you to organize and find the photos you care about. We don’t have any specific features to show off today, but we’re looking forward to having more to share with you soon.

Neven Visions technology has also been used in conjuction with Logitech to produce Facial movement tracking technology for use with standard webcams, this sort of stuff would help really bring avatar to avatar interactions to life.

This stuff might look like kids play, but there is some serious comp/sci theory going on in the background here.

Another clever play in the virtual worlds space for Google, or just a coincidence ?

During the course of some investigations into 3D Flash options by Jay Dykes our Meadan graphic designer (and ace photographer) he came across the Papervision3D open source project.

Its a 3D library written in action script for Flash and looks pretty interesting, it supports a variety of formats including the Collada standard for digital asset exchange.

The hot new thing for today seems to be Yahoo pipes which Andy pointed out to me. Roo has already had a quick go.

I’ve had a little play around and it looks very promising, the interface is nice especially the little bendy pipe connections. I’d say it’s pretty much pushing the bounds of what DHTML is capable of and it just goes to show how far browser technology has come in the last 5 years. I remember only 3 or 4 years ago the professional mantra coming from senior web architects was to use as little client side script as possible, I used to have a hard time convincing them that it was ok to use a bit of javascript and could make sites more useable.

I can’t go on without linking it to the QEDWiki project, which is also aimed at providing a platform for creating Mashups. However the difference is that QEDWiki is aimed more at being a Mashup technology for the enterprise, you can download it install it within the company firewall. Then just hook it into your internal company feeds pull in any external sources you need and quickly create situational applications that can be used for specific projects or situations that arise in day to day business.

Back on the Yahoo Pipes theme though, here’s the result of my quick play around. It’s basically a filter on a bunch of secondlife feeds to return any the mention IBM in the content.

Here’s the feed

A great little video showing the evolution of the Web and our awakening to its uses. From Michael Wesch of Kansas State University.