Timeline for ST_ReducePrecision PostGIS function throwing an error
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 30 at 20:34 | vote | accept | Sam | ||
| Aug 28 at 17:25 | comment | added | jbalk | en.wikipedia.org/wiki/Decimal_degrees | |
| Aug 28 at 7:37 | answer | added | Pieter | timeline score: 4 | |
| Aug 27 at 19:23 | comment | added | JGH | If you layer projection unit is in meters, then 0.0001 meters if pretty accurate and sufficient. If the projection unit is in degrees - as in your sample -, 0.0001 degree is very coarse (about 11m as Jbalk and Vince wrote). Your 1st polygon is about 6m on one side, which will collapse to a single point when using an 11 meters resolution, making it invalid. --> if you want to stick to a resolution of 0.0001 map unit then use another projection. Else, use a resolution of 0.0001 meters, which is roughly 0.000000001 map units | |
| Aug 27 at 18:48 | comment | added | Sam | @JGH Based on previous experience, using gridsize less than 0.0001 might cause arcmap to throw shape integrity error with the postgres connection, when reading the same layer on SQL Server, I encounter an error "The number of points is less than required for feature." | |
| Aug 27 at 18:41 | comment | added | Sam | @jbalk could you elaborate more how does reducing precision to 0.0001 move the vertices up to 11m and how does 0.0001 m translate to 9 decimals gridsize? | |
| Aug 27 at 17:59 | comment | added | JGH | @Sam the post you have linked didn't quote the doc properly. The distances are in "meters or its equivalent in map units" | |
| Aug 27 at 17:11 | comment | added | jbalk | It looks like your geometries are WGS 84 (srid 4326). Reducing precision to 0.0001 is moving your vertices up to 11m. My guess is that you're trying to set a tolerance of 0.0001 m? If so, you need a gridsize of about 9 decimals or 0.000000001. | |
| Aug 27 at 16:59 | comment | added | Sam | Shapes throw shape integrity error with lower precision while reading fine on QGIS .Reference I used for the limits: gis.stackexchange.com/questions/250165/… | |
| Aug 27 at 16:52 | history | edited | Sam | CC BY-SA 4.0 |
added 91 characters in body
|
| Aug 27 at 16:49 | comment | added | Vince | ArcMap doesn't need shapes stripped to four places of precision in decimal degrees (which is pretty coarse for geodata). ob xkcd | |
| Aug 27 at 16:47 | history | edited | Vince | CC BY-SA 4.0 |
naming
|
| S Aug 27 at 16:45 | review | First questions | |||
| Aug 27 at 18:53 | |||||
| S Aug 27 at 16:45 | history | asked | Sam | CC BY-SA 4.0 |