Just getting started with the CartoDB Way and have run up against first problem. Looks like I'm not alone.
We have a GeoJSON feed coming from a Fulcrum data collection app. We want to see current results of that collection on a map, so I have set up a GeoJSON feed from Fulcrum as a starting point.
Over in CartoDB, I create a table and provide the GeoJSON URL.
The data appears...all as strings, except for the_geom (thankfully).
I want to create a sort of "set and forget" transfom process so that the column types are always converted properly and made available to CartoDB as their correct data types.
What is the next step?