diff options
Diffstat (limited to 'tests/insert-positions.sql')
| -rw-r--r-- | tests/insert-positions.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/tests/insert-positions.sql b/tests/insert-positions.sql new file mode 100644 index 0000000..c287f29 --- /dev/null +++ b/tests/insert-positions.sql @@ -0,0 +1,19 @@ +INSERT INTO positions (user_id, location, activity) +VALUES + (1, ST_GeogFromText('SRID=4326;POINT(11.3339 44.5010)'), 'Still'), + (2, ST_GeogFromText('SRID=4326;POINT(11.3565 44.4967)'), 'Still'), + (3, ST_GeogFromText('SRID=4326;POINT(11.3490 44.4958)'), 'InVehicle'), + (4, ST_GeogFromText('SRID=4326;POINT(11.3411 44.4952)'), 'Still'), + (5, ST_GeogFromText('SRID=4326;POINT(11.3439 44.4971)'), 'Walking'), + (6, ST_GeogFromText('SRID=4326;POINT(11.3403 44.4936)'), 'Running'), + (7, ST_GeogFromText('SRID=4326;POINT(11.3485 44.4969)'), 'InVehicle'), + (8, ST_GeogFromText('SRID=4326;POINT(11.3442 44.4932)'), 'Still'), + (9, ST_GeogFromText('SRID=4326;POINT(11.3465 44.4978)'), 'Walking'), + (10, ST_GeogFromText('SRID=4326;POINT(11.3453 44.4941)'), 'Running'), + (11, ST_GeogFromText('SRID=4326;POINT(11.3155 44.5313)'), 'InVehicle'), + (12, ST_GeogFromText('SRID=4326;POINT(11.5789 44.5246)'), 'Still'), + (13, ST_GeogFromText('SRID=4326;POINT(11.7339 44.2956)'), 'Walking'), + (14, ST_GeogFromText('SRID=4326;POINT(11.2258 44.6452)'), 'Running'), + (15, ST_GeogFromText('SRID=4326;POINT(11.0708 44.5426)'), 'InVehicle'); + (16, ST_GeogFromText('SRID=4326;POINT(11.3426 44.4949)'), 'Walking'), + (17, ST_GeogFromText('SRID=4326;POINT(11.3450 44.4965)'), 'Running'), |