{
  "id" : "x4tc-npww",
  "name" : "Geolocalització dels municipis amb sistema de llistes obertes o consell obert",
  "assetType" : "dataset",
  "attribution" : "Subdirecció General de Processos Electorals i Democràcia Directa",
  "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/",
  "averageRating" : 0,
  "category" : "Sector Públic",
  "createdAt" : 1678374170,
  "description" : "Es mostren els municipis de Catalunya, localitzats geogràficament i amb el punt marcat en diferent color segons si tenen el sistema de llistes obertes o de consell obert.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 421,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "SEE_TERMS_OF_USE",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 2602782,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1678374476,
  "publicationGroup" : 1759222,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1679472196,
  "rowsUpdatedBy" : "nwrb-z6nc",
  "tableId" : 1759222,
  "totalTimesRated" : 0,
  "viewCount" : 730,
  "viewLastModified" : 1744021053,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1750676644,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 1509536,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1750676644,
    "targetAudience" : "public",
    "workflowId" : 182,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "endedAt" : 1750676644,
      "failureCount" : 0,
      "startedAt" : 1750676644,
      "status" : "success"
    },
    "submitter" : {
      "id" : "yfnw-wvkz",
      "displayName" : "briangonzalez@gencat.cat"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 23725376,
    "name" : "Nom municipi",
    "dataTypeName" : "text",
    "description" : "Nom oficial del municipi",
    "fieldName" : "nom_municipi",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 14931664,
    "cachedContents" : {
      "non_null" : "178",
      "largest" : "VIVER I SERRATEIX",
      "null" : "0",
      "top" : [ {
        "item" : "ARGENTERA, L'",
        "count" : "1"
      }, {
        "item" : "GRANERA",
        "count" : "1"
      }, {
        "item" : "ALÒS DE BALAGUER",
        "count" : "1"
      }, {
        "item" : "MONTCLAR",
        "count" : "1"
      }, {
        "item" : "ALBANYÀ",
        "count" : "1"
      }, {
        "item" : "VALLBONA DE LES MONGES",
        "count" : "1"
      }, {
        "item" : "MONT-RAL",
        "count" : "1"
      }, {
        "item" : "ARSÈGUEL",
        "count" : "1"
      }, {
        "item" : "MERANGES",
        "count" : "1"
      }, {
        "item" : "BAUSEN",
        "count" : "1"
      }, {
        "item" : "CIUTADILLA",
        "count" : "1"
      }, {
        "item" : "VECIANA",
        "count" : "1"
      }, {
        "item" : "CAPAFONTS",
        "count" : "1"
      }, {
        "item" : "CASTELLFOLLIT DE RIUBREGÓS",
        "count" : "1"
      }, {
        "item" : "GISCLARENY",
        "count" : "1"
      }, {
        "item" : "TALAMANCA",
        "count" : "1"
      }, {
        "item" : "FORADADA",
        "count" : "1"
      }, {
        "item" : "SETCASES",
        "count" : "1"
      }, {
        "item" : "TARRÉS",
        "count" : "1"
      }, {
        "item" : "CLARIANA DE CARDENER",
        "count" : "1"
      } ],
      "smallest" : "ABELLA DE LA CONCA",
      "count" : "178",
      "cardinality" : "178"
    },
    "format" : { }
  }, {
    "id" : 23725375,
    "name" : "Sistema electoral",
    "dataTypeName" : "text",
    "description" : "Llistes obertes o consell obert",
    "fieldName" : "sistema_electoral",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 14931663,
    "cachedContents" : {
      "non_null" : "178",
      "largest" : "Llistes obertes",
      "null" : "0",
      "top" : [ {
        "item" : "Llistes obertes",
        "count" : "172"
      }, {
        "item" : "Consell obert",
        "count" : "6"
      } ],
      "smallest" : "Consell obert",
      "count" : "178",
      "cardinality" : "2"
    },
    "format" : { }
  }, {
    "id" : 23725374,
    "name" : "Latitud",
    "dataTypeName" : "number",
    "description" : "Latitud de les coordenades on es troba situat geogràficament el nucli principal",
    "fieldName" : "latitud",
    "position" : 3,
    "renderTypeName" : "number",
    "tableColumnId" : 14931662,
    "cachedContents" : {
      "non_null" : "178",
      "largest" : "42.84022",
      "null" : "0",
      "top" : [ {
        "item" : "42.00023",
        "count" : "1"
      }, {
        "item" : "42.23876",
        "count" : "1"
      }, {
        "item" : "41.12443",
        "count" : "1"
      }, {
        "item" : "41.86869",
        "count" : "1"
      }, {
        "item" : "41.20711",
        "count" : "1"
      }, {
        "item" : "41.65594",
        "count" : "1"
      }, {
        "item" : "41.22469",
        "count" : "1"
      }, {
        "item" : "41.52512",
        "count" : "1"
      }, {
        "item" : "42.07973",
        "count" : "1"
      }, {
        "item" : "41.36808",
        "count" : "1"
      }, {
        "item" : "42.00989",
        "count" : "1"
      }, {
        "item" : "41.04037",
        "count" : "1"
      }, {
        "item" : "42.05257",
        "count" : "1"
      }, {
        "item" : "42.13685",
        "count" : "1"
      }, {
        "item" : "41.97083",
        "count" : "1"
      }, {
        "item" : "42.38333",
        "count" : "1"
      }, {
        "item" : "42.32506",
        "count" : "1"
      }, {
        "item" : "41.77198",
        "count" : "1"
      }, {
        "item" : "42.16174",
        "count" : "1"
      }, {
        "item" : "42.23445",
        "count" : "1"
      } ],
      "smallest" : "40.98371",
      "count" : "178",
      "cardinality" : "178"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 23725373,
    "name" : "Longitud",
    "dataTypeName" : "number",
    "description" : "Longitud de les coordenades on es troba situat geogràficament el nucli principal",
    "fieldName" : "longitud",
    "position" : 4,
    "renderTypeName" : "number",
    "tableColumnId" : 14931661,
    "cachedContents" : {
      "non_null" : "178",
      "largest" : "3.18855",
      "null" : "0",
      "top" : [ {
        "item" : "1.97484",
        "count" : "1"
      }, {
        "item" : "1.32053",
        "count" : "1"
      }, {
        "item" : "1.58282",
        "count" : "1"
      }, {
        "item" : "3.12803",
        "count" : "1"
      }, {
        "item" : "0.73164",
        "count" : "1"
      }, {
        "item" : "1.02696",
        "count" : "1"
      }, {
        "item" : "2.31007",
        "count" : "1"
      }, {
        "item" : "1.66029",
        "count" : "1"
      }, {
        "item" : "0.93581",
        "count" : "1"
      }, {
        "item" : "1.76497",
        "count" : "1"
      }, {
        "item" : "2.27709",
        "count" : "1"
      }, {
        "item" : "1.23664",
        "count" : "1"
      }, {
        "item" : "1.97513",
        "count" : "1"
      }, {
        "item" : "2.99331",
        "count" : "1"
      }, {
        "item" : "1.02414",
        "count" : "1"
      }, {
        "item" : "1.22999",
        "count" : "1"
      }, {
        "item" : "2.14002",
        "count" : "1"
      }, {
        "item" : "1.09858",
        "count" : "1"
      }, {
        "item" : "2.11535",
        "count" : "1"
      }, {
        "item" : "0.94658",
        "count" : "1"
      } ],
      "smallest" : "0.25113",
      "count" : "178",
      "cardinality" : "178"
    },
    "format" : {
      "decimalSeparator" : ",",
      "groupSeparator" : "."
    }
  }, {
    "id" : 23725372,
    "name" : "Georeferència",
    "dataTypeName" : "point",
    "description" : "",
    "fieldName" : "georefer_ncia",
    "position" : 5,
    "renderTypeName" : "point",
    "tableColumnId" : 14931660,
    "cachedContents" : {
      "non_null" : "178",
      "null" : "0",
      "top" : [ {
        "item" : {
          "coordinates" : [ 1.61115, 42.32589 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.02414, 41.46358 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.23664, 41.56343 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.40066, 41.97083 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.92491, 41.91632 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 0.71736, 42.83663 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.83604, 42.18094 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 2.30149, 42.37478 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 0.72143, 41.39421 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 2.96418, 42.17388 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 2.82916, 42.33757 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.31202, 41.79836 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 0.91773, 42.07477 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 0.85559, 42.11125 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.62425, 41.93398 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.64242, 42.13685 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.29113, 41.51862 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.44352, 41.59794 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.26961, 41.59052 ],
          "type" : "Point"
        },
        "count" : "1"
      }, {
        "item" : {
          "coordinates" : [ 1.32053, 41.76249 ],
          "type" : "Point"
        },
        "count" : "1"
      } ],
      "count" : "178",
      "cardinality" : "178"
    },
    "format" : { }
  }, {
    "id" : 23725377,
    "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" : 6,
    "renderTypeName" : "number",
    "tableColumnId" : 14931665,
    "computationStrategy" : {
      "source_columns" : [ "georefer_ncia" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_bh64-c7uy",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 23725378,
    "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" : 7,
    "renderTypeName" : "number",
    "tableColumnId" : 14931666,
    "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ó" : "Variable"
      },
      "Idioma" : {
        "Idioma" : "Català",
        "Dataset name (EN)" : "Geolocation of municipalities with open list system or open council.",
        "Nombre del conjunto de datos (ES)" : "Geolocalización de los municipios con sistema de listas abiertas o consejo abierto."
      },
      "Informació de gènere o sexe" : {
        "Informació de gènere o sexe" : "No aplicable"
      },
      "Actors" : {
        "Departament" : "Justícia i Qualitat Democràtica",
        "Tipus actor" : "Generalitat de Catalunya"
      },
      "Àmbit geogràfic" : {
        "Informació geogràfica" : "Coordenades",
        "Àmbit geogràfic" : "Catalunya"
      }
    },
    "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" : [ "eleccions", "locals", "municipis", "llistes obertes", "consell obert", "ods16_pau justícies i institucions sòlides" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}