Latest Contributions by danbecker

‎07-30-2019

Federated portal/server, version 10.7. Webmap in Enterprise works fine. SDE gdb (postgresql) also works fine in Pro, but when trying to load the map in Collector the layers will not draw. Nothing in server or portal error logs. Anyone have this happen? We are shut down at this point with field work.

‎06-13-2019

ArcGIS Enterprise 10.7, PostGreSQL 9.6, ESRI ST_Geometry spatial type, Archiving enabled. I set a definition query on a feature layer, "defquery IS NULL", then published the feature service with sync enabled. In Pro, webmap and Collector, newly created features are shown since "defquery" field is null by default. On the webmap I checked the settings to make sure "Device will download and get updates to features and attachments." is selected. In ArcGIS Pro, If I calculate the defquery field to be "hide", i.e. it's no longer NULL, then it is hidden from the map in ArcGIS Pro like you would expect. Same with the webmap, it's also hidden in the feature service. BUT, in Collector, after a sync the feature remains, it is not removed from the map. Is this expected behavior? This used to work in Collector classic, wondering if something changed. It's nice to show/hide features via a definition query on the feature service so field workers aren't continually re-downloading the offline map. With the current iOS Collector version, the only way to "hide" those features is to re-download the map. thanks.

‎06-10-2019

Hosted feature layer created by Survey123 connect. From the HFL, I created a view layer with only a subset of fields displayed, the view layer is also shared differently. I run a .py script that updates the point location of the HFL records, but the associated view layer doesn't update. Any tricks to get the view layer to update?

‎04-30-2019

Thanks Aaron. I figured that since Tracker is in it's infancy the recorded "horizontal_accuracy" attribute is not correct (just like in the early days of Collector). For our workflow, this is an issue. We're required to report the accuracy of our tracklog lines because the protocol survey's we're performing require the field staff to walk transects that are 15 ft apart (we generated a set of fishnet lines to use as a guide). If the accuracy is capped at 5m (by the iOS LM) and that's what we report, then we may not have surveyed according to the protocol, as adjacent tracklog lines could potentially be 5m (~15 ft) +/- of where the line geometry is placed thereby creating 30 ft "gaps" in violation of the protocol. Tracker needs to report the accuracy of the GPS stream it's utilizing. We'll have to tell our client "even though the line feature states an average accuracy of 5 meters, it's likely much more accurate but we're not sure". By GNSS metadata, I was just referring to "location_source", "session_id", "signal_strength", ect... Not necessarily GNSS metadata, but regardless, these values aren't being regularly populated. Don't get me wrong, Tracker has been working great, it was 3 instructions in an email to the field staff to roll it out, very simple, which is awesome. We spun up a dedicated Linux VM for the spatiotemporal datastore, holy smokes does that take a lot of memory! These are shortcomings of the new tracking functionality for our org: GNSS accuracy reporting, no GUI tools to delete data from the hosted feature layer and requirement for Geoanalytics Server License to do almost anything with the track points. The ArcGIS API for Python will easily handle the deleting and point-to-line conversion though.

‎04-30-2019

We're using the Tracker Mobile app with various bluetooth GPS receivers (BadElf Surveyor and EOS Arrow-100) both of which have a horizontal accuracy around 1m, the Arrow-100 commonly gets below 0.5m. Collector is correctly reporting the GPS accuracy, yet the field team is saying that Tracker reports 15+ ft accuracy. Questions: 1) Does tracker (iOS) use the connected bluetooth GPS receiver to position points? 2) The location_tracking hosted feature service records "Horizontal Accuracy" in the attribute table, along with other GNSS metadata, but what is the h. accuracy unit? Meters, feet, ect...? 3) Why is some of the GNSS metadata missing, i.e. <Null> in the feature service? I know that Collector erases GNSS metadata when a feature is manually placed, what causes this behavior in Tracker?

‎04-29-2019

