1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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'),
|
