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
146
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
|
1143
|
|
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
|
1143
|
|
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
|
1143
|
|
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
|
1303
|
|
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
|
1
|
3368
|
|
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
|
711
|
|
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
|
1185
|
|
POST
|
Good to know, thanks. Sometimes less options are easier to deal with!
... View more
01-18-2019
07:23 AM
|
2
|
0
|
2316
|
|
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
|
2316
|
|
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
|
534
|
|
POST
|
In environments where there is no Internet connection ArcGIS Explorer and Collector are great at visualising data that has been taken offline in advance. Is it possible to integrate new data collected in Survey123 with the Explorer or Collector maps? For people working offline in a disconnected environment being able to visualise their new data in relation to previously collected data is important. Cheers, Finnian
... View more
01-11-2019
08:51 AM
|
0
|
2
|
787
|
|
POST
|
I'd also be interested to know if anyone has successfully integrated the Fleetmatrics data into GeoEvent. Cheers, Finnian
... View more
12-17-2018
09:22 AM
|
0
|
0
|
1787
|
|
POST
|
The data in AGOL was initially created by publishing a Survey123 form from Survey123 Connect, where the related table is the result of a 'repeat' in the form. I've then downloaded the hosted feature layer from AGOL as a file geodatabase so the feature class and the table are in the same geodatabase together with associated relationship class. The feature class and table also have attachments so each has another relationship class.
... View more
12-06-2018
06:18 AM
|
0
|
0
|
3584
|
|
POST
|
From the Share ribbon (Publish web layer). In the Share Map As A Web Layer dialog, on the Content tab, only the feature class shows up, not the table. Not sure if the table should be displaying here?
... View more
12-04-2018
07:25 AM
|
0
|
3
|
3584
|
|
POST
|
Trying this today in Pro 2.2.4 and the related table does not get created in AGOL. Adding the same data (feature class with related table from a file geodatabase) to ArcMap and I can successfully publish the hosted feature layer with the related table.
... View more
12-04-2018
06:52 AM
|
1
|
5
|
11813
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 12-04-2018 06:52 AM | |
| 1 | 08-20-2018 06:33 AM | |
| 1 | 08-20-2018 05:22 AM | |
| 1 | 09-05-2019 04:00 AM | |
| 1 | 01-18-2017 06:30 AM |
Activity Feed
- Got a Kudo for Indicator - Days Since Last Event. 09-13-2023 02:02 PM
- Got a Kudo for Re: Publish hosted feature service with related tables - Won't work with ArcGIS Pro 2.0. 06-16-2023 08:34 AM
- Got a Kudo for Re: Related Data in ArcGIS. 11-01-2022 04:53 AM
- Got a Kudo for Re: Allow Portal Access. 06-10-2022 05:28 AM
- Got a Kudo for Allow Portal Access. 06-10-2022 05:27 AM
- 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
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|