How do you enable the Delete capability on the location_tracking hosted feature service? I tried to using the Service Detials page in Portal but got an error "Location Tracking Schema cannot be modified". As the Portal Admin (and owner of the Hosted Feature Service), I would like to delete some test track points, using Pro but get an error that "user does not have permission to execute the operation [delete capability is not set]. Thanks.

Arcade - Popup Profile, define global · ‎04-25-2019

ArcGIS Enterprise 10.7. I have an Arcade script that generates a datasheet ID and displays it in the popup title. Users manually type the datasheet ID into the correct field when entering a new feature in Collector. This is obiv. a workaround because Arcade cannot calculate field values in Collector... But, it seems like the Arcade script is called each time a user types something into an attribute field. Is there any way to define a true global variable in the "Popup" Profile? Like $map, $feature, ect.. Something like $feature["popupGlobal"] that could be created in the Attribute Expression would be really nice.

‎03-29-2019

type name label calculation default integer total_repeats Number Repeats count(${dummy_counter}) decimal mean_veg Average round(sum(${num_veg}) div ${total_repeats},2) begin repeat quads Quad Data Entry hidden dummy_counter incraments repeat count 1 integer num_veg # Vegetative 0 decimal num_veg_sqdif Sq Difference Veg pow((${num_veg} - ${mean_veg}),2) 0 end repeat A portion of the XLS form is above, the problem is that the num_veg_sqdif doesn't automatically re-calculate after new repeat records are added. Notice how the calculation uses the mean of all values inside the repeat. This mean value changes when a new repeat is added, thus all previously calculated num_veg_sqdif values need to be re-calculated. The only way to do that is to manually page back through the repeat records and hit the arrow button (looks like the recycle symbol) on the num_veg_sqdif field. The survey123 docs say this: "Unlike the default column, which is evaluated only when the survey is opened or the question becomes relevant, calculations are evaluated every time answers in your survey that are inputs to the calculation change or become relevant." Why isn't the re-calculation happening inside the repeat, is this expected behavior? BTW: this entire post would be a moot point if there were a few more aggregation functions that work with repeats, submitted idea here: https://community.esri.com/ideas/16449

‎03-26-2019

After testing further, the problem seems to be survey123 disconnecting from the EOS Arrow-100 receiver after a period of time. Our field workflow includes counting small plants in plots along a transect. So, the field crew starts a new survey123 form at the beginning of the transect and adds 20 or 30 plots along the transect; each plot is a new repeat record. Whenever they stop to flag or count plants (sometimes takes 20 minutes of longer), the iPad goes into standby and looses bluetooth connection with the Arrow-100. It seems like survey123 is having issues re-connecting while in the middle of a survey form, it lacks the "GPS" ^ shaped button that Collector has on the map screen. Anyone experience re-connect issues like this before?

‎03-22-2019

A geopoint question is inside a repeat. We don't need a basemap displayed, we just need to record our xy position several times in a survey. I.e. we don't want to hassle with creating a tile package, side-loading, ect... The survey is downloaded and the offline iOS device is connected to an EOS Arrow-100 GPS Receiver. Collector is working fine, high accuracy positions are confirmed working. The field crew then follows a link on a Collector popup to launch the survey123 form with the repeated geopoint. The geopoint question just says "No Location". The crosshair locate button just spins. As expected, the geopoint map says "offline map preview not available" because we never side loaded a tile package, ect.. We have also specified the EOS Arrow-100 in the survey123 location provider settings, the geopoint question still says "No Location". Same result if we switch to Integrated Receiver, "no Location". The iOS settings give permission for survey123 to use location services, checked that a few times. Any help would be appreciated. 1) Does offline survey123 require some type of basemap for geopoint questions? 2) Are survey123 and Collector fighting over the GPS metadata stream? thanks,

‎03-01-2019

Confirmed; that fixes it. Thanks so much!!

‎03-01-2019

