Latest Contributions by MicahBabinski

Without seeing your code it's tough to know how to make it run faster. I know that arcpy does involve a certain amount of abstraction and therefore isn't always the fastest when compared to .NET solutions. I have a more generic python/arcpy QAQC process that rips through large datasets fairly quickly. A couple questions/considerations: 1. Are you using data access module cursors, or the old kind? 2. What is the format of your streets data? 3. Are you processing it over a network or locally? 4. Are you importing a bunch of modules or packages that you aren't using? 5. Slightly facetious one: 30 minutes doesn't seem too bad. Why not just run it over lunch? Micah ... View more

Fun! Your workflow looks pretty legit, but yeah I see what you mean about unnecessary vertices. I would add this one step at the beginning of your process: Simplify Polygon—ArcGIS Pro | ArcGIS Desktop  Use the POINT_REMOVE algorithm. From the docs: Retains critical points that preserve the essential shape of a polygon outline and removes all other points. This is the default. Let us know how that goes. Micah ... View more

I can't access it either. Are you sure their geoserver is still up and running? ... View more

Hmmm, in that case you may want to check to see if your ArcGIS Server site is configured to use "standardized queries." I guess it's a security setting at the ArcGIS Server site level that is supposed to prevent SQL injection attacks. The default setting I think is to only allow standardized queries.  About standardized queries—ArcGIS Server Administration (Windows) | ArcGIS Enterprise  From my read of the documentation, your use of a subquery may be causing issues when creating the replica. However, I am not sure why you would have been allowed to publish the service in the first place. I hope you figure it out! Micah ... View more

Hi Kevin, What field types are used as the primary and foreign keys of the relationship class(es)? I believe that might impact the ability to create replicas for offline Collector use. Micah ... View more

Hi Kevin, I would try examining the geodatabase locks by right-clicking the SDE connection and going to Administration > Administer Geodatabase and then looking at the locks tab. This could give you some info about what users/processes are locking your output feature class. Also, does running your script without declaring all those local variables make a difference? I have heard that creating a variable pointing to a feature class can lock it up because the variable represents a pointer from python exe. Just a thought. You might also be able to make use of the TestSchemaLock—ArcPy Functions | ArcGIS Desktop function to test whether you can get an exclusive schema lock on your target dataset. Good luck, Micah ... View more

Hello Jordan, What SDE-level permissions have been applied to the datasets you want your Operators to be able to edit? If you are connected to that SDE geodatabase using operating system authentication you will need to grant SDE editing permissions to your ArcGIS Server account. Just to help diagnose - is your data versioned? Finally, it looks like you've got a lot of layers in your ArcMap table of contents. It won't necessarily cause an issue - but do all of those layers need to be editable by your Operators? If not I would remove them - it will reduce the complexity and may help isolate the issue. Micah ... View more

Hi Alexis, Try this line of code right after you import arcpy: arcpy.env.overwriteOutput = True‍ That should tell your geoprocessing environment to overwrite outputs if they exist already. Micah ... View more

Hi Almaz, What error message did you get when you executed the tool? That will help diagnose the problem. Micah ... View more

Hi Kieren, It sounds like you already covered all this stuff but from the documentation here's a couple things to check: Are both the ArcGIS Server Site and Portal site configured to use HTTPS communication? In the Portal Server's settings, is the Administration URL set as your Web Adaptor or load balancer URL? Is the Web Adaptor configured to enable administrative access to the server? Micah ... View more

Heya Justin, Check out the code example for the Data Access Walk function: Walk—Help | ArcGIS for Desktop  It will let you quickly list all your feature classes without needing separate code to peek in each feature dataset. Once you've got a nice list of all feature classes, you can identify which ones are populated with at least one feature using Get Count—Data Management toolbox | ArcGIS Desktop. Note with Get Count that you need to access the result as an integer in your script. So use something like: for fc in fcs:     if int(arcpy.GetCount_management(fc).getOutput(0)) > 0:         print(fc)‍‍‍ Happy listing! Micah ... View more

Hmmm, is it possible that one of the shapefiles has its coordinate system defined incorrectly? Sometimes it helps me to consider the source of the data - was it GPS? Digitized based on aerial photo or other reference data? If I think that my data source has the wrong coordinate system definition, here is what I do: Open a blank MXD Make a copy of the dataset that is not lining up correctly in ArcCatalog On the copy, set the coordinate system to Undefined in ArcCatalog Set the data frame of the blank MXD to the geographic coordinate system you think the mystery data source might have Add a dataset that you know has the right spatial reference Add the mystery dataset Repeat these steps (besides step 2) until it lines up correctly. The geographic coordinate system which you set your data frame to is the right one. This has worked for me in the past, but if you post your shapefiles here maybe some folks who are better at it than me could take a look. Good luck! Micah ... View more

Hi Jeff, How many attribute tables, and how many values do you need to update on a monthly basis? There's a find and replace tool which you can use if it's only a few values in a limited number of tables: How To: Replace the text in multiple fields within an attribute table using the Find and Replace tool  If you want something more automated, here's what I'd do: Create a table with two columns: old_value and new_value, which contain the old value and the one you want to update it with Create an empty Python dictionary, and use an arcpy DA search cursor (SearchCursor—Help | ArcGIS for Desktop) to populate it with the keys being the old text and the corresponding values being the new text. For each file geodatabase attribute table you want to update, use an arcpy DA update cursor (UpdateCursor—Help | ArcGIS for Desktop) to comb through each table and update the values based on the lookup dictionary. That sounds like it will increase your productivity and so would be a good first forray into arcpy. Good luck! Micah ... View more

Hi Gaston, Check out the system requirements here: ArcGIS Pro 2.0 system requirements—ArcGIS Pro | ArcGIS Desktop  There's a nice utility linked to that help page that will scan your PC and tell you if your machine is capable of running ArcGIS Pro, and will report what upgrades you need to get in shape. That might help you pick out a new machine. Here it is: Can You Run It?  From my limited expertise the things to focus on for Pro are: 64-bit Operating System (required) RAM (Go for 8 or 16 gigs) Nice CPU/Processor Good graphics hardware, although doesn't have to be as nice as a full-blown gaming computer I need to get up to speed on ArcGIS Pro here pretty soon so if you end up buying a machine that works really nicely let me know what you got. Micah ... View more