Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About forestknutsen1
forestknutsen1
MVP Alum
since
07-04-2014
11-12-2025
736
Posts created
107
Kudos given
36
Solutions
175
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(2 Idea Submissions)Latest Contributions by forestknutsen1
|
POST
|
Okay, thanks. But in this case just the Oracle version will be changing not the version of ArcGIS.
... View more
01-04-2023
10:59 AM
|
0
|
2
|
1535
|
|
POST
|
Example of sub process use: import argparse
import os
import subprocess
parser = argparse.ArgumentParser(description='initialize electric trace weights')
parser.add_argument('--env', help='target environment: dev, test , or prod', default='dev')
args = parser.parse_args()
env = args.env
database = {'dev': 'dev', 'test': 'test', 'prod': 'prod'}[env]
working_dir = os.path.dirname(os.path.realpath(__file__))
password = xxxx
trace_weight_exe = os.path.join(working_dir, 'ElectricTraceWeightInit.exe')
command = '"{exe}" {db} {pw}'.format(exe=trace_weight_exe, db=database, pw=password)
process = subprocess.Popen(command, shell=True, stdin=subprocess.PIPE, stdout=subprocess.PIPE,
stderr=subprocess.PIPE)
exit_code = process.wait()
... View more
01-04-2023
10:56 AM
|
0
|
0
|
2949
|
|
POST
|
We have upgraded a dev database for Oracle 12c to Oracle 19. We did this by creating a new pluggable database and using the data pump to migrate the data over. Then we give the new database the original database's TNS name and rename the old database. All of our existing connection files appear to be working fine. Is there any need to recreate them? Also, I noticed that this still appears to be an issue at ArcGIS 10.6 https://support.esri.com/en/technical-article/000011653
... View more
01-03-2023
04:44 PM
|
0
|
4
|
1581
|
|
POST
|
Okay, I think I got it. The key is to use the class extension from the items xml found in the sde.gdb_items_vw.definition field. In the xml you will find the extclsid or class extension. Once you know what guid to look for you can make up a sql statement to grab the anno classes. with fc as
(select i.name, i.physicalname, i.path, i.definition
from sde.gdb_items_vw i
join sde.gdb_itemtypes t
on i.type = t.uuid
where t.name = 'Feature Class')
select name, physicalname, path
from fc
where extractvalue(xmltype(fc.definition), '/DEFeatureClassInfo/EXTCLSID') =
'{24429589-D711-11D2-9F41-00C04F6BC6A5}'
... View more
10-27-2022
02:44 PM
|
0
|
0
|
852
|
|
POST
|
How can I select all annotation classes with sql in an Oracle SDE? I can get all feature classes (including annotation) with this: select i.name, i.physicalname, i.path, t.name
from sde.gdb_items_vw i
join sde.gdb_itemtypes t
on i.type = t.uuid
where t.name = 'Feature Class'
... View more
10-26-2022
05:52 PM
|
1
|
1
|
896
|
|
POST
|
Yes, I can see that. I am in Alaska so getting cut off from the outside is a real risk for us too.
... View more
10-13-2022
01:30 PM
|
0
|
0
|
1577
|
|
POST
|
Right, okay. Thanks Scott. I think we would want them internal if we had a major disaster (like a massive earthquake or a volcanic event) and we lost all connectivity with the outside and the application has to keep working.
... View more
10-13-2022
10:01 AM
|
0
|
2
|
1582
|
|
POST
|
@Scott_Tansley Thanks for the feedback. I am still a little lost. I can hit the urls your provided. I don't see what the down side is for just using the AGOL ones... Clearly I will not be able to update the content myself but on the other had I don't think this is something I would need to do.
... View more
10-12-2022
11:19 AM
|
0
|
0
|
1592
|
|
POST
|
I am working on a SmartWorks to Esri GIS integration to an on site ArcGIS Portal. The SmartWorks folks are asking if we have internal Esri API urls for (CSS and JavaScript). This is an area of Portal I have never had to deal with. How would I go about finding the url's within our systems. And maybe some documentation on this part of Portal. Federated Portal version 10.8.1 AGOL sample url's http://serverapi.arcgisonline.com/jsapi/arcgis/1.6/js/dojo/dijit/themes/tundra/tundra.css http://serverapi.arcgisonline.com/jsapi/arcgis/?v=2.3)
... View more
10-11-2022
05:53 PM
|
0
|
7
|
1648
|
|
POST
|
How do I export and then import a web map's json with python? I took a quick look at the GIS module... but I did not see the right call.
... View more
10-07-2022
04:58 PM
|
0
|
3
|
1430
|
|
POST
|
Okay. The work flow our contractor has put together for this is making me a little unconfutable. I can see that the features on the other side of the relationship are not getting un-versioned when we un-versioned the copied anno classes. In the past I have seen changes to in versioning follow feature classes across relationships. For example, creating a relationship between a versioned feature class and a non-versioned feature class will version everything. It would be a disaster if version data was impacted with this process.
... View more
10-06-2022
02:27 PM
|
0
|
0
|
1917
|
|
POST
|
@MarlonAmaya Thanks for the feedback. So, in our case we are copying the data into new feature classes and then un-versioning them and then versioning. This is all at the feature class level with in the feature dataset. While one cannot do this at the feature level with ArcCatalog, arcpy does appear to support it. So, our workflow is not quite the same as what you outlined. Does our workflow sound okay.
... View more
10-04-2022
10:17 AM
|
0
|
0
|
1952
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-04-2024 05:39 PM | |
| 1 | 07-30-2024 09:05 AM | |
| 1 | 07-08-2024 05:32 PM | |
| 1 | 03-20-2024 10:27 AM | |
| 6 | 03-13-2024 03:38 PM |
Activity Feed
- Posted Re: SQL database (2022) Collation for UN on Geodatabase Questions. 11-12-2025 02:13 PM
- Posted Re: SQL database (2022) Collation for UN on Geodatabase Questions. 11-12-2025 11:05 AM
- Posted SQL database (2022) Collation for UN on Geodatabase Questions. 11-11-2025 09:11 AM
- Posted Panama Colon DEM on Comunidad Esri Colombia - Ecuador - Panamá Questions. 10-23-2025 12:25 PM
- Kudoed Re: show sum in cluster label for AndrewPadilla. 09-10-2025 04:29 PM
- Posted Re: Create an arcgis server folder with the python API? on ArcGIS API for Python Questions. 01-14-2025 08:38 AM
- Kudoed Re: Create an arcgis server folder with the python API? for Clubdebambos. 01-14-2025 08:38 AM
- Posted Re: Create folder in ArcGSI Server on ArcGIS REST APIs and Services Questions. 01-13-2025 05:44 PM
- Posted Create folder in ArcGSI Server on ArcGIS REST APIs and Services Questions. 01-13-2025 04:49 PM
- Posted Re: Create an arcgis server folder with the python API? on ArcGIS API for Python Questions. 01-13-2025 04:15 PM
- Posted Create an arcgis server folder with the python API? on ArcGIS API for Python Questions. 01-13-2025 02:49 PM
- Posted Re: Edit the hosts.etc file for WebGIS DR tool on High Availability and Disaster Recovery Questions. 12-12-2024 02:57 PM
- Posted Edit the hosts.etc file for WebGIS DR tool on High Availability and Disaster Recovery Questions. 12-11-2024 02:19 PM
- Posted Panama elevation and image data on 3D Mapping Questions. 12-05-2024 05:31 PM
- Posted Re: License Manager Options 11.3 for ArcGIS Pro on ArcGIS Enterprise Portal Questions. 10-08-2024 05:21 PM
- Posted Re: License Manager Options 11.3 for ArcGIS Pro on ArcGIS Enterprise Portal Questions. 10-08-2024 03:48 PM
- Got a Kudo for License Manager Options 11.3 for ArcGIS Pro. 10-06-2024 03:41 PM
- Posted License Manager Options 11.3 for ArcGIS Pro on ArcGIS Enterprise Portal Questions. 10-04-2024 05:39 PM
- Posted Re: Image service in 10.8 vs. 11.3 on ArcGIS Enterprise Questions. 08-29-2024 04:30 PM
- Posted Re: Image service in 10.8 vs. 11.3 on ArcGIS Enterprise Questions. 08-26-2024 11:58 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
11-12-2025
11:02 AM
|