Latest Contributions by DanPatterson_Retired

Your parameters cannot contain spaces.  Did the output from my example look reasonable given my default values to test the string? More generally, it looks like you were working with a table with joins or something since the table.field notation (eg. locationbirdinfo.birdinformation_ART_Bezeichnung may work well in a model but it may fail in a script. More generally, is that the "exact" output from the model? or did you edit portions of the output? It would be much better to break that one query into a series of building blocks then concatenate them at the end just prior to feeding it into the query. ... View more

That is by design, the tool now requires that they be known and the same as indicated in the help topic post.  This is to avoid project-on-the-fly dealings I suspect ... View more

You have raised that before, but it doesn't seem to be in the cards, perhaps the User Interface options for projects again would be the best place.  I do know that a number of tools are now disabled if the coordinate system and units are unknown or unspecified. ... View more

That would be an ArcGIS Ideas‌ idea.  They do have the new preference section on the Project Backstage where you can specify whether you want your tables to float by default.  Project Options, then User Interface... that is the most likely location to have those general options placed.  To disallow multiple openings of maps etc would get a lot of pushback since a number of people like that option for the reason I stated.  So try that approach of having those types of activities put on the general User Interface options ... View more

what are your location units?  you might want to check them all Jamal ... View more

Are you using the tool that I posted? and I thought you wanted to undo the merge? Can you clarify what your inputs are and what you want as an output? ... View more

Too many 'merge' options. If you mean Merge—Data Management toolbox | Documentation  and specified an "add_source" or some other unique field is in each table, Then  Split By Attributes—Help | Documentation  might be able to do it if there is that field information which can be used to differentiate the original files (assuming you have no backups, I am guessing) ... View more

In ArcGIS Pro?  Multi-Distance Spatial Cluster Analysis (Ripley's K Function)—ArcGIS Pro | Documentation  Sounds like, it is optionally "nothing".  Perhaps if you want to graph something, then you will have to create one from the tabular results. Display_Results_Graphically (Optional) This parameter has no effect; it remains to support backward compatibility. NO_DISPLAY —No graphical summary will be created (default). DISPLAY_IT —A graphical summary will be created as a graph layer. ... View more

I don't know/care if it works, but...  \ needed at the ends Did modelbuilder really spit that out??? or was it edited??  If it was the former, then there is an issue that should be tracked down Sitename = 'a' Category = 'b' Specie = 'c' Start_Month = 'd' End_Month = 'e' End_Year = 'f' Start_Year = 'g' q = "locationbirdinfo.locationinfo_wvz_zaehlgebiete_oag_karlsruhe_Sitename = " + \ Sitename + " and locationbirdinfo.birdinformation_KAT_Bezeichnung = " + \ "'" + Category + "'" + " and locationbirdinfo.birdinformation_ART_Bezeichnung = " + \ "'" + Specie + "'" + " and locationbirdinfo.birdinformation_Month_ >= " + \ Start_Month + " and locationbirdinfo.birdinformation_Month_ <= " + \ End_Month + " and locationbirdinfo.birdinformation_DAT_Datum >= " + \ Start_Year + " and locationbirdinfo.birdinformation_DAT_Datum <= " + \ End_Year‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ # useless result q "locationbirdinfo.locationinfo_wvz_zaehlgebiete_oag_karlsruhe_Sitename = a and locationbirdinfo.birdinformation_KAT_Bezeichnung = 'b' and locationbirdinfo.birdinformation_ART_Bezeichnung = 'c' and locationbirdinfo.birdinformation_Month_ >= d and locationbirdinfo.birdinformation_Month_ <= e and locationbirdinfo.birdinformation_DAT_Datum >= g and locationbirdinfo.birdinformation_DAT_Datum <= f"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Specify a coordinate system—Properties of maps | Documentation  Create a custom coordinate system The right-click method didn't work? ... View more

As I said, that is correct ... View more

could you format your code so that it can be examined with proper indentation.. /blogs/dan_patterson/2016/08/14/script-formatting  ... View more

Updates will leave duplicates. A clean install means downloading the *.exe from My Esri and not updating through ArcGIS Pro. Just check that you only have 1 environment in arcgis pro from the Project backstage (in Python, Manage Environments. You only have one python (3.6.9 which is correct )in your environment. You can try to clone, but when you do, you have to switch into that environment before you install packages. I don't clone, since I have full admin rights to my computer and I live on the edge and do all my installs there... that is because I have the *.msi and *.cab file from the *.exe from My Esri... so I can use .... the conda install --revision thing to roll back anything glitchy. ... View more

That wasn't a clean wipe and fresh install, you now have duplicate packages.  As suggested earlier, you have to remove all vestiges of anything Arc* and to be on the safe side, anything Python.  I won't even suggest doing a registry edit at this stage. ... View more