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 14196

PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

3 votes
2 answers
235 views

Compare row to all others in PostGIS

Given a PostGIS table of polygons, what is the best way to check if each geometry is inside the union (ST_Collect) of all other geometries from the same table? …
jczaplew's user avatar
  • 1,208
6 votes
2 answers
983 views

PostGIS Geography Buffer producing different areas?

I'm trying to create circles of equal area in different places, but depending on the location of the centroid different areas are calculated. For example SELECT ST_Area(ST_Buffer('POINT(0 0)'::geogra …
jczaplew's user avatar
  • 1,208
16 votes

Fixing non-noded intersection problem using PostGIS

I ran into this same problem (Postgres 9.1.4, PostGIS 2.1.1), and the only thing that worked for me was to wrap the geometry with a very small buffer. …
jczaplew's user avatar
  • 1,208
1 vote
Accepted

Editing PostGIS topology in web browser

It is currently handled server side with PostGIS. …
jczaplew's user avatar
  • 1,208
6 votes
2 answers
2k views

Editing PostGIS topology in web browser

I am trying to conceptualize the best process for editing topology from PostGIS in a web browser. … Ideally what I would like to accomplish is the loading of a topology (imagine the lower 48 states of the US), adjusting the borders, and updating a PostGIS table with the changes. …
jczaplew's user avatar
  • 1,208
11 votes
1 answer
657 views

Point sampling along a pole-wrapping coastline with PostGIS

I am working on a task that requires me to get sample points every 1000 km along coastlines, and have run into a problem with Antarctica. From what I can tell, it seems to be an issue with the use of …
jczaplew's user avatar
  • 1,208