...
import file and seup schema like
+ set timestamp to mark as time fieldtimestamp
+ add semantic type lat => http://www.w3.org/2003/01/geo:lat and geo:long ti the lat lng values/wgs84_pos#lat
+ add semantic type long => http://www.w3.org/2003/01/geo/wgs84_pos#long
Image Added
Image Removed
| View file |
|---|
| name | petrolstationsjts_points.csv |
|---|
| height | 150250 |
|---|
|
Pipeline
Result
| geomWKT | houseNumbe | id | isOpenplace | postCode | street | 1668543732028| 1676139041911 | 4326 | POINT (8.375062 49.0113144) |
12G | 1c9212bc-bf5e-424d-a1f5-5b628dc146b5 | true | 49.011314392089844 | 8.375061988830566 |
Karlsruhe | 76133.0 | Kaiserallee | 1668543732031| 1676139041914 | 4326 | POINT (8.4322996 49.0334015) |
542ba4c08-7be7-4460-9c9d-0602b762d862 | false | | 49.03340148925781 | 8.432299613952637 |
Karlsruhe | 76139.0 | Königsberger Str. | 1668543732033 | | 1676139041915 | 4326 | POINT (8.3494587 48.9985352) |
349739128e-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.Tests
Performance