Skip to main content
Skip table of contents

Spatial Report Viewer 📝

What is the Spatial Report Viewer?

The Spatial Report Viewer (SRV) is a read-only screen that houses all of the legal items and tracts under a single roof.

Why would a client use the Spatial Report Viewer?

The tool combines attributes from the Land module with the output from the GIS module to provide insight to both the Land and GIS Analysts on what has been mapped and what remains outstanding.

What Configurations apply when using the Spatial Report Viewer?

This is client and environment specific; please update for each client environment.

CODE
gis_sql:
  username: gas_plant
  password: veggie_petroleum
  database: surge_gis_project
  port: 1433
  host: sql3.we.local

gis_host: sql3.we.local
gis_database: surge_gis_project
gis_table_schema: dbo

How to setup Spatial Report Viewer in the system

The SRV is only configured and available if the client takes both Land and GIS. This is set up by DevOps, and an example ticket as provided below:

WEDEVOPS-4256

How does this concept impact/feed other areas in the application?

The SRV combines Land and GIS data to provide intel on what has been successfully mapped and what has not at both the legal item and tract levels.

For Land data, the SRV includes but is not limited to: legal_description_id, tract_id, agreement_id, legal description, tract status, legal acreage

For GIS data, the SRV displays: legal map status, tract map status, calculated GIS acreage

Alternative Method

An alternative method to leveraging the SRV is to use the database connection in ArcGIS Desktop. This is a less user friendly interface but still a powerful tool for the GIS Analyst (only GIS Analyst(s) have access to ArcGIS Desktop).

  1. Launch the VDI with ArcGIS Desktop.

  2. Drag and drop the legal_items table from the main database connection to the Table of Contents.

  3. In the Table of Contents, right-click on the legal_items table, select Open which opens the textual attributes.

  4. Right-click once more and select Properties.

  5. In the Definition Query tab, a definition query can be added to view which legal items have and have not been mapped.

  6. The example query below returns legal items that have a parent tract and have not been mapped: (map_status_id = 2 or map_status_id is NULL) and tract_id is not null

  7. Other modules than Land use the legal_items table, but the rows for these other modules will have null parent tract ids. This is why we need only the legal items where the tract_id is null.

Other items worth noting that would impact the process.

Known issues with the process

WEDEVOPS-7482

WEDEVOPS-7483

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.