{
  "id" : "3prd-nrah",
  "name" : "Aigua regenerada del Prat de Llobregat",
  "assetType" : "dataset",
  "attribution" : "Departament de Territori, Habitatge i Transició Ecològica",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Medi Ambient",
  "createdAt" : 1703247970,
  "description" : "Cabal de sortida de l’estació de regeneració d’aigua del Prat de Llobregat. S’indiquen dues sortides, una d'elles corresponent a la sortida d'aigua regenerada aportada al riu i l'altre al bombament de Can Solé.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 639,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2849096,
  "provenance" : "official",
  "publicationAppendEnabled" : true,
  "publicationDate" : 1703248756,
  "publicationGroup" : 1907941,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1792652646,
  "rowsUpdatedBy" : "a4b5-gx6v",
  "tableId" : 1907941,
  "totalTimesRated" : 0,
  "viewCount" : 2882,
  "viewLastModified" : 1792652641,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1705321514,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1416279,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1705321514,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1705321514,
      "failureCount" : 0,
      "startedAt" : 1705321514,
      "status" : "success"
    },
    "submitter" : {
      "id" : "7yiu-nmxh",
      "displayName" : "M. Montserrat Moliné Salvat"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 25507227,
    "name" : "Dia",
    "dataTypeName" : "calendar_date",
    "description" : "Data en què s’ha pres la mesura",
    "fieldName" : "dia",
    "position" : 2,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 15555849,
    "cachedContents" : {
      "non_null" : "4905",
      "largest" : "2026-10-20T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2019-06-15T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-18T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-13T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-14T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-16T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-17T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-11T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-12T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-05-31T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-01T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-02T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-03T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-04T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-05T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-06T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-07T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-08T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-09T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-10T00:00:00.000",
        "count" : "2"
      }, {
        "item" : "2019-06-19T00:00:00.000",
        "count" : "2"
      } ],
      "smallest" : "2019-05-22T00:00:00.000",
      "count" : "4905",
      "cardinality" : "4905"
    },
    "format" : {
      "view" : "date_dmy"
    }
  }, {
    "id" : 25507226,
    "name" : "Codi estació",
    "dataTypeName" : "text",
    "description" : "Codi de l’estació de regeneració d’aigua pública",
    "fieldName" : "codi_estaci",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 15555848,
    "cachedContents" : {
      "non_null" : "4905",
      "largest" : "F030397",
      "null" : "0",
      "top" : [ {
        "item" : "F030397",
        "count" : "4905"
      } ],
      "smallest" : "F030397",
      "count" : "4905",
      "cardinality" : "4905"
    },
    "format" : { }
  }, {
    "id" : 25507225,
    "name" : "Estació",
    "dataTypeName" : "text",
    "description" : "Nom de l’estació de regeneració d’aigua pública",
    "fieldName" : "estaci",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 15555847,
    "cachedContents" : {
      "non_null" : "4905",
      "largest" : "ERA - Llobregat - el Prat de Llobregat",
      "null" : "0",
      "top" : [ {
        "item" : "ERA - Llobregat - el Prat de Llobregat",
        "count" : "4905"
      } ],
      "smallest" : "ERA - Llobregat - el Prat de Llobregat",
      "count" : "4905",
      "cardinality" : "4905"
    },
    "format" : { }
  }, {
    "id" : 25507224,
    "name" : "Codi variable",
    "dataTypeName" : "text",
    "description" : "Codi de la variable que es mesura",
    "fieldName" : "codi_variable",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 15555846,
    "cachedContents" : {
      "non_null" : "4905",
      "largest" : "4493804",
      "null" : "0",
      "top" : [ {
        "item" : "4392153",
        "count" : "2513"
      }, {
        "item" : "4493804",
        "count" : "2392"
      } ],
      "smallest" : "4392153",
      "count" : "4905",
      "cardinality" : "4905"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 25507223,
    "name" : "Descripció variable",
    "dataTypeName" : "text",
    "description" : "Descripció de la variable que es mesura",
    "fieldName" : "descripcio_variable",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 15555845,
    "cachedContents" : {
      "non_null" : "4905",
      "largest" : "Cabal sortida ERA a riu",
      "null" : "0",
      "top" : [ {
        "item" : "Cabal sortida ERA a riu",
        "count" : "2513"
      }, {
        "item" : "Cabal sortida bombament Can Solé",
        "count" : "2392"
      } ],
      "smallest" : "Cabal sortida bombament Can Solé",
      "count" : "4905",
      "cardinality" : "4905"
    },
    "format" : { }
  }, {
    "id" : 25507222,
    "name" : "Cabal canal (m³/s)",
    "dataTypeName" : "number",
    "description" : "Cabal d’aigua en m3 per segon que s’aboca pel canal de sortida",
    "fieldName" : "cabal_canal_m3_s",
    "position" : 7,
    "renderTypeName" : "number",
    "tableColumnId" : 15555844,
    "cachedContents" : {
      "non_null" : "4905",
      "largest" : "1601.96",
      "null" : "0",
      "top" : [ {
        "item" : "0",
        "count" : "1658"
      }, {
        "item" : "0.01",
        "count" : "53"
      }, {
        "item" : "0.02",
        "count" : "53"
      }, {
        "item" : "0.05",
        "count" : "46"
      }, {
        "item" : "1.51",
        "count" : "45"
      }, {
        "item" : "1.36",
        "count" : "41"
      }, {
        "item" : "0.70",
        "count" : "40"
      }, {
        "item" : "0.03",
        "count" : "40"
      }, {
        "item" : "1.00",
        "count" : "38"
      }, {
        "item" : "1.70",
        "count" : "34"
      }, {
        "item" : "1.01",
        "count" : "32"
      }, {
        "item" : "1.3",
        "count" : "32"
      }, {
        "item" : "1.33",
        "count" : "32"
      }, {
        "item" : "1.32",
        "count" : "31"
      }, {
        "item" : "0.06",
        "count" : "30"
      }, {
        "item" : "1.69",
        "count" : "30"
      }, {
        "item" : "1.88",
        "count" : "29"
      }, {
        "item" : "0.71",
        "count" : "28"
      }, {
        "item" : "1.02",
        "count" : "28"
      }, {
        "item" : "0.72",
        "count" : "28"
      } ],
      "smallest" : "0",
      "count" : "4905",
      "cardinality" : "4905"
    },
    "format" : {
      "decimalSeparator" : ",",
      "precision" : "2",
      "groupSeparator" : "."
    }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "See Terms of Use"
  },
  "metadata" : {
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "dia",
        "ascending" : false
      }, {
        "columnFieldName" : "descripcio_variable",
        "ascending" : true
      } ]
    },
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Diària"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Outflow rate of the water regeneration station in El Prat de Llobregat",
        "Nombre del conjunto de datos (ES)" : "Caudal de salida de la estación de regeneración de agua del Prat de Llobregat"
      },
      "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" : "Sense informació geogràfica",
        "Àmbit geogràfic" : "Catalunya"
      }
    },
    "rowIdentifier" : 25507228,
    "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" : 25507227,
        "type" : "column"
      }
    }, {
      "ascending" : true,
      "expression" : {
        "columnId" : 25507223,
        "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" : [ "estació regeneració", "reutilització", "tractament terciari", "aigua regenerada", "era", "ods6_aigua neta i sanejament", "aca" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}