Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About FinnianO_Connor
FinnianO_Connor
Occasional Contributor II
since
07-04-2014
11-11-2020
115
Posts created
55
Kudos given
2
Solutions
141
Kudos received
My Ideas
(1 Idea Submissions)Latest Contributions by FinnianO_Connor
|
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
|
456
|
|
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
|
456
|
|
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
|
456
|
|
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
|
616
|
|
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
|
1404
|
|
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
|
434
|
|
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
|
443
|
|
POST
|
Good to know, thanks. Sometimes less options are easier to deal with!
... View more
01-18-2019
07:23 AM
|
2
|
0
|
798
|
|
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
|
798
|
|
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
|
226
|
Activity Feed
- Got a Kudo for Re: Low isolation and maximum number of instances. 11-11-2020 02:06 AM
- Got a Kudo for Re: Low isolation and maximum number of instances. 11-11-2020 02:06 AM
- Got a Kudo for Re: Identify device which is used to fill in Survey123 form?. 11-11-2020 02:06 AM
- Got a Kudo for Re: Passing Parent GlobalID to Survey123 using Custom URL. 11-11-2020 02:06 AM
- Got a Kudo for Re: Query Layer with View_Scale Parameter using Oracle Data?. 11-11-2020 02:06 AM
- Got a Kudo for Re: Add reporting and ability to export to CSV. 10-27-2020 12:42 PM
- Got a Kudo for Re: Low isolation and maximum number of instances. 08-24-2020 02:53 AM
- Got a Kudo for Survey123 filter forms based on Active Portal. 07-03-2020 09:36 AM
- Got a Kudo for Re: Add reporting and ability to export to CSV. 06-08-2020 11:37 AM
- Got a Kudo for Re: Add reporting and ability to export to CSV. 05-22-2020 07:29 AM
- Got a Kudo for Re: Add reporting and ability to export to CSV. 04-14-2020 12:34 PM
- Got a Kudo for Indicator - Days Since Last Event. 03-25-2020 08:13 AM
- Got a Kudo for Re: Add reporting and ability to export to CSV. 02-24-2020 01:27 PM
- Got a Kudo for Re: Low isolation and maximum number of instances. 01-18-2020 01:13 PM
- Got a Kudo for Re: Add reporting and ability to export to CSV. 11-17-2019 06:28 AM
- Got a Kudo for Survey123 filter forms based on Active Portal. 10-01-2019 01:46 PM
- Got a Kudo for Re: Export & Email features on Survey123 mobile app. 10-01-2019 11:10 AM
- Posted Re: Query Layer with View_Scale Parameter using Oracle Data? on Geodatabase Questions. 09-10-2019 12:31 AM
- Kudoed Define Vector Tile Package Extent for emmornile1. 09-05-2019 04:24 AM
- Posted Re: Query Layer with View_Scale Parameter using Oracle Data? on Geodatabase Questions. 09-05-2019 04:00 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|