Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 960

A common GIS operation. Used to determine whether a point lies within a polygon's bounds.

2 votes

Creating evenly distributed points within an irregular boundary

You can do it in PostGIS with a query something like this: SELECT grid.the_geom FROM (select st_setsrid(st_point(x, y), polygon_srid) AS the_geom from (select generate_series(minX, maxX, grid_size) …
Nicklas Avén's user avatar
1 vote

Points in polygon by months

I think you should divide this in two separate things. First you have the calculations to find how many points you have in every polygon each month. The other part is the presentation, or report pa …
Nicklas Avén's user avatar
1 vote
Accepted

Postgis: Point-in-polygon check + feature attributes inheritance

Select points.*, polygons.* from points inner join polygons on st_intersects(points.geom,polygons.geom);
Nicklas Avén's user avatar
33 votes
Accepted

Counting Points in Polygon with PostGIS

SELECT grid.gid, count(kioskdhd3.geom) AS totale FROM grid LEFT JOIN kioskdhd3 ON st_contains(grid.geom,kioskdhd3.geom) GROUP BY grid.gid;
Nicklas Avén's user avatar
35 votes
Accepted

Creating regular point grid inside polygon in PostGIS

You do that with generate_series. If you don't want to manually write where the grid is to start and stop, the easiest is to create a function. I have not tested the below properly, but I think it sho …
Nicklas Avén's user avatar
1 vote

Point in polygon algorithm for multiple polygons

In postgis ST_Intersects uses indexes to first find if the point is inside the bounding box of the polygon and then makes a recheck to see if it really is inside the polygon. That is fast, often very …
Nicklas Avén's user avatar
3 votes

Creating polygons from one to many relationship of points using QGIS or PostGIS?

I think it sounds like what you want to do is a grouping on more than one field. you want to group the points by both their polygon belonging and their company belonging. If that is what you want it …
Nicklas Avén's user avatar
28 votes
Accepted

Point in Polygon analysis of 200 million points

ST_DWithin was faster in my test than ST_Intersects. That is surprising, especially since the prepared geometry algorithm is supposed to kick in on cases like this. I think there is a chance that this …
Nicklas Avén's user avatar