This map is part of the Map and Data Centre Collections, and is available for physical viewing under the call number C33 D04. Explore the item in our Library Catalogue: Collection Permalink Publication Date: 1893 Publisher Location: Toronto, Ont. Publisher: Toronto Lithographing Co. Geographic Area: London (Ont.) Map Theme: Business enterprises Description: Hand-drawn, colour map of London Ontario with inset drawings of the building fronts of local companies. Physical Size: 94 x 69 cm

Film and Television industries tend to cluster in a very small number of places around the world, moreover, they appear to be rooted to these places. These locales tend to be very high cost, and thus, there must be a strong need, and benefit of such location patterns. A classic film and television 'cluster' is located in London, with its core in Soho. One of the first objectives of the research is to confirm these points. Beyond this basic mapping, the research seeks to examine the organisation of the film and television industries in London, and thus to understand how Soho fits into this picture. It uses the notion of the 'production chain' to conceptualise the linkage between different stages of the production process. A central point of this research is to investigate the sensitivity of firms in the Film and Television industry to both proximity and to the specifics of particular places. The notion of relationship between firms is explored in terms of directly traded, economic, relationships, as well as more informal and non-economic relationships. The research methods used in the research are twofold. First, we use commercial and industry directories to map the firms by location and activity. Second, we will carry out detailed face-to-face interviews with a sample of firms, numbering 60 in total, in the five clusters that we expect to find in the London region. These interviews will yield detailed information on the firms and the nature of their core activities and the character and nature of their interaction with other companies.

With this add in it is possible to create map templates from GIS files in KML format, and create choropleths with them.

Providing you have access to KML format map boundary files, it is possible to create your own quick and easy choropleth maps in Excel. The KML format files can be converted from 'shape' files. Many shape files are available to download for free from the web, including from Ordnance Survey and the London Datastore. Standard mapping packages such as QGIS (free to download) and ArcGIS can convert the files to KML format.

A sample of a KML file (London wards) can be downloaded from this page, so that users can easily test the tool out.

Macros must be enabled for the tool to function.

When creating the map using the Excel tool, the 'unique ID' should normally be the area code, the 'Name' should be the area name and then if required and there is additional data in the KML file, further 'data' fields can be added. These columns will appear below and to the right of the map. If not, data can be added later on next to the codes and names.

In the add-in version of the tool the final control, 'Scale (% window)' should not normally be changed. With the default value 0.5, the height of the map is set to be half the total size of the user's Excel window.

To run a choropleth, select the menu option 'Run Choropleth' to get this form.

To specify the colour ramp for the choropleth, the user needs to enter the number of boxes into which the range is to be divided, and the colours for the high and low ends of the range, which is done by selecting coloured option boxes as appropriate. If wished, hit the 'Swap' button to change which colours are for the different ends of the range. Then hit the 'Choropleth' button.

The default options for the colours of the ends of the choropleth colour range are saved in the add in, but different values can be selected but setting up a column range of up to twelve cells, anywhere in Excel, filled with the option colours wanted. Then use the 'Colour range' control to select this range, and hit apply, having selected high or low values as wished. The button 'Copy' sets up a sheet 'ColourRamp' in the active workbook with the default colours, which can just be extended or deleted with just a few cells, so saving the user time.

The add-in was developed entirely within the Excel VBA IDE by Tim Lund. He is kindly distributing the tool for free on the Datastore but suggests that users who find the tool useful make a donation to the Shelter charity. It is not intended to keep the actively maintained, but if any users or developers would like to add more features, email the author.

Acknowledgments

Calculation of Excel freeform shapes from latitudes and longitudes is done using calculations from the Ordnance Survey.