Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About Brian_McLeer
Brian_McLeer
MVP Regular Contributor
since
02-16-2017
Online
426
Posts created
205
Kudos given
12
Solutions
351
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(31 Idea Submissions)Latest Contributions by Brian_McLeer
|
IDEA
|
@MichaelVolz , I had the same issue with working in an enterprise database. It did at least break the links in batch so I could redirect to a different workspace all at once. @KoryKramer , thank you for the follow-up, I will be sure to kudos to the idea.
... View more
09-07-2021
10:48 AM
|
0
|
0
|
3517
|
|
IDEA
|
When viewing data in the table of contents under the 'List by Data Source' option, having the ability to batch change data sources would be efficient. For example, changing the data source from a database role that has editing privileges to a reader connection. Another example would be changing data from a parent database to a child database. Being able to right-click and say "change data source" would be helpful for a group of data rather than going into each layer's properties and changing the data source that way.
... View more
09-02-2021
02:59 PM
|
1
|
2
|
3603
|
|
POST
|
Glad it worked out, I have not used XRay but good to know if I do in the future.
... View more
08-09-2021
06:25 AM
|
0
|
0
|
5682
|
|
POST
|
Hi @JoeBryant1 , might it have to do with the version of the source FGDB coming from AGOL? Could you do a second transfer to have the FGDB be on 10.7 level? Maybe it thinks the AGOL FGDB is a newer version.
... View more
08-05-2021
02:20 PM
|
0
|
2
|
5752
|
|
POST
|
We are starting to migrate our enterprise database from traditional to branch versioning. The recommended SDE admin workflow (link below) for traditional versioning is to delete \ create versions after editing is complete on a version. At our organization, we reconcile\post, delete versions, compress, rebuild indexes, analyze, create versions via nightly Python routines. With migrating to branch versioning, compress is no longer needed, and you cannot rebuild indexes (indices?) on branch versioned data. My question for the community is it still necessary to delete\create branch versions on a daily schedule after an editor has completed edits for the day? Or is this becoming obsolete, such as compressing the database is as ESRI recommends migrating to branch versioning. https://desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/recommended-version-administration-workflow.htm
... View more
08-02-2021
08:58 AM
|
2
|
3
|
4993
|
|
IDEA
|
When publishing branch versioned data for the first time changing from traditional versioning, allow for required fields to be turned on by the right-click option in the 'Share As Web Layer' pane. I received 465 errors which I have to go into each layer and turn on all fields that are required to be turned on to publish branch versioned data to Portal. Being able to select the errors, right-click and choose 'turn on field' would be a great improvement.
... View more
07-29-2021
10:00 AM
|
3
|
0
|
731
|
|
POST
|
Had to make some updates, but the below solution worked. fc = "D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded"
fields = ['USER_MunisAccount','IN_Single_Line_Input']
qry = "Status NOT IN ( 'M', 'T')"
with arcpy.da.SearchCursor(fc, fields, qry) as cursor:
for row in cursor:
print(row [0], row [1])
txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n'))
HOST = "server.domain.com"
SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts"
TO = "symon@email.com", "dave@email.com", "brian@email.com"
FROM = "Water Accounts<GIS@email.com>"
text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row[0]) + " | UB Address: "+str(row[1])+"\n"
BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text)
server = smtplib.SMTP(HOST)
server.sendmail(FROM, TO, BODY)
server.quit()
... View more
07-29-2021
08:19 AM
|
0
|
0
|
1827
|
|
POST
|
So I got the code to work and email to a single address like the commented out line 11, but in trying to send to multiple email addresses like in line 10 it fails with the error message below. unhashable type: 'list' fc = "D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded"
fields = ['USER_MunisAccount','IN_Single_Line_Input']
qry = "Status NOT IN ( 'M', 'T')"
with arcpy.da.SearchCursor(fc, fields, qry) as cursor:
for row in cursor:
print(row [0], row [1])
txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n'))
HOST = "server.email.com"
SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts"
TO = ["symon@email.com","dave@email.com","brian@email.com"]
#TO = "brian@email.com"
FROM = "Water Accounts<GIS@email.com>"
text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row[0]) + " | UB Address: "+str(row[1])+"\n"
BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text)
server = smtplib.SMTP(HOST)
server.sendmail(FROM, [TO], BODY)
server.quit()
... View more
07-28-2021
03:11 PM
|
0
|
0
|
1848
|
|
POST
|
Thank you Dan, I updated the code below for lines 2, 3, and 4 based on the ESRI documentation, and still getting the error the field 'MunisAccount' does not exist. My guess is something in row 5 or row 13 is the issue? arcpy.SelectLayerByAttribute_management("NewAccountsGeocoded_Layer", "NEW_SELECTION", "Status NOT IN ( 'M', 'T')")
fc = "D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded"
fields = ['MunisAccount']
for row in arcpy.SearchCursor(fc, fields):
print((row.MunisAccount, row.ARC_Single_Line_Input))
arcpy.AddMessage("Water_ID_Updates Failed...{0}".format('\n'))
txtFile.write("Water_ID_Updates Failed...{0}".format('\n'))
txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n'))
HOST = "server.host.com"
SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts"
TO = "brian@email.com"
FROM = "Water Accounts<email@email.com>"
text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row.MunisAccount) + " | UB Address: "+str(row.ARC_Single_Line_Input)+"\n"
BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text)
server = smtplib.SMTP(HOST)
server.sendmail(FROM, [TO], BODY)
server.quit()
... View more
07-28-2021
07:47 AM
|
0
|
0
|
1858
|
|
POST
|
In migrating from Python 2.x to 3.x, we had a process that emails water accounts that are unable to be geocoded and added to our meter feature class. There was no change to the schema, but recently we had the below failure. The field still exists named 'MunisAccount' in the NewAccountsGeocoded feature class. Error received: Row: Field MunisAccount does not exist arcpy.MakeFeatureLayer_management("D:\\WorkSpace\\Water\\Workspace.gdb\\NewAccountsGeocoded", "NewAccountsGeocoded_Layer", "", "", "")
arcpy.SelectLayerByAttribute_management("NewAccountsGeocoded_Layer", "NEW_SELECTION", "Status NOT IN ( 'M', 'T')")
for row in arcpy.SearchCursor("NewAccountsGeocoded_Layer"):
print (row.MunisAccount, row.ARC_Single_Line_Input)
arcpy.AddMessage("Water_ID_Updates Failed...{0}".format('\n'))
txtFile.write("Water_ID_Updates Failed...{0}".format('\n'))
txtFile.write("{0}{1}".format(arcpy.GetMessages(), '\n'))
HOST = "server.host.com"
SUBJECT = "Report: Unable to Add UB Accounts to GIS Accounts"
TO = "brian@email.com"
FROM = "Water Accounts<email@email.com>"
text = "The following UB Account was not able to be imported into GIS WtrAccounts. Please see if there is an error in UB or if the address exists in COH Address GIS feature class. \n " + "UB Account: "+str(row.MunisAccount) + " | UB Address: "+str(row.ARC_Single_Line_Input)+"\n"
BODY = "From: {1}{0}To: {2}{0}Subject: {3}{0}{0}{4}".format('\r\n', FROM, TO, SUBJECT, text)
server = smtplib.SMTP(HOST)
server.sendmail(FROM, [TO], BODY)
server.quit()
... View more
07-27-2021
11:14 AM
|
0
|
6
|
1909
|
|
IDEA
|
In ArcGIS Desktop under Data Reviewer Tools, there was a tool that performed a GDB schema comparison. This appears to have been deprecated with no viable replacement in ArcGIS Pro. Being able to compare GDB schemas between a parent/child or production/development database is very beneficial. Are there any plans to bring this back into Pro? The Pro version I am on is 2.6.2.
... View more
06-24-2021
10:15 AM
|
22
|
8
|
5339
|
|
IDEA
|
In ArcMap, on the table of contents window, you can list data by source. From there, you can remove data from the TOC at the source level and remove all of the data from that data source. This functionality is not available in Pro (at least at version 2.6.2). Being able to remove data from a TOC in batch via the same source without having to highlight all the layers would be a good addition to bring over from ArcMap.
... View more
05-20-2021
01:39 PM
|
0
|
1
|
1257
|
|
IDEA
|
In creating database sequences, there is not a streamlined way to view database sequences that have been created. I have seen other posts of using Python to list database sequences, but that seems to only be applicable to file geodatabase and not enterprise databases. List Database Sequences for Enterprise Geodatabase Being able to view database sequences in a database would be beneficial, especially as these can interact with attribute rules to auto-generate values. Viewing along the same lines as you can for attribute rules, domains, subtypes, etc.
... View more
04-28-2021
09:38 AM
|
43
|
19
|
10291
|
|
POST
|
Thank you @KenBuja I tried again and I got the below to work based on your feedback. I also created a new label class just for where the description is business so I was not trying to do so much in one label class. Thank you very much for your help! var d = $feature.Description
var s = $feature.SitusNum
var u = $feature.UnitNum
var b = $feature.BuildingNum
return When(d == 'BUSINESS',
IIf(!IsEmpty(b) && !IsEmpty(u), b + ' - ' + u,
IIf(!IsEmpty(b), b,
IIf(!IsEmpty(u), u, s)
)
),
null) .
... View more
04-28-2021
08:05 AM
|
2
|
1
|
25527
|
|
POST
|
Thank you @KenBuja , So I get the below error when trying to update on my end. It is a direct copy and paste, all I did was keep the '$feature.' in front of each variable.
... View more
04-27-2021
01:50 PM
|
0
|
3
|
25556
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | Tuesday | |
| 1 | a week ago | |
| 6 | 12-10-2025 03:48 PM | |
| 1 | 12-10-2025 12:19 PM | |
| 1 | 11-13-2025 07:02 AM |
Activity Feed
- Posted Re: Uploading CSV to hosted layer table - changes time fields no matter what setting I import with on ArcGIS Enterprise Portal Questions. 13 hours ago
- Posted Re: Can database connections in Favorites be referenced in ArcPy on ArcGIS Pro Questions. 14 hours ago
- Got a Kudo for Property Report Widget. 15 hours ago
- Got a Kudo for Re: Advanced Draw Widget Improvements: Import, Export, Save Drawings, Tool Tips, Snapping, Measurements. 16 hours ago
- Kudoed Your Ideas in ArcGIS Pro 3.6 for ValeriaChavez. Tuesday
- Got a Kudo for Re: Advanced Draw Widget Improvements: Import, Export, Save Drawings, Tool Tips, Snapping, Measurements. Tuesday
- Posted Re: Advanced Draw Widget Improvements: Import, Export, Save Drawings, Tool Tips, Snapping, Measurements on Experience Builder Custom Widgets. Tuesday
- Got a Kudo for Advanced Draw Widget Improvements: Import, Export, Save Drawings, Tool Tips, Snapping, Measurements. Friday
- Got a Kudo for Basemap Gallery Custom Widget. a week ago
- Posted Basemap Gallery Custom Widget on Experience Builder Custom Widgets. a week ago
- Posted Re: Advanced Draw Widget Improvements: Import, Export, Save Drawings, Tool Tips, Snapping, Measurements on Experience Builder Custom Widgets. a week ago
- Got a Kudo for Advanced Draw Widget Improvements: Import, Export, Save Drawings, Tool Tips, Snapping, Measurements. a week ago
- Posted Re: Mailing Labels Custom Widget on Experience Builder Custom Widgets. a week ago
- Got a Kudo for Mailing Labels Custom Widget. a week ago
- Posted Re: Enhanced Measurement Widget on Experience Builder Custom Widgets. 2 weeks ago
- Kudoed Re: Enhanced Measurement Widget for eMosby. 2 weeks ago
- Got a Kudo for Enhanced Measurement Widget. 2 weeks ago
- Posted Re: Create nested group layers in a Web Map on ArcGIS API for Python Questions. 3 weeks ago
- Got a Kudo for Google Analytics applied to widgets. 3 weeks ago
- Got a Kudo for Re: Advanced Draw Widget Improvements: Import, Export, Save Drawings, Tool Tips, Snapping, Measurements. 4 weeks ago
User Groups for Brian_McLeer
Contact Me
| Online Status |
Online
|
| Date Last Visited |
14 hours ago
|