Geodesk ... eine neue geospatiale Datenbank für OSM-Daten?

Communities Deutschland (Germany)
,
42

This is now supported in Version 0.1.3: Clicking on a feature on a generated Leaflet map takes the user to the OSM object.

2 Likes
43

Danke, funktioniert. :heart_eyes:

44

Als Anregung hier mein golm.bat (angepasstes gol.bat), welches die generierte Map automatisch anzeigt:

@echo off
set javacmd=\apps\gol-tool\jdk17\bin\java

%javacmd% -Xmx12g -cp %~dp0\..\lib\gol.jar -Dfile.encoding=UTF-8 com.geodesk.gol.GolTool %* -f=map -f:color=#0000FF > map.html

start map.html

Beispielaufruf:

golm query germany "na[tourism=aquarium]" :fish: :tropical_fish:

3 Likes
45

Yes, it’s using an index for the tags key/values. I should note that my measurements were based on my heavily modified fork. The runtimes for the count use case above using the latest official release look more like this:

<osm version="0.6" generator="Overpass API 0.7.59.1 2a9d9642">
<note>The data included in this document is from www.openstreetmap.org. The data is made available under ODbL.</note>
<meta osm_base=""/>

  <count id="0">
    <tag k="nodes" v="75398"/>
    <tag k="ways" v="10"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="75408"/>
  </count>

</osm>
	Command being timed: "./osm3s_query --db-dir=db"
	User time (seconds): 12.04
	System time (seconds): 0.33
	Percent of CPU this job got: 99%
	Elapsed (wall clock) time (h:mm:ss or m:ss): 0:12.37

I’m using an 8 core Intel i9 at 2.4 GHz.

1 Like
46

Is there a possibility to query based on meta-data such as user name or date-range of timestamp? Or is something like querying meta data planned in later versions?

1 Like
47

20x speedup, excellent job! When will this go live?

48

Currently, GOLs don’t contain any OSM metadata. We don’t have any immediate plans to add metadata support, though we’re considering an option to turn edit timestamps and user information into additional tags (which can then be queried).

Could you tell me more about your use case? Are you looking for features edited within a time span, in a specific area, or are you gathering planet-wide statistics (similar to HDYC)?

49

Thanks for your reply. At the moment there are two use cases in my mind:
First is about cleanup of untouched imported data. E.g., TIGER-data in the US. The user name and time-range of the import is known. Those query is pretty heavy, so public overpass server only works on small areas. As GeoDesk is pretty easy to setup on my local computer, my idea was to do this locally.

Second one is similar like hdyc, but maybe more individual (in regards of areas) and as well also a bit similar like Tag-info to see how popular (in question of users using it) a specific tag is in a specific region.

50

Thanks! This is a bit of a challenging topic. Upstream merging turned out to be too time consuming and in the end not feasible at all. OTOH, I don’t have enough free time to operate my own instance. Currently, only testing on a dev server is available for a limited audience.

Can you share an example, maybe?

51

https://wiki.openstreetmap.org/wiki/TIGER_fixup/Overpass_queries

You can find some in the wiki above, mainly the issue is the amount of data you get as a result. :wink:

52

Thanks! I worked with those before, and yes, they’re triggering some known performance issues.

If the amount of data is the main concern, maybe don’t try to display the results in overpass turbo, but download them to a file instead. Overpass turbo really has a hard time displaying dozens of megabytes.

Follow up for the TIGER queries is here now: TIGER data quality - #24 by mmd

53

Wo finde ich nochmal die Binaries für Windows vom GOL Tool?

54

@chris66
Also ich werde direkt auf http://www.geodesk.com/download fündig,

dort gibt es doch aktuell das zip-Archiv für die Version 0.1.8 … oder?

2 Likes
55

Ah, danke. Ich hatte auf github gesucht.