Skip to main content
added 2 characters in body
Source Link
geozelot
  • 30.9k
  • 4
  • 34
  • 57
  • When creating/editing a Virtual Layer using either the

    • <QGIS> | Layer | Create Layer | New Virtual Layer or

    • <QGIS> | Layer | Add Layer | Add/Edit Virtual Layer

    dialogue, you need to Import (or Add from source) all referenced layers in the Embedded Layers panel, and use the (editable) names in the SQL; it's a good idea to always "" enclose relation names with characters other than lowercase_123, e.g. "tAbLe N@m€"

  • Alternatively, when using the DB Manager, you simply need to connect to the Virtual Layers provider in the Providers panel and refer to the layer names as seen in e.g. the Project Layers tab. Layers created via the DB Manager are automatically considered a Virtual Layer.


Use ST_Intersects instead of ST_Within to include freeholds sharing only a portion with the isochrone polygons.

  • When creating/editing a Virtual Layer using either the

    • <QGIS> | Layer | Create Layer | New Virtual Layer or

    • <QGIS> | Layer | Add Layer | Add/Edit Virtual Layer

    dialogue, you need to Import (or Add from source) all referenced layers in the Embedded Layers panel, and use the (editable) names in the SQL; it's a good idea to always "" enclose relation names with characters other than lowercase_123, e.g. "tAbLe N@m€"

  • Alternatively, when using the DB Manager, you simply need to connect to the Virtual Layers provider in the Providers panel and refer to the layer names as seen in e.g. the Project Layers tab. Layers created via the DB Manager are automatically considered a Virtual Layer.


Use ST_Intersects instead of ST_Within to include freeholds sharing only portion with the isochrone polygons.

  • When creating/editing a Virtual Layer using either the

    • <QGIS> | Layer | Create Layer | New Virtual Layer or

    • <QGIS> | Layer | Add Layer | Add/Edit Virtual Layer

    dialogue, you need to Import (or Add from source) all referenced layers in the Embedded Layers panel, and use the (editable) names in the SQL; it's a good idea to always "" enclose relation names with characters other than lowercase_123, e.g. "tAbLe N@m€"

  • Alternatively, when using the DB Manager, you simply need to connect to the Virtual Layers provider in the Providers panel and refer to the layer names as seen in e.g. the Project Layers tab. Layers created via the DB Manager are automatically considered a Virtual Layer.


Use ST_Intersects instead of ST_Within to include freeholds sharing only a portion with the isochrone polygons.

Source Link
geozelot
  • 30.9k
  • 4
  • 34
  • 57

  • When creating/editing a Virtual Layer using either the

    • <QGIS> | Layer | Create Layer | New Virtual Layer or

    • <QGIS> | Layer | Add Layer | Add/Edit Virtual Layer

    dialogue, you need to Import (or Add from source) all referenced layers in the Embedded Layers panel, and use the (editable) names in the SQL; it's a good idea to always "" enclose relation names with characters other than lowercase_123, e.g. "tAbLe N@m€"

  • Alternatively, when using the DB Manager, you simply need to connect to the Virtual Layers provider in the Providers panel and refer to the layer names as seen in e.g. the Project Layers tab. Layers created via the DB Manager are automatically considered a Virtual Layer.


Use ST_Intersects instead of ST_Within to include freeholds sharing only portion with the isochrone polygons.