|
POST
|
No problem. Most of the time people have questions like this, it isn't a question of whether the functionality got ported over but where it got put. If you are happy with the outcome, please mark the question answered to close out the thread. Thanks.
... View more
10-23-2015
08:19 AM
|
1
|
0
|
10616
|
|
POST
|
In the Contents pane, List By Selection tab, you can right-click on a layer to get a context menu showing "Make this the only selectable layer."
... View more
10-23-2015
07:46 AM
|
1
|
2
|
10616
|
|
POST
|
I just tested an older layer file and created a new one, and I didn't run into the issue you are seeing. Are the field mappings showing up correctly in the tool before you hit the Run button?
... View more
10-22-2015
01:14 PM
|
0
|
1
|
1954
|
|
POST
|
For starters, something is off with the code you posted here because having square brackets around your parameters in the function definition is invalid. Also, do you mean to be turning all of your variables into lists before checking them? For example; >>> zero = 0
>>> [zero] > 0
True
>>> The code, as written, is comparing a list with one element to an integer. It is important to note the list itself is being compared, not the first element in the list. Another issue could be how you are concatenating the strings. Are you passing strings or numbers to this function? If numbers, your string concatenations will generate a TypeError. Try the following, it assumes the last 3 parameters are numbers. If the last 3 are strings, some changes would have to be made: def FindLabel ( stand_code, Avg_TPA_Pine, Avg_TPA_Cyp, Avg_TPA_Hdwd ):
label = ""
try:
if Avg_TPA_Pine > 0:
label += "TPA P: " + str(Avg_TPA_Pine) + " / "
if Avg_TPA_Cyp > 0:
label += "TPA C: " + str(Avg_TPA_Cyp) + " / "
if Avg_TPA_Hdwd > 0:
label += "TPA H: " + str(Avg_TPA_Hdwd)
return str(stand_code) + '\n'+ label
except:
return str(stand_code)
... View more
10-22-2015
01:02 PM
|
0
|
5
|
4448
|
|
POST
|
I suspect what is happening can be explained in the Build Network documentation: Build Network Summary Reconstructs the network connectivity and attribute information of a network dataset. The network dataset needs to be rebuilt after making edits to the attributes or the features of a participating source feature class. After the source features are edited, the tool establishes the network connectivity only in the areas that have been edited to speed up the build process; however, when the network attributes are edited, the entire extent of the network dataset is rebuilt. This may be a slow operation on a large network dataset. Usage Before building a network dataset, an exclusive schema lock is required on the network dataset and the participating source feature classes. This means that you (or anyone else) cannot be editing the participating feature classes. You will receive an error if an exclusive schema lock cannot be obtained. .... Although you are not directly calling the BuildNetwork function, your error message gives the impression it may be called for you after closing an edit session on a network dataset. As to why the BuildNetwork function is failing, possibly because it can't gain an exclusive schema lock? Can you run the Build Network tool successfully outside of trying these edits?
... View more
10-19-2015
01:56 PM
|
0
|
0
|
1542
|
|
POST
|
It appears you have an issue where you are never applying your non-spatial filter to your spatial selection or your spatial filter to your non-spatial selection until the ExportFeatureClass call at the very end of your script, hence the empty shape file. I can't verify my hunch right now because I don't have VBA Compatibility installed. As an aside, please use code formatting/syntax highlighting as described in Posting Code blocks in the new GeoNet. It is much easier for community member to comment when the code has line numbers. After this line: pSelSet = pFSel.SelectionSet Try adding and changing the following to see if it makes any difference: pSelSet1 = pSelSet.Select(pQFilter)
If pSelSet1.Count = 0 Then
Exit Sub
End If
... View more
10-19-2015
08:56 AM
|
0
|
1
|
1993
|
|
POST
|
Can you connect or access the server and database from outside of ArcGIS, e.g., can you ping the server, can you login to the database using the sqlcmd utility? There could be lots of issues that have nothing to do with ArcGIS that are causing the error message. When you say you have "the SQL Server 2012 install" on your laptop, do you mean SQL Server Express that bundled for creating desktop and workgroup geodatabases? If so, can you connect to your desktop or workgroup geodatabase on your machine?
... View more
10-18-2015
03:50 PM
|
0
|
0
|
1176
|
|
POST
|
Can you elaborate on "the WhereClause is null?" A SQL WHERE clause can be absent/present or defined/undefined, but I would argue the clause itself cannot be NULL. A SQL WHERE clause can contain search conditions that check for NULL conditions, but that is different than saying the clause itself is NULL. You ask, "How can I stop the export if pQFilter.WhereClause is nothing?" Is that question meant to imply that the line in the script, pQFilter.WhereClause = ..., doesn't exist sometimes or does it mean that ep_query isn't always defined or is an empty string? My guess is that your issue is with ep_query, so it would be helpful if you could elaborate on what data type it is, where it is getting defined, and how it is getting defined.
... View more
10-18-2015
03:31 PM
|
0
|
3
|
1993
|
|
POST
|
OSA login is never a user, a specific user, it is a flag to tell the software to use the credentials of the currently running process that is initiating the connection. You can have a single script that uses the same SDE connection file (with OSA authentication) but creates different versions for different users. The scheduled task the executes the code just needs to run under each user's credentials, which can be stored/cached when the task is scheduled. Similar to how Windows services can be run under different user or system credentials, so can scheduled tasks, but the user would have to be there with you to set it up since his/her fingerprint will be requested when changing the execution credentials of the task. I can't recall ever hearing about changing version owners after versions are created. There might be some kind of hack, but it seems risky/unstable.
... View more
10-15-2015
11:44 AM
|
0
|
0
|
2288
|
|
POST
|
I don't work with fingerprint readers, but I assume credentials from logging in with fingerprint readers can be cached like when using a username and password. If so, I would script out the creation of new versions, using the tool Neil Ayres suggests, and then create a bunch of scheduled tasks on a machine to have the script run under each user profile after the maintenance work has been done. If your security settings in your company force users to be logged in for their scheduled tasks to run, then you might have to set up the scheduled task as a login task/script.
... View more
10-15-2015
06:26 AM
|
1
|
4
|
2288
|
|
POST
|
Query layers is a form of SQL access to data, so I guess I don't understand your statement regarding not having SQL access to your organizations production data. If that were true, you wouldn't be retrieving any data through query layers either. Regarding the use case where someone wants to interact with DBMS tables and geodatabase feature classes in a versioned environment, I think that is quite a common situation. If you want to work with DBMS tables, i.e., non-geodatabase tables or feature classes, then you can use query layers to pull the data into ArcMap. If you want to work with versioned data from a geodatabase, you can use the normal add data workflows to load them into ArcMap. There is nothing that prevents someone from mixing different types of data sources in the same map document. I may be misunderstanding your situation.
... View more
10-15-2015
06:00 AM
|
0
|
1
|
2444
|
|
POST
|
Can you post more complete code? You mention doing some "calculations," what calculations specifically before trying to remove the join.
... View more
10-14-2015
09:47 AM
|
0
|
4
|
2221
|
|
POST
|
I see the same behavior with ArcGIS 10.3.1 and SQL Server. It is arguable whether what you are experiencing is a bug, design limitation, or simply the design of query layers. As is discussed in the documentation: What is a query layer? A query layer is a layer or stand-alone table that is defined by a SQL query. Query layers allow both spatial and nonspatial information stored in a DBMS to be easily integrated into GIS projects within ArcMap. ... Query layers allow ArcMap to integrate data from geodatabases as well as from DBMSs. .... The focus or primary purpose of query layers is accessing data from DBMSes, i.e., not geodatabases. If you are using ArcGIS Desktop to access data in a geodatabase, the assumption is that you will be using the normal way of adding data into the application and not query layers. The New Query Layer dialog box uses SDE connection files to get DBMS properties, not geodatabase properties, so the version the SDE connection file is pointed to is basically ignored. I am not defending how this works, or doesn't work, I am just explaining that what you are seeing is expected given the current implementation of query layers.
... View more
10-14-2015
09:10 AM
|
0
|
3
|
2444
|
|
POST
|
By chance, do you have 64-bit Background Geoprocessing installed as well? Personal geodatabases and Excel tables aren't supported with 64-bit Background Geoprocessing, so sometimes people have problems if it is installed and they have background processing enabled.
... View more
10-14-2015
08:50 AM
|
2
|
1
|
1392
|
|
POST
|
There are several pre-defined arrow styles in the Gallery as well, which I find sometimes easier to use one of those and then modify it rather than modifying the default.
... View more
10-13-2015
09:58 AM
|
1
|
0
|
1276
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 2 weeks ago | |
| 2 | 4 weeks ago | |
| 1 | 4 weeks ago | |
| 2 | 06-05-2026 10:30 AM | |
| 1 | 05-29-2026 08:22 AM |
| Online Status |
Offline
|
| Date Last Visited |
11 hours ago
|