262 reputation
26
bio website stackoverflow.com/users/20133/…
location Oklahoma City, OK
age 32
visits member for 3 years, 9 months
seen Jul 29 at 20:44

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.


Dec
3
awarded  Nice Answer
Oct
18
awarded  Taxonomist
Sep
10
accepted ArcGIS Server: Better to have one massive map service or multiple smaller services?
Aug
10
awarded  Autobiographer
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
10
asked ArcGIS Server: Better to have one massive map service or multiple smaller services?
Aug
9
accepted Why are self-intersecting polygons bad?
Aug
8
comment Why are self-intersecting polygons bad?
Is that a limitation of the algorithms used for boundary detection?
Aug
8
asked Why are self-intersecting polygons bad?
Jun
5
awarded  Yearling
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
27
revised In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?
Added more specific tags.
Jan
26
awarded  Teacher
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
26
answered What are spatial and attribute indexes?
Jan
21
awarded  Scholar
Jan
21
accepted In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?
Jan
20
awarded  Supporter
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).