Towards a common DB and API


#1

##· Goal progressive refactoring of the data base towards an in common mapping infrastructure
step 1 integrating RCR database determining the Smallest Common Denominator
https://framacalc.org/taxinomies

Lister les modèles de sources de RCR:

  • flux RSS
  • imported Geo Json

This refactoring aims to create a new model for the common database and make it accessible through a shared API for which we need to commonly identify the characteristics, here are some of the issues we identified

APPLi

ACCOUNT

USER
    username
    name
    city
    country
    email

TAXONOMY

SECTION
    section-id
    name
    decription
    icon
    rank
TAG
    name
    color
EXPORT

EMBED
    center
    zoom
    sections
    tag(s)

DATA

RESSOURCE MANAGER TYPE

MANAGER
    code
    name
    type

PROPERTIES

THING
    fountain
    sculpture
PLACE
    vegetable garden
SERVICE
    mobile kitchen
    shower
COLLECTION
    cycling path
    cultural walk
ORGANIZATION
    zinneke

Design for Participation

Design for participation is key to dealing with data obsolescence
We identified several steps

  • first determine criteria for data obsolescence, for example a fountain does not move as quickly as a repair cafe, but might have other issues for example a fountain can loose its accessibility because of privatisation or else.

  • Build an interface to signal the problem, it can be an email reminder, or it can be linked to the mobile version calling the user, in all cases it should allow the user to flag a point or to validate it and if several users do so then the issue concerning the point rises in importance.

Geometrie

  • Type Point or Surface
  • Coordinates: (x,y) or (Polygone)

Properties

  • JSon Object

Determine the basic operations of the API

Define API methods :

  • Path
  • Arguments
  • Solidity

GET/ lists API methods
GET/MODEL
GET/CATEGORIES lists API categories
GET/POSITION point (x,y)


Notes de la rencontre du 5 juillet 2017 (Boom Café)
En attendant l'API
Roadmap In Common