Latest Contributions by JoeBorgione

If you use append, set it and forget it; that is, create a script for the append, and start it at 4:55 pm just be fore you leave for the day and forget about it.  That saves you all the overhead of insert cursors, edit sessions, etc.... ... View more

As a matter of style, I prefer not to use words like workspace as a variable since it's in the env method.  I always use ws as the workspace.  Also, I notice that you use the r'' (raw text) but include \\.  That's the beauty of r''; there is no need to escape a slash.  Finally, what is the purpose of nesting the insert cursor within a search cursor?   import arcpy arcpy.env.workspace = r'C:\temp\my.gdb' ws = arcpy.env.workspace fc = 'YourFeatureClassName' ... ... ... edit = arcpy.da.Editor(ws) edit.startEditing() edit.startOperation() ... ... ... edit.stopOperation() edit.stopEditing(True)   ... View more

Just spotted this job posting down below your post: https://community.esri.com/t5/gis-jobs-questions/gis-administrator-for-the-greater-orlando-aviation-authority/m-p/1078699#M255   ... View more

Welcome!  What a great background to bring to the table! ... View more

Instead of sys.exit() can you  try quit() ?   import time for x in range(0,10): if x == 9: print(f'{x} Quit in 5 seconds') time.sleep(5) quit() ... View more

...but I never used it before and am not sure how to configure it I guess you can't say this ^ any more! ... View more

That's true for any web app: it starts with a web map.  I just re-read your o.p.: for an ArcGIS On Line map, you'll need to get your data from ArcGIS Server to AGOL. Is the Server data static or dynamic? There is a way to point AGOL to your server data, but I don't know the particulars on that off hand.   ... View more

I'm no expert with it, but give it a shot; I know that's the one you need to use. ... View more

Again, I really don't understand what you are trying to achieve.  Perhaps someone else can help. ... View more

I'm afraid I don't understand what you are after.  You have a file that has Lat,Lat and Long,Long in two different fields correct?  What are the pairs you wish to display?  Lat,Lat?  Long,Long?  Neither of those make sense in GIS.   ... View more

I assume by 'open' you mean view as points.  Take a look at XY Table to Point.  I suggest turning your csv into a table first.  ... View more

Do you just simply make the updates in the local database and the batch append those feature class updates to the hosted feature layer That's pretty much how we do it.  We do overwrites too but sounds like that isn't  an option for you. ... View more

To echo @VinceAngelo , you'll need to closely examine what is being given to you.  For example, if your Excel worksheets have complex formulas that refer to other worksheet cells, you will have your work cut out for you.  On the other hand, if they are just straight up text, int, float etc fields, it won't be too bad. When you mention that 'Authority can export its schema as an excel file' does that include the data or just the field definitions?  You might start with Excel to Table and see how that shakes out for you.  With respect to your 'lookup lists for particular attributes'  that sounds like you might get away with first converting them to a table and use Table to Domain for starters. It's all do-able, but you'll need to experiment a bit as you go.   ... View more