In [ ]:
__copyright__ = "Reiner Lemoine Institut"
__license__ = "GNU Affero General Public License Version 3 (AGPL-3.0)"
__url__ = "https://github.com/openego/data_processing/blob/master/LICENSE"
__author__ = "Ludee"
In [ ]:
from IPython.core.display import HTML
import requests
import pandas as pd
# oedb
oep_url= 'http://oep.iks.cs.ovgu.de/'
# token
your_token = '' # no token needed for GET method!
In [ ]:
# select data
schema = 'boundaries'
table = 'bkg_vg250_2_lan'
where = 'reference_date=2016-01-01'
column = 'column=id&column=gen&column=geom'
orderby = 'order_by=gen'
result = requests.get(oep_url+'/api/v0/schema/'+schema+'/tables/'+table+'/rows/?where='+where+'&'+column+'&'+orderby, )
result.status_code
In [ ]:
df = pd.DataFrame(result.json())
df
In [ ]: