Select to view content in your preferred language

Hi every way to trace geometric network with SQL function in the database

3149
3
04-14-2016 01:44 AM
mohamadalmaddah
Deactivated User

Hi every way to trace geometric network with SQL function in the database. For example, the oid of source feature to the function and then trace downstream line  and give the oid of sink .

0 Kudos
3 Replies
WesMiller
Deactivated User
0 Kudos
nicogis
MVP Frequent Contributor

I don't know but you could take a trace downstream line  with toolbar ArcGIS and in sql server runs Create a Trace (SQL Server Profiler) (video 21-How to trace incoming SQL statements to SQL Server Database (using SQL Server Profiler) - YouTube ) so you trace the query for this task ...

0 Kudos
mohamadalmaddah
Deactivated User

Thanks to the call of my friends actually I need to trace geometric network in database environment and use toolbar do not useful , Using the query analysis tool is not useful

for example in postgresql database with postgis can trace path in database please see this sample :

http://boundlessgeo.com/2010/07/network-walking-in-postgis/

0 Kudos