0

I have two tables each georeferenced in CartoDB with the same timestamps, can I merge the two and keep the georeferenced data so I have two sets of points but in one table?

  • Is this in PostGres/PostGis? If so, you can use a View I would think, or append both tables to a new table if it is static data – Mark Cupitt Oct 9 '14 at 5:46
1

I guess you want to append the data, but not merging it, am I right?

You can do this by applying the following SQL query in the CartoDB Editor:

INSERT INTO table1name (column1, column2, column3) SELECT column1, column2, column3 FROM table2name

This will insert all your rows from table 2 into table 1. Notice that you need to use conveniently the column names (order is important too, do not include cartodb_id!).

In case you were actually interested in merging both datasets, you can just do a column join using a column you may have in common and selecting the_geom from the dataset you want to conserve it, but from you message I think you're interested in the append option.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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