Merge remote branch 'upstream/master'

Conflicts:
	src/nodejs/start.js

6 files changed, 837 insertions, 16 deletions

diff --git a/src/nodejs/no1.js b/src/nodejs/no1.js
new file mode 100644
index 0000000..1a250be
--- /dev/null
+++ b/src/nodejs/no1.js
@@ -0,0 +1,85 @@
+
+var clutch = require('clutch');
+var pg = require('pg')
+
+var connectionString = "pg://user:password@host/database";
+
+
+function createNodeBboxQuery(key, value, left, bottom, right, top) {
+	return "SELECT * from nodes WHERE (tags @> '\"" + key
+				+ "\"=>\"" + value + "\"'" +  
+				" AND POINT(geom) @ polygon(box('(" + left
+				 + "," + bottom +")'::point,'(" + 
+				+ right + "," + top + ")'::point)));";
+}
+
+
+
+function nodeWorldHandler(req, res, key, value) {
+
+    res.writeHead(200, {'Content-Type': 'text/plain'});
+    res.end(' key:' +key +' value:'+value+'\n');
+}
+function nodeBboxHandler(req, res, key, value, left, bottom, right, top) {
+	pg.connect(connectionString, function(err,client) {
+		
+		if (err) {
+			console.log(err);	
+		}
+		else {
+			console.log(createNodeBboxQuery(key, value, left, bottom, right, top));
+			/*client.query(createNodeBboxQuery(key, value, left, bottom, right, top), function(err,result) {
+				
+				if (err) {
+					console.log(err);
+				}
+				else {
+					console.log(result.rows);
+					for(row in result.rows.length) {
+						console.log(row);
+					}
+				}
+			});*/
+		}
+			
+		
+		
+	});
+	
+	
+	
+    res.writeHead(200, {'Content-Type': 'text/plain'});
+    res.end( 'bbox: '+ left + bottom + right + top + ' key:' +key +' value:'+value+'!\n');
+}
+
+function wayWorldHandler(req, res, key, value) {
+
+    res.writeHead(200, {'Content-Type': 'text/plain'});
+    res.end(' key:' +key +' value:'+value+'!\n');
+}
+function wayBboxHandler(req, res, key, value, bbox, left, bottom, right, top) {
+}
+
+function relationWorldHandler(req, res, key, value) {
+	
+    res.writeHead(200, {'Content-Type': 'text/plain'});
+    res.end(' key:' +key +' value:'+value+'!\n');
+}
+function relationBboxHandler(req, res, key, value, left, bottom, right, top) {
+
+}
+
+myRoutes = clutch.route404([
+				//['GET /api/(\\w+)(\\[bbox=(\\d,\\d,\\d,\\d)\\])*\\[(\\w+)=(\\w+)\\]$', helloSomeone],
+				['GET /api/node\\[(\\w+)=(\\w+)\\]$',nodeWorldHandler],
+				['GET /api/node\\[(\\w+)=(\\w+)\\]\\[bbox=(\\d+(\\.\\d+)?),(\\d+),(\\d+),(\\d+)\\]$',nodeBboxHandler],
+				['GET /api/node\\[(\\w+)=(\\w+)\\]\\[bbox=(\\d+\\.\\d+),(\\d+),(\\d+),(\\d+)\\]$',nodeBboxHandler],
+				['GET /api/way\\[(\\w+)=(\\w+)\\]$',wayWorldHandler],
+				['GET /api/way\\[(\\w+)=(\\w+)\\]\\[bbox=(\\d),(\\d),(\\d),(\\d)\\]$',wayBboxHandler],
+				['GET /api/relation\\[(\\w+)=(\\w+)\\]$',relationWorldHandler],
+				['GET /api/relation\\[(\\w+)=(\\w+)\\](\\[bbox=(\\d),(\\d),(\\d),(\\d)\\])$',relationBboxHandler],
+				]);
+
+
+var http = require('http');
+http.createServer(myRoutes).listen(8080, 'localhost');
diff --git a/src/nodejs/no2.js b/src/nodejs/no2.js
new file mode 100644
index 0000000..233b5e1
--- /dev/null
+++ b/src/nodejs/no2.js
@@ -0,0 +1,106 @@
+var users = [
+  { name: 'tj' },
+  { name: 'tim' }
+];
+
+function user(app) {
+  app.resource('/.:format?', {
+    'get' : function(req, res, next) {
+      switch (req.params.format) {
+        case 'json':
+          var body = JSON.stringify(users);
+          res.writeHead(200, {
+            'Content-Type': 'application/json',
+            'Content-Length': body.length
+          });
+          res.end(body);
+          break;
+        default:
+          var body = '<ul>'
+            + users.map(function(user) {
+            return '<li>' + user.name + '</li>';
+          }).join('\n')
+            + '</ul>';
+          res.writeHead(200, {
+            'Content-Type': 'text/html',
+            'Content-Length': body.length
+          });
+          res.end(body);
+      }
+    }
+  });
+
+  app.resource('/:id.:format', {
+    'get' : function(req, res, next) {
+      var user = users[req.params.id];
+      if (user && req.params.format === 'json') {
+        user = JSON.stringify(user);
+        res.writeHead(200, {
+          'Content-Type': 'application/json',
+          'Content-Length': user.length
+        });
+        res.end(user);
+      }
+      else {
+        // When true is passed, provide control
+        // back to middleware, skipping route
+        // match attemps
+        next(true);
+      }
+    }
+  })
+
+  app.resource('/\\[:id/:op?', {
+    'get' : function(req, res) {
+      var body = users[req.params.id]
+        ? users[req.params.id].name
+        : 'User ' + req.params.id + ' does not exist';
+      body = (req.params.op || 'view') + 'ing ' + body;
+      res.writeHead(200, {
+        'Content-Type': 'text/html',
+        'Content-Length': body.length
+      });
+      res.end(body, 'utf8');
+    }
+  })
+}
+
+
+function main(app) {
+  app.resource('/', {
+    'get' : function(req, res) {
+      var examples = [
+        '/users',
+        '/users.json',
+        '/users/0 (or /users/0/view)',
+        '/users/0/edit',
+        '/users/0.json'
+      ];
+      var body = 'Visit one of the following: <ul>'
+        + examples.map(function(str) {
+        return '<li>' + str + '</li>'
+      }).join('\n')
+        + '</ul>';
+      res.writeHead(200, {
+        'Content-Type': 'text/html',
+        'Content-Length': body.length
+      });
+      res.end(body, 'utf8');
+    }
+  });
+}
+
+
+var connect = require('connect');
+var resource = require('resource-router');
+
+var server = connect.createServer(
+    connect.logger({ buffer: true }),
+    connect.cache(),
+    connect.gzip()
+  );
+
+server.use('/users', resource(user));
+server.use(resource(main));
+server.listen(3000);
+console.log('Connect server listening on port 3000');
diff --git a/src/nodejs/start.js b/src/nodejs/start.js
index c664cfe..52c0748 100644
--- a/src/nodejs/start.js
+++ b/src/nodejs/start.js
@@ -34,24 +34,19 @@ function getDataBaseResult(tag,bbox,res) {
 
 function createQuery(tag,bbox){
     // FIXME: validate
-    // var table = tag[0] + "#" + tag[1];
-    // var filter = "";
-
-    // // input validation
-    // for(i=0;i<bbox.length;i++){
-    //     bbox[i] = parseFloat(bbox[i]);
-    // }
-
-    // if(bbox){
-    //     filter = "WHERE longitude > " + bbox[0] + " AND longitude < " + bbox[1] +
-    //              " AND latitude > " + bbox[2] + " AND latitude < " + bbox[3];
-    // }
+    var table = tag[0] + "#" + tag[1];
+    var filter = "";
 
+    // input validation
+    for(i=0;i<bbox.length;i++){
+        bbox[i] = parseFloat(bbox[i]);
+    }
 
-    return "SELECT id, tags, linestring \
-	    FROM ways \
-	    WHERE (tags @> '\"amenity\"=>\"pub\"' AND \
-		lseg(linestring) @ box('(13.0882097323,52.3418234221)'::point,'(13.7606105539,52.6697240587)'::point));"
+    if(bbox){
+        filter = "WHERE longitude > " + bbox[0] + " AND longitude < " + bbox[1] +
+                 " AND latitude > " + bbox[2] + " AND latitude < " + bbox[3];
+    } 
+    return "SELECT * FROM \"" + table + "\" " + filter + ";";
 }
 
 
diff --git a/src/sql/exampleDatabase.test b/src/sql/exampleDatabase.test
new file mode 100644
index 0000000..a585ea6
--- /dev/null
+++ b/src/sql/exampleDatabase.test
@@ -0,0 +1,17 @@
+CREATE TABLE "anamnity#pub" (
+        id bigint PRIMARY KEY,
+        longitude float4,
+        latitude float4,
+        object varchar);
+
+CREATE TABLE "highway#tohell" (
+        id bigint PRIMARY KEY,
+        longitude float4,
+        latitude float4,
+        object varchar);
+
+CREATE TABLE "anamnity#resturant" (
+        id bigint PRIMARY KEY,
+        longitude float4,
+        latitude float4,
+        object varchar);
diff --git a/src/sql/generateData.sh b/src/sql/generateData.sh
new file mode 100755
index 0000000..7c4276e
--- /dev/null
+++ b/src/sql/generateData.sh
@@ -0,0 +1,18 @@
+#! /bin/bash
+rm -f insert.sql
+touch insert.sql
+
+for i in `seq 1 100`; do 
+    echo "INSERT INTO \"anamnity#pub\" VALUES
+        ( $i , $i.5 , $i.7, 'pub nr $i'); " >> insert.sql
+done
+
+for i in `seq 1 100`; do 
+    echo "INSERT INTO \"highway#tohell\" VALUES
+        ( $i , $i.5 , $i.7, 'highway nr $i'); " >> insert.sql
+done
+
+for i in `seq 1 100`; do 
+    echo "INSERT INTO \"anamnity#resturant\" VALUES
+        ( $i , $i.5 , $i.7, 'restuarant nr $i'); " >> insert.sql
+done
diff --git a/src/sql/insert.sql b/src/sql/insert.sql
new file mode 100644
index 0000000..737d06f
--- /dev/null
+++ b/src/sql/insert.sql
@@ -0,0 +1,600 @@
+INSERT INTO "anamnity#pub" VALUES
+        ( 1 , 1.5 , 1.7, 'pub nr 1'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 2 , 2.5 , 2.7, 'pub nr 2'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 3 , 3.5 , 3.7, 'pub nr 3'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 4 , 4.5 , 4.7, 'pub nr 4'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 5 , 5.5 , 5.7, 'pub nr 5'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 6 , 6.5 , 6.7, 'pub nr 6'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 7 , 7.5 , 7.7, 'pub nr 7'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 8 , 8.5 , 8.7, 'pub nr 8'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 9 , 9.5 , 9.7, 'pub nr 9'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 10 , 10.5 , 10.7, 'pub nr 10'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 11 , 11.5 , 11.7, 'pub nr 11'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 12 , 12.5 , 12.7, 'pub nr 12'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 13 , 13.5 , 13.7, 'pub nr 13'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 14 , 14.5 , 14.7, 'pub nr 14'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 15 , 15.5 , 15.7, 'pub nr 15'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 16 , 16.5 , 16.7, 'pub nr 16'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 17 , 17.5 , 17.7, 'pub nr 17'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 18 , 18.5 , 18.7, 'pub nr 18'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 19 , 19.5 , 19.7, 'pub nr 19'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 20 , 20.5 , 20.7, 'pub nr 20'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 21 , 21.5 , 21.7, 'pub nr 21'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 22 , 22.5 , 22.7, 'pub nr 22'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 23 , 23.5 , 23.7, 'pub nr 23'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 24 , 24.5 , 24.7, 'pub nr 24'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 25 , 25.5 , 25.7, 'pub nr 25'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 26 , 26.5 , 26.7, 'pub nr 26'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 27 , 27.5 , 27.7, 'pub nr 27'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 28 , 28.5 , 28.7, 'pub nr 28'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 29 , 29.5 , 29.7, 'pub nr 29'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 30 , 30.5 , 30.7, 'pub nr 30'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 31 , 31.5 , 31.7, 'pub nr 31'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 32 , 32.5 , 32.7, 'pub nr 32'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 33 , 33.5 , 33.7, 'pub nr 33'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 34 , 34.5 , 34.7, 'pub nr 34'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 35 , 35.5 , 35.7, 'pub nr 35'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 36 , 36.5 , 36.7, 'pub nr 36'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 37 , 37.5 , 37.7, 'pub nr 37'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 38 , 38.5 , 38.7, 'pub nr 38'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 39 , 39.5 , 39.7, 'pub nr 39'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 40 , 40.5 , 40.7, 'pub nr 40'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 41 , 41.5 , 41.7, 'pub nr 41'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 42 , 42.5 , 42.7, 'pub nr 42'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 43 , 43.5 , 43.7, 'pub nr 43'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 44 , 44.5 , 44.7, 'pub nr 44'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 45 , 45.5 , 45.7, 'pub nr 45'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 46 , 46.5 , 46.7, 'pub nr 46'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 47 , 47.5 , 47.7, 'pub nr 47'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 48 , 48.5 , 48.7, 'pub nr 48'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 49 , 49.5 , 49.7, 'pub nr 49'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 50 , 50.5 , 50.7, 'pub nr 50'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 51 , 51.5 , 51.7, 'pub nr 51'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 52 , 52.5 , 52.7, 'pub nr 52'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 53 , 53.5 , 53.7, 'pub nr 53'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 54 , 54.5 , 54.7, 'pub nr 54'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 55 , 55.5 , 55.7, 'pub nr 55'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 56 , 56.5 , 56.7, 'pub nr 56'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 57 , 57.5 , 57.7, 'pub nr 57'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 58 , 58.5 , 58.7, 'pub nr 58'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 59 , 59.5 , 59.7, 'pub nr 59'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 60 , 60.5 , 60.7, 'pub nr 60'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 61 , 61.5 , 61.7, 'pub nr 61'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 62 , 62.5 , 62.7, 'pub nr 62'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 63 , 63.5 , 63.7, 'pub nr 63'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 64 , 64.5 , 64.7, 'pub nr 64'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 65 , 65.5 , 65.7, 'pub nr 65'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 66 , 66.5 , 66.7, 'pub nr 66'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 67 , 67.5 , 67.7, 'pub nr 67'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 68 , 68.5 , 68.7, 'pub nr 68'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 69 , 69.5 , 69.7, 'pub nr 69'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 70 , 70.5 , 70.7, 'pub nr 70'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 71 , 71.5 , 71.7, 'pub nr 71'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 72 , 72.5 , 72.7, 'pub nr 72'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 73 , 73.5 , 73.7, 'pub nr 73'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 74 , 74.5 , 74.7, 'pub nr 74'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 75 , 75.5 , 75.7, 'pub nr 75'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 76 , 76.5 , 76.7, 'pub nr 76'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 77 , 77.5 , 77.7, 'pub nr 77'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 78 , 78.5 , 78.7, 'pub nr 78'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 79 , 79.5 , 79.7, 'pub nr 79'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 80 , 80.5 , 80.7, 'pub nr 80'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 81 , 81.5 , 81.7, 'pub nr 81'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 82 , 82.5 , 82.7, 'pub nr 82'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 83 , 83.5 , 83.7, 'pub nr 83'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 84 , 84.5 , 84.7, 'pub nr 84'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 85 , 85.5 , 85.7, 'pub nr 85'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 86 , 86.5 , 86.7, 'pub nr 86'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 87 , 87.5 , 87.7, 'pub nr 87'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 88 , 88.5 , 88.7, 'pub nr 88'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 89 , 89.5 , 89.7, 'pub nr 89'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 90 , 90.5 , 90.7, 'pub nr 90'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 91 , 91.5 , 91.7, 'pub nr 91'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 92 , 92.5 , 92.7, 'pub nr 92'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 93 , 93.5 , 93.7, 'pub nr 93'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 94 , 94.5 , 94.7, 'pub nr 94'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 95 , 95.5 , 95.7, 'pub nr 95'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 96 , 96.5 , 96.7, 'pub nr 96'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 97 , 97.5 , 97.7, 'pub nr 97'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 98 , 98.5 , 98.7, 'pub nr 98'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 99 , 99.5 , 99.7, 'pub nr 99'); 
+INSERT INTO "anamnity#pub" VALUES
+        ( 100 , 100.5 , 100.7, 'pub nr 100'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 1 , 1.5 , 1.7, 'highway nr 1'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 2 , 2.5 , 2.7, 'highway nr 2'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 3 , 3.5 , 3.7, 'highway nr 3'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 4 , 4.5 , 4.7, 'highway nr 4'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 5 , 5.5 , 5.7, 'highway nr 5'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 6 , 6.5 , 6.7, 'highway nr 6'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 7 , 7.5 , 7.7, 'highway nr 7'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 8 , 8.5 , 8.7, 'highway nr 8'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 9 , 9.5 , 9.7, 'highway nr 9'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 10 , 10.5 , 10.7, 'highway nr 10'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 11 , 11.5 , 11.7, 'highway nr 11'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 12 , 12.5 , 12.7, 'highway nr 12'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 13 , 13.5 , 13.7, 'highway nr 13'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 14 , 14.5 , 14.7, 'highway nr 14'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 15 , 15.5 , 15.7, 'highway nr 15'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 16 , 16.5 , 16.7, 'highway nr 16'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 17 , 17.5 , 17.7, 'highway nr 17'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 18 , 18.5 , 18.7, 'highway nr 18'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 19 , 19.5 , 19.7, 'highway nr 19'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 20 , 20.5 , 20.7, 'highway nr 20'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 21 , 21.5 , 21.7, 'highway nr 21'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 22 , 22.5 , 22.7, 'highway nr 22'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 23 , 23.5 , 23.7, 'highway nr 23'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 24 , 24.5 , 24.7, 'highway nr 24'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 25 , 25.5 , 25.7, 'highway nr 25'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 26 , 26.5 , 26.7, 'highway nr 26'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 27 , 27.5 , 27.7, 'highway nr 27'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 28 , 28.5 , 28.7, 'highway nr 28'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 29 , 29.5 , 29.7, 'highway nr 29'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 30 , 30.5 , 30.7, 'highway nr 30'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 31 , 31.5 , 31.7, 'highway nr 31'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 32 , 32.5 , 32.7, 'highway nr 32'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 33 , 33.5 , 33.7, 'highway nr 33'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 34 , 34.5 , 34.7, 'highway nr 34'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 35 , 35.5 , 35.7, 'highway nr 35'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 36 , 36.5 , 36.7, 'highway nr 36'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 37 , 37.5 , 37.7, 'highway nr 37'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 38 , 38.5 , 38.7, 'highway nr 38'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 39 , 39.5 , 39.7, 'highway nr 39'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 40 , 40.5 , 40.7, 'highway nr 40'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 41 , 41.5 , 41.7, 'highway nr 41'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 42 , 42.5 , 42.7, 'highway nr 42'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 43 , 43.5 , 43.7, 'highway nr 43'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 44 , 44.5 , 44.7, 'highway nr 44'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 45 , 45.5 , 45.7, 'highway nr 45'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 46 , 46.5 , 46.7, 'highway nr 46'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 47 , 47.5 , 47.7, 'highway nr 47'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 48 , 48.5 , 48.7, 'highway nr 48'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 49 , 49.5 , 49.7, 'highway nr 49'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 50 , 50.5 , 50.7, 'highway nr 50'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 51 , 51.5 , 51.7, 'highway nr 51'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 52 , 52.5 , 52.7, 'highway nr 52'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 53 , 53.5 , 53.7, 'highway nr 53'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 54 , 54.5 , 54.7, 'highway nr 54'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 55 , 55.5 , 55.7, 'highway nr 55'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 56 , 56.5 , 56.7, 'highway nr 56'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 57 , 57.5 , 57.7, 'highway nr 57'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 58 , 58.5 , 58.7, 'highway nr 58'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 59 , 59.5 , 59.7, 'highway nr 59'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 60 , 60.5 , 60.7, 'highway nr 60'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 61 , 61.5 , 61.7, 'highway nr 61'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 62 , 62.5 , 62.7, 'highway nr 62'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 63 , 63.5 , 63.7, 'highway nr 63'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 64 , 64.5 , 64.7, 'highway nr 64'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 65 , 65.5 , 65.7, 'highway nr 65'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 66 , 66.5 , 66.7, 'highway nr 66'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 67 , 67.5 , 67.7, 'highway nr 67'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 68 , 68.5 , 68.7, 'highway nr 68'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 69 , 69.5 , 69.7, 'highway nr 69'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 70 , 70.5 , 70.7, 'highway nr 70'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 71 , 71.5 , 71.7, 'highway nr 71'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 72 , 72.5 , 72.7, 'highway nr 72'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 73 , 73.5 , 73.7, 'highway nr 73'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 74 , 74.5 , 74.7, 'highway nr 74'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 75 , 75.5 , 75.7, 'highway nr 75'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 76 , 76.5 , 76.7, 'highway nr 76'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 77 , 77.5 , 77.7, 'highway nr 77'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 78 , 78.5 , 78.7, 'highway nr 78'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 79 , 79.5 , 79.7, 'highway nr 79'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 80 , 80.5 , 80.7, 'highway nr 80'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 81 , 81.5 , 81.7, 'highway nr 81'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 82 , 82.5 , 82.7, 'highway nr 82'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 83 , 83.5 , 83.7, 'highway nr 83'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 84 , 84.5 , 84.7, 'highway nr 84'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 85 , 85.5 , 85.7, 'highway nr 85'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 86 , 86.5 , 86.7, 'highway nr 86'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 87 , 87.5 , 87.7, 'highway nr 87'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 88 , 88.5 , 88.7, 'highway nr 88'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 89 , 89.5 , 89.7, 'highway nr 89'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 90 , 90.5 , 90.7, 'highway nr 90'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 91 , 91.5 , 91.7, 'highway nr 91'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 92 , 92.5 , 92.7, 'highway nr 92'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 93 , 93.5 , 93.7, 'highway nr 93'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 94 , 94.5 , 94.7, 'highway nr 94'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 95 , 95.5 , 95.7, 'highway nr 95'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 96 , 96.5 , 96.7, 'highway nr 96'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 97 , 97.5 , 97.7, 'highway nr 97'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 98 , 98.5 , 98.7, 'highway nr 98'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 99 , 99.5 , 99.7, 'highway nr 99'); 
+INSERT INTO "highway#tohell" VALUES
+        ( 100 , 100.5 , 100.7, 'highway nr 100'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 1 , 1.5 , 1.7, 'restuarant nr 1'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 2 , 2.5 , 2.7, 'restuarant nr 2'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 3 , 3.5 , 3.7, 'restuarant nr 3'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 4 , 4.5 , 4.7, 'restuarant nr 4'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 5 , 5.5 , 5.7, 'restuarant nr 5'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 6 , 6.5 , 6.7, 'restuarant nr 6'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 7 , 7.5 , 7.7, 'restuarant nr 7'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 8 , 8.5 , 8.7, 'restuarant nr 8'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 9 , 9.5 , 9.7, 'restuarant nr 9'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 10 , 10.5 , 10.7, 'restuarant nr 10'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 11 , 11.5 , 11.7, 'restuarant nr 11'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 12 , 12.5 , 12.7, 'restuarant nr 12'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 13 , 13.5 , 13.7, 'restuarant nr 13'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 14 , 14.5 , 14.7, 'restuarant nr 14'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 15 , 15.5 , 15.7, 'restuarant nr 15'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 16 , 16.5 , 16.7, 'restuarant nr 16'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 17 , 17.5 , 17.7, 'restuarant nr 17'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 18 , 18.5 , 18.7, 'restuarant nr 18'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 19 , 19.5 , 19.7, 'restuarant nr 19'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 20 , 20.5 , 20.7, 'restuarant nr 20'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 21 , 21.5 , 21.7, 'restuarant nr 21'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 22 , 22.5 , 22.7, 'restuarant nr 22'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 23 , 23.5 , 23.7, 'restuarant nr 23'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 24 , 24.5 , 24.7, 'restuarant nr 24'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 25 , 25.5 , 25.7, 'restuarant nr 25'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 26 , 26.5 , 26.7, 'restuarant nr 26'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 27 , 27.5 , 27.7, 'restuarant nr 27'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 28 , 28.5 , 28.7, 'restuarant nr 28'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 29 , 29.5 , 29.7, 'restuarant nr 29'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 30 , 30.5 , 30.7, 'restuarant nr 30'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 31 , 31.5 , 31.7, 'restuarant nr 31'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 32 , 32.5 , 32.7, 'restuarant nr 32'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 33 , 33.5 , 33.7, 'restuarant nr 33'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 34 , 34.5 , 34.7, 'restuarant nr 34'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 35 , 35.5 , 35.7, 'restuarant nr 35'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 36 , 36.5 , 36.7, 'restuarant nr 36'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 37 , 37.5 , 37.7, 'restuarant nr 37'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 38 , 38.5 , 38.7, 'restuarant nr 38'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 39 , 39.5 , 39.7, 'restuarant nr 39'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 40 , 40.5 , 40.7, 'restuarant nr 40'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 41 , 41.5 , 41.7, 'restuarant nr 41'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 42 , 42.5 , 42.7, 'restuarant nr 42'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 43 , 43.5 , 43.7, 'restuarant nr 43'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 44 , 44.5 , 44.7, 'restuarant nr 44'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 45 , 45.5 , 45.7, 'restuarant nr 45'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 46 , 46.5 , 46.7, 'restuarant nr 46'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 47 , 47.5 , 47.7, 'restuarant nr 47'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 48 , 48.5 , 48.7, 'restuarant nr 48'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 49 , 49.5 , 49.7, 'restuarant nr 49'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 50 , 50.5 , 50.7, 'restuarant nr 50'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 51 , 51.5 , 51.7, 'restuarant nr 51'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 52 , 52.5 , 52.7, 'restuarant nr 52'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 53 , 53.5 , 53.7, 'restuarant nr 53'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 54 , 54.5 , 54.7, 'restuarant nr 54'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 55 , 55.5 , 55.7, 'restuarant nr 55'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 56 , 56.5 , 56.7, 'restuarant nr 56'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 57 , 57.5 , 57.7, 'restuarant nr 57'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 58 , 58.5 , 58.7, 'restuarant nr 58'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 59 , 59.5 , 59.7, 'restuarant nr 59'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 60 , 60.5 , 60.7, 'restuarant nr 60'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 61 , 61.5 , 61.7, 'restuarant nr 61'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 62 , 62.5 , 62.7, 'restuarant nr 62'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 63 , 63.5 , 63.7, 'restuarant nr 63'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 64 , 64.5 , 64.7, 'restuarant nr 64'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 65 , 65.5 , 65.7, 'restuarant nr 65'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 66 , 66.5 , 66.7, 'restuarant nr 66'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 67 , 67.5 , 67.7, 'restuarant nr 67'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 68 , 68.5 , 68.7, 'restuarant nr 68'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 69 , 69.5 , 69.7, 'restuarant nr 69'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 70 , 70.5 , 70.7, 'restuarant nr 70'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 71 , 71.5 , 71.7, 'restuarant nr 71'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 72 , 72.5 , 72.7, 'restuarant nr 72'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 73 , 73.5 , 73.7, 'restuarant nr 73'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 74 , 74.5 , 74.7, 'restuarant nr 74'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 75 , 75.5 , 75.7, 'restuarant nr 75'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 76 , 76.5 , 76.7, 'restuarant nr 76'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 77 , 77.5 , 77.7, 'restuarant nr 77'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 78 , 78.5 , 78.7, 'restuarant nr 78'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 79 , 79.5 , 79.7, 'restuarant nr 79'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 80 , 80.5 , 80.7, 'restuarant nr 80'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 81 , 81.5 , 81.7, 'restuarant nr 81'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 82 , 82.5 , 82.7, 'restuarant nr 82'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 83 , 83.5 , 83.7, 'restuarant nr 83'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 84 , 84.5 , 84.7, 'restuarant nr 84'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 85 , 85.5 , 85.7, 'restuarant nr 85'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 86 , 86.5 , 86.7, 'restuarant nr 86'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 87 , 87.5 , 87.7, 'restuarant nr 87'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 88 , 88.5 , 88.7, 'restuarant nr 88'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 89 , 89.5 , 89.7, 'restuarant nr 89'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 90 , 90.5 , 90.7, 'restuarant nr 90'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 91 , 91.5 , 91.7, 'restuarant nr 91'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 92 , 92.5 , 92.7, 'restuarant nr 92'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 93 , 93.5 , 93.7, 'restuarant nr 93'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 94 , 94.5 , 94.7, 'restuarant nr 94'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 95 , 95.5 , 95.7, 'restuarant nr 95'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 96 , 96.5 , 96.7, 'restuarant nr 96'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 97 , 97.5 , 97.7, 'restuarant nr 97'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 98 , 98.5 , 98.7, 'restuarant nr 98'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 99 , 99.5 , 99.7, 'restuarant nr 99'); 
+INSERT INTO "anamnity#resturant" VALUES
+        ( 100 , 100.5 , 100.7, 'restuarant nr 100');