<< Click to Display Table of Contents >> Navigation:  EQuIS Library > Reports > Agents > Agent - Coordinate Updates Report

Report Agent Name: Agent - Coordinate Updates (example)

File Name: EarthSoft.Reports.Agent.CoordUpdates.dll

Dependencies: N/A

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: This report agent grants the ability to convert coordinate datasets via EQuIS Enterprise, rather than through formats, direct table edits, or the EQuIS Professional Coordinate Converter Form.

 

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. For use with EQuIS Enterprise, publish the report to the database. No additional installation steps are necessary.

 

Overview: This report allows users to select a facility and its configured coordinate system (i.e., the DT_FACILITY.COORD_TYPE_CODE and IDENTIFIER fields), and convert matching DT_COORDINATE table records to another coordinate system. If this conversion is valid (i.e., RT_COORD_TYPE.SRID is specified for both the source and target COORD_TYPE_CODEs), new rows will be inserted into the database and the report output will provide a summary of the new coordinate records.

 

The Coordinate Updates Agent only INSERTs, not UPDATEs or DELETEs, records into the database. If the source coordinate dataset for the selected FACILITY_ID includes records that have already been converted to the target COORD_TYPE_CODE, then those records will not be converted again unless the rows for that IDENTIFIER and target_coordinate_type_code parameter are removed. However, new records will be created in the source coordinate dataset for records that have been converted to the target_coordinate_type_code parameter (i.e., new coordinates).

 

Converted rows can be identified by the DT_COORDINATE.REMARK field, which summarizes the conversion parameters. For example, "Generated by converting (coord_type_code: LAT LONG, Identifier: PRIMARY) to (coord_type_code: UTM_17N, Identifier: PRIMARY).".

 

Example: FACILITY_ID 1 is configured with a COORD_TYPE_CODE of "LAT LONG" (i.e., DT_FACILITY.COORD_TYPE_CODE = "LAT LONG") and IDENTIFIER of "Primary". That COORD_TYPE_CODE has an SRID of 4326 specified in the RT_COORD_TYPE table.

•By selecting a target_coordinate_type_code parameter of "UTM_17N" (i.e., SRID = 26717, as specified in the RT_COORD_TYPE table), the report will create new coordinate records, converted to the selected target_coordinate_type_code parameter.

•These corresponding records will be created for all coordinate records from FACILITY_ID 1 with a COORD_TYPE_CODE of "LAT LONG" and IDENTIFIER of "Primary".

 

 

 

Tables: DT_FACILITY, DT_LOCATION, DT_COORDINATE, RT_COORD_TYPE, VW_LOCATION

 

 

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.