Latest Contributions by LLCCG

‎12-13-2022

I have a feature class that has an attribute called "status", and another attribute called "approved by". Obviously, when something is in the planning stage, I want "approved by" to remain null. But when the status changes to "approved", I want to require some value in "approved by". I don't care what the user puts in that space--there are too many possibilities to create a list of domains. But I do want to require that something is put there. Using contingent values, I can require that the "Approved by" value is when "Status" changes to approved. But a null value seems to pass the test. Is there any way to require a value in "Approved by" if and only if "Status" is set to "Approved"?

‎11-14-2022

I did it on both machines. Those two machines are also the machines that run Portal and Data Store. When I open Portal Admin, and go to the SSLCertificates page under Machines, each one shows two self-signed certificates, both of which have 2053 expiration dates. Is there anything else I need to do there? When I run describedatastore, it doesn't have any mention of SSL. (It goes straight from "Data store status" to "Last failover" with no lines in between.) I assume that means it's not ssl enabled?

‎11-14-2022

This seems to have worked perfectly. Thanks!

‎11-13-2022

The screen for both machines looks the same: The cert that ends in "2022" is the CA cert that expires soon.

‎11-13-2022

Here's the screenshot from Server Admin that lists the certificates. There is an identical page for the other machine on which Portal, Server, and Data Store are installed. The one ending in "2022" is the one that expires soon. In Server Admin, when I go to the "Machine" page and click on each machine, it says that the Web Server SSL Certificate is that cert ending in 2022.

‎11-11-2022

Yes, using the 6443 address. The date isn't in Server Manager, though, it's in Server Admin (server.domain.com:6443/arcgis/admin). It's under Home>Machines>MachineName>sslcertificates. When I open the two certificates listed, on is a self-signed certificate that expires in 2053, and the other expires in 2022.

‎11-11-2022

I see the one in Server Admin that is expiring soon. That one must have been installed in ArcGIS Server, right? Or is it just reading it from IIS?

‎11-10-2022

Yes

‎11-10-2022

这是当我对一个shapefile使用它。但I need to run it on a versioned enterprise geodatabase. When I run the script, it give me an error saying that it has to be done in an edit session. There's a post on stackexchange that says to use Arcpy.da.Editor. The Editor documentation looks like that tool does exactly what I need. Should my code just be something like this then? import arcpy import os feature_class=r'\DB.sde\DB.DBO.Addresses' fields=['Longitude','Latitude'] with arcpy.da.Editor(os.path.dirname(feature_class), multiuser_mode=True): with arcpy.da.UpdateCursor(feature_class,['SHAPE@X','SHAPE@Y']+fields) as cursor: for row in cursor: row[0]=float(row[2]) row[1]=float(row[3]) cursor.updateRow(row)

‎11-10-2022

IT tells me that our SSL certificate is expiring soon and needs to be updated. I have a HA system with Portal, Server, and Data Store each running on two machines. I'm not really sure how many places I need to update these certificates, though. In Portal Admin, when I go to Home > Machine > MachineName > SSLCertificates, each of the two certificates listed shows an expiration date of 2053. I'm assuming I don't need to update anything there. In Server Admin, when I go to Home > Machine > MachineName > SSLCertificates, I have one that expires soon, and and a self-signed certificate that expires in 2053. Is there any way to check the expiration date of the certificate for Data Store? Is there any other place I need to check for certificates that expire soon? I'm thinking that all I need to do is update the one in Server Admin that is expiring soon, and restart services, right? Thanks!

‎11-04-2022

I have a feature class that has several million address points. A small percentage of them are not terribly accurate, but a small percentage of several million is still too many to update one at a time. We have some code that interpolates a more accurate X,Y location based on nearby addresses that are accurately placed. So now I have a table of new X,Y coordinates and I need to move the existing points to those coordinates. I can't, unfortunately, just use Display XY, append the new feature class to the original, and replace the old entries. The GlobalID for the original feature has to stay the same. I can use the Move To tool to update one at a time, but that would be really unpleasant. Is there a tool I can use to do them all at once?

‎07-21-2022

@Anonymous User Is this still a viable timeline for Enterprise integration?

‎01-31-2022

Unfortunately, they're shifting differently. We purchased a set of addresses, a number of which (mostly addresses for newly constructed roads) were only geocoded to a zip-code level. I'd like to update them with more accurate coordinates. Each address has a unique identifier, so I'd love to be able to make a table with the identifier, lat, and long, and be able to move the points to those new coordinates. I thought about copying the attribute table for the records I want to change, adding lat and long columns, using the Display XY tool to locate them on the map, and then deleting the original features and appending the new feature class to the original feature class, but that would change the GlobalID for the address, which I can't do.

‎01-31-2022

I have a large point feature class, and I need to move a significant number of the features to new coordinates. I can use the Move To tool to do it one at a time, but it would be significantly better if I could take a table of coordinates and do it all in one. How could I do this? I don't think I can create a new feature, because I need the GlobalID to stay the same.

‎12-30-2021

I have an enterprise geodatabase. One of the feature classes in that geodatabase is a bunch of addresses. The table is traditionally versioned, and the versioned view is called address_evw. A different part of the business operation looks at that address_evw in SQL Server. For purposes of indexing it in order to make their queries run faster, can those indices be made within SQL Server, or should I use the Add Attribute Index tool? Does it matter?

Online Status	Offline
Date Last Visited	‎02-17-202311:31 PM

My Ideas

Latest Contributions by LLCCG

Is it possible to disallow a null attribute with contingent attribute rules?

再保险:追求ions about updating SSL certificates on 10.8.1

再保险:追求ions about updating SSL certificates on 10.8.1

再保险:追求ions about updating SSL certificates on 10.8.1

再保险:追求ions about updating SSL certificates on 10.8.1

再保险:追求ions about updating SSL certificates on 10.8.1

再保险:追求ions about updating SSL certificates on 10.8.1

再保险:追求ions about updating SSL certificates on 10.8.1

Re: I need to bulk update the location of points

Questions about updating SSL certificates on 10.8.1

I need to bulk update the location of points

Re: Compatibility with ArcGIS Enterprise

Re: How to bulk move point features to new x,y coordinates?

How to bulk move point features to new x,y coordinates?

Enterprise database indexing question

再保险:追求ions about updating SSL certificates on 1...

Enterprise database indexing question

Dashboard views analytics/tracking?