Latest Contributions by LorindaGilbert

Hi All, I need to check some indices on some tables in SQL server SDE.  I have the S number for the table that needs to be reindexed, however, I can't find the magic decoder ring for determining the business table name in order to perform the reindex. I know that the table number in the sde.table_registry gives me the adds and deletes tables, but my experience in the past was that the s, f, and i table numbers weren't the same as the adds and deletes. Can someone point me in the right direction? Thanks a bunch! Lorinda ... View more

Hi All, Think I'm just completely overlooking something here.  I'm attempting to get the closest street to a point for an address and gathering the individual components of the name for the address point. Here's what I'm attempting to use for the code.  It was telling me that I needed another curly brace, checked them all, they all matched up.  Now it says that the else is a reserved word on the second else on line 37.  Any help is appreciated. Lorinda var fsn = $feature.FullStreetName; var streetLayer = FeatureSetByName($datastore, "server.dbo.StreetCenterline"); var pre = $feature.PreDirection; var sn = $feature.StreetName; var st = $feature.StreetType; var post = $feature.PostDirection; var searchDistance = 150; var streetIntersect = Intersects(streetLayer, Buffer($feature, searchDistance, "feet")); var cnt = Count(streetIntersect); var minDistance = Infinity; if (cnt > 0) { for (var street in streetIntersect) { var dist = Distance(street, $feature, "feet"); if (dist < minDistance) { var stparse = { attributes: { pre: ["streetLayer.PreDirection"], sn: ["streetLayer.StreetName"], st: ["streetLayer.StreetType"], post: ["streetLayer.PostDirection"], fsn: ["streetLayer.FullStreetName"], minDistance: dist } } } else { var stparse = { attributes: { pre: "", sn: "", st: "", post: "", fsn: "" } } } } else { // pass no features found within search distance, name remains null var stparse = { attributes: { pre: "", sn: "", st: "", post: "", fsn: "" } } } } return stparse;    ... View more

Hi, I've got 13 Attribute Rules, all calculations (some grabbing data from another table, some setting a Y/N value, some making data all Upper case, and 4 that are actual math or date calculations), on a feature class.  I've done the editing as the data owner, tested, all work as expected.  Change the user to the sql authenticated user, tested, they all work as expected.  Then I publish the feature class to our Enterprise Server and Portal, grant the permissions needed.  Add this feature service to a web map/app, works as expected.  When I add the feature service to a Pro project (we have things locked down to minimize oops), one of the 13 AR calculations just does not work, one of the math calculations - and it is to be done before one of the others, so it is done earlier in the order.  I have tried with and without auto apply, entering the data in a specific order (it calculates based on one of two fields to be determined based on a domain).  When I add the feature class directly to the Pro project, the AR works as expected.  I have redone the rule a couple of times, resaved, republished, rinse and repeat. I have done this process of using a sql authenticated user for a feature service in a web map/app several times in the past, only without Attribute Rules. This process will also be added to a Survey123 Form in the future, so it needs to work correctly and reliably. ETA:  Pro 3.1.x; some the calculations are all non-editable, they are insert and update, I have checked 'Exclude from Application Evaluation'. What gives? Thanks, Lorinda ... View more

Hi, Have searched the forum but didn't find anything. I'm writing attribute rules in ArcPro for the LGS Addressing.  I'm wanting to fill in columns from other data that has been published to our Enterprise Portal.  Parcels, Zipcodes, Municipalites specifically, I've got the var for the portal item and set up the AR, it all validates.  However, when placing a new feature, it fills in the columns with the text for the name of the column - PID, Zip, City - not the value.  Any help would be appreciated. One of the ARs: // This rule will calculate the Zipcode the site address falls within // Define the Site Addresses fields var portal = Portal('//server.domain/portal/') var zip_field = "ZipCode"; // column name in Situs Address layer if (IsEmpty(zip_field)) { var fs = FeatureSetByPortalItem(portal, 'Zip Codes', 0, ['ZIP_CODE'], true); var zip_field = First(Intersects($feature, fs)); } else { zip_field = zip_field } return zip_field;   Thanks, Lorinda ... View more