Enumerando Sub-redes via API

Question

Estou tentando enumerar todas as sub-redes para que eu possa chamar programaticamente exportSubnetwork via a API REST.<\/P> Não consigo encontrar nada na documentação que mostre que há uma forma de fazer isso via a API REST.<\/P> Minha única opção aqui é usar arcpy ou fazer uma consulta no banco de dados para olhar a tabela de sub-redes? <\/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.