2010-06-28

03:03 maxticket1 joined #geoloqi
07:23 caseorganic joined #geoloqi
08:57 workshop joined #geoloqi
11:00 jtbandes joined #geoloqi
11:00 workshop joined #geoloqi
11:00 Loqi joined #geoloqi
11:00 donpdonp joined #geoloqi
12:14 <aaronpk> that's awesome
12:16 <aaronpk> that is an awesome feature for playing back a saved track
12:16 <aaronpk> donpdonp: check out jtbandes' link above
12:17 <aaronpk> I had a thought about how to do the saved track thing like you mentioned
12:26 <jtbandes> It's also trivial to export KML, which should be included as a feature eventually
12:37 <maxticket1> I'm working on the landing page today. I imagine it'll use text from the Dev site? And there'll be a How It Works page too.
12:58 caseorganic joined #geoloqi
13:55 <donpdonp> jtbandes: zomg awesome
13:55 <donpdonp> jtbandes: how did you record that data?
13:55 <jtbandes> uh, with Geoloqi :)
13:56 <donpdonp> jtbandes: woo!
14:03 <donpdonp> aaronpk: did you get my DM? im gonna see mobile portland tonight. you might want go too
14:08 <donpdonp> aaronpk: ignore that. im going to nopoconi. sorry for the confusion
14:14 <caseorganic> hey, i want to see the sweet data.
14:27 <donpdonp> caseorganic: are you bringing home that robot you were holding? it looks awesome
14:29 <caseorganic> no, unfortunately - it was very expensive
14:30 <caseorganic> cool, great data! thanks, jtbandes!
14:30 <donpdonp> maybe if you simply asked it to get to SE Portland, it would walk there
14:31 <donpdonp> :)
14:31 <caseorganic> nice! wish i could
14:31 <caseorganic> this map is beautiful!
14:34 paiges joined #geoloqi
14:39 <aaronpk> yea!
14:39 <aaronpk> donpdonp: see you at nopoconi!
14:39 <donpdonp> aaronpk: roger that, echo base. red 5 standing by.
14:44 <caseorganic> will not see either of you at nocoponi
14:44 <caseorganic> am still in sf
14:44 <caseorganic> but will be back tonight
14:44 <donpdonp> caseorganic: im looking forward to hearing about foocamp.
14:46 <caseorganic> i'm looking forward to talking more about it!
14:46 <caseorganic> i'll hopefully see you soon
14:46 <caseorganic> btw do you need anything for geoloqi android edition that i can help with?
14:47 <aaronpk> donpdonp is going to help get me set up with android dev tonight so I can work on geoloqi too
14:47 <donpdonp> not that i can think of. aaronpk and i are meeting at nopoconi to look at it
14:50 <caseorganic> hooray! okay! yeah!
14:57 <donpdonp> i still want that robot.
14:57 <caseorganic> me too.
14:57 <donpdonp> i seriously think i could take over the world with one of those
14:58 <donpdonp> then id put an end to non-functioning crosswalk push-buttons forever! bwwaahaaahaa!
14:58 <aaronpk> could you put in a crosswalk at 22nd & hawthorne while you're at it too?
14:59 <donpdonp> sure. would you like a 'people-mover' conveyor belt from your doorstep to downtown as well?
14:59 <aaronpk> how about a zipline?
14:59 <donpdonp> oh rad. okay
14:59 <donpdonp> how would you hold your coffee then? it might spil
15:02 <caseorganic> yes, i wuld like that very much!!!
15:03 <caseorganic> i have a robot video
15:04 <caseorganic> it will be uploaded soo
15:04 <caseorganic> n
15:04 <donpdonp> woo.
15:04 <aaronpk> yeah!!
15:33 <caseorganic> here's the dancing robot!
15:34 <aaronpk> holy crap
15:34 <Loqi> sucker
15:34 <aaronpk> that's awesome
15:39 <donpdonp> did i miss the link?
15:41 <caseorganic> oh jeez. i forgot the link
15:47 <donpdonp> omg want.
15:48 <donpdonp> caseorganic: are you allowed to say who makes it
15:48 <caseorganic> donpdonp: darn
15:48 <caseorganic> i don't know
15:48 <donpdonp> caseorganic: no worries
15:49 <caseorganic> i don't remember
15:50 <donpdonp> if its not a small outfit, id say its made by sony because it looks like a similar style to the Rolly http://www.youtube.com/watch?v=HTxdKi77G20
15:50 <donpdonp> and sony loves robots
15:50 <donpdonp> super-pets
15:51 <donpdonp> er, super-toys they're called in that staney kubrick film
15:53 <caseorganic> it probably is!
16:30 workshop joined #geoloqi
16:34 <workshop> jtbandes: awesome map
16:35 <jtbandes> Thanks
17:48 paiges joined #geoloqi
18:12 maxticket joined #geoloqi
19:07 jtbandes_ joined #geoloqi
19:40 jtbandes joined #geoloqi
19:54 caseorganic joined #geoloqi
19:55 <caseorganic> teddybear3000 was the best
19:55 <caseorganic> livestream nocoponi!!
20:20 <aaronpk> haha can you skype right now?
20:20 <aaronpk> caseorganic ping
20:20 <Loqi> ahahahaha
20:22 <aaronpk> caseorganic: http://qik.com/aaronpk
20:49 Schuyler joined #geoloqi
20:50 <Schuyler> donpdonp!
21:06 <donpdonp> Schuyler!
21:06 <donpdonp> hows it goin
21:11 <Schuyler> living in SF now
21:12 <donpdonp> ah. im still in portland.
21:12 <donpdonp> doing contract rails programming
21:12 <donpdonp> with android as a side interest
21:12 <Schuyler> I figured as much! this is a PDX heavy channel
21:12 <Schuyler> I just met Amber and Mario a couple hours ago
21:12 <donpdonp> yup. im on a personaltelco node right now :)
21:13 <donpdonp> Schuyler: cool.
21:13 <Schuyler> Personal Telco is the only one of the original Free Networks to stand the test of time
21:13 <Schuyler> I still wear my t-shirt proudly.
21:13 <aaronpk> geoloqi is sorta a pdx project right now ;)
21:13 <Schuyler> that much is clear
21:14 <donpdonp> Schuyler: the only one?? nyc wireless?
21:14 <donpdonp> i havent been following any others
21:14 <Schuyler> so I totally wish using SimpleGeo was an option here
21:14 <donpdonp> i figured they were mostly around
21:15 <Schuyler> Geoloqi is an absolutely perfect application for our platform
21:15 <Schuyler> donpdonp: NYC Wireless is still around, but the nodes don't seem to be good for much
21:15 <donpdonp> Schuyler: are you working for simplegeo?
21:15 <Schuyler> the Bryant Park node is down completely
21:15 <Schuyler> yeah -- that's why I moved back to SF
21:16 <Schuyler> and SimpleGeo's data store would solve the scaling problems that Geoloqi is going to have
21:17 <aaronpk> I missed the part about why it isn't an option
21:17 <donpdonp> geoloqi could have support for different kinds of storage
21:22 <donpdonp> Schuyler: what do you do for simplegeo?
21:22 <donpdonp> donpdonp runs next door. bbiab
21:29 <Schuyler> aaronpk, it's a free but proprietary service. think appengine for geo.
21:30 <Schuyler> the geoloqi stuff all seems very die hard Free Softwarrific which is my default, but SG is paying me the proverbial to boldly index what no one has indexed et cetera
21:31 <Schuyler> from a technical standpoint I recommend checking out SimpleGeo
21:31 <aaronpk> is there API documentation somewhere?
21:32 <Schuyler> but the company is a startup and plans to make money somehow
21:32 <aaronpk> I managed to find this, is this the complete list of services provided? http://simplegeo.com/tour/tools/
21:33 <Schuyler> alternately I have a PDF I wrote for a client that explains how to do proximity queries in MySQL
21:33 <Schuyler> which you're welcome to. Amber said you guys hadn't implemented the geofencing stuff yet
21:33 <Schuyler> you could try doing it all in MySQL as scaling that up is kind of a known quantity
21:33 <aaronpk> Ah, interesting. Currently we're doing geofencing with just a simple radius calculation.
21:34 <aaronpk> doing some trig in the mysql query to calculate distance between two lat/long points
21:34 <Schuyler> yeah
21:34 <Schuyler> link me to where in the github code?
21:34 <aaronpk> But I don't see that scaling very well
21:34 <Schuyler> I looked but didn't see it
21:34 <Schuyler> (didn't look hard)
21:34 <Loqi> that's what she said!
21:35 <aaronpk> it's not in the github project yet, it's in the pre-alpha version
21:35 <Schuyler> ok
21:35 <Schuyler> dinner's on the table, but I'll find you the guide I wrote to doing proximity queries in MySQL
21:35 <aaronpk> awesome, thanks!
21:36 <Schuyler> biab
21:38 <aaronpk> here is the query I'm using now to find the closest place to a given lat/long. http://gist.github.com/456800 There are some obvious optimizations I could do to this given a much larger set of places.
21:48 <Schuyler> hmm yeah that's going to do a full table scan
21:51 <aaronpk> obviously an index on the lat/long would help, and then I could trim the table down with a where clause to do the math on a much smaller region
21:51 <aaronpk> but of course this limits places being defined by circles, or collections of circles.
21:52 <Schuyler> ah you want geometries?
21:52 <aaronpk> so far circles have been sufficient, but it might be nice
21:52 <Schuyler> you want PostGIS, then
21:52 <Schuyler> er. well. I guess there's MySQL Spatial.
21:53 <Schuyler> all of this points to SimpleGeo being a good idea, of course, unless this is a software development project and not just a monolithic platform
21:54 <aaronpk> I could see writing an API where the server could ask "give me the location closest to x" and the request is fulfilled with different backends. The default project could use MySQL and assume it's a single-user installation where there wouldn't be scaling issues, and the live geoloqi.com site could use simplegeo as a backend
21:55 <Schuyler> yes, a nice clean abstraction layer would give you some options
21:58 <aaronpk> that's probably the right way to do it. I can see my MySQL database's legs are trembling at the thought of much traffic.
21:59 <Schuyler> yes, success is its own worst enemy when it comes to these things
22:00 <Schuyler> anyway. sorry for the PDF. that seemed like the way to justify charging the most money for it at the time.
22:00 <aaronpk> haha, nice
22:02 <Schuyler> I should reformat this as HTML and just blat it on the web
22:05 <Schuyler> wow I shoulda read that before posting it... it's old. but it'll probably still work for basic bounding box queries, and I did test that MySQL will use the multi column index on those queries
22:06 <Schuyler> but that is a much deeper rabbit hole
22:07 <Schuyler> "Currently, MySQL does not implement these functions according to the specification. Those that are implemented return the same result as the corresponding MBR-based functions."
22:07 <Schuyler> argh, they just don't care.
22:07 <aaronpk> heh, yea, good idea with the bounding box.
22:08 <aaronpk> doesn't implement the geo functions?
22:08 <Schuyler> anyway, that's three directions right there towards scaling up a bit
22:09 <aaronpk> Can you tell me more about how simplegeo could be used?
22:10 <aaronpk> oh actually, gotta go pick up caseorganic from the airport! She got in early.
22:10 <aaronpk> back in a bit
23:11 maxticket joined #geoloqi
23:15 <aaronpk> I'll be online tomorrow, maybe we can chat a bit more then.
23:22 <aaronpk> ping
23:22 <Loqi> pong
23:23 <Schuyler> word nn
23:23 <Schuyler> but first: listen
23:23 <Schuyler> and you can ask anselm about this
23:23 <Schuyler> we have been waiting seven years for this
23:23 <Schuyler> tomorrow is no rush
23:23 maxticket1 joined #geoloqi