OpenStreetBugs/osmbugszweinull

From OpenStreetMap Wiki
Jump to: navigation, search

OSMBugs prequel a.k.a. osmreports/osminsect/osmharmony

In case the project will be called OSMinsects insects should express that the application consists no longer only ordinary bugs but also all kinds of insects.

Insect Species

One evolutionary thing about this new service should be that insects can be separated into different species. Every entomologist can filter the insects to only see their favourite species. The good thing with theses loose species (tags), we are not bound to a fixed set. Every entomologist could create their own species though clients may only support a fixed set for filtering.

Possible species:

  • missing - a place on the map where something is missing, only insects own this place
  • wrong - something is wrong here, maybe the insects damaged it?
  • routing - something wring in the routing i.e. turn-restrictions, insects may have conquered a crossing?
  • bicycle - some cycle related stuff, maybe the insects only drive beetles?
  • ...

state of insects

Every insect should have a state. The entomologist (user) should be able to see if an insect needs their attention. There should be at least four different kind of states

  • born - this is a new one (open)
  • stasis - this is a fixed problem (fixed)
  • sleeping - a closed one not fixed (closed)
  • awake - a reopened one (reopened)

users

The service should provide a kind of authentication. This authentication will not be required but possible. An entomologist that want to login can do, but doesn't have to. To save every one in creating a new set of username:password the service will use OAUTH against the OSM DB. If there are some parts of the service that require authentication is not yet decided. A possible situation could be that only logged in entomologists can wakeup (reopen) an insect.

tech stuff

DB schema

insects a.k.a. bugs:

  • ID - number
  • POINT - geom
  • TEXT - text
  • STATE - text (see above for state types)
  • SPECIES - text (a.k.a. tags see above for possible ones)
  • DATE - date
  • OSM_USER_ID - number
  • ENT_NAME - text (entomologist name a.k.a. username)

chitin a.k.a. notes:

  • ID - number
  • INSECT_ID - number
  • TEXT - text
  • DATE - date
  • OSM_USER_ID - number
  • ENT_NAME - text (entomologist name a.k.a. username)

genealogy a.k.a. bug_versions

  • ID - number
  • INSECT_ID - number
  • POINT - geom
  • TEXT - text
  • STATUS - text
  • TAGS - text
  • DATE - date
  • OSM_USER_ID - number
  • ENT_NAME - text (entomologist name a.k.a. username)

Old DB import

Bugs from old database should be imported with a special tag i.e. "ordinary_bug" a.k.a. "old_db".