• Member for 7 years, 1 month
  • Last seen more than a week ago
Adding vertices to polygon in PostGIS?
3 votes

A simple alternate solution might be ST_Segmentize(). This function will add vertices to your polygon such that no segment is longer than a given length. If getting using the exact midpoints is ...

View answer
Calculating Voronoi Diagrams for polygons
Accepted answer
2 votes

I like the answer which mentioned "Segment Voronoi diagrams," but I ultimately found it difficult to implement in my particular workflow. I found that because my geometries were fairly detailed (i.e., ...

View answer
pgAdmin III SQL creating a point
1 votes

UpdateGeometrySRID() is unnecessary because your column already has an SRID set, as indicated in your error message. You need to do something like this: UPDATE tmorr.dc_crimes SET geom = ST_SetSRID(...

View answer
Polygon found with search cursor, but not update cursor
Accepted answer
0 votes

Found the solution, though I have no idea why it works. The code works if I move edit.startOperation() and edit.stopOperation() inside the loop: # Open an edit session and attempt to find all the ...

View answer