3,628 reputation
424
bio website
location Colorado Springs, CO
age 35
visits member for 2 years
seen 13 hours ago

20h
comment Spatialite Table Difference in QGIS
Thank you @Matthias Kuhn, that worked!
20h
accepted Spatialite Table Difference in QGIS
1d
revised Spatialite Table Difference in QGIS
added 220 characters in body
1d
revised Spatialite Table Difference in QGIS
added 32 characters in body
1d
comment Import Shapefile into Existing Spatialite Table
Thank you Brad.
1d
comment Spatialite Table Difference in QGIS
Please see the revised update. I have tried this in spatialite-gui, as well as in QGIS DB Manager. Both methods have produced the same results; added and updated tables that can be viewed in QGIS DB Manager, Qspatialite and spatialite-gui, but not when the table is loaded into QGIS and the attribute table is opened. It is my belief that QGIS has an issues with columns that are added via a different means, other than in the QGIS attribute table. I have had this issue in other cases.
1d
revised Spatialite Table Difference in QGIS
added 707 characters in body
1d
comment Import Shapefile into Existing Spatialite Table
Thank you Brad, I wasn't sure if I needed to make a Virtual table, or if I could import (append) directly into my spatialite table from a shapefile, and limit the columns on the import.
1d
comment Spatialite Table Difference in QGIS
Brad I have added everything you asked for. The only thing I haven't told is that I added the table into QGIS straight from Qspatialite plugin. I have also added the table directly from the Spatialite import in QGIS. What you see is everything I see and have done. What it is showing is that the same table has different column results two packages (spatialite-GUI and QGIS). Is this a known problem with using spatialite?
1d
revised Spatialite Table Difference in QGIS
added 29 characters in body
1d
revised Spatialite Table Difference in QGIS
added 363 characters in body
1d
comment Import Shapefile into Existing Spatialite Table
Yes, but the geometry is in a column called geom. City, state, and country are all text fields.
1d
asked Spatialite Table Difference in QGIS
1d
revised Import Shapefile into Existing Spatialite Table
added 83 characters in body
1d
comment Import Shapefile into Existing Spatialite Table
My spatialite table has three columns (city, state, country). The shapefiles have the previous columns, but also many other columns. I was thinking that my Append would have a SELECT clause in it (ie: SELECT city, state, country FROM shapefile...)
1d
asked Import Shapefile into Existing Spatialite Table
1d
answered Mac QGIS files to Windows Arc GIS compatibility
2d
awarded  Yearling
Apr
15
comment Convert from Julian Date to Calender Date in Field Calculator
Thank you Alex, I will pass it along. I don't see Julian dates either, but there must be some reason as to why they are using it.
Apr
15
comment Convert from Julian Date to Calender Date in Field Calculator
To be honest, I am asking for a friend, and I am not sure if he can disclose it, but I will ask.