get used to handle i/o errors. this is my experience
using ssd.
consider moving tables to hdd and indexes (and
primary keys) to ssd after processing your tasks.
martin
signature.asc
Description: This is a digitally signed message part.
___
dev maili
hi,
josm and rails port have different world parts. 65535 and 65536.
testing at bounds
for eg. at lon=180 we get different results, namely 65535 or 65536.
am I right?
look at this in quad_tile.rb
def self.tiles_for_area(bbox)
minx = ((bbox.min_lon + 180) * 65535 / 360).round
maxx =
hi,
1. "duplicate key value violates unique constraint" was a osmosis bug. its
fixed since 0.43.
2. i think dumping software like osmosis is responsible for dropping and
recreating indexes and rails just provides the schema.
martin
___
dev mailing l
On Sunday 07 April 2013 17:12:16 Peter K wrote:
Still don't get it. Why would this junction be a problem for you? The traffic
light is mapped only once on the road: For every combinations of directions
you'll get only one traffic signal. See
http://www.openstreetmap.org/edit?bbox=3.09915%2C50.9
On Sunday 07 April 2013 15:41:14 Peter K wrote:
> All the examples I mean are properly defined (Ie. only if you really
> cross the junction you'll pass a traffic signal, turning right is mapped
> as a separate lane without traffic light).
>
> So give us the concrete example you mean.
first abbrev
On Sunday 07 April 2013 14:05:44 Peter K wrote:
> IMO your step by step approach is not sufficient to work properly.
> You'll need a the driver's final destination and full path.
this app is not routing.
this app "just" provides speed and timing info of the next traffic signals even
if no path
On Saturday 06 April 2013 23:55:19 Peter K wrote:
> Martin,
>
> > routing is not enough
>
> Why not? I don't see your problem. Do you have an example?
>
i need a different routing namely:
give me the next traffic signals in my driving direction and a radius of 2 km.
this is already implemented
routing is not enough
martin
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev
On Saturday 06 April 2013 13:48:35 Shaun McDonald wrote:
> Are you sure you wouldn't be better making the edits directly in OSM instead
> of just locally?
I would like to, but I couldn't convince the (german) community to have
features like "green light optimal speed adivsory" (glosa) and "red l
On Saturday 06 April 2013 11:28:28 Tom Hughes wrote:
> Well you almost certainly don't want to use an API database to start
> with. You want to use a database whose schema is optimised for routing
> rather than for editing.
I want to (let) edit my data with josm and have all changes tracked.
The
On Friday 05 April 2013 22:43:45 you wrote:
> That said, it sounds like this can only happen when the database has
> been placed in an inconsistent state by importing data - the rails code
> would never allow such data to be created.
this guys in forum also tried to import data partially.
how c
found solution in forum.
http://forum.openstreetmap.org/viewtopic.php?id=7256
its a post from october 2011 and isn't commited yet?
--- a/app/models/relation.rb
+++ b/app/models/relation.rb
@@ -126,7 +126,7 @@ class Relation < ActiveRecord::Base
end
else
# otherwise, ma
hi,
can you help, i dont speak ruby.
the request was:
/api/0.6/map?bbox=10.532664,52.2265227,10.5389798,52.2296985
by josm
error in file: app/models/relation.rb
this error appears after a lot of sqls:
[2013-04-05 20:22:49.563787 #10382] API threw unexpected NoMethodError
exception: undefin
hi,
im trying to install my own osm server with api 0.6.
following instructions i stuck on database import.
http://wiki.openstreetmap.org/wiki/Rails_port#Database_tables
at this point all indexes and constraints are created before import.
Is this really the correct approach? indexes and const
> You can create a buffer (with ST_Buffer) around one geometry and then ..
> is a rather expensive operation, so it might be too slow for your use.
do prefilter result set by bbox to speed up
___
dev mailing list
dev@openstreetmap.org
http://lists.o
> Thanks a lot for the advice. The query as I previously mentioned it would
> be as simple as a "SELECT * FROM db WHERE X=X AND DISTANCE<5km". There
> wouldn't be more type of queries.
>
>
what happens if X=X matches the half database?
a lot of comparisons.
filter nodes by bbox
WHERE ST_Make
On Fri 14.12.2012 19:39:04 Ander Pijoan wrote:
> Hi all,
>
> I am starting to develope an application that needs of a spatial database.
>
> I'm almost sure that I will use PostGIS because it works great but taking
> into account that I will ONLY make querys to get a number of points near to
> a
17 matches
Mail list logo
