VERIFIED SOLUTION i
X

How to remove Dead Assets from an Oracle Spatial Layer in Confirm

UPDATED: August 24, 2017


To remove a batch of Dead Features from an Oracle Spatial layer, in Confirm®, do the following:
  • Export the layer in question to Tab format from Oracle Spatial (OnDemand clients will need to raise a Confirm Technical Support case for this).
  • Run a Data Source query on the Feature table in Confirm for the relevant Feature Group and limit End Date using <= Today.
  • Save the Data Source to Excel.
  • Import the Excel Spreadsheet (this creates a MiPro Table).
  • Load both the Map layer (e.g. StreetLighting) and the table (DeadAssets), created from the spreadsheet, into MiPro.
  • Use the Select tool to write the following query:
SELECT * FROM STREETLIGHTING, DEADASSETS WHERE STREETLIGHTING.CENTRAL_ASSET_ID = DEADASSETS.CENTRAL_ASSET_ID
  • This opens a new browser window in MIPro called QueryX and contains the Dead Central Asset IDs (CAIDs).
  • Click on the browser of Table STREETLIGHTING in MiPro.
  • Click Delete.

What you can do prior to all the above is note a CAID to be removed, find it in the original layer and then try again once you've deleted it (it shouldn't now find it).

Environment Details

Products affected: Confirm®
Product Feature: Mapping (MapXtreme in Confirm)

Downloads

  • No Downloads