Latest Contributions by ModernElectric

Good Afternoon: I have been experimenting with a series of Python Scripts that utilize the ArcPy SearchCursor feature that has user input (Enter Meter Number) and the script prints the XFMR, Protective Device and Feeder. This first start out as an experiment to learn more about writing Python scripts and it began me thinking.  What I would like to do is to take the Python Script and allow others (Non-GIS Users) within my company to use the script. This way, if a user (Engineer, foreman, etc) has a meter number but wants to know the Upstream Protective Device, they can open the script, enter the meter number and get the return value they need. Keep in mind, these users have NO GIS software (ArcDesktop, Python, etc) and simply just viewers.  Is this something that is possible to convert a Python script to an executable file for Non-GIS users? If so, how do I start. If I can get it to work, it will open up many possibilities and new query scripts I can build and provide to company users that need to research specific information.  Appreciate it. ... View more

I am working on fine-tuning my collection of Python Scripts and one thing I want to do is to add the AddMessage feature to my script. I have a particular script that produces a series of .PDF Graphs from a SearchCursor function. What I want to be able to do is each time an individual .PDF is created, I want to use the built-in SearchCursor with AddMessage to print a message to the screen showing the name of the .PDF created. Here is a portion of my script. list = [] rows = arcpy.SearchCursor(table) for row in rows: list.append(row.SERVICE_IDENTIFIER) # Double del row, rows # Remove duplicates from list list = dict.fromkeys(list) list = list.keys() for n in list: arcpy.TableSelect_analysis(table, r"in_memory\table_sel", "SERVICE_IDENTIFIER = " + str(n)) # Double # Get TWACs_Number value for row in arcpy.SearchCursor(r"in_memory\table_sel"): SERVICE_ADDRESS = row.getValue("SERVICE_ADDRESS") # String out_graph_name = n out_graph_pdf = r"Z:\Operations\Maps and Records\GeoDatabase\MEWCO GIS System\GIS Attachments\Electric System\Electric Usage Demand Graphs\F1 Feeder ALL" + "\\" + str(n)[:-2] + ".pdf" input_template = r"Y:\MEWCo GIS System - LOCAL\ELECTRIC SYSTEM\ELECTRIC GRAPHS - CONSTRUCT\GIS Graph Temps\ELECTRIC METER DEMAND - UPDATED 2020.grf" input_data = r"in_memory\table_sel" Thank You ... View more

Greetings:    For the past few years, I have been trying to convince my company to move away from the Tape Measure, Pen and Paper style of doing Utility As-Builts (Electric and Water) and move to collecting GPS points for new infrastructure and service(s) that we install using a GPS receiver and our current Trimble Nomad field data collection device. As of now, I have had very little luck in convincing them that this would be a benefit to our company and my GIS database.     What I would like is to see if there are other companies out there that are using a GPS Receiver and some kind of mobile hardware to collect Field As-Builts, specifically in the electric and water utility industry that I could get some advice and feedback on how it has benefited their field As-Built collection workflow. My goal is to be able to collect new infrastructure installation data (Valves, meters, end-points of mainlines, building corners, etc) via GPS coordinates at a very high accuracy and append the newly collected data into my overall dataset. However, as I mentioned before, convincing the decision makers is becoming a challenge and I need some assistance.     Any advice or assistance in helping me achieve my goal(s), would be great. Thank You ... View more