How can I copy geometry table from spatialite?

Question

I tried spatialite:

create table Twn_free_way as select * from Twn_road;

This works fine but I can not copy the complete table.

enter image description here

I cannot read your mind. Some more details will help me help you. — Ram, Apr 29 '14 at 13:39
I found SELECT RecoverGeometryColumn('Twn_free_way','GEOMETRY',4326,'POINT','XY') , AND in Qgis If You want trun CSV to sqlite ,You must to appropriate SRID in output menu. — user3513254, May 05 '14 at 08:47

score 0 · Accepted Answer · answered Apr 29 '14 at 13:50

0

A geometry column must be described in the geometry_columns metadata table.

To add this entry, use the AddGeometryColumn function:

SELECT AddGeometryColumn('tablename', 'MyGeoColumn', 1234, 'POINT');

answered Apr 29 '14 at 13:50

CL.

but I use Create table Twn_free_way as select， How can I update the colunm type to geomrtry，You can see my image thanks!! – user3513254 Apr 29 '14 at 14:18
Then use the appropriate values for the table/column names and SRID. – CL. Apr 29 '14 at 14:19
I had to use SELECT RecoverGeometryColumn(...), as mentioned bt user3513254 – Daniel Jul 07 '17 at 16:45

1 Answers1