{ "id" : "2bwe-vgpr", "name" : "Nivell d’aforament de rius de les conques internes de Catalunya", "assetType" : "dataset", "attribution" : "Agència Catalana de l’Aigua (ACA)", "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/", "averageRating" : 0, "category" : "Medi Ambient", "createdAt" : 1708522128, "description" : "Mesura de cabals en rius mitjançant equips d’aforament a les conques internes de Catalunya. S’especifica un codi d’estació que identifica el punt on es troba l’aforament, el nom de la conca i subconca, les coordinades UTM i la mitjana del cabal en el període mesurat.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 1319, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "SEE_TERMS_OF_USE", "locked" : false, "newBackend" : true, "numberOfComments" : 0, "oid" : 2886335, "provenance" : "official", "publicationAppendEnabled" : true, "publicationDate" : 1708678302, "publicationGroup" : 1931776, "publicationStage" : "published", "rowsUpdatedAt" : 1778746030, "rowsUpdatedBy" : "a4b5-gx6v", "tableId" : 1931920, "totalTimesRated" : 0, "viewCount" : 4633, "viewLastModified" : 1778746022, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1709903439, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 1426802, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1709903439, "targetAudience" : "public", "workflowId" : 182, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "endedAt" : 1709903439, "failureCount" : 0, "startedAt" : 1709903439, "status" : "success" }, "submitter" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 25677865, "name" : "Dia", "dataTypeName" : "calendar_date", "description" : "Data en què s’ha pres la mesura en format yyyy/mm/dd", "fieldName" : "dia", "position" : 2, "renderTypeName" : "calendar_date", "tableColumnId" : 15659150, "cachedContents" : { "non_null" : "796905", "largest" : "2026-05-13T00:00:00.000", "null" : "0", "top" : [ { "item" : "2011-02-15T00:00:00.000", "count" : "95" }, { "item" : "2011-02-11T00:00:00.000", "count" : "95" }, { "item" : "2011-02-06T00:00:00.000", "count" : "95" }, { "item" : "2011-02-08T00:00:00.000", "count" : "95" }, { "item" : "2011-02-12T00:00:00.000", "count" : "95" }, { "item" : "2011-02-17T00:00:00.000", "count" : "95" }, { "item" : "2011-02-09T00:00:00.000", "count" : "95" }, { "item" : "2011-02-07T00:00:00.000", "count" : "95" }, { "item" : "2011-02-05T00:00:00.000", "count" : "95" }, { "item" : "2011-02-16T00:00:00.000", "count" : "94" }, { "item" : "2011-01-31T00:00:00.000", "count" : "94" }, { "item" : "2011-02-13T00:00:00.000", "count" : "94" }, { "item" : "2011-02-14T00:00:00.000", "count" : "94" }, { "item" : "2011-02-20T00:00:00.000", "count" : "94" }, { "item" : "2011-02-10T00:00:00.000", "count" : "94" }, { "item" : "2011-02-21T00:00:00.000", "count" : "94" }, { "item" : "2011-02-04T00:00:00.000", "count" : "94" }, { "item" : "2011-01-30T00:00:00.000", "count" : "94" }, { "item" : "2011-02-25T00:00:00.000", "count" : "94" }, { "item" : "2011-02-26T00:00:00.000", "count" : "94" } ], "smallest" : "1951-01-01T00:00:00.000", "count" : "796905", "cardinality" : "796905" }, "format" : { "view" : "date_dmy" } }, { "id" : 25677866, "name" : "Estació", "dataTypeName" : "text", "description" : "Nom que identifica el punt on es troba l’aforament", "fieldName" : "estaci", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 15659131, "cachedContents" : { "non_null" : "796905", "largest" : "QLSub - Font De La Deu Vella O Deu Grossa", "null" : "0", "top" : [ { "item" : "Embassament de Sant Ponç (Clariana de Cardener)", "count" : "31251" }, { "item" : "Embassament de Sau (Vilanova de Sau)", "count" : "27190" }, { "item" : "Embassament de Darnius Boadella (Darnius)", "count" : "25268" }, { "item" : "Embassament de Susqueda (Osor)", "count" : "24060" }, { "item" : "Embassament de Siurana (Cornudella de Montsant)", "count" : "23045" }, { "item" : "Embassament de la Baells (Cercs)", "count" : "22583" }, { "item" : "Embassament de Foix (Castellet i la Gornal)", "count" : "17860" }, { "item" : "Aforament - Guardiola de Berguedà (Llobregat)", "count" : "17740" }, { "item" : "Embassament de la Llosa del Cavall (Navès)", "count" : "14871" }, { "item" : "Aforament - Sant Joan de les Abadesses", "count" : "13549" }, { "item" : "Aforament - Cornudella de Montsant_EA041", "count" : "12479" }, { "item" : "Aforament - Berga (Olvan)", "count" : "11246" }, { "item" : "Aforament - Esponellà", "count" : "11055" }, { "item" : "Aforament - Sant Joan Despí", "count" : "11020" }, { "item" : "Aforament - Ripoll", "count" : "10490" }, { "item" : "Aforament - Qualitat - Pont de Molins", "count" : "10207" }, { "item" : "Aforament - Colomers (riu i canal de Sentmenat)", "count" : "10197" }, { "item" : "Aforament - Boadella d'Empordà", "count" : "9648" }, { "item" : "Aforament - Girona (Onyar)", "count" : "9641" }, { "item" : "Aforament - Castellbell i el Vilar", "count" : "9583" } ], "smallest" : "Aforament - Abrera", "count" : "796905", "cardinality" : "796905" }, "format" : { } }, { "id" : 25677867, "name" : "Conca", "dataTypeName" : "text", "description" : "Nom de la conca on es troba l’aforament", "fieldName" : "conca", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 15659130, "cachedContents" : { "non_null" : "796905", "largest" : "RIERES DEL MARESME", "null" : "0", "top" : [ { "item" : "EL LLOBREGAT", "count" : "263409" }, { "item" : "EL TER", "count" : "200605" }, { "item" : "LA MUGA", "count" : "82528" }, { "item" : "L'EBRE", "count" : "46583" }, { "item" : "EL BESÒS", "count" : "40795" }, { "item" : "LA TORDERA", "count" : "39096" }, { "item" : "EL FLUVIÀ", "count" : "30588" }, { "item" : "EL FOIX", "count" : "23355" }, { "item" : "EL FRANCOLÍ", "count" : "18358" }, { "item" : "EL DARÓ", "count" : "16874" }, { "item" : "RIERA DE RIUDECANYES", "count" : "16011" }, { "item" : "EL GAIÀ", "count" : "9368" }, { "item" : "RIERES DEL CAP DE BEGUR-BLANES", "count" : "8853" }, { "item" : "RIERES DEL MARESME", "count" : "482" } ], "smallest" : "EL BESÒS", "count" : "796905", "cardinality" : "796905" }, "format" : { } }, { "id" : 25677868, "name" : "Subconca", "dataTypeName" : "text", "description" : "Nom de la subconca on es troba l’aforament", "fieldName" : "subconca", "position" : 5, "renderTypeName" : "text", "tableColumnId" : 15659129, "cachedContents" : { "non_null" : "796905", "largest" : "Riu Mogent", "null" : "0", "top" : [ { "item" : "Alt Ter", "count" : "121492" }, { "item" : "el Cardener", "count" : "84415" }, { "item" : "Baix Ter", "count" : "63179" }, { "item" : "Alt Llobregat", "count" : "60019" }, { "item" : "LA MUGA", "count" : "59124" }, { "item" : "Baix Llobregat", "count" : "47380" }, { "item" : "Riu de Siurana", "count" : "46583" }, { "item" : "LA TORDERA", "count" : "39096" }, { "item" : "Llobregat Mig", "count" : "34084" }, { "item" : "l'Anoia", "count" : "32945" }, { "item" : "EL FLUVIÀ", "count" : "24726" }, { "item" : "EL FOIX", "count" : "23355" }, { "item" : "EL FRANCOLÍ", "count" : "17744" }, { "item" : "EL DARÓ", "count" : "16874" }, { "item" : "RIERA DE RIUDECANYES", "count" : "16011" }, { "item" : "el Congost", "count" : "9669" }, { "item" : "EL BESÒS", "count" : "9639" }, { "item" : "EL GAIÀ", "count" : "9368" }, { "item" : "el Llobregat (d'Empordà)", "count" : "9326" }, { "item" : "el Ridaura", "count" : "8853" } ], "smallest" : "Alt Llobregat", "count" : "796905", "cardinality" : "796905" }, "format" : { } }, { "id" : 25677869, "name" : "UTM X", "dataTypeName" : "number", "description" : "Coordenada UTM X on es troba l’aforament", "fieldName" : "utm_x", "position" : 6, "renderTypeName" : "number", "tableColumnId" : 15659128, "cachedContents" : { "non_null" : "796905", "largest" : "510378", "null" : "0", "top" : [ { "item" : "384452", "count" : "31251" }, { "item" : "451408", "count" : "27190" }, { "item" : "486262", "count" : "25268" }, { "item" : "460844", "count" : "24060" }, { "item" : "325206", "count" : "23045" }, { "item" : "407302", "count" : "22583" }, { "item" : "406706", "count" : "18736" }, { "item" : "386988", "count" : "17860" }, { "item" : "382818", "count" : "14871" }, { "item" : "322597", "count" : "12479" }, { "item" : "407241", "count" : "12385" }, { "item" : "483371", "count" : "11055" }, { "item" : "420245", "count" : "11020" }, { "item" : "433448", "count" : "10490" }, { "item" : "493240", "count" : "10207" }, { "item" : "499269", "count" : "10197" }, { "item" : "440427", "count" : "9669" }, { "item" : "488441", "count" : "9648" }, { "item" : "485464", "count" : "9641" }, { "item" : "404933", "count" : "9583" } ], "smallest" : "322597", "count" : "796905", "cardinality" : "796905" }, "format" : { "noCommas" : "true", "precision" : "3" } }, { "id" : 25677870, "name" : "UTM Y", "dataTypeName" : "number", "description" : "Coordenada UTM Y on es troba l’aforament", "fieldName" : "utm_y", "position" : 7, "renderTypeName" : "number", "tableColumnId" : 15659127, "cachedContents" : { "non_null" : "796905", "largest" : "4691138", "null" : "0", "top" : [ { "item" : "4646602", "count" : "31251" }, { "item" : "4646459", "count" : "27190" }, { "item" : "4687606", "count" : "25268" }, { "item" : "4647561", "count" : "24060" }, { "item" : "4568569", "count" : "23045" }, { "item" : "4663932", "count" : "22583" }, { "item" : "4674198", "count" : "18736" }, { "item" : "4568011", "count" : "17860" }, { "item" : "4661827", "count" : "14871" }, { "item" : "4567061", "count" : "12479" }, { "item" : "4659812", "count" : "12385" }, { "item" : "4669513", "count" : "11055" }, { "item" : "4578251", "count" : "11020" }, { "item" : "4669209", "count" : "10490" }, { "item" : "4684812", "count" : "10207" }, { "item" : "4658310", "count" : "10197" }, { "item" : "4616399", "count" : "9669" }, { "item" : "4686953", "count" : "9648" }, { "item" : "4647022", "count" : "9641" }, { "item" : "4611165", "count" : "9583" } ], "smallest" : "4555741", "count" : "796905", "cardinality" : "796905" }, "format" : { "precisionStyle" : "standard", "noCommas" : "true", "precision" : "3" } }, { "id" : 25677871, "name" : "Codi variable", "dataTypeName" : "number", "description" : "Codi de la variable que es mesura", "fieldName" : "codi_variable", "position" : 8, "renderTypeName" : "number", "tableColumnId" : 15659126, "cachedContents" : { "non_null" : "796905", "largest" : "4654700", "null" : "0", "top" : [ { "item" : "4165146", "count" : "27527" }, { "item" : "4165140", "count" : "22871" }, { "item" : "4140489", "count" : "20314" }, { "item" : "4165465", "count" : "20294" }, { "item" : "4165144", "count" : "19931" }, { "item" : "4165139", "count" : "17856" }, { "item" : "4165137", "count" : "15303" }, { "item" : "4277310", "count" : "13549" }, { "item" : "4178795", "count" : "12896" }, { "item" : "4290783", "count" : "11055" }, { "item" : "4369424", "count" : "11020" }, { "item" : "4277308", "count" : "10490" }, { "item" : "4557642", "count" : "10197" }, { "item" : "4165460", "count" : "10084" }, { "item" : "4290744", "count" : "9669" }, { "item" : "4140492", "count" : "9648" }, { "item" : "4287922", "count" : "9641" }, { "item" : "4261138", "count" : "9583" }, { "item" : "4343829", "count" : "9538" }, { "item" : "4143482", "count" : "9496" } ], "smallest" : "4140489", "count" : "796905", "cardinality" : "796905" }, "format" : { "noCommas" : "true" } }, { "id" : 25677872, "name" : "Descripció variable", "dataTypeName" : "text", "description" : "Descripció de la variable que es mesura", "fieldName" : "descripci_variable", "position" : 9, "renderTypeName" : "text", "tableColumnId" : 15659125, "cachedContents" : { "non_null" : "796905", "largest" : "EA141_Les Masies de Voltrega_Cabal riu Ter", "null" : "0", "top" : [ { "item" : "E13_Clariana Cardener_Sant Ponc_Cabal sortida", "count" : "27527" }, { "item" : "E06_Vilanova Sau_Sau_Cabal sortida", "count" : "22871" }, { "item" : "E01_Darnius Boadella_Cabal sortida", "count" : "20314" }, { "item" : "E18_Cornudella Montsant_Siurana_Cabal sortida", "count" : "20294" }, { "item" : "E07_Osor_Susqueda_Cabal sortida", "count" : "19931" }, { "item" : "E14_Cercs_Baells_Cabal sortida", "count" : "18354" }, { "item" : "E16_Castellet i la Gornal_Foix_Cabal sortida", "count" : "15303" }, { "item" : "EA041_Cornudella Montsant_Cabal riu Siurana", "count" : "12896" }, { "item" : "EA016_Esponella_Cabal riu Fluvia", "count" : "11055" }, { "item" : "EA049_Sant Joan Despi_Cabal riu Llobregat", "count" : "11020" }, { "item" : "EA121_Colomers_Cabal riu Ter", "count" : "10197" }, { "item" : "E12_Emb_La Llosa del Cavall_Cabal sortida", "count" : "9739" }, { "item" : "EA037_La Garriga_Cabal riu_Congost", "count" : "9669" }, { "item" : "EA012_Boadella Emporda_Cabal riu Muga", "count" : "9648" }, { "item" : "EA020_Girona_Cabal riu Onyar", "count" : "9641" }, { "item" : "EA023_Castellbell i el Vilar_Cabal riu Llobregat", "count" : "9583" }, { "item" : "EA015_Sant Celoni_Cabal riu Tordera", "count" : "9538" }, { "item" : "EA125_Pont Molins_Cabal riu Muga", "count" : "9496" }, { "item" : "EA013_Olot_Cabal riu Fluvia", "count" : "9488" }, { "item" : "EA067_Balsareny_Cabal riu_Llobregat", "count" : "9474" } ], "smallest" : "08125-0069_Montcada i Reixac_Cabal rec Comtal", "count" : "796905", "cardinality" : "796905" }, "format" : { } }, { "id" : 25677873, "name" : "Cabal riu (m3/s)", "dataTypeName" : "number", "description" : "Mesura de l’aforament en metres cúbics per segon", "fieldName" : "cabal_riu_m3_s", "position" : 10, "renderTypeName" : "number", "tableColumnId" : 15659124, "cachedContents" : { "non_null" : "796905", "largest" : "4289271", "null" : "0", "top" : [ { "item" : "0", "count" : "70424" }, { "item" : "0.03", "count" : "6537" }, { "item" : "0.02", "count" : "5438" }, { "item" : "3", "count" : "4353" }, { "item" : "0.01", "count" : "4157" }, { "item" : "1.5", "count" : "4012" }, { "item" : "2", "count" : "3931" }, { "item" : "1", "count" : "3843" }, { "item" : "0.002", "count" : "3490" }, { "item" : "0.05", "count" : "2758" }, { "item" : "0.053", "count" : "2583" }, { "item" : "0.04", "count" : "2395" }, { "item" : "0.003", "count" : "2249" }, { "item" : "0.007", "count" : "2103" }, { "item" : "0.5", "count" : "2061" }, { "item" : "0.06", "count" : "2049" }, { "item" : "0.018", "count" : "1988" }, { "item" : "0.022", "count" : "1923" }, { "item" : "2.5", "count" : "1923" }, { "item" : "0.07", "count" : "1922" } ], "smallest" : "-0.022", "count" : "796905", "cardinality" : "796905" }, "format" : { "decimalSeparator" : ",", "groupSeparator" : "." } }, { "id" : 25677874, "name" : "Latitud", "dataTypeName" : "number", "description" : "Latitud calculada a les coodenades WGS84 a partir de la coordenada UTM X Sistema de coordenades d'origen: ETRS89.UTM-31N Sistema de coordenades de destí: LL84 Transformació: ETRF89 a WGS84", "fieldName" : "lat", "position" : 11, "renderTypeName" : "number", "tableColumnId" : 15660388, "cachedContents" : { "non_null" : "796905", "largest" : "42.37232575030992", "null" : "0", "top" : [ { "item" : "41.96294229205039", "count" : "31251" }, { "item" : "41.96862495507766", "count" : "27190" }, { "item" : "42.34058878142266", "count" : "25268" }, { "item" : "41.97907523619728", "count" : "24060" }, { "item" : "41.24964238002498", "count" : "23045" }, { "item" : "42.122014523706994", "count" : "22583" }, { "item" : "42.214385564916455", "count" : "18736" }, { "item" : "41.25561731794095", "count" : "17860" }, { "item" : "42.09978496831785", "count" : "14871" }, { "item" : "41.23549953562199", "count" : "12479" }, { "item" : "42.0849076369047", "count" : "12385" }, { "item" : "42.17758312049573", "count" : "11055" }, { "item" : "41.35181064097362", "count" : "11020" }, { "item" : "42.17219216130356", "count" : "10490" }, { "item" : "42.31551753898176", "count" : "10207" }, { "item" : "42.07686002144604", "count" : "10197" }, { "item" : "41.69714444846008", "count" : "9669" }, { "item" : "42.33474321500407", "count" : "9648" }, { "item" : "41.9750594948072", "count" : "9641" }, { "item" : "41.64656164285967", "count" : "9583" } ], "smallest" : "41.13493135303816", "count" : "796905", "cardinality" : "796905" }, "format" : { } }, { "id" : 25677875, "name" : "Longitud", "dataTypeName" : "number", "description" : "Longitud calculada a les coodenades WGS84 a partir de la coordenada UTM Y Sistema de coordenades d'origen: ETRS89.UTM-31N Sistema de coordenades de destí: LL84 Transformació: ETRF89 a WGS84", "fieldName" : "long", "position" : 12, "renderTypeName" : "number", "tableColumnId" : 15660387, "cachedContents" : { "non_null" : "796905", "largest" : "3.125380536654679", "null" : "0", "top" : [ { "item" : "1.6056132582791622", "count" : "31251" }, { "item" : "2.413554059012637", "count" : "27190" }, { "item" : "2.833225164955092", "count" : "25268" }, { "item" : "2.5273574567266737", "count" : "24060" }, { "item" : "0.9138007842134876", "count" : "23045" }, { "item" : "1.8785595555259327", "count" : "22583" }, { "item" : "1.869705978928608", "count" : "18736" }, { "item" : "1.6510346579203994", "count" : "17860" }, { "item" : "1.5828582701079756", "count" : "14871" }, { "item" : "0.883120386123059", "count" : "12479" }, { "item" : "1.8784758282061782", "count" : "12385" }, { "item" : "2.7986486366573384", "count" : "11055" }, { "item" : "2.046600124307674", "count" : "11020" }, { "item" : "2.194229580901238", "count" : "10490" }, { "item" : "2.9179683791973123", "count" : "10207" }, { "item" : "2.99116273348982", "count" : "10197" }, { "item" : "2.2840593294526634", "count" : "9669" }, { "item" : "2.8596905037355054", "count" : "9648" }, { "item" : "2.8245503213582874", "count" : "9641" }, { "item" : "1.858396555541691", "count" : "9583" } ], "smallest" : "0.883120386123059", "count" : "796905", "cardinality" : "796905" }, "format" : { } }, { "id" : 25677877, "name" : "Georeferència", "dataTypeName" : "point", "description" : "Punt de georeferència segons la Latitud i Longitud. Sistema de coordenades d'origen: ETRS89.UTM-31N", "fieldName" : "georefer", "position" : 13, "renderTypeName" : "point", "tableColumnId" : 15660584, "cachedContents" : { "non_null" : "796905", "null" : "0", "top" : [ { "item" : { "coordinates" : [ 1.605613258279, 41.96294229205 ], "type" : "Point" }, "count" : "31251" }, { "item" : { "coordinates" : [ 2.413554059013, 41.968624955078 ], "type" : "Point" }, "count" : "27190" }, { "item" : { "coordinates" : [ 2.833225164955, 42.340588781423 ], "type" : "Point" }, "count" : "25268" }, { "item" : { "coordinates" : [ 2.527357456727, 41.979075236197 ], "type" : "Point" }, "count" : "24060" }, { "item" : { "coordinates" : [ 0.913800784213, 41.249642380025 ], "type" : "Point" }, "count" : "23045" }, { "item" : { "coordinates" : [ 1.878559555526, 42.122014523707 ], "type" : "Point" }, "count" : "22583" }, { "item" : { "coordinates" : [ 1.869705978929, 42.214385564916 ], "type" : "Point" }, "count" : "18736" }, { "item" : { "coordinates" : [ 1.65103465792, 41.255617317941 ], "type" : "Point" }, "count" : "17860" }, { "item" : { "coordinates" : [ 1.582858270108, 42.099784968318 ], "type" : "Point" }, "count" : "14871" }, { "item" : { "coordinates" : [ 0.883120386123, 41.235499535622 ], "type" : "Point" }, "count" : "12479" }, { "item" : { "coordinates" : [ 1.878475828206, 42.084907636905 ], "type" : "Point" }, "count" : "12385" }, { "item" : { "coordinates" : [ 2.798648636657, 42.177583120496 ], "type" : "Point" }, "count" : "11055" }, { "item" : { "coordinates" : [ 2.046600124308, 41.351810640974 ], "type" : "Point" }, "count" : "11020" }, { "item" : { "coordinates" : [ 2.194229580901, 42.172192161304 ], "type" : "Point" }, "count" : "10490" }, { "item" : { "coordinates" : [ 2.917968379197, 42.315517538982 ], "type" : "Point" }, "count" : "10207" }, { "item" : { "coordinates" : [ 2.99116273349, 42.076860021446 ], "type" : "Point" }, "count" : "10197" }, { "item" : { "coordinates" : [ 2.284059329453, 41.69714444846 ], "type" : "Point" }, "count" : "9669" }, { "item" : { "coordinates" : [ 2.859690503736, 42.334743215004 ], "type" : "Point" }, "count" : "9648" }, { "item" : { "coordinates" : [ 2.824550321358, 41.975059494807 ], "type" : "Point" }, "count" : "9641" }, { "item" : { "coordinates" : [ 1.858396555542, 41.64656164286 ], "type" : "Point" }, "count" : "9583" } ], "count" : "796905", "cardinality" : "796905" }, "format" : { } }, { "id" : 25677878, "name" : "LIMADM_MUNICIPI", "dataTypeName" : "number", "description" : "This column was automatically created in order to record in what polygon from the dataset 'LIMADM_MUNICIPI' (bh64-c7uy) the point in column 'georefer' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.", "fieldName" : ":@computed_region_bh64_c7uy", "position" : 14, "renderTypeName" : "number", "tableColumnId" : 15660585, "computationStrategy" : { "source_columns" : [ "georefer" ], "type" : "georegion_match_on_point", "parameters" : { "region" : "_bh64-c7uy", "primary_key" : "_feature_id" } }, "format" : { } }, { "id" : 25677879, "name" : "LIMADM COMARCA", "dataTypeName" : "number", "description" : "This column was automatically created in order to record in what polygon from the dataset 'LIMADM COMARCA' (wvic-k925) the point in column 'georefer' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.", "fieldName" : ":@computed_region_wvic_k925", "position" : 15, "renderTypeName" : "number", "tableColumnId" : 15660586, "computationStrategy" : { "source_columns" : [ "georefer" ], "type" : "georegion_match_on_point", "parameters" : { "region" : "_wvic-k925", "primary_key" : "_feature_id" } }, "format" : { } } ], "grants" : [ { "inherited" : false, "type" : "viewer", "flags" : [ "public" ] } ], "license" : { "name" : "See Terms of Use" }, "metadata" : { "jsonQuery" : { "order" : [ { "columnFieldName" : "dia", "ascending" : false }, { "columnFieldName" : "codi_variable", "ascending" : true } ] }, "custom_fields" : { "Freqüència d'actualització" : { "Freqüència d'actualització" : "Diària" }, "Idioma" : { "Idioma" : "Català", "Dataset name (EN)" : "Level of capacity of rivers of the internal basins of Catalonia", "Nombre del conjunto de datos (ES)" : "Nivel de aforo de rios de las cuencas internas de Cataluña" }, "Informació de gènere o sexe" : { "Informació de gènere o sexe" : "No aplicable" }, "Actors" : { "Departament" : "Territori, Habitatge i Transició Ecològica", "Tipus actor" : "Generalitat de Catalunya" }, "Àmbit geogràfic" : { "Informació geogràfica" : "Coordenades", "Àmbit geogràfic" : "Catalunya" } }, "rowIdentifier" : 25677864, "availableDisplayTypes" : [ "table", "fatrow", "page" ] }, "owner" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya", "profileImageUrlLarge" : "/api/users/a4b5-gx6v/profile_images/LARGE", "profileImageUrlMedium" : "/api/users/a4b5-gx6v/profile_images/THUMB", "profileImageUrlSmall" : "/api/users/a4b5-gx6v/profile_images/TINY", "screenName" : "Dades Obertes Catalunya", "type" : "interactive", "flags" : [ "acceptedEula" ] }, "query" : { "orderBys" : [ { "ascending" : false, "expression" : { "columnId" : 25677865, "type" : "column" } }, { "ascending" : true, "expression" : { "columnId" : 25677871, "type" : "column" } } ] }, "rights" : [ "read" ], "tableAuthor" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya", "profileImageUrlLarge" : "/api/users/a4b5-gx6v/profile_images/LARGE", "profileImageUrlMedium" : "/api/users/a4b5-gx6v/profile_images/THUMB", "profileImageUrlSmall" : "/api/users/a4b5-gx6v/profile_images/TINY", "screenName" : "Dades Obertes Catalunya", "type" : "interactive", "flags" : [ "acceptedEula" ] }, "tags" : [ "aforament", "conca", "nivell", "aca", "ods6_aigua neta i sanejament", "ods15_vida d'ecosistemes terrestres" ], "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ] }