text: --DO NOT MODIFY THIS FILE, IT IS GENERATED AUTOMATICALLY FROM SOURCES
  -- Complain if script is sourced in psql, rather than via CREATE EXTENSION
  \echo Use "ALTER EXTENSION cdb_dataservices_server UPDATE TO '0.29.0'" to load this file. \quit
  
  -- HERE goes your code to upgrade/downgrade
  DROP FUNCTION IF EXISTS cdb_dataservices_server._cdb_mapbox_route_with_waypoints(username TEXT, orgname TEXT, waypoints geometry(Point, 4326)[], mode TEXT);
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_route_point_to_point(
    username TEXT,
    orgname TEXT,
    origin geometry(Point, 4326),
    destination geometry(Point, 4326),
    mode TEXT,
    options text[] DEFAULT ARRAY[]::text[],
    units text DEFAULT 'kilometers')
  RETURNS cdb_dataservices_server.simple_route AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.tools import Logger
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_routing_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_routing_config = GD["user_routing_config_{0}".format(username)]
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
  
    with metrics('cdb_route_with_point', user_routing_config, logger):
      waypoints = [origin, destination]
      mapzen_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server._cdb_mapzen_route_with_waypoints($1, $2, $3, $4, $5, $6) as route;", ["text", "text", "geometry(Point, 4326)[]", "text", "text[]", "text"])
      result = plpy.execute(mapzen_plan, [username, orgname, waypoints, mode, options, units])
      return [result[0]['shape'],result[0]['length'], result[0]['duration']]
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_route_with_waypoints(
    username TEXT,
    orgname TEXT,
    waypoints geometry(Point, 4326)[],
    mode TEXT,
    options text[] DEFAULT ARRAY[]::text[],
    units text DEFAULT 'kilometers')
  RETURNS cdb_dataservices_server.simple_route AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.tools import Logger
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_routing_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_routing_config = GD["user_routing_config_{0}".format(username)]
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
  
    with metrics('cdb_route_with_waypoints', user_routing_config, logger):
      mapzen_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server._cdb_mapzen_route_with_waypoints($1, $2, $3, $4, $5, $6) as route;", ["text", "text", "geometry(Point, 4326)[]", "text", "text[]", "text"])
      result = plpy.execute(mapzen_plan, [username, orgname, waypoints, mode, options, units])
      return [result[0]['shape'],result[0]['length'], result[0]['duration']]
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_geocode_street_point(username TEXT, orgname TEXT, searchtext TEXT, city TEXT DEFAULT NULL, state_province TEXT DEFAULT NULL, country TEXT DEFAULT NULL)
  RETURNS Geometry AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.tools import Logger,LoggerConfig
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_geocoder_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_geocoder_config = GD["user_geocoder_config_{0}".format(username)]
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
  
    with metrics('cdb_geocode_street_point', user_geocoder_config, logger):
      if user_geocoder_config.heremaps_geocoder:
        here_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_here_geocode_street_point($1, $2, $3, $4, $5, $6) as point; ", ["text", "text", "text", "text", "text", "text"])
        return plpy.execute(here_plan, [username, orgname, searchtext, city, state_province, country], 1)[0]['point']
      elif user_geocoder_config.google_geocoder:
        google_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_google_geocode_street_point($1, $2, $3, $4, $5, $6) as point; ", ["text", "text", "text", "text", "text", "text"])
        return plpy.execute(google_plan, [username, orgname, searchtext, city, state_province, country], 1)[0]['point']
      elif user_geocoder_config.mapzen_geocoder:
        mapzen_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_mapzen_geocode_street_point($1, $2, $3, $4, $5, $6) as point; ", ["text", "text", "text", "text", "text", "text"])
        return plpy.execute(mapzen_plan, [username, orgname, searchtext, city, state_province, country], 1)[0]['point']
      else:
        raise Exception('Requested geocoder is not available')
  
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  DROP FUNCTION IF EXISTS cdb_dataservices_server.cdb_mapbox_geocode_street_point(username TEXT, orgname TEXT, searchtext TEXT, city TEXT, state_province TEXT, country TEXT);
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server._cdb_mapzen_geocode_street_point(username TEXT, orgname TEXT, searchtext TEXT, city TEXT DEFAULT NULL, state_province TEXT DEFAULT NULL, country TEXT DEFAULT NULL)
  RETURNS Geometry AS $$
    from cartodb_services.tools import ServiceManager
    from cartodb_services.mapzen import MapzenGeocoder
    from cartodb_services.mapzen.types import country_to_iso3
    from cartodb_services.refactor.service.mapzen_geocoder_config import MapzenGeocoderConfigBuilder
  
    import cartodb_services
    cartodb_services.init(plpy, GD)
  
    service_manager = ServiceManager('geocoder', MapzenGeocoderConfigBuilder, username, orgname)
    service_manager.assert_within_limits()
  
    try:
      geocoder = MapzenGeocoder(service_manager.config.mapzen_api_key, service_manager.logger, service_manager.config.service_params)
      country_iso3 = None
      if country:
        country_iso3 = country_to_iso3(country)
      coordinates = geocoder.geocode(searchtext=searchtext, city=city,
                                     state_province=state_province,
                                     country=country_iso3, search_type='address')
      if coordinates:
        service_manager.quota_service.increment_success_service_use()
        plan = plpy.prepare("SELECT ST_SetSRID(ST_MakePoint($1, $2), 4326); ", ["double precision", "double precision"])
        point = plpy.execute(plan, [coordinates[0], coordinates[1]], 1)[0]
        return point['st_setsrid']
      else:
        service_manager.quota_service.increment_empty_service_use()
        return None
    except BaseException as e:
      import sys
      service_manager.quota_service.increment_failed_service_use()
      service_manager.logger.error('Error trying to geocode street point using mapzen', sys.exc_info(), data={"username": username, "orgname": orgname})
      raise Exception('Error trying to geocode street point using mapzen')
    finally:
      service_manager.quota_service.increment_total_service_use()
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  DROP FUNCTION IF EXISTS cdb_dataservices_server._cdb_mapbox_geocode_street_point(username TEXT, orgname TEXT, searchtext TEXT, city TEXT, state_province TEXT, country TEXT);
  
  ---- cdb_geocode_namedplace_point(city_name text)
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_geocode_namedplace_point(username text, orgname text, city_name text)
  RETURNS Geometry AS $$
    import spiexceptions
    try:
      mapzen_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_mapzen_geocode_namedplace($1, $2, $3) as point;", ["text", "text", "text"])
      return plpy.execute(mapzen_plan, [username, orgname, city_name])[0]['point']
    except spiexceptions.ExternalRoutineException as e:
      internal_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_internal_geocode_namedplace($1, $2, $3) as point;", ["text", "text", "text"])
      return plpy.execute(internal_plan, [username, orgname, city_name])[0]['point']
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  ---- cdb_geocode_namedplace_point(city_name text, country_name text)
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_geocode_namedplace_point(username text, orgname text, city_name text, country_name text)
  RETURNS Geometry AS $$
    import spiexceptions
    try:
      mapzen_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_mapzen_geocode_namedplace($1, $2, $3, NULL, $4) as point;", ["text", "text", "text", "text"])
      return plpy.execute(mapzen_plan, [username, orgname, city_name, country_name])[0]['point']
    except spiexceptions.ExternalRoutineException as e:
      internal_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_internal_geocode_namedplace($1, $2, $3, NULL, $4) as point;", ["text", "text", "text", "text"])
      return plpy.execute(internal_plan, [username, orgname, city_name, country_name])[0]['point']
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  ---- cdb_geocode_namedplace_point(city_name text, admin1_name text, country_name text)
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_geocode_namedplace_point(username text, orgname text, city_name text, admin1_name text, country_name text)
  RETURNS Geometry AS $$
    import spiexceptions
    try:
      mapzen_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_mapzen_geocode_namedplace($1, $2, $3, $4, $5) as point;", ["text", "text", "text", "text", "text"])
      return plpy.execute(mapzen_plan, [username, orgname, city_name, admin1_name, country_name])[0]['point']
    except spiexceptions.ExternalRoutineException as e:
      internal_plan = plpy.prepare("SELECT cdb_dataservices_server._cdb_internal_geocode_namedplace($1, $2, $3, $4, $5) as point;", ["text", "text", "text", "text", "text"])
      return plpy.execute(internal_plan, [username, orgname, city_name, admin1_name, country_name])[0]['point']
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  DROP FUNCTION IF EXISTS cdb_dataservices_server._cdb_mapbox_geocode_namedplace(username text, orgname text, city_name text, admin1_name text, country_name text);
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server._cdb_mapzen_geocode_namedplace(username text, orgname text, city_name text, admin1_name text DEFAULT NULL, country_name text DEFAULT NULL)
  RETURNS Geometry AS $$
    from cartodb_services.mapzen import MapzenGeocoder
    from cartodb_services.mapzen.types import country_to_iso3
    from cartodb_services.metrics import QuotaService, metrics
    from cartodb_services.tools import Logger,LoggerConfig
  
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_geocoder_config({0}, {1}, {2})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname), plpy.quote_nullable('mapzen')))
    user_geocoder_config = GD["user_geocoder_config_{0}".format(username)]
  
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
    quota_service = QuotaService(user_geocoder_config, redis_conn)
    if not quota_service.check_user_quota():
      raise Exception('You have reached the limit of your quota')
  
    with metrics('cdb_geocode_namedplace_point', user_geocoder_config, logger):
      try:
        geocoder = MapzenGeocoder(user_geocoder_config.mapzen_api_key, logger)
        country_iso3 = None
        if country_name:
          country_iso3 = country_to_iso3(country_name)
        coordinates = geocoder.geocode(searchtext=city_name, city=None,
                                      state_province=admin1_name,
                                      country=country_iso3, search_type='locality')
        if coordinates:
          quota_service.increment_success_service_use()
          plan = plpy.prepare("SELECT ST_SetSRID(ST_MakePoint($1, $2), 4326); ", ["double precision", "double precision"])
          point = plpy.execute(plan, [coordinates[0], coordinates[1]], 1)[0]
          return point['st_setsrid']
        else:
          quota_service.increment_empty_service_use()
          return None
      except BaseException as e:
        import sys
        quota_service.increment_failed_service_use()
        logger.error('Error trying to geocode city point using mapzen', sys.exc_info(), data={"username": username, "orgname": orgname})
        raise Exception('Error trying to geocode city point using mapzen')
      finally:
        quota_service.increment_total_service_use()
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  DROP FUNCTION IF EXISTS cdb_dataservices_server._cdb_mapbox_isodistance(username TEXT, orgname TEXT, source geometry(Geometry, 4326), mode TEXT, data_range integer[], options text[]);
  
  DROP FUNCTION IF EXISTS cdb_dataservices_server._cdb_mapbox_isochrones(username TEXT, orgname TEXT, source geometry(Geometry, 4326), mode TEXT, data_range integer[], options text[]);
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_isodistance(username TEXT, orgname TEXT, source geometry(Geometry, 4326), mode TEXT, range integer[], options text[] DEFAULT array[]::text[])
  RETURNS SETOF cdb_dataservices_server.isoline AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.tools import Logger
  
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_isolines_routing_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_isolines_config = GD["user_isolines_routing_config_{0}".format(username)]
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
  
    if user_isolines_config.google_services_user:
      raise Exception('This service is not available for google service users.')
  
    with metrics('cb_isodistance', user_isolines_config, logger):
      if user_isolines_config.heremaps_provider:
        here_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server.cdb_here_isodistance($1, $2, $3, $4, $5, $6) as isoline; ", ["text", "text", "geometry(geometry, 4326)", "text", "integer[]", "text[]"])
        return plpy.execute(here_plan, [username, orgname, source, mode, range, options])
      elif user_isolines_config.mapzen_provider:
        mapzen_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server.cdb_mapzen_isodistance($1, $2, $3, $4, $5, $6) as isoline; ", ["text", "text", "geometry(geometry, 4326)", "text", "integer[]", "text[]"])
        return plpy.execute(mapzen_plan, [username, orgname, source, mode, range, options])
      else:
        raise Exception('Requested isolines provider is not available')
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  DROP FUNCTION IF EXISTS cdb_dataservices_server.cdb_mapbox_isodistance(username TEXT, orgname TEXT, source geometry(Geometry, 4326), mode TEXT, range integer[], options text[]);
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.cdb_isochrone(username TEXT, orgname TEXT, source geometry(Geometry, 4326), mode TEXT, range integer[], options text[] DEFAULT array[]::text[])
  RETURNS SETOF cdb_dataservices_server.isoline AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.tools import Logger
  
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_isolines_routing_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_isolines_config = GD["user_isolines_routing_config_{0}".format(username)]
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
  
    if user_isolines_config.google_services_user:
      raise Exception('This service is not available for google service users.')
  
    with metrics('cb_isochrone', user_isolines_config, logger):
      if user_isolines_config.heremaps_provider:
        here_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server.cdb_here_isochrone($1, $2, $3, $4, $5, $6) as isoline; ", ["text", "text", "geometry(geometry, 4326)", "text", "integer[]", "text[]"])
        return plpy.execute(here_plan, [username, orgname, source, mode, range, options])
      elif user_isolines_config.mapzen_provider:
        mapzen_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server.cdb_mapzen_isochrone($1, $2, $3, $4, $5, $6) as isoline; ", ["text", "text", "geometry(geometry, 4326)", "text", "integer[]", "text[]"])
        return plpy.execute(mapzen_plan, [username, orgname, source, mode, range, options])
      else:
        raise Exception('Requested isolines provider is not available')
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  DROP FUNCTION IF EXISTS cdb_dataservices_server.cdb_mapbox_isochrone(username TEXT, orgname TEXT, source geometry(Geometry, 4326), mode TEXT, range integer[], options text[]);
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.OBS_GetData(
    username TEXT,
    orgname TEXT,
    geomvals geomval[],
    params JSON,
    merge BOOLEAN DEFAULT True)
  RETURNS TABLE (
    id INT,
    data JSON
  ) AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.metrics import QuotaService
    from cartodb_services.tools import Logger,LoggerConfig
  
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_obs_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_obs_config = GD["user_obs_config_{0}".format(username)]
  
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
    quota_service = QuotaService(user_obs_config, redis_conn)
    if not quota_service.check_user_quota():
      raise Exception('You have reached the limit of your quota')
  
    with metrics('obs_getdata', user_obs_config, logger):
      try:
          obs_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server._OBS_GetData($1, $2, $3, $4, $5);", ["text", "text", "geomval[]", "json", "boolean"])
          result = plpy.execute(obs_plan, [username, orgname, geomvals, params, merge])
          empty_results = len(geomvals) - len(result)
          if empty_results > 0:
            quota_service.increment_empty_service_use(empty_results)
          if result:
            quota_service.increment_success_service_use(len(result))
            return result
          else:
            return []
      except BaseException as e:
          import sys
          quota_service.increment_failed_service_use(len(geomvals))
          logger.error('Error trying to OBS_GetData', sys.exc_info(), data={"username": username, "orgname": orgname})
          raise Exception('Error trying to OBS_GetData')
      finally:
          quota_service.increment_total_service_use(len(geomvals))
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.OBS_GetData(
    username TEXT,
    orgname TEXT,
    geomrefs TEXT[],
    params JSON)
  RETURNS TABLE (
    id TEXT,
    data JSON
  ) AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.metrics import QuotaService
    from cartodb_services.tools import Logger,LoggerConfig
  
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_obs_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_obs_config = GD["user_obs_config_{0}".format(username)]
  
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
    quota_service = QuotaService(user_obs_config, redis_conn)
    if not quota_service.check_user_quota():
      raise Exception('You have reached the limit of your quota')
  
    with metrics('obs_getdata', user_obs_config, logger):
      try:
          obs_plan = plpy.prepare("SELECT * FROM cdb_dataservices_server._OBS_GetData($1, $2, $3, $4);", ["text", "text", "text[]", "json"])
          result = plpy.execute(obs_plan, [username, orgname, geomrefs, params])
          empty_results = len(geomrefs) - len(result)
          if empty_results > 0:
            quota_service.increment_empty_service_use(empty_results)
          if result:
            quota_service.increment_success_service_use(len(result))
            return result
          else:
            return []
      except BaseException as e:
          import sys
          quota_service.increment_failed_service_use(len(geomrefs))
          exc_info = sys.exc_info()
          logger.error('%s, %s, %s' % (exc_info[0], exc_info[1], exc_info[2]))
          logger.error('Error trying to OBS_GetData', exc_info, data={"username": username, "orgname": orgname})
          raise Exception('Error trying to OBS_GetData')
      finally:
          quota_service.increment_total_service_use(len(geomrefs))
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  
  CREATE OR REPLACE FUNCTION cdb_dataservices_server.OBS_GetMeta(
    username TEXT,
    orgname TEXT,
    geom Geometry(Geometry, 4326),
    params JSON,
    max_timespan_rank INTEGER DEFAULT NULL,
    max_score_rank INTEGER DEFAULT NULL,
    target_geoms INTEGER DEFAULT NULL)
  RETURNS JSON AS $$
    from cartodb_services.metrics import metrics
    from cartodb_services.tools import Logger,LoggerConfig
  
    plpy.execute("SELECT cdb_dataservices_server._connect_to_redis('{0}')".format(username))
    redis_conn = GD["redis_connection_{0}".format(username)]['redis_metrics_connection']
    plpy.execute("SELECT cdb_dataservices_server._get_obs_config({0}, {1})".format(plpy.quote_nullable(username), plpy.quote_nullable(orgname)))
    user_obs_config = GD["user_obs_config_{0}".format(username)]
  
    plpy.execute("SELECT cdb_dataservices_server._get_logger_config()")
    logger_config = GD["logger_config"]
    logger = Logger(logger_config)
  
    with metrics('obs_getmeta', user_obs_config, logger):
      try:
          obs_plan = plpy.prepare("SELECT cdb_dataservices_server._OBS_GetMeta($1, $2, $3, $4, $5, $6, $7) as meta;", ["text", "text", "Geometry (Geometry, 4326)", "json", "integer", "integer", "integer"])
          result = plpy.execute(obs_plan, [username, orgname, geom, params, max_timespan_rank, max_score_rank, target_geoms])
          if result:
            return result[0]['meta']
          else:
            return None
      except BaseException as e:
          import sys
          logger.error('Error trying to OBS_GetMeta', sys.exc_info(), data={"username": username, "orgname": orgname})
          raise Exception('Error trying to OBS_GetMeta')
  $$ LANGUAGE plpythonu STABLE PARALLEL RESTRICTED;
  