Latest Contributions by Brian_McLeer

‎02-04-2019

I had this issue and went the following route: If the field that is the ID is a number field, create a view for creating the next ID in sequence in SQL Server such as: SELECT MAX(FieldName) + 1 AS NEXT_ID FROM owner.TABLENAME‍‍‍‍‍‍ Then, in Model Builder, I created a model to assign the ID. Get Field Value: Using your view that you created: Field is NEXT_ID, Data Type is Long Make a Feature Layer of the feature class you are trying to update, then Select By Attribute as "FieldName IS NULL", then calculate "FieldName" with the "Value" from the next available ID Calculate Field (Python 9.3): Expression: autoIncrement() Code Block: rec=0 def autoIncrement(): global rec pStart = %Value% pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ From here, you can import the Model Builder model into a Python script as: arcpy.ImportToolbox("C:\Path\To\Your\Toolbox\AutoID.tbx","test") arcpy.ModelName_test()‍‍‍‍‍‍ Make sure you add _test() to the end of your model name and "test" at the end of your toolbox.

‎02-04-2019

Thank you, that one worked after removing the double 'arcpy'.

‎01-31-2019

I updated line 6 and 7 with your code but seems to still report an error: Traceback (most recent call last): File "C:\path\to\python\file.py", line 8, in <module> arcpy.arcpy.CreateDatabaseView_management(fc, os.path.join("Database Connections\\Server DB sde.sde",'v_{}'.format(fc), 'select * from {}'.format(fc))) File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\management.py", line 4069, in CreateDatabaseView raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000837: The workspace is not the correct workspace type. ERROR 000735: View Definition: Value is required Failed to execute (CreateDatabaseView). import arcpy import os arcpy.env.workspace = "Database Connections\\Server DB sde.sde" featureclasses = arcpy.ListFeatureClasses() for fc in featureclasses: arcpy.arcpy.CreateDatabaseView_management(fc, os.path.join("Database Connections\\Server DB sde.sde",'v_{}'.format(fc), 'select * from {}'.format(fc)))‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎01-31-2019

I have created an SDE database in which I have copied feature classes from my production database from State Plane into WGS 84 for web mapping applications. The final step is to create views, and I am trying to automate the process as I have hundreds of feature classes. Below, I am trying to make a list of all the feature classes and use the name of the feature class. The middle parameter starts with a prefix of v_ then grabs the feature class name (ie: v_watermeters). The third variable is the SQL statement used to create the view definition, where it grabs all the fields (SELECT * FROM ) then I want to use the feature class name (ie: SELECT * FROM watermeters). I am having trouble with the third variable and concatenating the string values to make valid code. We are currently on ArcGIS 10.3.1 and SQL Server 2012. import arcpy import os arcpy.env.workspace = "Database Connections\\Server Database sde.sde" featureclasses = arcpy.ListFeatureClasses() for fc in featureclasses: arcpy.arcpy.CreateDatabaseView_management( fc, os.path.join("Database Connections\\Server Database sde.sde","v_"+str(featureclasses), "select * from "+featureclasses)‍‍‍‍‍‍‍‍

‎01-16-2019

I had a similar issue, and I could not assign privileges with a blank feature dataset. Once I added a dummy feature class within the feature dataset, I was able to assign privileges then I removed the dummy feature class and added the real ones.

‎12-27-2018

I have a folder of PDFs that are a 1:1 relationship with an MXD. Each plan is a floor of a building. In the screenshot below, WHBFD325 is only one floor, so no modifications need to be done to that. In the 4 files for WHBFD364, I would like to merge the 4 PDFs into one PDF with _1 being the first page, _4 being the last page. The merged file name would be WHBFD364. After the merge is complete, I would like the 4 files that end with _1, _2, _3, _4 to be deleted. I am not sure where to start, but any advice or links would really help me out. I am looking at the PDFDoc ArpPy commands, but nothing looks promising so far. PDFDocument—Help | ArcGIS for Desktop

‎12-13-2018

Thank you Shana, I had to add a suffix directional field to the alternate name table so all 4 fields are mapped to each other (Prefix Direction, Name, Suffix Type, Suffix Direction). The Suffix Direction FIeld in both the streets table and alternate name table is NULL for the most part, but that still threw it off originally.

‎12-10-2018

I have a table of alternate names with a common LOCALID field for a list of centerlines. An example is the LOCALID in the main centerline feature class is 244074. The current name in the centerline file is: Prefix: SE RoadName: CENTURY RoadType: BLVD The alias table has a record with the same LOCALID of 244074 with: Prefix: SW RoadName: 234TH RoadType: AVE The features join successfully: When I set up the Dual Range Addresses style locator, I follow the tutorial data and make sure match with no zones and match without house number are set to yes. The rest of my setup looks like: However, none of the alternate (alias) names are being recognized. Any suggestions or something I am missing?

‎11-26-2018

Thank you, This seems to happen in other areas as well such as exporting TPKs via ArcPy and using Data Reviewer ArcPy functions.

‎10-25-2018

Thank you, Randy. The 'domain.name' expression was the key.

‎10-25-2018

Thank you, Joe, It is a start, but seem to be missing the value for the SortCodedValueDomain_management command. import arcpy domains = arcpy.da.ListDomains("Database Connections\\Server DB Owner.sde") for domain in domains: print('Domain name: {0}'.format(domain.name)) if domain.domainType == 'CodedValue': coded_values = domain.codedValues for val, desc in coded_values.items(): arcpy.SortCodedValueDomain_management("Database Connections\\Server DB Owner.sde", Which Value?, "CODE", "ASCENDING") print('{0} : {1}'.format(val, desc)) elif domain.domainType == 'Range': print('Min: {0}'.format(domain.range[0])) print('Max: {0}'.format(domain.range[1]))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎10-25-2018

Looking for a way in model builder or python to iterate through all domains in a GDB and Sort Coded Value on ASC order.

‎08-23-2018

Any ideas on how to list unused domain values from within a coded domain? An example is we had PKWY EAST in a domain for street suffixes. I would like to generate a list of domain values that are not being used in a feature class.

‎08-15-2018

Currently, we have our water system mains in a geometric network but they are not split at valves. I would like to batch split the water main complex edges at the valves while maintaining the attributes. I looked at the split line at points tool, but it wants a separate output. I am trying to do this operation from within an edit session to maintain current attributes. After the split, my plan is to assign a unique ID. I am looking at within an edit session or a Python script to accomplish this. Below is an image of our current geometry.

‎08-13-2018

I had the same issue, and I found that having the background geoprocessing 64-bit patch installed is not compatible with Data Reviewer Arcpy functions. My solution was to run Python routines with DR Arcpy functions from a machine that has 32-bit Python installed, not 64 bit. Background Geoprocessing (64-bit)—Help | ArcGIS Desktop

Online Status	Online
Date Last Visited	13 hours ago

My Ideas

Latest Contributions by Brian_McLeer

Re: Generate an auto populating unique ID field in ArcMap

Re: Using STR function in Arcpy Statement

Re: Using STR function in Arcpy Statement

Using STR function in Arcpy Statement

Re: Unable to add privileges to a feature dataset

Merge DDP PDF Outputs into one file

Re: Dual Range Addresses Style Locator not honoring Alternate Name Table

Dual Range Addresses Style Locator not honoring Alternate Name Table

Re: Symbol Rotation not honored during arcpy.mapping.ExportToPDF

Re: Iterate through a GDB to Sort Coded Value Domains

Re: Iterate through a GDB to Sort Coded Value Domains

Iterate through a GDB to Sort Coded Value Domains

List unused domain values in a domain via Python

Split Water Mains at Valves

Re: How to run Data Reviewer outside of ArcMap

Re: Right Click Widget

Re: Advanced Draw Widget Improvements: Import, Exp...

Re: Advanced Draw Widget Improvements: Import, Exp...

Re: Right Click Widget

Re: Right Click Widget

Experience Builder Custom Widgets

Experience Builder Tips and Tricks