This guide walks you through how to create, configure, run, and download results from a Download Patrols Workflow in Ecoscope.

This workflow type is designed to export Patrol data from your connected EarthRanger data source. Results are available in CSV or Parquet format, making it easy to use the data in external tools or for further analysis.

This workflow type is available both on Ecoscope Web and on Ecoscope Desktop (v1.0.0 and newer). Salient differences, when applicable, are called out below. 

Results Dashboard

When a workflow runs successfully, the Results Screen May Display (depending on configuration):

• Context Panel: A summary of your workflow configuration, including the title, description, time range, and time zone used.
• Dashboard Tab:  described below
• Files Tab:  described below

Dashboard Tab

This tab is visually and functionally identical on Cloud and Desktop.

The Dashboard Tab May Display (depending on configuration):

• Patrols Map: A spatial view of Patrol trajectories plotted on a map, color-coded by the category selected during configuration (e.g., Patrol Subject).

Files Tab

This tab has subtle visual and behavioral differences on Cloud and Desktop. See below for details.

Ecoscope Web

The Dashboard Tab May Display (depending on configuration):

• List of Downloadable Files: A table list of downloadable files for the exported Patrol data. You can click on the download icon on any row to save that file to your computer.

Note that the download links on the cloud stay valid for 20 minutes (from when the Files tab loads) to keep your data secure. You're able to start the download at any point before the 20 minutes expire. If you stay on this screen for more than 20 minutes, you will see a button that asks you to Refresh the download links. If you refresh your browser while on the Files tab, the 20 minute timer restarts with new links for the same files. 

If your dashboard has multiple Views selectable from the Context Panel, then changing to a new view will update the Files tab to show you downloadable files associated with that View.

Ecoscope Desktop

The Dashboard Tab May Display (depending on configuration):

• Open Results Folder: A button at the top right of the dashboard to download your exported data files.
• List of Downloadable Files: A table list of downloadable files for the exported Patrol data. You can click on the download icon on any row to save that file to a folder of your choice.

Note that the download links on the desktop do not expire as the files already exist on your hard drive.

If your dashboard has multiple Views selectable from the Context Panel, then changing to a new view will update the Files tab to show you downloadable files associated with that View.

Before You Begin

This workflow is available on both Ecoscope Web and on Ecoscope Desktop. 

On Ecoscope Web, it is available by default on the workflow template library for all users.

On Ecoscope Desktop, it must be imported from the Workflow Template Catalog before it can be configured or run.
If you haven't done this yet, follow the steps in Adding Workflow Templates in Ecoscope Desktop to import the Download Patrols Workflow into your instance. Once the template has been added, return to this article to continue.

Configure New Workflow

To create a new workflow, navigate to Workflow Templates from the top navigation bar and select Download Patrols Workflow.

Workflow Details

This section allows you to name and describe your workflow so that it's easy to find and identify.

• Workflow Name: This must be unique. If you try to submit a name that has already been used, you'll receive a validation error.
• Workflow Description: This is optional. The description will be displayed on the results view to help you or your team remember the configuration context or purpose of the export.

Time Range

This section defines the time window of the data you want to export. The selected time range determines which Patrols will be pulled from your data source.

You will configure:

• Since – Start date and time
• Until – End date and time
• Timezone – Required to provide fidelity over precise time selection

Data Source

Select a data source from the dropdown. 

If only one data source is configured, it will be selected automatically and you will be shown the Workflow Configuration page.

Patrol and Event Types

Specify which Patrol Types and Event Types are included in the export.

Patrol Types
Select the Patrol Type(s) you want to download from the dropdown.

• Leave this section empty to download all patrol types.

Event Types
Select the Event Type(s) you want to download from the dropdown.

• Leave this section empty to download all event types.

Include events without a location
Events without coordinates (point or polygon) will still appear in your download.

Advanced Configurations (optional)

• Patrol Status – Choose to include only Patrols with a certain status. Leave empty to include Patrols of all statuses.
• Patrols Overlap Daterange – Choose whether to include Patrols that start or end outside your selected Time Range.

Filter Data (optional)

Narrow down your export using one or more of the following:

• Bounding box – Limit results to Patrols within a specific area.
• Exact coordinates – Filter to a precise location.
• Trajectory filter – Filter based on movement patterns.

Group Data (optional)

Use this configuration to split your Patrol tracks and events into separate views for reporting and mapping.

• Select + Add to create a group.
• Add as many groups as you need — each one is exported and mapped as its own dataset..

Refine Patrol Data (optional)

Reshape and organize your data before downloading it. This applies only to the downloaded files — not the generated map. Everything here lives under Advanced Configurations.

Remove Columns
Columns listed here will be left out of both the generated map and your download. If you're not sure which to remove, try running the workflow first to see all available columns.

Apply SQL Query
Write a SQL query to filter or transform your data. Leave blank to skip this step. Use df as the table name (e.g., SELECT * FROM df WHERE status = 'active'). Queries apply only to your downloaded files, not the generated map.

Patrol Track Download File Format

Choose the file format for your Patrol track download.

• CSV – Human-readable format, compatible with spreadsheet tools.
• Parquet – Compressed columnar format, ideal for large datasets and programmatic use.
• GPKG (GeoPackage) – An open, standards-based geospatial format compatible with GIS tools such as QGIS and ArcGIS.
• GeoParquet – A geospatial extension of Parquet, optimized for large spatial datasets with native geometry support.

Under Advanced Configurations, set a filename prefix — a name added to the beginning of your Patrol track output files. A unique ID is automatically added to the end to prevent duplicates.

Event Download File Format

Choose the file format for your event download.

• CSV – Human-readable format, compatible with spreadsheet tools.
• Parquet – Compressed columnar format, ideal for large datasets and programmatic use.

Under Advanced Configurations, set a filename prefix — a name added to the beginning of your event output files. A unique ID is automatically added to the end to prevent duplicates.

Trajectory Category

Differentiate tracks by color using the selected category.

• Category – Choose how tracks are colored in the map: Patrol Type, Patrol Status, Patrol Subject, or Patrol Serial Number. 

Generate Maps (optional)

Use this configuration to generate a spatial map of your Patrol tracks alongside the data file.

• Generate maps in dashboard is checked by default. Not recommended for large datasets.
• Under Advanced Configurations, set the map's base layers.

Uncheck this when:

• Your dataset is large
• You only need the data file, not a visual output
• You want to minimize processing time

Turning off map generation does not affect the completeness of the exported data. It will also leave the Dashboard tab empty.

Run the Workflow

After submission, you'll be returned to the My Workflows view. Your new workflow will appear in the list with:

• Status: Ready
• No values yet for Last Run Start or Last Run Duration
• A Run button will be available

Click Run to begin processing. The status will change to Running.

Note: Processing time depends on the data volume and output format. Most workflows complete within one minute. Some workflows may take up to 10 minutes for very large datasets.

If the workflow fails, it will show a Failed status. Refer to Known Errors and Solutions in case this happens to you.

View and Download Results

Once the workflow finishes successfully (status: Success), click on the workflow name to open the results view.

You can now:

• Download the exported file in your selected format (CSV or Parquet) from the Files tab
• Review the record count and export summary
• Explore the map panel showing Patrol tracks, if you did not enable Skip Map