Re: [OSM-dev] OSM Database schema

2020-01-04 Thread Stefan Keller
Am Sa., 4. Jan. 2020 um 18:18 Uhr schrieb mmd : > ... As an example check out: > https://wiki.openstreetmap.org/wiki/User:Maxbe/Routen_%C3%BCber_Fl%C3%A4chen See also the research work from my lab https://eprints.hsr.ch/625/ and https://github.com/PlazaRoute/plazaroute . :Stefan Am Sa., 4. Jan.

Re: [OSM-dev] OSM Database schema

2020-01-03 Thread Stefan Keller
Ciao Lorenzo I assume you're interested in a software developers perspective. For this I've found e.g. "An Introduction to OpenStreetMap" by Mele Sax-Barnett 2014 [1]. This is a little outdated but seems to be a rather road online overview. In order to be up-to-date replace following links there:

Re: [OSM-dev] OpenStreetMap Carto release v4.9.0

2018-03-23 Thread Stefan Keller
Hi Daniel Nice. Many thanks for your work! How can I help implementing rendering of castles (forts, ruins, manors, palaces)? https://github.com/gravitystorm/openstreetmap-carto/issues/744 :Stefan 2018-03-23 14:41 GMT+01:00 Daniel Koć : > Dear all, > > Today, v4.9.0 of the

[OSM-dev] How to calculate 'Areas of Interest' with OpenStreetMap data?

2017-05-21 Thread Stefan Keller
Hi, I'm thinking since some time about criteria and an algorithm to find 'Areas of Interest' in OpenStreetMap data (aka "action around you" [1]). Of course, this should be better and more objective than G* Maps [2][3] ;-). Any ideas? :Stefan [1] "Discover the action around you with the updated

[OSM-dev] OSM GSoc 2017 projects are set

2017-05-10 Thread Stefan Keller
Hi, I just realized that 5 OSM GSoc 2017 projects are set [1] (with 8 students as stated here [2]?). Are you aware that there is another OSM related project here about an "OSM extrusion adapter" on NASA Web World Wind [3]? See also "OSGeo's GSoC 2017 - what's next" over at OSGeo discuss [4].

Re: [OSM-dev] [overpass] OSM API lookups to complement minutely diffs?

2016-09-18 Thread Stefan Keller
Thanks mmd: That was exactly what I tried to summarize after some observations: 0. The typical delay (augmented diff id) compared to current time is 1 to 4 minutes. 1. The id is always increasing but sometimes an id (or more) is/are left out between to consecutive deliveries. 2. The time interval

Re: [OSM-dev] OSM API lookups to complement minutely diffs?

2016-09-17 Thread Stefan Keller
-api.de/api/augmented_diff?id=2111988 Just want to be sure that this is the correct way to use the API. :Stefan 2016-09-17 16:48 GMT+02:00 mmd <mmd@gmail.com>: > Am 15.09.2016 um 22:53 schrieb Stefan Keller: >> I'm setting up a Kafka publish-subscribe messaging system delivering &g

Re: [OSM-dev] OSM API lookups to complement minutely diffs?

2016-09-16 Thread Stefan Keller
e the data thus taking over the load from subscribers. I'll try augmented diffs. :Stefan 2016-09-16 5:59 GMT+02:00 Paul Norman <penor...@mac.com>: > On 9/15/2016 1:53 PM, Stefan Keller wrote: >> >> Is it OK to do API lookups like this >> https://www.osm.org/api

Re: [OSM-dev] OSM API lookups to complement minutely diffs?

2016-09-16 Thread Stefan Keller
] http://wiki.openstreetmap.org/wiki/Overpass_API/Augmented_Diffs [2] https://github.com/drolbr/Overpass-API/ 2016-09-16 1:30 GMT+02:00 Frederik Ramm <frede...@remote.org>: > Hi, > > On 09/15/2016 10:53 PM, Stefan Keller wrote: >> AFAIK augmented diffs are rather an experiment

[OSM-dev] OSM API lookups to complement minutely diffs?

2016-09-15 Thread Stefan Keller
I'm setting up a Kafka publish-subscribe messaging system delivering minutely diffs. AFAIK augmented diffs are rather an experimental feature and I'd like to avoid the latency time and blackouts of overpass which runs in same server. So I'm concentrating on the main OSM API. Now, osmChange XML

Re: [OSM-dev] PostGIS query "Crossing ways"

2016-09-11 Thread Stefan Keller
Mike, See below a solution which runs standalone in a PostGIS db. This SQL looks little bit scary - but I'm open for simplifications :-). It would have been much easier to calculate in a topological structure like OSM given nodes and list of nodes (=ways)). The main query comes after the remark.

Re: [OSM-dev] osm2pgsql: avoid addition to planet_osm_point when importing ways?

2015-09-27 Thread Stefan Keller
Hi Kai and Paul, dear all Is there a solution to configure or lua-script osm2pgsql to populate osm_points only with nodes which onle have "user defined" tags (i.e. no osm_timestamp,osm_changeset,osm_version,osm_uid)? This would cut down the no. rows in table osm_point about ten times And: I

Re: [OSM-dev] OSM in a Box

2015-03-23 Thread Stefan Keller
Hi, That was a students project and is not supported anymore. It's still in use in Germany somewhere including a patch regarding bigint osm_ids, It had some nice ideas regarding OSM schema mapping to GIS. But I agree with Serge: Images/Docker containing osm2pgsql will be a better choice these

Re: [OSM-dev] osm2pgsql: junctions (closed ways) imported as polygon?

2015-02-20 Thread Stefan Keller
it in polygon since the roundabout consists of more than one closed way. My hypothesis is, that osm2pgsql is incorrectly building polygons here because these single closed ways are also part of a relation (disregarding what this relation is). -S. 2015-02-18 17:28 GMT+01:00 Stefan Keller sfkel

Re: [OSM-dev] osm2pgsql: junctions (closed ways) imported as polygon?

2015-02-18 Thread Stefan Keller
...@denofr.de: On Tue, Feb 17, 2015 at 12:07:21AM +0100, Stefan Keller wrote: Now I found a pattern: osm2pgsql imports junction=roundabouts incorrectly into table planet_osm_polygon (instead of planet_osm_line) if they are mapped as one single closed way (like http://www.openstreetmap.org/way

Re: [OSM-dev] osm2pgsql: junctions (closed ways) imported as polygon?

2015-02-16 Thread Stefan Keller
Now I found a pattern: osm2pgsql imports junction=roundabouts incorrectly into table planet_osm_polygon (instead of planet_osm_line) if they are mapped as one single closed way (like http://www.openstreetmap.org/way/24932843)! -S. 2015-02-16 2:20 GMT+01:00 Stefan Keller sfkel...@gmail.com: I

[OSM-dev] osm2pgsql: junctions (closed ways) imported as polygon?

2015-02-15 Thread Stefan Keller
Hi, I observed, that many junctions (mapped as closed ways, see e.g. [1]) but not all are imported as polygons (into table planet_osm_polygon) by osm2pgsql. I'd prefer to keep them as ways/roads. Any ideas? -S. [1] http://www.openstreetmap.org/way/24932843

Re: [OSM-dev] osm2pgsql: junctions (closed ways) imported as polygon?

2015-02-15 Thread Stefan Keller
I observed, that many junctions (mapped as closed ways, see e.g. [1]) but not all are imported as polygons (into table planet_osm_polygon) by osm2pgsql. I'd prefer to keep them as ways/roads. I meant roundabouts (junction=roundabout). -S. 2015-02-15 13:28 GMT+01:00 Stefan Keller sfkel

Re: [OSM-dev] OSM with Hadoop

2015-02-12 Thread Stefan Keller
Hi Stephen, Though being biased(*) I'm observing alternatives to PostgreSQL all the time. An obvious evaluation target for me would be http://en.wikipedia.org/wiki/Greenplum And on a higher level I would reflect about different architectures, e.g. like applying this architecture design pattern

Re: [OSM-dev] Adding Slippy Map to Taginfo's Projects Tab?

2014-12-18 Thread Stefan Keller
Hi Mateusz Mateusz Konieczny [mailto:notificati...@github.com] wrote 18. Dezember 2014 09:00 ... So first stage - generating reliable list from OSM data is finished. Nice! It is possible that some of tags are missing - in this case feedback would be really useful. Ok. In the near future

Re: [OSM-dev] [OSM-talk] Is there some loop trip founder?

2014-12-03 Thread Stefan Keller
Hi Mateusz Have a look at http://poitour.ch ... It's work in progress of a semester thesis project of a student here at Geometa Lab (sorry for the german front end language). Source code will be available soon on github. Yours, Stefan P.S. Regarding our conversation/thread about

Re: [OSM-dev] Adding Slippy Map to Taginfo's Projects Tab?

2014-11-25 Thread Stefan Keller
Any news about a quick-and-dirty 80/20 solution for adding Slippy Map as a project file? Such a machine readable legend/map key would be a very useful information for other projects too. -S. 2014-10-09 16:29 GMT+02:00 Martin Raifer tyr@gmail.com: There already exists the project

Re: [OSM-dev] Adding Slippy Map to Taginfo's Projects Tab?

2014-11-25 Thread Stefan Keller
Paul Norman wrote: What do you mean by Slippy Map? A slippy map doesn't necessarily use OSM data. The openstreetmap-carto style of the main OSM page... -S: 2014-11-25 20:27 GMT+01:00 Paul Norman penor...@mac.com: On 11/25/2014 10:45 AM, Stefan Keller wrote: Any news about a quick-and-dirty

Re: [OSM-dev] Adding Slippy Map to Taginfo's Projects Tab?

2014-11-25 Thread Stefan Keller
#issuecomment-61508627 describing problems with my quick-and-dirty 80/20 solution. 2014-11-25 20:55 GMT+01:00 Stefan Keller sfkel...@gmail.com: Paul Norman wrote: What do you mean by Slippy Map? A slippy map doesn't necessarily use OSM data. The openstreetmap-carto style of the main OSM

[OSM-dev] Overpass API: Getting nodes together with centroids of areas (POI query)?

2014-10-18 Thread Stefan Keller
Hi, A typical query gives all 1. nodes, 2. ways and 3. areas with tourism=zoo” (see below). But I'd like to get back only point geometries which consist of 1. nodes together with (union) 2. centroids calculated on the fly from areas. I coined this a POI query. Possible? Yours, S. !-- This

[OSM-dev] Adding Slippy Map to Taginfo's Projects Tab?

2014-10-08 Thread Stefan Keller
Hi, On Mon, 15 Sep 2014 Jochen Topf wrote about Upcoming new feature: Projects in [Taginfo-dev] which you recently released [1]. That's a cool feature and many projects are already integrated [2]! Would'nt it be very helpful to have also Slippy Map (openstreetmap-carto [3]) listed there? Did

Re: [OSM-dev] Tile acess statistics?

2014-05-25 Thread Stefan Keller
Hi I'm also interested in tile acess statistics of the Slippy Map (or other well known renderers with worldwide coverage) It's for the purpose of getting evidence about regional and local use of OSM. It doesn't need to be realtime but shouldn't be older than one year. Any hints? -- Stefan

Re: [OSM-dev] An alternative rendering-database setup and update strategy!

2013-12-17 Thread Stefan Keller
Hi Sven Can you explain liitle bit more the setup of the servers you have in mind? You seem to have a potent machine which has a PostGIS database and uses osm2pgsql to populate and update it periodically. Then you want to attach a semi-potent server to that master? Yours, Stefan 2013/11/25

Re: [OSM-dev] osm2pgsql: access flatfile from postgresql via foreign data wrapper

2013-11-12 Thread Stefan Keller
Hi Walter Just a small hint: There exists two FDW which could be of interest here: The file_fdw [1] (which is part of the Additional Supplied Modules) and file_fixed_length_record_fdw . I assume your're interested more in the file_fixed_length_record_fdw since OSM nodes are of fixed length. Be

[OSM-dev] osm2pgsql and timestamp as data in Postgres?

2013-07-09 Thread Stefan Keller
Hi, Did anyone manage to configure osm2pgsql in order that it stores also the timestamp XML attribute in Postgres - either as separate field or as key/value in the hstore field? If yes, how can I do that? Yours, Stefan ___ dev mailing list

Re: [OSM-dev] osm2pgsql and timestamp as data in Postgres?

2013-07-09 Thread Stefan Keller
contains e.g. osm_id, osm_version - but no timestamp! Yours, Stefan 2013/7/9 Paul Norman penor...@mac.com: From: Stefan Keller [mailto:sfkel...@gmail.com] Subject: [OSM-dev] osm2pgsql and timestamp as data in Postgres? Hi, Did anyone manage to configure osm2pgsql in order that it stores also

Re: [OSM-dev] osm2pgsql and timestamp as data in Postgres?

2013-07-09 Thread Stefan Keller
there is a bug that the timestamps don't get imported from .pbf files. Should work fine with xml. Simon Am 09.07.2013 12:21, schrieb Stefan Keller: Hi Paul 2013/7/9 Paul Norman penor...@mac.com wrote: The -x|--extra-attributes option will include this metadata. You may want to add the columns

[OSM-dev] keepright currently with inconsistencies?

2013-05-23 Thread Stefan Keller
Hi, Currently, keepright seems to have less data (small files sizes) and duplicate primary keys. Any explanation? Yours, Stefan ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev

[OSM-dev] Photo/Image Server?

2013-02-16 Thread Stefan Keller
Hi, I'm looking for websites/projects about sharing street level photos (with API). Background: First: Some argue that Photo Mapping is efficient and ensures users have been there: See [1]. Second: I'm planning to add new features to the Kort game (http:/play.kort.ch ) which runs on mobile

Re: [OSM-dev] GSoC 2013 - project ideas.

2013-02-16 Thread Stefan Keller
Hi Ian Is there a wiki page about successful GSoc projects? Or could we simply update [1] to indicate those ideas which have been realized (or attempted to)? -Stefan [1] http://wiki.openstreetmap.org/wiki/Google_Summer_of_Code/2012 2013/2/13 Ian Dees ian.d...@gmail.com: Hi Deepak! I'm

Re: [OSM-dev] Is there any API to get data from OSM as geoJson?

2013-02-10 Thread Stefan Keller
-script%3EC=47.39803;8.61975;18R (go to data tab) Am 10.02.2013, 02:06 Uhr, schrieb Stefan Keller sfkel...@gmail.com: To Martin and Ander: Martin suggested to use Overpass output. He also pointed to OSM4Leaflet.js which does resolve node id's in ways to linestrings. I would avoid such client

Re: [OSM-dev] Is there any API to get data from OSM as geoJson?

2013-02-10 Thread Stefan Keller
. Yours, Stefan 2013/2/10 Stefan Keller sfkel...@gmail.com: Hi Martin 2013/2/10 Martin Raifer tyr@gmail.com: Btw: I think you are mistaken when it comes to Overpass API: it does *not* return GeoJSON or any GeoJSON like geometry (LineStrings, etc.) [1]. Where did you see ways as LineStrings

[OSM-dev] Call for A Proper Area Datatype for OSM

2013-02-10 Thread Stefan Keller
Hi Roland 2013/2/10 Roland Olbricht roland.olbri...@gmx.de: ... What makes me hesitate about GeoJSON is essentially that there is no clear rule whether an elements becomes a linestring or a polygon. Solving this will require both a test for validness (e.g. self intersections, but also some

Re: [OSM-dev] Is there any API to get data from OSM as geoJson?

2013-02-10 Thread Stefan Keller
) the common boundaries suppressed? Or (3) is the area degenerated to lines ([ | ])? Yours, Stefan 2013/2/10 Paweł Paprota ppa...@fastmail.fm: On 02/10/2013 12:13 PM, Stefan Keller wrote: To Pavel: Nice work. But I'm still not sure if OWL API is a solution to the question here: The doc says Returns

Re: [OSM-dev] Is there any API to get data from OSM as geoJson?

2013-02-09 Thread Stefan Keller
Hi Pawel 2013/2/8 Paweł Paprota ppa...@fastmail.fm: In the future (whether near or far, hard to say) there should be additional API for serving vector tiles worldwide - that would possibly power browser-side map rendering (KothicJS and such). So you mean given a tile location like this

Re: [Taginfo-dev] Tag synonyms

2013-02-07 Thread Stefan Keller
Hi Bryce I strongly agree that there is a need that users can search for tags via a specialized API (in topical or vertical search engine API). Unfortunately I know no answer yet within OSM which does that. Taginfo is definitely a good starting point. And yes, it's a challenge to extract

Re: [OSM-dev] Best and FASTEST Spatial DB for only calculating points near to X?

2012-12-15 Thread Stefan Keller
Hi Ander I would try PostGIS with the newest KNN index, limited to X first results, and eventually also limited by an absolute distance criterion (see ST_DWithin) or bbox, accelerated by a spatial index like this: SELECT ST_AsText(osm_poi.way) AS geom, name AS label FROM osm_poi,

Re: [OSM-dev] OSM API Improvements work

2012-10-15 Thread Stefan Keller
Hi Jochen 2012/10/14 Jochen Topf joc...@remote.org: On Sun, Oct 14, 2012 at 03:59:59AM +0200, Stefan Keller wrote: @Jochen: taginfo is a very valuable service which I use regularly. But it seems to me that taginfo is rather a browsing tool and has not been designed to return key-value

Re: [OSM-dev] OSM API Improvements work

2012-10-13 Thread Stefan Keller
2012/10/14 Richard Weait rich...@weait.com: I'd love to have sensible tags suggested for me. If I add name = Walmart, an editor that suggested the most-popular value for shop=* would be really useful. Yes, that would be in fact a much needed feature for beginners but also for expert mappers.

Re: [OSM-dev] GSoC - Data Tile Service

2012-05-20 Thread Stefan Keller
Hi Thorsten, hi Michael 2012/5/20 Torsten Rahn tac...@t-online.de wrote: Actually in the Marble Team we have a GSoC 2012 project which has related aims. Tiled OpenStreetMap vector rendering for Marble @Thorsten: The video you mention shows no website nor contact about the Marble project.

[OSM-dev] Syntax of XAPI queries with OR and NOT?

2012-04-15 Thread Stefan Keller
Hi, With a XAPI API I'd like to make following query types (operators/predicates): 1) OR query: Example [amenity=restaurant] OR [tourism=office] 2. NOT query: Example NOT [cuisine=pizza] What could be a suitable syntax for doing this? My suggestions: 1a)

Re: [OSM-dev] Syntax of XAPI queries with OR and NOT?

2012-04-15 Thread Stefan Keller
Hi, 2012/4/15 Paul Hartmann phaau...@googlemail.com wrote: 2012/4/15 Stefan Keller sfkel...@gmail.com: Hi, With a XAPI API I'd like to make following query types (operators/predicates): 1) OR query: Example [amenity=restaurant] OR [tourism=office] 2. NOT query: Example NOT [cuisine=pizza

Re: [OSM-dev] Syntax of XAPI queries with OR and NOT?

2012-04-15 Thread Stefan Keller
Hi, 2012/4/15 Philipp Borgers borg...@mi.fu-berlin.de: Hi, issue two queries? One for [amenity=restaurant] and one for [toursim=office] ? I think the pipe | is intended for keys and values. You can do something like this [amenity|tourism=restaurant|office]. This returns entities for

Re: [OSM-dev] Schema for v0.6 OSM files?

2012-03-28 Thread Stefan Keller
We're speaking of about three pages of XML and that is not that big thing. Of course I could do it but who - if not the developers - would know better than they themselves? I think that it would be a sign of maturity of the OSM project if an XML schema would exist! Just my 2 cents. -Stefan

Re: [OSM-dev] GSOC 2012: Kothic JS added

2012-03-14 Thread Stefan Keller
2012/3/14 Nick Whitelegg nick.whitel...@solent.ac.uk: Not the developer of kothic-js but a user of it, but +1 from me. Nick -Stefan Keller sfkel...@gmail.com wrote: - To: OSM-Dev Openstreetmap dev@openstreetmap.org From: Stefan Keller sfkel...@gmail.com Date: 14/03/2012 12

[OSM-dev] GSOC 2012: Kothic JS added

2012-03-13 Thread Stefan Keller
Hi I added Extend Kothic JS to the GSoC and I probably have a student: See http://wiki.openstreetmap.org/wiki/GSoC_Project_Ideas_2012#Renderers What do you think? -Stefan ___ dev mailing list dev@openstreetmap.org

Re: [OSM-dev] Converting OSM Mapnik stylesheet to Cascadenik or Carto

2012-02-16 Thread Stefan Keller
Hi Komяpa 2011/7/30 Komяpa m...@komzpa.net: 2011/7/30 Igor Brejc igor.br...@gmail.com: Great work and thanks for the detailed info. One comment/question: from your description (using Mapnik) and from looking at the json_getter.py I conclude you rely Osm2pgsql DB schema. yes. The main

Re: [OSM-dev] ER Diagram of OSM Database

2011-12-12 Thread Stefan Keller
Perhaps you an try this tool to extract the schema and display it in an UMLet diagram. http://wiki.hsr.ch/StefanKeller/wiki.cgi?DBSchemaToUML I'm also interested in the result. Yours, Stefan 2011/12/12 Parveen Arora m...@parveenarora.in: Hi All, I was searching for ER Diagram of

[OSM-dev] Related terms in the wiki for improved tag search

2011-09-01 Thread Stefan Keller
We are currently experimenting with our TagFinder (http://152.96.56.32/poiservice/tagfinder ) and want to improve the search for OSM tags. One of the crucial point there is that synonyms and related terms are found (term being one ore more words). Example: A search for church will show

Re: [OSM-dev] Proposal for OpenMetaMap - proper OSM import solution

2011-08-25 Thread Stefan Keller
Hi Jukka Given a WFS can also output OSM format, there is not necessarily an additional component needed. The concept of GML contains two features among others: It is based on a user defined schema and it allows user defined response data formats (where GML is mandatory). Being based on a user

Re: [OSM-dev] Proposal for OpenMetaMap - proper OSM import solution

2011-08-22 Thread Stefan Keller
a donation and then the central organisation (say: the topographic institute) does the same some months/years later. Yours, Stefan 2011/8/21 Anthony o...@inbox.org: On Sun, Aug 21, 2011 at 12:41 PM, Anthony o...@inbox.org wrote: On Sun, Aug 21, 2011 at 9:23 AM, Stefan Keller sfkel...@gmail.com

Re: [OSM-dev] Proposal for OpenMetaMap - proper OSM import solution

2011-08-22 Thread Stefan Keller
Hi Anthony 2011/8/22 Anthony o...@inbox.org: So I agree with you: The disadvantages and requirements outweigh the current concept of maintaining OMM as a separate (meta-)database. You don't agree with me.  I said the exact opposite. Sorry, I meant it seriously: I wanted to say that I agree

Re: [OSM-dev] Proposal for OpenMetaMap - proper OSM import solution

2011-08-22 Thread Stefan Keller
2011/8/22 Anthony o...@inbox.org: On Mon, Aug 22, 2011 at 8:44 AM, Stefan Keller sfkel...@gmail.com wrote: ... Given there is an organisation like the museum (in the proposal) then there *is* a community which would take care of whatever is needed to keep the relationships between the OSM

Re: [OSM-dev] Proposal for OpenMetaMap - proper OSM import solution

2011-08-21 Thread Stefan Keller
Hi Frederik Nice you join here, since we already talked little bit about this it's before. 2011/8/21 Frederik Ramm frede...@remote.org: Hi, Stefan Keller wrote: What about storing the object ID (and the link properties) directly in the OSM object? Wasn't the idea of *not* polluting

Re: [OSM-dev] Proposal for OpenMetaMap - proper OSM import solution

2011-08-20 Thread Stefan Keller
Hi Jaak That OpenMetaMap is a very interesting proposal. What about storing the object ID (and the link properties) directly in the OSM object? Yours, Stefan 2011/8/15 Jaak Laineste jaak.laine...@gmail.com: Hello,  Based on my own long-time thinking and small talk in WhereCamp Berlin I

Re: [OSM-dev] Osm2pgsql: Proposal to rename or ignore system and extra-attributes like osm_id and osm_user to save disk space

2011-08-18 Thread Stefan Keller
Hi all Is there a bug (and feature) tracking system or (developers) wiki available to input such requests for osm2pgsql? I can't find it here http://wiki.openstreetmap.org/wiki/Osm2pgsql or on elsewhere. Yours, Stefan 2011/7/25 Sven Geggus li...@fuchsschwanzdomain.de: Stefan Keller sfkel

Re: [OSM-dev] Osm2pgsql outputs neg. and duplicate osm_ids (and weird attributes in table rels)

2011-07-24 Thread Stefan Keller
Hi Frederik, hi Jon Thanks for your quick explanations. 2011/7/23 Frederik Ramm frede...@remote.org: = Any hints? Read the source, Luke ;) Lazyness was not my (main :-) problem and surely not reading the code. Regarding at least the attribute pending in osm_rels and osm_ways I assumed that

[OSM-dev] Osm2pgsql: Proposal to rename or ignore system and extra-attributes like osm_id and osm_user to save disk space

2011-07-24 Thread Stefan Keller
In osm2pgsql I'm using options --hstore-all (for analyzing tags) and --extra-attributes (for maintaining osm_version). Now, while I can control the tag entries that are taken as attributes (in the style file), I can't help that hstore is stuffed with extra-attributes like osm_user or

[OSM-dev] Osm2pgsql outputs neg. and duplicate osm_ids (and weird attributes in table rels)

2011-07-23 Thread Stefan Keller
Hi, I have some questions about the osm2pgsql and it's output to the tables osm_line, osm_polygon and osm_rels (hereby called tables line, polygon and rels). After loading OSM data there are three remarkable things in the resulting tables regarding osm_ids: 1. In the tables lines and polygons

[OSM-dev] XAPI: Any difference between 'map' and '*' and between '[bbox=...]' and '?bbox=...'?

2011-06-15 Thread Stefan Keller
Hi In XAPI [1] what is the difference * between a [bbox=...] and ?bbox=... * and between a 'map' and a '*' request ? and if the represent equal requests, which one is preferred? These examples return identical results: * 'map' request with bbox as URL parameter:

Re: [OSM-dev] XAPI log (or use cases)?

2011-06-09 Thread Stefan Keller
Hi André 2011/6/9 André Riedel riedel.an...@gmail.com wrote: Ian was pointing you to this sentence: Running queries are listed on an admin stats page http://jxapi.openstreetmap.org/xapi/admin/stats Thanks. That's a useful starting point. These stats obviously show running queries supported

[OSM-dev] XAPI log (or use cases)?

2011-06-08 Thread Stefan Keller
I'd like find out the use cases of XAPI. Does anyone know if there exists a log for XAPI usage from any existing web service? That's what I found so far: https://github.com/osm-spline/xapi/tree/new-main which suggests: * .../api/0.6/node[amenity=*] * .../api/0.6/node[highway=busstop] *

Re: [OSM-dev] which tool is better for osm data import to postgres

2011-06-06 Thread Stefan Keller
Hi Oliver 2011/6/5 Oliver Tonnhofer o...@omniscale.de wrote: I use it mostly for country extracts, but it also works with planet imports. The last import of a planet file took 20 hours on a host with 8GB RAM and a SATA RAID 1, it should be much faster on a host with more RAM. In short, it

Re: [OSM-dev] osm2pgsql for 64-bit IDs

2011-06-05 Thread Stefan Keller
Hi, 2011/5/24 Jukka Rahkonen jukka.rahko...@latuviitta.fi: ... Spatialite_osm_map with the finland.osm dataset from Geofabrik is faster than osm2pgsql in slim mode with my laptop. I have not studied spatialite_osm_map thoroughly and I do not know how well it has solved the mystery of OSM

Re: [OSM-dev] which tool is better for osm data import to postgres

2011-06-05 Thread Stefan Keller
Hi Oliver 2011/6/5 Oliver Tonnhofer o...@omniscale.de: Hi Stefan, On 05.06.2011, at 01:09, Stefan Keller wrote: I'm the project leader of osm2gis. I've tried to do a characterization of the projects mentioned before: http://dev.ifs.hsr.ch/redmine/projects/osminabox/wiki/Wiki Thanks

Re: [OSM-dev] osm2pgsql: missing osm_polygon and osm_line data under PostgreSQL 9/PostGIS 1.5.2

2011-06-04 Thread Stefan Keller
error output stream in order to find more easily what's gonig wrong. Yours, Stefan 2011/5/6 Jon Burgess jburgess...@gmail.com: On Fri, 2011-05-06 at 20:23 +0200, Stefan Keller wrote: Hi, We recently upgraded to PostgreSQL 9 and PostGIS 1.5.2 and hence were forced to rebuild osm2pgsql because

Re: [OSM-dev] osm2pgsql output possible to work with Java XAPI?

2011-05-31 Thread Stefan Keller
: It does'nt output polygons AFAIK(*)! Yours, Stefan P.S. And I know from own pains (OSM-in-a-box) how difficult OSM makes it for programmers to detect polygons... :- On May 30, 2011 4:23 PM, Stefan Keller sfkel...@gmail.com wrote: Hi, 2011/5/30 Frederik Ramm frede...@remote.org wrote: Hi, On 05/30

Re: [OSM-dev] osm2pgsql output possible to work with Java XAPI?

2011-05-31 Thread Stefan Keller
Hi Jukka 2011/5/31 Jukka Rahkonen jukka.rahko...@latuviitta.fi wrote: Stefan Keller wrote: We're not targeting a rendering system but OSM web services which deliver OSM data in geospatial formats (incl. point, linestring and polygon). We're using heavily the hstore option and recently

[OSM-dev] How do clients use XAPI's XML attributes version, timestamp, uid, user and changeset?

2011-05-31 Thread Stefan Keller
Hi, To all users/consumers of XAPI services: I'm thinking about some nice OSM services like a local JXAPI server (but also about other geospatial standards). To your knowledge, how much used are the XML attributes: version, timestamp, uid, user and changeset in the XAPI format (except for

Re: [OSM-dev] osm2pgsql output possible to work with Java XAPI?

2011-05-31 Thread Stefan Keller
Hi Ian, hi all 2011/5/31 Ian Dees ian.d...@gmail.com wrote: Since OSM format (and thus XAPI/JXAPI) does not natively support polygons, you'll have to come up with something else to use to query the database. osm2pgsql will convert OSM data to polygons for you, but it does not offer a way to

[OSM-dev] osm2pgsql output possible to work with Java XAPI?

2011-05-30 Thread Stefan Keller
Hi, Did someone already managed to configure osm2pgsql in order to make it work with Java XAPI? I'm aware that Java XAPI uses pieces of Osmosis and especially the pgsnapshot database schema

Re: [OSM-dev] osm2pgsql output possible to work with Java XAPI?

2011-05-30 Thread Stefan Keller
Hi, 2011/5/30 Frederik Ramm frede...@remote.org wrote: Hi, On 05/30/11 17:19, Peter Körner wrote: ... Wouldn't it be more logical to trick the rendering system to use the pgsnapshot tables? I think that all depends on what you want to do with your system. A rendering system that uses

Re: [OSM-dev] Planet file Import OOM kills postgres

2011-05-29 Thread Stefan Keller
I think we've got similar problems with osm2psql recently - even in slim-mode and with a relatively medium sized OSM country (Switzerland). But I have to check for the exact command line first. Yours, Stefan 2011/5/25 Frederik Ramm frede...@remote.org: Hi, Stefan Menzel wrote: i am trying

[OSM-dev] osm2pgsql: missing osm_polygon and osm_line data under PostgreSQL 9/PostGIS 1.5.2

2011-05-06 Thread Stefan Keller
Hi, We recently upgraded to PostgreSQL 9 and PostGIS 1.5.2 and hence were forced to rebuild osm2pgsql because of new versions of its dependencies (e.g., libgeos). Afterwards, we tried to insert Switzerland data with the following command: $ osm2pgsql --create --database gisdb --prefix osm

Re: [OSM-dev] Why there is no data in building_indoor_to_indoor table?

2011-03-18 Thread Stefan Keller
Hi Vanu Could you give little more info about what is missing where? Yours, S. OpenStreetMap-in-a-Box Demo: http://geometa.hsr.ch/map/ 2011/3/16 venugopal palapala venu56go...@gmail.com: Hi, i am comparing with my osminabox setup data and opnstreetmap website. i see a difference when it

[OSM-dev] List of all point Point elements (symbols) displayed in Mapnik style?

2011-03-18 Thread Stefan Keller
Hi, I'd like to get a list of all Point elements (symbols) displayed in Mapnik style. When looking at http://svn.openstreetmap.org/applications/rendering/mapnik/osm.xml But only find few PointSymbolizer rules (/turning_circle-livs-fill.xxx.png). Am I looking at the wrong osm.xml? Yours, S.

Re: [OSM-dev] List of all point Point elements (symbols) displayed in Mapnik style?

2011-03-18 Thread Stefan Keller
with popup box! LG, S. 2011/3/18 Lennard l...@xs4all.nl: On 18-3-2011 12:30, Stefan Keller wrote: Hi, I'd like to get a list of all Point elements (symbols) displayed in Mapnik style. When looking at http://svn.openstreetmap.org/applications/rendering/mapnik/osm.xml But only find few

Re: [OSM-dev] OSM and CouchDB/GeoCouch

2011-01-22 Thread Stefan Keller
Hi Serge You wrote earlier: 2) We don't really have a universal benchmark. I've defined a generic spatial benchmark called HSR Texas Geo Database Benchmark: http://www.gis.hsr.ch/wiki/HSR_Texas_Geo_Database_Benchmark This includes scripts for PostGIS, Spatialite and GeoCouch. Feel free to add

Re: [OSM-dev] API 0.7 brainstorming

2010-12-29 Thread Stefan Keller
There is one single shortcoming: The lack of a first class element called (multi-)polygon. This hurts consistent and easy data acquisition from the users point of view as well as data managment. Yours, S. 2010/12/30 Simon Ward si...@bleah.co.uk: On Thu, Dec 30, 2010 at 12:05:12AM +0100,

[OSM-dev] Data overlay in Slippy Map: Why not display details immediately with object tags?

2010-12-23 Thread Stefan Keller
Hi, Does anybody know who programmed the Slippy Map web fontend, especially the nice new Data layer? I'd like to suggest the following: Why not display all details? The weblink Details could remain the same but renamed to Browse (object). I'm observing many users to search for the osm_id, click

Re: [OSM-dev] XAPI - Source code

2010-12-19 Thread Stefan Keller
Philipp, Ian @Philipp: Ian seems to begin a complete rewrite of XAPI. There seems to be only on implementation out there and at for some time least three well known installations. See also Frederiks answer recently. @Ian: Since you start programming: Did you verify/discuss with others the syntax

Re: [OSM-dev] API/XAPI caching proxy server

2010-12-16 Thread Stefan Keller
Rewriting xapi on the other hand is an excellent idea. Yes, good idea. I would probably start with osm2pgsql and setup a mirror (incuding hstore). Since osm2pgsql uses the PostGIS database I think it should'nt be too hard to turn predicates to WHERE clauses and bbox to a ST_Within query in

Re: [OSM-dev] API/XAPI caching proxy server

2010-12-16 Thread Stefan Keller
Hi Brett Thanks very much for your detailed instructions. In my experience the biggest limitation in performance is disk seeking, rather than the amount of data returned. If that's the bottleneck (or the amount of data returned before processing), then pl/pgsql or pl/python could help, since

Re: [OSM-dev] API/XAPI caching proxy server

2010-12-14 Thread Stefan Keller
But at least regarding XAPI (as indicated in the thread title) it's true: Although http://wiki.openstreetmap.org/wiki/Platform_Status indicates green/OK, my tests and the remarks at http://wiki.openstreetmap.org/wiki/Xapi#Servers tell me that there's currently no XAPI server answers in less than

Re: [OSM-dev] API/XAPI caching proxy server

2010-12-14 Thread Stefan Keller
the question arises, who uses XAPI anyhow? Do you have an overview of the main apps? Yours, S. 2010/12/15 Frederik Ramm frede...@remote.org: Hi, Stefan Keller wrote: But at least regarding XAPI (as indicated in the thread title) it's true: Although http://wiki.openstreetmap.org/wiki

Re: [OSM-dev] API/XAPI caching proxy server

2010-12-13 Thread Stefan Keller
Dear Wyo, Graham Jones wrote: Last time there was serious trouble with XAPI servers I started to think about setting up my own server (at least for a limited area), but got stuck with the technology that XAPI uses. We also looked at XAPI technology and I can confirm that it's a zoo of

Re: [OSM-dev] Multilingual Maps Overlays

2010-11-05 Thread Stefan Keller
Luxembourgish) How about this? -S. 2010/11/5 Pieren pier...@gmail.com: On Fri, Nov 5, 2010 at 2:02 AM, Stefan Keller sfkel...@gmail.com wrote: name=Strasbourg name:de=Straßburg name:gsw=Schdroosburi Is this example correct (especially name:gsw=Schdroosburi)? Yes and no. gsw is an iso

Re: [OSM-dev] Multilingual Maps Overlays

2010-11-05 Thread Stefan Keller
/6 Stefan Keller sfkel...@gmail.com: I have been convinced to use loc_name for alternate names the local people use which does not have the same etymology (history and origin of the word) as the name. The city of Luxembourg has a nice example of loc_name: name=Luxembourg name:lb=Lëtzebuerg

Re: [OSM-dev] Multilingual Maps Overlays

2010-11-04 Thread Stefan Keller
Ok; I'm getting it slowly... But still have definition problems. name=Strasbourg name:de=Straßburg name:gsw=Schdroosburi Is this example correct (especially name:gsw=Schdroosburi)? What about the loc_name: Is there there no loc_name or is it loc_name=Schdroosburi too? My problem is still

Re: [OSM-dev] Multilingual Maps Overlays

2010-11-02 Thread Stefan Keller
Hi Nice idea. I don't see any labels except those already rendered by Mapnik. I looked at osm-labes-de and -ch. 1. Can you give my an example Permalink? 2. Then I encountered a JavaScript problem (some CPU consuming endless loop) when trying to click and launch a Permalink. 3. And the

Re: [OSM-dev] Multilingual Maps Overlays

2010-11-02 Thread Stefan Keller
as labels dynamically as GeoJSON. * How to generate, display and control layers for local dialect names (Barça, Züri)? Yours, S. 2010/11/2 Peter Körner osm-li...@mazdermind.de: Am 02.11.2010 11:52, schrieb Stefan Keller: Hi Nice idea. I don't see any labels except those already rendered

