DAM - DAW - MP 0484 Bases de Dades

Comunitats autònomes i províncies

Carrega la següent Col·lecció i busca la solució a les següents preguntes:

Contingut del fitxer

db.provincies.drop();
db.provincies.insertMany([
{"provincia": "\u00c1vila", "geo_point_2d": [40.5710367492, -4.94553505619],
"text": "\u00c1vila", "ccaa": "Castilla y Le\u00f3n", "codi": "05", "cod_ccaa": "07"},
{"provincia": "C\u00e1diz", "geo_point_2d": [36.5538729195, -5.7604183752],
"text": "C\u00e1diz", "ccaa": "Andaluc\u00eda", "codi": "11", "cod_ccaa": "01"},
{"provincia": "Val\u00e8ncia", "geo_point_2d": [39.3702562375, -0.800789615081],
"text": "Valencia", "ccaa": "Comunitat Valenciana", "codi": "46", "cod_ccaa": "10"},
{"provincia": "Madrid", "geo_point_2d": [40.4950873744, -3.71704619215], "text":
"Madrid", "ccaa": "Comunidad de Madrid", "codi": "28", "cod_ccaa": "13"},
{"provincia": "Cantabria", "geo_point_2d": [43.1975220484, -4.03002122038],
"text": "Cantabria", "ccaa": "Cantabria", "codi": "39", "cod_ccaa": "06"},
{"provincia": "Bizkaia", "geo_point_2d": [43.2376797057, -2.85260007926], "text":
"Vizcaya", "ccaa": "Pa\u00eds Vasco", "codi": "48", "cod_ccaa": "16"},
{"provincia": "Asturias", "geo_point_2d": [43.292357861, -5.99350932547], "text":
"Asturias", "ccaa": "Asturias, Principado de", "codi": "33", "cod_ccaa": "03"},
{"provincia": "Las Palmas", "geo_point_2d": [28.3624928216, -14.5509933924],
"text": "Las Palmas", "ccaa": "Canarias", "codi": "35", "cod_ccaa": "05"},
{"provincia": "Pontevedra", "geo_point_2d": [42.435764706, -8.46106294738],
"text": "Pontevedra", "ccaa": "Galicia", "codi": "36", "cod_ccaa": "12"},
{"provincia": "Ja\u00e9n", "geo_point_2d": [38.0165122783, -3.44169215171],
"text": "Ja\u00e9n", "ccaa": "Andaluc\u00eda", "codi": "23", "cod_ccaa": "01"},
{"provincia": "Guadalajara", "geo_point_2d": [40.8134495654, -2.62368878371],
"text": "Guadalajara", "ccaa": "Castilla - La Mancha", "codi": "19", "cod_ccaa": "08"},
{"provincia": "Illes Balears", "geo_point_2d": [39.5751889864, 2.91229172079],
"text": "Islas Baleares", "ccaa": "Illes Balears", "codi": "07", "cod_ccaa": "04"},
{"provincia": "Navarra", "geo_point_2d": [42.6672011509, -1.64611414443], "text":
"Navarra", "ccaa": "Comunidad Foral de Navarra", "codi": "31", "cod_ccaa": "15"},
{"provincia": "Granada", "geo_point_2d": [37.3125169672, -3.26788107732], "text":
"Granada", "ccaa": "Andaluc\u00eda", "codi": "18", "cod_ccaa": "01"},
{"provincia": "La Rioja", "geo_point_2d": [42.2748706958, -2.5170441194], "text":
"La Rioja", "ccaa": "Rioja, La", "codi": "26", "cod_ccaa": "17"},
{"provincia": "A Coru\u00f1a", "geo_point_2d": [43.1257958229, -8.4642836868],
"text": "La Coru\u00f1a", "ccaa": "Galicia", "codi": "15", "cod_ccaa": "12"},
{"provincia": "Teruel", "geo_point_2d": [40.6612619615, -0.815532258446], "text":
"Teruel", "ccaa": "Arag\u00f3n", "codi": "44", "cod_ccaa": "02"},
{"provincia": "Zaragoza", "geo_point_2d": [41.6203648019, -1.06449678144],
"text": "Zaragoza", "ccaa": "Arag\u00f3n", "codi": "50", "cod_ccaa": "02"},
{"provincia": "Badajoz", "geo_point_2d": [38.7097707381, -6.14158521981], "text":
"Badajoz", "ccaa": "Extremadura", "codi": "06", "cod_ccaa": "11"},
{"provincia": "Huesca", "geo_point_2d": [42.2030557371, -0.0728865943582],
"text": "Huesca", "ccaa": "Arag\u00f3n", "codi": "22", "cod_ccaa": "02"},
{"provincia": "Araba", "geo_point_2d": [42.8351264353, -2.72060346921], "text":
"\u00c1lava", "ccaa": "Pa\u00eds Vasco", "codi": "01", "cod_ccaa": "16"},
{"provincia": "Girona", "geo_point_2d": [42.1280117119, 2.6735559327], "text":
"Girona", "ccaa": "Catalunya", "codi": "17", "cod_ccaa": "09"},
{"provincia": "Alacant", "geo_point_2d": [38.4786378049, -0.568699068376],
"text": "Alicante", "ccaa": "Comunitat Valenciana", "codi": "03", "cod_ccaa": "10"},
{"provincia": "Murcia", "geo_point_2d": [38.0023681653, -1.48575629332], "text":
"Murcia", "ccaa": "Regi\u00f3n de Murcia", "codi": "30", "cod_ccaa": "14"},
{"provincia": "Segovia", "geo_point_2d": [41.1710254065, -4.05415057783], "text":
"Segovia", "ccaa": "Castilla y Le\u00f3n", "codi": "40", "cod_ccaa": "07"},
{"provincia": "Zamora", "geo_point_2d": [41.7271743961, -5.98053925522], "text":
"Zamora", "ccaa": "Castilla y Le\u00f3n", "codi": "49", "cod_ccaa": "07"},
{"provincia": "Palencia", "geo_point_2d": [42.3718338546, -4.53585717538],
"text": "Palencia", "ccaa": "Castilla y Le\u00f3n", "codi": "34", "cod_ccaa": "07"},
{"provincia": "Barcelona", "geo_point_2d": [41.7310008895, 1.98405401772],
"text": "Barcelona", "ccaa": "Catalunya", "codi": "08", "cod_ccaa": "09"},
{"provincia": "Cuenca", "geo_point_2d": [39.8960496846, -2.19567153274], "text":
"Cuenca", "ccaa": "Castilla - La Mancha", "codi": "16", "cod_ccaa": "08"},
{"provincia": "M\u00e1laga", "geo_point_2d": [36.8138591651, -4.72586195603],
"text": "M\u00e1laga", "ccaa": "Andaluc\u00eda", "codi": "29", "cod_ccaa": "01"},
{"provincia": "Castell\u00f3", "geo_point_2d": [40.2413705852, -0.146777086937],
"text": "Castell\u00f3n", "ccaa": "Comunitat Valenciana", "codi": "12", "cod_ccaa": "10"},
{"provincia": "Huelva", "geo_point_2d": [37.5771794021, -6.82930221031], "text":
"Huelva", "ccaa": "Andaluc\u00eda", "codi": "21", "cod_ccaa": "01"},
{"provincia": "Santa Cruz de Tenerife", "geo_point_2d": [28.3125567678, -
17.017856743], "text": "Santa Cruz de Tenerife", "ccaa": "Canarias", "codi":
"38", "cod_ccaa": "05"},
{"provincia": "Soria", "geo_point_2d": [41.6207742504, -2.58874304739], "text":
"Soria", "ccaa": "Castilla y Le\u00f3n", "codi": "42", "cod_ccaa": "07"},
{"provincia": "Toledo", "geo_point_2d": [39.7937341614, -4.14815562595], "text":
"Toledo", "ccaa": "Castilla - La Mancha", "codi": "45", "cod_ccaa": "08"},
{"provincia": "Albacete", "geo_point_2d": [38.8254086192, -1.98037326935],
"text": "Albacete", "ccaa": "Castilla - La Mancha", "codi": "02", "cod_ccaa": "08"},
{"provincia": "C\u00e1ceres", "geo_point_2d": [39.7118899607, -6.16082194997],
"text": "C\u00e1ceres", "ccaa": "Extremadura", "codi": "10", "cod_ccaa": "11"},
{"provincia": "Ciudad Real", "geo_point_2d": [38.9256128254, -3.82809764894],
"text": "Ciudad Real", "ccaa": "Castilla - La Mancha", "codi": "13", "cod_ccaa": "08"},
{"provincia": "Lleida", "geo_point_2d": [42.0439686698, 1.04798206104], "text":
"Lleida", "ccaa": "Catalunya", "codi": "25", "cod_ccaa": "09"},
{"provincia": "Lugo", "geo_point_2d": [43.011764, -7.44638404764], "text":
"Lugo", "ccaa": "Galicia", "codi": "27", "cod_ccaa": "12"},
{"provincia": "Ourense", "geo_point_2d": [42.1964503002, -7.59259790937], "text":
"Orense", "ccaa": "Galicia", "codi": "32", "cod_ccaa": "12"},
{"provincia": "Tarragona", "geo_point_2d": [41.0876143957, 0.818127863314],
"text": "Tarragona", "ccaa": "Catalunya", "codi": "43", "cod_ccaa": "09"},
{"provincia": "C\u00f3rdoba", "geo_point_2d": [37.9926944409, -4.80926161095],
"text": "C\u00f3rdoba", "ccaa": "Andaluc\u00eda", "codi": "14", "cod_ccaa": "01"},
{"provincia": "Le\u00f3n", "geo_point_2d": [42.6199552439, -5.83988102629],
"text": "Le\u00f3n", "ccaa": "Castilla y Le\u00f3n", "codi": "24", "cod_ccaa": "07"},
{"provincia": "Burgos", "geo_point_2d": [42.3687127267, -3.58574245567], "text":
"Burgos", "ccaa": "Castilla y Le\u00f3n", "codi": "09", "cod_ccaa": "07"},
{"provincia": "Gipuzcoa", "geo_point_2d": [43.1437759117, -2.19417845709],
"text": "Guip\u00fazcoa", "ccaa": "Pa\u00eds Vasco", "codi": "20", "cod_ccaa": "16"},
{"provincia": "Salamanca", "geo_point_2d": [40.8049892162, -6.06541224773],
"text": "Salamanca", "ccaa": "Castilla y Le\u00f3n", "codi": "37", "cod_ccaa": "07"},
{"provincia": "Melilla", "geo_point_2d": [35.2908279949, -2.95053552337], "text":
"Melilla", "ccaa": "Melilla", "codi": "52", "cod_ccaa": "19"},
{"provincia": "Almer\u00eda", "geo_point_2d": [37.1960852121, -2.3448128003],
"text": "Almer\u00eda", "ccaa": "Andaluc\u00eda", "codi": "04", "cod_ccaa": "01"},
{"provincia": "Sevilla", "geo_point_2d": [37.4356699135, -5.68277303032], "text":
"Sevilla", "ccaa": "Andaluc\u00eda", "codi": "41", "cod_ccaa": "01"},
{"provincia": "Valladolid", "geo_point_2d": [41.6341260695, -4.84719141141],
"text": "Valladolid", "ccaa": "Castilla y Le\u00f3n", "codi": "47", "cod_ccaa": "07"},
{"provincia": "Ceuta", "geo_point_2d": [35.8934069863, -5.34342403891], "text":
"Ceuta", "ccaa": "Ceuta", "codi": "51", "cod_ccaa": "18"}
])

Mostra les dades de la província Girona. find()
Mostra les dades de les províncies de la CCAA de codi 02. find()
Mostra les dades de les províncies de la CCAA de nom Canarias. find()
Mostra només el nom de província i el nom de CCAA. find()
Mostra el nom de les CCAA una sola vegada cadascuna. distinct()
Mostra el codi de les CCAA una sola vegada cadascun. distinct()
Mostra el nom de les CCAA i el codi màxim i mínim de la província. aggregate()
Mostra el nom de les CCAA i el nombre de províncies de cada CCAA aggregate()
Mostra el nom de les CCAA i el nombre de províncies de cada CCAA ordenat per nombre de províncies de forma descendent. Si dues o més CCAA tenen el mateix nombre de províncies ordena per codi nom de CCAA. aggregate()
Mostra el nom de les CCAA que tenen 7 o més províncies. aggregate()
Elimina les províncies de la CCAA de Extremadura. deleteMany