Message Boards Message Boards

Confirmed COVID-19 Cases in Catalonia

UPDATED notebook and CSV source file for March attached: COVID-19CatalunyaMarch_2020.nb

Interactive map with tooltip info displayed for each municipality: wolframcloud.com/obj/bernate/covidcat

Evolution of confirmed cases in Catalonia, March 2020

Source: analisi.transparenciacatalunya.cat

CSV format API:

genderDataCSV=Import["https://analisi.transparenciacatalunya.cat/resource/jj6z-iyrp.csv"]

Sample (date, division, municipality, gender, test result, cases)

TableForm[Transpose[genderDataCSV[[;; 2]]]]

csv sample

City Location List

cityloc={"Albesa"->GeoPosition[{41.75`,0.67`}],
"Aiguamúrcia"->GeoPosition[{41.329339`,1.3585409`}],"Alcover"->GeoPosition[{41.2620504`,1.1711248`}],"Bràfim"->GeoPosition[{41.27055556`,1.34166667`}],"Cabra del Camp"->GeoPosition[{41.39722222`,1.27777778`}],"Figuerola del Camp"->GeoPosition[{41.371399`,1.264977`}],"Els Garidells"->GeoPosition[{41.207451`,1.247507`}],"El Milà"->GeoPosition[{41.24791`,1.20667`}],"Montferri"->GeoPosition[{41.265384`,1.365801`}],"Nulles"->GeoPosition[{41.249369`,1.295206`}],"El Pla de Santa Maria"->GeoPosition[{41.363909`,1.289333`}],"El Pont d'Armentera"->GeoPosition[{41.383036`,1.362838`}],"Puigpelat"->GeoPosition[{41.27797`,1.29711`}],"Rodonyà"->GeoPosition[{41.27988`,1.39909`}],"Vallmoll"->GeoPosition[{41.2459224`,1.2496811`}],"Valls"->GeoPosition[{41.288333`,1.250833`}],"Vilabella"->GeoPosition[{41.248439`,1.330786`}],"Vila-Rodona"->GeoPosition[{41.310512`,1.357966`}],"Avinyonet del Penedès"->GeoPosition[{41.36305556`,1.77888889`}],"Les Cabanyes"->GeoPosition[{41.37305556`,1.69027778`}],"Castellet i la Gornal"->GeoPosition[{41.254323`,1.592833`}],"Castellví de la Marca"->GeoPosition[{41.32805556`,1.61972222`}],"Gelida"->GeoPosition[{41.4409078`,1.8646915`}],"La Granada"->GeoPosition[{41.37916667`,1.72027778`}],"Mediona"->GeoPosition[{41.47972222`,1.6125`}],"Olèrdola"->GeoPosition[{41.32166667`,1.72305556`}],"Olesa de Bonesvalls"->GeoPosition[{41.35527778`,1.85055556`}],"Pacs del Penedès"->GeoPosition[{41.36416667`,1.67083333`}],"El Pla del Penedès"->GeoPosition[{41.417615`,1.712842`}],"Puigdàlber"->GeoPosition[{41.40611111`,1.70138889`}],"Sant Cugat Sesgarrigues"->GeoPosition[{41.36611111`,1.75416667`}],"Sant Llorenç d'Hortons"->GeoPosition[{41.46972222`,1.82555556`}],"Sant Martí Sarroca"->GeoPosition[{41.38722222`,1.61194444`}],"Sant Pere de Riudebitlles"->GeoPosition[{41.4525`,1.70472222`}],"Sant Quintí de Mediona"->GeoPosition[{41.46444444`,1.665`}],"Sant Sadurní d'Anoia"->GeoPosition[{41.42611111`,1.785`}],"Santa Fe del Penedès"->GeoPosition[{41.38694444`,1.72166667`}],"Santa Margarida i els Monjos"->GeoPosition[{41.32305556`,1.66472222`}],"Subirats"->GeoPosition[{41.38472222`,1.79805556`}],"Torrelavit"->GeoPosition[{41.44944444`,1.73`}],"Torrelles de Foix"->GeoPosition[{41.39`,1.57055556`}],"Vilobí del Penedès"->GeoPosition[{41.39055556`,1.6625`}],"Vilafranca del Penedès"->GeoPosition[{41.34472222`,1.69944444`}],"Alàs i Cerc"->GeoPosition[{42.35361111`,1.50916667`}],"Bassella"->GeoPosition[{42.005826`,1.29456`}],"Montferrer i Castellbò"->GeoPosition[{42.34305556`,1.42916667`}],"Oliana"->GeoPosition[{42.067136`,1.31419`}],"Organyà"->GeoPosition[{42.21277778`,1.32944444`}],"Ribera d'Urgellet"->GeoPosition[{42.31444444`,1.38361111`}],"La Seu d'Urgell"->GeoPosition[{42.35777778`,1.45861111`}],"La Vall de Boí"->GeoPosition[{42.50722222`,0.80166667`}],"El Pont de Suert"->GeoPosition[{42.408249`,0.741699`}],"Vilaller"->GeoPosition[{42.476623`,0.717366`}],"Argençola"->GeoPosition[{41.59972222`,1.44583333`}],"El Bruc"->GeoPosition[{41.5825`,1.78111111`}],"Cabrera d'Anoia"->GeoPosition[{41.47944444`,1.70472222`}],"Calonge de Segarra"->GeoPosition[{41.76583333`,1.4825`}],"Capellades"->GeoPosition[{41.53194444`,1.68666667`}],"Carme"->GeoPosition[{41.5313629`,1.6211224`}],"Castellfollit de Riubregós"->GeoPosition[{41.7762237`,1.4383714`}],"Castellolí"->GeoPosition[{41.5981563`,1.7002323`}],"Copons"->GeoPosition[{41.63833333`,1.51944444`}],"Igualada"->GeoPosition[{41.58138889`,1.62083333`}],"Jorba"->GeoPosition[{41.60361111`,1.54888889`}],"La Llacuna"->GeoPosition[{41.47416667`,1.53416667`}],"Masquefa"->GeoPosition[{41.50361111`,1.81361111`}],"Montmaneu"->GeoPosition[{41.62722222`,1.41722222`}],"Òdena"->GeoPosition[{41.60805556`,1.64194444`}],"Orpí"->GeoPosition[{41.53083333`,1.60805556`}],"Piera"->GeoPosition[{41.52222222`,1.74944444`}],"Els Hostalets de Pierola"->GeoPosition[{41.53555556`,1.77194444`}],"La Pobla de Claramunt"->GeoPosition[{41.55444444`,1.67972222`}],"Els Prats de Rei"->GeoPosition[{41.7075`,1.54222222`}],"Sant Martí de Tous"->GeoPosition[{41.56194444`,1.52472222`}],"Sant Martí Sesgueioles"->GeoPosition[{41.70305556`,1.49027778`}],"Santa Margarida de Montbui"->GeoPosition[{41.57555556`,1.60916667`}],"Santa Maria de Miralles"->GeoPosition[{41.51972222`,1.52777778`}],"La Torre de Claramunt"->GeoPosition[{41.53527778`,1.66083333`}],"Vallbona d'Anoia"->GeoPosition[{41.52083333`,1.70888889`}],"Veciana"->GeoPosition[{41.65833333`,1.48944444`}],"Vilanova del Camí"->GeoPosition[{41.57333333`,1.63805556`}],"Artés"->GeoPosition[{41.798134`,1.955215`}],"Avinyó"->GeoPosition[{41.8630096`,1.9707409`}],"Balsareny"->GeoPosition[{41.86583333`,1.87694444`}],"Callús"->GeoPosition[{41.7824664`,1.7837664`}],"Cardona"->GeoPosition[{41.9141431`,1.6809864`}],"Castellbell i el Vilar"->GeoPosition[{41.63388889`,1.86361111`}],"Castellgalí"->GeoPosition[{41.6732765`,1.8378043`}],"Castellnou de Bages"->GeoPosition[{41.8348412`,1.8364808`}],"Fonollosa"->GeoPosition[{41.763222`,1.669006`}],"Sant Salvador de Guardiola"->GeoPosition[{41.6797988`,1.7671087`}],"Manresa"->GeoPosition[{41.72638889`,1.82916667`}],"Monistrol de Montserrat"->GeoPosition[{41.60944444`,1.84194444`}],"Navarcles"->GeoPosition[{41.7531567`,1.9033612`}],"Navàs"->GeoPosition[{41.89972222`,1.87861111`}],"Rajadell"->GeoPosition[{41.7291916`,1.7056275`}],"El Pont de Vilomara i Rocafort"->GeoPosition[{41.7049439`,1.90763497`}],"Sallent"->GeoPosition[{41.8259065`,1.8948758`}],"Santpedor"->GeoPosition[{41.78361111`,1.83916667`}],"Sant Feliu Sasserra"->GeoPosition[{41.946`,2.023`}],"Sant Fruitós de Bages"->GeoPosition[{41.750728`,1.872651`}],"Sant Joan de Vilatorrada"->GeoPosition[{41.74555556`,1.80555556`}],"Sant Mateu de Bages"->GeoPosition[{41.7969781`,1.7327386`}],"Marganell"->GeoPosition[{41.640556`,1.7907524`}],"Sant Vicenç de Castellet"->GeoPosition[{41.66549`,1.864089`}],"Súria"->GeoPosition[{41.831136`,1.752564`}],"l'Albiol"->GeoPosition[{41.251823`,1.089617`}],"L'Aleixar"->GeoPosition[{41.20159`,1.0458`}],"Alforja"->GeoPosition[{41.21138`,0.97553`}],"Almoster"->GeoPosition[{41.19768`,1.11276`}],"Les Borges del Camp"->GeoPosition[{41.17215`,1.02044`}],"Botarell"->GeoPosition[{41.1375`,0.99055556`}],"Cambrils"->GeoPosition[{41.06699`,1.05645`}],"Castellvell del Camp"->GeoPosition[{41.18005`,1.0987`}],"Colldejou"->GeoPosition[{41.09952`,0.88746`}],"Duesaigües"->GeoPosition[{41.14562`,0.93005`}],"Maspujols"->GeoPosition[{41.18213`,1.04595`}],"Montbrió del Camp"->GeoPosition[{41.12075`,1.003491`}],"Mont-Roig del Camp"->GeoPosition[{41.088245`,0.957827`}],"Pratdip"->GeoPosition[{41.0513`,0.87128`}],"Reus"->GeoPosition[{41.15487`,1.10871`}],"Riudecanyes"->GeoPosition[{41.130174`,0.960748`}],"Riudoms"->GeoPosition[{41.1390915`,1.0519702`}],"La Selva del Camp"->GeoPosition[{41.215501`,1.137309`}],"Vandellòs i l'Hospitalet de l'Infant"->GeoPosition[{41.02138889`,0.83194444`}],"Vilanova d'Escornalbou"->GeoPosition[{41.11371`,0.93667`}],"Vilaplana"->GeoPosition[{41.2286`,1.03301`}],"Vinyols i  els Arcs"->GeoPosition[{41.11367`,1.03935`}],"Aldover"->GeoPosition[{40.88166667`,0.50111111`}],"L'Ametlla de Mar"->GeoPosition[{40.8838957`,0.8024645`}],"Benifallet"->GeoPosition[{40.97583333`,0.51777778`}],"Xerta"->GeoPosition[{40.90944444`,0.49166667`}],"Roquetes"->GeoPosition[{40.82063`,0.502505`}],"Tivenys"->GeoPosition[{40.90944444`,0.51333333`}],"Tortosa"->GeoPosition[{40.8125`,0.52111111`}],"Deltebre"->GeoPosition[{40.71944444`,0.70833333`}],"Camarles"->GeoPosition[{40.77361111`,0.6725`}],"l'Aldea"->GeoPosition[{40.74166667`,0.61194444`}],"L'Ampolla"->GeoPosition[{40.81416667`,0.71`}],"Abrera"->GeoPosition[{41.516465`,1.902428`}],"Begues"->GeoPosition[{41.331907`,1.922779`}],"Castelldefels"->GeoPosition[{41.28`,1.97666667`}],"Cervelló"->GeoPosition[{41.396166`,1.958895`}],"Collbató"->GeoPosition[{41.57083333`,1.83027778`}],"Corbera de Llobregat"->GeoPosition[{41.41694444`,1.93138889`}],"Cornellà de Llobregat"->GeoPosition[{41.355`,2.07111111`}],"Esparreguera"->GeoPosition[{41.53805556`,1.86916667`}],"Esplugues de Llobregat"->GeoPosition[{41.37666667`,2.08583333`}],"Gavà"->GeoPosition[{41.30722222`,2.00388889`}],"Martorell"->GeoPosition[{41.47444`,1.930537`}],"Molins de Rei"->GeoPosition[{41.41388889`,2.01583333`}],"Olesa de Montserrat"->GeoPosition[{41.545`,1.89444444`}],"Pallejà"->GeoPosition[{41.42416667`,1.99777778`}],"El Papiol"->GeoPosition[{41.43916667`,2.01055556`}],"El Prat de Llobregat"->GeoPosition[{41.3246333`,2.0952568`}],"Sant Andreu de la Barca"->GeoPosition[{41.44777778`,1.97694444`}],"Sant Boi de Llobregat"->GeoPosition[{41.34583333`,2.04166667`}],"Sant Climent de Llobregat"->GeoPosition[{41.33805556`,1.99833333`}],"Sant Esteve Sesrovires"->GeoPosition[{41.495`,1.87444444`}],"Sant Feliu de Llobregat"->GeoPosition[{41.38333333`,2.04388889`}],"Sant Joan Despí"->GeoPosition[{41.3667951`,2.0570346`}],"Sant Just Desvern"->GeoPosition[{41.383333`,2.075`}],"Santa Coloma de Cervelló"->GeoPosition[{41.3687006`,2.0174512`}],"Sant Vicenç dels Horts"->GeoPosition[{41.3932274`,2.009708`}],"Torrelles de Llobregat"->GeoPosition[{41.3565232`,1.9816276`}],"Vallirana"->GeoPosition[{41.3877623`,1.9320806`}],"Viladecans"->GeoPosition[{41.31583333`,2.01944444`}],"La Palma de Cervelló"->GeoPosition[{41.4129722`,1.9686826`}],"Albinyana"->GeoPosition[{41.2454739`,1.486748`}],"L'Arboç"->GeoPosition[{41.26763`,1.60431`}],"Banyeres del Penedès"->GeoPosition[{41.27963`,1.58334`}],"Bellvei"->GeoPosition[{41.24126`,1.57664`}],"La Bisbal del Penedès"->GeoPosition[{41.28079`,1.48789`}],"Calafell"->GeoPosition[{41.200356`,1.569347`}],"Cunit"->GeoPosition[{41.197559`,1.634533`}],"Llorenç del Penedès"->GeoPosition[{41.28197`,1.55374`}],"El Montmell"->GeoPosition[{41.31535`,1.45376`}],"Sant Jaume dels Domenys"->GeoPosition[{41.29986`,1.55958`}],"Santa Oliva"->GeoPosition[{41.25335`,1.55224`}],"El Vendrell"->GeoPosition[{41.220077`,1.534846`}],"Badalona"->GeoPosition[{41.43333333`,2.23333333`}],"Barcelona"->GeoPosition[{41.3825`,2.17694444`}],"L'Hospitalet de Llobregat"->GeoPosition[{41.35888889`,2.09916667`}],"Sant Adrià del Besòs"->GeoPosition[{41.4304832`,2.2182775`}],"Santa Coloma de Gramenet"->GeoPosition[{41.45388889`,2.21111111`}],"Alp"->GeoPosition[{42.37527778`,1.88861111`}],"Guils de Cerdanya"->GeoPosition[{42.45055556`,1.87972222`}],"Isòvol"->GeoPosition[{42.39944444`,1.83916667`}],"Puigcerdà"->GeoPosition[{42.43166667`,1.92833333`}],"Bellver de Cerdanya"->GeoPosition[{42.37085`,1.77804`}],"Lles de Cerdanya"->GeoPosition[{42.390343`,1.687296`}],
"Cubelles"->GeoPosition[{41.22`,1.68`}],
"Olivella"->GeoPosition[{41.310415`,1.810898`}],"Sant Pere de Ribes"->GeoPosition[{41.259195`,1.772998`}],"Sitges"->GeoPosition[{41.23388889`,1.80416667`}],"Vilanova i la Geltrú"->GeoPosition[{41.224277`,1.725905`}],"l'Albagés"->GeoPosition[{41.45055556`,0.74027778`}],"Arbeca"->GeoPosition[{41.54166944`,0.92369722`}],"Bovera"->GeoPosition[{41.32833333`,0.64`}],"Les Borges Blanques"->GeoPosition[{41.51944444`,0.86833333`}],"Castelldans"->GeoPosition[{41.50027778`,0.76694444`}],"Cervià de les Garrigues"->GeoPosition[{41.42694444`,0.86166667`}],"El Cogul"->GeoPosition[{41.467009`,0.689661`}],"Fulleda"->GeoPosition[{41.465`,1.02527778`}],"La Granadella"->GeoPosition[{41.35694444`,0.66638889`}],"Juncosa"->GeoPosition[{41.37091667`,0.77533333`}],"Juneda"->GeoPosition[{41.549157`,0.825071`}],"Els Omellons"->GeoPosition[{41.50361111`,0.96138889`}],"La Pobla de Cérvoles"->GeoPosition[{41.36916667`,0.91638889`}],"Bellaguarda"->GeoPosition[{41.33944444`,0.73694444`}],"Puiggròs"->GeoPosition[{41.55222222`,0.89`}],"El Vilosell"->GeoPosition[{41.38388889`,0.94666667`}],"Vinaixa"->GeoPosition[{41.43027778`,0.97611111`}],"Besalú"->GeoPosition[{42.198926`,2.698557`}],"Castellfollit de la Roca"->GeoPosition[{42.22138889`,2.55083333`}],"Maià de Montcal"->GeoPosition[{42.2222272`,2.7424313`}],
"Mieres"->GeoPosition[{42.1244,2.6401}],
"Montagut i Oix"->GeoPosition[{42.231314`,2.595494`}],"Olot"->GeoPosition[{42.1821928`,2.4890165`}],"Les Planes d'Hostoles"->GeoPosition[{42.0565983`,2.5384283`}],"Les Preses"->GeoPosition[{42.14638889`,2.45944444`}],"Riudaura"->GeoPosition[{42.1887348`,2.4093804`}],"Sant Feliu de Pallerols"->GeoPosition[{42.0758164`,2.5078037`}],"Sant Jaume de Llierca"->GeoPosition[{42.2119833`,2.6074259`}],"Santa Pau"->GeoPosition[{42.14583333`,2.57222222`}],"Tortellà"->GeoPosition[{42.23527778`,2.63138889`}],"La Vall de Bianya"->GeoPosition[{42.24133405`,2.43261148`}],"Aiguaviva"->GeoPosition[{41.938536`,2.76235`}],"Bescanó"->GeoPosition[{41.964851`,2.737005`}],"Bordils"->GeoPosition[{42.04555556`,2.91333333`}],"Campllong"->GeoPosition[{41.89555556`,2.83194444`}],"Canet d'Adri"->GeoPosition[{42.03340194`,2.73712389`}],"Cassà de la Selva"->GeoPosition[{41.88934`,2.874249`}],"Celrà"->GeoPosition[{42.02472222`,2.87888889`}],"Cervià de Ter"->GeoPosition[{42.06916667`,2.91166667`}],"Flaçà"->GeoPosition[{42.05055556`,2.95555556`}],"Fornells de la Selva"->GeoPosition[{41.93611111`,2.81305556`}],"Girona"->GeoPosition[{41.98333333`,2.81666667`}],"Llagostera"->GeoPosition[{41.82916667`,2.89333333`}],"Llambilles"->GeoPosition[{41.920704`,2.858867`}],"Madremanya"->GeoPosition[{41.989912`,2.957186`}],"Quart"->GeoPosition[{41.939894`,2.83987`}],"Salt"->GeoPosition[{41.97611111`,2.78805556`}],"Sant Andreu Salou"->GeoPosition[{41.875`,2.82666667`}],"Sant Gregori"->GeoPosition[{41.989274`,2.759685`}],"Sant Jordi Desvalls"->GeoPosition[{42.07305556`,2.95472222`}],"Sant Joan de Mollet"->GeoPosition[{42.046074`,2.941929`}],"Sant Julià de Ramis"->GeoPosition[{42.034698`,2.839403`}],"Sant Martí de Llémena"->GeoPosition[{42.03805556`,2.64888889`}],"Sant Martí Vell"->GeoPosition[{42.02194444`,2.93166667`}],"Sarrià de Ter"->GeoPosition[{42.01805556`,2.82611111`}],"Vilablareix"->GeoPosition[{41.952465`,2.793695`}],"Alella"->GeoPosition[{41.49527778`,2.29583333`}],"Arenys de Mar"->GeoPosition[{41.58194444`,2.55027778`}],"Arenys de Munt"->GeoPosition[{41.61277778`,2.54027778`}],"Argentona"->GeoPosition[{41.55583333`,2.4025`}],"Cabrera de Mar"->GeoPosition[{41.5275`,2.39555556`}],"Cabrils"->GeoPosition[{41.52833333`,2.36916667`}],"Caldes d'Estrac"->GeoPosition[{41.57194444`,2.52861111`}],"Calella"->GeoPosition[{41.61694444`,2.66416667`}],"Canet de Mar"->GeoPosition[{41.59111111`,2.58277778`}],"Dosrius"->GeoPosition[{41.59416667`,2.40722222`}],"Malgrat de Mar"->GeoPosition[{41.64555556`,2.74277778`}],"El Masnou"->GeoPosition[{41.48166667`,2.31777778`}],"Mataró"->GeoPosition[{41.53333333`,2.45`}],"Montgat"->GeoPosition[{41.4666983`,2.2789654`}],"Palafolls"->GeoPosition[{41.66916667`,2.75055556`}],"Pineda de Mar"->GeoPosition[{41.62722222`,2.69111111`}],"Premià de Mar"->GeoPosition[{41.4920085`,2.3620172`}],"Sant Iscle de Vallalta"->GeoPosition[{41.62472222`,2.57027778`}],"Sant Andreu de Llavaneres"->GeoPosition[{41.57333333`,2.48277778`}],"Sant Cebrià de Vallalta"->GeoPosition[{41.62138889`,2.60055556`}],"Vilassar de Dalt"->GeoPosition[{41.5163595`,2.3592879`}],"Vilassar de Mar"->GeoPosition[{41.50527778`,2.39277778`}],"Premià de Dalt"->GeoPosition[{41.50805556`,2.34583333`}],"Sant Pol de Mar"->GeoPosition[{41.60333333`,2.62444444`}],"Santa Susanna"->GeoPosition[{41.63666667`,2.70805556`}],"Sant Vicenç de Montalt"->GeoPosition[{41.58027778`,2.50861111`}],"Teià"->GeoPosition[{41.49861111`,2.32416667`}],"Tordera"->GeoPosition[{41.70083333`,2.72`}],"Àger"->GeoPosition[{41.999751`,0.762755`}],"Algerri"->GeoPosition[{41.8175`,0.63944444`}],"Alòs de Balaguer"->GeoPosition[{41.91361111`,0.96222222`}],"Artesa de Segre"->GeoPosition[{41.89539`,1.045428`}],"La Sentiu de Sió"->GeoPosition[{41.804734`,0.87853`}],"Les Avellanes i Santa Linya"->GeoPosition[{41.907896`,0.763885`}],"Balaguer"->GeoPosition[{41.790401`,0.805573`}],"Bellcaire d'Urgell"->GeoPosition[{41.759084`,0.90506`}],"Castelló de Farfanya"->GeoPosition[{41.82111111`,0.72916667`}],"Cubells"->GeoPosition[{41.85361111`,0.95972222`}],"Ivars de Noguera"->GeoPosition[{41.85194444`,0.58777778`}],"Montgai"->GeoPosition[{41.800159`,0.961291`}],"Os de Balaguer"->GeoPosition[{41.871658`,0.718611`}],"Térmens"->GeoPosition[{41.71944444`,0.76166667`}],"Torrelameu"->GeoPosition[{41.70666667`,0.70305556`}],"Vallfogona de Balaguer"->GeoPosition[{41.75388889`,0.81555556`}],"Balenyà"->GeoPosition[{41.812907`,2.234847`}],"Calldetenes"->GeoPosition[{41.9275`,2.28555556`}],"Folgueroles"->GeoPosition[{41.940116`,2.316349`}],"Gurb"->GeoPosition[{41.9575`,2.23388889`}],"Lluçà"->GeoPosition[{42.07`,2.07444444`}],"Manlleu"->GeoPosition[{42,2.28361111`}],"Les Masies de Roda"->GeoPosition[{41.990059`,2.306718`}],"Les Masies de Voltregà"->GeoPosition[{42.02416667`,2.23611111`}],"Muntanyola"->GeoPosition[{41.88027778`,2.17972222`}],"Montesquiu"->GeoPosition[{42.11111111`,2.21055556`}],"Olost"->GeoPosition[{41.98777778`,2.09694444`}],"Orís"->GeoPosition[{42.06`,2.24027778`}],"Oristà"->GeoPosition[{41.93472222`,2.06194444`}],"Prats de Lluçanès"->GeoPosition[{42.01083333`,2.03083333`}],"Roda de Ter"->GeoPosition[{41.980119`,2.309109`}],"Sant Bartomeu del Grau"->GeoPosition[{41.98555556`,2.17194444`}],"Sant Boi de Lluçanès"->GeoPosition[{42.05972222`,2.1525`}],"Sant Hipòlit de Voltregà"->GeoPosition[{42.01722222`,2.23888889`}],"Sant Julià de Vilatorta"->GeoPosition[{41.922975`,2.325071`}],"Sant Martí de Centelles"->GeoPosition[{41.76527778`,2.25166667`}],"Sant Pere de Torelló"->GeoPosition[{42.074782`,2.296763`}],"Sant Quirze de Besora"->GeoPosition[{42.10333333`,2.22027778`}],"Santa Eugènia de Berga"->GeoPosition[{41.90222222`,2.28416667`}],"Santa Eulàlia de Riuprimer"->GeoPosition[{41.91277778`,2.18972222`}],"L'Esquirol"->GeoPosition[{42.034935`,2.369022`}],"Sant Vicenç de Torelló"->GeoPosition[{42.06222222`,2.27277778`}],"Taradell"->GeoPosition[{41.873716`,2.287395`}],"Torelló"->GeoPosition[{42.049229`,2.262913`}],"Vic"->GeoPosition[{41.930379`,2.254575`}],"Vilanova de Sau"->GeoPosition[{41.94888889`,2.38583333`}],"Rupit i Pruit"->GeoPosition[{42.02583333`,2.46694444`}],"Espinelves"->GeoPosition[{41.87055556`,2.41833333`}],"Viladrau"->GeoPosition[{41.847714`,2.390339`}],"Barbens"->GeoPosition[{41.67972222`,1.01805556`}],"Bellvís"->GeoPosition[{41.69555556`,0.83277778`}],"Castellnou de Seana"->GeoPosition[{41.64972222`,0.97166667`}],"Fondarella"->GeoPosition[{41.63638889`,0.87472222`}],"Golmés"->GeoPosition[{41.63583333`,0.93194444`}],"Ivars d'Urgell"->GeoPosition[{41.6808072`,0.9859309`}],"Linyola"->GeoPosition[{41.71222222`,0.90555556`}],"Miralcamp"->GeoPosition[{41.60638889`,0.88138889`}],"Mollerussa"->GeoPosition[{41.63166667`,0.89611111`}],"El Palau d'Anglesola"->GeoPosition[{41.6525`,0.88333333`}],"El Poal"->GeoPosition[{41.68083333`,0.85722222`}],"Sidamon"->GeoPosition[{41.63111111`,0.83305556`}],"Torregrossa"->GeoPosition[{41.58166667`,0.83`}],"Vilanova de Bellpuig"->GeoPosition[{41.61555556`,0.965`}],"Banyoles"->GeoPosition[{42.11944444`,2.76638889`}],"Camós"->GeoPosition[{42.09444444`,2.76722222`}],"Cornellà del Terri"->GeoPosition[{42.09138889`,2.81777778`}],"Esponellà"->GeoPosition[{42.178925`,2.795061`}],"Fontcoberta"->GeoPosition[{42.14444444`,2.79111111`}],"Porqueres"->GeoPosition[{42.122077`,2.74799`}],"Sant Miquel de Campmajor"->GeoPosition[{42.13597`,2.679126`}],"Serinyà"->GeoPosition[{42.17027778`,2.74416667`}],"Vilademuls"->GeoPosition[{42.14055556`,2.89`}],"Bellmunt del Priorat"->GeoPosition[{41.16383`,0.76546`}],"Cabacés"->GeoPosition[{41.24741`,0.73356`}],"Capçanes"->GeoPosition[{41.10063`,0.78138`}],"Cornudella de Montsant"->GeoPosition[{41.2657`,0.90504`}],"Falset"->GeoPosition[{41.14619`,0.82008`}],"Marçà"->GeoPosition[{41.12666`,0.8008`}],"El Masroig"->GeoPosition[{41.12598`,0.73222`}],"La Morera de Montsant"->GeoPosition[{41.264976`,0.841747`}],"Poboleda"->GeoPosition[{41.23457`,0.84575`}],"Porrera"->GeoPosition[{41.189006`,0.85646`}],"Ulldemolins"->GeoPosition[{41.322596`,0.876363`}],"La Vilella Alta"->GeoPosition[{41.22543`,0.78023`}],"Ascó"->GeoPosition[{41.18078`,0.567236`}],"Benissanet"->GeoPosition[{41.0569`,0.63472`}],"Flix"->GeoPosition[{41.231043`,0.550137`}],"Ginestar"->GeoPosition[{41.04216`,0.6326`}],"Miravet"->GeoPosition[{41.03741`,0.59781`}],"Móra d'Ebre"->GeoPosition[{41.092981`,0.641158`}],"Móra la Nova"->GeoPosition[{41.10027778`,0.65083333`}],"La Palma d'Ebre"->GeoPosition[{41.282913`,0.665722`}],"Rasquera"->GeoPosition[{41.001507`,0.597515`}],"Tivissa"->GeoPosition[{41.0423`,0.73308`}],"La Torre de l'Espanyol"->GeoPosition[{41.19194`,0.62601`}],"Vinebre"->GeoPosition[{41.18381`,0.58989`}],"Campdevànol"->GeoPosition[{42.22583333`,2.16944444`}],"Camprodon"->GeoPosition[{42.311803`,2.364804`}],"Llanars"->GeoPosition[{42.32277778`,2.34527778`}],"Molló"->GeoPosition[{42.34944444`,2.40611111`}],"Ripoll"->GeoPosition[{42.201085`,2.190272`}],"Sant Joan de les Abadesses"->GeoPosition[{42.23611111`,2.28666667`}],"Sant Pau de Segúries"->GeoPosition[{42.26361111`,2.36666667`}],"Setcases"->GeoPosition[{42.374873`,2.301495`}],"Vilallonga de Ter"->GeoPosition[{42.331274`,2.311945`}],"Biosca"->GeoPosition[{41.84232778`,1.35885833`}],"Cervera"->GeoPosition[{41.6657`,1.271001`}],"Estaràs"->GeoPosition[{41.69169444`,1.37811667`}],"Guissona"->GeoPosition[{41.78467222`,1.28797222`}],"Ivorra"->GeoPosition[{41.77171111`,1.39542778`}],"Massoteres"->GeoPosition[{41.79764722`,1.31073889`}],"Les Oluges"->GeoPosition[{41.69725278`,1.31920556`}],"Sanaüja"->GeoPosition[{41.87617778`,1.31054167`}],"Sant Guim de Freixenet"->GeoPosition[{41.65559722`,1.41937778`}],"Sant Ramon"->GeoPosition[{41.725958`,1.362945`}],"Torà"->GeoPosition[{41.812943`,1.402873`}],"Ribera d'Ondara"->GeoPosition[{41.628022`,1.341887`}],"Fogars de Tordera"->GeoPosition[{41.72805556`,2.68111111`}],"Amer"->GeoPosition[{42.009218`,2.603015`}],"Arbúcies"->GeoPosition[{41.81777778`,2.51694444`}],"Blanes"->GeoPosition[{41.67694444`,2.79166667`}],
"Breda"->GeoPosition[{41.75`,2.57`}],
"Brunyola"->GeoPosition[{41.904513`,2.68418`}],"Caldes de Malavella"->GeoPosition[{41.838747`,2.808905`}],"Hostalric"->GeoPosition[{41.74805556`,2.63611111`}],"Lloret de Mar"->GeoPosition[{41.7`,2.833333`}],"Maçanet de la Selva"->GeoPosition[{41.777445`,2.730826`}],"Riells i Viabrea"->GeoPosition[{41.725013`,2.558212`}],"Riudarenes"->GeoPosition[{41.82388889`,2.7175`}],"Riudellots de la Selva"->GeoPosition[{41.89555556`,2.80638889`}],"Sant Feliu de Buixalleu"->GeoPosition[{41.79093`,2.586137`}],"Sant Hilari Sacalm"->GeoPosition[{41.878632`,2.507902`}],"Santa Coloma de Farners"->GeoPosition[{41.862402`,2.66536`}],"La Cellera de Ter"->GeoPosition[{41.968291`,2.620736`}],"Sils"->GeoPosition[{41.809423`,2.743542`}],"Tossa de Mar"->GeoPosition[{41.72055556`,2.93194444`}],"Vidreres"->GeoPosition[{41.788883`,2.779273`}],"Vilobí d'Onyar"->GeoPosition[{41.88888889`,2.7425`}],"Sant Julià del Llor i Bonmatí"->GeoPosition[{41.76361111`,2.66583333`}],"Olius"->GeoPosition[{41.977751`,1.554937`}],"Solsona"->GeoPosition[{41.994425`,1.517823`}],"Altafulla"->GeoPosition[{41.14333333`,1.37694444`}],"El Catllar"->GeoPosition[{41.17539`,1.32645`}],"Constantí"->GeoPosition[{41.153175`,1.21433`}],"Creixell"->GeoPosition[{41.16944444`,1.44222222`}],"El Morell"->GeoPosition[{41.192208`,1.208658`}],"Els Pallaresos"->GeoPosition[{41.17523`,1.269452`}],"Perafort"->GeoPosition[{41.191121`,1.255668`}],"La Pobla de Mafumet"->GeoPosition[{41.1865974`,1.2082805`}],"La Pobla de Montornès"->GeoPosition[{41.178862`,1.414518`}],"La Riera de Gaià"->GeoPosition[{41.164985`,1.361647`}],"Roda de Berà"->GeoPosition[{41.18565`,1.45682`}],"La Secuita"->GeoPosition[{41.203226`,1.279376`}],"Tarragona"->GeoPosition[{41.11868`,1.24532`}],"Torredembarra"->GeoPosition[{41.145668`,1.395671`}],"Vespella"->GeoPosition[{41.2054`,1.35945`}],"Vilallonga del Camp"->GeoPosition[{41.211467`,1.205855`}],"Vila-Seca"->GeoPosition[{41.11098`,1.144988`}],"Salou"->GeoPosition[{41.07964`,1.13163`}],"La Canonja"->GeoPosition[{41.11914`,1.18297`}],"Arnes"->GeoPosition[{40.91073`,0.261`}],"Caseres"->GeoPosition[{41.03955`,0.25054`}],"La Fatarella"->GeoPosition[{41.16228`,0.47337`}],"Gandesa"->GeoPosition[{41.052071`,0.438887`}],"Horta de Sant Joan"->GeoPosition[{40.955641`,0.315115`}],"La Pobla de Massaluca"->GeoPosition[{41.18054`,0.35364`}],"Agramunt"->GeoPosition[{41.786289`,1.096388`}],"Anglesola"->GeoPosition[{41.658977`,1.081367`}],"Belianes"->GeoPosition[{41.5625`,1.01805556`}],"Bellpuig"->GeoPosition[{41.62666667`,1.01333333`}],"Castellserà"->GeoPosition[{41.74833333`,0.98916667`}],"Ciutadilla"->GeoPosition[{41.56277778`,1.14138889`}],"La Fuliola"->GeoPosition[{41.71527778`,1.01916667`}],"Guimerà"->GeoPosition[{41.564537`,1.185395`}],"Els Omells de na Gaia"->GeoPosition[{41.50222222`,1.07694444`}],"Puigverd d'Agramunt"->GeoPosition[{41.77972222`,1.12333333`}],"Tàrrega"->GeoPosition[{41.64638889`,1.13944444`}],"Tornabous"->GeoPosition[{41.70305556`,1.05555556`}],"Verdú"->GeoPosition[{41.61277778`,1.14444444`}],"Vilagrassa"->GeoPosition[{41.65027778`,1.10666667`}],"Sant Martí de Riucorb"->GeoPosition[{41.56027778`,1.05527778`}],"Naut Aran"->GeoPosition[{42.70916667`,0.90277778`}],"Es Bòrdes"->GeoPosition[{42.73972222`,0.72083333`}],"Bossòst"->GeoPosition[{42.7875`,0.69361111`}],"Les"->GeoPosition[{42.81027`,0.70991`}],"Vielha e Mijaran"->GeoPosition[{42.735`,0.79527778`}],"Vilamòs"->GeoPosition[{42.74944444`,0.7275`}],"Castellar del Vallès"->GeoPosition[{41.61853889`,2.08783889`}],"Castellbisbal"->GeoPosition[{41.47666667`,1.98222222`}],"Gallifa"->GeoPosition[{41.69416667`,2.11555556`}],"Matadepera"->GeoPosition[{41.60361111`,2.02444444`}],"Montcada i Reixac"->GeoPosition[{41.486653`,2.187913`}],"Polinyà"->GeoPosition[{41.557465`,2.156197`}],"Rellinars"->GeoPosition[{41.6375`,1.91083333`}],"Ripollet"->GeoPosition[{41.496514`,2.153427`}],"Sabadell"->GeoPosition[{41.54833333`,2.1075`}],"Sant Cugat del Vallès"->GeoPosition[{41.473538`,2.085244`}],"Sant Llorenç Savall"->GeoPosition[{41.678874`,2.058636`}],"Sant Quirze del Vallès"->GeoPosition[{41.530143`,2.0820052`}],"Barberà del Vallès"->GeoPosition[{41.51638889`,2.12444444`}],"Cerdanyola del Vallès"->GeoPosition[{41.49194444`,2.13888889`}],"Sentmenat"->GeoPosition[{41.608638`,2.135767`}],"Terrassa"->GeoPosition[{41.56111111`,2.00805556`}],"Ullastrell"->GeoPosition[{41.52631`,1.95866`}],"Vacarisses"->GeoPosition[{41.60633`,1.918199`}],"Viladecavalls"->GeoPosition[{41.55777778`,1.95583333`}],"Badia del Vallès"->GeoPosition[{41.51055556`,2.11694444`}],"L'Ametlla del Vallès"->GeoPosition[{41.668103`,2.260682`}],"Aiguafreda"->GeoPosition[{41.768111`,2.251498`}],"Bigues i Riells"->GeoPosition[{41.67861111`,2.22361111`}],"Caldes de Montbui"->GeoPosition[{41.63277778`,2.1675`}],"Campins"->GeoPosition[{41.72638889`,2.465`}],"Canovelles"->GeoPosition[{41.617592`,2.281373`}],"Cànoves i Samalús"->GeoPosition[{41.694019`,2.353008`}],"Cardedeu"->GeoPosition[{41.64055556`,2.35944444`}],"Fogars de Montclús"->GeoPosition[{41.72861111`,2.44444444`}],"Les Franqueses del Vallès"->GeoPosition[{41.636418`,2.296294`}],"La Garriga"->GeoPosition[{41.68038889`,2.28333333`}],"Granollers"->GeoPosition[{41.608333`,2.288889`}],"Gualba"->GeoPosition[{41.73222222`,2.50472222`}],"La Llagosta"->GeoPosition[{41.51555556`,2.19277778`}],"Llinars del Vallès"->GeoPosition[{41.64055556`,2.40222222`}],"Lliçà d'Amunt"->GeoPosition[{41.6104867`,2.2397066`}],"Lliçà de Vall"->GeoPosition[{41.59361111`,2.24305556`}],"Martorelles"->GeoPosition[{41.527921`,2.237507`}],"Mollet del Vallès"->GeoPosition[{41.535572`,2.210705`}],"Figaró-Montmany"->GeoPosition[{41.72277778`,2.275`}],"Montmeló"->GeoPosition[{41.55472222`,2.25`}],"Montornès del Vallès"->GeoPosition[{41.544369`,2.267033`}],"Parets del Vallès"->GeoPosition[{41.573274`,2.233678`}],"La Roca del Vallès"->GeoPosition[{41.582652`,2.324701`}],"Sant Antoni de Vilamajor"->GeoPosition[{41.672559`,2.399991`}],"Sant Celoni"->GeoPosition[{41.689515`,2.489678`}],"Sant Esteve de Palautordera"->GeoPosition[{41.706145`,2.43192`}],"Sant Fost de Campsentelles"->GeoPosition[{41.50611111`,2.24`}],"Sant Feliu de Codines"->GeoPosition[{41.6885036`,2.1646769`}],"Sant Pere de Vilamajor"->GeoPosition[{41.683393`,2.392953`}],"Santa Eulàlia de Ronçana"->GeoPosition[{41.65305556`,2.22611111`}],"Santa Maria de Martorelles"->GeoPosition[{41.52138889`,2.255`}],"Santa Maria de Palautordera"->GeoPosition[{41.69527778`,2.44583333`}],"Vallgorguina"->GeoPosition[{41.647871`,2.51037`}],"Vallromanes"->GeoPosition[{41.531841`,2.29819`}],"Vilalba Sasserra"->GeoPosition[{41.65388889`,2.44222222`}],"Vilanova del Vallès"->GeoPosition[{41.55418`,2.288608`}],"Calders"->GeoPosition[{41.79055556`,1.98777778`}],"Castellterçol"->GeoPosition[{41.75194444`,2.1225`}],"Collsuspina"->GeoPosition[{41.82777778`,2.17611111`}],"L'Estany"->GeoPosition[{41.8682984`,2.1116329`}],"Monistrol de Calders"->GeoPosition[{41.75638`,2.01397`}],"Moià"->GeoPosition[{41.8130971`,2.0971277`}],"Santa Maria d'Oló"->GeoPosition[{41.8746556`,2.0348964`}],"Vallfogona de Riucorb"->GeoPosition[{41.56312`,1.23697`}],"Berga"->GeoPosition[{42.1`,1.84555556`}],"La Pobla de Segur"->GeoPosition[{42.2473665`,0.9672725`}],"Talarn"->GeoPosition[{42.185778`,0.900361`}],"Figueres"->GeoPosition[{42.26666667`,2.95`}],"Alcanar"->GeoPosition[{40.54301`,0.48082`}],"Alcarràs"->GeoPosition[{41.56383`,0.524069`}],"Lleida"->GeoPosition[{41.61666667`,0.63333333`}],"Alcoletge"->GeoPosition[{41.647384`,0.694155`}],"Ulldecona"->GeoPosition[{40.59805`,0.44816`}],"Saus Camallera i Llampaies"->GeoPosition[{42.1318736`,2.9808946`}],"Palamós"->GeoPosition[{41.84583333`,3.12888889`}],"Almacelles"->GeoPosition[{41.731689`,0.437057`}],"Almenar"->GeoPosition[{41.79861111`,0.56888889`}],"Godall"->GeoPosition[{40.6553486`,0.4693771`}],"Vilamalla"->GeoPosition[{42.2165982`,2.9708293`}],"Albons"->GeoPosition[{42.10861111`,3.08111111`}],"Sudanell"->GeoPosition[{41.55833333`,0.56805556`}],"Vilajuïga"->GeoPosition[{42.32805556`,3.09527778`}],"Sant Carles de la Ràpita"->GeoPosition[{40.620301`,0.592744`}],"Lladó"->GeoPosition[{42.24944444`,2.81444444`}],"Torroella de Montgrí"->GeoPosition[{42.04388889`,3.12861111`}],"Roses"->GeoPosition[{42.263333`,3.175`}],"Albatàrrec"->GeoPosition[{41.575`,0.60638889`}],"Alfarràs"->GeoPosition[{41.83277778`,0.57222222`}],"L'Espluga de Francolí"->GeoPosition[{41.3972`,1.1029`}],"Alpicat"->GeoPosition[{41.66805556`,0.55611111`}],"Salàs de Pallars"->GeoPosition[{42.21293056`,0.93105`}],"Sort"->GeoPosition[{42.410086`,1.128661`}],"Gavet de la Conca"->GeoPosition[{42.122928`,0.921086`}],"Amposta"->GeoPosition[{40.71055556`,0.58083333`}],"Alguaire"->GeoPosition[{41.736318`,0.58382`}],"Aitona"->GeoPosition[{41.4945`,0.459359`}],"Freginals"->GeoPosition[{40.67161`,0.51967`}],"Isona i Conca Dellà"->GeoPosition[{42.117294`,1.044253`}],"Palafrugell"->GeoPosition[{41.918182`,3.16302`}],"La Bisbal d'Empordà"->GeoPosition[{41.959012`,3.037783`}],"Castelló d'Empúries"->GeoPosition[{42.258222`,3.074669`}],"Ordis"->GeoPosition[{42.218701`,2.906741`}],"El Far d'Empordà"->GeoPosition[{42.25361111`,2.99638889`}],"Montblanc"->GeoPosition[{41.37640556`,1.16386944`}],"Bagà"->GeoPosition[{42.25472222`,1.86361111`}],"Sant Feliu de Guíxols"->GeoPosition[{41.780556`,3.030556`}],"Solivella"->GeoPosition[{41.456019`,1.177643`}],"Vilafant"->GeoPosition[{42.246755`,2.937935`}],"La Pera"->GeoPosition[{42.020386`,2.973441`}],"Llers"->GeoPosition[{42.29722222`,2.91333333`}],"Tremp"->GeoPosition[{42.16668`,0.89465`}],"Sarral"->GeoPosition[{41.44462`,1.24888`}],"La Galera"->GeoPosition[{40.68178`,0.46325`}],"Capmany"->GeoPosition[{42.37611111`,2.92138889`}],"Castell-Platja d'Aro"->GeoPosition[{41.81916667`,3.06833333`}],"Llançà"->GeoPosition[{42.36666667`,3.1525`}],"Cercs"->GeoPosition[{42.14805556`,1.86194444`}],"Torrefarrera"->GeoPosition[{41.675`,0.60805556`}],"Ventalló"->GeoPosition[{42.14883333`,3.02690278`}],"Rosselló"->GeoPosition[{41.6959`,0.596032`}],"Senterada"->GeoPosition[{42.324944`,0.937689`}],"L'Armentera"->GeoPosition[{42.17388889`,3.07611111`}],"L'Escala"->GeoPosition[{42.1135764`,3.1349656`}],"Garriguella"->GeoPosition[{42.34527778`,3.05777778`}],"Santa Cristina d'Aro"->GeoPosition[{41.813866`,2.997373`}],"Borrassà"->GeoPosition[{42.225`,2.92722222`}],"Sant Climent Sescebes"->GeoPosition[{42.37083333`,2.98111111`}],"Begur"->GeoPosition[{41.9541918`,3.2088349`}],"Conca de Dalt"->GeoPosition[{42.2496022`,0.96845574`}],"Cadaqués"->GeoPosition[{42.28861111`,3.27777778`}],"Soses"->GeoPosition[{41.535`,0.48777778`}],"Torroella de Fluvià"->GeoPosition[{42.17638889`,3.04166667`}],"Seròs"->GeoPosition[{41.46166667`,0.41194444`}],"Sant Pere Pescador"->GeoPosition[{42.1899836`,3.0837479`}],"Gironella"->GeoPosition[{42.0375`,1.88305556`}],"Esterri d'Àneu"->GeoPosition[{42.63`,1.12444444`}],"Els Alamús"->GeoPosition[{41.61777778`,0.74055556`}],"Avià"->GeoPosition[{42.07972222`,1.81833333`}],"Peralada"->GeoPosition[{42.3085047`,3.0089916`}],"La Sénia"->GeoPosition[{40.63356`,0.2853`}],"Gimenells i el Pla de la Font"->GeoPosition[{41.65361111`,0.39083333`}],"Santa Coloma de Queralt"->GeoPosition[{41.532435`,1.383852`}],"Puigverd de Lleida"->GeoPosition[{41.54555556`,0.73472222`}],"Santa Bàrbara"->GeoPosition[{40.714571`,0.492868`}],"Casserres"->GeoPosition[{42.015`,1.84333333`}],"Espolla"->GeoPosition[{42.39305556`,3.00194444`}],"Sant Julià de Cerdanyola"->GeoPosition[{42.22555556`,1.89388889`}],"Guardiola de Berguedà"->GeoPosition[{42.2333`,1.87926`}],"Bellcaire d'Empordà"->GeoPosition[{42.08083333`,3.09611111`}],"Corbins"->GeoPosition[{41.6905677`,0.6930804`}],"Alt Àneu"->GeoPosition[{42.63527778`,1.11111111`}],"Vilamaniscle"->GeoPosition[{42.37722222`,3.06888889`}],"Artesa de Lleida"->GeoPosition[{41.55472222`,0.70388889`}],"Benavent de Segrià"->GeoPosition[{41.6975`,0.63444444`}],"Espot"->GeoPosition[{42.57861111`,1.08805556`}],"La Jonquera"->GeoPosition[{42.41972222`,2.87527778`}],"Ullà"->GeoPosition[{42.0525`,3.10916667`}],"Borredà"->GeoPosition[{42.13805556`,1.99583333`}],"Rabós"->GeoPosition[{42.3787458`,3.0283472`}],"Cabanelles"->GeoPosition[{42.230503`,2.8199`}],"Maçanet de Cabrenys"->GeoPosition[{42.38861111`,2.75194444`}],"Vilanova de Segrià"->GeoPosition[{41.71388889`,0.61972222`}],"Colera"->GeoPosition[{42.40638889`,3.15444444`}],"Pont de Molins"->GeoPosition[{42.3148493`,2.9304359`}],"Pals"->GeoPosition[{41.97166667`,3.15`}],"Llardecans"->GeoPosition[{41.37611111`,0.55083333`}],"Avinyonet de Puigventós"->GeoPosition[{42.250456`,2.912017`}],"Bàscara"->GeoPosition[{42.16222222`,2.91111111`}],"El Port de la Selva"->GeoPosition[{42.3375`,3.20416667`}],"Sant Jaume d'Enveja"->GeoPosition[{40.70573`,0.71782`}],"Sant Miquel de Fluvià"->GeoPosition[{42.17722222`,2.99277778`}],"Maials"->GeoPosition[{41.36583333`,0.50527778`}],"Vilanova de la Barca"->GeoPosition[{41.69111111`,0.72861111`}],"Vilanova de Prades"->GeoPosition[{41.34783`,0.95667`}],"Cruïlles Monells i Sant Sadurní de l'Heura"->GeoPosition[{41.956395`,2.991304`}],"Corçà"->GeoPosition[{41.987216`,3.014582`}],"Vimbodí i Poblet"->GeoPosition[{41.40065`,1.04988`}],"Fortià"->GeoPosition[{42.245`,3.04`}],"Mas de Barberans"->GeoPosition[{40.73472222`,0.37333333`}],"Alins"->GeoPosition[{42.55055556`,1.31972222`}],"Vilabertran"->GeoPosition[{42.2826972`,2.9814591`}],"Rialp"->GeoPosition[{42.44583333`,1.13527778`}],"Vilopriu"->GeoPosition[{42.1075`,2.99444444`}],"La Guingueta d'Àneu"->GeoPosition[{42.595065`,1.13127694`}],"Saldes"->GeoPosition[{42.23138889`,1.73805556`}],"La Portella"->GeoPosition[{41.74111111`,0.64166667`}],"Masdenverge"->GeoPosition[{40.71462`,0.53126`}],"Vilanant"->GeoPosition[{42.254815`,2.889282`}],"Montmajor"->GeoPosition[{42.017752`,1.735373`}],"Vilaür"->GeoPosition[{42.145`,2.95694444`}],"La Granja d'Escarp"->GeoPosition[{41.418948`,0.352457`}],"Agullana"->GeoPosition[{42.39378333`,2.84667778`}],"Rocafort de Queralt"->GeoPosition[{41.4783`,1.28132`}],"Alcanó"->GeoPosition[{41.48277778`,0.61888889`}],"Torrefeta i florejacs"->GeoPosition[{41.754072`,1.27343`}],"Calonge i Sant Antoni"->GeoPosition[{41.8625`,3.076389`}],"Anglès"->GeoPosition[{41.95`,2.65`}],"Batea"->GeoPosition[{41.1`,0.32`}],"Bot"->GeoPosition[{41.`,0.38`}],"Cabanes"->GeoPosition[{42.3111`,2.97694`}],"Calaf"->GeoPosition[{41.730000000000004`,1.52`}],"Camarasa"->GeoPosition[{41.87`,0.88`}],"Canyelles"->GeoPosition[{41.2883`,1.72306`}],"Castellar de N'Hug"->GeoPosition[{41.62`,2.08`}],"Catellví de Rosanes"->GeoPosition[{41.45`,1.9000000000000001`}],"Centelles"->GeoPosition[{41.79746`,2.21902`}],"El Brull"->GeoPosition[{41.82`,2.32`}],"El Perelló"->GeoPosition[{40.87`,0.72`}],"Font-Rubí"->GeoPosition[{41.42068`,1.65004`}],"Ger"->GeoPosition[{42.4131`,1.84583`}],"La Floresta"->GeoPosition[{41.52`,0.92`}],"Malla"->GeoPosition[{41.88`,2.23`}],"Massanes"->GeoPosition[{41.7678`,2.6525`}],"Mont-Ras"->GeoPosition[{41.9`,3.15`}],"Montseny"->GeoPosition[{41.77`,2.4`}],"Navata"->GeoPosition[{42.22`,2.87`}],"Palau-Sator"->GeoPosition[{41.980000000000004`,3.12`}],"Palau-Solità i Plegamans"->GeoPosition[{41.6`,2.18`}],"Pau"->GeoPosition[{42.32`,3.12`}],"Pira"->GeoPosition[{41.42`,1.2`}],"Ponts"->GeoPosition[{41.92`,1.2`}],"Prades"->GeoPosition[{41.300000000000004`,0.98`}],"Puig-Reig"->GeoPosition[{41.97`,1.8800000000000001`}],"Riba-Roja d'Ebre"->GeoPosition[{41.25`,0.48333`}],"Rubí"->GeoPosition[{41.5`,2.0300000000000002`}],"Santa Perpétua de Mogoda"->GeoPosition[{41.54`,2.18`}],"Sant Joan Les Fonts"->GeoPosition[{42.22`,2.52`}],"Seva"->GeoPosition[{41.83`,2.2800000000000002`}],"Sora"->GeoPosition[{42.1144`,2.16083`}],"Talavera"->GeoPosition[{41.5842`,1.33917`}],"Tiana"->GeoPosition[{41.47`,2.27`}],"Tona"->GeoPosition[{41.85`,2.23`}],"Torrent"->GeoPosition[{41.95`,3.13`}],"Torres del Segre"->GeoPosition[{41.53`,0.52`}],"Vall-Llobrega"->GeoPosition[{41.88`,3.13`}],"Vila-Sacra"->GeoPosition[{42.27`,3.02`}],"Mortellà i Martinet"->GeoPosition[{42.3625`,1.696389`}],"Navès"->GeoPosition[{41.991714`,1.635019`}],"Bell-Lloc d'Urgell"->GeoPosition[{41.632778`,0.781389`}],"La Vall d'En Bas"->GeoPosition[{42.117813`,2.45884`}],"Palau-Saverdera"->GeoPosition[{42.3079`,3.1471`}],"Vila-Sana"->GeoPosition[{41.664167`,0.93`}]};

Checking GeoPositions

GeoGraphics[
 GeoMarker[DeleteDuplicates[genderDataCSV[[2 ;;, 5]]] /. cityloc]]

Catalonia municipalities

Creating the Dataset

rawdata=GatherBy[SortBy[Map[
{DateObject[#[[1]]],
#[[5]],#[[-3]],#[[-5]],#[[-1]]}&,
genderDataCSV[[2;;]]],First],#[[1;;2]]&];

datasetCAT = Dataset[Map[ <| "date" -> #[[1, 1]], "municipality" -> #[[1, 2]], "location" -> #[[1, 2]] /. cityloc, "covid" -> <| "negative" -> <| Entity["Gender",  "Male"] -> (pm = Select[#[[All, 3 ;;]], #[[1 ;; 2]] == {0, 0} &]; If[pm == {}, 0, Last[pm[[1]]]]), Entity["Gender", "Female"] -> (pf = Select[#[[All, 3 ;;]], #[[1 ;; 2]] == {0, 1} &]; If[pf == {}, 0, Last[pf[[1]]]])|>, "positive" -> <| Entity["Gender", "Male"] -> (nm = Select[#[[All, 3 ;;]], #[[1 ;; 2]] == {1, 0} &]; If[nm == {}, 0, Last[nm[[1]]]]), Entity["Gender", "Female"] -> (nf = Select[#[[All, 3 ;;]], #[[1 ;; 2]] == {1, 1} &]; If[nf == {}, 0, Last[nf[[1]]]])|> |> |> &, rawdata]]

dataset created by Bernat Espigule

Dataset Grouped By Date

bydate=datasetCAT[GroupBy["date"]];

Available dates

dates = Intersection[
  With[{first = 
     DateObject[{2020, 2, 28, 0, 0, 0.`}, "Instant", "Gregorian", 
      2.`]}, DateRange[first, Yesterday]],
  Normal[Keys[bydate]]]

Custom GeoMarker with male female gender icons

Tested Positive

covidP[cases_,op_]:=Graphics[{
EdgeForm[Directive[Thin,Black]],
Opacity[op],
LightRed,
Translate[Scale[First[Entity["Icon","MensRoom"]["Image"]],Log[1.0+ cases["positive",male    gender]]],
{Log[1.0+ cases["positive",male gender]]15/1.8,0}],
Opacity[op],
LightBlue,
Scale[First[Entity["Icon","WomensRoom"]["Image"]],Log[1.0+cases["positive",female   gender]]]}]

Tested Negative

covidN[cases_, op_] := Graphics[{
   EdgeForm[Directive[Thin, Black]],
   Opacity[op],
   LightRed,
   Translate[
    Scale[First[Entity["Icon", "MensRoom"]["Image"]], 
     Log[1.0 + cases["negative", Entity["Gender", "Male"]]]],
    {Log[1.0 + cases["negative", Entity["Gender", "Male"]]] 15/1.8, 
     0}],
   Opacity[op],
   LightBlue,
   Scale[First[Entity["Icon", "WomensRoom"]["Image"]], 
    Log[1.0 + cases["negative", Entity["Gender", "Female"]]]]}]

Custom legend

legend = Reverse@{<|"negative" -> <|Entity["Gender", "Male"] -> 500, Entity["Gender", "Female"] -> 500|>, "positive" -> <|Entity["Gender", "Male"] -> 500, Entity["Gender", "Female"] -> 500|>|>, <|"negative" -> <|Entity["Gender", "Male"] -> 50, Entity["Gender", "Female"] -> 50|>, "positive" -> <|Entity["Gender", "Male"] -> 50, Entity["Gender", "Female"] -> 50|>|>, <|"negative" -> <|Entity["Gender", "Male"] -> 5, Entity["Gender", "Female"] -> 5|>, "positive" -> <|Entity["Gender", "Male"] -> 5, Entity["Gender", "Female"] -> 5|>|>, <|"negative" -> <|Entity["Gender", "Male"] -> 1, Entity["Gender", "Female"] -> 1|>, "positive" -> <|Entity["Gender", "Male"] -> 1, Entity["Gender", "Female"] -> 1|>|>}

Map for Confirmed COVID-19 Cases in Catalonia

map[nday_] := 
 With[{catalonia = 
    Entity["AdministrativeDivision", {"Catalonia", "Spain"}]},
  GeoGraphics[{
    GeoStyling["ReliefMap",
     GeoStylingImageFunction -> (Darker[
         ColorNegate@ColorConvert[#1, "Grayscale"], .6] &)], 
    Polygon[catalonia],
    (* Previous days GeoMarkers *)
    Table[GeoMarker[#3,
        covidP[#4, .5],
        "Scale" -> Offset[20 Log[2.0 + Total[#4["positive"]]]],
        "Alignment" -> Bottom] & @@@ 
      Normal[Reverse@
        SortBy[bydate[#[dates[[i]]] &], 
         Total[#covid["positive"]] &]],
     {i, nday - 1}],
    (* GeoMarkers *)
    Tooltip[
       GeoMarker[#3,
        covidP[#4, .9],
        "Scale" -> Offset[20 Log[2.0 + Total[#4[\!\(\*
StyleBox[\"\\\"\",\nShowSpecialCharacters->False,\n\
ShowStringCharacters->True,\nNumberMarks->True]\)positive"]]]],
        "Alignment" -> Bottom],
       Column[{Style[#2, "Section"], 
         Style[Row[
           Reverse@
            Flatten[
             KeyValueMap[
               List, #4["positive"]] /. {Entity["Gender", "Male"] -> 
                "\[Mars]︎", 
               Entity["Gender", "Female"] -> "\[Venus]" ︎}]], 
          "Chapter"]}, Alignment -> Center]]
      & @@@ 
     Normal[Reverse@
       SortBy[bydate[#[dates[[nday]]] &], 
        Total[#covid["positive"]] &]],
    (* Legend *)
    MapIndexed[{
       GeoMarker[GeoPosition[{40.65, 1.6 + .37 First[#2]}],
        covidP[#1],
        "Scale" -> Offset[20 Log[1.0 + Total[#1[\!\(\*
StyleBox[\"\\\"\",\nShowSpecialCharacters->False,\n\
ShowStringCharacters->True,\nNumberMarks->True]\)positive"]]]],
        "Alignment" -> Bottom],
       EdgeForm[Directive[Thin, Black]],
       Inset[Style[ToString[Total[#1[\!\(\*
StyleBox[\"\\\"\",\nShowSpecialCharacters->False,\n\
ShowStringCharacters->True,\nNumberMarks->True]\)positive"]]], 
         LightGray, Bold, 16],
        GeoPosition[{40.62, 1.6 + .37 First[#2]}]]} &,
     legend],
    Inset[Column[{
       Style[
        "analisi.transparenciacatalunya.cat/resource/jj6z-iyrp.csv", 
        Gray, "Subsubsubsection"],
       Style["COVID-19 Cases in Catalonia", Gray, Bold, "Subtitle"],
       Style[StringDrop[DateString[dates[[nday]]], 4], LightGray, 
        Bold, "Subtitle"]}, Alignment -> Center],
     GeoPosition[{42.7, 2.2}]],
    Inset[
     Style["Open Data Govern de Catalunya     Powered by WOLFRAM     Designed by Bernat Espigulé     @bernatree ", Gray, 12],
     GeoPosition[{42.84, 2.15}]]},
   {GeoBackground ->
     GeoStyling["StreetMapNoLabels",
      GeoStylingImageFunction -> (ColorNegate@
          ColorConvert[#1, "Grayscale"] &)],
    GeoScaleBar -> 
     Placed[{"Metric", "Imperial"}, GeoPosition[{40.62, 1.}]],
    GeoRange -> {{42.9, 40.5}, {0.1, 3.5}},
    GeoRangePadding -> Full,
    ImageSize -> 800}]]

Evolution for the past 15 days

mapsList = Table[map[i], {i, 17, Length[dates]}]

15 days COVID-19 Catalonia

Interactive Map Using Tooltips

map[Length[dates]]

enter image description here

Available on Desktop: CommunityCOVID-19CasesCataloniaBEspigule.nb

COVID-19 Catalonia March 2020

POSTED BY: Bernat Espigulé

enter image description here -- you have earned Featured Contributor Badge enter image description here

Your exceptional post has been selected for our editorial column Staff Picks http://wolfr.am/StaffPicks and Your Profile is now distinguished by a Featured Contributor Badge and is displayed on the Featured Contributor Board. Thank you!

POSTED BY: Moderation Team
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract