Skip to content

Open Infrastructure Map, a view of infrastructure data in OpenStreetMap

851 B
Raw Blame
import decimal
from typing import Any, Sequence

import pandas as pd
from bokeh.plotting import figure as bokeh_figure
from sqlalchemy import Row


def result_to_df(result: Sequence[Row[Any]]) -> pd.DataFrame:
    return pd.DataFrame.from_records(
        [
            dict((k, float(v) if isinstance(v, decimal.Decimal) else v) for k, v in row._mapping.items())
            for row in result
        ]
    )


def figure(**kwargs):
    kwargs = {
        "width": 600,
        "height": 400,
        "sizing_mode": "stretch_width",
        "tools": "box_zoom,reset",
        **kwargs,
    }
    fig = bokeh_figure(**kwargs)
    fig.toolbar.active_drag = None
    fig.toolbar.active_scroll = None
    fig.toolbar.active_tap = None
    fig.outline_line_width = 0
    fig.xgrid.grid_line_color = None
    fig.ygrid.grid_line_alpha = 0.5
    return fig