|
POST
|
I have a fairly simple Sql trigger set to run on a point feature class. The trigger, however, doesn't seem to execute when the point is initially inserted. Any subsequent edit of the feature will seem to work as expected. The trigger is on the add delta table of the feature class. The screenshot below is a query of the add delta table showing the edit history of a feature (most recent last). The trigger should update the XCoordinate, YCoordinate, Longitude, and Latitude fields after insert. You can see that on the initial insert of the feature, those fields remain NULL. Any edits after initial insert (rows 2-4) show those fields getting updated. Is there some reason the trigger isn't working on the initial insert of the feature? I am testing by editing through a web map in ArcGIS Enterprise (10.7.1). Below are some details of my feature class, database, etc... and the trigger statement. RDBMS: Sql Server 2014 Standard Geodatabase Version: 10.7.1 Feature Class is Registered as Versioned Feature Class is Archived ALTER TRIGGER [dbo].[triggerName]
ON [dbo].[a999]
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- ==================================================
-- UPDATE COORDINATE FIELDS
-- ==================================================
-- update X coordinate field
update t
set t.XCoordinate = i.SHAPE.STX
from
EnterpriseDatabase.DBO.a999 as t
inner join
inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID
-- update Y coordinate field
update t
set t.YCoordinate = i.SHAPE.STY
from
EnterpriseDatabase.DBO.a999 as t
inner join
inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID
-- update Longitude field
update t
set t.Longitude = (select db1.dbo.get_longitude(i.SHAPE.STX, i.SHAPE.STY))
from
EnterpriseDatabase.DBO.a999 as t
inner join
inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID
-- update Latitude field
update t
set t.Latitude = (select db1.dbo.get_latitude(i.SHAPE.STX, i.SHAPE.STY))
from
EnterpriseDatabase.DBO.a999 as t
inner join
inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID
END
... View more
03-05-2020
08:42 AM
|
0
|
5
|
6035
|
|
POST
|
Drew Dowling In my experience feature classes that have numeric values in their names will show up at the bottom of the Pro catalog pane, prior to version 2.5. This seems to have been corrected in 2.5 (...and perhaps earlier 2.4.x versions, I'm running 2.5 currently).
... View more
03-02-2020
12:57 PM
|
0
|
1
|
3578
|
|
POST
|
So if I wanted to change this, is this bit located in a file somewhere within the WAB structure?
... View more
11-25-2019
09:18 AM
|
0
|
1
|
1072
|
|
POST
|
When a search result is not found, the highlighted text is shown. Is this text string stored in a file somewhere where it can be altered? We've had a request to include specific contact information if this occurs. Or...can a javascript file be written to append text to the end?
... View more
11-22-2019
07:43 AM
|
0
|
3
|
1115
|
|
POST
|
I have a service that has a polygon feature class representing parcels, and a related table populated with tax history data. Using Arcade, I'm able to build a pop-up in a web map that displays the tax information for each tax authority. However, this only seems to work in ArcGIS Online (AGO). If I use the same service, and the same Arcade expressions within Portal (10.7.1), the pop-up does not display, or seem to retrieve any of the related table information, specifically when calling an iterator to get the individual rows within the related table feature set. If I use the Console function to test if the FeatureSet is returning/finding anything, it seems to indicate that the related records are being found in Portal, as the number of related tax records found is correct...but none of the individual rows within the related table feature set are being returned. Is this a known issue/bug in Portal...?...is there some sort of performance issue in Portal when it comes to retrieving the data? Any ideas...? Below is the Arcade expression being used, and console returns between both AGO and Portal. AGO returns what I want, Portal does not ... like I said, seems to be specific to the iterator. // get gpn
var gpn = $feature.GPN;
// construct sql
var sql = "GPN=" + "'" + gpn + "'";
// create feature set
var fsTaxBill = FeatureSetByName($map, "Tax Bill Distribution");
// order feature set
var fs = OrderBy(Filter(fsTaxBill, sql), "TaxGross DESC");
// get feature set count
var cnt = Count(fs);
// display number of related records found
Console('Number of related tax records found: ' + cnt)
// create return place holder
var p = "";
// check if any related records were found
if (cnt > 0) {
// create iterator
Console("Start iterator...")
for (var x in fs) {
Console("Within iterator...")
// get tax authority
var a = x.TaxAuthority;
// get and format gross tax
var g = "$" + Text(x.TaxGross, "#,###.00");
// add authority and gross tax to place holder
p += a + ": " + g + TextFormatting.NewLine
}
Console("End interator...")
} else {
// no related tax information found
p = "No tax information found..."
}
// display return value
Console(p)
// return value
return p Related table pop-up working in ArcGIS Online AGO console test --- iterator working Related table pop-up NOT working in Portal Portal console test --- iterator NOT working
... View more
10-28-2019
10:37 AM
|
0
|
0
|
1654
|
|
POST
|
Nana Dei, This is exactly what I was looking for, thank you so much! Edited the test features (blue) in the screenshot above, added the environment variable for the transformation to my python script, and synchronized edits. Everything lines up now As a follow-up, I see that the Create Replica tool has an environment variable for geographic transformations as well. Instead of doing the manual create replica method in ArcMap mentioned in this article, can I just add the same environment variable when creating the replica via a python script using arcpy.CreateReplica? Thanks again!!!
... View more
10-18-2019
07:50 AM
|
0
|
1
|
2557
|
|
POST
|
Hilary Curtis, Is your response referring to hosted feature layers within a Portal Data Store, or feature services published from ArcGIS Server to a federated Portal? I agree with Kevin MacLeod that polygon or line feature services published from ArcGIS Server are just too slow to draw to support being used within a web map. However, hosted feature layers published to the Portal Data Store are incredibly responsive. We are a medium sized government agency that supports a pretty good number of GIS users, and if would be amazing if we could just publish feature services from ArcGIS Server and have them available for our users to use in web maps. Most of our users are not heavy editors that need Pro or Desktop, and being able to provide them web maps and feature layers as a way to construct maps, is one of our desired goals...but until published feature layers from Server perform better, that's not a reality. Before someone mentions alternatives...like caching, or publishing data to a hosted feature layer...that's all well and good, but it requires maintenance, and perhaps a lot of it if you have several or tens of hosted feature layers you want your users to be able to use. Re-building cache takes time and a lot server resources. Overwriting hosted feature layers takes time and both of these options means your data is a snapshot in time until you update it.
... View more
10-17-2019
12:57 PM
|
1
|
2
|
3852
|
|
POST
|
I really like the idea of geodatabase replication, and one idea we've had recently is to replicate our production data to a separate geodatabase specifically used for web services. Our production data is in a local State Plane coordinate and we'd like our web environment to be in Web Mercator so that no projection has to be done on the data in order to overlay on Esri standard base maps. I am aware of this Esri technical article that provides a workflow for initially creating the replica, and it works as expected. However, I'd like to automate the process of synchronizing our replicas using Python. When I test this workflow, edits pushed from production to the web replica do not seem to take into account any type of transformation, and when the web replica is overlaid with the production data, you can see the NAD83 and WGS84 datum shift (screenshot below). Is there any way to account for the datum transformation when automating the replica synchronization? Having to manually sync the replica using tools within ArcMap really isn't a feasible option for us. Blue features = production data in NAD83 State Plane Red features = replicated data in WGS84 Web Mercator The shifted red features are those that were added AFTER the replica was created and then synchronized.
... View more
10-17-2019
09:30 AM
|
0
|
3
|
2810
|
|
POST
|
I really like the idea of shared pooling instances with the latest releases of ArcGIS Server. Rather than having dedicated SOC instances running, we can dedicate certain services to participate in the shared pool to save server resources. One thing I have noticed with services participating in the shared pool is that anti-aliasing is not honored for these services. Once I remove a service from the shared pool, I notice anti-aliasing is honored. I'm just curious why this is?...and if this is something that can be changed / implemented in future releases? I know this may be a small issue for some, but as someone who enjoys good looking maps, it's one thing I notice right away with services.
... View more
09-17-2019
12:26 PM
|
2
|
2
|
1288
|
|
POST
|
Using the ArcGIS API for Python, is there a way to get the name of a user's folder if provided the folder ID? For example, one of the properties of a portal item is "ownerFolder", which returns the id of the user's folder where the portal item is housed. This is very helpful if the user has many folders when trying to find the item. I'd like to know the name of this folder rather than just having the id. Is there something similar to "content.get('item_id')" that can be used to return folder properties? I'm aware of arcgis.gis.User("user_name").folders ... which returns a list of dictionaries providing information about all the folders a user has. I don't really want to cross-reference all the user's folders and then match the id, but if that's the only way...
... View more
07-09-2019
07:18 AM
|
2
|
4
|
4992
|
|
POST
|
We currently have an enterprise geodatabase that we use for hosting read-only web services. I'm wondering if this would be better suited for a local file geodatabase on our ArcGIS Server machine, in terms of read performance? What I'm really interested in is: is there a way to get quantifiable data that would show performance differences? For example, if I had the same feature class in an enterprise gdb and a file gdb, and each are published to separate services, can I be able to determine any noticeable performance gains? ... are the ArcGIS Server statistics a good method for doing this?...are there other tools that would help detect performance differences? My initial thoughts would be: a local file gdb should perform better since it's local to the Server machine, and since it's a file gdb, it doesn't have to authenticate a user, read any versions, and connect to a different server. I'm not sure if it would be leaps and bounds better in performance, and maybe it wouldn't provide any noticeable performance gains at all...I'm just curious on if others have tried detecting performance differences, and if so, what methods, tools, etc... did you use and which were helpful.
... View more
06-19-2019
01:25 PM
|
0
|
0
|
890
|
|
POST
|
Is it possible to change some of the default Print widget Advanced settings within Web AppBuilder developer edition? For example, the default map scale unit is "Miles" ... I'd like it to be "Feet", so every time one of our users wants to use the widget, they have to remember to go through the Advanced settings. Just curious if there's a javascript or config file somewhere where this can be changed?
... View more
06-06-2019
11:52 AM
|
1
|
7
|
6764
|
|
IDEA
|
I think it would be incredibly useful to provide your machine's installed font list as an option when trying to create a point symbol callout for labels in Pro. Currently, when I create a point symbol callout label in Pro (2.3.3) and select "More Point Symbols", I'm provided a gallery of point symbols for the project. I think it would be beneficial to have the option to browse your installed fonts in order to have the ability to select a specific character from an installed font. I don't really want to have to create a point symbol just to use it as a callout in a label. Similarly, what if I want multiple characters in my callout, I'd like to be able to add characters to the callout as needed.
... View more
06-04-2019
10:43 AM
|
1
|
1
|
997
|
|
POST
|
We have a lot of base maps available to our users with ArcGIS Enterprise, however, I've noticed something in the Portal Map Viewer which I'm curious if anyone else has experienced... From my testing, it seems like the maximum number of base maps that will be returned within the Basemaps dropdown in the Portal Map Viewer is 50. As I mentioned, we have a lot of base maps available to our users, (for example, dealing with historical imagery, raster and vector tiles caches based on the application use, etc...) the number of web maps created to be used as base maps, and shared to the group we've designated as being used to display available base maps probably numbers somewhere around 65-70. I noticed that certain web maps that are shared to our base maps group were not showing in the Basemaps dropdown, so I created a test group, shared them to that group, changed the Organization settings, and the same thing is happening ... only 50 maps are being returned. I'm wondering if anyone knows if there is a setting buried somewhere in the Portal install files that stores the maximum number of maps returned in the Basemaps dropdown, somewhere we could alter the number of maps being returned to include all of our maps that are shared to our basemaps group???
... View more
05-09-2019
12:13 PM
|
0
|
0
|
823
|
| Title | Kudos | Posted |
|---|---|---|
| 3 | Friday | |
| 1 | Friday | |
| 3 | Friday | |
| 15 | Friday | |
| 5 | Friday |
| Online Status |
Offline
|
| Date Last Visited |
Friday
|