Vjylku

Aging parents with no investments

What is the closest word meaning "respect for time / mindful"

Deal with toxic manager when you can't quit

Why do UK politicians seemingly ignore opinion polls on Brexit?

Am I thawing this London Broil safely?

What is the meaning of the verb "bear" in this context?

Can one be advised by a professor who is very far away?

What is the motivation for a law requiring 2 parties to consent for recording a conversation

Geography at the pixel level

Which Sci-Fi work first showed weapon of galactic-scale mass destruction?

Earliest use of the term "Galois extension"?

Apparent duplicates between Haynes service instructions and MOT

Why didn't the Event Horizon Telescope team mention Sagittarius A*?

Are there incongruent pythagorean triangles with the same perimeter and same area?

Right tool to dig six foot holes?

Did Section 31 appear in Star Trek: The Next Generation?

Protecting Dualbooting Windows from dangerous code (like rm -rf)

What did it mean to "align" a radio?

Identify boardgame from Big movie

Is three citations per paragraph excessive for undergraduate research paper?

Who coined the term "madman theory"?

What tool would a Roman-age civilization have for the breaking of silver and other metals into dust?

How to manage monthly salary

What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?

MySQL 8.0 Error Code: 3617. Latitude is out of range in function st_geomfromtext

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

First of all: Hello to everybody, this is my first post!

I have a problem creating spatial index in MySQL 8.0. Here the description:

1. I have a collection of several thousand species range maps (polygon & multi-polygon) which is provided by IUCN as a single shapefile.


2. I opened this shapefile in QGIS 3.6 and performed geometry check (Vector/Geometry Tools/Check validity).


3. All valid range maps have been exported into a new shapefile.


4. I imported this new shapefile into MySQL 8.0 via command line tool ogr2ogr.


5. For the ogr2ogr import I had to use the option "-skipfailures". Reason: ogr2ogr considered some of the range maps as invalid.


6. The remaining maps were imported into a MySQL table. And it seems all ok, at least you can run queries successfully. But the queries are slow, because MySQL always reads the whole table.


7. So I decided to create a spatial index and here the problem starts:

“03:10:32 UPDATE gis.all_reptiles_innodb SET SHAPE =
ST_GeomFromText(ST_AsText(shape), 4326) Error Code: 3617. Latitude
124.241900 is out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]. 0.000 sec”

A latitude of "124.241900" is obviously impossible, because latitude can only range from -90 and +90 degrees. It seems to happen quite often, that people mix up longitude (allowed range: -180 and +180 degrees) with latitude.

Additional information: QIS shows these properties for the shapefile:

“-181.5899672849999718,-54.0594466929999840 : 181.1581243180000911,71.1881355930000836”

Does somebody have an idea what went wrong and how I could prevent this error?

Something in the interaction between shapefile, QGIS, ogr2ogr and MySQL obviously caused problems. The map display in QGIS, however, seems to work fine.

I would like to import only valid maps into MySQL because I need the spatial data index. Without an index a single query takes >8 seconds and that is too slow.

Looking forward to your feedback!

qgis shapefile ogr2ogr mysql-spatial

share

asked 1 min ago

stssts

1

New contributor

sts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

First of all: Hello to everybody, this is my first post!

I have a problem creating spatial index in MySQL 8.0. Here the description:

1. I have a collection of several thousand species range maps (polygon & multi-polygon) which is provided by IUCN as a single shapefile.


2. I opened this shapefile in QGIS 3.6 and performed geometry check (Vector/Geometry Tools/Check validity).


3. All valid range maps have been exported into a new shapefile.


4. I imported this new shapefile into MySQL 8.0 via command line tool ogr2ogr.


5. For the ogr2ogr import I had to use the option "-skipfailures". Reason: ogr2ogr considered some of the range maps as invalid.


6. The remaining maps were imported into a MySQL table. And it seems all ok, at least you can run queries successfully. But the queries are slow, because MySQL always reads the whole table.


7. So I decided to create a spatial index and here the problem starts:

“03:10:32 UPDATE gis.all_reptiles_innodb SET SHAPE =
ST_GeomFromText(ST_AsText(shape), 4326) Error Code: 3617. Latitude
124.241900 is out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]. 0.000 sec”

A latitude of "124.241900" is obviously impossible, because latitude can only range from -90 and +90 degrees. It seems to happen quite often, that people mix up longitude (allowed range: -180 and +180 degrees) with latitude.

Additional information: QIS shows these properties for the shapefile:

“-181.5899672849999718,-54.0594466929999840 : 181.1581243180000911,71.1881355930000836”

Does somebody have an idea what went wrong and how I could prevent this error?

Something in the interaction between shapefile, QGIS, ogr2ogr and MySQL obviously caused problems. The map display in QGIS, however, seems to work fine.

I would like to import only valid maps into MySQL because I need the spatial data index. Without an index a single query takes >8 seconds and that is too slow.

Looking forward to your feedback!

qgis shapefile ogr2ogr mysql-spatial

share

asked 1 min ago

stssts

1

New contributor

sts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

First of all: Hello to everybody, this is my first post!

I have a problem creating spatial index in MySQL 8.0. Here the description:

1. I have a collection of several thousand species range maps (polygon & multi-polygon) which is provided by IUCN as a single shapefile.


2. I opened this shapefile in QGIS 3.6 and performed geometry check (Vector/Geometry Tools/Check validity).


3. All valid range maps have been exported into a new shapefile.


4. I imported this new shapefile into MySQL 8.0 via command line tool ogr2ogr.


5. For the ogr2ogr import I had to use the option "-skipfailures". Reason: ogr2ogr considered some of the range maps as invalid.


6. The remaining maps were imported into a MySQL table. And it seems all ok, at least you can run queries successfully. But the queries are slow, because MySQL always reads the whole table.


7. So I decided to create a spatial index and here the problem starts:

“03:10:32 UPDATE gis.all_reptiles_innodb SET SHAPE =
ST_GeomFromText(ST_AsText(shape), 4326) Error Code: 3617. Latitude
124.241900 is out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]. 0.000 sec”

A latitude of "124.241900" is obviously impossible, because latitude can only range from -90 and +90 degrees. It seems to happen quite often, that people mix up longitude (allowed range: -180 and +180 degrees) with latitude.

Additional information: QIS shows these properties for the shapefile:

“-181.5899672849999718,-54.0594466929999840 : 181.1581243180000911,71.1881355930000836”

Does somebody have an idea what went wrong and how I could prevent this error?

Something in the interaction between shapefile, QGIS, ogr2ogr and MySQL obviously caused problems. The map display in QGIS, however, seems to work fine.

I would like to import only valid maps into MySQL because I need the spatial data index. Without an index a single query takes >8 seconds and that is too slow.

Looking forward to your feedback!

qgis shapefile ogr2ogr mysql-spatial

share

asked 1 min ago

stssts

1

New contributor

sts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

stssts

1

New contributor

sts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

stssts

1

New contributor

sts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

stssts

1

New contributor

sts is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

stssts

1