yakima AP entry

[Don Park]

http://geomena.org/ap/00184dcd9585

im sitting in a conference room in the KOIN tower downtown and the
access point is in geomena as being in Yakima Washington.

any idea how that AP got in the db?

just curious,
don

[Don Park]

I'm suddenly realizing and edit history for an AP would be
interesting. like a changes page on a wiki, which geomena aims to be
:)

don

[Aaron Parecki]

Strange. That mac address isn't in my database so it didn't come from me :)

I was just about to suggest some sort of logging of edits. You could make a separate table for history, showing date, IP address, API key, etc for entries added.

aaronpk

On Tue, Mar 2, 2010 at 7:04 PM, Don Park <don....@gmail.com> wrote:

[AdamD]

Don't we get revisions along with Couch? It's just a matter of
surfacing them, right?

I think an edit history would be very beneficial. For example, at
WhereCamp PDX we talked about using it to take the last few entries
that are near each other and re-setting an "average" location for the
AP.

On Mar 2, 7:06 pm, Don Park <don.p...@gmail.com> wrote:
> I'm suddenly realizing and edit history for an AP would be
> interesting. like a changes page on a wiki, which geomena aims to be
> :)
>
> don
>

[Aaron Parecki]

That's what I'm doing with my data, I've taken the average of every lat/lng point I've seen for an AP and used that to draw it on the map. Since I've been driving to collect most of my data, I will log every access point as being in the middle of the road. But once I see an AP from both sides of a block it will show up as being in the middle.

iirc the database stores multiple records for a mac address and only uses the latest one when displaying it on the site. I have no idea what the code would look like to calculate the average using the history tho.

aaronpk

[Don Park]

CouchDB does keep old versions but it considers them disposable. There
is a vacuum function of some sort that will remove all older versions.
So the geomena app might need to do some special work to make old
versions real documents that will stay around.

Don

On Tue, Mar 2, 2010 at 8:45 PM, AdamD <duva...@gmail.com> wrote: