Hey Alex, Thanks for the tip on unixepoch. I'll have to research that one a little more.
And, yes, several tabular joins are performed between various spatial tables, but as you allude to, some join results are flat, and I do employ the SpatiaLite gui in the mix. For others, it's nice to be able to visualize the relationship, so that is where I am using the QGIS join for this. The PyQT date format from the QspatiaLite import just caught me off guard. The joins are simple enough that if I consistently use DB Manager or just use QspatiaLite then I wouldn't have a problem. Thanks for the ogr2ogr hint as well. James Sent from my iPhone > On May 24, 2015, at 11:56, Alex Mandel <[email protected]> wrote: > > Of course that won't work in this case as DBF does not support Date-time > in a single field. > > Back to the original question, if I'm understanding you are importing 2+ > tables and joins between those tables aren't working when you try to > join by Date-Time? > > If you really want things to work in SQLite use unixepoch to match the > join. Are you using the QGIS join tool for this? I would write a view in > sqlite/spatialite that joins the tables. It sounds like your issue stems > from how QGIS read the spatialite tables and tries the join. If you do > it with SQL then you can more finely control how the matches work (like > the above mentioned epoch conversion can be done on the fly). > > PS: ogr2ogr should be able to batch convert your db consistently. > > Thanks, > Alex > > > > >> On 05/24/2015 09:09 AM, Bernd Vogelgesang wrote: >> Haven't worked with spatialite for a while, but by that time I needed to >> work with DB Manager, QSpatialite and the Spatialite GUI to get things >> done. Variety is nice, but having to use 3 tools is a bit too much imho. >> >> Actually I would have like to move all my work to spatialite, but as >> qgis still seems to be very shape-o-centric (and postis is no option) >> and it's hard to remember what syntax to use in this tool and which >> function was in that, but not in the other, or the other way round, led >> me on the path of lowest resistance: using shape files :( >> >> No offence, just a pitiful remark ;) >> >> Cheers >> Bernd >> >> Am 24.05.2015, 17:13 Uhr, schrieb Paolo Cavallini <[email protected]>: >> >>> Il 24/05/2015 17:03, James Wood ha scritto: >>> >>>> I was afraid >>> >>> No problem with that, James - I just want to understand the real needs >>> of users. My underlying idea is that variety is good, but too much >>> duplication scares users away, so we're trying to reduce it when >>> appropriate and feasible (remember the good old days where everything in >>> QGIS was double? labelling, styling, etc.). >>> All the best, and thanks for the feedback. >>> >> >> > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
