262 reputation
26
bio website stackoverflow.com/users/20133/…
location Oklahoma City, OK
age 31
visits member for 3 years, 2 months
seen Apr 9 at 21:31

I am a software engineer for Oseberg, LLC. I specialize in .NET, GIS, MS SQL Server/Oracle/PostgreSQL, Python, and Scala.

In my free time I spend time with my wife and kids, study Koine Greek, and practice target shooting.


Aug
10
comment ArcGIS Server: Better to have one massive map service or multiple smaller services?
Good point. In this case, all of them are dynamic. Some are being consumed as dynamic while others feature layers.
Aug
8
comment Why are self-intersecting polygons bad?
Is that a limitation of the algorithms used for boundary detection?
Mar
21
comment Oracle Linestrings and MultiLinestrings
Is this actually causing a problem? In Oracle, when a spatial index is configured explicitly for multi-part lines or polygons, it is compatible with single part geometries. It is going the other way around that causes issues.
Jan
28
comment In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?
The geometry column has a spatial index. In Oracle, you can't perform most geometric operations without a spatial index. As far as optimizing the parameters, I'll try to see if I can make it more efficient. With the benchmarking I've done, my bottleneck is not finding intersections, but calculating 1/16 of the intersected area after I've found a relationship. The sdo_intersection function is what is so slow.
Jan
26
comment What are spatial and attribute indexes?
The poster is asking what is the difference between an attribute index and a spatial index. wt == "what"
Jan
20
comment In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?
This is a good suggestion. If I take the intersection of the MBRs as opposed to the union, it gives me what I want (even with crescents and narrow polygons).