POST
|
Yikes, and I was thinking that I had hit on a better solution, not a worse one. It doesn't look like the table being copied from AWS to our geodatabase has spatial indexing (at least not for lat/long coordinates fields), since I'm using the "Export Table" geoprocessing function and the lat/long coordinates are being stored in regular Double format and there's no "*" next to the field name like there is for the OBJECTID. Is there another work-around to this such as adding spatial indexing after the fact to the table (if that's possible) or even creating duplicate lat/long fields to the table coordinates could be copied into? Thank you, Thank you, Thank you for all the advice so far.
... View more
11-09-2023
05:39 AM
|
0
|
1
|
741
|
POST
|
Thanks again Scott. I have had very limited exposure to both the Data Interoperability extension and FME but would love to learn more about their capabilities. I have been trying out the approach you recommended and have created a Model Builder function that can copy the table from the AWS server to our local geodatabase. My next challenge/question to the community is how do automate that Model Builder function to make it run every night? Is that even possible with Model Builder in ArcGIS Enterprise? I'm also abandoning my original plan to use publish a point feature service with a table join (to the table that's now been copied into our SQL database), in favor of a Database View, something I also have very little experience with, leading to a second community posting here. I think this makes more sense since the table will always have the lat/long coordinates for each account location while the point feature would require constant updating. Again anyone who created a process like this that can share their thoughts/recommendations will have my sincere appreciation and kudos.
... View more
11-08-2023
02:04 PM
|
0
|
3
|
754
|
POST
|
Thankyou Marcelo, We are using an enterprise geodatabase, yes. I read through the documentation but I didn't really find out what I needed to about the scripting of the View Definition. Sample code, if anyone can provide it, would really help out here.
... View more
11-08-2023
01:31 PM
|
0
|
0
|
315
|
POST
|
Hi There, I am trying to create a Database View from a table that contains data extracted from our utility billing software with latitude and longitude coordinates for each account. I'm very new to this and I'm relying on an example view I found in an ESRI Community posting here which I've modified by adding a "Select" statement to try to make it include a some of attribute data from the table (ServiceLocation, CurrentAccount etc.). The view works in to extent that the locations are plotting correctly based on the lat/long coordinates, but when I attempt to view the attribute table I get a "Failed to retrieve a page of rows" error. CREATE VIEW VIPCustomerPointsView
AS
SELECT ServiceLocation, CurrentAccount, ServiceLocationOid, AccountNumber, AccountOid, StartDate, LocationId, GISId, ServiceLatitude, ServiceLongitude, ServiceStreetNumber, ServiceStreetName, ServiceStreetSuffix, ServiceCity, ServiceZipcode
geography::Point(CASE ISNULL(ServiceLatitude,0)
WHEN 0 THEN '37.809737'
ELSE ServiceLatitude END,
CASE ISNULL(ServiceLongitude,0)
WHEN 0 THEN '-85.509352'
ELSE ServiceLongitude END
, 4326) AS GeomPoint
FROM DBO.dbo_IdsForGISFinalCable1 I'm guessing that I've used the wrong syntax with my select statement or missed something somewhere and that's preventing the View from fetching all the attribute data. If anyone can help by showing me the correct script I should use you all have my sincere appreciation. Thanks!!
... View more
11-08-2023
07:56 AM
|
0
|
2
|
443
|
POST
|
Thank you Scott for your candid and very illuminating response. I suspected that the solution might be to develop some kind of script to take an image of the AWS table every night and write that to the SQL geodatabase within our enterprise. I have not had any experience with creating this type of process myself. You wouldn't happen to know of any resources (tutorials, sample code, etc.) that might help me get started on this track? I'm hoping I might find something within the esri community forums, though it can sometimes can be a task trying to narrow down search terms to find what you're looking for!
... View more
11-08-2023
05:10 AM
|
0
|
5
|
780
|
POST
|
Hi, I'm trying to do something that may not be possible in our Enterprise Portal (version 11.0). We have a feature service that I would like to publish with a table join to a table containing live customer billing data hosted in an Amazon Web Services (AWS) database. This AWS database is not managed by me or my organization, I just have a URL and credentials that I've used to connect to using the Microsoft OLE DB connection for SQL Server. I'm trying Add the database as a data store to our Portal in ArcGIS Pro to a machines we have set up for hosting that is federated with our Portal, but when I do this I get an error informing me there was an Error validating with the server (see attached image). I've read through the documentation for Adding a database data store item on ESRI's website which says that I need to have a .SDE database connection file. As mentioned above I don't have direct access to the AWS site and before I go down a rabbit hole with the AWS/billing software's IT department I wanted to see if anyone here could advise me on whether adding an AWS database as a datastore is even possible in Enterprise, and if not if there's a different method we could employ to allow us to publish a feature service linked to that billing data. Thank you all for any assistance/expertise you can provide
... View more
11-07-2023
02:12 PM
|
0
|
8
|
886
|
POST
|
Yeah, that's an option for sure, especially if everything is hosted in our AGOL account. If there's a more automated option I'll leave this question open for suggestions until the end of the week. Thanks again!!
... View more
03-21-2022
08:55 AM
|
0
|
0
|
784
|
POST
|
Hi Doug, Thank you again for being so helpful. Running a Python script doesn't sound like a bad option, especially if it can be automated somehow. Are you using them for a similar application to what I've described (joining Survey123 record data into another feature)? If so would you be willing to share here (or offline) or is there another ESRI resource you can point me toward to help get me started? Would this approach be possible with everything being hosted under our AGOL organization account or would it need to be running in an Enterprise Portal?
... View more
03-21-2022
08:37 AM
|
0
|
2
|
786
|
POST
|
Hi Doug, Thanks again for your response on Friday last week. I jumped right in and tested the Arcade Expressions you kindly suggested and I’m pleased to say that with a little finagling I was able to get it working by substituting the relevant feature and field names as shown below: (Note this Expression was created in the Attribute Expressions section of the Water Backflow Preventer Feature Pop-up, since I’m assuming this is the “Parent” and the Backflow Prevention Device Test Form Survey123 records are the “Child” in this data relationship) var sql = "LocationAccNo = '" + $feature.LocationAccNo + "'";
var tbl = Filter(FeatureSetByName($map,"Backflow Prevention Device Test Form", ['LocationAccNo'], false), sql);
return First(tbl).LocationAccNo Hurrah! But… There’s still a couple more steps that I’m not so clear on that will probably require additional code that you (or anyone else reading this) might be able to help me out with. First off, I would like if possible to have the symbology of the Backflow Preventer location points reflect whether there is a corresponding Survey123 record or not. This will allow the user to see at a glance which Backflow Preventers have/have not been inspected. My first preference would be to use the Filter functions in the Web Map, but my custom “Survey123 Join” field does not show up in the list that the Filter expression can be built from. The Symbology tools for the layer have an option to create a “New Expression” that take me to a similar Arcade expression builder, however I’m not able to simply copy and paste the same expression I used for the Pop-up (I get a “Parse Error:featuresetbyname is not available” error). Secondly, I need a way to filter and list the Backflow Preventer locations that do not have associated Survey123 records that could ideally be outputted to a .csv file (with name & address information) to be used for mail merges etc. I notice that when I view the table in the Web Map or in Web App Builder there is a column for the joined data but the values are not initially shown (I have to click on a little “Show” link to make them show up). Would adapting one of the other Arcade Expressions you suggested solve this? (I chose the first one because it was the simplest). Finally, this workflow is intended to be performed annually, so any advice on how to expand the expression to look at a date field and return/join only the results within a calendar year would be most appreciated. If this is not possible or is exponentially more complicated, a work around I think could use would simply be to export out the previous years Survey123 reports and then wipe the data table clean at start of each year, but this is doesn’t seem like the most elegant solution. Thanks again for any help/advice you can provide
... View more
03-21-2022
08:05 AM
|
0
|
4
|
792
|
POST
|
Hi Doug, thank you for the quick response! I've taken a look at the FeatuteSet function and found the following Blog Posts quite informative. Sadly, the example given in the Blog doesn't match my use case. In their example the FeatureSet is used to return the number of point features intersecting a poly feature. It would help me tremendously to see an example or learn what Arcade expression to use in order to join information in the Survey123 table to the Backflow Device Point Feature, using a common field (such as an Account Number). I think if that is possible using the Feature Set function then I will really be onto something and can use the Data Expressions as you suggested.
... View more
03-18-2022
12:51 PM
|
0
|
6
|
831
|
POST
|
Fellow Esri users, We’re looking at creating a publicly accessible Survey123 form for contractors to report Backflow Prevention Device tests. That’s the easy part and we already have the form created. What I’d like to do now is link results (records) created in this Survey123 form to a Point feature layer containing Backflow Device locations (there are only around 150 of them in the system) so that I can create a Dashboard to display the status of whether each Device has been tested or not. I know that I can use the Analysis tools available in the ArcGIS online web map to run a table join on the two data sets, but I what I really want need is for these two data sources to be continually linked or for the join to be automated in some way. Is this something that can be accomplished with features hosted entirely within our ArcGIS Online account or would we need to host some/all of the data ourselves through an Enterprise Portal? I’ve seen another topic which asked if Survey123 could automatically update a separate layer and that certainly might be an option we could investigate though the solution involved using Notebook to read, transform and write to the other layer, which was a little beyond my experience and comfort zone so if anyone has a simpler method I would love to get your input. Apologies as well if there's something obvious that I'm missing here or if this question has already been answered (I did look!). Thanks you'all
... View more
03-18-2022
11:04 AM
|
0
|
8
|
906
|
POST
|
I changed the Role assigned to the user account that is logged-in in the Tracker App to a regular "Data Editor" role and the tracks have now been pushed so I can view them all in the Track Viewer. I am curious still whether its possible to create a custom role that has the "View location tracks" privilege that I can assign to the user account(s) that would benefit from being able to see the Tracks (not least the guys performing the mosquito fogging so they don't go over ground they have already covered). Currently the "View location tracks" privilege is only available to the top tier Administrator role. Are there any plans by ESRI to update one or more of the other roles (i.e. Data Editor, Publisher) with this privilege or create a new "Tracker" role? When creating custom roles, it might also be useful to be able to start with one of the preset roles and modify it, as opposed to needing to configure everything from scratch (I guess I should post this to the Ideas section). Thanks
... View more
08-11-2020
05:41 AM
|
0
|
0
|
1154
|
POST
|
I created a Group to keep the Tracker content separate from our other features/maps, and the "TrackerTest" account is a member of this group and should have access to both the Tracks and Location Tracking feature services. Here is the search result for "Location Tracking Service" (The highlighted symbols indicate the layers are shared with the "Mosquito Fogging Tracker" group) Here is what is shown in the "Last Known Locations" data: The username is the one that is set up in the Tracker App on the iPad (BtownTracker) the created date is showing 7/15/2020 and the timestamp is 8/10/2020.
... View more
08-10-2020
10:26 AM
|
0
|
0
|
1154
|
POST
|
Hi Aaron, Here are the logs that were exported when I followed your directions: 8/10/20, 10:40 AM Ping tracking service 8/10/20, 10:39 AM Failed to update last known location 8/10/20, 10:39 AM Ping tracking service 8/10/20, 10:39 AM Regenerating lines 8/10/20, 10:39 AM Reachability changed: Connected 8/10/20, 10:39 AM Tracking started 8/10/20, 10:39 AM Tracking manager lines table loaded 8/10/20, 10:39 AM Tracking manager log table loaded 8/10/20, 10:18 AM Failed to update last known location 8/10/20, 10:18 AM stationary updating LKL service with last location 8/10/20, 10:17 AM Failed to update last known location 8/10/20, 10:17 AM stationary updating LKL service with last location 8/10/20, 10:16 AM Failed to update last known location 8/10/20, 10:16 AM stationary updating LKL service with last location 8/10/20, 10:15 AM Failed to update last known location 8/10/20, 10:15 AM stationary updating LKL service with last location 8/10/20, 10:14 AM Failed to update last known location 8/10/20, 10:14 AM stationary updating LKL service with last location 8/10/20, 10:13 AM Failed to update last known location 8/10/20, 10:13 AM stationary updating LKL service with last location 8/10/20, 10:11 AM Failed to update last known location 8/10/20, 10:11 AM stationary updating LKL service with last location 8/10/20, 10:10 AM Failed to update last known location 8/10/20, 10:10 AM stationary updating LKL service with last location 8/10/20, 10:09 AM Failed to update last known location 8/10/20, 10:09 AM stationary updating LKL service with last location 8/10/20, 10:08 AM Failed to update last known location 8/10/20, 10:08 AM stationary updating LKL service with last location 8/10/20, 10:07 AM Failed to update last known location 8/10/20, 10:07 AM stationary updating LKL service with last location 8/10/20, 10:06 AM Failed to update last known location 8/10/20, 10:06 AM stationary updating LKL service with last location 8/10/20, 10:05 AM Failed to update last known location 8/10/20, 10:05 AM stationary updating LKL service with last location 8/10/20, 10:05 AM Ping tracking service 8/10/20, 10:05 AM tracks fail-safe timer triggered 8/10/20, 10:04 AM Failed to update last known location 8/10/20, 10:04 AM stationary updating LKL service with last location 8/10/20, 10:03 AM Failed to update last known location 8/10/20, 10:03 AM stationary updating LKL service with last location 8/10/20, 10:02 AM Failed to update last known location 8/10/20, 10:02 AM stationary updating LKL service with last location 8/10/20, 10:01 AM Failed to update last known location 8/10/20, 10:01 AM stationary updating LKL service with last location 8/10/20, 10:00 AM Failed to update last known location 8/10/20, 10:00 AM stationary updating LKL service with last location 8/10/20, 9:59 AM Failed to update last known location 8/10/20, 9:59 AM stationary updating LKL service with last location 8/10/20, 9:58 AM Failed to update last known location 8/10/20, 9:58 AM stationary updating LKL service with last location 8/10/20, 9:57 AM Failed to update last known location 8/10/20, 9:57 AM stationary updating LKL service with last location 8/10/20, 9:56 AM Failed to update last known location 8/10/20, 9:56 AM stationary updating LKL service with last location 8/10/20, 9:55 AM Ping tracking service 8/10/20, 9:55 AM Ping tracking service 8/10/20, 9:55 AM Failed to update last known location 8/10/20, 9:55 AM stationary updating LKL service with last location 8/10/20, 9:54 AM Failed to update last known location 8/10/20, 9:54 AM stationary updating LKL service with last location 8/10/20, 9:54 AM Ping tracking service 8/10/20, 9:54 AM tracks fail-safe timer triggered 8/10/20, 9:53 AM Failed to update last known location 8/10/20, 9:53 AM stationary updating LKL service with last location 8/10/20, 9:52 AM Failed to update last known location 8/10/20, 9:52 AM stationary updating LKL service with last location 8/10/20, 9:51 AM Failed to update last known location 8/10/20, 9:51 AM stationary updating LKL service with last location 8/10/20, 9:50 AM Failed to update last known location 8/10/20, 9:50 AM stationary updating LKL service with last location 8/10/20, 9:49 AM Failed to update last known location 8/10/20, 9:49 AM stationary updating LKL service with last location 8/10/20, 9:48 AM Failed to update last known location 8/10/20, 9:48 AM stationary updating LKL service with last location 8/10/20, 9:47 AM Failed to update last known location 8/10/20, 9:47 AM stationary updating LKL service with last location 8/10/20, 9:46 AM Failed to update last known location 8/10/20, 9:46 AM stationary updating LKL service with last location 8/10/20, 9:45 AM Regenerating lines 8/10/20, 9:45 AM Purged 0 features 8/10/20, 9:45 AM Failed to update last known location 8/10/20, 9:45 AM stationary updating LKL service with last location 8/10/20, 9:44 AM Regenerating lines 8/10/20, 9:44 AM Regenerating lines 8/10/20, 9:44 AM Regenerating lines 8/10/20, 9:44 AM Failed to update last known location 8/10/20, 9:43 AM Tracking started 8/10/20, 9:43 AM Tracking stopped 8/10/20, 9:42 AM Failed to update last known location 8/10/20, 9:42 AM Tracking started 8/10/20, 9:42 AM Purged 0 features 8/10/20, 9:41 AM Ping tracking service 8/10/20, 9:41 AM Ping tracking service 8/10/20, 9:41 AM Failed to update last known location 8/10/20, 9:41 AM Tracking stopped 8/10/20, 9:41 AM Tracking started 8/10/20, 9:41 AM Regenerating lines 8/10/20, 9:41 AM Ping tracking service 8/10/20, 9:41 AM Reachability changed: Connected 8/10/20, 9:41 AM Received applicationWillTerminate Aug 10, 2020 at 9:41:01 AM 8/10/20, 9:41 AM Tracking manager lines table loaded 8/10/20, 9:41 AM Tracking manager log table loaded 8/10/20, 8:34 AM Ping tracking service 8/10/20, 8:34 AM Ping tracking service 8/10/20, 8:34 AM Ping tracking service 8/10/20, 8:34 AM tracks fail-safe timer triggered Hope this helps!
... View more
08-10-2020
07:43 AM
|
0
|
2
|
1154
|
POST
|
We have a tracker application we created within our ArcGIS Online account (all the maps and data is hosted through our AGOL account) to monitor areas our City Public Works department have passed through to fog for mosquitoes. Everything appeared to be work as it should during testing with tracks automatically pushed from the iPad (the Tracker app is installed on) and viewable within the Track Viewer application. Now tracks are no longer being pushed automatically and we cannot even use the manual "Upload Now" button to push them (tapping the update button does not activate that function and the date of last upload remains July 21, 2020). Restarting the app and restarting the iPad itself do not fix the problem. I am afraid to sign out of the app incase I lose the data that is stored under that account. Is there something I'm missing or some other setting needed to upload our tracks? One further detail (I'm not sure if this would have any bearing on the problem we've encountered) is that we wanted the mobile user to be able to view their tracks through a regular web map without having to give them the full admin privileges usually required to View Location Tracks and access to the Track Viewer. We therefore set up a custom user type within the "Member Role" settings with the "View Location Tracks" privilege and assigned the account that is logged in on the Tracker App on the iPad to this customer user type. I appreciate any assistance that can be provided.
... View more
08-07-2020
06:28 AM
|
0
|
6
|
1241
|
Online Status |
Offline
|
Date Last Visited |
01-17-2024
05:08 AM
|