Latest Contributions by JoeBorgione

@JonathonRobert - I'm confused here: are you saying you did or did not use MakeFeatureLayer() in your stand alone script? ... View more

I wish the old search/update/insert cursors would just go away so you get a syntax error instead of some jacked up result. ... View more

I think @curtvprice addressed that above;  when you are working in a stand alone script, you need to use the make feature layer method in arcpy.  ArcGIS Pro presents the data in that form for you so you are able to interact with it, hence, when you refer to the data in you TOC it's a feature layer.  But when you run a stand alone script, you need to do what ArcGIS Pro does. import arcpy arcpy.env.workspace = r'C:/path/to/data.gdb' fc = 'MyFeatureClass' arcpy.MakeFeatureLayer_management(fc, "MyLayer") select = 'OBJECTID = 1' arcpy.management.SelectLayerByAttribute('MyLayer', 'NEW_SELECTION', select) ... View more

@curtvprice Curtis- where is the rest of this post? ... View more

Select features by location.  Within 0 feet; Share a line; etc.... ... View more

I can't comment on it being a bug or not, but obviously something changed between 10.6 and 10.7.  As a work around, can you run your calculations and then go back and select those lines where Bearing is Null and calculate them to 0? ... View more

Removing and replacing seems to do the trick.  We have a cloud based ArcGIS Server to which we publish data, and then we point back to it for an item in our AGOL.  Here is the code that I got to work for me: import arcpy aprx = arcpy.mp.ArcGISProject('N:\\GIS\\AddressDataManagement\\TestDir\\CUP2020_000038\\cup2020_000038.aprx') m = aprx.listMaps()[0] rmlyr = m.listLayers("MSD.SLCOMSD.AddressGridMSD")[0] m.removeLayer(rmlyr) #addlyr = r'https://name/server/rest/services/Hosted/AddressCoordinateGrid/FeatureServer/0' addlyr = r'https://ourAgol/home/item.html?id=################' m.addDataFromPath(addlyr) aprx.saveACopy('N:\\GIS\\AddressDataManagement\\TestDir\\CUP2020_000038\\cup2020_000038NEW.aprx') Lines 10 and 12 are the same data in our case: this just illustrates that the addDataFromPath can take an ArcGIS Enterprise rest end or and AGOL item. ... View more

Thank you @GaetanPRU -  the problem I see with using another layer for the CIM properties is I'd have to add the reference layer to the set of project files and that essentially defeats the purpose.  Now as I type this, I wonder if a better way would be to simply delete the existing Egdb layer and replace it with the Feature Service Layer... ... I think it's a bug or we can't update workspace_factory SDE to FeatureService.... Pretty much what I've been thinking too.  I mean, ESRI is pushing hosted feature services and with good reason However there needs to be an efficient set of tools that work and allow us to migrate from the old days of direct connection data bases to the modern approach of hosted feature services.  This from a guy with one foot out the door because he: ... View more

After a couple hours of trial and error, I'm tossing in the towel and getting a cold adult beverage. The online help describes using an existing dictionary and a replacement dictionary to update the properties.  I just can make sense of it. aprx = arcpy.mp.ArcGISProject('N:\\GIS\\AddressDataManagement\\TestDir\\CUP2020_000038\\cup2020_000038.aprx') m = aprx.listMaps()[0] l = m.listLayers("MSD.SLCOMSD.AddressGridMSD")[0] existingDict = {'connection_info': {'authentication_mode': 'DBMS', 'db_connection_properties':'xxxdb', 'instance':'sde:sqlserver:sxxxdb', 'server': 'xxxdb', 'dataset': 'MSD.SLCOMSD.AddressGridMSD', 'workspace factory':'SDE'}} replaceDict = {'connection_info': {'url':'https://xxx.org/server/rest/services/Hosted/AddressCoordinateGrid/FeatureServer'}, 'dataset': '0', 'alias':'AddressCoordinateGrid', 'workspace_factory':'FeatureService'} l.updateConnectionProperties(existingDict,replaceDict) aprx.saveACopy('N:\\GIS\\AddressDataManagement\\TestDir\\CUP2020_000038\\cup2020_000038NEW.aprx')  When I run this as is, the properties of my feature layer looks like this: Notice the value in the url row.  In the python code above, line 5 has 'authentication_mode': 'DBMS'  : if I leave that part out, it won't make any updates at all; the feature layer in the TOC still has the red exclamation mark in front of it. But when I leave it in, I get the weird properties value shown above.  In closing for today, if I list the connection properties through arcpy, it shows the sde connection properties but the feature url : pprint.pprint(l.connectionProperties) {'connection_info': {'authentication_mode': 'DBMS', 'database': 'xxx', 'db_connection_properties': '"xxxdb', 'dbclient': 'sqlserver', 'instance': '"sde:sqlserver:xxxdb', 'password': '<xxx>', 'server': 'xxxdb', 'url': 'https://xxx.org/server/rest/services/Hosted/AddressCoordinateGrid/FeatureServer', 'user': 'SLCOmsd', 'version': 'sde.DEFAULT'}, 'dataset': '0', 'workspace_factory': 'FeatureService'} It appears to be pulling from the correct source, but I don't really want those other properties populated and I would really like the Properties pane to be accurate as well.... ... View more

That's a great suggestion!  I'll post up what I find!   ... View more

That's too bad; never have understood that mentality and don't miss it now that I've left the 9-1-1 arena. I always felt  that the public in public safety is what really matters.... ... View more

Didn't quite get the part of Tom Tom and Here, but now I get it.  I've always been leery of commercially available data; comes from working in 9-1-1 for a number of years. I've always been a 'roll yer own' sort of guy when it comes to geocoding. ... View more

For the sake of discussion:  If you are already using higher quality data, what value does the Tiger data add?  I looked for Tiger 2020  streets earlier just to see what it has, and couldn't find it.  Now we are in ArcGIS Pro using the new style of locators and this process is beyond belief to try and migrate. ^^^ This is what  I don't understand.  I create new style locators and composite them together all the time.  But then again, I don't use Tiger data... ... View more