Latest Contributions by NicoleSchleifer

‎04-23-2015

SELECT f.folderyear || '-' || f.foldersequence || ' ' || f.foldertype permit_no, vs.statusdesc status, f.indate, TO_NUMBER (TO_CHAR (f.issuedate, 'YYYY')) issuedyear, f.issuedate, vsb.subdesc Permit_Bldg_Type, pi.propinfovalue Planning_Unit_Type, fi1.infovalue DC_Unit_Count, fi2.infovalue DC_Suite_Count, NVL (fi3.infovalue, fi4.infovalue) Units_Created, fi4.infovalue Apts, p.prophouse || ' ' || p.propstreet || ' ' || p.propstreettype || ' ' || p.propstreetdirection || ' ' || p.propunit Address, p.propertyroll, p.propplan, TRUNC (fp3.enddate) HVACOCCDT, TRUNC (fp2.enddate) PLUMBINGOCDT, TRUNC (fp1.enddate) BUILDINGOCCDT, pp.shape, f.folderyear || '-' || f.foldersequence || ' ' || f.foldertype || ' ' || p.propertyroll Uniqueid FROM whadmin.cty_folder f, whadmin.cty_property p, whadmin.cty_validfolder vf, whadmin.cty_folderinfo fi1, whadmin.cty_folderinfo fi2, whadmin.cty_folderinfo fi3, whadmin.cty_folderinfo fi4, whadmin.cty_propertyinfo pi, whadmin.cty_validstatus vs, whadmin.cty_validsub vsb, whadmin.cty_folderprocess fp1, whadmin.cty_folderprocess fp2, whadmin.cty_folderprocess fp3, gisadmin.parcel pp WHERE f.propertyrsn = p.propertyrsn AND f.indate > '1-jan-00' AND f.statuscode IN (20, 30, 350) AND f.foldertype = vf.foldertype AND vf.foldergroupcode = 1 AND f.statuscode = vs.statuscode AND f.subcode = vsb.subcode AND p.propertyrsn = pi.propertyrsn(+) AND pi.propertyinfocode(+) = 65 AND f.folderrsn = fi1.folderrsn(+) AND fi1.infocode(+) = 14 AND f.folderrsn = fi2.folderrsn(+) AND fi2.infocode(+) = 185 AND f.folderrsn = fi3.folderrsn(+) AND fi3.infocode(+) = 3 AND f.folderrsn = fi4.folderrsn(+) AND fi4.infocode(+) = 25 AND TO_NUMBER (NVL (fi3.infovalue, fi4.infovalue)) > 0 AND f.folderrsn = fp1.folderrsn(+) AND fp1.processcode(+) = 39 AND f.folderrsn = fp2.folderrsn(+) AND fp2.processcode(+) = 40 AND f.folderrsn = fp3.folderrsn(+) AND fp3.processcode(+) = 405 AND pp.name = p.propertyroll;

‎04-23-2015

I've create a Query Layer to join multiple tables to one Parcel table with Geometry. In ArcMap, it displays all the correct parcels. In Toad, it has a count of all the correct records.... but when I right-click on the Query Layer in ArcMap and select the Attribute Table it only show 19 out of the 3840 records. ???? Any suggestions? ArcMap 10.2.2 - Oracle 11g

‎02-19-2015

Does anyone know what the equivalent in ST_Geometry functions would be for SDO_NN using Oracle 11g? I need to select the 10 closes linear assets to another linear shape.

‎02-18-2015

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

‎02-18-2015

Totally understandable. You're response is appreciated. I will continue on this path. Thanks

‎02-17-2015

We have the standard Spatial Index created through the desktop tools: INDEXTYPE IS SDE.ST_SPATIAL_INDEX PARAMETERS('ST_GRIDS = 530 ST_SRID = 26917 ST_COMMIT_ROWS = 10000 PCTFREE 0 INITRANS 4') NOPARALLEL; Is there a way to test if the query is calling the spatial index? Secondly, I'm a little unsure of how/where to use the st_envintersects ? Am I replacing the st_intersect with it? or do I need to use them both?

‎02-17-2015

We are working on migrating our existing applications from SDO_Geometry into ST_Geometry (Oracle 11g - SDE 10.2.2). One of our applications uses an iPad to get the X, Y coordinates and locate the closest linear asset. Our SDO sql statement was simple: WHERE SDO_WITHIN_DISTANCE ( A.AREAGEOMETRY ,mdsys.sdo_geometry(2001, 8307, mdsys.sdo_point_type( -78.2990416, 44.29297897, NULL), NULL, NULL), 'distance=75') = 'TRUE' The response time is 196 msecs Attempting to duplicate the results using ST functions is a little frustrating I have not been able to us the x, y points from the iPad at all, so I've been uisng the UTM coordinates. I've been able to reproduce the results using the UTM coordinates but the response time is way too slow (see below) 14 secs where sde.st_intersects (sde.st_buffer(sde.st_point(715480.6, 4907962.3, 26917), 15 ),pl.shape) = 1 11 secs where sde.st_distance (sde.st_point(715480.6, 4907962.3, 26917),pl.shape) < 15 9 secs where sde.st_distance (sde.st_geometry(715480.6, 4907962.3,null,null, 26917),pl.shape) < 15 Does anyone have any advice for how to speed the response time up? Are these the correct sql functions? or am I missing one? Please let me know.

‎02-04-2015

I'm having the exact same issue. Did you find the resolution?

‎06-27-2013

Did you solve this issue?

‎02-19-2013

Does anyone know how to convert a single point geometry in the Oracle SDE to a multipoint geometry? I registered an existing point geometry table that stored the coordinates in SDO_ORDINATES but when I edit in ArcMap (10.1) just those points editing through ArcMap are storing the coordinates in SDO_POINT. I'd ultimately like to store all my point geometry in the SDO_ORDINATES array so the feature class can be seen by GeoMedia's desktop software.

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

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

What ST_Geometry function replaces SDO_NN

Re: Speed up ST Functions

Re: Speed up ST Functions

Re: Speed up ST Functions

Speed up ST Functions

Re: Error in the some st_geometry functions (ORA-28579)

Re: Table to Table Joins or Relates Not Publishing

Change a single-point to a multi-point?