/// <summary> /// Moves to the next object. /// </summary> /// <returns></returns> public override bool MoveNext() { if (!_include_extra_mode) { // just go over all nodes and ways. if (this.Source.MoveNext()) { bool finished = false; bool is_in = false; // move to the next object of the current type. while (this.Current().Type != _current_type) { if (!this.Source.MoveNext()) { finished = true; break; } } if (!finished) { while (this.Current().Type == _current_type && !is_in) { SimpleOsmGeo current = this.Source.Current(); is_in = this.IsInBB(current); // check and keep the extras. if (is_in) { // add to the actual in-boundingbox indexes. switch (current.Type) { case SimpleOsmGeoType.Node: _nodes_in.Add(current.Id.Value); break; case SimpleOsmGeoType.Way: _ways_in.Add(current.Id.Value); break; case SimpleOsmGeoType.Relation: _relation_in.Add(current.Id.Value); break; } break; } // move to the next object of the current type. if (!this.Source.MoveNext()) { finished = true; break; } while (this.Current().Type != _current_type) { if (!this.Source.MoveNext()) { finished = true; break; } } // stop when finished. if (finished) { break; } } } if (!finished && this.Current().Type == _current_type) { // nothing was finished and the types match. return true; } } // switch to the next mode. switch (_current_type) { case SimpleOsmGeoType.Node: this.Source.Reset(); _current_type = SimpleOsmGeoType.Way; return this.MoveNext(); case SimpleOsmGeoType.Way: this.Source.Reset(); _current_type = SimpleOsmGeoType.Relation; return this.MoveNext(); case SimpleOsmGeoType.Relation: this.Source.Reset(); _include_extra_mode = true; return this.MoveNext(); } throw new InvalidOperationException("Unkown SimpleOsmGeoType"); } else { while (this.Source.MoveNext()) { switch (this.Source.Current().Type) { case SimpleOsmGeoType.Node: if (_nodes_to_include.Contains(this.Source.Current().Id.Value)) { if (!_nodes_in.Contains(this.Source.Current().Id.Value)) { return true; } } break; case SimpleOsmGeoType.Way: if (_ways_to_include.Contains(this.Source.Current().Id.Value)) { if (!_ways_in.Contains(this.Source.Current().Id.Value)) { return true; } } break; case SimpleOsmGeoType.Relation: if (_relations_to_include.Contains(this.Source.Current().Id.Value)) { if (!_relation_in.Contains(this.Source.Current().Id.Value)) { return true; } } break; } //this.Source.MoveNext(); } return false; } }
/// <summary> /// Resets this filter. /// </summary> public override void Reset() { _ways_in.Clear(); _nodes_in.Clear(); _current_type = SimpleOsmGeoType.Node; _include_extra_mode = false; this.Source.Reset(); }
private bool MoveNextWay() { if (_way_reader == null) { OracleCommand way_command = new OracleCommand("select * from way order by id"); way_command.Connection = _connection; _way_reader = way_command.ExecuteReader(); if (!_way_reader.Read()) { _way_reader.Close(); } OracleCommand way_tag_command = new OracleCommand("select * from way_tags order by way_id"); way_tag_command.Connection = _connection; _way_tag_reader = way_tag_command.ExecuteReader(); if (!_way_tag_reader.IsClosed && !_way_tag_reader.Read()) { _way_tag_reader.Close(); } OracleCommand way_node_command = new OracleCommand("select * from way_nodes order by way_id,sequence_id"); way_node_command.Connection = _connection; _way_node_reader = way_node_command.ExecuteReader(); if (!_way_node_reader.IsClosed && !_way_node_reader.Read()) { _way_node_reader.Close(); } } // read next way. if (!_way_reader.IsClosed) { // load/parse data. long id = _way_reader.GetInt64(0); long changeset_id = _way_reader.GetInt64(1); DateTime timestamp = _way_reader.GetDateTime(2); bool visible = _way_reader.GetInt64(3) == 1; long version = _way_reader.GetInt64(4); string user = _way_reader.GetString(5); long uid = _way_reader.GetInt64(6); SimpleWay way = new SimpleWay(); way.Id = id; way.ChangeSetId = changeset_id; way.TimeStamp = timestamp; way.UserId = uid; way.UserName = user; way.Version = (ulong)version; way.Visible = visible; if (!_way_tag_reader.IsClosed) { long returned_id = _way_tag_reader.GetInt64(_way_tag_reader.GetOrdinal("way_id")); while (returned_id == way.Id.Value) { if (way.Tags == null) { way.Tags = new Dictionary<string, string>(); } string key = _way_tag_reader.GetString(1); string value = _way_tag_reader.GetString(2); way.Tags.Add(key, value); if (!_way_tag_reader.Read()) { _way_tag_reader.Close(); returned_id = -1; } else { returned_id = _way_tag_reader.GetInt64(0); } } } if (!_way_node_reader.IsClosed) { long returned_id = _way_node_reader.GetInt64(_way_node_reader.GetOrdinal("way_id")); while (returned_id == way.Id.Value) { if (way.Nodes == null) { way.Nodes = new List<long>(); } long node_id = _way_node_reader.GetInt64(1); way.Nodes.Add(node_id); if (!_way_node_reader.Read()) { _way_node_reader.Close(); returned_id = -1; } else { returned_id = _way_node_reader.GetInt64(0); } } } // set the current variable! _current = way; // advance the reader(s). if (!_way_reader.Read()) { _way_reader.Close(); } if (!_way_tag_reader.IsClosed && !_way_tag_reader.Read()) { _way_tag_reader.Close(); } if (!_way_node_reader.IsClosed && !_way_node_reader.Read()) { _way_node_reader.Close(); } return true; } else { _way_reader.Close(); _way_reader.Dispose(); _way_reader = null; _way_tag_reader.Close(); _way_tag_reader.Dispose(); _way_tag_reader = null; _current_type = SimpleOsmGeoType.Relation; return false; } }
/// <summary> /// Initialiers this oracle source. /// </summary> public override void Initialize() { _connection = new OracleConnection(_connection_string); _connection.Open(); _current = null; _current_type = SimpleOsmGeoType.Node; _node_reader = null; _node_tag_reader = null; }
private bool MoveNextNode() { if (_node_reader == null) { OracleCommand node_command = new OracleCommand("select * from node order by id"); node_command.Connection = _connection; _node_reader = node_command.ExecuteReader(); if (!_node_reader.Read()) { _node_reader.Close(); } OracleCommand node_tag_command = new OracleCommand("select * from node_tags order by node_id"); node_tag_command.Connection = _connection; _node_tag_reader = node_tag_command.ExecuteReader(); if (!_node_tag_reader.Read()) { _node_tag_reader.Close(); } } // read next node. if (!_node_reader.IsClosed) { // load/parse data. long id = _node_reader.GetInt64(0); long latitude_int = _node_reader.GetInt64(1); long longitude_int = _node_reader.GetInt64(2); long changeset_id = _node_reader.GetInt64(3); bool visible = _node_reader.GetInt64(4) == 1; DateTime timestamp = _node_reader.GetDateTime(5); long tile = _node_reader.GetInt64(6); long version = _node_reader.GetInt64(7); string user = _node_reader.GetString(8); long uid = _node_reader.GetInt64(9); SimpleNode node = new SimpleNode(); node.Id = id; node.Latitude = latitude_int; node.Longitude = longitude_int; node.ChangeSetId = changeset_id; node.TimeStamp = timestamp; node.UserId = null; node.UserName = null; node.Version = (ulong)version; node.Visible = visible; node.UserName = user; node.UserId = uid; if (!_node_tag_reader.IsClosed) { long returned_id = _node_tag_reader.GetInt64(0); while (returned_id == node.Id.Value) { if (node.Tags == null) { node.Tags = new Dictionary<string, string>(); } string key = _node_tag_reader.GetString(1); string value = _node_tag_reader.GetString(2); node.Tags.Add(key, value); if (!_node_tag_reader.Read()) { _node_tag_reader.Close(); } returned_id = _node_tag_reader.GetInt64(0); } } // set the current variable! _current = node; // advance the reader(s). if (!_node_reader.Read()) { _node_reader.Close(); } if (!_node_tag_reader.IsClosed && !_node_tag_reader.Read()) { _node_tag_reader.Close(); } return true; } else { _node_reader.Close(); _node_reader.Dispose(); _node_reader = null; _node_tag_reader.Close(); _node_tag_reader.Dispose(); _node_tag_reader = null; _current_type = SimpleOsmGeoType.Way; return false; } }
private bool MoveNextRelation() { if (_relation_reader == null) { OracleCommand relation_command = new OracleCommand("select * from relation order by id"); relation_command.Connection = _connection; _relation_reader = relation_command.ExecuteReader(); if (!_relation_reader.Read()) { _relation_reader.Close(); } OracleCommand relation_tag_command = new OracleCommand("select * from relation_tags order by relation_id"); relation_tag_command.Connection = _connection; _relation_tag_reader = relation_tag_command.ExecuteReader(); if (!_relation_tag_reader.IsClosed && !_relation_tag_reader.Read()) { _relation_tag_reader.Close(); } OracleCommand relation_node_command = new OracleCommand("select * from relation_members order by relation_id,sequence_id"); relation_node_command.Connection = _connection; _relation_member_reader = relation_node_command.ExecuteReader(); if (!_relation_member_reader.IsClosed && !_relation_member_reader.Read()) { _relation_member_reader.Close(); } } // read next relation. if (!_relation_reader.IsClosed) { // load/parse data. long id = _relation_reader.GetInt64(0); long changeset_id = _relation_reader.GetInt64(1); DateTime timestamp = _relation_reader.GetDateTime(2); bool visible = _relation_reader.GetInt64(3) == 1; long version = _relation_reader.GetInt64(4); string user = _relation_reader.GetString(5); long uid = _relation_reader.GetInt64(6); SimpleRelation relation = new SimpleRelation(); relation.Id = id; relation.ChangeSetId = changeset_id; relation.TimeStamp = timestamp; relation.UserId = null; relation.UserName = null; relation.Version = (ulong)version; relation.Visible = visible; relation.UserName = user; relation.UserId = uid; if (!_relation_tag_reader.IsClosed) { long returned_id = _relation_tag_reader.GetInt64(0); while (returned_id == relation.Id.Value) { if (relation.Tags == null) { relation.Tags = new Dictionary<string, string>(); } string key = _relation_tag_reader.GetString(1); string value = _relation_tag_reader.GetString(2); relation.Tags.Add(key, value); if (!_relation_tag_reader.Read()) { _relation_tag_reader.Close(); returned_id = -1; } else { returned_id = _relation_tag_reader.GetInt64(0); } } } if (!_relation_member_reader.IsClosed) { long returned_id = _relation_member_reader.GetInt64(0); while (returned_id == relation.Id.Value) { if (relation.Members == null) { relation.Members = new List<SimpleRelationMember>(); } string member_type = _relation_member_reader.GetString(1); long member_id = _relation_member_reader.GetInt64(2); object member_role = _relation_member_reader.GetValue(3); SimpleRelationMember member = new SimpleRelationMember(); member.MemberId = member_id; if (member_role != DBNull.Value) { member.MemberRole = member_role as string; } switch (member_type) { case "Node": member.MemberType = SimpleRelationMemberType.Node; break; case "Way": member.MemberType = SimpleRelationMemberType.Way; break; case "Relation": member.MemberType = SimpleRelationMemberType.Relation; break; } relation.Members.Add(member); if (!_relation_member_reader.Read()) { _relation_member_reader.Close(); returned_id = -1; } else { returned_id = _relation_member_reader.GetInt64(0); } } } // set the current variable! _current = relation; // advance the reader(s). if (!_relation_reader.Read()) { _relation_reader.Close(); } if (!_relation_tag_reader.IsClosed && !_relation_tag_reader.Read()) { _relation_tag_reader.Close(); } if (!_relation_member_reader.IsClosed && !_relation_member_reader.Read()) { _relation_member_reader.Close(); } return true; } else { _relation_reader.Close(); _relation_reader.Dispose(); _relation_reader = null; _relation_tag_reader.Close(); _relation_tag_reader.Dispose(); _relation_tag_reader = null; _current_type = SimpleOsmGeoType.Relation; return false; } }
/// <summary> /// Raises the chance event. /// </summary> /// <param name="type"></param> /// <param name="object_type"></param> /// <param name="id"></param> private void RaiseChange(SimpleChangeType type, SimpleOsmGeoType object_type, long id) { if (Change != null) { Change(type, object_type, id); } }
/// <summary> /// Resets the current source. /// </summary> public override void Reset() { _current = null; _current_type = SimpleOsmGeoType.Node; if (_node_reader != null) { _node_reader.Close(); _node_reader.Dispose(); _node_reader = null; } if (_node_tag_reader != null) { _node_tag_reader.Close(); _node_tag_reader.Dispose(); _node_tag_reader = null; } }
/// <summary> /// Resets this filter. /// </summary> public override void Reset() { _current_type = SimpleOsmGeoType.Node; this.Source.Reset(); }
/// <summary> /// Returns a filter that filters on type. /// </summary> /// <param name="type"></param> /// <returns></returns> public static Filter Type(SimpleOsmGeoType type) { return new FilterType(type); }
/// <summary> /// Move to the next object. /// </summary> /// <returns></returns> public override bool MoveNext() { if (this.Source.MoveNext()) { bool finished = false; while (this.Current().Type != _current_type) { if (!this.Source.MoveNext()) { finished = true; break; } } if (!finished && this.Current().Type == _current_type) { return true; } } switch (_current_type) { case SimpleOsmGeoType.Node: this.Source.Reset(); _current_type = SimpleOsmGeoType.Way; return this.MoveNext(); case SimpleOsmGeoType.Way: this.Source.Reset(); _current_type = SimpleOsmGeoType.Relation; return this.MoveNext(); case SimpleOsmGeoType.Relation: return false; } throw new InvalidOperationException("Unkown SimpleOsmGeoType"); }
/// <summary> /// Creates a new filter type. /// </summary> /// <param name="type"></param> internal FilterType(SimpleOsmGeoType type) { _type = type; }
private bool MoveNextWay() { if (_wayReader == null) { SQLiteCommand way_command = new SQLiteCommand("select * from way where id > 26478817 order by id"); way_command.Connection = _connection; _wayReader = way_command.ExecuteReader(); if (!_wayReader.Read()) { _wayReader.Close(); } SQLiteCommand way_tag_command = new SQLiteCommand("select * from way_tags where way_id > 26478817 order by way_id"); way_tag_command.Connection = _connection; _wayTagReader = way_tag_command.ExecuteReader(); if (!_wayTagReader.IsClosed && !_wayTagReader.Read()) { _wayTagReader.Close(); } SQLiteCommand way_node_command = new SQLiteCommand("select * from way_nodes where way_id > 26478817 order by way_id,sequence_id"); way_node_command.Connection = _connection; _wayNodeReader = way_node_command.ExecuteReader(); if (!_wayNodeReader.IsClosed && !_wayNodeReader.Read()) { _wayNodeReader.Close(); } } // read next way. if (!_wayReader.IsClosed) { SimpleWay way = new SimpleWay(); way.Id = _wayReader.GetInt64(0); way.ChangeSetId = _wayReader.GetInt64(1); way.TimeStamp = _wayReader.IsDBNull(3) ? DateTime.MinValue : _wayReader.GetDateTime(3); //way.UserId = _way_reader.GetInt64(6); //way.UserName = _way_reader.GetString(5); way.Version = (ulong)_wayReader.GetInt64(4); way.Visible = _wayReader.GetInt64(2) == 1; if (!_wayTagReader.IsClosed) { long returned_id = _wayTagReader.GetInt64(_wayTagReader.GetOrdinal("way_id")); while (returned_id == way.Id.Value) { if (way.Tags == null) { way.Tags = new Dictionary<string, string>(); } string key = _wayTagReader.GetString(1); string value = _wayTagReader.GetString(2); way.Tags.Add(key, value); if (!_wayTagReader.Read()) { _wayTagReader.Close(); returned_id = -1; } else { returned_id = _wayTagReader.GetInt64(0); } } } if (!_wayNodeReader.IsClosed) { long returned_id = _wayNodeReader.GetInt64(_wayNodeReader.GetOrdinal("way_id")); while (returned_id == way.Id.Value) { if (way.Nodes == null) { way.Nodes = new List<long>(); } long node_id = _wayNodeReader.GetInt64(1); way.Nodes.Add(node_id); if (!_wayNodeReader.Read()) { _wayNodeReader.Close(); returned_id = -1; } else { returned_id = _wayNodeReader.GetInt64(0); } } } // set the current variable! _current = way; // advance the reader(s). if (!_wayReader.Read()) { _wayReader.Close(); } if (!_wayTagReader.IsClosed && !_wayTagReader.Read()) { _wayTagReader.Close(); } if (!_wayNodeReader.IsClosed && !_wayNodeReader.Read()) { _wayNodeReader.Close(); } return true; } else { _wayReader.Close(); _wayReader.Dispose(); _wayReader = null; _wayTagReader.Close(); _wayTagReader.Dispose(); _wayTagReader = null; _currentType = SimpleOsmGeoType.Relation; return false; } }
private bool MoveNextNode() { if (_nodeReader == null) { SQLiteCommand node_command = new SQLiteCommand("select * from node left join node_tags on node_tags.node_id = node.id order by node.id"); node_command.Connection = _connection; _nodeReader = node_command.ExecuteReader(); if (!_nodeReader.Read()) _nodeReader.Close(); } // read next node. if (!_nodeReader.IsClosed) { // load/parse data. SimpleNode node = new SimpleNode(); node.Id = _nodeReader.GetInt64(0); node.Latitude = _nodeReader.GetInt64(1)/10000000.0; node.Longitude = _nodeReader.GetInt64(2)/10000000.0; node.ChangeSetId = _nodeReader.GetInt64(3); node.TimeStamp = _nodeReader.GetDateTime(5); node.Version = (ulong) _nodeReader.GetInt64(7); node.Visible = _nodeReader.GetInt64(4) == 1; //node.UserName = _node_reader.GetString(8); //node.UserId = _node_reader.IsDBNull(9) ? -1 : _node_reader.GetInt64(9); //Has tags? if (!_nodeReader.IsDBNull(10)) { //if (node.Tags == null) //node.Tags = new Dictionary<string, string>(); long currentnode = node.Id.Value; while(currentnode == node.Id.Value){ //string key = _node_reader.GetString(11); //string value = _node_reader.GetString(12); //node.Tags.Add(key, value); if (!_nodeReader.Read()) { _nodeReader.Close(); break; } currentnode = _nodeReader.GetInt64(0); } }else if (!_nodeReader.Read()) _nodeReader.Close(); // set the current variable! _current = node; return true; } _nodeReader.Close(); _nodeReader.Dispose(); _nodeReader = null; _currentType = SimpleOsmGeoType.Way; return false; }
/// <summary> /// Initializes this source. /// </summary> public override void Initialize() { _connection = new SQLiteConnection(_connectionString); _connection.Open(); _current = null; _currentType = SimpleOsmGeoType.Node; _nodeReader = null; }