Latest Contributions by VinceAngelo

What database product are you using (are a least half a dozen SQL-supporting databases that also support spatial types)?  On what platform? There isn't any way to predict the performance of native types across products or platforms, or even in differing storage format on the same product/platform.  Even the same storage format can give wildly different performance, depending on the nature of input data, order of execution and tuning parameters. - V ... View more

It can't be a known issue until an incident is filed with Tech Support.  Unfortunately, it's now too late to get the fix(es) into 9.3.1 SP2 or 10.0 SP1. It won't be as efficient as a server-side function, but you can write your own helper to fetch all the shapes meeting your critera, then return the envelope.  Be sure to pass in *only* the geometry column -- se_layer_calculate_extent(SE_CONNECTION conn, char *table, char *column, char *where,                 SE_ENVELOPE *e, LFLOAT zrange[2], LFLOAT mrange[2]) Note that this is close enough to  SE_layer_calculate_extent that you can try this function as well. If you're using ST_GEOMETRY, then there's probably a pure SQL call which will return the union of the shape envelopes for a where clause (which would be less expensive than the current SE_stream_calculate_layer_extent).  ArcSDE 10.0 has a new SE_EXTENT_STATS_QUERY object API, but no documentation, so it may not be implemented yet. - V ... View more

I'd still recommend using the -R or -x & -G flags when registering a table with ArcSDE, especially when you consider that the coordref generated without them can't represent all data in the envelope you specified (which should probably be reported as a bug). - V ... View more

Direct Connect is going to log to the SDEHOME from which the connection is made; if you decentralize your connections, you also decentralize your connection logs. That message may just be from a 'sdesetup -o upgrade', which uses Direct Connect locally on the server. - V ... View more

I found the magic search term that led me to the right directory for OCI include files: 8 = SQLT_LNG             /* long */ 23 = SQLT_BIN             /* binary data(DTYBIN) */ 187 = SQLT_TIMESTAMP     /* TIMESTAMP */ 188 = SQLT_TIMESTAMP_TZ /* TIMESTAMP WITH TIME ZONE */ 190 = SQLT_INTERVAL_DS  /* INTERVAL DAY TO SECOND */ So, we've got two generic binary types and three time types with no mapping to the supported ArcSDE type list. You may be able to use a customized view to remap those types to something that ArcSDE will know how to decode. - V ... View more

If you can't find an Oracle doc listing the dataypes associated with type codes (and I couldn't in a cursory search), then you'll need to check the log file after running 'sdetable -o describe' on each table to track down which tables are generating those messages.  It's likely they're LOB types or unsupported date/time variants. Which version of Oracle 10g are you using? 10.2.0.1 has enough known issues, that this could be related to that (10.2.0.1 is unsupported -- 10.2.0.3 is the minimum supported release, and 10.2.0.4 requires ArcSDE 9.2 SP5 or higher). 9.2 SP2 is over three years old; if you want your ArcSDE to run with the fewest issues, you should try to apply service packs within six months of their release.  Even SP6 is now more than a year old, so you really ought to get your 9.2 to SP6 with the post-SP6 patch (performance issue on connect from Desktop) as soon as possible, and start looking to get 9.3.1sp2 and/or 10.0 installed in the coming months. - V ... View more

What version of Oracle are you using? (A.B.C.D notation) What version of ArcSDE are you using?  What service pack has been applied? What version of ArcGIS are you using?  What service pack has been applied?  Is your license ArcInfo, ArcEditor, or ArcView? What is the default version for the connection?  Is this version protected? - V ... View more

You can only perform SQL operations with ST_GEOMETRY or native geometry storage (PostGIS/SDO_GEOMETRY/GEOMETRY/GEOGRAPHY). There are utilities to convert an entire table to a new storage format, but it is not possible to convert SDEBINARY/SDELOB to ST_GEOMETRY/native on the fly in via SQL. - V ... View more

The ArcSDE 'C'/Java APIs and command-line utilities are only supported with Enterprise ArcSDE, which is part of ArcGIS Server. Query Layers are the means to access native SQL tables from Desktop without registration. - V ... View more

I run multiple ArcSDE instances all the time. On Windows hosts you just have to correctly configure the services so that they use the appropriate SDEHOME ('sdemon' just starts the service, so if your service is misconfigured, a '-H' flag won't help). The easiest way to do this is to: 1) Open a new CMD window 2) Set the SDEHOME variable (preferably to a path without any spaces) 3) Set the PATH variable to prepend %SDEHOME%\bin 4) Use 'sdeservice -o create' to create the service 5) [For non-Oracle installs] Use 'sdeservice -o modify' to set the Admin_database variable to the database name 6) [For remote installs] You may need to edit the dbinit.sde to use the appropriate connection variables (e.g., LOCAL instead ot ORACLE_SID) Given that you want services to start after reboot, you should *always* use Windows services to start and stop ArcSDE on Windows hosts. If it doesn't work for you, contact Tech Support to have them work you though the steps. - V ... View more

There is a 64-bit Java SDK installer in the media kit, but I haven't looked for it on the distribution site.  In the copy to which I have access, it's in an "ArcSDE_SDK" folder, which contains both 64-bit and 32-bit folders for Linux and Windows (64-bit only for Sun/IBM/HP). - V ... View more

You don't really need more than a 32-bit unique integer column and a GEOMETRY to register a table with ArcSDE. When I use SQL to create databases, I use SQL, with only a few registers at the end.  I mostly use the ArcSDE API to load the data, but only because I've got a very powerful ASCII loader -- there's no reason SQL can't be used for that as well (provided you validate your geometries to be sure they honor ArcSDE topology rules -- lines vs. simple lines, polygon boundaries which are non-intersecting,...).  There is no inherent geodatabase complexity when working with "simple feature classes", you just don't get the full monty in terms of object behaviors, complex topology, et. al. - V ... View more

Direct Connect requires that the word size environments be identical -- 32-bit app with ArcSDE 32-bit DLL and  32-bit Oracle library *or* a 64-bit app with an ArcSDE 64-bit DLL and a 64-bit Oracle client install.  Your error message indicates you're attempting to mix-n-match architectures, which cannot work.  You'll need to use a 64-bit ArcSDE install to make 64-bit Java and 64-bit Oracle work. - V ... View more

You don't need convert between geodatabase and SQL tables because ArcSDE geodatabases *are* SQL tables. If you chose to store the geometries of your geodatabase in a native SQL format, then you won't need to do any further conversion (beyond the one-time storage method change Brent suggested). If you don't want to utilize the benefits of versioning, there's no reason to do so, but there's also no reason to incur the cost of storing your tables twice (and keeping them synchronized). - V ... View more

If you have ArcSDE 9.2sp3 and ArcGIS 9.2sp6 on the same host, they will both have a DLL named "SDE.DLL", but one will be SP3 and one will be SP6.  The LoadLibraryEx() function is used to load dynamic libraries, and it searches directories in the order specified by the PATH variable.  If your SP3 bin directory is before the SP6 directory, then the 92sp6 ArcGIS will use the outdated DLL, making it unreliable. There are a multitude of reasons to install ArcSDE 9.2 SP6 and the post-SP6 patches; eliminating search order conflicts as a possible problem is one of the less pressing ones, but if it works, then the other issues won't give you trouble either. - V ... View more