Portal, Server and Datastore are all at 10.6.1. We cannot export any hosted feature layers from portal to FGDB, every time we get an error that says "failed". It doesn't matter how the hosted feature layer was created, (Survey123 Connect, created in Portal, ect...) they all fail to be exported to FGDB. Anyone else experience this? It looks like this is happening after the upgrade from 10.6 to 10.6.1. Prior to the update, I exported everything to FGDB and it was working. Here's the error in the Server Manager log: Instance of the service 'System/PublishingTools.GPServer' crashed. Please see if an error report was generated in 'C:\arcgisserver\logs\machinename.local\errorreports'. To send an error report to Esri, compose an e-mail to [email protected] and attach the error report file. Also validated the ArcGIS_Data_Store Managed Database in Server Manager, that was successful.

‎02-06-2019

PostgreSQL 9.5 installed on Linux Ubuntu 16.04, using ST_Geometry spatial type. I had a cron job scheduled to backup all databases nightly using pg_dump cmd, backup output was set to plain-text SQL (.sql) file. THIS IS NOT ADVISED. Before you read anything else, switch your pg_dump command right now to use either "custom" or "tar" backup formats, see the doc here: PostgreSQL: Documentation: 9.6: pg_dump Why is this so important? Because when using ST_Geometry spatial type, certain schemas have to be restored before others. When you have a plain text .sql dump as I did, you are unable to hand-pick what schemas are restored, it's an "all or nothing" restore using psql. Take a look at the ESRI postgre restore doc here: Restore a geodatabase to PostgreSQL—Help | ArcGIS Desktop. Restoring the entire .sql file resulted in tons of errors and ultimately a blank geodatabase. Schema seemed OK, but data was missing. Everything in the above ESRI doc says to use pg_restore, but that cmd only takes "custom" or "tar" backup files as input, NOT plain text .sql. I ended up getting everything restored by searching for "schema: public" in the .sql dump, then running those sql queries first, then restoring the entire .sql dump with psql. Painful lesson, be advised.

‎11-19-2018

ArcGIS Pro 2.2.4 Repo steps below. Add a feature class to map, symbolize by unique values. In the "Field 1" dropdown, set a custom expression using Arcade. I simply concatenated 2 text fields using ", ". I dont' think the expression matters though, just so your using it Add map to a layout, set up a simple map series Expand the legend item in the layout, select the feature class where you set the unique value symbology expression. In the Element Pane, check "only show features visible in the map extent". In the dropdown under that you can select either option "within map frame" or "within map series". The legend does not update, all features in the above feature class are shown, (not filtered by map frame extent) this is the issue. If you remove the custom expression from the symbology in #2 above, everything works as expected

‎08-27-2018

The hosted feature service I'm attempting to dump was generated from survey123 connect. After wasting hours last Friday dealing with globalid values not being properly dumped via REST API and CopyFeatures_Management tool, I just decided to do this the quick way today. Simply login to portal, Export the entire database to FGDB. And, like magic, the local FGDB contains all globalid and parentglobalid values. Now, I can just loop over the various tables and build my exported Excel file like I want. Sure, it would be nice to just dump via REST API so one doesn't have to continually login/dump to FGDB/extract, ect... but the process only takes 2 minutes vs. hours trying to figure out how to do it via the REST API. Our fixed price contracts don't support learning curves very well thanks everyone.

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by danbecker

asking to sign in, secured layers

2-way sync not working, latest iOS version

Enterprise 10.7 View Layer not Updating

Re: Tracker - bluetooth GPS being used?

Tracker - bluetooth GPS being used?

Location tracking Hosted Feature Service - Delete Capability

Arcade - Popup Profile, define global

Calculation Doesn't Fire Inside Repeat

Re: geopoint, offline basemap required?

geopoint, offline basemap required?

Re: 10.6.1 Cannot Export HFL to FGDB

10.6.1 Cannot Export HFL to FGDB

PostgreSQL - Important Backup Info

Bug - map series that shows unique value symbology expression

Re: CopyFeatures_management doens't include globalid

ESRI Survey123 Website Sending Report API Requests...

Re: Portal for ArcGIS upgrade from 11.5 to 12.1 no...

Re: Azure Files premium file share - SLOW File Geo...

arcpy layout.export - hosted feature layers not sh...

Re: Survey123 Date Only shows incorrectly on Repor...