{ "id" : "9aju-tpwc", "name" : "Municipis Catalunya Geo", "assetType" : "dataset", "attribution" : "Catàleg Tècnic de Dades - Institut d'Estadística de Catalunya (IDESCAT), Institut Cartogràfic i Geològic de Catalunya (ICGC)", "attributionLink" : "https://administraciodigital.gencat.cat/ca/dades/dades-obertes/informacio-practica/llicencies/", "averageRating" : 0, "category" : "Urbanisme-infraestructures", "createdAt" : 1614160213, "description" : "Llistat de municipis de Catalunya indicant la comarca a on pertanyen i amb dades de Geolocalització de l'Institut Cartogràfic i Geològic de Catalunya.", "diciBackend" : false, "displayType" : "table", "downloadCount" : 14514, "hideFromCatalog" : false, "hideFromDataJson" : false, "licenseId" : "SEE_TERMS_OF_USE", "locked" : false, "newBackend" : true, "numberOfComments" : 0, "oid" : 2608261, "provenance" : "official", "publicationAppendEnabled" : false, "publicationDate" : 1678810414, "publicationGroup" : 1352498, "publicationStage" : "published", "rowsUpdatedAt" : 1763568689, "rowsUpdatedBy" : "vdnf-89vw", "tableId" : 1762598, "totalTimesRated" : 0, "viewCount" : 15033, "viewLastModified" : 1763568689, "viewType" : "tabular", "approvals" : [ { "reviewedAt" : 1614185843, "reviewedAutomatically" : true, "state" : "approved", "submissionId" : 1303856, "submissionObject" : "public_audience_request", "submissionOutcome" : "change_audience", "submittedAt" : 1614185843, "targetAudience" : "public", "workflowId" : 182, "submissionDetails" : { "permissionType" : "READ" }, "submissionOutcomeApplication" : { "endedAt" : 1614185843, "failureCount" : 0, "startedAt" : 1614185843, "status" : "success" }, "submitter" : { "id" : "a4b5-gx6v", "displayName" : "Dades Obertes Catalunya" } } ], "clientContext" : { "clientContextVariables" : [ ], "inheritedVariables" : { } }, "columns" : [ { "id" : 23749638, "name" : "Codi", "dataTypeName" : "text", "description" : "Identificador únic de municipi. La codificació parteix inicialment de l'ordenació alfabètica segon el nom i dins de cada una de les províncies, tot i que posteriorment ha sofert variacions. És a sis dígits, format de la següent manera: - Els dos primers són el codi de província. - Els tres següents l'identificador de municipi - L'últim és un dígit de control. Els registres amb identificador superior a 999990 són casos especials.", "fieldName" : "codi", "position" : 1, "renderTypeName" : "text", "tableColumnId" : 12238054, "cachedContents" : { "non_null" : "949", "largest" : "999999", "null" : "0", "top" : [ { "item" : "431074", "count" : "1" }, { "item" : "430056", "count" : "1" }, { "item" : "081094", "count" : "1" }, { "item" : "082129", "count" : "1" }, { "item" : "171463", "count" : "1" }, { "item" : "430688", "count" : "1" }, { "item" : "082652", "count" : "1" }, { "item" : "080569", "count" : "1" }, { "item" : "439039", "count" : "1" }, { "item" : "259031", "count" : "1" }, { "item" : "430691", "count" : "1" }, { "item" : "250019", "count" : "1" }, { "item" : "431690", "count" : "1" }, { "item" : "080497", "count" : "1" }, { "item" : "081189", "count" : "1" }, { "item" : "250479", "count" : "1" }, { "item" : "171024", "count" : "1" }, { "item" : "431397", "count" : "1" }, { "item" : "430043", "count" : "1" }, { "item" : "431286", "count" : "1" } ], "smallest" : "080018", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749639, "name" : "Nom", "dataTypeName" : "text", "description" : "Denominació oficial del municipi d'acord amb la legislació de règim local.", "fieldName" : "nom", "position" : 2, "renderTypeName" : "text", "tableColumnId" : 12238059, "cachedContents" : { "non_null" : "949", "largest" : "Xerta", "null" : "0", "top" : [ { "item" : "Vallgorguina", "count" : "1" }, { "item" : "Parets del Vallès", "count" : "1" }, { "item" : "Jafre", "count" : "1" }, { "item" : "Oliana", "count" : "1" }, { "item" : "Boadella i les Escaules", "count" : "1" }, { "item" : "Quar, la", "count" : "1" }, { "item" : "Esquirol, l'", "count" : "1" }, { "item" : "Albagés, l'", "count" : "1" }, { "item" : "Sant Vicenç de Castellet", "count" : "1" }, { "item" : "Benissanet", "count" : "1" }, { "item" : "Artés", "count" : "1" }, { "item" : "Gelida", "count" : "1" }, { "item" : "Albi, l'", "count" : "1" }, { "item" : "Peralada", "count" : "1" }, { "item" : "Fígols", "count" : "1" }, { "item" : "Cerdanyola del Vallès", "count" : "1" }, { "item" : "Garrigàs", "count" : "1" }, { "item" : "Bellprat", "count" : "1" }, { "item" : "Molar, el", "count" : "1" }, { "item" : "Cervelló", "count" : "1" } ], "smallest" : "Abella de la Conca", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749640, "name" : "Codi comarca", "dataTypeName" : "text", "description" : "Identificador de la comarca a on pertany el municipi.", "fieldName" : "codi_comarca", "position" : 3, "renderTypeName" : "text", "tableColumnId" : 12238053, "cachedContents" : { "non_null" : "949", "largest" : "99", "null" : "0", "top" : [ { "item" : "02", "count" : "68" }, { "item" : "24", "count" : "43" }, { "item" : "33", "count" : "38" }, { "item" : "41", "count" : "38" }, { "item" : "10", "count" : "36" }, { "item" : "06", "count" : "33" }, { "item" : "14", "count" : "31" }, { "item" : "23", "count" : "30" }, { "item" : "07", "count" : "30" }, { "item" : "11", "count" : "30" }, { "item" : "21", "count" : "30" }, { "item" : "08", "count" : "28" }, { "item" : "20", "count" : "27" }, { "item" : "03", "count" : "27" }, { "item" : "34", "count" : "26" }, { "item" : "18", "count" : "24" }, { "item" : "01", "count" : "23" }, { "item" : "40", "count" : "23" }, { "item" : "29", "count" : "23" }, { "item" : "36", "count" : "22" } ], "smallest" : "01", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749641, "name" : "Nom comarca", "dataTypeName" : "text", "description" : "Denominació de la comarca a on pertany el municipi. Informació extra, obtinguda a partir de la relació entre municipis i comarques a través del Codi de comarca.", "fieldName" : "nom_comarca", "position" : 4, "renderTypeName" : "text", "tableColumnId" : 12238058, "cachedContents" : { "non_null" : "949", "largest" : "Vallès Oriental", "null" : "0", "top" : [ { "item" : "Alt Empordà", "count" : "68" }, { "item" : "Osona", "count" : "43" }, { "item" : "Segrià", "count" : "38" }, { "item" : "Vallès Oriental", "count" : "38" }, { "item" : "Baix Empordà", "count" : "36" }, { "item" : "Anoia", "count" : "33" }, { "item" : "Berguedà", "count" : "31" }, { "item" : "Noguera", "count" : "30" }, { "item" : "Bages", "count" : "30" }, { "item" : "Maresme", "count" : "30" }, { "item" : "Baix Llobregat", "count" : "30" }, { "item" : "Baix Camp", "count" : "28" }, { "item" : "Gironès", "count" : "27" }, { "item" : "Alt Penedès", "count" : "27" }, { "item" : "Selva", "count" : "26" }, { "item" : "Garrigues", "count" : "24" }, { "item" : "Vallès Occidental", "count" : "23" }, { "item" : "Priorat", "count" : "23" }, { "item" : "Alt Camp", "count" : "23" }, { "item" : "Tarragonès", "count" : "22" } ], "smallest" : "Alta Ribagorça", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749642, "name" : "UTM X", "dataTypeName" : "number", "description" : "Valor de la coordenada X, en el geodèsic de referència és l’EPSG:25831 - ETRS89 / UTM31N, del geopunt (punt central) a on es localitza el municipi. ", "fieldName" : "utm_x", "position" : 5, "renderTypeName" : "number", "tableColumnId" : 12238057, "cachedContents" : { "non_null" : "949", "largest" : "522741.7868", "null" : "0", "top" : [ { "item" : "0.0000", "count" : "2" }, { "item" : "412974.4545", "count" : "1" }, { "item" : "348500.1812", "count" : "1" }, { "item" : "395706.5456", "count" : "1" }, { "item" : "486178.7970", "count" : "1" }, { "item" : "449285.1658", "count" : "1" }, { "item" : "405456.6305", "count" : "1" }, { "item" : "493008.7075", "count" : "1" }, { "item" : "386131.9784", "count" : "1" }, { "item" : "319281.6712", "count" : "1" }, { "item" : "408399.9631", "count" : "1" }, { "item" : "419968.2798", "count" : "1" }, { "item" : "290480.2860", "count" : "1" }, { "item" : "478768.6626", "count" : "1" }, { "item" : "487481.7150", "count" : "1" }, { "item" : "437271.3629", "count" : "1" }, { "item" : "288225.0816", "count" : "1" }, { "item" : "493906.6866", "count" : "1" }, { "item" : "352930.9237", "count" : "1" }, { "item" : "406029.1147", "count" : "1" } ], "smallest" : "0.0000", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749643, "name" : "UTM Y", "dataTypeName" : "number", "description" : "Valor de la coordenada Y, en el geodèsic de referència és l’EPSG:25831 - ETRS89 / UTM31N, del geopunt (punt central) a on es localitza el municipi.", "fieldName" : "utm_y", "position" : 6, "renderTypeName" : "number", "tableColumnId" : 12238052, "cachedContents" : { "non_null" : "949", "largest" : "4745346.7800", "null" : "0", "top" : [ { "item" : "0.0000", "count" : "2" }, { "item" : "4685968.1450", "count" : "1" }, { "item" : "4597316.0820", "count" : "1" }, { "item" : "4666755.2110", "count" : "1" }, { "item" : "4624904.8640", "count" : "1" }, { "item" : "4690585.6060", "count" : "1" }, { "item" : "4614115.9960", "count" : "1" }, { "item" : "4647027.4080", "count" : "1" }, { "item" : "4598317.7310", "count" : "1" }, { "item" : "4678947.2320", "count" : "1" }, { "item" : "4673532.4910", "count" : "1" }, { "item" : "4528421.6400", "count" : "1" }, { "item" : "4621508.0870", "count" : "1" }, { "item" : "4633756.3160", "count" : "1" }, { "item" : "4679445.6340", "count" : "1" }, { "item" : "4685820.2310", "count" : "1" }, { "item" : "4558350.2440", "count" : "1" }, { "item" : "4669045.2820", "count" : "1" }, { "item" : "4491059.4590", "count" : "1" }, { "item" : "4606589.8470", "count" : "1" } ], "smallest" : "0.0000", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749644, "name" : "Longitud", "dataTypeName" : "number", "description" : "Valor de la longitud, expressat en format decimal, en el geodèsic de referència és l’EPSG:25831 - ETRS89 / lon-lat del geopunt (punt central) a on es localitza el municipi.", "fieldName" : "longitud", "position" : 7, "renderTypeName" : "number", "tableColumnId" : 12238056, "cachedContents" : { "non_null" : "949", "largest" : "3.275849152", "null" : "0", "top" : [ { "item" : "0E-9", "count" : "2" }, { "item" : "3.064692114", "count" : "1" }, { "item" : "1.217309912", "count" : "1" }, { "item" : "3.026900742", "count" : "1" }, { "item" : "2.743365182", "count" : "1" }, { "item" : "0.605376149", "count" : "1" }, { "item" : "1.206824514", "count" : "1" }, { "item" : "1.700317601", "count" : "1" }, { "item" : "1.246309237", "count" : "1" }, { "item" : "2.178421008", "count" : "1" }, { "item" : "2.954141859", "count" : "1" }, { "item" : "0.958121082", "count" : "1" }, { "item" : "2.325763581", "count" : "1" }, { "item" : "1.590910882", "count" : "1" }, { "item" : "0.763893912", "count" : "1" }, { "item" : "1.291294091", "count" : "1" }, { "item" : "2.009712625", "count" : "1" }, { "item" : "0.583741122", "count" : "1" }, { "item" : "3.275849152", "count" : "1" }, { "item" : "2.731325675", "count" : "1" } ], "smallest" : "0E-9", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749645, "name" : "Latitud", "dataTypeName" : "number", "description" : "Valor de la latitud, expressat en format decimal, en el geodèsic de referència és l’EPSG:25831 - ETRS89 / lon-lat del geopunt (punt central) a on es localitza el municipi.", "fieldName" : "latitud", "position" : 8, "renderTypeName" : "number", "tableColumnId" : 12238055, "cachedContents" : { "non_null" : "949", "largest" : "42.83836792", "null" : "0", "top" : [ { "item" : "0E-8", "count" : "2" }, { "item" : "41.92412424", "count" : "1" }, { "item" : "41.67921889", "count" : "1" }, { "item" : "41.67220364", "count" : "1" }, { "item" : "42.36821251", "count" : "1" }, { "item" : "42.75497977", "count" : "1" }, { "item" : "41.98028526", "count" : "1" }, { "item" : "41.10184911", "count" : "1" }, { "item" : "41.47753985", "count" : "1" }, { "item" : "41.50238859", "count" : "1" }, { "item" : "41.63550377", "count" : "1" }, { "item" : "42.18318266", "count" : "1" }, { "item" : "41.58011517", "count" : "1" }, { "item" : "41.56287362", "count" : "1" }, { "item" : "41.53238304", "count" : "1" }, { "item" : "42.05713729", "count" : "1" }, { "item" : "42.41282570", "count" : "1" }, { "item" : "42.09382295", "count" : "1" }, { "item" : "42.21106657", "count" : "1" }, { "item" : "41.62939237", "count" : "1" } ], "smallest" : "0E-8", "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749646, "name" : "Georeferència", "dataTypeName" : "point", "description" : "Valor de format geogràfic, calculat automàticament a partir dels atributs Longitud i Latitud, que s’utilitza per a la georeferenciació del punt central a on es localitza el municipi.", "fieldName" : "georefer_ncia", "position" : 9, "renderTypeName" : "point", "tableColumnId" : 14945494, "cachedContents" : { "non_null" : "949", "null" : "0", "top" : [ { "item" : { "coordinates" : [ 0.0, 0.0 ], "type" : "Point" }, "count" : "2" }, { "item" : { "coordinates" : [ 1.766295575, 41.67923246 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 2.295144857, 41.49384008 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.039134837, 41.11362398 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 0.723326471, 41.28022562 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 2.260585184, 42.04713193 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.566512595, 42.23122593 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.186369339, 41.91533392 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.363104482, 41.34655112 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 2.53916522, 41.61094994 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.38330159, 41.53238304 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.480451914, 42.23356279 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 0.56965673, 41.82999269 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.252463404, 41.91086491 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.341832868, 42.29395966 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 2.243276016, 41.94048906 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 2.253349207, 41.51957597 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.206824514, 41.24822743 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 1.703544417, 41.47766643 ], "type" : "Point" }, "count" : "1" }, { "item" : { "coordinates" : [ 0.694256215, 41.6470102 ], "type" : "Point" }, "count" : "1" } ], "count" : "949", "cardinality" : "949" }, "format" : { } }, { "id" : 23749647, "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" : 10, "renderTypeName" : "number", "tableColumnId" : 14945495, "computationStrategy" : { "source_columns" : [ "georefer_ncia" ], "type" : "georegion_match_on_point", "parameters" : { "region" : "_bh64-c7uy", "primary_key" : "_feature_id" } }, "format" : { } }, { "id" : 23749648, "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" : 11, "renderTypeName" : "number", "tableColumnId" : 14945496, "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)" : "Municipalities of Catalonia Geo", "Nombre del conjunto de datos (ES)" : "Municipios de Catalunya Geo" }, "Informació de gènere o sexe" : { "Informació de gènere o sexe" : "No aplicable" }, "Actors" : { "Departament" : "Territori, Habitatge i Transició Ecològica", "Organisme o institució" : "IDESCAT", "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" : [ "dades_de_referència", "ods9_indústria innovació i infraestructures", "ods11_ciutats i comunitats sostenibles" ], "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ] }