Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page Properties
hiddentrue
idKB


ThemeMapping
Type

Export

Available from


...

We will use the existing Views in the Annotations schema and join to the layers table to retrieve the Layer Name as this is not held in the Views. This is easily achieved by using the Spatial Data Transformation Task in Studio Workflow. iShare requires tables that only contain one geometry type so we will create separate tables for Polygon, Line, and Point data but other GIS applications can support multiple geometry types so we will also create a Features table containing all of the data.

Tip
  • These steps cover exporting all Layers but you may only want to export one specific Layer. If this is the case then first find the Layer ID (scratch_id) from the annotations.layers table and then you can add it to the relevant select statements below.
  • Once you have exported the features from your Annotation Layer you would probably want to remove those features from the relevant Annotation Layer.

Create Annotation Polygons table

...