Search Results
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 |
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) …
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 …
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);
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;
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 …
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 …
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 …
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 …