- render :text => doc.to_s
-
- #el1 = XML::Node.new 'node'
- #el1['id'] = self.id.to_s
- #el1['lat'] = self.latitude.to_s
- #el1['lon'] = self.longitude.to_s
- #Node.split_tags(el1, self.tags)
- #el1['visible'] = self.visible.to_s
- #el1['timestamp'] = self.timestamp.xmlschema
- #root << el1
- end
+ # get all the nodes
+ nodes = Node.find(:all, :conditions => ['latitude > ? AND longitude > ? AND latitude < ? AND longitude < ? AND visible = 1', min_lat, min_lon, max_lat, max_lon])
+
+ node_ids = nodes.collect {|node| node.id }
+ segments = Array.new
+ if node_ids.length > 0
+ node_ids_sql = "(#{node_ids.join(',')})"
+ # get the referenced segments
+ segments = Segment.find_by_sql "select * from current_segments where visible = 1 and (node_a in #{node_ids_sql} or node_b in #{node_ids_sql})"
+ end
+ # see if we have nay missing nodes
+ segments_nodes = segments.collect {|segment| segment.node_a }
+ segments_nodes += segments.collect {|segment| segment.node_b }
+
+ segments_nodes.uniq!
+
+ missing_nodes = segments_nodes - node_ids
+
+ # get missing nodes if there are any
+ nodes += Node.find(missing_nodes) if missing_nodes.length > 0