Trees

An API for Berlin's street trees. Based on Django and PostgreSQL/PostGIS.

Trees are extracted from Baumbestand Berlin.

Overview

• Data source: Baumbestand Berlin
• Data extraction via codeforberlin/wfs-downloader
• This is the API
• Map for trees.codefor.de via codeforberlin/trees-map
• The map tiles and also the tree tiles are generated using codeforberlin/trees-mapnik

Somewhat related

• codeforberlin/treemeta collects botanical names which might be integrated in the API or by a client application.
• codeforberlin/tree-column-names is not directly used in this project but the basis for the column-names.json that is used.

Roadmap / features

• Command to import GML file
• API endpoint to filter by properties
• API endpoint to filter by distance from point
• API endpoint to filter by bounding box
• Filter combining by properties, distance from point, bounding box (Django filters, DRF-GIS)
• Advanced filtering such as greater then year, fuzzy search on strings
• Server-side clustering

tbc.

Set up

$ git clone https://github.com/codeforberlin/trees-api
$ cd trees
$ virtualenv env
$ source env/bin/activate
$ pip install -r requirements.txt
$ cp trees/settings/sample.local.py trees/settings/local.py

edit trees/settings/local.py for your database connection

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'NAME': 'trees',
        'USER': 'postgres',
        'PASSWORD': 'secret',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

$ ./manage.py migrate
$ ./manage.py createsuperuser
$ ./manage.py ingest GMLFILE 2016-02-29T13:00Z
$ ./manage.py runserver

go to http://localhost:8000/admin/ or http://localhost:8000

Making Queries

REST style object retrieval

http://localhost:8000/trees/
http://localhost:8000/trees/1

Location queries

Distance to point

http://localhost:8000/trees/?dist=100&point=13.381018,52.498606

On TMS tile

http://localhost:8000/trees/?tile=15/17602/10749

In bounding box

http://localhost:8000/trees/?in_bbox=13.20,52.427,13.21,52.428

Properties

http://localhost:8000/trees/?art_dtsch=LINDE&bezirk=Spandau