Verify field type for synced fish_tracking_tags

[peterdesmet]

To reevaluate when metadata is more complete:

• [x] cartodb_id: number
• [x] the_geom: geometry
• [x] catch_latitude: number
• [x] catch_length: number
• [x] catch_location: string
• [x] catch_longitude: number
• [x] catch_weight: number
• [x] catched_at: date
• [x] durif_lifestage: string
• [x] is_active: string (cannot be cast to boolean)
• [x] is_ghost: string (cannot be cast to boolean)
• [x] pit_code: string
• [x] project: string
• [x] release_latitude: number
• [x] release_location: string
• [x] release_longitude: number
• [x] release_time: time without timezone
• [x] released_at: date
• [x] remarks: string
• [x] scientific_name: string
• [x] sex: string
• [x] tag_id: number
• [x] tag_type: string
• [x] created_at: date
• [x] updated_at: date

[peterdesmet]

Assigning to @karenrobberechts: we first need data for the unchecked fields before we can assess if the field type is detected correctly.

[peterdesmet]

Maybe is_ghost would be interpreted as boolean by CartoDB if other case was used (False or false) - I doubt it though - but Google Spreadsheet automatically transforms those to uppercase.

[peterdesmet]

Regarding is_ghost: https://github.com/CartoDB/cartodb/issues/1116

[peterdesmet]

All done and cast correctly (except booleans). Note that numbers cannot be formatted as 1,000.00, they have to be formatted as 1000.00.