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

On a map, a closed shape defined by a connected sequence of x,y coordinate pairs, where the first and last coordinate pair are the same and all other pairs are unique.

3 votes

maximum circle inside an irregular polygon from a random point

I just wanted to test out your donuts in PostGIS I tried it on PostGISonline. To do the same test you go to: http://postgisonline.org/map.php There is some polygons called "property" print: SELECT …
Nicklas Avén's user avatar
3 votes

Lines to Polygons

"converting lines to polygons" depends more of the format than polygon/linestring representation. … I mean going from: LINESTRING(1 1, 2 2) LINESTRING(2 2, 2 1) LINESTRING(2 1, 1 1) to: POLYGON((1 1,2 2,2 1,1 1)) is converting line to polygon, but isn't what you are talking about I guess. …
Nicklas Avén's user avatar
3 votes

Optimizing a nearest neighbor calculation using PostGIS

That is because polygon to polygon calculations is much faster since 1.5 if their bounding boxes doesn't intersect. You can read more about that here.. The third thing to mention is the future. …
Nicklas Avén's user avatar
10 votes
Accepted

Filling a polygon with lines using Postgis

x_max from (SELECT the_geom AS the_polygon FROM lakes) l Next step is to build lines from those coordinates and and use ST_Intersection to only get the parts of the lines intersecting the polygon
Nicklas Avén's user avatar
2 votes

Web service to see postgis polygons

postgisonline is for things like this. go to http://postgisonline.org/map.php and paste your code. But you have to write it as a query understandable for PostGIS and call the geometry the_geom. Then …
Nicklas Avén's user avatar
2 votes

Algorithm to find polygons enclosing points

from a database perspective it sounds like you want to group the points on the ilands and make a convexhull on each group. in postgis it would look something like: SELECT ST_Convexhull(ST_Collect(p. …
Nicklas Avén's user avatar
2 votes

How to bring polygons closer to a point?

making the polygons bigger should give the desired effect. http://postgis.net/docs/manual-1.5/ST_Scale.html /Nicklas
Nicklas Avén's user avatar
0 votes

How to get MultiPolygon from MultiPoint for area calculation in Postgis?

Assuming your points is ordered so they define a polygon, you can combine ST_LineFromMultiPoint with ST_Polygon You will not get a multipolygon from this but a polygon. … To build a multipolygon which actually have more than 1 part you will need to define how the points shall be divided into sub polygon parts. But I guess that is not what you want. …
Nicklas Avén's user avatar