Latest Contributions by MatthewCarey

I have a map service with 4 layers within it, all of which contain date-time fields. The most date-intensive layer has 6 fields containing dates and times.  The layers are being served up from an Oracle geodatabase, and I'm using ArcGIS Server 10.7.1.  The dates and times are recorded in US Eastern Standard Time (GMT - 5). In a web application, the times would show in pop-ups as 5 hours earlier than the time in the database/feature class, apparently interpreting the times as UTC. The way to remedy this seemed to be to go into the map service parameters and specify the Eastern time zone, and also check on the daylight savings checkbox: In the pop-ups the correct time was displayed, but the rendering performance of the map service instantly went way down, and Severe warnings appeared in the ArcGIS Server logs saying "Error performing query operation. Wait time of the request to the service '<service name>' has expired." On setting the time zone back to None, the service's good performance returned. Has anyone else run into a similar issue? Is it possible that a layer with ~100,000 records and 6 date and time fields could have its performance affected by the time zone settings? If so, is there a better way to get the right dates and times in pop-ups? Thanks!       ... View more

I have a procedure that inserts a bunch of point features into an Oracle feature class using a function like this: INSERT INTO THETABLE (JOB_NUMBER, MUNICIPALITY, THE_LATITUDE,THE_LONGITUDE,SHAPE) SELECT B.JOB_NUMBER,                 A.MUNICIPALITY,                A.LATITUDE,                A.LONGITUDE,                sde.st_geometry(THE_LONGITUDE, THE_LATITUDE,null,null,4326) FROM TABLE1 A, TABLE2 B WHERE A.BATCH_ID = 'SOME NUMBER' --------------------------------------------------- It's working but running slower than expected, it runs at about 30,000 records per minute.  I could use a lot better performance than this if possible; I need a process to run every 15 minutes or so that needs to handle hundreds of thousands of records every time, if not more.  It says Here in Esri's documentation that this is the optimal way to create points: If anyone knows of something I may be missing that's slowing down the insert process I'd really appreciate it. I have database folks and developers I can work with to make changes if we have a direction to go in, but as it is this is quite new to all of us. We have tried running the same Insert process without creating the geometry in the SHAPE column, and it's way faster, just a few seconds to run for ~ 30,000 records. So it's the geometry part that seems to be the culprit. Thanks in advance. ... View more

Field inspectors in my organization have some fairly specific needs. They want to fill out a form in Survey 123 on an iPad, and then later they want to have the survey content appear in custom reports, which they would then like to modify in the iOS version of Word before printing.  My solution so far: a) Inspector fills out survey in Survey 123 for iOS and submits it b)  In the back office, an ArcGIS API for Python script runs periodically, generates custom report(s) (Word documents) based on data in the hosted feature layer and moves them to the personal content folder of the user who submitted the form c) I would like the user to look at their content in ArcGIS Companion for iOS, find the report they need, have it open in Word for iOS and be able to edit it before printing. Part c is easily done with a web browser on a PC, but the field staff would like to keep it 'all iOS' if possible. So far I've found that if I navigate to the report item in Companion, I can click Open and the only choice is to open it in the In-app browser. When I do that, it appears in a window where it appears to be read-only and it says drive.google.com at the top (this may be to do with the way I've opened Word documents in the past, perhaps, having only recently installed Word), and none of the options available after pressing the Share button seem to enable me to open it in the Word for iOS application.  Changing the 'Open links in > '  setting in Companion from In-app browser to System default browser doesn't seem to yield any different results.  I thought I'd try using the iOS Safari browser to try and access the report by logging in to the organization in the same way as on a desktop and navigating to the content. Under the default mobile view it can't seem to get at the report, clicking the item's thumbnail doesn't do anything. If I 'request desktop view' for the site, I can then get at the report. It appears in the browser window with an Amazon AWS URL, and from there I can hit the Share button and choose Copy to Word, which opens a read only copy in Word. I can then hit 'Save a copy' and edit that copy, at last! If you're still with me, hopefully you'd agree that the Safari workaround seems like too many steps for an overworked field inspector to tackle, especially the 'request desktop site' part. So, does anyone know if/how it would be possible to pick out a report in Companion and then send that to Word for editing? Or, if you can think of a different workflow that would achieve the same results I'd welcome that too, reluctant as I am to discard my painstakingly developed report generation script! I have considered emailing the Word documents directly to the users but I believe that would be tough to implement because of organizational policies and constraints. ... View more

In Survey123 Connect (2.6.4) I'm struggling with getting the form to perform a calculation in a question only if I answer yes to an earlier question. I have a select_one yes_no question ({samples}) which is "Did you take samples today?" If the answer is yes, I would like it to generate a sample number (text, in the field sample_coll_no) which concatenates text that's already been entered by the user such as county code, target pest, and date. It has this in the calculation column: ${county}+"-"+${targetsci} ..... and so on. So when, using the 'relevant' column, I make sample_coll_no relevant only when ${samples} = 'yes', or make the group that it's in relevant only when ${samples} = 'yes', it doesn't populate it in the form; there doesn't seem to be a triggering event that would make that happen. If I make the 'relevant' column blank for the sample number question, it performs the calculation whether or not the "did  you take samples" question is answered yes or no. And I don't want a sample number filled out when none was taken. I'm not sure if it makes a difference but this survey is for filling in fields in a related table; the main point feature layer is trap locations and this related table is for the site visits; there will be multiple site visits for each site/trap.  Can anyone suggest a different approach to my problem?  It seems like a somewhat standard thing that I'm trying to achieve but somehow I'm not getting there. Thanks! ... View more