New answers tagged

0

Turns out on one of the layers the Append corrupted the spatial index on the polyline layers, now to the next problem figuring out why the Appends are destroying the spatial index because it happened multiple times after some testing. After we rebuilt the spatial index it was working as normal. Also, using the "Rebuild Indexes" tool didn't work, we had to go ...


2

The 000210 error is principally caused by two potential errors: The table name is not valid (often a reserved word) One or more of the columns are not valid (reserved word or too many characters) The ArcSDE communication library has constants which limit table and column name buffers to 32 bytes (31 characters, plus a closing terminator). Oracle itself ...


1

I have seen some application software, like TOAD, display Oracle VARRAYs in ways like this. The SDO_GEOMETRY may be fine which is why I suggest querying it for sdo_util.GetNumVertices (tests sdo_ordinate_array)and sdo_util.getNumElem() (tests sdo_elem_info_array) See my answer to your other thread here: https://stackoverflow.com/questions/59699858/wkt-...


1

I have access to Oracle not ESRI so I can't help with all aspects. The WKT looks fine, though the space after the first ( is normally not there. Try using the sdo_geometry(WKT,srid) constructor supplying the SRID rather than the sdo_util function. Take the WKT as a string and directly constructed the SDO_GEOMETRY with it rather than using st_astext, this ...


3

I assume that there is a physical Oracle table that sees insert/update events as the REST service fires. And that those events aren't a complete truncate/reload. If so I would create a before insert/update trigger and construct an sde.st_geometry object from the X,y columns. No indexes should exist before the initial load; create them after the load. As ...


2

Number 1 will have least overhead. Based on map extent used most often set smallest grid slightly smaller than this map extent zoomed to. Set next middle grid 3 times this value. Set largest grid three times the middle grid value. This works like a spatial index explained here: https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/...


1

TOAD writes out the meta data of Oracles ST_GEOMETRY UDT implementation for ESRIs SDE; it's essentially a list of geometric predicates describing the geometry, and the vertex array that builds the geometry type, held as BLOB: ST_GEOMETRY( <ENTITY>, -- geometry type (POINT, LINESTRING, ...) <NUMPTS>, -- number of points <MINX>, ...


1

For role-specific editing, I'd recommend applying Privileges to the data in an Enterprise geodatabase. The 'insert,' 'delete,' and 'update' privileges would be applied to specific Active Directly (AD) groups created in Windows (https://docs.microsoft.com/en-us/previous-versions/commerce-server/aa545347(v=cs.70)?redirectedfrom=MSDN). For feature-specific ...


Top 50 recent answers are included