Posts tagged postgis

Updrading Postgresql 9.3 to 9.5 with Postgis.

April 29, 2016, 6:21 a.m. postgis , postgresql , pg_dump

encodings for database "postgres" do not match:  old "UTF8", new "SQL_ASCII"   can be overcome by using /usr/pgsql-9.5/bin/initdb -E 'UTF-8' 9.5 as mentioned in the manual. When you run pg_upgrade, you must provide the following information: &nbsp ...

Which PostGIS function to use?

May 16, 2015, 4:11 a.m. postgis , python , road.lk

Which PostGIS function or operator do you use if you wanted to find the overlap between different lines? There are several candidates with ~, && , ST_Overlaps and and ST_Intersect being amongst the most prominent. They all do the job in different way and take different amounts of time a ...