Latest Contributions by VinceAngelo

I build 64-bit apps on RHEL 5 using the 9.3.1 SDK all the time. I'm somewhat amazed you've gotten a successful compile with any SDK without using the required flags (especially -Dunix). On 32-bit hosts my CFLAGS is: -Wall -D_XOPEN_SOURCE=600 -D_XOPEN_SOURCE_EXTENDED -D_ISOC99_SOURCE -DARCSDE=100 -DLINUX -Dunix -I$(SDEHOME)/include On 64-bit Linux I use: -Wall -D_XOPEN_SOURCE=600 -D_XOPEN_SOURCE_EXTENDED -D_ISOC99_SOURCE -DARCSDE=100 -DLINUX -DSDE64 -Dunix -I$(SDEHOME)/include (only the "-Wall" and "-DARCSDE=100" are my own preferences) For both environments, I also need: CC= gcc LFLAGS=-L$(SDEHOME)/lib LIBS=-lsde -lsg -lpe -lpthread -lm -ldl - V ... View more

It's not possible for any ArcSDE function to return a value in excess of 2^31-1. If you defined the 'rc' variable as LONG (which on 64-bit platforms is defined "int"), the return value would have been -30 (SE_INVALID_SEARCH_METHOD). Did you just recently port to 64-bit? What compilation flags do you use? Is '-DSDE64' in the list? Alignment issues could easily cause this sort of problem, but usually the compiler would complain when the prototypes are violated. -V BTW:  The SE_stream_query() function was superceeded by SE_stream_query_with_info at the 9.2 release.  If you're still using SE_SQL_CONSTRUCT-based functions at 10.0, you may run into other difficulties as well. ... View more

Check your environment variables again, especially LD_LIBRARY_PATH.  As the postgres user, execute 'ldd st_geometry.so' -- Do all the DLLs resolve? Did you forget to copy the ArcSDE application libraries into the PostgreSQL shared libraries directory?  Remember that libsg.so and libpe.so are dependencies for st_geometry.so. - V ... View more

I haven't heard of any current applications, but it seems as though you'd be able to submit any SQL statement you'd like through ODBC, which would include an UPDATE command with the Oracle- (or other-) specific syntax to change geometries.  It would be tedious, but possible. Questions about possible future functionality would be more appropriately directed to your marketing representative and/or ideas.esri.com. - V ... View more

Personal (and Workgroup) ArcSDE does not run as a service; only Enterprise ArcSDE does. - V ... View more

Most pre-10 ArcSDE database limit the column count to 256, but at 10.0 the ArcSDE limit was increased to 500 (SE_MAX_COLUMNS).  The FGDB limit is 64K fields, but I believe they must start with a character ([A-Z](A-Z0-9_)* - SQL requirement). You're probably going to have to code this from scratch, so it doesn't really matter where you make the change.  The fastest approach would use C++ (either ArcObjects or FileGDB API), but if you don't have a lot of rows, C# or Python won't slow you down too much.  What interface do you have at the Stata end for accessing raw data?  Or would you plan to use ASCII for interchange? - V ... View more

Are you looking to transfer to a file geodatabase or an ArcSDE database?  Which version of ArcGIS?  If ArcSDE, which database? - V ... View more

What version of ArcGIS are you using?  What version of ArcSDE is running? There are several different types of connections available from ArcGIS, only the "Database Connections" tree element manages ArcSDE connections -- are you using this? Is there a firewall running on the ArcSDE server host?  If so, has the service port been approved for communication from the client on that port? Can you connect to ArcSDE from the ArcSDE server host? - V ... View more

It shouldn't be possible to get in this situation.  All feature classes must have the same SRID in order to join a feature dataset. You can't change the SRID of a layer without corrupting the contents of the SDEBINARY, SDELOB, or ST_GEOMETRY shapes in the table (the integer compression encoding remains the same but the meaning changes, causing the shapes to shift and scale differently into real-world coordinates). Your best bet is focus on what changed, and when, to track down who changed things, and how. Your recovery path would be determined by this. - V ... View more

I much prefer the "put stuff back the way it was, then delete it" approach to hacking the geodatabase dictionary.  It's just one 'sderaster -o add'  to fix an inopportune '-o drop' (and you don't even need to get the parameters correct, just to do enough that Catalog will able to clean up the whole tree). - V ... View more

You *really* need to use the '-x' (or '-R') parameter in *every* 'shp2sde -o create' command. The coordref automatically generated by 'shp2sde' is usually inappropriate, but 900 trillion in the X/Y scale is spectacularly wrong (unless you're planning on mapping individual hydrogen atoms in geographic units). - V ... View more

The File Geodatabase API and ArcGIS API for Silverlight have nothing in common.  If you were to implement COM objects with C++ and FGDBAPI, then I suppose you could do anything you'd like. The same would be true with the .Net wrapper, when it's released.  Either way, there'd be a good bit of programming involved. - V ... View more

The main problem with editing the dbtune.sde file before initial setup is the possibility of corrupting the file so that you can't install.   Try dropping the SDE user and starting over with an original DBTUNE file.  If setup fails again, then your Oracle instance doesn't have the correct configuration for XML support; if it doesn't fail, pay closer attention to the changes you are making to the initial dbtune.sde. - V ... View more

It's hard to believe that Esri Tech Support would recommend that.  The fix is simple to do, but not at all simple to explain.  Leaving your database like this will prevent application of service packs or upgrades.  Please follow up with Esri Tech Support. - V ... View more

The 'sdetable -o create_view' command exists to create spatially-aware views with SDEBINARY or SDELOB storage. The 'sdelayer -o register' command exists to synchronize native geometry (which includes ST_GEOMETRY storage) with an existing ArcSDE instance. There is no need to register a view which doesn't contain geometry with ArcSDE (which will see it as a table as soon as it is created [provided it is limited to the supported column types, of course]).  It is not possible to register views with the geodatabase, since ArcGIS expects SDE-set registered rowid columns, and these are not possible with views. While Oracle no longer supports 10gR2 databases, Esri does continue to support ArcSDE in them at ArcGIS 10.  The last ArcSDE release to support Oracle 9iR2 was 9.3.1.  It's not too early to be planning 11g  database transition. - V ... View more