DB Format

<< Click to Display Table of Contents >>

Navigation:  EDP > Home Ribbon > Open >

DB Format

The Professional EDP DB Format tool is used to load custom EQuIS Alive formats, based on existing Survey Types, for data entry in EDP. Before the DB Format tool can be used, Survey Types first need to be created and saved using the Alive Survey Definition Form. The DB Format tool can be used to convert coordinates from one type of coordinates to another. As the DB Format tool requires an active database connection, it is only available for use in Professional EDP. The ALIVE_EDGE format is included with the Professional installation and is required to use the DB Format tool.

 

Using DB Format in Professional EDP

1.Open EDP on the Home tab of Professional.  

2.Click on the DB Format button (located in the Open group on the Home tab).

3.Select the survey definition and click Open or Export. The format can be used to create/collect, edit, and load data for the associated Survey Type.

Select Open to open the format directly in EDP, allowing data to be loaded and processed directly.

Select Export to create an Alive Format File that can be used for data collection.

 

Converting Coordinates using DB Format  

 

The coordinate conversion occurs during the Create step in EDP by sending the coordinates to ArcGIS to do the conversion. After Create, DT_SPATIAL_EXTENT.REMARK will show information about the original coordinates if conversion succeeded; if the conversion failed, then the REMARK field will show an error messaging to explain why.

 

To use the coordinate conversion, the EQuIS6_GIS record needs to exist in the ST_CONFIG table along with either the edgeCoordConversion or edgeFacilityCoordConvert record. A global setting with a target coordinate type will override any facility-specific setting with the same target coordinate type.

 

EQuIS6_GIS

 

ST_CONFIG

VALUE

REMARK

VALID VALUES

CONFIG_SECTION

EQuIS6_GIS

Required


CONFIG_KEY

GeometryServerURL

Required


STRING_VALUE

https://utility.arcgisonline.com/ArcGIS/rest/services/Geometry/GeometryServer

Required


 

 

edgeCoordConversion

 

ST_CONFIG

VALUE

REMARK

VALID VALUES

CONFIG_SECTION

edgeCoordConversion

Required


CONFIG_KEY

global

Required


OBJECT_TYPE

coord_type

Required


OBJECT_VALUE

<Target coordinate type from RT_COORD_TYPE.COORD_TYPE_CODE. For this record in RT_COORD_TYPE, SRID must be populated.>

Required


STRING_VALUE

TRUE

Required


 

Remarks

This setting will apply the coordinate conversion to all facilities.

 

 

edgeFacilityCoordConvert

 

ST_CONFIG

VALUE

REMARK

VALID VALUES

CONFIG_SECTION

edgeFacilityCoordConvert

Required


CONFIG_KEY

<facility_id>

Required


OBJECT_TYPE

coord_type

Required


OBJECT_VALUE

<Target coordinate type from RT_COORD_TYPE.COORD_TYPE_CODE. For this record in RT_COORD_TYPE, SRID must be populated.>

Required


STRING_VALUE

TRUE

Required


 

Remarks

This setting will apply the coordinate conversion to only a specific facility.

 

 

Example
STCONFIG_AliveDBFormat