Re: [OSM-dev] Query-Formats

2010-03-24 Thread Peter Körner
The NYTimes version can't the Cherokee version can. And administration of 'certain query types' is usually not the idea of a public SQL interface. Anyway you could of course make a view on the data that only provides select capabilities. The problem is that the queries must be formated in a

Re: [OSM-dev] Query-Formats

2010-03-24 Thread Stefan de Konink
Solution: documentation. Stefan Op 24 mrt 2010 om 08:35 heeft Peter Körner osm-li...@mazdermind.de het volgende geschreven:\ The NYTimes version can't the Cherokee version can. And administration of 'certain query types' is usually not the idea of a public SQL interface. Anyway you

[OSM-dev] Query-Formats

2010-03-23 Thread Peter Körner
Hi On the osm dev-server we're playing around with the postgres-hstore extension which allows us to repond to xapi-like queries, but with already assembled LIESTRINGs and such neat things. I'm currently thinking about the interface on how to query this resource and i'd like to be able to ask

Re: [OSM-dev] Query-Formats

2010-03-23 Thread Frederik Ramm
Hi, Peter Körner wrote: So I was thinking about an XML-Based interface: I don't like XML but computers are said to like it. Would you return the geometry in WKT then? what do you think about supplying a raw SQL-Where via URL? query.php?(tags ? 'name') AND (tags ? 'highway') AND

Re: [OSM-dev] Query-Formats

2010-03-23 Thread Peter Körner
Frederik Ramm schrieb: Hi, Peter Körner wrote: So I was thinking about an XML-Based interface: I don't like XML but computers are said to like it. What dou you like better? The query could be re-formulated as json or even yaml. Would that solve you're concerns? Would you return the

Re: [OSM-dev] Query-Formats

2010-03-23 Thread Roland Olbricht
Hello, I'm currently thinking about the interface on how to query this resource and i'd like to be able to ask queries like all highway=trunk and highway=primary with a name what is not possible with the current XAPI-Interface. This would look like osm-script timeout=180 union query

Re: [OSM-dev] Query-Formats

2010-03-23 Thread Jukka Rahkonen
Peter Körner osm-lists at mazdermind.de writes: Hi On the osm dev-server we're playing around with the postgres-hstore extension which allows us to repond to xapi-like queries, but with already assembled LIESTRINGs and such neat things. I'm currently thinking about the interface on

Re: [OSM-dev] Query-Formats

2010-03-23 Thread Stefan de Konink
Just make a dbslayer interface, presented that last year on sotm. Stefan Op 23 mrt 2010 om 13:30 heeft Peter Körner osm-li...@mazdermind.de het volgende geschreven:\ Hi On the osm dev-server we're playing around with the postgres-hstore extension which allows us to repond to xapi-like

Re: [OSM-dev] Query-Formats

2010-03-23 Thread Peter Körner
Stefan de Konink schrieb: Just make a dbslayer interface, presented that last year on sotm. Can DBSlayer also query Postgresql? Can I intervent and only allow some query types? Peter ___ dev mailing list dev@openstreetmap.org

Re: [OSM-dev] Query-Formats

2010-03-23 Thread Stefan de Konink
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Op 23-03-10 16:51, Peter Körner schreef: Stefan de Konink schrieb: Just make a dbslayer interface, presented that last year on sotm. Can DBSlayer also query Postgresql? Can I intervent and only allow some query types? The NYTimes version