Background
Data Setup
import file and seup schema like
+ set timestamp to mark as timestamp
+ add semantic type lat => http://www.w3.org/2003/01/geo/wgs84_pos#lat
+ add semantic type long => http://www.w3.org/2003/01/geo/wgs84_pos#long
Pipeline
Result
timestamp | epsg | geomWKT | houseNumbe | id | isOpen | lat | lng | place | postCode | street |
1668543732028 | 4326 | POINT (8.375062 49.0113144) | 12G | 1c9212bc-bf5e-424d-a1f5-5b628dc146b5 | true | 49.011314392089844 | 8.375061988830566 | Karlsruhe | 76133.0 | Kaiserallee |
1668543732031 | 4326 | POINT (8.4322996 49.0334015) | 5 | 42ba4c08-7be7-4460-9c9d-0602b762d862 | false | 49.03340148925781 | 8.432299613952637 | Karlsruhe | 76139.0 | Königsberger Str. |
1668543732033 | 4326 | POINT (8.3494587 48.9985352) | 34 | 9739128e-e4dd-4dbf-bc9c-2bdd768c2f9a | true | 48.99853515625 | 8.349458694458008 | Karlsruhe | 76189.0 | Eichelbergstr. |
1668543732034 | 4326 | POINT (8.4052916 48.9660759) | 2 | 26a8cf8b-6dc6-40a5-a77a-35056bb03278 | true | 48.9660758972168 | 8.405291557312012 | Karlsruhe | 76199.0 | Battstr. |
1668543761914 | 4326 | POINT (8.3977394 49.015976) | 3 | 7c1efd63-be24-42d3-a638-14bcd28ceb5f | true | 49.01597595214844 | 8.39773941040039 | Karlsruhe | 76131.0 | Willy-Brandt-Allee |
1668543761916 | 4326 | POINT (8.4228497 49.0076294) | 46 | 8c34683e-aecb-45d8-bd38-f8356dd01ed2 | true | 49.00762939453125 | 8.422849655151367 | Karlsruhe | 76131.0 | Durlacher Allee |
1668543761918 | 4326 | POINT (8.4283371 48.9994202) | 46 | 5cb08765-da25-4bee-a118-a5710cb9aae5 | true | 48.999420166015625 | 8.428337097167969 | Karlsruhe | 76137.0 | Wolfartsweierer Str. |
1668543761923 | 4326 | POINT (8.3600721 48.9964943) | 16 | 4b85efa1-44d9-42f5-83d0-61745f958d11 | true | 48.99649429321289 | 8.360072135925293 | Karlsruhe | 76185.0 | Hardeckstraße |
1668543761926 | 4326.0 | POINT (8.3551998 49.0140991) | 90-92 | 3324d1a4-b89e-4373-8326-8a0717b9d29d | true | 49.01409912109375 | 8.355199813842773 | Karlsruhe | 76185.0 | Rheinstr. |
1668543761929 | 4326.0 | POINT (8.4564505 48.9970398) | 32 | 51d4b432-a095-1aa0-e100-80009459e03a | true | 48.997039794921875 | 8.456450462341309 | KARLSRUHE | 76227.0 | KILLISFELDSTR. |