topic Re: ST_Functions and versioned environment in Data Management Questions

ST_Functions and versioned environment

MichalGasparovic — Wed, 14 Jul 2010 06:54:44 GMT

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

Re: ST_Functions and versioned environment

DallasShearer — Thu, 15 Jul 2010 11:36:36 GMT

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_ST_Geometry_types

Re: ST_Functions and versioned environment

MichalGasparovic — Thu, 15 Jul 2010 11:50:15 GMT

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

Re: ST_Functions and versioned environment

KimPeter — Mon, 19 Jul 2010 14:35:12 GMT

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_of_using_SQL_with_ArcSDE_geodatabases/0093000015sw000000/

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_multiversioned_views/0093000015m6000000/

...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_data_can_be_edited_using_SQL/0093000015pv000000/

Re: ST_Functions and versioned environment

MichalGasparovic — Mon, 19 Jul 2010 15:22:10 GMT

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