BEGIN TRANSACTION;
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612873693928 -3.6907012481242)', '2026-07-09 16:37:01', 18.400024414062, 0, 'deslocando'); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612878555432 -3.690700577572)', '2026-07-09 16:37:15', 18.599975585938, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612873693928 -3.6907012481242)'), GeomFromEWKT('SRID=4674;POINT (-38.612878555432 -3.690700577572)'))) / (select extract(epoch from '2026-07-09 16:37:15'::timestamp) - extract(epoch from '2026-07-09 16:37:01'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612873693928 -3.6907012481242)'), GeomFromEWKT('SRID=4674;POINT (-38.612878555432 -3.690700577572)'))) / (select extract(epoch from '2026-07-09 16:37:15'::timestamp) - extract(epoch from '2026-07-09 16:37:01'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612879393622 -3.6907013319433)', '2026-07-09 16:37:39', 18.400024414062, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612878555432 -3.690700577572)'), GeomFromEWKT('SRID=4674;POINT (-38.612879393622 -3.6907013319433)'))) / (select extract(epoch from '2026-07-09 16:37:39'::timestamp) - extract(epoch from '2026-07-09 16:37:15'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612878555432 -3.690700577572)'), GeomFromEWKT('SRID=4674;POINT (-38.612879393622 -3.6907013319433)'))) / (select extract(epoch from '2026-07-09 16:37:39'::timestamp) - extract(epoch from '2026-07-09 16:37:15'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612879980356 -3.6907042656094)', '2026-07-09 16:37:54', 18.400024414062, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612879393622 -3.6907013319433)'), GeomFromEWKT('SRID=4674;POINT (-38.612879980356 -3.6907042656094)'))) / (select extract(epoch from '2026-07-09 16:37:54'::timestamp) - extract(epoch from '2026-07-09 16:37:39'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612879393622 -3.6907013319433)'), GeomFromEWKT('SRID=4674;POINT (-38.612879980356 -3.6907042656094)'))) / (select extract(epoch from '2026-07-09 16:37:54'::timestamp) - extract(epoch from '2026-07-09 16:37:39'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612878471613 -3.6907054390758)', '2026-07-09 16:38:20', 18.400024414062, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612879980356 -3.6907042656094)'), GeomFromEWKT('SRID=4674;POINT (-38.612878471613 -3.6907054390758)'))) / (select extract(epoch from '2026-07-09 16:38:20'::timestamp) - extract(epoch from '2026-07-09 16:37:54'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612879980356 -3.6907042656094)'), GeomFromEWKT('SRID=4674;POINT (-38.612878471613 -3.6907054390758)'))) / (select extract(epoch from '2026-07-09 16:38:20'::timestamp) - extract(epoch from '2026-07-09 16:37:54'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612875621766 -3.6907097976655)', '2026-07-09 16:39:11', 18.799987792969, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612878471613 -3.6907054390758)'), GeomFromEWKT('SRID=4674;POINT (-38.612875621766 -3.6907097976655)'))) / (select extract(epoch from '2026-07-09 16:39:11'::timestamp) - extract(epoch from '2026-07-09 16:38:20'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612878471613 -3.6907054390758)'), GeomFromEWKT('SRID=4674;POINT (-38.612875621766 -3.6907097976655)'))) / (select extract(epoch from '2026-07-09 16:39:11'::timestamp) - extract(epoch from '2026-07-09 16:38:20'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612875873223 -3.6907114740461)', '2026-07-09 16:40:24', 19.200012207031, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612875621766 -3.6907097976655)'), GeomFromEWKT('SRID=4674;POINT (-38.612875873223 -3.6907114740461)'))) / (select extract(epoch from '2026-07-09 16:40:24'::timestamp) - extract(epoch from '2026-07-09 16:39:11'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612875621766 -3.6907097976655)'), GeomFromEWKT('SRID=4674;POINT (-38.612875873223 -3.6907114740461)'))) / (select extract(epoch from '2026-07-09 16:40:24'::timestamp) - extract(epoch from '2026-07-09 16:39:11'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612876376137 -3.6907122284174)', '2026-07-09 16:40:44', 19.400024414062, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612875873223 -3.6907114740461)'), GeomFromEWKT('SRID=4674;POINT (-38.612876376137 -3.6907122284174)'))) / (select extract(epoch from '2026-07-09 16:40:44'::timestamp) - extract(epoch from '2026-07-09 16:40:24'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612875873223 -3.6907114740461)'), GeomFromEWKT('SRID=4674;POINT (-38.612876376137 -3.6907122284174)'))) / (select extract(epoch from '2026-07-09 16:40:44'::timestamp) - extract(epoch from '2026-07-09 16:40:24'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612873442471 -3.6907115578651)', '2026-07-09 16:41:13', 19.799987792969, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612876376137 -3.6907122284174)'), GeomFromEWKT('SRID=4674;POINT (-38.612873442471 -3.6907115578651)'))) / (select extract(epoch from '2026-07-09 16:41:13'::timestamp) - extract(epoch from '2026-07-09 16:40:44'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612876376137 -3.6907122284174)'), GeomFromEWKT('SRID=4674;POINT (-38.612873442471 -3.6907115578651)'))) / (select extract(epoch from '2026-07-09 16:41:13'::timestamp) - extract(epoch from '2026-07-09 16:40:44'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612871179357 -3.6907129827887)', '2026-07-09 16:41:48', 20.200012207031, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612873442471 -3.6907115578651)'), GeomFromEWKT('SRID=4674;POINT (-38.612871179357 -3.6907129827887)'))) / (select extract(epoch from '2026-07-09 16:41:48'::timestamp) - extract(epoch from '2026-07-09 16:41:13'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612873442471 -3.6907115578651)'), GeomFromEWKT('SRID=4674;POINT (-38.612871179357 -3.6907129827887)'))) / (select extract(epoch from '2026-07-09 16:41:48'::timestamp) - extract(epoch from '2026-07-09 16:41:13'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612867658958 -3.690705774352)', '2026-07-09 16:42:17', 20.400024414062, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612871179357 -3.6907129827887)'), GeomFromEWKT('SRID=4674;POINT (-38.612867658958 -3.690705774352)'))) / (select extract(epoch from '2026-07-09 16:42:17'::timestamp) - extract(epoch from '2026-07-09 16:41:48'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612871179357 -3.6907129827887)'), GeomFromEWKT('SRID=4674;POINT (-38.612867658958 -3.690705774352)'))) / (select extract(epoch from '2026-07-09 16:42:17'::timestamp) - extract(epoch from '2026-07-09 16:41:48'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612859193236 -3.6907045170665)', '2026-07-09 16:42:40', 20.599975585938, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612867658958 -3.690705774352)'), GeomFromEWKT('SRID=4674;POINT (-38.612859193236 -3.6907045170665)'))) / (select extract(epoch from '2026-07-09 16:42:40'::timestamp) - extract(epoch from '2026-07-09 16:42:17'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612867658958 -3.690705774352)'), GeomFromEWKT('SRID=4674;POINT (-38.612859193236 -3.6907045170665)'))) / (select extract(epoch from '2026-07-09 16:42:40'::timestamp) - extract(epoch from '2026-07-09 16:42:17'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612859863788 -3.6907015834004)', '2026-07-09 16:43:01', 20.400024414062, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612859193236 -3.6907045170665)'), GeomFromEWKT('SRID=4674;POINT (-38.612859863788 -3.6907015834004)'))) / (select extract(epoch from '2026-07-09 16:43:01'::timestamp) - extract(epoch from '2026-07-09 16:42:40'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612859193236 -3.6907045170665)'), GeomFromEWKT('SRID=4674;POINT (-38.612859863788 -3.6907015834004)'))) / (select extract(epoch from '2026-07-09 16:43:01'::timestamp) - extract(epoch from '2026-07-09 16:42:40'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.61286053434 -3.6907035950571)', '2026-07-09 16:43:18', 20.400024414062, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612859863788 -3.6907015834004)'), GeomFromEWKT('SRID=4674;POINT (-38.61286053434 -3.6907035950571)'))) / (select extract(epoch from '2026-07-09 16:43:18'::timestamp) - extract(epoch from '2026-07-09 16:43:01'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.612859863788 -3.6907015834004)'), GeomFromEWKT('SRID=4674;POINT (-38.61286053434 -3.6907035950571)'))) / (select extract(epoch from '2026-07-09 16:43:18'::timestamp) - extract(epoch from '2026-07-09 16:43:01'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.61286229454 -3.6907022539526)', '2026-07-09 16:43:35', 20.599975585938, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.61286053434 -3.6907035950571)'), GeomFromEWKT('SRID=4674;POINT (-38.61286229454 -3.6907022539526)'))) / (select extract(epoch from '2026-07-09 16:43:35'::timestamp) - extract(epoch from '2026-07-09 16:43:18'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.61286053434 -3.6907035950571)'), GeomFromEWKT('SRID=4674;POINT (-38.61286229454 -3.6907022539526)'))) / (select extract(epoch from '2026-07-09 16:43:35'::timestamp) - extract(epoch from '2026-07-09 16:43:18'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
 INSERT INTO registro_rota_ponto (id, cod_registro_rota, geom, dat_registro_ponto, num_elevacao, velocidade, status) 
                VALUES (nextval('registro_rota_ponto_id_seq'), 47293, 'SRID=4674;POINT (-38.612861959264 -3.6907038465142)', '2026-07-09 16:43:42', 20.599975585938, (SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.61286229454 -3.6907022539526)'), GeomFromEWKT('SRID=4674;POINT (-38.612861959264 -3.6907038465142)'))) / (select extract(epoch from '2026-07-09 16:43:42'::timestamp) - extract(epoch from '2026-07-09 16:43:35'::timestamp)),  CASE WHEN ((SELECT ST_DistanceSphere(GeomFromEWKT('SRID=4674;POINT (-38.61286229454 -3.6907022539526)'), GeomFromEWKT('SRID=4674;POINT (-38.612861959264 -3.6907038465142)'))) / (select extract(epoch from '2026-07-09 16:43:42'::timestamp) - extract(epoch from '2026-07-09 16:43:35'::timestamp))) < 1 THEN  'pescando' ELSE 'deslocando' END ); 
COMMIT TRANSACTION;
