Latest Contributions by NicoleSchleifer

‎04-23-2015

I haven't dealt much with Query Layers, but for those I have, I would suspect a problem with the Unique ID.

‎02-27-2015

I'm not sure there is one. What I've used in the past on SQL Server is to: Select all within a distance threshold Order them by distance select rownum = 1 I'm not an expert in Oracle, but I'm in the process of migrating in to it. I'm more familiar w/ SQL Server so I don't have as much experience writing fancy queries and I still haven't learned all the functions, but something like: select q.*, rownum from( select t1.objectid oid1, t2.objectid oid2, sde.ST_Distance(t1.shape, t2.shape) from table t1, table t2 where t1.objectid <> t2.objectid order by sde.ST_Distance(t1.shape, t2.shape) ) q where rownum =1 A lot of spatial queries seem MUCH slower in Oracle compared to SQL Server, but I have a lot to learn.

‎02-18-2015

THANK-YOU SO MUCH! It works perfectly!!! Response time is now 264 msecs......... SO EXCITING!!!

‎02-19-2013

How is this question different from a similar thread from not long ago? - V

‎12-05-2012

UPDATE: Trying to do this outside the Esri environment was clunky and a bit messy. An easier method inside the Esri environment that was just pointed out to me..... In ArcCatalog: Rename the original table (Feature Class), then copy and paste it with the original name. *This is for Stand-alone Features* Way cool......... worked like a charm and maintains all the spatial metadata that Esri requires. Super Impressed!

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by NicoleSchleifer

Re: Query Layer in ArcMap 10.2.2 - Visual doesn't match Attribute Table

Re: What ST_Geometry function replaces SDO_NN

Re: Speed up ST Functions

Re: Change a single-point to a multi-point?

Re: Point Feaure in SDO_GEOMETRY populating the SDO_POINT, instead of SDO_ORDINATES