User Jakub Kania

25 votes

Accepted

PostGIS Column has Z dimension but geometry does not

answered Aug 5, 2014 at 12:05

15 votes

Accepted

Creating polygons from gaps in PostGIS?

answered May 14, 2013 at 12:24

15 votes

Accepted

Creating line from points using PostGIS?

answered May 19, 2013 at 16:50

11 votes

PostGIS nearest points with ST_Distance, kNN

answered Feb 23, 2015 at 14:24

9 votes

Accepted

Drop M values from MULTIPOLYGON with PostGIS?

answered Oct 2, 2014 at 23:32

9 votes

PostGIS doesn't use spatial index with ST_Intersects

answered Jan 21, 2015 at 18:37

8 votes

Accepted

Postgis: aggregate function for intersection

answered Mar 27, 2013 at 20:13

6 votes

Accepted

Splitting line layer at polygon's boundary of polygon layer using PostGIS

answered Apr 2, 2013 at 22:41

6 votes

Accepted

PostGIS - How to do ST_UNION on each feature of a geojson FeatureCollection

answered Sep 17, 2014 at 16:38

5 votes

Start postgresql+postgis without installation on Windows

answered May 24, 2013 at 22:00

5 votes

Accepted

Mapping latlng values to a point on a HRAP grid

answered May 28, 2013 at 19:26

4 votes

Accepted

How to split a linestring every 1000 points in postgis

answered May 5, 2013 at 15:56

4 votes

Accepted

How do I convert MultiLines to MultiPolygons using Postgis

answered May 13, 2013 at 15:17

4 votes

Accepted

Finding points along a path

answered Sep 4, 2013 at 19:59

4 votes

Accepted

Nearest neighbour for every row

answered Sep 16, 2013 at 12:39

4 votes

Accepted

Computing altitude from contour table - slow ST_Dwithin query

answered Sep 27, 2013 at 12:04

4 votes

Accepted

Finding closest outside point to point inside polygon in PostGIS?

answered Aug 22, 2015 at 16:32

4 votes

Accepted

GeoDjango/PostGIS distance lookup not working

answered Aug 24, 2015 at 15:19

3 votes

Accepted

PostGIS - raster - get multiple values at once

answered Oct 31, 2015 at 19:48

3 votes

Using ST_Union to merge tables containing lines?

answered Apr 9, 2014 at 12:43

3 votes

Accepted

Improving speed on pgRouting on table update with many rows: faster to loop on each row than a table update call?

answered Jun 24, 2014 at 12:32

3 votes

PostgreSQL/PostGIS Geom to JSON with Inner Join to another table

answered Mar 4, 2015 at 9:21

3 votes

Find the area of points in PostGIS?

answered Apr 9, 2015 at 16:52

3 votes

Accepted

Running spatial query on huge table

answered May 11, 2015 at 15:05

3 votes

Accepted

Feeder bus service

answered Oct 11, 2013 at 12:33

3 votes

How to design a bus station query database schema?

answered Sep 9, 2013 at 12:36

3 votes

PostgreSQL Queries, how can I handle logic and complex mathematical functions to update a column

answered Oct 23, 2013 at 12:34

3 votes

Accepted

Can distance be calculated to destination feature based on attribute in source?

answered Nov 1, 2013 at 21:25

3 votes

Accepted

Accurate and fast nearest neighbour, which distance function should I use and how to it speed up?

answered Apr 14, 2013 at 10:28

3 votes

Accepted

How do I find the intersection of two polylines in PostGIS?

answered Jul 8, 2013 at 12:35

Stack Exchange Network

60 Answers

PostGIS Column has Z dimension but geometry does not

Creating polygons from gaps in PostGIS?

Creating line from points using PostGIS?

PostGIS nearest points with ST_Distance, kNN

Drop M values from MULTIPOLYGON with PostGIS?

PostGIS doesn't use spatial index with ST_Intersects

Postgis: aggregate function for intersection

Splitting line layer at polygon's boundary of polygon layer using PostGIS

PostGIS - How to do ST_UNION on each feature of a geojson FeatureCollection

Start postgresql+postgis without installation on Windows

Mapping latlng values to a point on a HRAP grid

How to split a linestring every 1000 points in postgis

How do I convert MultiLines to MultiPolygons using Postgis

Finding points along a path

Nearest neighbour for every row

Computing altitude from contour table - slow ST_Dwithin query

Finding closest outside point to point inside polygon in PostGIS?

GeoDjango/PostGIS distance lookup not working

PostGIS - raster - get multiple values at once

Using ST_Union to merge tables containing lines?

Improving speed on pgRouting on table update with many rows: faster to loop on each row than a table update call?

PostgreSQL/PostGIS Geom to JSON with Inner Join to another table

Find the area of points in PostGIS?

Running spatial query on huge table

Feeder bus service

How to design a bus station query database schema?

PostgreSQL Queries, how can I handle logic and complex mathematical functions to update a column

Can distance be calculated to destination feature based on attribute in source?

Accurate and fast nearest neighbour, which distance function should I use and how to it speed up?

How do I find the intersection of two polylines in PostGIS?