Re: [OSM-dev] Any OpenStreetMap viewer for Android?

2009-09-28 Thread Stefan Keller
aren't. -S. 2009/9/28 John Smith deltafoxtrot...@gmail.com: 2009/9/28 Stefan Keller sfkel...@gmail.com: Am I right that there's no OpenStreetMap viewer software available for Viewer to do what? Android-based phones - at least no open source except AndNav2? Not all of AndNav2 is open source

Re: [OSM-dev] Any OpenStreetMap viewer for Android?

2009-09-28 Thread Stefan Keller
://code.google.com/p/osm-android/) and eventually AndNav2 of which we'll have a closer look. Yours, S. 2009/9/28 Eric Marsden eric.mars...@free.fr: sk == Stefan Keller sfkel...@gmail.com writes:  sk Am I right that there's no OpenStreetMap viewer software available for  sk Android-based phones

[OSM-dev] Any OpenStreetMap viewer for Android?

2009-09-27 Thread Stefan Keller
Am I right that there's no OpenStreetMap viewer software available for Android-based phones - at least no open source except AndNav2? -S. BTW: Just saw this: Google’s Android-based devices made by companies such as Motorola and HTC are about to hit the market in large numbers in 2010.

[OSM-dev] Tool to convert KML to OSM?

2009-05-13 Thread Stefan Keller
Hi all, Is there any tool (or XSLT file) which converts KML (points, linestrings, ev. polygons) to OSM format (XML)? Yours, S. P.S. The KML comes from own sources and does'nt originate from digitizing in Google Earth. ___ dev mailing list

  1   2   >