1

How to import .csv file to CartoDB using SQL, the data given below :

POINT | TOP_dm | BOTTOM_dm | X_RD | Y_RD

35AP7600 | 4418 | 4368 | 262053 | 467223

35AP7601 | 4267 | 4217 | 262000 | 467143

35AP7602 | 4358 | 4308 | 261780 | 467148

35AP7603 | 4209 | 4159 | 262098 | 467243

asked Jun 23, 2014 at 18:17

1 Answer 1

1

Using the SQL API

If it's dynamic data what you want to load with SQL, you should check CartoDB SQL API and do a script that INSERT your csv data on CartoDB.

Using the Dashboard

If it's static data you can just drag the file on your CartoDB dashboard 

https://your_account_name.cartodb.com/dashboard

Using the IMPORT API

There is also a very interesting post on the Import API that may be useful for you. The post includes a shell script to upload your files like this:

./cdb_import.sh <cdb_username> <api_key> <file_name>

Note: Take an account the disclaimer in the cdb_import.sh script. It may be outdated

answered Jun 24, 2014 at 9:14

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.