From: Gabriel Ebner <gabriel@svn.openstreetmap.org>
Date: Sat, 22 Sep 2007 19:55:33 +0000 (+0000)
Subject: rails_port_0.5: Merge rails_port r4643
X-Git-Tag: live~8641^2~16
X-Git-Url: https://git.openstreetmap.org./rails.git/commitdiff_plain/e03ea17a227b09df70899b035680b51b3da2c61b

rails_port_0.5: Merge rails_port r4643
---

e03ea17a227b09df70899b035680b51b3da2c61b
diff --cc app/controllers/swf_controller.rb
index 6b29d1535,47ddcf902..40969c20f
--- a/app/controllers/swf_controller.rb
+++ b/app/controllers/swf_controller.rb
@@@ -89,14 -89,13 +89,13 @@@ class SwfController < ApplicationContro
  		# - Draw unwayed segments
  		
  		if params['unwayed']=='true'
- 			sql="SELECT cn1.latitude AS lat1,cn1.longitude AS lon1,"+
- 				"		cn2.latitude AS lat2,cn2.longitude AS lon2 "+
+ 			sql="SELECT cn1.latitude*0.0000001 AS lat1,cn1.longitude*0.0000001 AS lon1,"+
+ 				"		cn2.latitude*0.0000001 AS lat2,cn2.longitude*0.0000001 AS lon2 "+
  				"  FROM current_segments "+
 -				"       LEFT OUTER JOIN current_way_segments"+
 +				"       LEFT OUTER JOIN current_way_nodes"+
  				"       ON segment_id=current_segments.id,"+
  				"       current_nodes AS cn1,current_nodes AS cn2"+
- 				" WHERE (cn1.longitude BETWEEN #{xmin} AND #{xmax})"+
- 				"   AND (cn1.latitude  BETWEEN #{ymin} AND #{ymax})"+
+ 				" WHERE	"+OSM.sql_for_area(ymin,xmin,ymax,xmax,"cn1.")+
  				"   AND segment_id IS NULL"+
  				"   AND current_segments.visible=1"+
  				"   AND cn1.id=node_a AND cn1.visible=1"+