Question

Schema data type overide

  • 11 September 2018
  • 2 replies
  • 0 views
oliver.morris
Rank
Badge +10

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
Rank
Userlevel 4

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
Rank
Badge +10

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

Reply


Community Stats

28,698
Posts
109,447
Replies
36,548
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.