VW_LOCATION merges Location data and Coordinate data into a single view to determine which coordinate system will be used for spatially representing data in reporting and third-party interfaces.
The VW_LOCATION toolbar is in the Coordinates section under the Graphics tab of the EQuIS Professional ribbon.
Additional fields are accessed through the drop-down to the left of the COORD_TYPE_CODE.
This view allows you to quickly access the DT_FACILITY.COORD_TYPE_CODE and DT_FACILITY.IDENTIFIER fields used to populate VW_LOCATION. The COORD_TYPE_CODE and IDENTIFIER columns define the join between DT_FACILITY and DT_COORDINATE. Changes to VW_LOCATION will automatically update corresponding columns in DT_FACILITY and update the VW_LOCATION view.
The VW_LOCATION view enables easy viewing and access to manage the coordinate settings, which affect the output from EQuIS for ArcGIS, EnviroInsite, and other mapping software interfaces and reports that depend upon VW_LOCATION.
The X_COORD and Y_COORD values in the drop-down should be set to match the units defined for COORD_TYPE_CODE and IDENTIFIER values for X_COORD, Y_COORD, and ELEV in DT_COORDINATE. All depths and elevations should be in the same units for best results.
These dropdowns will be used to convert those XYZ coordinates to a desired output COORD_UNIT and ELEV_UNIT in VW_LOCATION and other VW_* views. This will normalize all XYZ coordinate values to a common unit, even when individual rows in DT_COORDINATE, DT_LITHOLOGY, DT_WELL_SEGMENT, DT_WELL, DT_LOCATION have different *_unit fields.
All the third-party interfaces that use coordinate values benefit from these settings when doing exports, including ArcGIS.
Note: There need to be conversion factors in the RT_UNIT_CONVERSION_FACTOR table for this feature to work. |