Douglas-Peucker is definitely the right approach. There are some simple ways to access implementations of it in PostGIS and QGIS that I thought I would add here for those who come across this post with a similar question. The goal is to start with something like this: and end up with something like this: In … Read more
I have worked with all three databases and done migrations between them, so hopefully I can still add something to an old post. Ten years ago I was tasked with putting a largish — 450 million spatial objects — dataset from GML to a spatial database. I decided to try out MySQL and Postgis, at … Read more
I had the same problem, but it was fixed by running following code CREATE EXTENSION postgis; In detail, open pgAdmin select (click) your database click “SQL” icon on the bar run “CREATE EXTENSION postgis;” code
You can use the data type point – combines (x,y) which can be your lat / long. Occupies 16 bytes: 2 float8 numbers internally. Or make it two columns of type float (= float8 or double precision). 8 bytes each. Or real (= float4) if additional precision is not needed. 4 bytes each. Or even … Read more
Since some of the functions depend on other libraries like GEOS and proj4 you might want to get their versions too. Then use: SELECT PostGIS_full_version();