Latest Contributions by PaulKroseman

‎10-17-2017

You can publish the NEAR tool as a GP Tool. Portal for ArcGIS has the Find Nearest tool available OOTB. The Near GP tool didn't work. It fails with schema is read-only error even when the near fields already exist. It also appears I would have to publish the GP tool once for each different input feature class. The Portal tool might work. I don't have Portal installed currently so I'm stuck with my current solution. without prepare the data (Quadtree ect.) with structure precalculated you could trivially increase the radius of the circle until it intersects at least one feature and then loop only on these. I do it for example with a soe. This is close to what I do currently. I start with a radius that is likely to return 1 feature, then double the radius until at least 1 feature is found, finally iterate the results to find the nearest.

‎10-12-2017

I'm want to query my feature service to find the feature nearest to a specific point. My current procedure is query all features within a certain radius, iterate for each feature in the result and calculate the distance to the point, then return the feature with the least distance. This seems inefficient. Is there a Near/Nearest tool available to REST for doing this better, or at least requiring less code in my application? Using ArcGIS Server 10.3.1.

‎10-26-2016

I have a couple problems with a service containing a layer with a joined table. The feature class is stored in a SDE database, the join table is in a SQL non-geodatabase within the same SQL Server instance. SQL Server 2012 ArcGIS Desktop and Server 10.3.1 Issues: 1. Using the REST interface, queries using fields in the joined SQL table returns 0 features. The query executes without error and returns the layer metadata. Queries on feature class fields will successfully return features, as will queries on the unjoined SQL table. How can I query the feature class on the joined fields? 2. Labels will not display feature class fields but will display joined table fields. A label expression containing fields from both the feature class and table will act as if the feature class field contains an empty string string. Why do the labels on a joined layer only display data from joined fields? Thanks.

‎04-26-2016

I think what the stackexchange post is asking is to create the user as a local Windows user on the server where SQL resides. Add this user (servername\username) to the SQL instance security. Open the Credential Manager on the client computer and add a Windows Credential for the server username. I only use domain authentication and have no idea if what I said is correct. Having a domain makes this infinitely easier.

‎10-28-2015

Timothy Pitts wrote: We use Active Directory to manage users, so it is definitely not preferred to try to manage user permissions at the database level since we'd need custom roles to do that. Currently, we have three roles: GIS Admin, GIS Editor, and GIS Viewer, with obvious database privileges attached at each level. That was my plan. Use AD groups for Admin, Editor, Viewer for users. Dataset permissions assigned to roles. Currently all edit roles are assigned to Editor group but I could create a group for each role if I want to restrict more.

‎10-28-2015

Writing a procedure for editors to follow, rather than rigid permissions, sounds like the best option. I could create a public version that QA posts to then use a script to post that to DEFAULT.

‎10-27-2015

I would guess all of your versions are set as Protected. I don't see a way to prevent posting to or editing a Public version.

‎10-27-2015

1. Editor - permission to Edit a Version, but not Reconcile/Post version to default. Once Editors work is completed, notifies QA/QC person to review. 2. QA/QC - permission to View the Editors Version, Reconcile, and Post to default, but not Edit the Version they are reviewing. The QA/QC person evaluates the version, but is not permitted to edit it themselves (instead they notify Editor if changes are needed). Having the editor contact the reviewer could work. How do you prevent the editor from modifying DEFAULT and allow QA user to post to DEFAULT? QA user can't be a geodatabase admin.

‎10-27-2015

I want to allow a QA/QC user to be able to post to DEFAULT but I don't them able to edit on DEFAULT. Seems like a contradiction in terms. Posting does edit sde.default. I don't want them to start an edit session or run a tool directly against DEFAULT. Posting is fine. They perform their own edits and push to DEFAULT, but don't need geodatabase admin priveleges.Check and see if sde.default is PUBLIC for them; my guess is it is. Yes it is public. We have only a few users with edit permissions, but will be getting more. Setting DEFAULT to Protected would require me to post all of their edits or give them sysadmin in the database. I only create datasets/feature classes for them. I guess you'll need to decide what your role in managing the database is. As mentioned, I take control of sde.default. If anything goes haywire on it, the buck stops with me. When you have multiple people 'in charge' you stand to get a blame game of World Series proportions when things go south. Not that it ever happens.... I manage the database, services, users, etc. But I would like to not be involved in the editing process for data I'm not responsible for.

‎10-27-2015

I want to allow a QA/QC user to be able to post to DEFAULT but I don't them able to edit on DEFAULT. End users should be able to post to the QA version when they have finished an edit in their version, but should not have edit on the QA version. Maybe I'm thinking backwards. There is also another group that has their own data/version tree. They perform their own edits and push to DEFAULT, but don't need geodatabase admin priveleges. Setting DEFAULT to Protected would require me to post all of their edits or give them sysadmin in the database. I only create datasets/feature classes for them.

Geodatabase version permissions by user · ‎10-27-2015

Is it possible to grant/restrict which actions users can take against a version? I would like a user to be able to reconcile and post to a version, but not directly edit on that version.

‎06-26-2015

I am trying to update a non-spatial field and have not specified a version. My SQL is simple. UPDATE mv_view SET datafield = 1 I think the feature class is using SDE Binary. I did not think it would make a difference when trying to update non-spatial fields.

‎06-25-2015

I am attempting to edit a multiversioned view using SQL. I set the feature class to versioned, created the view from command line using "sdetable -o create_mv_view", and try to run an update with SQL on a single attribute field but receive the error: Msg 50000, Level 16, State 1, Procedure v446_update, Line 27 User must call edit_version before editing the view. If I try to call edit_version I get: Msg 50000, Level 16, State 1, Procedure edit_version, Line 78 Cannot edit the DEFAULT version in STANDARD transaction mode. I am running ArcGIS and ArcSDE 10.0 SP3 on SQL Server 2008. The ability to edit the Default version through multiversioned views is available at version 10 SP2 according to http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_editing_versioned_data_using_SQL/006z000000vp000000/. http://support.esri.com/en/knowledgebase/techarticles/detail/39112 describes this behavior also. Not specifying an edit version still gives me the first error above. Just to be sure, I removed all other versions, compressed to state 0, unversioned the feature class, reverionsed, and recreated the view, but still have the same problem. Does anyone successfully use views in this way and what version is the server running? Is the documentation wrong?

‎05-18-2015

Freddie Gibson wrote: Yea....I'm pretty sure we have any out-of-the-box tools or scripts that would allow you to do this outside of the GUI for personal sde. I'm sure you meant "we don't have any".

‎05-18-2015

Yes, I am looking at the Personal/Desktop SDE. I have it setup and working but I would like to script the creation of geodatabases. I find it odd that scripting would not be supported or requires an ArcGIS Server license.

Online Status	Offline
Date Last Visited	‎05-13-2025 11:53 AM

My Ideas

Latest Contributions by PaulKroseman

Re: REST find nearest feature

REST find nearest feature

Couple issues on service with joined table

Re: Do I need to create user accounts on SQL Server before I can use Windows authentication?

Re: Geodatabase version permissions by user

Re: Geodatabase version permissions by user

Re: Geodatabase version permissions by user

Re: Geodatabase version permissions by user

Re: Geodatabase version permissions by user

Re: Geodatabase version permissions by user

Geodatabase version permissions by user

Re: Updating multiversioned view fails

Updating multiversioned view fails

Re: Create geodatabase on desktop SDE

Re: Create geodatabase on desktop SDE

Re: Create Replica python script gives error 00582

Re: Create ArcSDE keycodes file 10.1