Latest Contributions by Brian_McLeer

‎05-17-2019

We updated one of our SDE editor's computers from 10.3.1 to 10.6.1 (ArcGIS Server SDE at 10.3.1). I am able to edit on their 10.6.1 computer, but when they go to edit the same data they get the red warning 'No Editable Layers' with a warning for each layer 'Check to see that you have the appropriate permissions'. We have tested numerous machines both on Windows 8 and 10. We had that user edit the same data on ArcMap 10.3.1 and they were able to edit.

‎05-02-2019

My goal is to list all indexes that are being used on each feature class in an SDE database with ~50 feature classes that reside, with the end product being a list of the feature class and what the name of the index is. import arcpy arcpy.env.workspace = r"Database Connections\Server Database Login.sde" # Get list of indexes and print properties FCs = arcpy.ListFeatureClasses() for FC in FCs: indexes = arcpy.ListIndexes(FC) for index in indexes: print FC print("Name : {0}".format(index.name)) print("IsAscending : {0}".format(index.isAscending)) print("IsUnique : {0}".format(index.isUnique))‍‍‍‍‍‍‍‍‍‍‍‍‍

‎05-02-2019

A follow up to my above comment, while 5TH and MAIN does not work, NE 5TH AND MAIN does work just by adding NE at the beginning.

‎05-02-2019

Hi Shana and Devon, Has there been any update on this issue? I am having the same issue as we are upgrading from 10.3.1 to 10.6.1. On both levels, E MAIN ST and NE 5TH AVE works, however on 10.3.1 MAIN and 5TH works but does not work on 10.6.1.

‎03-14-2019

I usually do that but it requires a spatial join, then a table join, then a calculate field. In the case of my schema here, I don't have a unique ID field to join back to on a table join.

‎03-13-2019

Thanks, Mitch, That worked. I was able to make a separate python file for each point feature class and just schedule it sequentially in task scheduler, takes about 10 minutes to run instead of 2 hours. I also took your advice about doing the geoprocessing on my local drive. I ended up deleting the features where the PlanRefID was NULL after exporting locally then append them back into SDE at the end of the script. Thanks for your help.

‎03-13-2019

I am working on a python script that updates a field titled 'PlanRefID' field in several point feature classes. These are populated based on a 'PlanRefID' field in a polygon feature class. The cursor will loop through and populate the 'PlanRefID' field in the point feature classes (approximately 10) correctly. The issue I am having is that I only want it to update where the PlanRefID IS NULL in my point feature classes. However, it will loop through all records in the polygon feature class, which is taking about 1.5 - 2 hours to run. As the feature classes add more records, the processing time will only increase. I only interested in updating the point features where the PlanRefID IS NULL and referencing the polygons they intersect. arcpy.MakeFeatureLayer_management("Database Connections\\Server Database OWNER.sde\\Database.OWNER.FeatureDataset\\Database.OWNER.Polygon", "Database_OWNER_Polygon") arcpy.MakeFeatureLayer_management("Database Connections\\Server Database OWNER.sde\\Database.OWNER.FeatureDataset\\Database.OWNER.Point", "Database_Owner_Point", "PlanRefID IS NULL") arcpy.SelectLayerByAttribute_management("Database_Owner_Point", "NEW_SELECTION", "PlanRefID IS NULL") rows = arcpy.SearchCursor("Database_OWNER_Polygon") for row in rows: arcpy.SelectLayerByAttribute_management("Database_OWNER_Polygon", "NEW_SELECTION", "\"OBJECTID\" = " + str(row.getValue("OBJECTID"))) arcpy.SelectLayerByLocation_management("Database_Owner_Point", "INTERSECT", "Database_OWNER_Polygon", "", "NEW_SELECTION") arcpy.CalculateField_management("Database_Owner_Point", "PlanRefID", "'{0}'".format(str(row.getValue("PlanRefID"))), "PYTHON_9.3", "") print "Finished processing " + str(row.getValue("PlanRefID"))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎02-14-2019

We are in the process of importing our water mains into an asset management system. The system rejects any line segments with an arc/curve (example below). I think these were imported ~15 - 20 years ago from CAD. Trying to research a way to query out these features that will need to be updated to not contain arc segments. I looked through some Data Reviewer options but did not yield any results yet. We are on Desktop 10.3.1.

‎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.

Online Status	Online
Date Last Visited	5 hours ago

My Ideas

Latest Contributions by Brian_McLeer

Unable to edit SDE after upgrade to 10.6.1

List all Indexes within a geodatabase

Re: Address locator (10.6 release) fails to locate intersections of numbered streets

Re: Address locator (10.6 release) fails to locate intersections of numbered streets

Re: Using a cursor to update field in point feature class from polygon

Re: Using a cursor to update field in point feature class from polygon

Using a cursor to update field in point feature class from polygon

Selecting line features that contain arcs (curves)

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

Zone Lookup

CSV Geocoder Widget

Re: ArcGIS Security and Privacy Advisor does nothi...

Search Custom

Map Layers Custom

Experience Builder Custom Widgets

Experience Builder Tips and Tricks