Prototype function for metadata-returning object for cartoframes data_discovery

do-geom-specification.sql

with envelope as (
  SELECT 
    ST_SetSRID(ST_Extent(the_geom), 4326) as env,
    count(*)::int as cnt
  FROM 
    eschbacher.mexican_states
),
numers as (
  SELECT 
    unnest(Array['mx.inegi.entidad', 'mx.inegi.localidad_urbana_y_rural_amanzanada']::text[]) as geom_id,
    numer_id
  FROM 
    obs_getavailablenumerators((select env from envelope))
), dataaaaaa as (
SELECT * 
FROM (
  (
    SELECT
      OBS_GetMeta(
        envelope.env,
        json_agg(row_to_json(numers.*)),
        10,
        1,
        envelope.cnt
      ) AS meta
    FROM envelope, numers
    GROUP BY envelope.env, envelope.cnt
  )
) AS data)
SELECT * FROM json_array_elements((SELECT * from dataaaaaa))