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

2951
3
04-14-2016 01:44 AM
mohamadalmaddah
New Contributor

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
Regular Contributor III
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
New Contributor

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