def get_download_urls(query, params):
urls = {}
args = copy.copy(params)
for fmt in ['csv', 'geojson', 'svg', 'kml', 'shp']:
args['format'] = fmt
urls[fmt] = cdb.get_url(query, args)
return urls
def download(params):
if 'geom' in params:
query = DOWNLOAD_GEOM.format(**params)
else:
query = DOWNLOAD.format(**params)
params['filename'] = 'gfw_imazon_{begin}_to_{end}'.format(**params)
return cdb.get_url(query, params)
def get_download_urls(query, params):
urls = {}
args = copy.copy(params)
for fmt in ['csv', 'geojson', 'svg', 'kml', 'shp']:
args['format'] = fmt
urls[fmt] = cdb.get_url(query, args)
return urls
def download(params):
params['select_geom'] = ', c.the_geom'
geom = params.get('geom')
if geom:
query = ANALYSIS_GEOM.format(**params)
else:
query = ANALYSIS.format(**params)
return cdb.get_url(query, params=dict(format=params['format']))
def download(params):
"""Return CartoDB download URL for supplied parameters."""
if 'geom' in params:
query = GEOJSON_GEOM_SQL.format(**params)
elif 'iso' in params:
query = ISO_GEOM_SQL.format(**params)
else:
raise ValueError('FORMA download expects geom or iso parameter')
return cdb.get_url(query, params=dict(format=params['format']))
def download(params):
params["select_geom"] = ", c.the_geom"
geom = params.get("geom")
if geom:
query = ANALYSIS_GEOM.format(**params)
params["filename"] = "gfw_quicc_{date}".format(**params)
else:
query = ANALYSIS.format(**params)
params["filename"] = "gfw_quicc_{iso}_{date}".format(**params)
return cdb.get_url(query, params)
def download(params):
"""Return CartoDB download URL for supplied parameters."""
if 'format' in params and params.get('format') != 'csv':
params['select'] = ', the_geom'
else:
params['select'] = ''
if 'geom' in params:
query = GEOJSON_GEOM_SQL.format(**params)
params['filename'] = 'gfw_forma_{begin}_to_{end}'.format(**params)
elif 'iso' in params:
query = ISO_GEOM_SQL.format(**params)
params['filename'] = 'gfw_forma_{iso}_{begin}_to_{end}'.format(**params)
else:
raise ValueError('FORMA download expects geom or iso parameter')
return cdb.get_url(query, params)
def execute(cls, args, sql):
try:
query, download_query = sql.process(args)
download_url = cdb.get_url(download_query, args)
if 'format' in args:
return 'redirect', download_url
else:
action, response = 'respond', cdb.execute(query)
response = cls._query_response(response, args, query)
response['download_urls'] = get_download_urls(
download_query, args)
if 'error' in response:
action = 'error'
return action, response
except Exception, e:
return 'execute() error', e
def download(params):
"""Return CartoDB download URL for supplied parameters."""
begin = params.get('begin')
if len(begin) == 4:
begin = '%s-01-01' % begin
params['begin'] = begin
end = params.get('end')
if len(end) == 4:
end = '%s-01-01' % end
params['end'] = end
if 'format' in params and params.get('format') != 'csv':
params['select'] = ', the_geom'
else:
params['select'] = ''
if 'geom' in params:
query = GEOJSON_GEOM_SQL.format(**params)
params['filename'] = 'gfw_forma_{begin}_to_{end}'.format(**params)
elif 'iso' in params:
query = ISO_GEOM_SQL.format(**params)
params['filename'] = 'gfw_forma_{iso}_{begin}_to_{end}'.format(
**params)
else:
raise ValueError('FORMA download expects geom or iso parameter')
return cdb.get_url(query, params)
def download(params):
if 'geom' in params:
query = DOWNLOAD_GEOM.format(**params)
else:
query = DOWNLOAD.format(**params)
return cdb.get_url(query, params)
