IDEA
|
I found a way to do this in Microsoft SQL Server using an SET statement with a modify function. In the example below, I change the domain owner of the 'DATA QUALITY CODE_3' to the user 'SDE', but it could be set to any user account regardless of the owner. I was able to figure this out using ESRI's tech article "How To: Return information on coded value domains using ArcSDE 10.x for SQL Server." UPDATE [GeoLib].[sde].[GDB_ITEMS]
SET [Definition].modify('
replace value of
(/GPCodedValueDomain2/Owner/text())[1]
with ("SDE")')
WHERE TYPE in ('8C368B12-A12E-4C7E-9638-C9C64E69E98F','C29DA988-8C3E-45F7-8B5C-18E51EE7BEB4')
AND PhysicalName = 'DATA QUALITY CODE_3'
go
... View more
09-13-2017
02:40 PM
|
0
|
1
|
3441
|
IDEA
|
A tool for changing domain owners is still needed as much now, if not more then when this idea was created!
... View more
09-05-2017
03:37 PM
|
1
|
0
|
3441
|
POST
|
We have an Enterprise Geodatabase (SDE) containing 300 plus feature classes that acts like a one stop library for our GIS users to use. There are feature classes from several different state and federal agencies. Since this GDB goes back over 10 years you can imagine that as feature classes were retired domains were orphaned. Has anyone written a program / script to identify orphaned coded value and range domains? Environment: Enterprise Geodatabase 10.4.1 SQL Server 2012
... View more
08-15-2017
04:20 PM
|
1
|
5
|
2998
|
POST
|
My agenda didn't send me this year to the UC but each year the problems are the same with the online agenda. Each year ESRI creates something different thereby improving on somethings but also breaking things or making them worse.
... View more
07-11-2017
04:03 PM
|
0
|
0
|
1289
|
DOC
|
Richard, Thank you for posting this. I wish ESRI would post all of these online before the conference since I find these more useful then the online agenda. I've seen similar printed lists at the different islands, or whatever they're called now, during the past two years.
... View more
07-05-2017
08:54 AM
|
0
|
0
|
1072
|
BLOG
|
Rob, There is nothing on the roadmap for database management. Not even in the long-term. There is at least one request under the Ideas for a Stand Alone Data Catalog Like ArcCatalog to ArcGIS Pro <https://community.esri.com/ideas/12671-add-stand-alone-data-catalog-to-arcgis-pro-like-arccatalog I'm in ArcCatalog most of the day and rarely need ArcMap. Also, does ArcGIS Pro now allow for the creation of Metadata? If not, ERSI needs to recognize that metadata is as important as the data!
... View more
03-29-2017
01:03 PM
|
6
|
0
|
14206
|
POST
|
BUMP (I'm still interested in the answer) Also, do map services have to be republished when a fields has been added to a feature class if the new field doesn't need to be referenced in the map service?
... View more
03-23-2017
02:46 PM
|
0
|
0
|
677
|
POST
|
Is the image being serviced from an image service? I've seen this when viewing an images service where the original rasters are missing or have been moved. In this case the image pyramids (or overlays) are what you're seeing when zoomed out.
... View more
03-17-2017
01:21 PM
|
0
|
0
|
565
|
POST
|
I've been working with ESRI software for 28 years but I guess somewhere along the line I missed a memo or two Does the ESRI software no longer need the source and target feature classes in the same coordinate system for things like Append? A (younger) coworker told me that ArcGIS Desktop does the projection on the fly in behind the scenes automatically. If there are no reasons to have the source and target in the same projection we can eliminate the need for a staging copy when updating the Web Mercator copies we maintain for map services. Does ArcGIS reproject on the fly in all of the Overlay tools too? Thanks, Randy
... View more
03-17-2017
01:04 PM
|
0
|
1
|
943
|
IDEA
|
In our SQL/SDE database we've made physical tables to store domain values in so the data can be used outside of ArcGIS. This was a great idea 6 years ago and still a great idea today!
... View more
01-17-2017
01:21 PM
|
0
|
0
|
2475
|
POST
|
Hi Kelly, I can't find the cost of the new Level 1 named users anywhere. How much of a savings is it? Thanks, Randy
... View more
12-22-2016
05:06 PM
|
0
|
1
|
516
|
POST
|
Tom, what tool did you use to delete city_2? Did you rename City to city_2 using ArcGIS but delete the table via SQL Management Studio?
... View more
12-21-2016
11:10 AM
|
2
|
1
|
2071
|
POST
|
One possibility is to have your DBA (or database developer) create a view on the table with shortened field names where needed. We've had to do this with table names and fields that are reserved words in ArcGIS. For example, there was a table named "Transaction" in a straight SQL database. If I recall, ArcCatalog couldn't even see the table.
... View more
12-20-2016
09:29 AM
|
2
|
1
|
1256
|
POST
|
Laura, I was just going to add the same link that Dan did to another brand new GeoNet discussion just posted. Can you tell us who gave you that information? BTW, we are in the same boat as you with concurrent licenses. But it's my understanding from this year's User Conference that ESRI caved on the named user issue as least when it comes to the Desktop products. But things do change.
... View more
12-13-2016
03:17 PM
|
0
|
1
|
2067
|
Title | Kudos | Posted |
---|---|---|
1 | 10-17-2019 02:08 PM | |
1 | 10-27-2015 09:30 AM | |
1 | 08-06-2014 04:50 PM | |
1 | 02-22-2019 09:05 AM | |
1 | 04-19-2018 09:37 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|