Open Infrastructure Map, a view of infrastructure data in OpenStreetMap
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