Latest Contributions by mpboyle

‎02-14-2017

Melita Kennedy‌, I'm working through the Lambert Conic Conformal (2sp) example and I'm a little confused about how to find the 't' value since I'm not starting with a latitude...I'm trying to convert from State Plane to lat/lon. Can I use any pair of lat/lon values I want to do the forward calculations? I'm also confused about the 'r' value. What's the difference between the 'r' and 'r F ' values? Below is what I've got so far and feel pretty confident these values are correct based on the example provided in the guidance notes. Any advice to finish this off would be appreciated!

‎02-13-2017

Melita Kennedy‌, I stumbled across this thread when searching for a way to convert state plane coordinates to lat,lon values on the fly in Sql Server. I have found the guidance note 7.2 document you noted and am overwhelmed by the math Before I dive too deep into trying to understand it, I first wanted to check and make sure that we can/should be able to convert our data to lat,lon values using the formulas provided. Below is a screenshot of the coordinate system properties most of our data is within (Iowa State Plane NAD 1983 2011, wkid: 6463). If I had an x,y coordinate pair (below), can we use the formulas in note 7.2 to conver to lat,lon?...if yes, what formula exactly would we need to use? Any help you can provide is much appreciated! x: 5402473.342 y: 3421155.895

‎02-13-2017

Coming back to this thread nearly 2 years after original posting... finally had some time dive into Sql Server sequences, and they are surprisingly easy to understand, even for someone like me who is not a DBA, or Sql Server expert. I have been testing out using a sequence within a Sql Server trigger and have found some success. Below are some template screenshots others may find useful. Some quick notes about our environment: ArcGIS version: 10.4.1 DBMS: Sql Server 2014 Standard Step 1: create your sequence --- some background reading on their arguments is probably useful... t-sql examples are provided in the above link can also use SSMS --- expand database | Programmability | Sequences | New Sequence Step 2: apply your sequence to a Sql trigger Notes: The trigger template was provided to us by an Esri solution engineer; I'm not a DBA ... so the t-sql written may be improved upon without my knowing Line 14: if using a versioned dataset, your table name will need to be the associated 'add' (a) delta table Line 15: this trigger ONLY runs after an insert (create) Line 25: this trigger ONLY runs on the inserted record, not all records Step 3: test Sql trigger The highlighted fields in the screenshot below were all generated from Sql triggers Seq = next value within my sequence (sequence started at 1001) --- only on inserts Seq String = concatenation of 'WS-' and sequence value --- only on inserts Random = random 10-character string --- only on inserts Result Display = concatenation of Collection Date, Test, Result Value, and Result Unit --- on inserts and updates

‎01-25-2017

Does any know if it's possible to pass a search parameter through a URL into the Related Table Chart widget? To give you an idea of what I'm hoping to do, I think it would be nice to have the ability to construct a URL and have it as a hyperlink within a pop-up that would automatically perform the search within the Related Table widget, rather than having to rely on a user to open the widget and enter the search criteria or click on the map. I'm guessing this an not an easy JavaScript fix, and was curious if anyone had attempted to do something similar...?

‎01-25-2017

I think it would be nice / advantageous to have the ability to pass in a search parameter to the URL for certain WAB widgets. This would allow users to create hyperlinks that would automatically trigger the widget and perform the search, rather than relying on the end users to open the widget and enter the search parameters.

‎01-17-2017

This also got me thinking that perhaps it's our base map that needs to be adjusted. Since our production data is in Iowa State Plane North projection, is it best practice to keep our data in State Plane and set the data frame to a transformation when creating cached base maps?...rather than what we are currently doing which is loading our State Plane data into feature classes with Web Mercator as the projection.

‎01-17-2017

