Skip to content

GIScience/ohsome-filter-to-sql

View on GitHub ↗Related repositories →

Translate ohsome API filter to SQL WHERE clause ready to be used with ohsomeDB

active 2025-08-272026-08-13 (UTC)

Complete coverage26,403 / 26,403 hourly files (100%) · 2 absent upstream2023-08-152026-08-19 (UTC)
Events
106
Pushes
57
Pull requests
7
Issues
15
Stars
1
Forks
0

Activity over time

Daily event counts in the loaded window

Line chart, 352 days from 2025-08-27 to 2026-08-13. Pushes: 57 total, peak 5 in a day. Pull requests: 7 total, peak 1 in a day. Issues: 15 total, peak 4 in a day. Comments: 8 total, peak 5 in a day. Stars: 1 total, peak 1 in a day.

  • Pushes
  • Pull requests
  • Issues
  • Comments
  • Stars

Stars, PRs, issues and forks are under-captured in the later part of this window. GH Archive progressively stopped capturing non-push events during 2026 — −95% or worse by the end of the window. Every series here except Pushes fades for that reason, so a decline above reflects the archive, not this repository. Pushes stay reliable throughout, so read them, and the contributor counts derived from them, as the real signal. Data health has the measurements.

Top contributors

Pushes, PRs, issues, reviews and comments — stars and forks excluded, so this is contribution rather than popularity

ContributorContributionsPushesPRsComments
matthiasschaub623946
tyrasd181031
Gigaszi6501
joker2343300

Recent activity

Latest issues, pull requests and releases

  • Issue#37tyrasd2026-05-08 08:54
    add shorthand for `key=* and key!=no`
  • Issue#21matthiasschaub2025-12-16 12:17
    Queries with SQL injection vector use query arguments (native PostgreSQL syntax is `$n`)
  • Pull request#30matthiasschaub2025-12-16 12:17
  • Pull request#30matthiasschaub2025-12-09 14:20
  • Issue#29tyrasd2025-11-20 12:02
    Do we want to allow "simple" URLs in unquoted strings
  • Pull request#28tyrasd2025-11-05 15:04
  • Issue#24matthiasschaub2025-09-26 11:30
    Expose more functions to library user
  • Pull request#23tyrasd2025-09-12 15:38
  • Issue#21matthiasschaub2025-09-11 14:01
    Queries with SQL injection vector use query arguments (native PostgreSQL syntax is `$n`)
  • Issue#20matthiasschaub2025-09-11 13:59
    Add ohsome filter syntax documentation
  • Issue comment#12matthiasschaub2025-09-11 13:58
    refactor: make grammar simpler moving validation to listener
  • Issue#12matthiasschaub2025-09-11 13:58
    refactor: make grammar simpler moving validation to listener
  • Issue comment#17Gigaszi2025-09-04 11:42
    tests: move approval files to seperate directory (E.g. `tests/approvals`)
  • Issue#17matthiasschaub2025-09-03 07:42
    tests: move approval files to seperate directory (E.g. `tests/approvals`)
  • Issue#15matthiasschaub2025-09-03 07:32
    feat: normalize units (E.g. meter, miles, etc.)
  • Issue#14matthiasschaub2025-09-03 07:27
    feat: case insensitive queries (e.g. `leaftype=Broadleaf and leaftype=broadleaf`)
  • Issue#10matthiasschaub2025-09-03 07:19
    feat: support `id:n103` which is equivalent to `id:node/103`
  • Pull request#5matthiasschaub2025-09-03 05:31
  • Pull request#6matthiasschaub2025-09-02 13:21
  • Issue comment#3matthiasschaub2025-09-01 07:16
    dependency pytest-approval not available
  • Issue#7tyrasd2025-08-29 16:33
    (enhancement idea) introduce filters for substring matches in tags, etc.
  • Pull request#4tyrasd2025-08-29 10:26
  • Issue#3tyrasd2025-08-29 09:58
    dependency pytest-approval not available
  • Issue#2matthiasschaub2025-08-28 07:05
    Build and publish to pypi
  • Issue#1matthiasschaub2025-08-28 07:04
    Add CI

Totals cover only the window loaded into ClickHouse and count events, not GitHub's lifetime totals — 1 stars here means stars gained during the window, not the repo's star count.