Skip to main content

Export query results

Save data in a standard format​

After creating and refining a query in the Data Explorer, you can export the results in a standard data format, enabling you to store or process the data in other software.

alt text
Note

To import data into Alloy, see Gateway.

Export the current query​

To export the results of the current query:

  1. In the Data Explorer, select Menu (bottom-right) and choose Export results .

  2. In the window that appears, select Export file type and choose one of the following:

    • CSV - a text file that stores data as comma-separated values. Widely compatible with most software.

    • SHP - a popular format for storing geographic locations. It can describe points, lines and polygons in geographic space, along with custom attribute data. To learn more, see Shapefile on Wikipedia.

alt text

  1. If CSV is chosen, select Export attribute header type and choose one of the following:

    • Name (default) - attributes will be labelled with their name, e.g. Installed Date

    • Code - attributes will be labelled with their code, e.g. attributes_assetsInstalledDate

  2. If the query fetches geometry data, select Coordinate system and choose one of the following:

  3. Select Save to begin the export. When the export is ready, your web browser will start downloading a zip file containing your exported data files.

Note

While exports typically process in minutes, queries involving lots of data can take significantly longer ⏳. Alloy will email you the download link when it's ready, so feel free to close your web browser and come back later!

Linked data​

If the exported query fetches values for any linked attributes, they will be stored in a separate CSV file (one per linked design/interface). Each linked CSV contains Predecessor data to help you reconstruct the relationships between the linked items.

For example, imagine a query that fetches street lights and their defects. For each parent Street Lights item, the query fetches any child items stored within their Defects attribute. For each stored Defects item, the query fetches the value of their Defect Number attribute.

If exported, the downloaded zip file will contain two CSV files: one for items of the queried Street Lights design and one for items of the linked Defects interface. Each item in the Defects CSV can be matched to the Item ID of its parent Street Lights item and vice versa.

Caution

Due to the limitations of the shapefile format, exporting to SHP will only store data for attributes on the queried design/interface. Any linked attribute data will be excluded!