Vjylku

Do I need life insurance if I can cover my own funeral costs?

Existence of subset with given Hausdorff dimension

How to use deus ex machina safely?

Are there verbs that are neither telic, or atelic?

Unexpected result from ArcLength

How Could an Airship Be Repaired Mid-Flight

Most cost effective thermostat setting: consistent temperature vs. lowest temperature possible

What has been your most complicated TikZ drawing?

How to change two letters closest to a string and one letter immediately after a string using notepad++

What do Xenomorphs eat in the Alien series?

Can someone explain to me where this proof goes wrong? (Twin Prime Conjecture)

My Graph Theory Students

Does Mathematica reuse previous computations?

Why doesn't the EU now just force the UK to choose between referendum and no-deal?

Why Choose Less Effective Armour Types?

Life insurance that covers only simultaneous/dual deaths

How do anti-virus programs start at Windows boot?

Instead of Universal Basic Income, why not Universal Basic NEEDS?

Credit cards used everywhere in Singapore or Malaysia?

Is it normal that my co-workers at a fitness company criticize my food choices?

Why would a flight no longer considered airworthy be redirected like this?

Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?

Why do passenger jet manufacturers design their planes with stall prevention systems?

Science-fiction short story where space navy wanted hospital ships and settlers had guns mounted everywhere

Problem with checking for Valid Geometries for PostGIS in Azure

Ring Self-Intersections in PostGISProblem with ST_IsValid: Unknown geometry type: 9 - CompoundCurveAlternative to ST_Union/ST_MemUnion for merging overlapping polygons using PostGIS?Significant performance issues with PostGIS UnaryUnionEditable views in QGIS - update affects the wrong rowCompare only valid polygon geometries in PostGISGeography ST_Intersects causes “Boom! Could not generate outside point!”ST_MakeValid() leaving data unaltered?Checking for overlapping geometries in one table using PostGIS?PostGIS ST_Area causing error when used with “use_spheroid=false” setting, succeeds with spheroid

0

I have used this PostGIS in different environments many times without issue:

update my_table set geom = ST_MakeValid(geom) where ST_IsValid(geom) = false;

However in Azure I keep seeing the following response:

ERROR:  GEOS isvalid() threw an error!

This is using PostGIS 2.3.2 r15302 and GEOS 3.6.1-CAPI-1.10.1 r4317

In case it was because geom was null I tried the following:

update my_table set geom = ST_MakeValid(geom) 

where geom is not null and ST_IsValid(geom) = false;

However I get the same error.

The above was in psql. I tried DBeaver as well (I have given up on PgAdmin4) and there I see the following slightly different output:

SQL Error [XX000]: ERROR: GEOS isvalid() threw an error!

Googling GEOS threw an error seems to point to invalid geometries and suggests the user use ST_IsValid() but in this case that is the function causing the issue.

How do I fix the issue when ST_IsValid() itself throws an error?

Update:

Through searching through hundreds of thousands of entries in the table, I found two with errors.

If I try

update my_table set geom = ST_MakeValid(geom) where id in (1234, 5678)

then I see the following error

ERROR: GEOSisValid(): IllegalArgumentException: Exponent out of bounds

How do I fix either error?

azure postgis

share|improve this question

asked 13 hours ago

Ask613Ask613

1184

migrated from stackoverflow.com 5 mins ago

This question came from our site for professional and enthusiast programmers.

add a comment | 

0

I have used this PostGIS in different environments many times without issue:

update my_table set geom = ST_MakeValid(geom) where ST_IsValid(geom) = false;

However in Azure I keep seeing the following response:

ERROR:  GEOS isvalid() threw an error!

This is using PostGIS 2.3.2 r15302 and GEOS 3.6.1-CAPI-1.10.1 r4317

In case it was because geom was null I tried the following:

update my_table set geom = ST_MakeValid(geom) 

where geom is not null and ST_IsValid(geom) = false;

However I get the same error.

The above was in psql. I tried DBeaver as well (I have given up on PgAdmin4) and there I see the following slightly different output:

SQL Error [XX000]: ERROR: GEOS isvalid() threw an error!

Googling GEOS threw an error seems to point to invalid geometries and suggests the user use ST_IsValid() but in this case that is the function causing the issue.

How do I fix the issue when ST_IsValid() itself throws an error?

Update:

Through searching through hundreds of thousands of entries in the table, I found two with errors.

If I try

update my_table set geom = ST_MakeValid(geom) where id in (1234, 5678)

then I see the following error

ERROR: GEOSisValid(): IllegalArgumentException: Exponent out of bounds

How do I fix either error?

azure postgis

share|improve this question

asked 13 hours ago

Ask613Ask613

1184

migrated from stackoverflow.com 5 mins ago

This question came from our site for professional and enthusiast programmers.

add a comment | 

I have used this PostGIS in different environments many times without issue:

update my_table set geom = ST_MakeValid(geom) where ST_IsValid(geom) = false;

However in Azure I keep seeing the following response:

ERROR:  GEOS isvalid() threw an error!

This is using PostGIS 2.3.2 r15302 and GEOS 3.6.1-CAPI-1.10.1 r4317

In case it was because geom was null I tried the following:

update my_table set geom = ST_MakeValid(geom) 

where geom is not null and ST_IsValid(geom) = false;

However I get the same error.

The above was in psql. I tried DBeaver as well (I have given up on PgAdmin4) and there I see the following slightly different output:

SQL Error [XX000]: ERROR: GEOS isvalid() threw an error!

Googling GEOS threw an error seems to point to invalid geometries and suggests the user use ST_IsValid() but in this case that is the function causing the issue.

How do I fix the issue when ST_IsValid() itself throws an error?

Update:

Through searching through hundreds of thousands of entries in the table, I found two with errors.

If I try

update my_table set geom = ST_MakeValid(geom) where id in (1234, 5678)

then I see the following error

ERROR: GEOSisValid(): IllegalArgumentException: Exponent out of bounds

How do I fix either error?

azure postgis

share|improve this question

asked 13 hours ago

Ask613Ask613

1184

update my_table set geom = ST_MakeValid(geom) where ST_IsValid(geom) = false;

ERROR:  GEOS isvalid() threw an error!

update my_table set geom = ST_MakeValid(geom) 

where geom is not null and ST_IsValid(geom) = false;

SQL Error [XX000]: ERROR: GEOS isvalid() threw an error!

update my_table set geom = ST_MakeValid(geom) where id in (1234, 5678)

ERROR: GEOSisValid(): IllegalArgumentException: Exponent out of bounds

share|improve this question

asked 13 hours ago

Ask613Ask613

1184

share|improve this question

asked 13 hours ago

Ask613Ask613

1184

asked 13 hours ago

Ask613Ask613

1184

asked 13 hours ago

Ask613Ask613

1184