Latest Contributions by ThomasColson

‎03-30-2018

Ryan DeBruyn‌ Are you able to share your PY script where you solved this error? I'm having a hard time with trapping the error and passing on the arcpy.TableToDomain_management() call. "I found similar issue with domains. The SDE workspace I was copying to already had existing domains with the same name. I was able to work around the failure by trapping the error and passing on the arcpy.TableToDomain_management() call. When the new table is created, since the domain already exists there are no issues with the field properties."

‎03-30-2018

Any update on this from October of 2017? I'm getting the same error for the same reason. " Thank you James, its a fantastic script. Saved reinventing the wheel and is more comprehensive than we would create. If you are doing any updates, would you please consider unique domain naming. I cannot see if any one has mentioned it already but I'd also had a problem where a domain from a previous survey was preventing creation of a new survey from another schema user into a SQLServer Geodatabase. It would be useful if the domain name could be set to be more unique across the geodatabase, e.g. schemauser_survey domain name. The error that was returned when the survey was synchronized is : ====================== FAIL: Making Tables exception: ERROR 000464: Cannot get exclusive schema lock. Either being edited or in use by another application. Failed to execute (TableToDomain). ['ERROR 000464: Cannot get exclusive schema lock. Either being edited or in use by another application.\nFailed to execute (TableToDomain).\n'] <class 'arcgisscripting.ExecuteError'> 562 Thank you Kind regards"

‎03-30-2018

So line 547 is: if len(existingTables) > 0: lastSync = getLastSynchronizationTime(sdeConnection, existingTables) Not sure where to hardcode the two table names in there....

‎03-30-2018

You might have to translate that for me.....hard code the results...so do I go back to "{0}_{1}".format(prefix, table) and hard code GRSM_AA_SITE_FORM_2018? Where do I put the repeat question table, which in this case, is titled "repeat_species_event", names by the Survey Connect app when I published the survey.

‎03-29-2018

That didn't work for some reason. Have an existing SDE table "GRSM_AA_SITE_FORM_2018", that is the name of the feature service layer, same exact schema, FAIL: Making Tables exception: ERROR 000258: Output RESTON_VEG_MAP.sde\GRSM_AA_SITE_FORM_2018 already exists Failed to execute (CreateFeatureclass). ['ERROR 000258: Output RESTON_VEG_MAP.sde\\GRSM_AA_SITE_FORM_2018 already exists\nFailed to execute (CreateFeatureclass).\n'] <class 'arcgisscripting.ExecuteError'> 562 ---------------------- arcpy messages: ERROR 000258: Output RESTON_VEG_MAP.sde\GRSM_AA_SITE_FORM_2018 already exists Failed to execute (CreateFeatureclass). ====================== C:\temp\SRV_2018>

‎03-29-2018

Since you mention you're using SDE, this is really easy: STGeomFromText (geometry Data Type) | Microsoft Docs Do that on a stand-alone table, then import the geography column into a new feature class. For updates, just write a trigger that will pass new geography from your standalone table to the SDE table.

‎03-29-2018

I think, as people wrap their heads around Pro Catalog View, it might be helpful, as a "migration" aid, to be able to drag things from Arc Cat to Pro, for a few versions....

‎03-28-2018

Kory Kramer‌ I think his thinking is similar to https://community.esri.com/ideas/14251 . or either of these ideas could be edited to consider both use cases.

‎03-28-2018

