Latest Contributions by ModernElectric

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

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

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

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

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