[osmosis-dev] Database is empty after five days of importing
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 it. select * from nodes; returns 0 rows. Can anybody tell me what happened? Thanks, Klemens ___ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev
[OSM-dev] Vandalism how to proceed?
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 some info when the admins are willing to consider a block will be appreciated. If anyone want't to check it started with this changeset of mass upgrades from residential to tertiary of approx 3500 roads http://www.openstreetmap.org/browse/changeset/3515112 http://www.openstreetmap.org/browse/changeset/3518792 http://www.openstreetmap.org/browse/changeset/3519089 I have started to write some tools to analyze the edits and come up with a more intelligent revert of defined tags across full history only but due to time constraints this isn't finished yet. also not sure how this will help as this user can simply use revert.pl again to revert all my changes blindly as he has done multiple times. multiple users have contacted this users but refuses to accept any other opinion, advice, discussion … one example below. discuss ideas on the lists first If I wished to discuss an idea, I might do so. However, I'm unlikely to do so on mailing lists, an outdated technology ill-suited to the task at hand. Regardless, I have yet to be convinced that there's anything to discuss, let alone that there's a need to have a discussion first, as if I need permission. but you think after a month you know all better? Of course I think I know better. I don't purport to know all better, so I do research areas of lighter knowledge. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Vandalism how to proceed?
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 mass upgrades from residential to tertiary of approx 3500 roads http://www.openstreetmap.org/browse/changeset/3515112 http://www.openstreetmap.org/browse/changeset/3518792 http://www.openstreetmap.org/browse/changeset/3519089 It might be easiest to just track his change sets and revert them... ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Vandalism how to proceed?
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 anyone can be made to write arrogant e-mails given the right input so this doesn't say much.) And while other vandals rarely bother to put proper changeset comments (or they write piss off and things like that), this guy explains what he is doing and why. He might still be wrong but at least he talks about it: http://www.openstreetmap.org/user/mk408/edits Unless this guy is really good at cloaking his vandalism, he looks like somebody who does a lot of work and who truly believes that he makes OSM better. It should be possible to engage him in a discussion. I do not know anything about the exchanges between him and the multiple users who contacted him, but does the possibility exist that these exchanges have perhaps been initiated in a way that put him in the defensive? You're telling us how you have spent time investigating and writing scripts and reverting his edits and all - but to be honest, from the information you have given us, it looks like more time should have been spent on the human side rather than on the technical side! I'd say calm down, go slow, try to talk to him - if he doesn't like mailing lists then ask him if he'd prefer a meeting in person or what. It's not like 3500 roads changed from residential to tertiary need to be fixed instantly - if we decide to change them back a few months from now we can still do it. Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09 E008°23'33 ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Vandalism how to proceed?
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 problem but it would take the abuser longer to figure this out. I suggest that Apollinaris asks the folks in power to set block to set a block on this user and wait for them to set the block, before reverting the changes. If the user opens new accounts then that is clearly ban evasion and he himself will at least realise he's doing something against the rules if he needs to go that far. how? as soon as multiple edits on a object are done a revert tool must know which versions of which tag to reset too. Another user could have done a useful edit in between. I think John meant something similar to what user:GeneralDreedle does (revert every 10 minutes automatically if it there haven't been ther user's edits in between) You need to do it as soon as possible to limit other people from updating things, you could track the minutely change files... I try to write tools to do it without creating more damage but this is really tricky. the programming part is really the simplest of it. Others have already written revert tools, I wouldn't suggest writing any more... To be really sure to revert things I'd need to go back analyze all his edits and the to see them all reverted the next day. this is way beyond the time I can spend. Others have already done this, why reinvent the wheel? Really? I haven't seen them. Cheers ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Vandalism how to proceed?
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 be tertiary, and who writes arrogant e-mails. (But anyone can be made to write arrogant e-mails given the right input so this doesn't say much.) don't have the time to explain all the reasons and analysis done so far if there is no chance that this will help in any way to stop this. Can't spend 24/7 on osm. I can as well give up on this area evan that I l live there Don't need a map or navigation here since I know how to come around and spend my time on more useful things in unmapped areas. And while other vandals rarely bother to put proper changeset comments (or they write piss off and things like that), this guy explains what he is doing and why. He might still be wrong but at least he talks about it: and this makes it so difficult to revert. I do not want to blindly revert things if some edits have been useful. http://www.openstreetmap.org/user/mk408/edits Unless this guy is really good at cloaking his vandalism, he looks like somebody who does a lot of work and who truly believes that he makes OSM better. It should be possible to engage him in a discussion. I do not know anything about the exchanges between him and the multiple users who contacted him, but does the possibility exist that these exchanges have perhaps been initiated in a way that put him in the defensive? I don't think so. there have been friendly emails from people more patient than me. but all responses are like this I am correct You're telling us how you have spent time investigating and writing scripts and reverting his edits and all - but to be honest, from the information you have given us, it looks like more time should have been spent on the human side rather than on the technical side! haven't finished the scripts for lack of time and difficulties to really define how data should be reverted without creating more damage in case other users have worked on different aspects of the same ways. just coming up with a criteria what needs to be reverted it requires analysis of the changes and then I can as well use josm to look at a way at a time instead writing scripts and again if there is no help in sight why should I spend hours to write it all up instead trying to fix things or don't care at all. I'd say calm down, go slow, try to talk to him - if he doesn't like mailing lists then ask him if he'd prefer a meeting in person or what. It's not like 3500 roads changed from residential to tertiary need to be fixed instantly - if we decide to change them back a few months from now we can still do it. talk to someone who doesn't accept any inputs? I know of 2 others who contacted him but same response. it's already 2 months it doesn't change. Again I can't spend as much time as this guy definitely can. reverting in a few months is practically impossible if a way has been edited may times after. ways are split, ways are merged. osm is a nightmare when it comes to deep history analysis. You or others might have better tools than revert.pl and if they are not published I can fully understand. But if they exist than it will be useful to know what evidence is required to document bad edits that anyone would be willing to share it or run it themselves. Honestly if I finish any of my scripts there will be very view trusted users I am willing to share it as any revert tool is a weapon in the hands of the wrong person. Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09 E008°23'33 ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Vandalism how to proceed?
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 would not hesitate to ban someone who continuously upgrades residentials to motorways. But I cannot see that this guy has done something that is *obviously* wrong. Even if this guy should erroneously upgrade residentials to tertiaries, this is in my eyes not something that does terrible damage to OSM and needs to be fixed urgently. I know you are a respected and active member of the OSM community but allow me to say that your writing style in this situation sounds a bit heated - so heated, in fact, that I would hesitate to trust you with a revert tool, and implore you not to continue writing code to combat this social problem. If, as you say, you do not have the time to investigate the situation properly then you should not revert this guy's edits. 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 explain why he is wrong. What kind of help can we offer you under these circumstances? Perhaps it would be helpful for someone who is not involved to talk to the guy and try to understand what he's doing and why, and then mediate. But that would also require you, or those who think the edits are wrong, to explain what exactly they believe to be wrong. Bye Frederik -- Frederik Ramm ## eMail frede...@remote.org ## N49°00'09 E008°23'33 ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Vandalism how to proceed?
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 explain why he is wrong. What kind of help can we offer you under these circumstances? Perhaps it would be helpful for someone who is not involved to talk to the guy and try to understand what he's doing and why, and then mediate. But that would also require you, or those who think the edits are wrong, to explain what exactly they believe to be wrong. I'll chip in here with the following observations, based purely on this email thread: Firstly, this is not vandalism. This is a dispute, and will be handled as such. To resolve the dispute, both sides need to make their case clear and public. I would implore you to set up a wiki page to give full details on the dispute. If you do not have time for this, then do not expect the dispute to be resolved. When the dispute has been thoroughly documented (with an explanation of both sides point of view) then the community can adjudicate. Whether that's 'normal people' or OSMF working groups or whatnot will remain to be seen. Preference will be given to the local communities point of view, if such can be shown. Finally, bans are there only to interrupt runaway processes and people - hence why they are of limited time. They are not intended to prohibit someone carrying out their actions, more to warn them that they may be inappropriate. They are most suited to bots. Since this guy has responded to discussion - even if he hasn't agreed with your point of view - a ban is inappropriate until the dispute process is followed. Cheers, Andy ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] [Imports] Inserting OSM data
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 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 group privacy/protection under my control: I can give view/ modify / delete permissions to specific users/groups These three are, in my opinion, not compatible with the spirit of OSM. If you want your own data, store it somewhere else ;-) 4) I can subscribe to notifications for any modifications of my data (this specific piece of it). So I could easily see and revert changes. This is widely demanded, and already partly implemented by XAPI. It is however not something that necessarily has to be a core service - anyone could implement it. Bye Frederik ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] [Imports] Inserting OSM data
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 group privacy/protection under my control: I can give view/ modify / delete permissions to specific users/groups These three are, in my opinion, not compatible with the spirit of OSM. If you want your own data, store it somewhere else ;-) Yes, as soon as you license your data under CC-SA you are explicitly allowing people to modify it. I think the whole idea of putting the data in osm is not just for making a pretty picture, but for contributing data for others to build upon. mike ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Query-Formats
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 queries like all highway=trunk and highway=primary with a name what is not possible with the current XAPI-Interface. So I was thinking about an XML-Based interface: query and typeline/type or bboxx1,y1,x2,y2/bbox bboxxx,yy1,xx2,yy2/bbox /or or tag k=highway v=primary / tag k=highway v=secondary / /or /and /query What do you think about it? I'd also implement a json-based interface in the same way. Do you agree with this kind of query or do you like the possibility to query via url? how would you like to supply ANDs and ORs then? what do you think about supplying a raw SQL-Where via URL? query.php?(tags ? 'name') AND (tags ? 'highway') AND ((tags-'highway' = 'primary') OR (tags-'highway' = secondary')) Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Query-Formats
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 ((tags-'highway' = 'primary') OR (tags-'highway' = secondary')) I think your example already answers the question: The query has to be formulated in a certain way for PostGIS to make proper use of the index, i.e. inside knowledge is required in order to write a query that doesn't break the system. This should not come from the outside. (In addition, I am sure that one could somehow insert a sub-query that would delete the database ;-) Bye Frederik ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Query-Formats
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 geometry in WKT then? I haven't thought about the result-format yet ;) I liked the GeoJSON way if one provides an XML query interface he should also be able to answer in xml, should he? (In addition, I am sure that one could somehow insert a sub-query that would delete the database ;-) Hmm, that's true.. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Query-Formats
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 type=way has-kv k=highway v=trunk/ has-kv k=name/ /query query type=way has-kv k=highway v=primary/ has-kv k=name/ /query /union print mode=body/ /osm-script in OSM3S. Bboxes for ways are possible but I haven't implemented them yet - things that happen if a lonely guy develops a full blown multi-purpose server. This specific query is quite slow, because it returns data from across the entire planet. what do you think about supplying a raw SQL-Where via URL? query.php?(tags ? 'name') AND (tags ? 'highway') AND ((tags-'highway' = 'primary') OR (tags-'highway' = secondary')) I have thought about that when designing the interface, but I think it will be close to impossible to avoid - extremely long running a resource intensive queries - malicious queries (simple example ...'; drop table *') because SQL is simply not designed for to be offered over the web. The second observation was that at least MySQL was way too slow to be useful - MySQL delivered about 10'000 nodes per minute, while OSM3S delivers roughly 1'000'000 to 2'000'000 nodes per minute (for a query with is spatially local, like downloading all data from a city or county). From that starting point it looks unlikely that another general purpose DB engine would have a satisfactory performance. Thus, I have preferred a query language with good predictability properties. See http://78.46.81.38/#chapter.concepts The server is productive and used for some services with the current language, but comment and also a deep refactoring of the language are welcome. Cheers, Roland ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Query-Formats
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 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. Could it be possible to make it work as Web Feature Service (WFS)? Then the users would have a bunch of ready made clients available and a possibility to combine OSM vectors with data from other WFS servers. A reference service is easy to set up: import some data with osm2pgsql, install Geoserver and publish osm_point, osm_line and osm_polygon tables through WFS. Even if we decide to use our own interface it is worth knowing how well some already existing systems work. I have been using the Finnish OSM data as demo layers with our WFS for a couple of years now. It suits very well for that purpose because there are points, lines and polygons and whole lot of attributes for building queries. However, I have never done any performance tests with OSM data and PostGIS before now because our real data come from Oracle. Here are the results from my very simple test. My WFS query was this: wget http://comp2.our_domain.fi:8080/geoserver/wfs?service=wfsversion=1.0.0; request=getfeaturetypename=topp:osm_line cql_filter=highway='unclassified'ANDname is null Geoserver supports CQL Filter syntax which is not according to WFS standard but much more comfortable to write by hand. So, no spatial filters in this query, only two attribute filters (unclassifield highways without names). Wget result was: 16,799,251 2.49M/s in 5.9s. Query took 5.9 seconds to perform, data transform rate as loose gml2 format was 2.49 megabytes per second and the result set seem to contain 16329 lines and 288283 vertices and all the attributes which osm2pgsql has imported. It makes roughly 2.8 million nodes per minute. Server is some 5 years old single processor 3 GHz Xeon with old time IDE disk and running on Windows XP. -Jukka Rahkonen- ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Query-Formats
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 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 queries like all highway=trunk and highway=primary with a name what is not possible with the current XAPI-Interface. So I was thinking about an XML-Based interface: query and typeline/type or bboxx1,y1,x2,y2/bbox bboxxx,yy1,xx2,yy2/bbox /or or tag k=highway v=primary / tag k=highway v=secondary / /or /and /query What do you think about it? I'd also implement a json-based interface in the same way. Do you agree with this kind of query or do you like the possibility to query via url? how would you like to supply ANDs and ORs then? what do you think about supplying a raw SQL-Where via URL? query.php?(tags ? 'name') AND (tags ? 'highway') AND ((tags- 'highway' = 'primary') OR (tags-'highway' = secondary')) Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] [Imports] Inserting OSM data
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 this case the message would read please don't delete my IDs It would also be useful in instances of unintentional vandalism, or that case where there was an edit war over some change of road layout between a local that knew the ground and a remote user with out of date yahoo data. Just a thought. JR On 23 March 2010 11:57, jamesmikedup...@googlemail.com jamesmikedup...@googlemail.com wrote: On Tue, Mar 23, 2010 at 12:50 PM, Frederik Ramm frede...@remote.orgwrote: 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 group privacy/protection under my control: I can give view/ modify / delete permissions to specific users/groups These three are, in my opinion, not compatible with the spirit of OSM. If you want your own data, store it somewhere else ;-) Yes, as soon as you license your data under CC-SA you are explicitly allowing people to modify it. I think the whole idea of putting the data in osm is not just for making a pretty picture, but for contributing data for others to build upon. mike ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Query-Formats
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 http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Query-Formats
-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 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. Stefan -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.14 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAkuo6+IACgkQYH1+F2Rqwn1pcgCeII38tygsDUNG7ZWyXB8GG9ql XKQAnRJY+kshsrnV/4R512jUHnjG4TgU =9qvQ -END PGP SIGNATURE- ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Tile stitcher?
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 blackout (like today) or other problems. Before I embark on the somewhat daunting project of a full-blown server, I just want to be able to stitch some of these 200x200 pixel, 0.25m/pixel images together into larger images that I can load as background in JOSM (using PicLayer). Is there a simple, hopefully command-line or config-file driven tool that I can use to generate a single JPEG from multiple JPEGs? What I've wasted time on so far are tools that are either intended to create panoramas, warping the images in the process, or random mosaic generators. Neither type of tool seems to be able to just line up images side-by-side. -- Alan Mintz alan_mintz+...@earthlink.net ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Tile stitcher?
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) server seems to be poorly supported and is prone to long periods of blackout (like today) or other problems. What about caching/proxy and/or setting up your own tile service? ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Removing Minutely and Hourly Changesets
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; $time2=time()-7200-300 -$delta; $time3=time()-7200-420 -$delta; $timestring1=date(YmdHi,$time1); $timestring2=date(YmdHi,$time2); $timestring3=date(YmdHi,$time3); $filename= $timestring1.-.$timestring2..osc.gz; -- Any idea how to do that with the new system? Bernhard Are there any objections to me disabling the old minute and hourly changesets and deleting their files from the planet server? http://planet.openstreetmap.org/minute/ http://planet.openstreetmap.org/minute-slow/ http://planet.openstreetmap.org/hourly/ They are replaced by the (hopefully) reliable transaction based replication changesets. http://planet.openstreetmap.org/minute-replicate/ http://planet.openstreetmap.org/hour-replicate/ I haven't heard any complaints about the replication changesets so I'm assuming they're working well. I'll leave the daily changesets running for now because they are running with a much longer delay and shouldn't miss data. I'm not aware of anybody still using the minute diffs. I'll disable them early in the new year. I won't delete the files straight away so they can be re-enabled if somebody suddenly screams. I hope to disable the hour diffs around the same time but will wait until Florian has moved off them first. Brett ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev