POST
|
In this particular case I'm working directly with the Oracle data (sdo geometry) from ArcGIS Pro so no connection is being made through Enterprise/Server etc
... View more
09-10-2019
12:31 AM
|
0
|
0
|
47
|
POST
|
Got it working - not by altering the query, but by creating the query in two steps. First I created the query layer without the 'where' clause. Then I went in to the query layer properties and edited the query by adding the 'where' clause. The data then displays as expected, with the Local table displaying at scales below 10000 and Regional data above scales of 10000. Not sure why the query wouldn't build in a single step though.
... View more
09-05-2019
04:00 AM
|
1
|
2
|
47
|
POST
|
Thanks for the reply George. If i more the 'x' inside that bracket I get a validation error with the 'where' clause, which I guess makes sense as the alias 'x' is now referring to the Regional table as opposed to the entire inner select query
... View more
09-04-2019
07:50 AM
|
0
|
4
|
47
|
POST
|
Using the blog, 'Scale dependent multiple datasources for a single feature layer', I am trying to create a query layer using the view_scale parameter to switch between different tables based on map scale. The data I am querying is stored in an Oracle database and the sql I am using for the query layer is: SELECT * FROM ( SELECT 1 as t_id, OBJECTID, Geometry FROM Local UNION ALL SELECT 2 as t_id, OBJECTID, Geometry FROM Regional) x WHERE x.t_id = CASE WHEN ::view_scale > 10000 THEN 2 ELSE 1 END The query validates with no errors, but after selecting 'finish' in the New Query Layer dialog no layer is added to the map in ArcGIS Pro. If I remove the WHERE clause, the data loads as expected, however both feature classes load at all scales which is not desired. Wondering have I an issue with the syntax of the query or are there other potential causes to the issue? Cheers, Finnian
... View more
09-04-2019
06:02 AM
|
0
|
6
|
207
|
IDEA
|
Hey Blake, Are dependencies listed only for items in your own organization or would I be able to see if one of my public hosted feature layers was used in another organization's web maps/apps? Cheers, Finnian
... View more
06-07-2019
01:06 AM
|
0
|
0
|
127
|
POST
|
When creating a Project Template in ArcGIS Pro, should it be possible to include a map that has an ArcGIS Online hosted feature layer added? I keep getting an error message indicating the hosted feature layer can not be opened: Status: Failed StatusMessage: ERROR 001707: Data cannot be opened: FeatureService(URL=https://services8.arcgis.com/...) I have tried saving the template to a file and also uploading to AGOL, but no difference. Finnian
... View more
02-14-2019
06:59 AM
|
0
|
1
|
207
|
POST
|
Hi Mark, Wondering were you successful getting the select_one choices populated from an external csv? Like you I tried following the XLSForm guide but couldn't get it to work. Wondering if I'm missing something, or perhaps I'm misunderstanding James Tedrick as to what the functionality does Cheers, Finnian
... View more
01-23-2019
04:35 AM
|
0
|
1
|
103
|
POST
|
Good to know, thanks. Sometimes less options are easier to deal with!
... View more
01-18-2019
07:23 AM
|
2
|
0
|
97
|
POST
|
Randall Williams Jonathan Quinn In a federated ArcGIS Server I do not see the option to change/set the isolation level. Is this expected behaviour? And if so, can I assume that all processes are running in high isolation? Thanks, Finnian
... View more
01-18-2019
07:02 AM
|
2
|
5
|
97
|
POST
|
Thanks for the reply Mark. Yes, basically users would like to overlay their new Survey123 data on a map showing other data for the area they are working in.
... View more
01-11-2019
09:25 AM
|
0
|
0
|
21
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|