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 | geometry | lat | lng |
1676139041911 | 4326 | POINT (8.375062 49.0113144) | 49.011314392089844 | 8.375061988830566 |
1676139041914 | 4326 | POINT (8.4322996 49.0334015) | 49.03340148925781 | 8.432299613952637 |
1676139041915 | 4326 | POINT (8.3494587 48.9985352) | 48.99853515625 | 8.349458694458008 |