# ===========================

# insert into evidencias

INSERT INTO evidencias (nome_evidencia, id_token_tipo_de_evidencia, id_token_tipo_de_veiculo, latitude, longitude, data, time_stamp) VALUES 
("Teste", (select id_chave_token from tokens where nome_token = "análise"), (select id_chave_token from tokens where nome_token="SEI"), 45.47803790, 9.22070440, "2024-01-18", "2024-01-17 20:57:51.641751");





# ===========================

# insert into autores_evidencias




# ===========================

# insert into evidencias_tipos_de_identificadores




# ===========================

# insert into enderecos_do_OSM

NULL



# ===========================

# insert into enderecos_evidencias

INSERT INTO enderecos_evidencias (id_evidencia, id_endereco_do_OSM, time_stamp) VALUES 
((select id_chave_evidencia from evidencias where nome_evidencia="Teste" and data="2024-01-18"), (select id_chave_endereco_do_OSM from enderecos_do_OSM where osm_type = "way" and osm_id = "40123601" and class = "amenity"), "2024-01-17 20:57:54");


