def index():
return render_template(
'index.html',
region_groups=RegionGroup.query(),
version=DumpVersion.query().one(),
export_url=app.env.config['web'].get('export_url', None)
)
def region(code):
region = Region.filter_by(code=code).one()
qgeom = DBSession.execute(
"""SELECT
ST_AsGeoJSON(ST_Difference(geom_out, geom_in )) AS ring,
ST_AsGeoJSON(geom) AS geom,
ST_AsGeoJSON(eval(expression)) AS current,
ST_XMin(geom_out) AS min_x,
ST_XMax(geom_out) AS max_x,
ST_YMin(geom_out) AS min_y,
ST_YMax(geom_out) AS max_y
FROM region WHERE id = :id""",
dict(id=region.id)
).fetchone()
return render_template(
'region.html',
region=region,
qgeom=qgeom,
version=DumpVersion.query().one(),
export_url=app.env.config['web'].get('export_url', None),
)
