Coping Tables

Topics: User Forum
May 29, 2007 at 5:09 PM
I have multiple tiger census files and I would like to merge them into one table. I have tried selecting the_geom asText but I get some errors on some of the rows. I have tried using asBinary but I get null when using geomfromwkb in the insert statement in my storedprocedure. Any help on doing this would be great. Thanks
Coordinator
May 29, 2007 at 9:33 PM
If target and source geometries have the same SRID and type (verify it in the ST.GEOMETRY_COLUMNS table), you should have no problem.

Anyway, in order to help you better, please always post the full exception message when you get one.

Best regards,
Ricardo Stuven.

May 30, 2007 at 11:22 AM
Sorry I was over thinking it. I was able to merge using:

INSERT into ZipCodePoly
(thegeom, ZCTA, NAME, LSAD, LSADTRANS)
SELECT thegeom, ZCTA, NAME, LSAD, LSADTRANS
FROM zt02;

Thanks