Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About mpboyle
mpboyle
Honored Contributor
since
07-04-2014
07-06-2026
566
Posts created
97
Kudos given
4
Solutions
1239
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(30 Idea Submissions)Latest Contributions by mpboyle
|
POST
|
Thanks for the thorough reply! What I gather from that is, it's best-form to update the CA certificate within ArcGIS Server. Having said that, is it best to delete the CA certificate and import the new one, or can we use the 'importSignedCertificate' operation on our existing CA certificate within Server admin...or does it really matter which way we do it?
... View more
05-24-2017
10:13 AM
|
0
|
1
|
11619
|
|
POST
|
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
05-24-2017
09:34 AM
|
0
|
4
|
11619
|
|
POST
|
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
05-24-2017
08:09 AM
|
0
|
0
|
11619
|
|
POST
|
Our SSL Certificate is expiring and I'm wondering if once we get our new certificate, do we need to import the certificate through ArcGIS Server admin or is updating the certificate on the server sufficient? We use a wildcard certificate and am assuming that is what our IT will be renewing, so the name of the certificate will likely not change. If we need to import the certificate, should we delete the existing certificate entry and then import? Just looking for best practices since we only do this once every few years! System Configs OS: Windows Server 2012 R2 ArcGIS Server: 10.4.1 Thanks!
... View more
05-24-2017
07:34 AM
|
0
|
11
|
18083
|
|
IDEA
|
I think it would be nice to have the ability to create multiple pop-ups for an ArcGIS Online layer, similar to having the ability to create multiple label classes for a layer within ArcMap/ArcGIS Pro. Some sort of Sql expression dialogue (like what is available within the Filter tool) would be available to query the features used by each pop-up, again similar to label classes within ArcMap/ArcGIS Pro. There are certain cases where we'd like to create different custom pop-ups for features based on their attributes, and currently, the only way to do this is to publish separate layers, or add the layer multiple times and apply a filter.
... View more
05-18-2017
08:11 AM
|
7
|
1
|
1981
|
|
POST
|
I have noticed since upgrading to ArcGIS 10.4, the SRID values of our feature classes have changed. All of our production feature classes use NAD 1983 (2011) Iowa State Plane North and are managed in SQL Server 2014 Standard using Geometry as the shape. The SRID for this spatial reference in 10.3 and prior is 103045. Starting at 10.4 the SRID is now 6463. Granted, our end users will never know the difference, and all the properties of the spatial reference are identical. However, I notice a huge difference when trying to run the same spatial queries within SQL Server that use multiple tables, most notably, for those feature classes that are created in 10.4, trying to apply the same spatial query doesn't work at all because the SRID value of the feature class created in 10.4 is different from those created in previous versions. Below are examples trying to execute an intersect spatial query using a point feature class created in 10.3 (103045) and one created in 10.4 (6463) against an underlying polygon feature class created in 10.3 or prior (103045). Is there any way of updating the SRID of a feature class without having to re-create the feature class in a current version? This wouldn't be too terrible except any relationships based on Esri system fields, for example, the GlobalID field when using attachments, would be very difficult to re-create because they would be re-generated for the new feature class. One of the benefits of us maintaining our data in SQL Server is the ability to do these type of spatial queries within the database. By having multiple SRID values for the same coordinate system, we are losing the ability to run these types of queries. Both feature classes (point shown below and underlying polygon) both have 103045 as SRID --- values are returned in the spatial query where features intersect Same point feature class, however, created in 10.4 with SRID equal to 6463 and underlying polygon in 103045...no records are returned
... View more
04-28-2017
10:26 AM
|
2
|
4
|
8537
|
|
POST
|
Is there any documentation on Esri's Support site specific to this bug? I'm unable to find anything.
... View more
04-25-2017
09:39 AM
|
0
|
1
|
2724
|
|
POST
|
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
04-21-2017
01:15 PM
|
0
|
3
|
5849
|
|
POST
|
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
04-21-2017
11:45 AM
|
0
|
1
|
5849
|
|
POST
|
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
04-21-2017
10:51 AM
|
0
|
0
|
5849
|
|
POST
|
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
04-21-2017
06:00 AM
|
0
|
10
|
5849
|
|
POST
|
I created a hosted vector tile layer and would like to create a custom style. I have read through the docs on how to create a custom style (save a layer, edit the style, update the style), but when I try to add the styled layer to a web map, it seems to fail to load, as it never displays. Am I missing something in the styled .json file, like paths to the sprites, glyphs, or url defined at the beginning of the json...? The URL to my test vector tile layer using a custom style can be found here. Thanks!
... View more
04-19-2017
02:45 PM
|
0
|
12
|
8371
|
|
IDEA
|
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
03-17-2017
06:32 AM
|
0
|
1
|
4674
|
|
POST
|
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
02-24-2017
01:47 PM
|
12
|
6
|
7967
|
|
POST
|
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
02-16-2017
01:17 PM
|
3
|
10
|
24628
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 6 | 06-26-2026 01:24 PM | |
| 1 | 06-26-2026 01:56 PM | |
| 3 | 06-26-2026 01:14 PM | |
| 17 | 06-26-2026 02:43 PM | |
| 6 | 06-26-2026 01:34 PM |
Activity Feed
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. a month ago
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 07-17-2026 04:19 PM
- Got a Kudo for ArcGIS Online Updates --- A Customer Viewpoint. 07-07-2026 09:57 AM
- Got a Kudo for ArcGIS Online Updates --- A Customer Viewpoint. 07-07-2026 09:27 AM
- Posted Re: June 2026 AGOL Update - issues....so many issues on ArcGIS Online Questions. 07-06-2026 10:38 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 07-06-2026 05:53 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 07-06-2026 05:47 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-30-2026 07:27 PM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-30-2026 10:34 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-30-2026 08:29 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-30-2026 08:29 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-30-2026 08:29 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-30-2026 08:28 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-30-2026 08:28 AM
- Got a Kudo for ArcGIS Online Updates --- A Customer Viewpoint. 06-30-2026 07:46 AM
- Got a Kudo for ArcGIS Online Updates --- A Customer Viewpoint. 06-29-2026 06:44 PM
- Got a Kudo for ArcGIS Online Updates --- A Customer Viewpoint. 06-29-2026 12:20 PM
- Got a Kudo for ArcGIS Online Updates --- A Customer Viewpoint. 06-29-2026 10:59 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-29-2026 10:57 AM
- Got a Kudo for Re: June 2026 AGOL Update - issues....so many issues. 06-29-2026 10:57 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-06-2026
10:34 AM
|