{
  "id" : "gn9e-3qhr",
  "name" : "Quantitat d’aigua als embassaments 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" : 1611314836,
  "description" : "Estat dels embassaments de les Conques Internes de Catalunya a partir dels valors de Nivell de l’aigua a l’embassament, Volum embassat i Percentatge del volum embassat respecte la capacitat de l’embassament (dades agregades del dia anterior).",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 22372,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2792134,
  "provenance" : "official",
  "publicationAppendEnabled" : true,
  "publicationDate" : 1697622500,
  "publicationGroup" : 1329285,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1779962412,
  "rowsUpdatedBy" : "a4b5-gx6v",
  "tableId" : 1872524,
  "totalTimesRated" : 0,
  "viewCount" : 376689,
  "viewLastModified" : 1779962406,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1647864675,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1387083,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1647864675,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1647864676,
      "failureCount" : 0,
      "startedAt" : 1647864675,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 25250350,
    "name" : "Dia",
    "dataTypeName" : "calendar_date",
    "description" : "Data en què s’ha pres la mesura",
    "fieldName" : "dia",
    "position" : 2,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 11928463,
    "cachedContents" : {
      "non_null" : "86796",
      "largest" : "2026-05-27T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2000-01-02T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-03T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-04T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-05T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-06T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-07T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-08T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-09T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-10T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-11T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-12T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-13T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-14T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-15T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-16T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-17T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-18T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-19T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-20T00:00:00.000",
        "count" : "9"
      }, {
        "item" : "2000-01-01T00:00:00.000",
        "count" : "9"
      } ],
      "smallest" : "2000-01-01T00:00:00.000",
      "count" : "86796",
      "cardinality" : "86796"
    },
    "format" : {
      "view" : "date_dmy"
    }
  }, {
    "id" : 25250351,
    "name" : "Estació",
    "dataTypeName" : "text",
    "description" : "Embassament on s’ha pres la mesura",
    "fieldName" : "estaci",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 11928465,
    "cachedContents" : {
      "non_null" : "86796",
      "largest" : "Embassament de Susqueda (Osor)",
      "null" : "0",
      "top" : [ {
        "item" : "Embassament de Darnius Boadella (Darnius)",
        "count" : "9644"
      }, {
        "item" : "Embassament de Foix (Castellet i la Gornal)",
        "count" : "9644"
      }, {
        "item" : "Embassament de la Baells (Cercs)",
        "count" : "9644"
      }, {
        "item" : "Embassament de la Llosa del Cavall (Navès)",
        "count" : "9644"
      }, {
        "item" : "Embassament de Riudecanyes",
        "count" : "9644"
      }, {
        "item" : "Embassament de Sant Ponç (Clariana de Cardener)",
        "count" : "9644"
      }, {
        "item" : "Embassament de Sau (Vilanova de Sau)",
        "count" : "9644"
      }, {
        "item" : "Embassament de Siurana (Cornudella de Montsant)",
        "count" : "9644"
      }, {
        "item" : "Embassament de Susqueda (Osor)",
        "count" : "9644"
      } ],
      "smallest" : "Embassament de Darnius Boadella (Darnius)",
      "count" : "86796",
      "cardinality" : "86796"
    },
    "format" : { }
  }, {
    "id" : 25250352,
    "name" : "Nivell absolut (msnm)",
    "dataTypeName" : "number",
    "description" : "Nivell de l’aigua (msnm) mesurat a l’embassament",
    "fieldName" : "nivell_absolut",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 11928466,
    "cachedContents" : {
      "non_null" : "86743",
      "largest" : "806.66",
      "null" : "53",
      "top" : [ {
        "item" : "100.51",
        "count" : "762"
      }, {
        "item" : "100.5",
        "count" : "650"
      }, {
        "item" : "100.52",
        "count" : "503"
      }, {
        "item" : "100.49",
        "count" : "420"
      }, {
        "item" : "100.48",
        "count" : "358"
      }, {
        "item" : "100.53",
        "count" : "314"
      }, {
        "item" : "100.47",
        "count" : "266"
      }, {
        "item" : "100.46",
        "count" : "218"
      }, {
        "item" : "100.45",
        "count" : "162"
      }, {
        "item" : "100.44",
        "count" : "136"
      }, {
        "item" : "100.42",
        "count" : "109"
      }, {
        "item" : "100.43",
        "count" : "107"
      }, {
        "item" : "100.41",
        "count" : "104"
      }, {
        "item" : "100.54",
        "count" : "104"
      }, {
        "item" : "100.38",
        "count" : "99"
      }, {
        "item" : "219.5",
        "count" : "98"
      }, {
        "item" : "100.36",
        "count" : "96"
      }, {
        "item" : "100.39",
        "count" : "91"
      }, {
        "item" : "100.17",
        "count" : "81"
      }, {
        "item" : "100.37",
        "count" : "79"
      } ],
      "smallest" : "96.79",
      "count" : "86796",
      "cardinality" : "86796"
    },
    "format" : {
      "decimalSeparator" : ",",
      "precision" : "2",
      "groupSeparator" : ".",
      "align" : "left"
    }
  }, {
    "id" : 25250353,
    "name" : "Percentatge volum embassat (%)",
    "dataTypeName" : "number",
    "description" : "Percentatge de volum d’aigua en relació a la capacitat màxima de l’embassament",
    "fieldName" : "percentatge_volum_embassat",
    "position" : 5,
    "renderTypeName" : "number",
    "tableColumnId" : 11928462,
    "cachedContents" : {
      "non_null" : "86796",
      "largest" : "151.7",
      "null" : "0",
      "top" : [ {
        "item" : "100.3",
        "count" : "691"
      }, {
        "item" : "100.1",
        "count" : "564"
      }, {
        "item" : "99.9",
        "count" : "451"
      }, {
        "item" : "100",
        "count" : "445"
      }, {
        "item" : "100.5",
        "count" : "444"
      }, {
        "item" : "99.7",
        "count" : "379"
      }, {
        "item" : "99.6",
        "count" : "322"
      }, {
        "item" : "90.9",
        "count" : "279"
      }, {
        "item" : "98.5",
        "count" : "271"
      }, {
        "item" : "100.7",
        "count" : "265"
      }, {
        "item" : "91.1",
        "count" : "265"
      }, {
        "item" : "97.6",
        "count" : "264"
      }, {
        "item" : "96.4",
        "count" : "260"
      }, {
        "item" : "99.4",
        "count" : "255"
      }, {
        "item" : "98.1",
        "count" : "246"
      }, {
        "item" : "98.3",
        "count" : "240"
      }, {
        "item" : "91.3",
        "count" : "230"
      }, {
        "item" : "90.8",
        "count" : "227"
      }, {
        "item" : "99.8",
        "count" : "223"
      }, {
        "item" : "99.2",
        "count" : "222"
      } ],
      "smallest" : "0.6",
      "count" : "86796",
      "cardinality" : "86796"
    },
    "format" : {
      "decimalSeparator" : ",",
      "precision" : "1",
      "groupSeparator" : ".",
      "align" : "left"
    }
  }, {
    "id" : 25250354,
    "name" : "Volum embassat (hm3)",
    "dataTypeName" : "number",
    "description" : "Volum d’aigua (hm3) al qual correspon el nivell mesurat",
    "fieldName" : "volum_embassat",
    "position" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 11928464,
    "cachedContents" : {
      "non_null" : "86796",
      "largest" : "247.44",
      "null" : "0",
      "top" : [ {
        "item" : "3.74",
        "count" : "951"
      }, {
        "item" : "3.75",
        "count" : "896"
      }, {
        "item" : "3.76",
        "count" : "579"
      }, {
        "item" : "3.73",
        "count" : "458"
      }, {
        "item" : "3.72",
        "count" : "418"
      }, {
        "item" : "3.77",
        "count" : "359"
      }, {
        "item" : "5.32",
        "count" : "325"
      }, {
        "item" : "3.7",
        "count" : "242"
      }, {
        "item" : "3.71",
        "count" : "234"
      }, {
        "item" : "3.68",
        "count" : "172"
      }, {
        "item" : "3.66",
        "count" : "170"
      }, {
        "item" : "3.69",
        "count" : "147"
      }, {
        "item" : "3.62",
        "count" : "141"
      }, {
        "item" : "3.53",
        "count" : "139"
      }, {
        "item" : "3.65",
        "count" : "134"
      }, {
        "item" : "3.57",
        "count" : "130"
      }, {
        "item" : "3.61",
        "count" : "128"
      }, {
        "item" : "3.67",
        "count" : "123"
      }, {
        "item" : "3.6",
        "count" : "119"
      }, {
        "item" : "3.58",
        "count" : "115"
      } ],
      "smallest" : "0.08",
      "count" : "86796",
      "cardinality" : "86796"
    },
    "format" : {
      "decimalSeparator" : ",",
      "precision" : "2",
      "groupSeparator" : ".",
      "align" : "left"
    }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "dia",
        "ascending" : false
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Diària"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Water quantity in the dams of Catalonia Internal Basins",
        "Nombre del conjunto de datos (ES)" : "Cantidad de agua en los embalses de las Cuencas Internas de Catalunya"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Enllaços relacionats" : {
        "Nom" : "Sobre  l'ACA. Conques internes de Catalunya i conques intercomunitàries",
        "URL" : "https://aca.gencat.cat/ca/laca/sobre-laca/#competencies--un-pais--dues-realitats-"
      },
      "Actors" : {
        "Departament" : "Territori, Habitatge i Transició Ecològica",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Nom d'element",
        "Àmbit geogràfic" : "Conques internes de Catalunya"
      }
    },
    "rowIdentifier" : 25250349,
    "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" : 25250350,
        "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" : [ "embassaments", "nivell", "msnm", "volum", "hm3", "ods6_aigua neta i sanejament", "ods13_acció pel clima", "ods12_producció i consum responsable", "aca", "percentatge" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}