![]() ![]() This is the prefered output as it can be loaded back in to this tool again. load a simple Google Sheet, hide hex labels, and remove hex borders gsheetid=1hqFqAyRp7JfHu7jmZK-tBtiU89B28rgfTKHofK16PMw&attribute=Date&labels=false&borders=false Exporting the map If you have data in a publicly-visible Google Sheet you can add the parameter gsheetid=1hqFqAyRp7JfHu7jmZK-tBtiU89B28rgfTKHofK16PMw (replace 1hqFqAyRp7JfHu7jmZK-tBtiU89B28rgfTKHofK16PMw with your Sheet ID) to the URL and the Builder will construct the CSV export URL for you e.g. keepmissing= can be set to true or false to show or not show hexes that aren't referred to in the data.labels= can be set to true or false to turn the hex labels on or off - turning them off can speed up rendering time for big maps.colourscale= is one of our named colour scales ( ).borders= can be set to true or false to turn the hex borders on or off.attribute= is the column heading for the column to use for the colour scale - we can cope with numeric valus and ISO8601 dates.Where you can replace with the URL of a CSV file and you can add the following properties: You can build your own links to this tool of the form: For instance, there is a CSV of US State data on Github which has state 2-letter codes so we can load it straight into the Builder and show US States coloured by admission number. That means you can use this tool as a simple visualisation tool for CSV files on the web too. If you have a CSV that appears to have a column with codes for one of those, the Builder will try to load an existing hex map layout for you and add the data to that. We already know about defined hex layouts for UK local authorities, UK Parliamentary constituencies, UK NUTS3 regions, UK Upper Tier Local Authorities, MSOAs, NHS Integrated Care Boards, and US States. Note that this tool is for creating layouts rather than fully interactive visualisations. When you have everything where you want it, save the output. When you select a hex you can optionally press "c" on the keyboard to select all the other hexes with the same colour - useful for moving a block of hexes. To move a hexagon click it to select it then click in an empty hex in the grid. You can optionally colour the hexagons by including a column headed colour. A column with the heading n or name will set the displayed name of the hex. You can specify the position of the hex using the column headings q and r. Other columns will be added as properties of each hex. ![]() The CSV should contain a column with the heading id that uniquely identifies each hex. You can either read in an existing HexJSON file or start creating your own hex cartogram from a CSV file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |