Getting keys and unique values associated with a key from pbf #188

Robinlovelace · 2021-04-05T10:45:26Z

Robinlovelace
Apr 5, 2021
Maintainer

Sometimes it's useful to see what keys are available and the range of values associated with a particular key are from the .pbf directly. Use case: finding out the type of railway tags in the UK OSM data.

Reprex demonstrating broadly the desired outcome with the Isle of Wight and demonstrating that queries on pbf files can work - just cannot figure out the query needed to find the unique keys without reading in the whole file.

# Aim: test querying of query .pbf files directly, without vectortranslate

remotes::install_github("ropensci/osmextract")
#> Using github PAT from envvar GITHUB_PAT
#> Skipping install of 'osmextract' from a github remote, the SHA1 (17e276fb) has not changed since last install.
#>   Use `force = TRUE` to force installation
library(osmextract)
#> Data (c) OpenStreetMap contributors, ODbL 1.0. https://www.openstreetmap.org/copyright.
#> Check the package website, https://docs.ropensci.org/osmextract/, for more details.

# Getting the desired result with extra_tags and vectortranslate
d = oe_get("isle of wight", extra_tags = "railway")
#> The input place was matched with: Isle of Wight
#> The chosen file was already detected in the download directory. Skip downloading.
#> The corresponding gpkg file was already detected. Skip vectortranslate operations.
#> Reading layer `lines' from data source `/home/robin/data/osm/geofabrik_isle-of-wight-latest.gpkg' using driver `GPKG'
#> Simple feature collection with 46059 features and 10 fields
#> Geometry type: LINESTRING
#> Dimension:     XY
#> Bounding box:  xmin: -5.405035 ymin: 43.35489 xmax: -0.175775 ymax: 50.89601
#> Geodetic CRS:  WGS 84
# desired result
table(d$railway)
#> 
#>    abandoned construction      disused    miniature     proposed         rail 
#>          134            2            3           12            3           73 
#>        razed 
#>           29

# Demonstration of getting summary data without translating to gpkg
# note: it could be useful for oe_download("isle of wight") to work:
oe_download("isle of wight")
#> Error in infer_provider_from_url(file_url): Cannot infer the provider from the url, please specify it.
f = oe_download(oe_match("isle of wight")$url)
#> The input place was matched with: Isle of Wight
#> The chosen file was already detected in the download directory. Skip downloading.
f
#> [1] "/home/robin/data/osm/geofabrik_isle-of-wight-latest.osm.pbf"
q = "SELECT DISTINCT highway FROM lines"
# works for highway:
sf::st_read(f, query = q, layer = "lines")
#> Reading layer `lines' from data source `/home/robin/data/osm/geofabrik_isle-of-wight-latest.osm.pbf' using driver `OSM'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>           highway
#> 1     residential
#> 2       secondary
#> 3        tertiary
#> 4    unclassified
#> 5         primary
#> 6         footway
#> 7         service
#> 8            <NA>
#> 9           track
#> 10      bridleway
#> 11          steps
#> 12           path
#> 13   primary_link
#> 14       cycleway
#> 15  living_street
#> 16     pedestrian
#> 17   construction
#> 18 secondary_link
#> 19  tertiary_link
#> 20       proposed

# Demonstration of doing queries on .pbf file
query = "SELECT hstore_get_value(other_tags, 'railway') AS railway FROM lines"
res = sf::st_read(f, query = query, layer = "lines")
#> Reading layer `lines' from data source `/home/robin/data/osm/geofabrik_isle-of-wight-latest.osm.pbf' using driver `OSM'
#> Simple feature collection with 46059 features and 1 field
#> Geometry type: LINESTRING
#> Dimension:     XY
#> Bounding box:  xmin: -5.405035 ymin: 43.35489 xmax: -0.175775 ymax: 50.89601
#> Geodetic CRS:  WGS 84
table(res$railway) # works
#> 
#>    abandoned construction      disused    miniature     proposed         rail 
#>          134            2            3           12            3           73 
#>        razed 
#>           29

^{Created on 2021-04-05 by the reprex package (v2.0.0)}

Not 100% that querying directly from the .pbf is possible but imagine it is and it could be a quick way of getting a handle on large datasets before committing to vectortranslating them with a range of extra_tags which can take a long time.

Robinlovelace · 2021-04-05T15:50:18Z

Robinlovelace
Apr 5, 2021
Maintainer Author

Interesting blog post on OSM hstore values (there is not much out there and they are strange): https://www.blueskiesabove.us/entry/querying-converting-osm-pbf/

0 replies

agila5 · 2021-04-05T17:26:44Z

agila5
Apr 5, 2021
Maintainer

Hi Robin! First of all, thank you very much for the suggestion and the link on hstore values. I think that your suggestion can be summarised as follows:

Expand the existing oe_get_keys() to read directly from a .pbf file and skip the .gpkg conversion;
Expand the existing function with an additional argument (something like show_values) that can be used to display the (unique) values associated with each key (or a subset of keys).

Is that right?

7 replies

agila5 Apr 10, 2021
Maintainer

Hi Robin. It's pretty easy to extract the values for a given set of keys in a .gpkg file:

# packages
library(sf)
#> Linking to GEOS 3.9.0, GDAL 3.2.1, PROJ 7.2.1
library(osmextract)
#> Data (c) OpenStreetMap contributors, ODbL 1.0. https://www.openstreetmap.org/copyright.
#> Check the package website, https://docs.ropensci.org/osmextract/, for more details.

# gpkg
its_gpkg <- oe_get("ITS Leeds", download_only = TRUE, quiet = TRUE)
oe_get_keys(its_gpkg)[1:2]
#> [1] "bicycle" "foot"
st_read(
  its_gpkg, 
  layer = "lines", 
  query = "
  SELECT DISTINCT 
    hstore_get_value(other_tags, 'bicycle') AS bicycle, 
    hstore_get_value(other_tags, 'foot') AS foot  
  FROM lines
  "
)
#> Reading layer `lines' from data source `C:\Users\Utente\Documents\osm-data\test_its-example.gpkg' using driver `GPKG'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>      bicycle       foot
#> 1       <NA>       <NA>
#> 2 designated designated
#> 3        yes       <NA>
#> 4       <NA>        yes
#> 5        yes        yes
#> 6 designated        yes

but the equivalent code doesn't work on pbf input

its_pbf <- oe_get("ITS Leeds", download_only = TRUE, skip_vectortranslate = TRUE, quiet = TRUE)
oe_get_keys(its_pbf)[1:2]
#> [1] "bicycle" "foot"
st_read(
  its_pbf, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines"
)
#> Reading layer `lines' from data source `C:\Users\Utente\Documents\osm-data\test_its-example.osm.pbf' using driver `OSM'
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 1: Invalid index : -1
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 1: Invalid index : -1
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 1: Invalid index : -1
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>   bicycle
#> 1

st_read(
  its_pbf, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines"
)
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 6: SELECT DISTINCT not supported on multiple columns.
#> Error in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : Query execution failed, cannot open layer.

^{Created on 2021-04-10 by the reprex package (v1.0.0)}

I'm not sure if that's a bug in sf or a limitation of pbf files. Do you know how if (and how) we can test that code with GDAL?

Robinlovelace Apr 11, 2021
Maintainer Author

Do you know how if (and how) we can test that code with GDAL?

No but good question...

Robinlovelace Apr 11, 2021
Maintainer Author

It would be something like this:

ogr2ogr \
  -where "\"POP_EST\" < 1000000" \
  -f GPKG output.gpkg \
  natural_earth_vector.gpkg \
  ne_10m_admin_0_countries

Source: https://gdal.org/programs/ogr2ogr.html

Robinlovelace Apr 11, 2021
Maintainer Author

In short: this error seems relevant

## ERROR 6: SELECT DISTINCT not supported on multiple columns.

agila5 Apr 11, 2021
Maintainer

ERROR 6: SELECT DISTINCT not supported on multiple columns.

Ok, but maybe that's not a big deal since I can create a for loop and process one column at a time. The main problem is that the same code fails with 1 column.

Robinlovelace · 2021-04-11T08:24:13Z

Robinlovelace
Apr 11, 2021
Maintainer Author

Reproducible example:

Test ogr queries

echo "Hello Bash!";
pwd;
ls | head;

## Hello Bash!
## /mnt/57982e2a-2874-4246-a6fe-115c199bc6bd/atfutures/itsleeds/osmextract/data-raw
## bbbike_zones.R
## geofabrik_zones.R
## its-example.osm.pbf
## its-example.osm.pbf.1
## its-example.osm.pbf.2
## lines.txt
## openstreetmap_fr_zones.R
## out.txt
## test-gdal.md
## test-gdal-query.sh

wget https://github.com/ropensci/osmextract/raw/master/inst/its-example.osm.pbf

ogrinfo its-example.osm.pbf 
ogrinfo its-example.osm.pbf lines > lines.txt
head lines.txt

## --2021-04-11 09:23:19--  https://github.com/ropensci/osmextract/raw/master/inst/its-example.osm.pbf
## Resolving github.com (github.com)... 140.82.121.3
## Connecting to github.com (github.com)|140.82.121.3|:443... connected.
## HTTP request sent, awaiting response... 302 Found
## Location: https://raw.githubusercontent.com/ropensci/osmextract/master/inst/its-example.osm.pbf [following]
## --2021-04-11 09:23:19--  https://raw.githubusercontent.com/ropensci/osmextract/master/inst/its-example.osm.pbf
## Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.199.109.133, 185.199.108.133, 185.199.111.133, ...
## Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.199.109.133|:443... connected.
## HTTP request sent, awaiting response... 200 OK
## Length: 40792 (40K) [application/octet-stream]
## Saving to: ‘its-example.osm.pbf.3’
## 
##      0K .......... .......... .......... .........            100% 3.31M=0.01s
## 
## 2021-04-11 09:23:19 (3.31 MB/s) - ‘its-example.osm.pbf.3’ saved [40792/40792]
## 
## INFO: Open of `its-example.osm.pbf'
##       using driver `OSM' successful.
## 1: points (Point)
## 2: lines (Line String)
## 3: multilinestrings (Multi Line String)
## 4: multipolygons (Multi Polygon)
## 5: other_relations (Geometry Collection)
## INFO: Open of `its-example.osm.pbf'
##       using driver `OSM' successful.
## 
## Layer name: lines
## Geometry: Line String
## Feature Count: -1
## Extent: (-1.561196, 53.806303) - (-1.549845, 53.809293)
## Layer SRS WKT:
## GEOGCRS["WGS 84",
##     DATUM["World Geodetic System 1984",

ogrinfo \
  -dialect sqlite -sql "SELECT highway, COUNT(*) from lines" \
  its-example.osm.pbf

## Had to open data source read-only.
## INFO: Open of `its-example.osm.pbf'
##       using driver `OSM' successful.
## 
## Layer name: SELECT
## Geometry: None
## Feature Count: 1
## Layer SRS WKT:
## (unknown)
## highway: String (0.0)
## COUNT(*): Integer (0.0)
## OGRFeature(SELECT):0
##   highway (String) = footway
##   COUNT(*) (Integer) = 189

ogrinfo \
  -dialect sqlite -sql "SELECT highway, COUNT(*) from lines" \
  its-example.osm.pbf

## Had to open data source read-only.
## INFO: Open of `its-example.osm.pbf'
##       using driver `OSM' successful.
## 
## Layer name: SELECT
## Geometry: None
## Feature Count: 1
## Layer SRS WKT:
## (unknown)
## highway: String (0.0)
## COUNT(*): Integer (0.0)
## OGRFeature(SELECT):0
##   highway (String) = footway
##   COUNT(*) (Integer) = 189

ogrinfo \
  -dialect sqlite -sql "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines" \
  its-example.osm.pbf

## Had to open data source read-only.
## INFO: Open of `its-example.osm.pbf'
##       using driver `OSM' successful.
## 
## Layer name: SELECT
## Geometry: None
## Feature Count: 6
## Layer SRS WKT:
## (unknown)
## bicycle: String (0.0)
## foot: String (0.0)
## OGRFeature(SELECT):0
##   bicycle (String) = (null)
##   foot (String) = (null)
## 
## OGRFeature(SELECT):1
##   bicycle (String) = designated
##   foot (String) = designated
## 
## OGRFeature(SELECT):2
##   bicycle (String) = yes
##   foot (String) = (null)
## 
## OGRFeature(SELECT):3
##   bicycle (String) = (null)
##   foot (String) = yes
## 
## OGRFeature(SELECT):4
##   bicycle (String) = yes
##   foot (String) = yes
## 
## OGRFeature(SELECT):5
##   bicycle (String) = designated
##   foot (String) = yes

ogrinfo \
  -sql "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines" \
  its-example.osm.pbf > out.txt

## ERROR 6: SELECT DISTINCT not supported on multiple columns.

  


# ogrinfo \
#   -sql "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines" \
#   its-example.osm.pbf > out.txt
  
# cat out.txt

ogrinfo \
  -sql "SELECT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines" \
  its-example.osm.pbf > out.txt

0 replies

Robinlovelace · 2021-04-11T08:27:27Z

Robinlovelace
Apr 11, 2021
Maintainer Author

And this seems to fail, not sure why, so basically, not easy:

ogrinfo \
  -sql "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines" \
  its-example.osm.pbf

0 replies

Robinlovelace · 2021-04-11T08:35:20Z

Robinlovelace
Apr 11, 2021
Maintainer Author

https://gis.stackexchange.com/questions/393540/how-to-extract-unique-values-from-pbf-file-with-gdal

9 replies

Robinlovelace Apr 12, 2021
Maintainer Author

(maybe) it's possible to add that option and use SQLite dialect in st_read.

Could be a good upstream solution!

agila5 Apr 13, 2021
Maintainer

Hi @Robinlovelace, can you run the following?

# install packages
remotes::install_github("ropensci/osmextract", quiet = TRUE)
remotes::install_github("agila5/sf", "test-dialect", quiet = TRUE)

# load packages
library(sf)
#> Linking to GEOS 3.9.0, GDAL 3.2.1, PROJ 7.2.1
library(osmextract)
#> Data (c) OpenStreetMap contributors, ODbL 1.0. https://www.openstreetmap.org/copyright.
#> Check the package website, https://docs.ropensci.org/osmextract/, for more details.

# data
pbf_its <- oe_get("ITS Leeds", download_only = TRUE, skip_vectortranslate = TRUE)
#> The input place was matched with: ITS Leeds
#> The chosen file was already detected in the download directory. Skip downloading.

# DISTINCT + hstore_get_value (current approach)
st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines"
)
#> Reading layer `lines' from data source 
#>   `C:\Users\Utente\Documents\osm-data\test_its-example.osm.pbf' 
#>   using driver `OSM'
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 1: Invalid index : -1
#> More warnings with Invalid Index: -1 ....

#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>   bicycle
#> 1
st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines"
)
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 6: SELECT DISTINCT not supported on multiple columns.
#> Error in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : Query execution failed, cannot open layer.

# DISTINCT + hstore_get_value (SQLite approach)
st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines", 
  dialect = "SQLite"
)
#> Reading layer `lines' from data source 
#>   `C:\Users\Utente\Documents\osm-data\test_its-example.osm.pbf' 
#>   using driver `OSM'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>      bicycle
#> 1       <NA>
#> 2 designated
#> 3        yes
st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines", 
  dialect = "SQLite"
)
#> Reading layer `lines' from data source 
#>   `C:\Users\Utente\Documents\osm-data\test_its-example.osm.pbf' 
#>   using driver `OSM'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>      bicycle       foot
#> 1       <NA>       <NA>
#> 2 designated designated
#> 3        yes       <NA>
#> 4       <NA>        yes
#> 5        yes        yes
#> 6 designated        yes

^{Created on 2021-04-13 by the reprex package (v2.0.0)}

tbh I'm not so sure that there are significant benefits if you skip the .gpkg conversion, but I think that the new SQLite feature could be interesting on its own.

Robinlovelace Apr 13, 2021
Maintainer Author

Sure, just running these lines now:

remotes::install_github("ropensci/osmextract", quiet = TRUE)
remotes::install_github("agila5/sf", "test-dialect", quiet = TRUE)

# load packages
library(sf)
library(osmextract)
pbf_its <- oe_get("ITS Leeds", download_only = TRUE, skip_vectortranslate = TRUE)
# DISTINCT + hstore_get_value (current approach)
st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines"
)
st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines"
)

# DISTINCT + hstore_get_value (SQLite approach)
st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines", 
  dialect = "SQLite"
)

st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines", 
  dialect = "SQLite"
)

Robinlovelace Apr 13, 2021
Maintainer Author

Result 🎉

st_read(
  dsn = pbf_its, 
  layer = "lines", 
  query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines", 
  dialect = "SQLite"
)
#> Reading layer `lines' from data source 
#>   `/mnt/57982e2a-2874-4246-a6fe-115c199bc6bd/data/osm/test_its-example.osm.pbf' 
#>   using driver `OSM'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>      bicycle       foot
#> 1       <NA>       <NA>
#> 2 designated designated
#> 3        yes       <NA>
#> 4       <NA>        yes
#> 5        yes        yes
#> 6 designated        yes

``` r remotes::install_github("ropensci/osmextract", quiet = TRUE) remotes::install_github("agila5/sf", "test-dialect", quiet = TRUE)

load packages

library(sf)
#> Linking to GEOS 3.9.0, GDAL 3.2.1, PROJ 7.2.1
library(osmextract)
#> Data (c) OpenStreetMap contributors, ODbL 1.0. https://www.openstreetmap.org/copyright.
#> Check the package website, https://docs.ropensci.org/osmextract/, for more details.
pbf_its <- oe_get("ITS Leeds", download_only = TRUE, skip_vectortranslate = TRUE)
#> The input place was matched with: ITS Leeds
#> The chosen file was already detected in the download directory. Skip downloading.

DISTINCT + hstore_get_value (current approach)

st_read(
dsn = pbf_its,
layer = "lines",
query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines"
)
#> Reading layer lines' from data source #> /mnt/57982e2a-2874-4246-a6fe-115c199bc6bd/data/osm/test_its-example.osm.pbf'
#> using driver `OSM'
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 1: Invalid index : -1