Melita Kennedy‌, Thanks for the reply! I did some testing on my end, re-publishing the service with various transformations (I didn't go through the entire list of possible transformations). Below are my results. Based on the resulting alignments of each, is there any reason NOT to use None as a transformation? Transformations that still resulted in an offset: 1) WGS_1984_(ITRF08)_To_NAD_1983_2011 2) WGS_1984_(ITRF00)_To_NAD_1983_2011 Transformations that resulted in alignment: 1) None 2) NAD_1983_HARN_To_NAD_1983_2011 + NAD_1983_HARN_To_WGS_1984

‎01-13-2017

All of our production feature classes are in NAD 1983 Iowa State Plane North 2011 (wkid: 6463). We have a separate file gdb that we use for caching base maps where we load our production feature classes into this file gdb. The feature classes within our cache file gdb are in Web Mercator (wkid: 3857). Below is a screenshot showing one of our parcel features overlaid on top of one of our base maps. You can see the parcel outline in gray within our base map. The pink parcel is the same feature as what is used to make the base map. The parcel service is in Iowa State Plane North spatial reference, while the base map is in Web Mercator spatial reference. I'm wondering why the parcel service (pink) doesn't line up directly on top of the parcel outline in the base map? Am I missing something when publishing the service? Do I need to apply a transformation? Do I need to publish the service where the Data Frame is in Web Mercator as well?

‎01-13-2017

I think it would be nice to have the base map gallery widget in Web AppBuilder (Dev edition 2.2 if what we're using) allow base maps that use more than 1 service the ability to mix spatial references. Within ArcGIS Online, this doesn't seem to be an issue, but if we use the same web maps as base maps within the Basemap Gallery widget in Web AppBuilder, it doesn't seem to work. We like to use the Esri Imagery (Web Mercator) service as a backdrop for many of our imagery base maps because it provides a continuous image. On top of that, we would like to pull in historical imagery hosting by our State, but their image services are in UTM. Again, within ArcGIS Online, this isn't an issue and works great, but if we try to use the same layering or the same web map as a base map in Web AppBuilder only the Esri Imagery service shows.

‎01-13-2017

I think it would be nice to have the base map gallery widget in Web AppBuilder (Dev edition 2.2 if what we're using) allow base maps that use more than 1 service the ability to mix spatial references. Within ArcGIS Online, this doesn't seem to be an issue, but if we use the same web maps as base maps within the Basemap Gallery widget in Web AppBuilder, it doesn't seem to work. We like to use the Esri Imagery (Web Mercator) service as a backdrop for many of our imagery base maps because it provides a continuous image. On top of that, we would like to pull in historical imagery hosting by our State, but their image services are in UTM. Again, within ArcGIS Online, this isn't an issue and works great, but if we try to use the same layering or the same web map as a base map in Web AppBuilder only the Esri Imagery service shows.

‎11-09-2016

Our Engineering Department has a Topcon HiPer SR receiver with a FC-5000 data collector running Windows 10. They are trying to use Collector with this receiver but it doesn't seem to want to connect when using their data collector. When inside Collector, if they try to switch the receiver to their HiPer SR receiver, the connection will always fail. If they switch to pairing their receiver with a phone or tablet (Android was our test), the receiver does seem to be able to connect inside Collector, but it doesn't appear that the receiver is actually communicating with Collector because the accuracy icon at the bottom of Collector remains red and shows no estimated accuracy. Just wondering if anyone out there has any suggestions to try?...are we missing a step somewhere?...perhaps enabling mock locations on the tablet? Is it the type of receiver that is the limitation? I thought I read that with the latest release of Collector, as long as the device output a NMEA string, Collector could consume it, or perhaps that was only for the GPS metadata? Thanks in advance!

‎09-02-2016

ichivite-esristaff‌, Thanks for the quick reply! I guess my idea would be that Survey123 would be used to populate a related table from the feature within Collector, is that kind of the same track as a Custom URL Scheme pop-up? Would the feature and table relationship keys auto-populate within the gdb? Thanks again!

‎09-02-2016

Is it possible to open a Survey123 form from Collector? For example, if a user is out collecting data using Collector and we have a Survey123 form that is used for inspections, can a user be linked to the Survey123 form from the feature within Collector? If so, can fields be pulled over from Collector, like a common key field?

‎09-02-2016

Is there a way within Survey123 to control the width of a question? For example, placing more than one question per line? If not, Is this something that is perhaps under consideration?

‎09-02-2016

That was easy, and makes sense

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by mpboyle

Re: Formula For State Plane to Lat/Lon Conversion

Re: Formula For State Plane to Lat/Lon Conversion

Re: Auto-Increment Field within SDE

Pass Search Parameter through URL with Related Table Chart Widget

Pass Search Parameters through URL for WAB widgets

Re: Features Not Aligned

Re: Features Not Aligned

Features Not Aligned

Allow Mixed Spatial References in WAB Basemap Gallery Widget

Allow Mixed Spatial References in WAB Basemap Gallery Widget

Topcon High Accuracy Receiver Collection

Re: Open Survey123 from Collector

Open Survey123 from Collector

How to Control Width and Layout of Form

Re: How to Show Field Using OR Expression

Re: Use Button to filter list

Print Error After February 2026 Update

Overwrite Experiences to Maintain IDs

Provide Icons in Image Elements

Re: Ballooning Feature Layer Size