Timeline for Merging Multiple Tables into New Table in PostGIS
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 17, 2022 at 13:10 | history | edited | PolyGeo♦ | CC BY-SA 4.0 |
deleted 30 characters in body
|
| May 26, 2021 at 13:36 | comment | added | mnguyen | Thank you Micha, I tried the second option and it works nicely. I have a question: What does the last line mean? This one: SELECT Populate_Geometry_Columns('merged'::regclass); | |
| Jul 16, 2013 at 17:49 | history | edited | artwork21 | CC BY-SA 3.0 |
added 10 characters in body
|
| Jun 15, 2012 at 18:37 | vote | accept | Ryan Garnett | ||
| Jun 13, 2012 at 19:21 | comment | added | lynxlynxlynx | use 2 instead of 'XY' as that argument specifies the dimensions. | |
| Jun 13, 2012 at 18:51 | comment | added | Ryan Garnett | NOTICE: CREATE TABLE will create implicit sequence "pbear_pp_id_seq" for serial column "pbear_pp.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pbear_pp_pkey" for table "pbear_pp" ERROR: invalid input syntax for integer: "XY" | |
| Jun 13, 2012 at 18:49 | comment | added | Ryan Garnett | CREATE TABLE pbear_pp (id serial primary key, entityname varchar(40)); SELECT AddGeometryColumn('pbear_pp','geom','-1','polygon','XY'); INSERT INTO pbear_pp(entityname, geom) SELECT entityname, geom FROM nts250k.nts250k_043e_poly; INSERT INTO pbear_pp(entityname, geom) SELECT entityname, geom FROM nts250k.nts250k_043f_poly; ETC ETC... | |
| Jun 13, 2012 at 18:49 | comment | added | Ryan Garnett | I have tried and I am getting an error associated to the XY. I know I am putting in the wrong thing, as I am unsure as to what I should be using there. Here is my query and the output response. Any help would be great. | |
| Jun 13, 2012 at 16:46 | comment | added | Ryan Garnett | Thank you Micha, I will try this. Yes, all the tables have the same attribute and they are the same geometry type. Thanks again... | |
| Jun 13, 2012 at 16:37 | history | answered | Micha | CC BY-SA 3.0 |