Latest Contributions by mpboyle

We use Web Adaptor.  The server hosting our Web Adaptor also uses a wildcard certificate, and it seems like it already has been updated with a more current certificate that will not expire until 2020. Since we use Web Adaptor, do we need to register an SSL certificate with ArcGIS Server?...or does the certificate on the Web Adaptor server take care of this?  We have a self-signed certificate that is not set to expire anytime soon. ... View more

I noticed there is a supported operation for 'importSignedCertificate' on our current wildcard SSL certificate.  Instead of deleting and making a new entry, can this be used to overwrite/update the certificate information? ... View more

Is there any documentation on Esri's Support site specific to this bug?  I'm unable to find anything. ... View more

cwhitmore-esristaff‌, Last mention, I promise It seems like just updating the previous vector tile package wasn't clearing out the json style because the '<>' symbols were still within layer names.  So...I went ahead and created a new vector tile package item, published it to a hosted vector tile layer, and then copied and saved a layer.  I now have the 'Download Style' as an option. Thanks again for pointing me in the right direction! ... View more

Chris Whitmore‌, I removed all special characters I could find (, / <>) from the layers and label classes and am still not getting the 'Download Style' option when saving a layer from the hosted vector tile layer. The steps I'm doing are: 1) Adding the original hosted vector tile layer to a web map 2) Copy the layer 3) Save the copied layer Updated hosted vector tile layer: http://linncounty-gis.maps.arcgis.com/home/item.html?id=dd4f63dd42834faabb2823d85f70dab4 Shared saved layer of hosted vector tile layer: http://linncounty-gis.maps.arcgis.com/home/item.html?id=8cb312e64ae245a0917ba18601ed90c8 Am I missing a step...?  Do I need to place the URLs within the styled json?...shouldn't this be done automatically based on your above comments and the steps I'm taking? ... View more

Chris Whitmore‌, I had a feeling it might be characters within the layer names!  I went through and eliminated commas but hadn't gotten to the other characters yet. I appreciate the help!!! On a side note...I have another question regarding offsetting vector tile labels, if you have any insights on this it would be appreciated.  Can it be handled using text-offset property within the style? ... View more

Kelly Gerrow‌, I probably deleted it when testing, sorry! The URL to the source vector tile layer I'm using to test can be found here.  Whenever I copy the layer and save it, I never seem to get the option for 'Download Style', I can view the style, but that's it. ... View more

Kory Kramer‌, We use Attribute Assistant for a variety of things here, however Attribute Assistant is confined to ArcMap.  Our organization is using Collector more and more for mobile data collection, and with these edits taking place outside of ArcMap, it would be nice to have a similar function at the database level.  We have implemented Sql triggers within our RDBMS to auto-populate fields in a similar fashion as to what Attribute Assistant does...however, I think it would be nice to have Esri controlled procedures that are supported. It's a bit of a hassle to have field staff collect data and then have someone with ArcMap be responsible for back-populating attributes when they have time or realize it needs to be done. ... View more

