{
  "id" : "g9ma-vbt8",
  "name" : "Dades recollides per l'aplicació Cobertura Mòbil (2015-2019)",
  "assetType" : "dataset",
  "attribution" : "Secretaria de Telecomunicacions i Transformació Digital",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Ciència i Tecnologia",
  "createdAt" : 1535529477,
  "description" : "Dades recollides per l'aplicació Cobertura mòbil promoguda pel Departament de la Presidència de la Generalitat de Catalunya.\n\nLes dades proporcionen informació del nivell de cobertura mòbil per un punt determinat del territori, per a una operadora determinada i per una tecnologia concreta (2G, 3G o 4G).\n\nEl següent vídeo explica com funciona l'aplicació Cobertura mòbil:\n\nhttps://www.youtube.com/watch?v=SOIYRgxf2b0&feature=youtu.be\n\nCada línia del fitxer informa de la data i hora de la mesura, posició (coordenades en format Spherical Mercator - EPSG 3857), nivell de senyal en format ASU, tecnologia emprada (2G, 3G o 4G) i operadora mòbil (Movistar, Orange, Vodafone o Yoigo (les operadores virtuals es relacionen amb la seva operadora de servei)).\n\nCal remarcar que es tracta de dades aportades per diferents ciutadans de manera anònima i fet a través del seu telèfon intel·ligent. Per tant, es tracta de mesures orientatives i no absolutes, tot i que quantes més mesures hi hagi sobre un punt, més correcta pot ser la interpretació del nivell de senyal. Tanmateix, en tractar-se d'equips no calibrats podria donar-se el cas d'alguna mesura incorrecta que escapi als mecanismes de control de la mateixa aplicació.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 1873,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2606594,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1678735417,
  "publicationGroup" : 568633,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1678729532,
  "rowsUpdatedBy" : "a4b5-gx6v",
  "tableId" : 1761461,
  "totalTimesRated" : 0,
  "viewCount" : 4548,
  "viewLastModified" : 1772439240,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1538556650,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1302989,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1538556650,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "failureCount" : 0,
      "status" : "success"
    },
    "submitter" : {
      "id" : "a4b5-gx6v",
      "displayName" : "Dades Obertes Catalunya"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 23742799,
    "name" : "timestamp_",
    "dataTypeName" : "number",
    "description" : "Marca de temps (en milisegons)",
    "fieldName" : "timestamp_",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 4513484,
    "cachedContents" : {
      "non_null" : "12913050",
      "largest" : "1513530191001513530493000",
      "null" : "0",
      "top" : [ {
        "item" : "1577620000000",
        "count" : "1332"
      }, {
        "item" : "1548430000000",
        "count" : "1186"
      }, {
        "item" : "1577020000000",
        "count" : "1111"
      }, {
        "item" : "1549030000000",
        "count" : "921"
      }, {
        "item" : "1548690000000",
        "count" : "905"
      }, {
        "item" : "1549710000000",
        "count" : "851"
      }, {
        "item" : "1563990000000",
        "count" : "841"
      }, {
        "item" : "1567190000000",
        "count" : "836"
      }, {
        "item" : "1548440000000",
        "count" : "815"
      }, {
        "item" : "1548680000000",
        "count" : "791"
      }, {
        "item" : "1577530000000",
        "count" : "766"
      }, {
        "item" : "1550920000000",
        "count" : "764"
      }, {
        "item" : "1551010000000",
        "count" : "757"
      }, {
        "item" : "1547060000000",
        "count" : "752"
      }, {
        "item" : "1548960000000",
        "count" : "734"
      }, {
        "item" : "1563010000000",
        "count" : "732"
      }, {
        "item" : "1547660000000",
        "count" : "723"
      }, {
        "item" : "1557570000000",
        "count" : "722"
      }, {
        "item" : "1551030000000",
        "count" : "694"
      }, {
        "item" : "1548850000000",
        "count" : "690"
      } ],
      "smallest" : "1420412587764",
      "count" : "12913050",
      "cardinality" : "12013577"
    },
    "format" : { }
  }, {
    "id" : 23742800,
    "name" : "Date",
    "dataTypeName" : "calendar_date",
    "description" : "Data i Hora de la mesura",
    "fieldName" : "date",
    "position" : 2,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 4513503,
    "cachedContents" : {
      "non_null" : "12913050",
      "largest" : "2019-12-31T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2018-06-27T00:00:00.000",
        "count" : "7472"
      }, {
        "item" : "2018-06-28T00:00:00.000",
        "count" : "6246"
      }, {
        "item" : "2018-06-29T00:00:00.000",
        "count" : "6077"
      }, {
        "item" : "2018-07-12T00:00:00.000",
        "count" : "5044"
      }, {
        "item" : "2018-08-17T00:00:00.000",
        "count" : "4945"
      }, {
        "item" : "2018-07-13T00:00:00.000",
        "count" : "4886"
      }, {
        "item" : "2018-07-10T00:00:00.000",
        "count" : "4835"
      }, {
        "item" : "2018-07-11T00:00:00.000",
        "count" : "4767"
      }, {
        "item" : "2018-07-06T00:00:00.000",
        "count" : "4679"
      }, {
        "item" : "2018-06-30T00:00:00.000",
        "count" : "4601"
      }, {
        "item" : "2018-07-18T00:00:00.000",
        "count" : "4592"
      }, {
        "item" : "2018-07-17T00:00:00.000",
        "count" : "4575"
      }, {
        "item" : "2018-06-21T00:00:00.000",
        "count" : "4529"
      }, {
        "item" : "2018-06-22T00:00:00.000",
        "count" : "4472"
      }, {
        "item" : "2018-07-20T00:00:00.000",
        "count" : "4394"
      }, {
        "item" : "2018-07-02T00:00:00.000",
        "count" : "4361"
      }, {
        "item" : "2018-10-05T00:00:00.000",
        "count" : "4339"
      }, {
        "item" : "2018-11-12T00:00:00.000",
        "count" : "4307"
      }, {
        "item" : "2018-07-03T00:00:00.000",
        "count" : "4217"
      }, {
        "item" : "2018-07-07T00:00:00.000",
        "count" : "4196"
      } ],
      "smallest" : "2015-01-05T00:03:07.000",
      "count" : "12913050",
      "cardinality" : "10432574"
    },
    "format" : {
      "view" : "date_dmy"
    }
  }, {
    "id" : 23742801,
    "name" : "Hora_",
    "dataTypeName" : "text",
    "description" : "Hora de la mesura",
    "fieldName" : "hora_",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 4513485,
    "cachedContents" : {
      "non_null" : "12913050",
      "largest" : "23:59:59",
      "null" : "0",
      "top" : [ {
        "item" : "17:40:15",
        "count" : "362"
      }, {
        "item" : "18:30:04",
        "count" : "346"
      }, {
        "item" : "13:03:02",
        "count" : "342"
      }, {
        "item" : "13:00:05",
        "count" : "341"
      }, {
        "item" : "18:15:20",
        "count" : "340"
      }, {
        "item" : "13:10:04",
        "count" : "340"
      }, {
        "item" : "17:29:04",
        "count" : "339"
      }, {
        "item" : "13:09:32",
        "count" : "337"
      }, {
        "item" : "19:00:05",
        "count" : "337"
      }, {
        "item" : "12:30:03",
        "count" : "336"
      }, {
        "item" : "13:08:32",
        "count" : "336"
      }, {
        "item" : "18:19:52",
        "count" : "335"
      }, {
        "item" : "19:09:14",
        "count" : "333"
      }, {
        "item" : "19:07:20",
        "count" : "333"
      }, {
        "item" : "18:15:04",
        "count" : "330"
      }, {
        "item" : "18:13:06",
        "count" : "330"
      }, {
        "item" : "12:14:49",
        "count" : "329"
      }, {
        "item" : "18:24:26",
        "count" : "329"
      }, {
        "item" : "18:38:33",
        "count" : "328"
      }, {
        "item" : "17:50:01",
        "count" : "328"
      } ],
      "smallest" : "00:00:00",
      "count" : "12913050",
      "cardinality" : "86401"
    },
    "format" : { }
  }, {
    "id" : 23742802,
    "name" : "Lat",
    "dataTypeName" : "number",
    "description" : "Latitud",
    "fieldName" : "lat",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 4513486,
    "cachedContents" : {
      "non_null" : "12913049",
      "largest" : "63.43513",
      "null" : "1",
      "top" : [ {
        "item" : "41.38",
        "count" : "35163"
      }, {
        "item" : "41.39",
        "count" : "27818"
      }, {
        "item" : "41.4",
        "count" : "23473"
      }, {
        "item" : "41.37",
        "count" : "21074"
      }, {
        "item" : "41.53",
        "count" : "14776"
      }, {
        "item" : "41.49",
        "count" : "13500"
      }, {
        "item" : "41.41",
        "count" : "13387"
      }, {
        "item" : "41.44458",
        "count" : "11915"
      }, {
        "item" : "41.54",
        "count" : "11479"
      }, {
        "item" : "41.56",
        "count" : "11052"
      }, {
        "item" : "41.55",
        "count" : "10780"
      }, {
        "item" : "41.5",
        "count" : "10180"
      }, {
        "item" : "41.36",
        "count" : "9364"
      }, {
        "item" : "41.42",
        "count" : "9211"
      }, {
        "item" : "41.93",
        "count" : "9151"
      }, {
        "item" : "41.35",
        "count" : "9131"
      }, {
        "item" : "41.22",
        "count" : "8756"
      }, {
        "item" : "41.48",
        "count" : "8378"
      }, {
        "item" : "41.44",
        "count" : "8222"
      }, {
        "item" : "42.26",
        "count" : "8164"
      } ],
      "smallest" : "-77.03775",
      "count" : "12913050",
      "cardinality" : "522132"
    },
    "format" : { }
  }, {
    "id" : 23742803,
    "name" : "Long_",
    "dataTypeName" : "number",
    "description" : "Longitud",
    "fieldName" : "long_",
    "position" : 5,
    "renderTypeName" : "number",
    "tableColumnId" : 4513487,
    "cachedContents" : {
      "non_null" : "12913049",
      "largest" : "139.641",
      "null" : "1",
      "top" : [ {
        "item" : "2.15",
        "count" : "20201"
      }, {
        "item" : "2.16",
        "count" : "19098"
      }, {
        "item" : "2.13",
        "count" : "18667"
      }, {
        "item" : "2.14",
        "count" : "18465"
      }, {
        "item" : "2.18",
        "count" : "18090"
      }, {
        "item" : "2.17",
        "count" : "15684"
      }, {
        "item" : "2.24",
        "count" : "14156"
      }, {
        "item" : "2.1",
        "count" : "12825"
      }, {
        "item" : "2.19",
        "count" : "12681"
      }, {
        "item" : "2.2",
        "count" : "11962"
      }, {
        "item" : "2.12",
        "count" : "11187"
      }, {
        "item" : "2.07",
        "count" : "10336"
      }, {
        "item" : "2.09",
        "count" : "9837"
      }, {
        "item" : "2.08",
        "count" : "9828"
      }, {
        "item" : "2",
        "count" : "9655"
      }, {
        "item" : "2.11",
        "count" : "9592"
      }, {
        "item" : "2.01",
        "count" : "9013"
      }, {
        "item" : "2.25",
        "count" : "8687"
      }, {
        "item" : "2.28",
        "count" : "8652"
      }, {
        "item" : "2.21",
        "count" : "8407"
      } ],
      "smallest" : "-178.72917",
      "count" : "12913050",
      "cardinality" : "701118"
    },
    "format" : { }
  }, {
    "id" : 23742804,
    "name" : "Senyal",
    "dataTypeName" : "number",
    "description" : "Senyal mitja (en ASU)",
    "fieldName" : "senyal",
    "position" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 4513488,
    "cachedContents" : {
      "non_null" : "12913049",
      "largest" : "99",
      "null" : "1",
      "top" : [ {
        "item" : "11",
        "count" : "771787"
      }, {
        "item" : "14",
        "count" : "742111"
      }, {
        "item" : "10",
        "count" : "683034"
      }, {
        "item" : "12",
        "count" : "655403"
      }, {
        "item" : "9",
        "count" : "654509"
      }, {
        "item" : "8",
        "count" : "653211"
      }, {
        "item" : "13",
        "count" : "648598"
      }, {
        "item" : "15",
        "count" : "620288"
      }, {
        "item" : "7",
        "count" : "615329"
      }, {
        "item" : "6",
        "count" : "580546"
      }, {
        "item" : "5",
        "count" : "531762"
      }, {
        "item" : "16",
        "count" : "517237"
      }, {
        "item" : "18",
        "count" : "504041"
      }, {
        "item" : "4",
        "count" : "474769"
      }, {
        "item" : "17",
        "count" : "461573"
      }, {
        "item" : "19",
        "count" : "398660"
      }, {
        "item" : "3",
        "count" : "391483"
      }, {
        "item" : "20",
        "count" : "341823"
      }, {
        "item" : "21",
        "count" : "328276"
      }, {
        "item" : "22",
        "count" : "281607"
      } ],
      "smallest" : "0",
      "count" : "12913050",
      "cardinality" : "76"
    },
    "format" : { }
  }, {
    "id" : 23742805,
    "name" : "Xarxa",
    "dataTypeName" : "text",
    "description" : "Xarxa del senyal mesurat",
    "fieldName" : "xarxa",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 4513489,
    "cachedContents" : {
      "non_null" : "12890521",
      "largest" : "yoigo",
      "null" : "22529",
      "top" : [ {
        "item" : "movistar",
        "count" : "5478789"
      }, {
        "item" : "orange",
        "count" : "3144977"
      }, {
        "item" : "vodafone",
        "count" : "3106327"
      }, {
        "item" : "yoigo",
        "count" : "441762"
      }, {
        "item" : "MetroPCS",
        "count" : "95162"
      }, {
        "item" : "jazztel",
        "count" : "60808"
      }, {
        "item" : "Telefonica Moviles Espana",
        "count" : "54745"
      }, {
        "item" : "Orange SP",
        "count" : "47626"
      }, {
        "item" : "Eroski Movil",
        "count" : "40041"
      }, {
        "item" : "simyo 3g",
        "count" : "31804"
      }, {
        "item" : "null",
        "count" : "30756"
      }, {
        "item" : "France Telcom Espana SA",
        "count" : "27203"
      }, {
        "item" : "TICAE",
        "count" : "26763"
      }, {
        "item" : "Lowi",
        "count" : "21740"
      }, {
        "item" : "T-Mobile",
        "count" : "17739"
      }, {
        "item" : "MOBILAND",
        "count" : "17716"
      }, {
        "item" : "F SFR",
        "count" : "16402"
      }, {
        "item" : "VIVO",
        "count" : "15819"
      }, {
        "item" : "icatel",
        "count" : "15392"
      }, {
        "item" : "Orange F",
        "count" : "12255"
      } ],
      "smallest" : "?????",
      "count" : "12913050",
      "cardinality" : "285"
    },
    "format" : { }
  }, {
    "id" : 23742806,
    "name" : "Operador",
    "dataTypeName" : "text",
    "description" : "Operador del senyal mesurat",
    "fieldName" : "operador",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 4513490,
    "cachedContents" : {
      "non_null" : "12890521",
      "largest" : "YOIGO",
      "null" : "22529",
      "top" : [ {
        "item" : "Movistar",
        "count" : "3881676"
      }, {
        "item" : "vodafone ES",
        "count" : "2687072"
      }, {
        "item" : "Orange",
        "count" : "1992094"
      }, {
        "item" : "movistar",
        "count" : "1101923"
      }, {
        "item" : "JAZZTEL",
        "count" : "459629"
      }, {
        "item" : "pepephone",
        "count" : "403204"
      }, {
        "item" : "vodafone es",
        "count" : "276855"
      }, {
        "item" : "YOIGO",
        "count" : "193820"
      }, {
        "item" : "Yoigo",
        "count" : "183022"
      }, {
        "item" : "simyo",
        "count" : "159711"
      }, {
        "item" : "orange",
        "count" : "152364"
      }, {
        "item" : "RACC",
        "count" : "145208"
      }, {
        "item" : "Orange SP",
        "count" : "124574"
      }, {
        "item" : "Vodafone ES",
        "count" : "104302"
      }, {
        "item" : "MetroPCS",
        "count" : "95162"
      }, {
        "item" : "yoigo",
        "count" : "64920"
      }, {
        "item" : "Telefonica Moviles Espana",
        "count" : "54745"
      }, {
        "item" : "adamo",
        "count" : "50343"
      }, {
        "item" : "orange sp",
        "count" : "48598"
      }, {
        "item" : "PARLEM",
        "count" : "48442"
      } ],
      "smallest" : "?????",
      "count" : "12913050",
      "cardinality" : "314"
    },
    "format" : { }
  }, {
    "id" : 23742807,
    "name" : "status",
    "dataTypeName" : "number",
    "description" : "Codi de l'estat de l'origen",
    "fieldName" : "status",
    "position" : 9,
    "renderTypeName" : "number",
    "tableColumnId" : 4513491,
    "cachedContents" : {
      "non_null" : "12913049",
      "largest" : "3",
      "null" : "1",
      "top" : [ {
        "item" : "2",
        "count" : "11480706"
      }, {
        "item" : "0",
        "count" : "1401652"
      }, {
        "item" : "3",
        "count" : "30064"
      }, {
        "item" : "1",
        "count" : "627"
      } ],
      "smallest" : "0",
      "count" : "12913050",
      "cardinality" : "4"
    },
    "format" : { }
  }, {
    "id" : 23742808,
    "name" : "Desc_",
    "dataTypeName" : "text",
    "description" : "Descripció de l'estat de l'origen",
    "fieldName" : "desc_",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 4513492,
    "cachedContents" : {
      "non_null" : "12913050",
      "largest" : "STATE_POWER_OFF",
      "null" : "0",
      "top" : [ {
        "item" : "STATE_EMERGENCY_ONLY",
        "count" : "10401304"
      }, {
        "item" : "STATE_IN_SERVICE",
        "count" : "1313787"
      }, {
        "item" : "NA",
        "count" : "1168136"
      }, {
        "item" : "STATE_POWER_OFF",
        "count" : "29676"
      }, {
        "item" : "STATE_OUT_OF_SERVICE",
        "count" : "147"
      } ],
      "smallest" : "NA",
      "count" : "12913050",
      "cardinality" : "5"
    },
    "format" : { }
  }, {
    "id" : 23742809,
    "name" : "net_type",
    "dataTypeName" : "text",
    "description" : "Nom tipus de Xarxa",
    "fieldName" : "net_type",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 4513493,
    "cachedContents" : {
      "non_null" : "12149769",
      "largest" : "4G",
      "null" : "763281",
      "top" : [ {
        "item" : "4G",
        "count" : "5433140"
      }, {
        "item" : "3G",
        "count" : "4280373"
      }, {
        "item" : "2G",
        "count" : "2436256"
      } ],
      "smallest" : "2G",
      "count" : "12913050",
      "cardinality" : "3"
    },
    "format" : { }
  }, {
    "id" : 23742810,
    "name" : "speed",
    "dataTypeName" : "number",
    "description" : "Velocitat estimat de l'origen",
    "fieldName" : "speed",
    "position" : 12,
    "renderTypeName" : "number",
    "tableColumnId" : 4513494,
    "cachedContents" : {
      "non_null" : "12913048",
      "largest" : "255",
      "null" : "2",
      "top" : [ {
        "item" : "0",
        "count" : "1104960"
      }, {
        "item" : "0.1",
        "count" : "373130"
      }, {
        "item" : "0.2",
        "count" : "268719"
      }, {
        "item" : "0.3",
        "count" : "214386"
      }, {
        "item" : "0.4",
        "count" : "178664"
      }, {
        "item" : "0.5",
        "count" : "157627"
      }, {
        "item" : "0.6",
        "count" : "142602"
      }, {
        "item" : "0.7",
        "count" : "128840"
      }, {
        "item" : "0.8",
        "count" : "117782"
      }, {
        "item" : "0.9",
        "count" : "110337"
      }, {
        "item" : "1",
        "count" : "103807"
      }, {
        "item" : "1.1",
        "count" : "98763"
      }, {
        "item" : "1.2",
        "count" : "96042"
      }, {
        "item" : "1.3",
        "count" : "93541"
      }, {
        "item" : "1.4",
        "count" : "91018"
      }, {
        "item" : "1.5",
        "count" : "89560"
      }, {
        "item" : "1.6",
        "count" : "86765"
      }, {
        "item" : "1.7",
        "count" : "82988"
      }, {
        "item" : "1.8",
        "count" : "81066"
      }, {
        "item" : "1.9",
        "count" : "78487"
      } ],
      "smallest" : "0",
      "count" : "12913050",
      "cardinality" : "2556"
    },
    "format" : { }
  }, {
    "id" : 23742811,
    "name" : "satellites",
    "dataTypeName" : "number",
    "description" : "Numero de satel·lits gps",
    "fieldName" : "satellites",
    "position" : 13,
    "renderTypeName" : "number",
    "tableColumnId" : 4513495,
    "cachedContents" : {
      "non_null" : "12911826",
      "largest" : "11503299477926",
      "null" : "1224",
      "top" : [ {
        "item" : "0",
        "count" : "1820153"
      }, {
        "item" : "4",
        "count" : "1213963"
      }, {
        "item" : "3",
        "count" : "1173577"
      }, {
        "item" : "5",
        "count" : "1144503"
      }, {
        "item" : "6",
        "count" : "1078510"
      }, {
        "item" : "2",
        "count" : "1007677"
      }, {
        "item" : "7",
        "count" : "937857"
      }, {
        "item" : "8",
        "count" : "811912"
      }, {
        "item" : "1",
        "count" : "742757"
      }, {
        "item" : "9",
        "count" : "648678"
      }, {
        "item" : "10",
        "count" : "495192"
      }, {
        "item" : "11",
        "count" : "369504"
      }, {
        "item" : "12",
        "count" : "300580"
      }, {
        "item" : "13",
        "count" : "217300"
      }, {
        "item" : "14",
        "count" : "142687"
      }, {
        "item" : "15",
        "count" : "117804"
      }, {
        "item" : "16",
        "count" : "112278"
      }, {
        "item" : "17",
        "count" : "58222"
      }, {
        "item" : "48",
        "count" : "46598"
      }, {
        "item" : "18",
        "count" : "45755"
      } ],
      "smallest" : "0",
      "count" : "12913050",
      "cardinality" : "705"
    },
    "format" : { }
  }, {
    "id" : 23742812,
    "name" : "precision1",
    "dataTypeName" : "number",
    "description" : "Constant que descriu l'exactitud del proveïdor",
    "fieldName" : "precision1",
    "position" : 14,
    "renderTypeName" : "number",
    "tableColumnId" : 4513496,
    "cachedContents" : {
      "non_null" : "11743688",
      "largest" : "241503912670000",
      "null" : "1169362",
      "top" : [ {
        "item" : "12",
        "count" : "536440"
      }, {
        "item" : "10",
        "count" : "509118"
      }, {
        "item" : "9",
        "count" : "474875"
      }, {
        "item" : "8",
        "count" : "471114"
      }, {
        "item" : "16",
        "count" : "457138"
      }, {
        "item" : "11",
        "count" : "426427"
      }, {
        "item" : "15",
        "count" : "405942"
      }, {
        "item" : "13",
        "count" : "390785"
      }, {
        "item" : "32",
        "count" : "387071"
      }, {
        "item" : "6",
        "count" : "374790"
      }, {
        "item" : "48",
        "count" : "365963"
      }, {
        "item" : "18",
        "count" : "355848"
      }, {
        "item" : "3",
        "count" : "355110"
      }, {
        "item" : "14",
        "count" : "354503"
      }, {
        "item" : "7",
        "count" : "352547"
      }, {
        "item" : "24",
        "count" : "344639"
      }, {
        "item" : "20",
        "count" : "319036"
      }, {
        "item" : "17",
        "count" : "315008"
      }, {
        "item" : "5",
        "count" : "314088"
      }, {
        "item" : "19",
        "count" : "311444"
      } ],
      "smallest" : "0",
      "count" : "12913050",
      "cardinality" : "380"
    },
    "format" : { }
  }, {
    "id" : 23742813,
    "name" : "provider",
    "dataTypeName" : "text",
    "description" : "Nom del proveïdor que ha generat la posició",
    "fieldName" : "provider",
    "position" : 15,
    "renderTypeName" : "text",
    "tableColumnId" : 4513497,
    "cachedContents" : {
      "non_null" : "12913047",
      "largest" : "NETWORK",
      "null" : "3",
      "top" : [ {
        "item" : "gps",
        "count" : "10309656"
      }, {
        "item" : "fused",
        "count" : "1433706"
      }, {
        "item" : "NA",
        "count" : "1168136"
      }, {
        "item" : "GPS",
        "count" : "1125"
      }, {
        "item" : "network",
        "count" : "288"
      }, {
        "item" : "NETWORK",
        "count" : "97"
      }, {
        "item" : "disabled",
        "count" : "27"
      }, {
        "item" : "local_database",
        "count" : "4"
      }, {
        "item" : "4",
        "count" : "2"
      }, {
        "item" : "gps1503861559460",
        "count" : "1"
      }, {
        "item" : "2017-08-28 11:31:10.000000",
        "count" : "1"
      }, {
        "item" : "2017-081503867352116,",
        "count" : "1"
      }, {
        "item" : "19",
        "count" : "1"
      }, {
        "item" : "7",
        "count" : "1"
      }, {
        "item" : "22",
        "count" : "1"
      } ],
      "smallest" : "19",
      "count" : "12913050",
      "cardinality" : "15"
    },
    "format" : { }
  }, {
    "id" : 23742814,
    "name" : "Activitat",
    "dataTypeName" : "text",
    "description" : "Tipus d'activitat més probable que l'usuari està fent",
    "fieldName" : "activitat",
    "position" : 16,
    "renderTypeName" : "text",
    "tableColumnId" : 4513498,
    "cachedContents" : {
      "non_null" : "12913016",
      "largest" : "UNKNOWN",
      "null" : "34",
      "top" : [ {
        "item" : "IN_VEHICLE",
        "count" : "5841815"
      }, {
        "item" : "ON_FOOT",
        "count" : "2230768"
      }, {
        "item" : "STILL",
        "count" : "1506007"
      }, {
        "item" : "TILTING",
        "count" : "1191040"
      }, {
        "item" : "UNKNOWN",
        "count" : "760875"
      }, {
        "item" : "0",
        "count" : "555685"
      }, {
        "item" : "2",
        "count" : "237654"
      }, {
        "item" : "ON_BICYCLE",
        "count" : "214375"
      }, {
        "item" : "4",
        "count" : "173080"
      }, {
        "item" : "3",
        "count" : "160947"
      }, {
        "item" : "1",
        "count" : "23393"
      }, {
        "item" : "5",
        "count" : "17376"
      }, {
        "item" : "NA",
        "count" : "1"
      } ],
      "smallest" : "0",
      "count" : "12913050",
      "cardinality" : "13"
    },
    "format" : { }
  }, {
    "id" : 23742815,
    "name" : "downloadSpeed",
    "dataTypeName" : "text",
    "description" : "Velocitat de baixada de dades mesurada",
    "fieldName" : "downloadspeed",
    "position" : 17,
    "renderTypeName" : "text",
    "tableColumnId" : 4513499,
    "cachedContents" : {
      "non_null" : "3256324",
      "largest" : "yoigo",
      "null" : "9656726",
      "top" : [ {
        "item" : "null",
        "count" : "2082312"
      }, {
        "item" : "NA",
        "count" : "1160870"
      }, {
        "item" : "15080.1131008",
        "count" : "503"
      }, {
        "item" : "11922.5037256",
        "count" : "475"
      }, {
        "item" : "2953.6643896",
        "count" : "404"
      }, {
        "item" : "3267.3065144",
        "count" : "342"
      }, {
        "item" : "5232.1778944",
        "count" : "309"
      }, {
        "item" : "10443.8642296",
        "count" : "304"
      }, {
        "item" : "17130.6209848",
        "count" : "277"
      }, {
        "item" : "21164.021164",
        "count" : "244"
      }, {
        "item" : "2503.1289112",
        "count" : "235"
      }, {
        "item" : "26143.7908496",
        "count" : "226"
      }, {
        "item" : "5988.023952",
        "count" : "226"
      }, {
        "item" : "5291.0052912",
        "count" : "224"
      }, {
        "item" : "109.4848056",
        "count" : "206"
      }, {
        "item" : "3408.6067319999997",
        "count" : "203"
      }, {
        "item" : "7897.3346496",
        "count" : "187"
      }, {
        "item" : "7480.1309024",
        "count" : "180"
      }, {
        "item" : "3179.6502384",
        "count" : "163"
      }, {
        "item" : "21563.3423184",
        "count" : "162"
      } ],
      "smallest" : "10050.251256",
      "count" : "12913050",
      "cardinality" : "803"
    },
    "format" : { }
  }, {
    "id" : 23742816,
    "name" : "uploadSpeed",
    "dataTypeName" : "text",
    "description" : "Velocitat de pujada de dades mesurada",
    "fieldName" : "uploadspeed",
    "position" : 18,
    "renderTypeName" : "text",
    "tableColumnId" : 4513500,
    "cachedContents" : {
      "non_null" : "3256324",
      "largest" : "vodafone",
      "null" : "9656726",
      "top" : [ {
        "item" : "null",
        "count" : "2082293"
      }, {
        "item" : "NA",
        "count" : "1160870"
      }, {
        "item" : "11180.9923128",
        "count" : "502"
      }, {
        "item" : "2696.3262552",
        "count" : "475"
      }, {
        "item" : "875.8964255999999",
        "count" : "404"
      }, {
        "item" : "3296.9297344",
        "count" : "342"
      }, {
        "item" : "5438.4772264",
        "count" : "309"
      }, {
        "item" : "1151.3276248000002",
        "count" : "304"
      }, {
        "item" : "12738.8535032",
        "count" : "257"
      }, {
        "item" : "1376.3440864",
        "count" : "244"
      }, {
        "item" : "5093.9191344",
        "count" : "235"
      }, {
        "item" : "9070.2947848",
        "count" : "226"
      }, {
        "item" : "9714.6326656",
        "count" : "226"
      }, {
        "item" : "1071.8831647999998",
        "count" : "224"
      }, {
        "item" : "1215.713092",
        "count" : "206"
      }, {
        "item" : "1872.659176",
        "count" : "203"
      }, {
        "item" : "4060.9137056",
        "count" : "187"
      }, {
        "item" : "8479.0673024",
        "count" : "180"
      }, {
        "item" : "829.4453088",
        "count" : "163"
      }, {
        "item" : "10126.582278400001",
        "count" : "163"
      } ],
      "smallest" : "0.85603",
      "count" : "12913050",
      "cardinality" : "902"
    },
    "format" : { }
  }, {
    "id" : 23742817,
    "name" : "MUNICIPI",
    "dataTypeName" : "text",
    "description" : "Codi del municipi de l'origen de la mesura",
    "fieldName" : "municipi",
    "position" : 19,
    "renderTypeName" : "text",
    "tableColumnId" : 8166974,
    "cachedContents" : {
      "non_null" : "11980544",
      "largest" : "NA",
      "null" : "932506",
      "top" : [ {
        "item" : "080193",
        "count" : "2136713"
      }, {
        "item" : "251207",
        "count" : "289067"
      }, {
        "item" : "431233",
        "count" : "247956"
      }, {
        "item" : "081017",
        "count" : "231875"
      }, {
        "item" : "80193",
        "count" : "227711"
      }, {
        "item" : "082055",
        "count" : "222022"
      }, {
        "item" : "170792",
        "count" : "184833"
      }, {
        "item" : "080155",
        "count" : "171075"
      }, {
        "item" : "081878",
        "count" : "144026"
      }, {
        "item" : "082798",
        "count" : "127901"
      }, {
        "item" : "083054",
        "count" : "125950"
      }, {
        "item" : "081136",
        "count" : "124771"
      }, {
        "item" : "431482",
        "count" : "107225"
      }, {
        "item" : "080961",
        "count" : "102675"
      }, {
        "item" : "081213",
        "count" : "96698"
      }, {
        "item" : "081691",
        "count" : "83340"
      }, {
        "item" : "083073",
        "count" : "81759"
      }, {
        "item" : "081069",
        "count" : "79569"
      }, {
        "item" : "082981",
        "count" : "78354"
      }, {
        "item" : "171143",
        "count" : "77157"
      } ],
      "smallest" : "080018",
      "count" : "12913050",
      "cardinality" : "1255"
    },
    "format" : { }
  }, {
    "id" : 23742818,
    "name" : "NOM_MUNI",
    "dataTypeName" : "text",
    "description" : "Nom del municipi de l'origen de la mesura",
    "fieldName" : "nom_muni",
    "position" : 20,
    "renderTypeName" : "text",
    "tableColumnId" : 4513502,
    "cachedContents" : {
      "non_null" : "11965012",
      "largest" : "Xerta",
      "null" : "948038",
      "top" : [ {
        "item" : "Barcelona",
        "count" : "2364424"
      }, {
        "item" : "Lleida",
        "count" : "289067"
      }, {
        "item" : "Reus",
        "count" : "247956"
      }, {
        "item" : "l'Hospitalet de Llobregat",
        "count" : "246590"
      }, {
        "item" : "Sant Cugat del Vallès",
        "count" : "234761"
      }, {
        "item" : "Girona",
        "count" : "184833"
      }, {
        "item" : "Badalona",
        "count" : "180475"
      }, {
        "item" : "Sabadell",
        "count" : "165103"
      }, {
        "item" : "Terrassa",
        "count" : "148848"
      }, {
        "item" : "Manresa",
        "count" : "134914"
      }, {
        "item" : "Vilafranca del Penedès",
        "count" : "128195"
      }, {
        "item" : "Mataró",
        "count" : "115768"
      }, {
        "item" : "Granollers",
        "count" : "113897"
      }, {
        "item" : "Tarragona",
        "count" : "107225"
      }, {
        "item" : "Vilanova i la Geltrú",
        "count" : "98495"
      }, {
        "item" : "el Prat de Llobregat",
        "count" : "95551"
      }, {
        "item" : "Vic",
        "count" : "89994"
      }, {
        "item" : "Llinars del Vallès",
        "count" : "82091"
      }, {
        "item" : "Cerdanyola del Vallès",
        "count" : "80932"
      }, {
        "item" : "Sant Boi de Llobregat",
        "count" : "79910"
      } ],
      "smallest" : "Abella de la Conca",
      "count" : "12913050",
      "cardinality" : "946"
    },
    "format" : { }
  }, {
    "id" : 23742819,
    "name" : "Georeferència",
    "dataTypeName" : "point",
    "description" : "",
    "fieldName" : "georefer_ncia",
    "position" : 21,
    "renderTypeName" : "point",
    "tableColumnId" : 14940805,
    "cachedContents" : {
      "non_null" : "12913049",
      "null" : "1",
      "top" : [ {
        "item" : {
          "coordinates" : [ 2.35, 41.49 ],
          "type" : "Point"
        },
        "count" : "5422"
      }, {
        "item" : {
          "coordinates" : [ 1.72, 41.22 ],
          "type" : "Point"
        },
        "count" : "4201"
      }, {
        "item" : {
          "coordinates" : [ 1.7317, 41.44457 ],
          "type" : "Point"
        },
        "count" : "4188"
      }, {
        "item" : {
          "coordinates" : [ 1.7316, 41.44458 ],
          "type" : "Point"
        },
        "count" : "4166"
      }, {
        "item" : {
          "coordinates" : [ 2.18, 41.38 ],
          "type" : "Point"
        },
        "count" : "3916"
      }, {
        "item" : {
          "coordinates" : [ 2.15, 41.38 ],
          "type" : "Point"
        },
        "count" : "3764"
      }, {
        "item" : {
          "coordinates" : [ 2.16, 41.38 ],
          "type" : "Point"
        },
        "count" : "3759"
      }, {
        "item" : {
          "coordinates" : [ 2.14, 41.38 ],
          "type" : "Point"
        },
        "count" : "3752"
      }, {
        "item" : {
          "coordinates" : [ 2.16, 41.39 ],
          "type" : "Point"
        },
        "count" : "3664"
      }, {
        "item" : {
          "coordinates" : [ 2.15, 41.4 ],
          "type" : "Point"
        },
        "count" : "3655"
      }, {
        "item" : {
          "coordinates" : [ 2.44, 41.53 ],
          "type" : "Point"
        },
        "count" : "3623"
      }, {
        "item" : {
          "coordinates" : [ 2.3, 41.59 ],
          "type" : "Point"
        },
        "count" : "3264"
      }, {
        "item" : {
          "coordinates" : [ 2.2, 41.39 ],
          "type" : "Point"
        },
        "count" : "3259"
      }, {
        "item" : {
          "coordinates" : [ 2.15, 41.39 ],
          "type" : "Point"
        },
        "count" : "3227"
      }, {
        "item" : {
          "coordinates" : [ 2.4, 41.75 ],
          "type" : "Point"
        },
        "count" : "3130"
      }, {
        "item" : {
          "coordinates" : [ 1.73169, 41.44458 ],
          "type" : "Point"
        },
        "count" : "3124"
      }, {
        "item" : {
          "coordinates" : [ 2.21, 42.31 ],
          "type" : "Point"
        },
        "count" : "3114"
      }, {
        "item" : {
          "coordinates" : [ 2, 41.38 ],
          "type" : "Point"
        },
        "count" : "3066"
      }, {
        "item" : {
          "coordinates" : [ 2.17, 41.38 ],
          "type" : "Point"
        },
        "count" : "2932"
      }, {
        "item" : {
          "coordinates" : [ 2.34, 41.5 ],
          "type" : "Point"
        },
        "count" : "2860"
      } ],
      "count" : "12913050",
      "cardinality" : "11518654"
    },
    "format" : { }
  }, {
    "id" : 23742820,
    "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_ncia' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_bh64_c7uy",
    "position" : 22,
    "renderTypeName" : "number",
    "tableColumnId" : 14940806,
    "computationStrategy" : {
      "source_columns" : [ "georefer_ncia" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_bh64-c7uy",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 23742821,
    "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_ncia' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_wvic_k925",
    "position" : 23,
    "renderTypeName" : "number",
    "tableColumnId" : 14940807,
    "computationStrategy" : {
      "source_columns" : [ "georefer_ncia" ],
      "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" : {
    "custom_fields" : {
      "Freqüència d'actualització" : {
        "Freqüència d'actualització" : "Dades estàtiques"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Data collected by Cobertura Mòbil (2015-2017) app",
        "Nombre del conjunto de datos (ES)" : "Datos recogidos por la aplicación Cobertura Móvil (2015-2017)"
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Actors" : {
        "Departament" : "Presidència",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Coordenades",
        "Àmbit geogràfic" : "Món"
      }
    },
    "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" : { },
  "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" : [ "cobertura mòbil", "smartcatalonia", "ods9_indústria innovació i infraestructures" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}
