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.

  1. Create a new String field.
  2. Set the string field to a WKT (see here for some examples of WKThttp://en.wikipedia.org/wiki/Well-known_text).
    1. Using the Modified Javascript step to create the WKT
    2. NOTE: You must take precautions to ensure that the latitude and longitude are not null before attempting to do the conversion.
  3. Use the select tool to convert to a Geometry type. If your WKT was formatted properly, you should have no issues.
    1. 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.
  4. Use the Set SRS tool to set the SRS on the new Geometry. (EPSG 4326 is equivalent to WGS 84)