Thomas Marshall‌ Since I can't attach through a comment, below are the Sql functions, and some notes to be aware of... These functions calculate longitude and latitude for Lambert Conformal Conic 2-parallel projections (as this is what our production features are stored in (wkid: 6463 --- NAD 1983 (2011) Iowa State Plane North)) Note lines 59 through 76 --- you will need to provide the values for your coordinate system You can find these values within the XY Coordinate System  properties of a feature class I do this by storing the values in a table and call them through a SELECT statement, that way the values are stored in one place (example below) Longitude Calculation USE [**DatabaseName**] GO /****** Object:  UserDefinedFunction [dbo].[get_longitude] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:     Your Name -- Create date: Date -- Description:     Returns longitude given x,y coordinates in Lambert Conformal Conic projection -- ============================================= CREATE FUNCTION [dbo].[get_longitude] (      -- Add the parameters for the function here      @x numeric(24,12),  --state plane x coordinate      @y numeric(24,12)   --state plane y coordinate ) RETURNS numeric(24,12) AS BEGIN      -- Declare the return variable here    DECLARE    @pi numeric(24,12),     --pi    @fx numeric(24,12),     --false easting    @fy numeric(24,12),     --false northing    @cmD numeric(24,12),    --central meridian in degrees    @cmR numeric(24,12),    --central meridian in radians    @sp1D numeric(24,12),   --standard parallel 1 in degrees    @sp1R numeric(24,12),   --standard parallel 1 in radians    @sp2D numeric(24,12),   --standard parallel 2 in degrees    @sp2R numeric(24,12),   --standard parallel 2 in radians    @loD numeric(24,12),    --latitude of origin in degrees    @loR numeric(24,12),    --latitude of origin in radians    @smjrM numeric(24,12),  --semimajor axis in meters    @smjrF numeric(24,12),  --semimajor axis in feet    @smnrM numeric(24,12),  --semiminor axis in meters    @smnrF numeric(24,12),  --semiminor axis in feet    @flat numeric(24,12),   --flattenging    @iflat numeric(24,12),  --inverse flattening    @e numeric(24,12),      --eccentricity    @m1 numeric(24,12),     --calculation value    @m2 numeric(24,12),     --calculation value    @t1 numeric(24,12),     --calculation value    @t2 numeric(24,12),     --calculation value    @tf numeric(24,12),     --calculation value    @n numeric(24,12),      --calculation value    @F numeric(24,12),      --calculation value    @rf numeric(24,12),     --calculation value    @rz numeric(24,12),     --calculation value    @tz numeric(24,12),     --calculation value    @zz numeric(24,12),     --calculation value    @lonR numeric(24,12),   --longitude in radians    @lonD numeric(24,12)    --longitude in degrees    -- Add the T-SQL statements to compute the return value here    SET @pi = pi()    -- false origin values    SET @fx = /* Enter false easting value */    SET @fy = /* Enter false northing value */    -- latitude of origin values    SET @loD = /* Enter latitude of origin value */    SET @loR = @loD * @pi / 180    -- central meridian values    SET @cmD = /* Enter central meridian value */    SET @cmR = @cmD * @pi / 180    -- standard parallel values    SET @sp1D = /* Enter standard parallel 1 value */    SET @sp1R = @sp1D * @pi / 180    SET @sp2D = /* Enter standard parallel 2 value */    SET @sp2R = @sp2D * @pi / 180    -- semimajor axis values    SET @smjrM = /* Enter semimajor axis value in meters */    SET @smjrF = @smjrM * 3.2808333    -- semiminor axis values    SET @smnrM = /* Enter semiminor axis value in meters */    SET @smnrF = @smnrM * 3.2808333    -- inverse flattening value    SET @iflat = @smjrM / (@smjrM - @smnrM)    -- flattenging value    SET @flat = 1 / @iflat    -- eccentricity value    SET @e = SQRT(2 * @flat - SQUARE(@flat))    -- m values    SET @m1 = COS(@sp1R) / POWER((1 - SQUARE(@e) * SQUARE(SIN(@sp1R))), 0.5)    SET @m2 = COS(@sp2R) / POWER((1 - SQUARE(@e) * SQUARE(SIN(@sp2R))), 0.5)    -- t values    SET @t1 = TAN((@pi / 4) - (@sp1R / 2)) / POWER((1 - (@e * SIN(@sp1R))) / (1 + (@e * SIN(@sp1R))), (@e / 2))    SET @t2 = TAN((@pi / 4) - (@sp2R / 2)) / POWER((1 - (@e * SIN(@sp2R))) / (1 + (@e * SIN(@sp2R))), (@e / 2))    SET @tf = TAN((@pi / 4) - (@loR / 2)) / POWER((1 - (@e * SIN(@loR))) / (1 + (@e * SIN(@loR))), (@e / 2))    -- n value    SET @n = (LOG(@m1) - LOG(@m2)) / (LOG(@t1) - LOG(@t2))    -- f value    SET @F = @m1 / (@n * POWER(@t1, @n))    -- r value    SET @rf = @smjrF * @F * POWER(@tf, @n)    -- r' value    SET @rz = POWER(POWER((@x - @fx), 2) + POWER((@rf - (@y - @fy)), 2), 0.5)    -- t' value    SET @tz = POWER((@rz / (@smjrF * @F)), (1 / @n))    -- thetha' value    SET @zz = ATAN((@x - @fx) / (@rf - (@y - @fy)))    -- longitude value in radians    SET @lonR = ((@zz / @n) + @cmR)    -- longitude value in degrees    SET @lonD = (@lonR * 180) / @pi      -- Return the result of the function      RETURN @lonD; END ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Latitude Calculation USE [**DatabaseName**] GO /****** Object:  UserDefinedFunction [dbo].[get_latitude] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author:     Your Name -- Create date: Date -- Description:     Returns latitude given x,y coordinates in Lambert Conformal Conic projection -- ============================================= CREATE FUNCTION [dbo].[get_latitude] (      -- Add the parameters for the function here      @x numeric(24,12),  --state plane x coordinate      @y numeric(24,12)   --state plane y coordinate ) RETURNS numeric(24,12) AS BEGIN      -- Declare the return variable here    DECLARE    @pi numeric(24,12),     --pi    @fx numeric(24,12),     --false easting    @fy numeric(24,12),     --false northing    @cmD numeric(24,12),    --central meridian in degrees    @cmR numeric(24,12),    --central meridian in radians    @sp1D numeric(24,12),   --standard parallel 1 in degrees    @sp1R numeric(24,12),   --standard parallel 1 in radians    @sp2D numeric(24,12),   --standard parallel 2 in degrees    @sp2R numeric(24,12),   --standard parallel 2 in radians    @loD numeric(24,12),    --latitude of origin in degrees    @loR numeric(24,12),    --latitude of origin in radians    @smjrM numeric(24,12),  --semimajor axis in meters    @smjrF numeric(24,12),  --semimajor axis in feet    @smnrM numeric(24,12),  --semiminor axis in meters    @smnrF numeric(24,12),  --semiminor axis in feet    @flat numeric(24,12),   --flattenging    @iflat numeric(24,12),  --inverse flattening    @e numeric(24,12),      --eccentricity    @m1 numeric(24,12),     --calculation value    @m2 numeric(24,12),     --calculation value    @t1 numeric(24,12),     --calculation value    @t2 numeric(24,12),     --calculation value    @tf numeric(24,12),     --calculation value    @n numeric(24,12),      --calculation value    @F numeric(24,12),      --calculation value    @rf numeric(24,12),     --calculation value    @rz numeric(24,12),     --calculation value    @tz numeric(24,12),     --calculation value    @zz numeric(24,12),     --calculation value    @latTR numeric(24,12),  --latitude trial in radians    @lat1R numeric(24,12),  --latitude iteration 1 in radians    @lat2R numeric(24,12),  --latitude iteration 2 in radians    @lat3R numeric(24,12),  --latitude iteration 3 in radians    @lat4R numeric(24,12),  --latitude iteration 4 in radians    @latFR numeric(24,12),  --latitude final iteration in radians    @latTD numeric(24,12),  --latitude trial in degrees    @lat1D numeric(24,12),  --latitude iteration 1 in degrees    @lat2D numeric(24,12),  --latitude iteration 2 in degrees    @lat3D numeric(24,12),  --latitude iteration 3 in degrees    @lat4D numeric(24,12),  --latitude iteration 4 in degrees    @latFD numeric(24,12)   --latitude final iteration in degrees    -- Add the T-SQL statements to compute the return value here    SET @pi = pi()    -- false origin values    SET @fx = /* Enter false easting value */    SET @fy = /* Enter false northing value */    -- latitude of origin values    SET @loD = /* Enter latitude of origin value */    SET @loR = @loD * @pi / 180    -- central meridian values    SET @cmD = /* Enter central meridian value */    SET @cmR = @cmD * @pi / 180    -- standard parallel values    SET @sp1D = /* Enter standard parallel 1 value */    SET @sp1R = @sp1D * @pi / 180    SET @sp2D = /* Enter standard parallel 2 value */    SET @sp2R = @sp2D * @pi / 180    -- semimajor axis values    SET @smjrM = /* Enter semimajor axis value in meters */    SET @smjrF = @smjrM * 3.2808333    -- semiminor axis values    SET @smnrM = /* Enter semiminor axis value in meters */    SET @smnrF = @smnrM * 3.2808333    -- inverse flattening value    SET @iflat = @smjrM / (@smjrM - @smnrM)    -- flattenging value    SET @flat = 1 / @iflat    -- eccentricity value    SET @e = SQRT(2 * @flat - SQUARE(@flat))    -- m values    SET @m1 = COS(@sp1R) / POWER((1 - SQUARE(@e) * SQUARE(SIN(@sp1R))), 0.5)    SET @m2 = COS(@sp2R) / POWER((1 - SQUARE(@e) * SQUARE(SIN(@sp2R))), 0.5)    -- t values    SET @t1 = TAN((@pi / 4) - (@sp1R / 2)) / POWER((1 - (@e * SIN(@sp1R))) / (1 + (@e * SIN(@sp1R))), (@e / 2))    SET @t2 = TAN((@pi / 4) - (@sp2R / 2)) / POWER((1 - (@e * SIN(@sp2R))) / (1 + (@e * SIN(@sp2R))), (@e / 2))    SET @tf = TAN((@pi / 4) - (@loR / 2)) / POWER((1 - (@e * SIN(@loR))) / (1 + (@e * SIN(@loR))), (@e / 2))    -- n value    SET @n = (LOG(@m1) - LOG(@m2)) / (LOG(@t1) - LOG(@t2))    -- f value    SET @F = @m1 / (@n * POWER(@t1, @n))    -- r value    SET @rf = @smjrF * @F * POWER(@tf, @n)    -- r' value    SET @rz = POWER(POWER((@x - @fx), 2) + POWER((@rf - (@y - @fy)), 2), 0.5)    -- t' value    SET @tz = POWER((@rz / (@smjrF * @F)), (1 / @n))    -- thetha' value    SET @zz = ATAN((@x - @fx) / (@rf - (@y - @fy)))    -- latitude trial value in radians    SET @latTR = (@pi / 2) - (2 * ATAN(@tz))    -- latitude iteration 1 value in radians    SET @lat1R = (@pi / 2) - (2 * ATAN((@tz * POWER((1 - (@e * SIN(@latTR))) / (1 + (@e * SIN(@latTR))), (@e / 2)))))    -- latitude iteration 2 value in radians    SET @lat2R = (@pi / 2) - (2 * ATAN((@tz * POWER((1 - (@e * SIN(@lat1R))) / (1 + (@e * SIN(@lat1R))), (@e / 2)))))    -- latitude iteration 3 value in radians    SET @lat3R = (@pi / 2) - (2 * ATAN((@tz * POWER((1 - (@e * SIN(@lat2R))) / (1 + (@e * SIN(@lat2R))), (@e / 2)))))    -- latitude iteration 4 value in radians    SET @lat4R = (@pi / 2) - (2 * ATAN((@tz * POWER((1 - (@e * SIN(@lat3R))) / (1 + (@e * SIN(@lat3R))), (@e / 2)))))    -- latitude final iteration value in radians    SET @latFR = (@pi / 2) - (2 * ATAN((@tz * POWER((1 - (@e * SIN(@lat4R))) / (1 + (@e * SIN(@lat4R))), (@e / 2)))))    -- latitude trial value in degrees    SET @latTD = (@latTR * 180) / @pi    -- latitude iteration 1 value in degrees    SET @lat1D = (@lat1R * 180) / @pi    -- latitude iteration 2 value in degrees    SET @lat2D = (@lat2R * 180) / @pi    -- latitude iteration 3 value in degrees    SET @lat3D = (@lat3R * 180) / @pi    -- latitude iteration 4 value in degrees    SET @lat4D = (@lat4R * 180) / @pi    -- latitude final iteration value in degrees    SET @latFD = (@latFR * 180) / @pi      -- Return the latitude in degrees      RETURN @latFD; END ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Melita Kennedy‌, Ended up created 2 Sql functions to calculate longitude and latitude values given a pair of State Plane x,y coordinates.  I then use these functions inside a Sql trigger to auto-calculate lat/lon fields within my feature classes. I appreciate the help, works great! Should anyone want the actual code behind the functions, I can provide it, however it is based on the formulas found within the references above. ... View more

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! ... View more