VERIFIED SOLUTION i
X

How to find the easting and northing coordinates for a Street Works notice in Confirm

UPDATED: August 16, 2017


The coordinates for a street works notice are stored in the 'coordinate_data' table.

You can write the following SQL to retrieve that coordinate data:

SELECT * FROM coordinate_data WHERE entity_type = 'SWN' AND entity_key like 'XXXXXXXX/%'

Here XXXXXXXX is the work_header_no of sw_header table.
 

Environment Details

Product Feature: Street Works

 

Downloads

  • No Downloads