Latest Contributions by ShitalDhakal

‎11-14-2021

Hi all, thank you for all the suggestions. The easier solution that worked for my (as of now) is to use the database view and publish the view layer instead. This way, there is a lock established on the view feature class only and I can use python scripts to overwrite the original feature class. More on the database view here - https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-view.htm

‎11-05-2021

I will look into this, thank you. I am also trying to see if creating a 'database view' and publishing the view layer might release lock from my actual feature class.

‎11-05-2021

Thank you. I will look into this. Although mine is not a hosted layer. It's a feature layer published through federated server so that the layer is always in sync with the enterprise geodatabase.

‎11-05-2021

Thank you. Append might not work for what I am trying to do because I want to add all the records every morning and delete all the records from the previous day.

‎11-05-2021

Thanks but I have other services that need write access to be editable on Collector app or through browser.

‎11-04-2021

Hello, I get a fresh csv every morning that I geocode and publish as a feature layer to be consumed in a dashboard. Now when I use python script to automate the workflow every morning, I see a lock from my ArcGIS Server service account. This lock (probably) doesn't let the python to overwrite the feature and a result, the new feature class that gets created appears in UPPER CASE and as a stand alone layer (not inside feature dataset). From second time around, the script just fails because either it couldn't overwrite the feature class or because it thinks there is already a feature class with that name inside the enterprise geodatabase. So, basically how can I overwrite a feature class that is published and hence has a lock from service account using python?

‎11-04-2021

Hi just wondering if you found a solution to this? I have a csv that I geocode every morning. Since the layer has been published in federate portal, there is always a lock. Next morning, my python script cannot work properly because of the lock. I would appreciate a solution to this.

‎06-03-2020

Thank you Joe but I doubt if Points to Line would be the right tool here because it would join all the points in Red Zone but in reality, there would be blocks of green and blue zone streets in between two red zones. Also, it wouldn't respect the geometry of real-life streets - they are seldom in a straight line. I have a hunch that Linear Referencing might have the right tools for the job, need to explore more.

‎06-02-2020

Thanks, Joe. When I think of it more, a line layer is more feasible than a polygon. Let me explain more. I am trying to create a street sweeping map so that each household knows what color zone they belong too. The table has a beginning and ending street intersections for each zone and the cross street that goes through the zone. There are no other vertices. So for the first column, I am trying to give the street segment between 150 to 2528 Cambell Ave a red color and street segment between 259 - 2522 Madigan St a green color. I have over 6000 such rows. So in short, how do I join these street intersections to get a line layer? Thanks!

‎06-02-2020

Hi, I have a very similar problem at hand, for mapping boundaries of police beat or fire districts. As shown in the image below, I am trying to draw a polygon or at least lines for the addresses/parcels between 'From' and 'Two' and give them individual color. I can geocode them but then all I'll have are points. How do I go from geocoding points to lines or even better polygons layers? Any feedback will be greatly appreciated - Richard Fairhurst‌ and Joe Borgione‌. Thanks, Shital

Online Status	Offline
Date Last Visited	‎04-12-2022 06:40 PM

My Ideas

Latest Contributions by ShitalDhakal

Re: Publishing a layer creates lock and my python script cannot replace the feature class

Re: Publishing a layer creates lock and my python script cannot replace the feature class

Re: Publishing a layer creates lock and my python script cannot replace the feature class

Re: Publishing a layer creates lock and my python script cannot replace the feature class

Re: Publishing a layer creates lock and my python script cannot replace the feature class

Publishing a layer creates lock and my python script cannot replace the feature class

Re: How to unlock SDE layers?

Re: how to geocode lines

Re: how to geocode lines

Re: how to geocode lines

Re: How to unlock SDE layers?