In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Attributes), this format adds the format-specific attributes described in this topic.
Features read from a database consist of geometry and a series of attribute values. The feature type of each CartoDB feature is defined in CartoDB Writer: Format Parameters.
Features written to the database have the destination table as their feature type, and attributes as defined in .
CartoDB attributes cannot have names that contain non-ASCII characters; however, the attribute values support full UTF-8.
The CartoDB attribute types are listed below.
|
Field Type |
Contents |
|---|---|
|
string |
String fields store UTF-8 strings of unlimited length. |
| boolean |
Boolean fields store true/false data. Data read or written from and to such fields must always have a value of either true or false. FME represents Booleans as Yes and No for true and false respectively, so any logging within FME will reflect this. Round-tripped values will be written as true or false as expected. |
| date |
Datetime fields convert datetimes in CartoDB to FME datetime string format. YYYYMMDDHHmmSS (Year, Month, Day, Hour, Minute, Second) If a timezone is specified, then the offset from GMT is included at the end of the string in the format: [+/-]HH:mm (Plus or Minus, Hour, Minute) |
| number |
Number fields store double precision floating point values. All numeric types are stored as number fields in CartoDB. |
The CartoDB attribute type mapping is shown below.
| CartoDB Attribute Type | FME Attribute Type |
|---|---|
| string | fme_varchar(width) |
| string | fme_char(width) |
| string | fme_buffer |
| string | fme_char |
| number | fme_real64 |
| number | fme_decimal(width, decimal) |
| number | fme_int32 |
| number | fme_int64 |
| number | fme_uint64 |
| number | fme_int16 |
| number | fme_uint16 |
| number | fme_uint8 |
| number | fme_real32 |
| number | fme_uint32 |
| date | fme_datetime |
| date | fme_date |
| date | fme_time |
| boolean | fme_boolean |
Geometry
| cartodb_type | Description |
|---|---|
| wkb_none | FME Feature with no geometry |
| wkb_point | 2D Point feature |
| wkb_line | 2D Linear feature |
| wkb_polygon | 2D Simple polygon or donut feature |
| wkb_geometry_collection | 2D Feature with multiple geometries |
| wkb_multi_point | 2D Feature with multiple heterogeneous point geometries |
| wkb_multi_line | 2D Feature with multiple line geometries |
| wkb_multi_polygon | 2D Feature with multiple polygon geometries |
| wkb_geometry | All geometries allowed |
| wkb_unknown | All geometries allowed |