Latest Contributions by VinceAngelo

Geodatabases and shapefiles are two different storage formats for spatial data. Shapefiles were originally created in the 1990s for use with the original ArcView. They use the dBase-III format to store attributes, and are subject to many limitations (among them: lack of numeric nulls, very short column names, day resolution dates, and short ASCII strings). "Geodatabase" is not a single format, but a family of formats that take advantage of true database concepts and support a wider range of datatypes, NULL columns, and raster datatypes. All modern Esri GIS applications can directly read geodatabases; not many others do. There's probably several hundred pages of documentation which touch on your topic, but if you start with something like A quick tour of data management, you'll have a good beginning. - V ... View more

It's difficult to debug someone else's code when the full source is provided, but it's impossible to debug with missing source.  Since the partial source uses several questionable techniques in memory management, I'd recommend inspecting every line where a malloc or free is present, and replacing it with code that reflects the fact that row-oriented processing functions only need one handle for each object. You should certainly move the SE_shape_free call outside the loop, but you also need to call SE_shape_create at some point before the loop starts (allocating a random block of memory, typing it as an array of handles, and treating it like a single shape handle is an easy way to produce run-time memory corruption errors).  It would certainly help to treat compilation warnings as errors (and to enable pedantic warnings to look for memory management problems at compile time). It's also important to keep in mind that the ArcSDE API does not operate on feature classes. "Feature class" is an ArcGIS / ArcObjects term.  The ArcSDE API operates on the tables on which feature classes are modelled.  You need to be very careful while using ArcSDE primitives that you don't corrupt the geodatabase organization imparted by ArcObjects.  It would be slower, but much safer to use C# or Python to manipulate geodatabase objects in a framework that is less vulnerable to memory management errors. - V ... View more

No, 'sdetable -o create_view' does not support multiple geometry columns in a result set. - V ... View more

The ArcSDE software is installed (via 'sdesetup') as the SDE login/schema (only). This creates metadata tables and installs the SDE.ST_GEOMETRY type. All further data creation should be done as a user other than SDE. Create a login, create a schema (with the same name as the login), grant the permissions, then create and populate tables. - V ... View more

If you can't start giomgr without the '@instance', then the listener configuration is incorrect, and nothing else is going to work correctly, either. Please contact Tech Support to get this straightened out. - V ... View more

So you're having issues starting the application service?  That sounds like a listener issue. What's the contents of the files in your $ORACLE_HOME/network/admin directory (*.ora files)? What does your start script look like?  Does it set ORACLE_SID or TWO_TASK?  What about your $SDEHOME/etc/dbinit.sde file? - V ... View more

There are two ways to connect to an ArcSDE instance, application server connects (via the ArcSDE network protocol) and Direct Connect (via a database client library). In the fomer the "instance" parameter is the port number or "port:<number>", or the service name (from .../etc/services). In the latter, the instance is "sde:<rdbms_key>[:parameters...]". The nominal notation for an Oracle 11gR2 connect is "sde:oracle11g". Since no indication of which Oracle instance is provided, the password parameter was modified to support the format password@instance . This is the way ArcSDE was designed to function, so I'm having difficulty seeing how this syntax would cause ArcGIS clients difficulty (the '@' symbol is forbidden from Oracle passwords, so this is unlikely to conflict with actual passwords). If you are having connection problems from ArcGIS clients, the cause is more likely to involve the Oracle client configuration. Can you provide details on the exact errors you are seeing? - V ... View more

File geodatabase uses the file system -- Any OS valid backup methodology will suffice, including right-click 7-Zip - "Add to foo.gdb.zip".  It would be best if you made sure there were no users at the time of snapshot (so the backup doesn't capture lock files). - V ... View more

Please ask in the appropriate Forum (after reviewing other similar posts). - V ... View more

The 1.1 version of the FileGDB API was released back in August;  you probably want to try using that before visiting the File Geodatabase API forum to ask further questions. - V ... View more

Yes, ArcSDE uses a rigid naming paradigm -- anyplace there is <sometext><somenumber> naming, you should look to the corresponding <something>_id table's row for the parent object. In the case of iN, look for the N in table_registry. The documentation covers this as well, and includes the caveat: Note: You will notice that once you have loaded data or run sdesetup, you have several i tables and stored procedures in your database. These stored procedures and i tables are used for generating feature IDs for feature classes. The i tables contain a number in their name. This number corresponds to the registration_id of the feature class in the SDE_table_registry table. Editing these tables or stored procedures is not supported and is highly discouraged. - V ... View more

It's exactly the same as in Oracle (and the other databases): + Rowid 'N' corresponds to the table_registry ID key + Layer 'N' corresponds to the layers ID key + Raster 'N' corresponds to the raster_columns ID key - V ... View more

A one-row "i table" is created, with a trigger to increment it like a sequence. - V ... View more

Given that ArcSDE is dependent on a standards-conformant SQL engine to operate, it doesn't seem likely. The best way to get answers to questions that start "Does Esri have plans" is to contact Esri directly, either through Tech Support or your local marketing representative.  While Esri staff often participate in these User Forums on technical issues, very few of us are empowered to respond to future "plans" questions directly. - V ... View more

You're more likely to get help if you post in the appropriate forum, which is probably over in ArcObjects - All Development Languages. When you post there, be sure to specify which version and service pack of ArcGIS you are using. It will also make your post more readable if you use the CODE tags and try to preserve indentation. - V ... View more