Reputation
252
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 13
Impact
~4k people reached

Jun
25
awarded  Popular Question
Apr
29
comment How to model a graveyard - one point per deceased or one per grave?
That's not complicated. That's properly modeling your data! +1 for good relational design.
Mar
13
comment Numbers containing e in ArcGIS?
Commonly known as E notation.
Feb
26
comment Split one field into 3 fields?
Some explanation of how Python slicing works: stackoverflow.com/a/509295/1394393.
Jan
24
revised Where can I find PostGIS error codes?
added 13 characters in body
Jan
24
answered Where can I find PostGIS error codes?
Nov
21
comment How to calculate polygon length and width using open source GIS?
@ThomasG77 That's a Python wrapper around something written in Java.... That makes me sad. =(
Nov
18
comment Specify geoprocessing service connection at publish
@Smalis That sounds like it warrants another question. Why not post what you're doing and the behavior you're seeing? You can leave me a comment and I'll look at it.
Nov
5
comment Why is PostGIS query not using spatial index?
Since 16000 is much greater than 360, I think we would have to assume it encompasses the entire Earth (if the behavior is even defined for a degree that large).
Oct
14
answered Delete all data from a PostGIS topology
Oct
14
comment Delete all data from a PostGIS topology
@Mapperz I'm looking into fiddling with the underlying topology tables manually, but I've noticed that at least the face table has a row in it when you create a new topology. Since the topology tables are something PostGIS is supposed to manage for me, I'm a bit cautious about just truncating them.
Oct
14
revised Delete all data from a PostGIS topology
added 97 characters in body
Oct
14
asked Delete all data from a PostGIS topology
Sep
24
awarded  Autobiographer
Aug
28
awarded  Curious
Aug
27
revised How can I associate a consistent polygon area with a set of attributes using a topology?
deleted 28 characters in body
Aug
27
comment Moving existing hard drive with PostGIS data directory to a new computer
Are you sure this still fails if you use the 32 bit PostgreSQL/PostGIS on the 64 bit machine? The mailing list suggests otherwise, although it does seem to suggest that dump/restore is just a better idea, anyway.
Aug
27
comment Is there any random data generator supporting geometry in PostGIS?
Have you considered generating random line boundaries and feeding them through MakeValid? I bet that would give some pretty complicated shapes. You could probably do something in the vein of a random walk to keep it in the same general area, maybe even a random walk plus some kind of sort if you want something a bit more regular.
Aug
27
revised How can I associate a consistent polygon area with a set of attributes using a topology?
Completely revised the question and made it narrower
Aug
27
asked How can I associate a consistent polygon area with a set of attributes using a topology?