Geographic data selector for historic regions (or adding regions into one geographic area)

%3CLINGO-SUB%20id%3D%22lingo-sub-1540911%22%20slang%3D%22en-US%22%3EGeographic%20data%20selector%20for%20historic%20regions%20(or%20adding%20regions%20into%20one%20geographic%20area)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540911%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20excel%20to%20map%20the%20number%20of%20farms%20in%202005%20per%20NUTS-2%20regions.%20However%2C%20I'm%20having%20troubles%20in%20finding%20the%20correct%20geographic%20location%20for%20each%20region%2C%20using%20data%20types%20-%20geography.%20For%20example%2C%20the%20region%20of%20Nord-pas-de-Calais%20in%20France.%20In%202005%2C%20this%20existed%20as%20one%20region%2C%20but%20since%202016%20it%20exists%20of%20the%20two%20subregions%20Nord%20and%20Pas%20de%20Calais%20(both%20NUTS3%20level).%20However%2C%20I%20only%20have%20data%20for%20the%20NUTS-2%20region%2C%20which%20are%2010%20farms.%20In%20the%20data%20selector%2C%20bing%20does%20not%20find%20the%20historic%20NUTS2%20Nord-pas-de-Calais%20region%2C%20but%20it%20does%20find%20the%20two%20NUTS3%20regions%20of%20Nord%20and%20Pas%20de%20Calais%2C%20which%20can%20then%20be%20mapped%20accordingly%2C%20if%20I%20can%20combine%20these%20two%20in%20one%20area%20on%20the%20map%2C%20displaying%2010%20farms.%20Is%20this%20possible%20and%20can%20anyone%20help%20me%20to%20a%20solution%3F%20I%20was%20thinking%20of%20some%20kind%20of%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1540911%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi,

 

I'm using excel to map the number of farms in 2005 per NUTS-2 regions. However, I'm having troubles in finding the correct geographic location for each region, using data types - geography. For example, the region of Nord-pas-de-Calais in France. In 2005, this existed as one region, but since 2016 it exists of the two subregions Nord and Pas de Calais (both NUTS3 level). However, I only have data for the NUTS-2 region, which are 10 farms. In the data selector, bing does not find the historic NUTS2 Nord-pas-de-Calais region, but it does find the two NUTS3 regions of Nord and Pas de Calais, which can then be mapped accordingly, if I can combine these two in one area on the map, displaying 10 farms. Is this possible and can anyone help me to a solution? I was thinking of some kind of formula?

 

Cheers!

0 Replies