Latest Contributions by forestknutsen1

‎03-13-2023

yes, it has a spatial index yes, we are versioned and no we never get back a low state count and we do have a large number of delta rows. So this could be the issue. (and yes we know this is a problem... I will spare you the details) I will give disjoint a try Thanks for the feedback

‎03-10-2023

I would like to do a spatial join between points and polygons with st_geometry this is what I have come up with: select sp.OBJECTID, p.parcel_num from servicepoint_evw sp join parcels p on (sde.st_intersects(sp.shape, p.shape)) = 1 This does appear to work but it is supper slow... I took over a minute to return one row.

‎03-01-2023

@TonyContreras_Frisco_TX Thanks! That works. Any idea how I get it to last longer then two weeks?

‎03-01-2023

Thanks for the feedback. Is there not a way to get it from the Portal Admin Site.

‎02-28-2023

We have an OMS (outage management system), Pragma, that we want to consume secure Esri services. They have a URL with a token on the end in their config file. They application will then use this token for each call the to the Esri service. So, the URL would look something like : "https://our-server/server/rest/services/Testing/OMS/MapServer/tile/{0}/{2}/{1}/256/png8?token=" How do I go about creating this token?

‎01-17-2023

I want to have a relationship between two point feature classes. I would like the destination feature to be deleted if the parent is deleted. But I don't want the geometry of the destination to move if the parent is moved. I tried a with a composite relationship with notification forward (origin to destination). This works for the delete but it also updates the geometry.

‎01-10-2023

I too am having a hard time wrapping my head around your question. It is not clear to me what is needed....

‎01-05-2023

Can you just have the user run the bat file from there desktops? Is the FME workspace and environment going to be on a server?

‎01-04-2023

Thanks! Everything is setup with TNSNAMES.

‎01-04-2023

Okay, thanks. But in this case just the Oracle version will be changing not the version of ArcGIS.

‎01-04-2023

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()

‎01-03-2023

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

‎12-05-2022

@jcarlson thanks! that did the trick

‎10-27-2022

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}'

‎10-26-2022

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'

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by forestknutsen1

Re: Spatial Join with st_geometry

Spatial Join with st_geometry

Re: Token for URL

Re: Token for URL

Token for URL

composite relationship

Re: Create buffer and transform polygone to line feature via Python script

Re: Can you run a BAT (Batch) file using ArcPy?

Re: Oracle 19 upgrade and old connection files

Re: Oracle 19 upgrade and old connection files

Re: Can you run a BAT (Batch) file using ArcPy?

Oracle 19 upgrade and old connection files

Re: Export/import web map's json

Re: Select all annotation classes with sql in an Oracle SDE

Select all annotation classes with sql in an Oracle SDE

Field map alternatives for windows 11

Add routing service to json for JS app

limit zoom levels in dashboard

Select all annotation classes with sql in an Oracl...

kill the extra vertices in a polygon FC