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
|
I am not sure I understand what you are after... I am guessing that by section you are talking about a PLSS section? Then one monuments (are they points or polygons) could be one or more sections? But they should all be in one feature (row) in the feature class? Or is it that the section geometry is poor so the section polygons overlap each other?
... View more
06-01-2018
10:06 AM
|
0
|
0
|
1422
|
|
POST
|
Jonathan Quinn wrote: 1) Storing passwords in plain-text on disk is never a good idea 2) Saving the password in the connection file and moving the connection file into a location that only authorized users can access is a good idea 3) Not saving the password in the connection file and requiring users to enter the password can help make sure even if someone does access the connection file, they can't open the database. This doesn't work with batch/automated jobs 4) Using OS authentication, (Connect to Oracle from ArcGIS—Help | ArcGIS Desktop, Authenticating Database Users with Windows), is a good solution as the credentials are pulled from the user running the process connecting through the connection file, (ArcMap, scheduled task through a batch file, ArcGIS Server). 1) Yep, I could not agree more... I think our system needs to change. 2) This is how we did in my last job that had an enterprise GIS system. I have only been in my new role for a few months. I am no security expert, so when I saw this GIS batch job setup I thought I was potentiality missing some flaw in the arcgis DBA connection file model. 3) We have this setup for every day admin tasks. 4) Everyone, save GIS admins, use OSA only. Thanks for the input. I am going to suggest a change to the team...
... View more
05-25-2018
02:46 PM
|
0
|
0
|
5018
|
|
POST
|
Thanks for the feedback. I did try and open it up with notepad++ and got garbage. I am wondering because the organization that I work for has a lot of the DB power user passwords in a python dictionary as part of our local python package. Then concretions are made with code for our batch jobs using this python module. It feels week to me because any machine that has the module installed has the password deep in the python installation, if someone thought to look there or just bummed into it very bad things could happen. If the esri connection files are safe I would think a better model would be to place the power user DB connections in a folder and limit access to it. Is this how most organization do it?
... View more
05-25-2018
12:33 PM
|
0
|
3
|
5018
|
|
POST
|
I am wondering about the password security in database authenticated connections files (e.g. connection.sde) when the password is saved in the connection file. Are the passwords encrypted in the connection file? In other words would it be possible for a users on the system to extract the password for a database user (like sde!) from a connection file? Not that we have sde user connections sitting around for the average user to stumble across but you get the idea...
... View more
05-25-2018
10:57 AM
|
0
|
5
|
5456
|
|
POST
|
broken_lyr.replaceDataSource(workspace_path, workspace_type, dataset_name, True You could try to set this validation to false. I have had some weird behavior around this and sde datasouces in the past.
... View more
05-25-2018
10:38 AM
|
0
|
1
|
3806
|
|
POST
|
The sql I tested for updating the vw tables. Just in case it helps anyone else in the future. But it has some risk with it. For my first time it was helpful to read this: https://sspinnovations.com/blog/versioning-dummies-part-4-esri-multiversion-views/ and this:What is a versioned view?—Help | ArcGIS Desktop call sde.version_util.set_current_version ('ARCFM8.vtest');
call sde.version_user_ddl.edit_version ('ARCFM8.vtest', 1);
update arcfm8.t_conductormarker_vw set REFERENCEDRAWING = 'test'
where OBJECTID = 3;
commit;
call sde.version_user_ddl.edit_version ('ARCFM8.vtest', 2);
... View more
05-03-2018
04:55 PM
|
1
|
0
|
3610
|
|
POST
|
This sql works fine from pl/sql developer but fails when I try and do it with cx_Oracle. Working fine.... call sde.version_util.set_current_version ('ARCFM8.vtest');
call sde.version_user_ddl.edit_version ('ARCFM8.vtest', 1);
update arcfm8.table_vw set REFERENCEDRAWING = 'my multiversion view update!!'
where OBJECTID = 3;
commit;
call sde.version_user_ddl.edit_version ('ARCFM8.vtest', 2); Failing on line 3... with cx_Oracle.connect("arcfm8/xxxx@xxxx") as connection:
cursor = connection.cursor()
cursor.callproc("sde.version_util.set_current_version", ('ARCFM8.vtest'))
cursor.callproc("sde.version_user_ddl.edit_version", ('ARCFM8.vtest', 1))
cursor.execute(
"update arcfm8.table_vw set REFERENCEDRAWING = 'my SECOND multiversion view update!!!' where OBJECTID = 3")
cursor.callproc("sde.version_user_ddl.edit_version", ('ARCFM8.vtest', 2)) cx_Oracle.DatabaseError: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SET_CURRENT_VERSION' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
... View more
05-02-2018
06:05 PM
|
0
|
3
|
2161
|
|
POST
|
My solution: ListSubtypes—Data Access module | ArcGIS Desktop Assign Domain To Field—Data Management toolbox | ArcGIS Desktop import arcpy
sde_path = r"xxxx"
arcpy.env.workspace = sde_path
domain = "T_LineSegment"
domain_feature_classes = {"feature_class": "domain_field", ....}
for feature, domain_field in domain_feature_classes.items():
print "updating domains by subtype on " + feature
subtypes = arcpy.da.ListSubtypes(feature)
for k, v in subtypes.items():
print "\tsetting domain for subtype code: " + str(k)
arcpy.AssignDomainToField_management(feature, domain_field, domain, k)
... View more
04-27-2018
12:35 PM
|
2
|
1
|
3119
|
|
POST
|
No we are still on desktop. But I did judge your last post to fast. It is part of the solution I think for sure. I was just being foolish. I am testing now...
... View more
04-27-2018
12:15 PM
|
0
|
0
|
3119
|
|
POST
|
Sadly the field calculator also failed... and the old style update cursor (before da) also failed... so all that remains is doing it by hand or using the vw tables...
... View more
04-26-2018
03:50 PM
|
0
|
0
|
3610
|
|
POST
|
oh... I did not know it was ending so soon... part of the problem is we are dependent on ArcFM8... So, we are trying to get to ArcFM8 10.2.1d...
... View more
04-26-2018
12:59 PM
|
0
|
0
|
3610
|
|
POST
|
I don't see anything in them that will let me set the domain on a field by subtype... unless I am missing something...
... View more
04-26-2018
11:46 AM
|
0
|
0
|
3119
|
|
POST
|
Is there a way to change the domains on a feature class that has sybtypes with arcpy?
... View more
04-26-2018
10:20 AM
|
0
|
6
|
3393
|
|
POST
|
Joshua, thanks for taking the time to reply. At least I know now that my approach is sound in general. I am thinking about the below options: trying a join and a field calculator with arcpy using cx_oracle with sql and update the versioned view tables using stand alone sql to update the versioned view tables On a side note we are trying (desperately) to get 10.2 so we at least will be back into a esri supported version. But we have massive corruption in are sde versions states. Which is causing no end of pain...
... View more
04-26-2018
09:56 AM
|
0
|
2
|
3610
|
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
|