Latest Contributions by ModernElectric

‎04-08-2013

Chris: How long does it take to run the python script that is outside an edit session? 9500 records is not alot of records, so this process should not take long (I would think 1-2 minutes at the most). When I built the Python script - I had a total of 18 different fields to update from (2) different tables. So I did the Join for (1) table - did all those fields, removed the join and did the same thing for the other table. This was outside of an edit session. To do this - it took almost 8 hours for the python script to run. When I do it inside an edit session in ArcMap without a model/script it takes about 1 to 2 minutes per field to update. I want to be able to do this automatically at night with a script so I am not taking time to do it the long way.

‎04-08-2013

Greetings- I have tried multiple things and trying to find a better/easier/faster way of doing this: I have a File Geodatabase Feature Class (Service_Locations) that has around 9500 records in it. This is the location and data for our Electric meters. The data behind it (Customer info, meter attributes, ETC) are stored/maintained/updated in our CIS system (Data held in an Oracle Database). Everynight - I have a python script that automatically exports a View from the Oracle Database (Customer data, Meter Data) and brings it directly into the File Geodatabase as a Geodatabase Table. What I have done in the past is to: Add Join (Feature Class Table TO Service_Locations FC) Calculate Field tool to say - Bring this field from the table (Meter Number) into this field of the FC (TWACs Number). I have done this inside and edit session and a data model to Python script (Outside of an edit session) Each way is very time consuming and does not work fast. QUESTION: Are there different tools that I can use to make this process much faster so I can build a Python Script to run automatically at night? The Join and Calculate Field tools are not working for me anymore.. Thank you

‎12-05-2012

Currently - I have almost 6000 attachments linked to my Water GIS system. Most of them are composed of .PDF construction as-builts and .JPEG field phtotos. However - these .PDFs are constantly being updated. The problem I have is when one of the "Native" external files are modified and saved - the editor has to go into ArcMap - remove that attachment and reattach the same file. This makes it really frustrating when there are alot of attachments being updated on a regular basis. it would be nice that when the external native file is modified and saved - nothing has to be done to the attachment in ArcMap.

‎12-05-2012

Thank you for promoting my idea. I found your idea from your comment on mine and returned the favor. Lets hope ESRI will pick up and run with this idea in a future release.

‎12-05-2012

Thank you for promoting my idea. I found your idea from your comment on mine and returned the favor. Lets hope ESRI will pick up and run with this idea in a future release.

‎12-05-2012

I had a similar issue with copying fields from a table to a feature class and wondering if what I came up with will work for you. What I did is to take a table (lets call it TB1) and a feature class (call it FC1) and use the join feature. This will work out if you have a linking field with a 1:1 relationship. That way you make sure everything from the field from TB1 is copied to the field of you choice to FC1. Once I joined TB1 to FC1 - I opened to the attributes table in ArcMap and selected the "Calculate Field" feature which allowed me to copy the field from TB1 and put it into the field of FC1 that I selected. It looks like you should be able to do the same thing with a Table to Table Join and use the Calculate Field feature. HOWEVER - in order to make sure you get everything to go from the field in TB1 to a field in TB2 - there has to be a 1:1 relationship. Hope this helps.

‎10-26-2012

My IT Staff is trying to install ArcReader 10 onto Terminal Server 2008 instead of having it on everybody's computer. This way they can just log into it and see the GIS Data through ArcReader. However - they are telling me they are having issues doing this. The symbols are all messed up, for one. Is this even possible to have ArcReader on a server like this?

‎10-26-2012

Negative Jake - I went through and copied the geodatabase and .MXD and put it onto my hard drive and rebuilt the data model in model builder and it is taking just as long. I am using the "Calculate Field" tool and saying I want this field from the Feature Layer to update/replace from the field in the table. Is there a different tool I can use?

‎10-26-2012

Mathew - I am not familiar with dictionaries when it comes to dealing with Python scripting and ArcGIS. Is there some reference material on the web you can point me to that I can do some "Homework" on? Jake - Currently - I am running the File Geodatabase through a network connection from our internal server. Not ArcGIS Server. I can test your thought by putting the geodatabase onto my hard drive and see if that speeds things up. Than - I need to create a task to update the "Production" Geodatabase on our network since that is the one that is used to produce the maps for our operations staff at night. Any other thoughts? Thanks for the ideas. I am experimenting with different things to see what will work better/quicker.

‎10-25-2012

Unless you are calculating pi to 1000 decimal places for each row that should be a matter of seconds, not hours. I have a script that takes 2 hours that calculates 17 fields for nearly 1 million features. Post your code and I'm sure someone will be able to figure out where the problem is. Okay - great. What "ArcTools" if any are you using to do that? I am using Calculate Field and writing an Expression saying to take this field from the table to put it into this field inside the feature class. For each field to do all 9600 features it takes a good 15 to 20 minutes. Is there something I am not doing right?

‎10-25-2012

How many features are you updating? Even if it's thousands it should take 4 seconds, not 4 hours... By the way, the da.updatecursor will be a lot faster than the older non-da cursor. My Service_Location feature class has around 9600 features (or 9600 meter locations). After going back to reviewing the log I created for the script it showed that each field took around 15 minutes to run through the "Calculate Field" tool in the script. da.updatecursor vs non-da cursor???????? I am far from being an expert on Python. I basically built a model from model builder - exported it out to a python script, found out how to add a create log feature and I had my script. Thanks

‎10-25-2012

Hi Chris, What type of geodatabase are you using (i.e. ArcSDE for Oracle, File Geodatabase)? What version of ArcGIS are you running? I am currently using a File Geodatabase - single use license on ArcMap 10 - ArcEditor. Thanks

‎10-25-2012

Greetings- I am working on a work-flow process that will automatically update the attributes of a specific feature class from a scheduled python script that will run overnight. Here is what I am trying to accomplish: Feature Class: Service Locations (Electric Meter Locations with account, meter and location data stored in our CIS system.) I currently have a python script the pulled the data from our Oracle System and produces it into a Geodatabase table that sits in the same geodatabase as the Service Location feature class. What I need to do is to take the individual fields from the table and update the fields in the feature class. This is what I have done: I made a data model through model builder to 1) Make a Feature Layer 2) Add Join 3) Calculate Field (Update the feature class field with the same field from the data table. Problem is - when I run the data model or the script - it takes a LONG time. The one script I build and tested only have 7 fields (so 7 Calculate Field processes) and it took about 4 hours to run. Is there an easier way to do this? Thanks in advanced

‎09-06-2012

Greetings- I have tried everything possible and what I am doing is not working. I am currently working with ArcMap 10.0 and a file geodatabase. What I am trying to fix/redo is a relationship class between (2) different feature classes. "SERVICE_LOCATION" feature class (Composed of electric meters) "XFMR_BANK" feature class (Composed of all Transformer Banks) Service Locations are connection via a secondary conductor to a Transformer Bank. There might be (1) meter connected to a transformer bank or there might be as many as (18) meters connected to a transformer bank. What I am trying to do is to construct a Relationship Class which will read in both directions. When you select a XFMR bank in the Attributes/Identify box - I want the ability to "Drill-Down" to see ALL of the Service Locations attached to it. SO-If there are (14) meters tied/linked to a specific transformer bank - ALL (14) meters will show up (From the "SERVICE_LOCATION" Feature class when you "Drill-Down" In Reverse - I want to be able to select a Service Location and "Drill-Down" to see what XFMR bank feeds that meter. Is it possible to create a single relationship class to do this in both directions or does it have to be (2) different relationship classes. How exactly do I program this relationship class. My fields: "SERVICE_LOCATION" - XFMR Bank Join (Numeric field type) "XFMR_BANK" - "XFMR Bank Join (Numeric field type) Thank you in advance

‎06-20-2012

I am currently using ArcMap 10.0 with ArcPad 10 and starting to having issues. When I click on "Get Data for ArcPad" from the ArcPad Manager toolbar, the dialog box does not come up and ArcMap crashes right away. The tools in ArcToolbox also will not work. Any ideas?

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by ModernElectric

Re: Updating Feature Class Attributes from Table

Updating Feature Class Attributes from Table

Attachment updates

Re: symbol zoom within specific scale range

Re: symbol zoom within specific scale range

Re: Copy Records between Tables

ArcReader on a Terminal Server

Re: Update Feature Class Attributes Automatically

Re: Update Feature Class Attributes Automatically

Re: Update Feature Class Attributes Automatically

Re: Update Feature Class Attributes Automatically

Re: Update Feature Class Attributes Automatically

Update Feature Class Attributes Automatically

Relationship Class Problems

ArcMap crashed when Check-Out Data

Re: Flow error/fail to run notification

Re: Water Utility Network - Model Blow-Off

Re: Workforce Project Sync Delay & Ongoing Issues

Survey123 Power Automate Notification

Re: Create Assignment in Line