I have two tables (in CartoDB/PostGIS) that are from two tiger shapefiles that have the exact same attributes, just in different counties. I want to combine them in to a single table, just appending the data from one to the other. What is the SQL call to do that?
0
1
Presuming you have two datyasets with the same attributes:
test_points1
and test_points2
you can combine them like this:
CREATE TABLE combined AS(
SELECT id, city, geom FROM test_points1
UNION
SELECT id, city, geom FROM test_points2)
and the result is the combined table:
answered Feb 27 '14 at 13:14
-
1The UNION keyword will check to ensure that all records are unique (which is expensive). If you don't want then de-duped in the process, use UNION ALL instead. – Paul Ramsey Feb 27 '14 at 18:20
