Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am running QGIS 1.8 (SpatiaLite 3.0.1) and QSpatiaLite 6.0.1.

I have a spatial table EventPrecise (with geometry column p in EPSG:4326). I want to join this table with another, non-spatial table Event and produce a new spatial table out of it with EPSG:21781, while at the same time filtering on a non-spatial attribute t. This is my query:

SELECT e.id, e.oid, e.type, e.subtype, e.t, ST_Transform(ep.p, 21781) AS p
FROM event e LEFT OUTER JOIN eventprecise ep ON e.id = ep.eid
WHERE datetime(e.t) > datetime('2013-02-05 18:20:00') AND datetime(e.t) < datetime('2013-02-19 08:31:00');

When running this query in QSpatiaLite with options "Create Spatial Table & Load in QGIS", and geometry column = "p", I get the error:

'%s' doesn't correspond to a geometry field, try with another field name

Creating a View works though.. is this a bug?

EDIT: Turns out that it works when doing an INNER JOIN, so p is never null - still, is this normal behaviour?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.