Skip to main content
Question

Schema data type overide

  • September 11, 2018
  • 2 replies
  • 2 views

oliver.morris
Contributor
Forum|alt.badge.img+12

Hi,

I have created a workbench which migrates data from WFS to spatialite. Only issue I am facing is that I use numeric data types (containing lat and long among other things), the data merges from many wfs into a few spatialite tables, the schema is the same but the precision on the data types differs.

As a result I get notices like this:

SPATIALITE writer: Existing feature type 'x' contains attribute 'longitude' of type 'real(20,10)' that does not match the schema attribute of type 'real(31,15)'. Attributes named 'longitude' on incoming features will be written to the existing feature type as type 'real(20,10)'

Is there a way I can override the schema so that I can set it to a larger precision and avoid this issue?

Thank you for your help in advance

 

2 replies

david_r
Celebrity
  • September 12, 2018

How did you generate the output feature type?

The best-practice solution would be to import the output feature type from your existing schema:

https://desktopmanualbasic.safe.com/DesktopBasic4Components/4.19.ImportWriterFeatureTypes.html


oliver.morris
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • September 12, 2018

Hi David, the output feature type is generated from wfs, the wfs features are chosen at runtime and therefore the schema and output writer are dynamic. I will look at

https://knowledge.safe.com/articles/1045/dynamic-workflow-tutorial-destination-schema-is-de.html

Hopefully I will be able to work something from this.

Thank you


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings