Latest Contributions by Brian_McLeer

‎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

‎08-10-2018

Update, the issue seems to be on machines having the Background 64-bit GeoProcessing patch installed.

‎08-09-2018

I am trying to implement a Python routine to update a Map Tile Package that will be used for offline map downloads with Lattitude Geographics GeoCortex product. The code snippet below was an output from Model Builder. The model ran successfully and updated the TPK. When running in Python, the generic error code appears (which isn't helpful): ERROR 999999: Error executing function. Failed to execute (CreateMapTilePackage). Looking for insight to see if anyone else has had this problem. Some troubleshooting I have done without different results: - Run the model from within Python calling the model from a toolbox - Change file paths for invalid characters - Tried another machine I am on ArcGIS Desktop 10.3.1 on a Windows 8.1 system and Python version is 2.7.8. import arcpy, os arcpy.env.overwriteOutput = True # Process: Create Map Tile Package arcpy.CreateMapTilePackage_management("C:\\Path\\To\\MXDtoBeUsed.mxd", "ONLINE", "C:\\Path\\To\\TPKtobeUsed.tpk", "PNG", "4", "", "TPKforGMAF", "Basemap")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎07-03-2018

I have several features that I have queried out in my RBJ files that are returned from an invalid geometry data reviewer check. These features do have invalid geometry, but it is intentional and I want them filtered out of the reviewer results table. When I run the RBJ files inside of a review session in ArcMap 10.3.1, 0 results are returned which is expected. This is after I turn off the Invalid Geometry Check in the Default Checks tab in the Reviewer Session Manager. I cannot find any documentation on how to turn this off when creating a python file from it, as the same RBJ file is referenced in my script but it still returns invalid geometry that I do not want to be returned. # Comments arcpy.AddMessage("Checkout DR Extension..." +'\n') txtFile.write("Checkout DR Extension..." +'\n') # Process: Checkout DR Extension arcpy.CheckOutExtension("datareviewer") # Comments arcpy.AddMessage("Checkout DR Extension Complete..." +'\n') txtFile.write("Checkout DR Extension Complete..." +'\n') txtFile.write("..." + '\n') # Comments arcpy.AddMessage("Enable Data Reviewer in GDB..." +'\n') txtFile.write("Enable Data Reviewer in GDB..." +'\n') # Process: Enable Data Reviewer arcpy.EnableDataReviewer_Reviewer("Z:\\GIS_Maintenance\\DataReviewer\\Data\\Server\\DataReviewerParks.gdb", "PROJCS['NAD_1983_HARN_StatePlane_Oregon_North_FIPS_3601',GEOGCS['GCS_North_American_1983_HARN',DATUM['D_North_American_1983_HARN',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',8202099.737532808],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-120.5],PARAMETER['Standard_Parallel_1',44.33333333333334],PARAMETER['Standard_Parallel_2',46.0],PARAMETER['Latitude_Of_Origin',43.66666666666666],UNIT['Foot',0.3048]];-111333600 -98152500 3048;-100000 10000;-100000 10000;3.28083989501312E-03;0.001;0.001;IsHighPrecision", "", "") # Comments arcpy.AddMessage("Enable Data Reviewer in GDB complete..." +'\n') txtFile.write("Enable Data Reviewer in GDB complete..." +'\n') txtFile.write("..." + '\n') # Comments arcpy.AddMessage("Creating Reviewer Session..." +'\n') txtFile.write("Creating Reviewer Session..." +'\n') # Process: Create Reviewer Session arcpy.CreateReviewerSession_Reviewer("Z:\\GIS_Maintenance\\DataReviewer\\Data\\Server\\DataReviewerParks.gdb", "ParksReviewChecks", "") # Comments arcpy.AddMessage("Creating Reviewer Session Complete..." +'\n') txtFile.write("Creating Reviewer Session Complete..." +'\n') txtFile.write("..." + '\n') # Comments arcpy.AddMessage("Executing Parks Reviewer Batch Job Files..." +'\n') txtFile.write("Executing Parks Reviewer Batch Job Files..." +'\n') # Process: Execute Reviewer Batch Job arcpy.AddMessage("Executing Parks Review Checks.rbj..." +'\n') txtFile.write("Executing Parks Review Checks.rbj..." +'\n') arcpy.ExecuteReviewerBatchJob_Reviewer("Z:\\GIS_Maintenance\\DataReviewer\\Data\\Server\\DataReviewerParks.gdb", "Session 1 : ParksReviewChecks", "Z:\\GIS_Maintenance\\DataReviewer\\RBJ\\Parks Review Checks\\Parks Review Checks.rbj", "Database Connections\\Server Production gis_reader.sde", "", "ALL_FEATURES", "") # Comments arcpy.AddMessage("Executing Parks Reviewer Batch Job Files Complete..." +'\n') txtFile.write("Executing Parks Reviewer Batch Job Files Complete..." +'\n') txtFile.write("..." + '\n')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎06-29-2018

I have about 30 feature classes in an FGDB. I am looking for a script to remove all attribute indexes, as I will need to do this for multiple FGDBs eventually. My file path is: "M:\\GIS_Data\\FileGeoDBs\Parks.gdb" I started with this article Remove all attribute indexes using arcpy But got stuck at line 02 dsc = arcpy.Describe("sap")

‎06-11-2018

I have referenced this article Writing conditional (if/then) statements into Field Calculator of ArcGIS for Desktop using Python parser? - Geographic I… I am trying to update values in a field using 'elif' statements in Field Calculator with the Python radio button selected. The set is as: Code Block: def Reclass(Density_18): if (Density_18 <= .8493): return 1 elif (Density_18 >.8493 and Density_18 <=1.761): return 2 elif (Density_18 >1.761 and Density_18 <=2.345): return 3 elif (Density_18 >2.345 and Density_18 <=3.399): return 4 elif (Density_18 >3.399): return 5‍‍‍‍‍‍‍‍‍‍‍ Expression: Reclass( !Index_18!)‍ When this expression is performed, it calculates all the values as '1', then the next time it is run all values are '2', so on until it maxes out and repeats at '5' in the Index_18 field.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by Brian_McLeer

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: Error using Python to create a TPK basemap package

Error using Python to create a TPK basemap package

Invalid Geometry turned off by default Data Reviewer Python

Delete all attribute indexes in a file geodatabase

Writing if/else statement in field calculator for calculating values

Basemap Gallery Custom Widget

Property Report Widget

Re: Right Click Widget

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

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

Experience Builder Tips and Tricks

Experience Builder Custom Widgets