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

Product Feature: Street Works

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.
UPDATED:  August 16, 2017