Consider this scenario: you have a couple of Pro templates saved in Portal, that you're workgroup uses, and these templates, for the sake of this example, deal with emergency services: connections to EMS, Fire, LE, FEMA, DHS, NIFC, etc...type enterprise geodatabases and gis servers. Since you were "Born Ready", you think ahead and you've download these templates to your hard drive because you know you're going to be in an ICP somewhere in a cold parking lot with a 500k Verizon Mifi and no way to connect to your Portal, but being "Born Ready" means you can double-click on these template files while you're chipping the ice out of your coffee at 6 AM and fire up a Pro Project that has all of the connections you need. WAAAAAAIIIIIIIITTTTTTTTT FOR IT! Not so fast...imagine your surprise when you Pro Project opens, and you go to look for that FEMA GIS server connection in "GIS Servers"....not there. What!?!?!? All the folder connections you defined in the template are there...but not the GIS Server or Enterprise DB connections. Even though you're working a Zombie Apocalypse Response, the next 16 hours of your day does not have to be as dystopian as the grocery store running out of milk and bread or as upsetting as Carl getting bitten. You can open a local template that honors GIS and DB connections by copying it to C:\Program Files\ArcGIS\Pro\Resources\ProjectTemplates, or, in the "New" Project UI, browse to the location of the downloaded template. Not as fast and cheeky as double-clicking on the template, but, as a disaster junkie and someone who binge watches Walking Dead, you're used to things not working, Pelican Cases with broken latches, and being surprised. Take home message here: The open project from template behavior needs to be consistent and honor GIS Server and DB Connections regardless of how the template is accessed. Every second counts.

‎03-28-2018

ahhh....your idea is to move the folder that Pro looks for when populating the default template dialogue. My upvote still stands! Great idea!

‎03-28-2018

I upvoted, but you can do this yourself, which is very cool, never would have thought of this...

‎03-28-2018

Be sure to add your user story and up vote to https://community.esri.com/ideas/13672

‎03-28-2018

If you're using a SQL Database (Oracle, SQL), then you have quite a few possibilities for automating attribute values. You can do something really over the top like /blogs/HackingArcSDE/2014/12/31/hey-neighbor-whats-your-value , or just add a simple calculated constraint to a column, such as adding an acres field, and using the calculated constraint to update the value based on the shape field.

‎03-28-2018

More sunshine! After using templates for a while, I have to grudgingly admit that I prefer working with templates in Pro versus folder, DB, and Server connections in Arc. In Arc, it's "every user on their own" for making those connections, unless I spool up some hokey scripts and try to explain to folks what %appdata% is. In Pro, I can make a template that is workgroup-specific that has all the connections needed for that workgroups tasks, slam it up to Portal, and with a simple instruction, have folks start new projects with the connections they need, regardless of what computer they're on (another thing you can't do in Arc).

‎03-27-2018

"some" of what you list above should be hitting the street in 2.2 (summer), however, I'm with you on the not being able to export to AI format (apparently there's some issues with the Adobe API that's blocking that), the x,y thing with the ID tool, the labeling thing. Just to add a bright ray of sunshine to this thread.....Offline editing in Pro is way better than the Arc Workflow, and way faster too!

Online Status	Offline
Date Last Visited	‎04-26-2026 07:12 AM

My Ideas

Latest Contributions by ThomasColson

Re: Migrating data from the Survey Feature Service to an Enterprise Geodatabase

Re: Migrating data from the Survey Feature Service to an Enterprise Geodatabase

Re: Migrating data from the Survey Feature Service to an Enterprise Geodatabase

Re: Migrating data from the Survey Feature Service to an Enterprise Geodatabase

Re: Migrating data from the Survey Feature Service to an Enterprise Geodatabase

Re: Convert Google Long Lat Strings into line work

Re: Add the ability to drag and drop from the desktop ArcCatalog into ArcGIS Pro

Re: Add the ability to drag and drop from the desktop ArcCatalog into ArcGIS Pro

Pro Project Templates Aren't Consistent During a Zombie Apocalypse

Re: Customize the default Arcgis Pro Templates Folder

Re: Customize the default Arcgis Pro Templates Folder

Re: ArcGISPro - Search Attribute table

Re: Is it possible to automatically recalculate calculate fields in an attribute table?

Re: What is your take on ArcGIS Pro

Re: What is your take on ArcGIS Pro

Re: Group Managed Service Account be used for Wind...

Re: Help: Legend color ramp does not match layer c...

Re: How do I transfer attributes between features ...

Re: How to bulk delete protect and mark as authori...

Re: Migrate Portal User, Group and Group Members t...

Wildfire Response GIS