How to create a new geometry field using geoKettle
geoKettle does not include a separate component to create a geometry field from scratch; however it is possible to create one using type conversion and WKT (well known text) markup.
- Create a new String field.
- Set the string field to a WKT (see here for some examples of WKThttp://en.wikipedia.org/wiki/Well-known_text).
- Using the Modified Javascript step to create the WKT
- NOTE: You must take precautions to ensure that the latitude and longitude are not null before attempting to do the conversion.
- Use the select tool to convert to a Geometry type. If your WKT was formatted properly, you should have no issues.
- Make sure your data is NOT stored as binary-string. Version 3.2.0 of geokettle has a bug in it that does not handle this storage type at all.
- Use the Set SRS tool to set the SRS on the new Geometry. (EPSG 4326 is equivalent to WGS 84)