#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 1: Invalid index : -1

#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 1: Invalid index : -1
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#> bicycle
#> 1
st_read(
dsn = pbf_its,
layer = "lines",
query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines"
)
#> Warning in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : GDAL
#> Error 6: SELECT DISTINCT not supported on multiple columns.
#> Error in CPL_read_ogr(dsn, layer, query, as.character(options), quiet, : Query execution failed, cannot open layer.

DISTINCT + hstore_get_value (SQLite approach)

st_read(
dsn = pbf_its,
layer = "lines",
query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle FROM lines",
dialect = "SQLite"
)
#> Reading layer lines' from data source #> /mnt/57982e2a-2874-4246-a6fe-115c199bc6bd/data/osm/test_its-example.osm.pbf'
#> using driver `OSM'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#> bicycle
#> 1
#> 2 designated
#> 3 yes

st_read(
dsn = pbf_its,
layer = "lines",
query = "SELECT DISTINCT hstore_get_value(other_tags, 'bicycle') AS bicycle, hstore_get_value(other_tags, 'foot') AS foot FROM lines",
dialect = "SQLite"
)
#> Reading layer lines' from data source #> /mnt/57982e2a-2874-4246-a6fe-115c199bc6bd/data/osm/test_its-example.osm.pbf'
#> using driver `OSM'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#> bicycle foot
#> 1
#> 2 designated designated
#> 3 yes
#> 4 yes
#> 5 yes yes
#> 6 designated yes


<sup>Created on 2021-04-13 by the [reprex package](https://reprex.tidyverse.org) (v1.0.0)</sup>

agila5 Apr 13, 2021
Maintainer

Great! I will complete the implementation and prepare a PR to the sf repo as soon as possible. Then I think we can just adopt something like lapply() + unique() or table().

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Getting keys and unique values associated with a key from pbf #188

{{title}}

Replies: 5 comments 16 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

ERROR 6: SELECT DISTINCT not supported on multiple columns.

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

load packages

DISTINCT + hstore_get_value (current approach)

DISTINCT + hstore_get_value (SQLite approach)

{{title}}

Select a reply

Getting keys and unique values associated with a key from pbf #188

Robinlovelace Apr 5, 2021 Maintainer

Replies: 5 comments · 16 replies

Robinlovelace Apr 5, 2021 Maintainer Author

agila5 Apr 5, 2021 Maintainer

agila5 Apr 10, 2021 Maintainer

Robinlovelace Apr 11, 2021 Maintainer Author

Robinlovelace Apr 11, 2021 Maintainer Author

Robinlovelace Apr 11, 2021 Maintainer Author

agila5 Apr 11, 2021 Maintainer

ERROR 6: SELECT DISTINCT not supported on multiple columns.

Robinlovelace Apr 11, 2021 Maintainer Author

Test ogr queries

Robinlovelace Apr 11, 2021 Maintainer Author

Robinlovelace Apr 11, 2021 Maintainer Author

Robinlovelace Apr 12, 2021 Maintainer Author

agila5 Apr 13, 2021 Maintainer

Robinlovelace Apr 13, 2021 Maintainer Author

Robinlovelace Apr 13, 2021 Maintainer Author

load packages

DISTINCT + hstore_get_value (current approach)

DISTINCT + hstore_get_value (SQLite approach)

agila5 Apr 13, 2021 Maintainer

Robinlovelace
Apr 5, 2021
Maintainer

Replies: 5 comments 16 replies

Robinlovelace
Apr 5, 2021
Maintainer Author

agila5
Apr 5, 2021
Maintainer

agila5 Apr 10, 2021
Maintainer

Robinlovelace Apr 11, 2021
Maintainer Author

Robinlovelace Apr 11, 2021
Maintainer Author

Robinlovelace Apr 11, 2021
Maintainer Author

agila5 Apr 11, 2021
Maintainer

Robinlovelace
Apr 11, 2021
Maintainer Author

Robinlovelace
Apr 11, 2021
Maintainer Author

Robinlovelace
Apr 11, 2021
Maintainer Author

Robinlovelace Apr 12, 2021
Maintainer Author

agila5 Apr 13, 2021
Maintainer

Robinlovelace Apr 13, 2021
Maintainer Author

Robinlovelace Apr 13, 2021
Maintainer Author

agila5 Apr 13, 2021
Maintainer