0

Has anyone ever made a map on CARTO from an ical feed? Given that it uses a standard format which includes a location information, I envision that I can scrape the data into a CSV then geocode the location field. Looking for suggestions for how to attack it!

1 Answer 1

2

You would need to transform the ical feed into one of the formats that CARTO supports (CSV, xls, shapefile, KML, geojson, etc).

Then, once you have transformed the file into a supported format of CARTO, you can import the file to your CARTO account.

Then, once has been imported, you can use the geocoding analysis or the geocoding functions to geocode the location field.

3
  • 1
    That transform need is very usual, I wrote a blogpost on writing a middleware that does a transform for another format so it can be used as a sync table: geomaticblog.net/2016/12/26/…
    – Jorge Sanz
    Commented May 21, 2018 at 10:01
  • Thanks for the feedback. We decided to write a python script that reads the feed and parses into a CSV. The script runs daily to update the CSV, which is stored in a location that is updated to Carto by connecting it as an external service: carto.com/learn/guides/data-and-sql/sync-real-time-data/…
    – JMers
    Commented May 22, 2018 at 17:57
  • you have also this post on the topic from one of our engineers in CARTO ivanmalagon.github.io/blog/adding-data-to-a-carto-dataset if the answer is correct please mark it or add your solutions as a full answer so we can close this question, thanks!
    – Jorge Sanz
    Commented May 23, 2018 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.