Using the Data Extract tool

Using the Data Extract tool

Overview

The Data Extract tool is designed to show you a list of map objects that are within another map object. This will help you answer questions such as:

  • Show me a list of all the Listed Buildings within my Council boundary.
  • Show me a list of all the addresses within 500m of a location.
  • Show me a list of all the SSSIs within an Ancient Woodland boundary.

It's essentially a cookie-cutter for map data.

Once it's returned the list you can export it to a CSV file (which can be opened in Excel or Notepad).

The Data Extract tool also has a Filter function which allows you to fine-tune your search before exporting.


Video



Method

  1. The first thing to do when performing a Data Extract is choose the Map Object that you want as your defining boundary (this is your cookie cutter shape). I can use any of the following:
    • An existing object in a Map Layer that you've created
    • An existing object in a Map Layer that's shared into your account (e.g. Ancient Woodland, Parish Boundaries, etc)
    • A temporary object that's been drawn using the Annotation tool
  2. Click on the object and select it from the list on the left-hand side if there are more than one map objects in the area.  Once it's selected it will highlight in blue.
  3. Click the three dots icon in the left-hand panel
  4. Click on Data Extract. This will open up a full-screen panel.
  5. Choose the Map Layer that you want to extract from the drop-down list in the top left. This list includes your Map Layers as well as ones shared into your account.
  6. Click Run. The results will appear in a list.
  7. Click Export. A file will be generated and will download to your computer.

Optionally, you can filter the data based on attributes within the Map Layer. For example, I might want to only return Listed Buildings that are Grade I. To filter a result:

  1. Choose a column from the filter drop-down
  2. Enter a value that you want to return
  3. Click Run

To close the tool, click Close.




    • Related Articles

    • Finding the UPRN of an address

      Overview UPRN stands for Unique Property Reference Number. It's a unique code assigned to every addressable property in Great Britain. It's commonly used to identify properties without having to list the whole address. UPRNs are used by Local ...
    • Using the MasterMap Export tool

      Overview This tool allows you to download layers stored in your account. You can export to a range of formats. This is useful for exporting information if you need to use it in other mapping software. Limitations In the current version of the tool ...
    • Asset Register Export

      Overview This tool allows you to export some or all of your asset register layers to a PDF or Excel report. PDF is the best option if you want to get a professional summary of your assets, along with an embedded map. Excel is the best option if you ...
    • Using Table View

      Overview The Table View (previously called 'List') allows you to see the contents of a Map layer in a spreadsheet-style view. If you have editing rights for the Map Layer you're viewing, you can edit the information from this view. Accessing Table ...
    • Using address data

      Overview Depending on your account you may have addressing data included. This data will come from either a national address database or your local authority. Video Video provided by Surrey Heath Borough Council