ST_Functions and versioned environment

[MichalGasparovic]

Hello, I'm relying quite a lot on using the ST_Functions in a lot of my web applications. so far, I could simplify things meaning that all the feature classes weren't versioned. Everything works quite nicely, it's much faster bypassing the arcobjects / webadf when altering the data.

It's been some time I've worked with versioned object classes in sde.... and from what I remember, in case I needed to access the versioned data via SQL, I had to create multiversioned views...there were some limitation in editing scenarios...(well, can't point it out now as it's been quite some time ago, 2y)

My question is : is this (creating mv views) the only way of accessing and editing the data using the SQL (+ST) functions?

Are there any documents describing working with the SDE via SQL ? Does any one of you have a relevant experience of performance and complexity of implementing this in real life situations?

Thank you for all your help

[DallasShearer]

If your data isn't versioned you don't need to create any mv views to work with ST_geometry. If your data is versioned you don't have to create mv views to work with ST_Geometry, you will just be missing the changes in the data from your Add and Deletes table.
Here is the help link for working with ST_Geometry functions and operators.


http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=An_overview_of_SQL_functions_used_with...

[MichalGasparovic]

thanks for the update...
well, that's the problem, I need to access/modify the features in A/D tables via SQL. I think there was a document called "Working with geodatabase with SQL".... I wonder whether there is an update or not...
update***
something like the following : http://proceedings.esri.com/library/userconf/devsummit09/papers/sql_and_gdb.pdf

[KimPeter]

There's a section in the ArcGIS help for using SQL with ArcSDE geodatabases. This is the first topic in that "book":

http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/A_quick_tour_...

Within that section of the help is information on multiversioned views (such as this topic)
http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Creating_mult...

...and a subsection on editing with SQL:
http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/What_type_of_...

[MichalGasparovic]

Pete, thank you for those links ! that was exactly I was looking for 😉