|
POST
|
Joshua: Yes, in a nut shell that would be correct. I have a series of Model(s) in ArcToolBox that runs my process for me (Billing Data) and it takes several hours to run the process. I am working on transitioning the model(s) to python scripts to make the process run faster and maybe run it automatically through a series of batch file(s).
... View more
06-19-2019
08:13 AM
|
0
|
0
|
1391
|
|
POST
|
I think I am being a little vague on what I am trying to do. I have a table of reading data (approx 15,000 records) of approx 30 months. I have one field that is the billing date (ex. May-2019). The other field is the billing month (ex. 30). Basically, I started with Dec-2016 which has a value of 1, Jan-2017 which is assigned a value of 2 and so on and so forth to May-2019. A previous step uses the Convert Date tool to get the May-2019. This step is to update the Billing Month field based on the value in the Billing Date field. Hope this helps and makes more sense.
... View more
06-19-2019
07:55 AM
|
0
|
2
|
1391
|
|
POST
|
Joe: Thank you for taking a look and providing me with additional information to look at. I build the script example you sent me. However, I am getting this error: updateRow[1] = monthDict[keyValue][0] TypeError: 'int' object has no attribute '__getitem__' Any advice?
... View more
06-19-2019
07:24 AM
|
0
|
9
|
5308
|
|
POST
|
Good Afternoon: I have been doing multiple searches on how to correctly write an if/else statement using Update Cursor to update a specific field based on the criteria in a different field, and lets say I got nothing. Looking for a little help on how to write this: I have a field called BILLING_MONTH_TEXT (text) and another field called BILLING_DATE (text). What I need to do is say (As an Example) if BILLING_MONTH_TEXT is May-2019 then it would update BILLING_DATE with a value of 30. If it is April-2019, the value would be 29. And so on and so on. If I could get started, I can figure out how to fill in the remaining months and values. Thank You for your help.
... View more
06-18-2019
03:27 PM
|
0
|
15
|
7786
|
|
POST
|
This is a great script that initial testing has been successful. However, I am having another problem. A little background first... I have a WORKING GDB on my local drive that is used to run analysis and edits. We have a separate PRODUCTION GDB that is on our network that is used to "run" the .PMF on ArcReader. I successfully built an ArcGIS Model to Truncate and Append data from the WORKING GDB to the PRODUCTION GDB without requiring ArcReader users from exiting out. It has been my goal to build a group of Python scripts to do this automatically with the help Windows Task Scheduler. Here is the problem. I have a few Feature Class(s) that has attachment(s) and the only way I have found the ArcGIS Model to work successfully is by opening the .MXD for the PRODUCTION GDB and run the ArcGIS Model. All of the attachments append/copy over without a problem. Now, doing this with the Field Mapping Python script isn't working properly. Any advice to duplicate the process I have been doing, but with the Field Mapping script with attachments? Thanks Again, GREAT script!!
... View more
08-01-2018
12:27 PM
|
0
|
0
|
16394
|
|
POST
|
Sorry to be seriously ignorant here, but I am doing some experimentation with ArcGIS pro and learned about the Utility Network package tool and the Water Distribution Utility Network and Electric Utility Network. Both I am curious about working with and experimenting with to integrate with my current workflow. At the present time, I am running a File GDB on ArcMap and publishing Feature Layers to our ArcGIS Online account. I have been experimenting with the ArcGIS Solutions and trying somethings out. One of the first things the instructions says to do is to create an Enterprise Geodatabase. I have all of the parameters I need for the Oracle database, except for the Authorization file. The only thing we have is ArcGIS Desktop Standard and Publisher. All of the literature I have been looking at keeps stating ArcGIS for Server, but of course I do not have that. So, the ignorant part.... In order to work with ArcGIS Pro and the Utility network feature, do we need ArcGIS for Server and SDE? Not very familiar with SDE functionality so I am learning on the fly. Looking for a little guidance is all. Thank You
... View more
06-27-2018
11:19 AM
|
0
|
1
|
1061
|
|
POST
|
Good Morning: A little background on what I am working on and what I am trying to accomplish. First thing, I have a Working File GDB that I maintain all of our company's assists (Electric and Water Data). All of the edits and modifications are done from this GDB. I am the only editor in the company, so I am the only one that works on this GDB. Now, I have a second File GDB that is on our internal server (another File GDB) that is used to provide the GIS Data to the ArcReader .PMF file for our Operational staff. Basically goes from Working GDB to Production GDB to .PMF in ArcReader. The biggest struggle that I have been having is when I need to update the Production GDB, I have to have everyone exit ArcReader and close any .PMFs due to a schema lock. There could be around 10 different people using the same .PMF at the same time, which makes updates difficult. I recently found out that I can use the TRUNCATE Tool and APPEND tool to "copy" data from the Working GDB to the Production GDB with it still being open. Sounds great. However, 1 step forward, 2 steps back... The problem I am now having is dealing with the Feature Class(s) that have attachment(s). I am testing a new process with Model Builder that I Truncate a Feature Class in the Production GDB and then Append from the Working to the Production GDB. The problem is with the feature class(s) with attachments and in one particular feature class, only about half of the attachments in the ATTACH Table are being transferred. I attempted to truncate the ATTACH table and then append from the Working to Production. That was wrong. I am starting to understand that the ObjectID for the same location between the Working and Production GDB are different/changing. I know some people are saying, well yeah duh.... To sum up this novel, I am trying to find a way better way to accomplish this task...Copying the Working GDB features and ALL attachments to the Production GDB without allowing the ObjectID to change. I have been doing some investigating in using a Global ID field, but unsure exactly how that would work out with the attachments feature. Any advice and recommendations would be greatly appreciated. Thank You
... View more
03-28-2018
09:02 AM
|
0
|
0
|
1146
|
|
POST
|
Good Morning... Please bare with me here since I am fairly new to using ArcGIS Pro, but have years of experience with ArcGIS Desktop. We recently implemented our ArcGIS Online account for use for our field crew(s). I usually update the feature layer(s) for ArcGIS Online from ArcMap. I have recently started experimenting with ArcGIS Pro, since I understand it is much easier to coordinate the maps/data between ArcGIS and ArcGIS Online. I have successfully created a web map with all of the GIS Layers, tables and attachments. However, for the life of me, I cannot figure out how to update the web map. The only way I can do it is by going to ArcGIS Online, delete the existing Web map and then re-publish it again from ArcGIS Pro. However, this is not a time saver. What I want to be able to do is if I do any data updates in ArcGIS Pro, then I can sync and/or update the current Web Map in ArcGIS Online without having to delete and create over and over. Is there a way I can accomplish this???? Thank You
... View more
02-13-2018
09:22 AM
|
10
|
10
|
47467
|
|
POST
|
Greetings: I am currently working on building a model using ArcGIS ModelBuilder that will use the Make Query Layer tool with the Append tool. My intention is to have the results from a SQL Query export/append into a new GDB Table. Currently, I am doing this manually, but want to have a one-click model that will do it for me and eventually export the model out to a Python script that can be used outside of ArcGIS. I have have multiple Query Layers built outside of ModelBuilder, but want to combine all of the individual task(s) into one model. The problem is, when I run the model, it stops at the append tool saying the input is invalid and doesn't exist. I am sure someone has tried this and ran into this problem before and wondering if someone could give me some hints or ideas on how to make this work. Thank You
... View more
10-12-2017
11:23 AM
|
0
|
1
|
1073
|
|
POST
|
I am working on importing a bunch of data from our Oracle Database into a File Geodatabase. The way it is set-up in the Oracle database is not how I need it in GIS. I understand I can take the data and manipulate it like you can in Microsoft Excel - by creating a Pivot table and that is exactly what I am trying to do with building a SQL query in ArcMap. Right now, I have this SQL Query: select * from ( select ACCOUNTNO, VALUE, PHONE_TYPE from ATSCBS.PHONE_NUMBERS ) src pivot ( MAX(VALUE) for PHONE_TYPE in ('Home' as HOME_PHONE, 'Cellular' as MOBILE_PHONE, 'Business' as BUSINESS_PHONE, 'Pager' as PAGER, 'E-Mail' as EMAIL, 'Fax' as FAX_NUMBER) ) piv order by ACCOUNTNO It validates just fine however, when I open the table I get this error. Any advice would be great. Thank You
... View more
10-09-2017
03:11 PM
|
0
|
1
|
1159
|
|
POST
|
I appreciate the feedback. Like i previously said, we are in the very beginning research and development stages of implementing ArcGIS Online for our company. We are trying different things with ESRI's android app and ArcGIS Collector in addition to regular web viewing. I will take this feedback to assist us with the current development project.
... View more
09-07-2017
11:36 AM
|
0
|
1
|
13011
|
|
POST
|
I have some basic questions about ArcGIS Online. We are just starting to use it as an organization and doing some research and experimentation. At this point, we have (1) Level 2 User Name login and (1) Level 1 User Name login. Is there a limit on how many individuals can use the same login/password at the same time? Example: Mike is using the login on a desktop while John & Phil are using the same log in on (2) separate android phones all at the same time. Is there a limit on how many times the login can be used all at the same time? We are also experimenting with Collector for ArcGIS. If Phil is on one phone and John is on a tablet, and they both are using a project to record sites for tree trimming, can they both be using the same project/map and record data and/or edit existing features without causing problems? I understand these are elementary questions, but we are just starting with ArcGIS Online and these have been questions that have come up. Thank you for the clarification.
... View more
09-01-2017
08:14 AM
|
1
|
12
|
19847
|
|
POST
|
What I am trying to figure out is by doing this in Model Builder: I want to be able to write an expression with the Calculate Field tool in a model to say if the attribute in the PARCEL_TYPE field is Condo, then copy the related attribute in the PID_1 Field into the PID_NEW field. In the past, I would do this manually. Now, I am building a model to do this automatically. Thank You
... View more
11-02-2016
12:27 PM
|
0
|
1
|
1118
|
|
POST
|
I have a polygon feature class within a file geodatabase that contains parcel information for our utility district. I am working on building some models to update the parcel data from raw data. One of the areas that I am stuck on is with using the Calculate Field tool. One of the fields has (2) attributes (Proxy and Condo). What I am trying to do is to select all rows that have an attribute of "Condo" and copy the PID (Parcel Number) into a new field. Also, to enter the attribute "Condo" into a new field as well. Not sure how to select the PIDs that have the 'Condo' attribute and copy only those records into a new field. Thank You for the help
... View more
11-02-2016
07:32 AM
|
0
|
3
|
1852
|
|
POST
|
The I get: "RuntimeError: Unspecific error" Says something about line 20 Does the code and everything look okay? I added your suggestion and nothing.
... View more
09-19-2016
03:14 PM
|
1
|
1
|
685
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-23-2026 10:58 AM | |
| 1 | 11-20-2025 02:52 PM | |
| 1 | 10-30-2025 12:42 PM | |
| 1 | 10-16-2025 10:51 AM | |
| 1 | 08-27-2025 08:47 AM |
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|