[Qgis-user] Import to SpatiaLite from file geodatabase

[James Wood]

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 <tech_dev at wildintellect.com> 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 <cavallini at faunalia.it>:
>> 
>>> 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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user