Import Point Geo using CSV

Data Service
1

Hello
I have a CSV file where one of the colums in schema is set to Point WGS 84.
I have the value in the CSV file like this
{“type”:“Point”,“coordinates”:[49.043613,-122.35802]}

When I try to import , it gives me an error like this
Invalid GIS data provided to function st_geometryfromtext

What should I do to import that CSV file with Geo location

Thanks

2

Hi @Deress_Asghedom

The point column must be in the following format

POINT(49.043613 -122.35802)

Regards,
Vlad

3

Hello @Vladimir Upirov
it still didn’t work and I am getting the same error. Here is a sample CSV file I am uploading. Do you spot something incorrect here?
Stores.csv (1.0 KB)

4

Hi @Deress_Asghedom ,

It looks like you misplaced latitude and longitude in the point definition. Correct Point definition is next POINT(longitude latitude).

When I tried to insert your point ( POINT(53.5376706 -113.785303)) to the test table I got Latitude -113.785303 is out of range in function st_geometryfromtext. It must be within [-90.000000, 90.000000] error

But when I change point definition to POINT(-113.785303 53.5376706) then point was added successfully.

Regards, Andriy