|
POST
|
Why can't i return information accessing a related table using the arcade code on a feature class? I'm requesting an assignmentID from the feature, placing the ID in a sql expression; accessing the related table and filtering the results to match the ID with the description and returning the results when a user clicks on a point. Right now it returns blank. Any ideas? // read out the ID of the assignment type
var assignmentID = $feature["assignmenttype"];
// create a sql expression to query on ID
var sql = "Assignment = '" + assignmentID + "'";
// access table data
var tbl = FeatureSetByName($datastore,"Assignment Types");
var related_data = Filter(tbl, sql);
return related_data
... View more
09-09-2020
11:16 AM
|
0
|
1
|
1002
|
|
POST
|
We have a excel spreadsheet we'd like to add links to open specific areas & locations based on that job. Is it possible to do that with ArcGIS Pro ?
... View more
05-20-2020
11:54 AM
|
0
|
0
|
490
|
|
POST
|
We have a excel spreadsheet we'd like to add links to open specific areas & locations based on that job. Is it possible to do that with ArcMap or ArcGIS Pro or ArcGIS Online?
... View more
05-20-2020
11:16 AM
|
0
|
0
|
507
|
|
POST
|
In ArcMap we had preset maps for users to use with limited access for editing but when I convert these to ArcGIS Pro it gave everyone the ability to make changes to everything. For some reason it overrides the sde geodatabase permissions. Any ideas?
... View more
02-27-2020
06:54 AM
|
0
|
0
|
409
|
|
POST
|
Is there a way to get the total count of features in a single service with python?
... View more
12-09-2019
10:38 AM
|
0
|
2
|
2373
|
|
POST
|
What's the best method for updating ArcGIS Online data that has sync enabled? Currently, we have multiple offices actively using this data offline.
... View more
11-23-2019
08:15 AM
|
0
|
21
|
10475
|
|
POST
|
If a child version gets deleted can you recover that information if you have a sql backup?
... View more
11-15-2019
04:15 AM
|
0
|
1
|
880
|
|
POST
|
I am publishing data from a versioned sde database and no matter what I do the sync always fails when I perform a sync on the New Collector for ArcGIS. I've never had issues syncing our data from our 10.6 enterprise portal. Any ideas?
... View more
10-07-2019
05:08 AM
|
0
|
7
|
2678
|
|
POST
|
This might be a "public facing" issue with your portal. I would recommend reading the documentation and having a word with your IT. https://doc.arcgis.com/en/survey123/reference/survey123withenterprise.htm
... View more
10-04-2019
08:19 AM
|
0
|
1
|
942
|
|
POST
|
Another solution is to entirely remove the Collector for Arcgis app and install it again.
... View more
10-04-2019
08:06 AM
|
0
|
0
|
2116
|
|
POST
|
Also interested in a response/solution. In the past we had the same issue.
... View more
10-02-2019
08:01 AM
|
0
|
0
|
663
|
|
POST
|
Any ideas why adding fields from a related table to a word doc template would generate the error from the image? You would think this function would work with the point fc and it's related tables that were published to AGOL.
... View more
10-01-2019
12:25 PM
|
0
|
4
|
1911
|
|
POST
|
Hey Doug, When you say "build a master FC" are you putting all your fields for the forms into a single point, line, or polygon feature class?
... View more
10-01-2019
05:54 AM
|
0
|
1
|
1596
|
|
POST
|
I am trying to figure out how to get a count on each feature class in our SDE database and later record it to a text file but I am having trouble figuring out how to setup the "Get Count" portion of the script. I haven't had any success incorporating the "Get Count" example. When "My Script" runs it prints the fc name (.e.g. jmillePCReplica.DBO.Wayne_Parcels) but when I plug that variable / fc name in place to the "Get Count" example it fails. Any ideas? My Script # Import system modules
import arcpy, os
from arcpy import env
# Set workspace
sdeConnection = r"Database Connections\STR-DT-JMILLE.sde"
feature_classes = []
walk = arcpy.da.Walk(sdeConnection, datatype="FeatureClass", type="All")
print("Starting..")
for dirpath, dirnames, filenames in walk:
for filename in filenames:
feature_classes.append(os.path.join(dirpath, filename))
print(filename) Get Count Example result = arcpy.GetCount_management(filename)
print('{} has {} records'.format(filename, result[0])) My Script results Starting..
jmillePCReplica.DBO.P_AbandonedDevice
jmillePCReplica.DBO.P_AbandonedPipe
jmillePCReplica.DBO.P_AbandonedService
jmillePCReplica.DBO.P_AlignmentSheet
jmillePCReplica.DBO.P_CapitalProject
jmillePCReplica.DBO.P_Coupon
jmillePCReplica.DBO.P_CPArea
jmillePCReplica.DBO.P_DrinkingWater
jmillePCReplica.DBO.P_EcologicalArea
jmillePCReplica.DBO.P_ExcavationDamage
jmillePCReplica.DBO.P_ExposedPipeInspect
jmillePCReplica.DBO.P_GasLeak
... View more
09-18-2019
08:12 AM
|
0
|
4
|
2849
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 05-11-2018 06:04 AM | |
| 1 | 04-11-2018 06:24 AM | |
| 1 | 04-04-2019 05:59 AM | |
| 1 | 05-06-2019 08:45 AM | |
| 2 | 06-06-2019 06:32 PM |
| Online Status |
Offline
|
| Date Last Visited |
01-13-2021
02:32 PM
|