[osmosis-dev] Database is empty after five days of importing

2010-03-23 Thread Klemens Z
Hi, I made an import of the planet.osm file using osmosis - the process ran for about five days. Now it finished but effectively the postgresql database is empty. In the statistics I can see that Tuples inserted for the nodes table is 564,050,700 and the size is 117 GB. But there are no rows in

[OSM-dev] Vandalism how to proceed?

2010-03-23 Thread Apollinaris Schoell
any ideas on how to deal with vandalism of a technically skilled user? has the block user function ever be used? how would one request it. I know I can't just call for it without evidence but can't spend much time right now for documentation and explanation. conformation from other users … so

Re: [OSM-dev] Vandalism how to proceed?

2010-03-23 Thread John Smith
On 23 March 2010 17:26, Apollinaris Schoell ascho...@gmail.com wrote: has the block user function ever be used? There is debate over how much it would actually help, given that it's trivial to add another account and do more damage. If anyone want't to check it started with this changeset of

Re: [OSM-dev] Vandalism how to proceed?

2010-03-23 Thread Frederik Ramm
Apo, Apollinaris Schoell wrote: any ideas on how to deal with vandalism of a technically skilled user? What you have given us here is not really an example of vandalism. You seem to have someone who thinks that certain roads should rather be tertiary, and who writes arrogant e-mails. (But

Re: [OSM-dev] Vandalism how to proceed?

2010-03-23 Thread andrzej zaborowski
On 23 March 2010 08:57, John Smith deltafoxtrot...@gmail.com wrote: On 23 March 2010 17:44, Apollinaris Schoell ascho...@gmail.com wrote: I know. at least it could delay things a bit. You'd then have to keep tabs on multiple accounts, not that reverting wouldn't potentially cause the same

Re: [OSM-dev] Vandalism how to proceed?

2010-03-23 Thread Apollinaris Schoell
On 23 Mar 2010, at 1:27 , Frederik Ramm wrote: Apo, Apollinaris Schoell wrote: any ideas on how to deal with vandalism of a technically skilled user? What you have given us here is not really an example of vandalism. You seem to have someone who thinks that certain roads should rather

Re: [OSM-dev] Vandalism how to proceed?

2010-03-23 Thread Frederik Ramm
Hi, Apollinaris Schoell wrote: talk to someone who doesn't accept any inputs? I know of 2 others who contacted him but same response. Is it completely impossible that this guy is actually right - as far as you can be right in OSM? You seem to be very convinced that he isn't. I think we

Re: [OSM-dev] Vandalism how to proceed?

2010-03-23 Thread Andy Allan
On Tue, Mar 23, 2010 at 10:15 AM, Frederik Ramm frede...@remote.org wrote: As I said, a cursory glance at the edits in question does not show anything which is obviously wrong (viewed from a few 1000 miles away). You seem to be sure that he is wrong but you don't have the time or patience to

Re: [OSM-dev] [Imports] Inserting OSM data

2010-03-23 Thread Frederik Ramm
Hi, Jaak Laineste wrote: Just for the future APIs I suggest to give to original importer (or just editor) some kind of priority over the others. Like possibility to lock/protect some parts of the data. It could be done in several levels: 1) my inserted data (tag, node, relation, way - any

Re: [OSM-dev] [Imports] Inserting OSM data

2010-03-23 Thread jamesmikedup...@googlemail.com
On Tue, Mar 23, 2010 at 12:50 PM, Frederik Ramm frede...@remote.org wrote: Jaak Laineste wrote: 1) my inserted data (tag, node, relation, way - any of them) can be defined as private, nobody else can not even see it. 2) my data is protected - you can see, but not modify 3) my data has

[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] [Imports] Inserting OSM data

2010-03-23 Thread John Robert Peterson
I've long considered that it would be good to have a system whereby anyone modifying a specified subset of the database would be presented with a message for them to read before comitting. This would be implemented with a special key that all editing software would be encouraged to support. In

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

[OSM-dev] Tile stitcher?

2010-03-23 Thread Alan Mintz
I've slowly been gathering USGS urban tiles for the areas in which I'm mapping (taking care not to bog down the server) with the ultimate goal of having a backup tileserver, since the MSRMaps.com (fka Terraservice.net) server seems to be poorly supported and is prone to long periods of

Re: [OSM-dev] Tile stitcher?

2010-03-23 Thread John Smith
On 24 March 2010 12:32, Alan Mintz alan_mintz+...@earthlink.net wrote: I've slowly been gathering USGS urban tiles for the areas in which I'm mapping (taking care not to bog down the server) with the ultimate goal of having a backup tileserver, since the MSRMaps.com (fka Terraservice.net)

Re: [OSM-dev] Removing Minutely and Hourly Changesets

2010-03-23 Thread Bernhard zwischenbrugger
hi I just noticed, that the minute diffs are not here anymore. My tool http://datenkueche.com/osmlive did use this files. Is there a possibility to find a file if I have only the time? For the old system I used: $delta=(int) $_GET['delta']; $time1=time()-7200-360 -$delta;