To generate a response containing a representation of all arenas, a query is made using the SQLAlchemy ORM. To convert the query results into GeoJSON, a list comprehension is used to generate a list of dictionaries that describe each arena returned from the ORM query. The resulting list (data) is then added to a dictionary, which is converted from a Python dictionary to a JSON object using the jsonify function:
@app.route('/nba/api/v0.1/arena', methods=['GET'])def get_arenas(): arenas = session.query(Arena).all() data = [{"type": "Feature", "properties":{"name":arena.name, "id":arena.id}, "geometry":{"type":"Point", "coordinates":[round(arena.longitude,6), round(arena.latitude,6)]}, } for arena in arenas] return jsonify({"type": ...
