Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About DrewDowling
DrewDowling
Frequent Contributor
since
07-04-2014
3 weeks ago
319
Posts created
300
Kudos given
4
Solutions
87
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(3 Idea Submissions)Latest Contributions by DrewDowling
|
POST
|
@ChristopherPawlyszynGreat.Thank you for the clarification.
... View more
11-11-2021
09:11 AM
|
0
|
0
|
1923
|
|
POST
|
ArcGIS License manager has 2 daemon, Sever and vendor. I have always set the Server port to something in the range of 27000 - 27009 and opened up the servers firewall. I never remember having to set the vendor daemon port before. We recently moved to ArcGIS Pro and named users. We want to move our license server into a DMZ and open up port 27000 so users can use ArcGIS Pro while working remotely. Will we have to set the vendor daemon port and open up this port as well?
... View more
11-10-2021
02:43 PM
|
0
|
2
|
1971
|
|
POST
|
I'm trying to track down schema locks coming from map services. I have noticed that shared instances no longer have the check box to "lock database schema". The attached images shows this difference. However I have determined that the locks are coming from shared instances using the code below. Is there a way to tell shared instances to not lock schemas in the same way as you can with dedicated instances? The shared instance process ID doesn't tell me which map service is causing the lock. SELECT A.SERVER_ID, B.OWNER || '.'|| B.TABLE_NAME "TABLE", A.NODENAME, L.LOCK_TYPE FROM SDE.SDE_PROCESS_INFORMATION A, SDE.SDE_TABLE_REGISTRY B, SDE.SDE_TABLE_LOCKS L
WHERE A.SDE_ID = L.SDE_ID AND L.REGISTRATION_ID = B.REGISTRATION_ID
ORDER BY NODENAME, SERVER_ID;
... View more
11-10-2021
02:11 PM
|
1
|
1
|
2774
|
|
POST
|
Great this really clarifys things for me. Thank you Amir.
... View more
11-09-2021
12:24 PM
|
1
|
0
|
2899
|
|
POST
|
We are prototyping our data model using the latest version of the fabric, Pro 2.9 equivalent. The existing control monuments are classed as first, second, third etc order points. (Sorry I'm more a developer than a surveyor so my terminology is off I know) A subtype sounds very reasonable. Will this allow us to do adjustments? We currently don't do true adjustment work and are very interested in this functionality.
... View more
11-08-2021
07:27 PM
|
0
|
0
|
2917
|
|
POST
|
My understanding is that control monuments should be loaded into the fabric_points feature class. Is this correct? If so then how are monuments distinguished from corner points? Looking at the fabric_points attributes I don't see how we would correlate monument confidence to the existing attributes for use in adjustments.
... View more
11-08-2021
02:54 PM
|
0
|
4
|
2955
|
|
IDEA
|
It would be great to see this implemented but only as an option and not automatic. I have cases where I don't want attribute rules copied as they would break the destination FC. If both "feature class to feature class" and "copy" bring in attribute rules then I will have to do post processing to remove them.
... View more
10-27-2021
12:18 PM
|
0
|
0
|
4773
|
|
POST
|
@Matthew_Williams wrote: ... unless it's to try to get you to move to ArcPro In my humble opinion yes.
... View more
08-03-2021
11:16 AM
|
0
|
0
|
4803
|
|
IDEA
|
I want to add my support for this. As others have said, this is a bug not a feature and it needs to be addressed asap if ESRI is serious about getting people to move to Pro from ArcCatalog.
... View more
04-30-2021
10:44 AM
|
0
|
0
|
3504
|
|
POST
|
It looks like the last forum migration messed up the formatting of your code. I've reformatted it to maybe help others. Hope you don't mind. USE yourDB
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
-- =============================================C
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 USE yourDB
GO
/****** Object: UserDefinedFunction [dbo].[get_latitude] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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
03-10-2021
09:09 AM
|
0
|
0
|
6826
|
|
POST
|
I'm trying to apply an attribute rule to an enterprise geodatabase feature class. I have a tree feature class that has both species (scientific) and common name attribute. I'm trying to automatically fill in the common name based on what species an editor enters. I have a lookup table, ENV_TREESPECIES_LUT, that lists the species name and common name. The general workflow I'm trying to achive is: If a new tree feature has a species value then search the ENV_TREESPECIES_LUT for that species and return the common name But no no matter what logic I've tried the attribute rule editor in Pro gives me an evaluation error on line 5 of this script below. It seems to the filter function. What is the correct way to filter on an feature attribute? I should mention that the code validates in the expression builder, the error is only thrown when I try to save the attribute rule. var cn = ""
var fspecies = $feature.Species
if(! isEmpty($feature.Species))
var LUT = FeatureSetByName( $datastore, "ENV_TREESPECIES_LUT", ["Species", "CommonName"], false)
var common_names = Filter(LUT, "Species = @fspecies")
var common_name = first(common_names)
if (! IsEmpty(common_name.CommonName))
cn = common_name.CommonName
return cn
... View more
03-08-2021
02:42 PM
|
0
|
2
|
3405
|
|
POST
|
I finally got this working by using the command prompt to install it. This first time used the command prompt it failed with the same "installer is no longer responding" error. The second time the command prompt install worked. The only difference was I added the parameter to set the install location. Instead of taking the default location I set the install location to c:\myportal and installing from the command prompt worked. 😕
... View more
01-08-2021
02:26 PM
|
0
|
0
|
2219
|
|
BLOG
|
@RichardFairhurstI just want to say thank you so much for this post. I've been using it a reference for years.
... View more
01-06-2021
08:53 AM
|
1
|
0
|
30788
|
|
POST
|
I'm experiencing the exact same issue. Clean Portal 10.8.1 install on a clean windows server 2019 VM instance is giving an installer unresponsive error. Did anybody ever find a work around?
... View more
12-29-2020
11:23 AM
|
0
|
1
|
4320
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 09-19-2023 09:32 AM | |
| 1 | 01-21-2025 01:39 PM | |
| 1 | 07-29-2025 10:45 AM | |
| 1 | 07-17-2025 03:33 PM | |
| 1 | 07-10-2025 10:30 AM |
Activity Feed
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 04-08-2026 01:42 PM
- Got a Kudo for Re: Recommended startup order (and delay) of the ArcGIS Enterprise Services. 04-03-2026 12:21 PM
- Posted Can an advanced editor user type cross enterprises? on ArcGIS Pro Questions. 04-01-2026 03:30 PM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 01-22-2026 12:01 PM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 01-21-2026 04:41 PM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 01-21-2026 04:41 PM
- Kudoed ArcGIS Monitor in Action: Observability for GIS Environments of All Sizes by Quartic Solutions for AlyssaGrant1. 01-14-2026 10:51 AM
- Posted Re: AttributeTabEmbeddableControl on Feature Service Layer on ArcGIS Pro SDK Questions. 12-24-2025 11:15 AM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 11-05-2025 12:50 PM
- Kudoed File size limit in manager.overwrite for OGLEngineering. 11-03-2025 09:50 AM
- Kudoed Re: File size limit in manager.overwrite for Leo_Lerner. 11-03-2025 09:50 AM
- Posted Re: Arcgis API on AWS Lambda on ArcGIS API for Python Questions. 10-17-2025 12:20 PM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 10-16-2025 02:16 PM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 10-14-2025 03:16 AM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 10-13-2025 02:40 PM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 10-13-2025 12:31 PM
- Got a Kudo for Re: Copy or Export/Import XML fail due to DBMS sequence not found. 09-29-2025 11:58 AM
- Posted Re: Downloading Data from Enterprise Portal to Local Machine (w/Viewer User) on ArcGIS Enterprise Portal Questions. 09-23-2025 12:46 PM
- Got a Kudo for Prevent the Default version from being directly edited, only allow Post operations to update the Protected Default version. 08-22-2025 01:48 AM
- Kudoed Re: lock request conflicts with an established lock [STATE_ID = 417401 for MarceloMarques. 08-12-2025 12:22 PM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
3 weeks ago
|