Subnetwerken enumereren via API

Question

Ik probeer alle subnetwerken te enumereren zodat ik programmatically exportSubnetwork kan aanroepen via de REST API.<\/P> Ik kan niets vinden in de documentatie dat aangeeft dat dit mogelijk is via de REST API.<\/P> Is mijn enige keuze hier om arcpy te gebruiken of een DB-query uit te voeren om naar de subnetworks-tabel te kijken? <\/P>

GIS_kiwi4 · Answer

@BrandenRager - Awesome job! 
Subnet Line is one way of getting all subnetworks but I believe a better way is to use the subnetworks table for this. This is layer id 500002

https://{Your Site}/server/rest/services/UN_Service/Prod_UN_Service_2/FeatureServer/500002/query?where=1%3D1&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&defaultSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=*&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&havingClause=&gdbVersion=&historicMoment=&returnDistinctValues=false&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&multipatchOption=xyFootprint&resultOffset=&resultRecordCount=&returnTrueCurves=false&returnCentroid=false&timeReferenceUnknownClient=false&maxRecordCountFactor=&sqlFormat=none&featureEncoding=esriDefault&datumTransformation=&cacheHint=false&f=html

Response

Two distinct advantages -

1) This will show you the Tier Name i.e the non-coded value

2) This will also show subnetworks where there may not be a subnet line. 
For example - A Distribution Transformer (LV subnetwork controller) without any LV Lines connected to it but has customers connected via associations. The "subnetline GlobalID" field will be blank for such instances.

Bonus advantages -

It will also show deleted subnetworks which you might want to clear out from the table periodically.

Also shows the last acknowledged date and last updated date which might help drive logic of when to export the subnetworks.

Hope this helps 🙂

BrandenRager · Answer

Answering my own question:

You have to look at the FeatureServer, not the UtilityNetwork to get this.

There exists a layer called "Subnet Line" which contains the tier/subnetworks that I was looking for.

Only downside is that that tiers are returned with their coded values, and the exportSubnet expects the non-coded value so you will have to do a translation.