Latest Contributions by AllenGuan2

‎02-01-2019

OMG, I found the tables/views that I created in the last few years in SQL Developer that do not show up in Catalog all start with "SDE_". If I create a table/view not in starting with "SDE_", it will show up in Catalog. I think ESRI did this to hide all the SDE system tables in Catalog, but mistakenly doing this hide globally across the data schemas, unless the "SDE_" objects are created inside Catalog and registered with SDE.

‎02-01-2019

OMG, I found the tables/views that I created in the last few years in SQL Developer that do not show up in Catalog all start with "SDE_". If I create a table/view not in starting with "SDE_", it will show up in Catalog. I think ESRI did this to hide all the SDE system tables in Catalog, but mistakenly doing this hide globally across the data schemas, unless the "SDE_" objects are created inside Catalog and registered with SDE.

‎02-01-2019

Really puzzled on this one. I ran into this strange issue with both ArcSDE 10.3.1/Oracle 12.1.0.1 and ArcSDE 10.5.1/Oracle 12.1.0.2 recently. We have been in 10.3.1 for 2 years now. I have created a lot of non-spatial in SQL Developer and never register them with SDE. This week, I found ArcCatalog (10.3.1 and 10.5.1) shows only some of them, but not most of them. I create a new one in different schemas using SQL Developer, it does not show up in any of them in Catalog. I added the objectid column in SQL Developer, the table still not show in Catalog. But when I add shape "SHAPE SDE.ST_GEOMETRY" column, it will show up in Catalog. I tried using the Catalog tool "Create unregistered table" to create an empty table. The table is shown with "OBJECTID" in SQL Developer, but not show up in the Catalog. If I use the "Create table" tool, the table shows up in Catalog. Look like using "Create table" tool to create the table and using "Add Field" is the only way to make the table appear in Catalog. But why it does show some of the tables created in the same way in the past, but not all of them? I don't want the table to have objectid column.

‎02-01-2019

I run into the same issue with ArcSDE 10.3.1 recently. We have been in 10.3.1 for 3 years now. I have created a lot of non-spatial in SQL Developer and never register them with SDE. This week, I found this week ArcCatalog (10.3.1 and 10.5.1) shows only some of them, most of them do not appear. I create a new one in different schemas, it does not show up in any of them. I tried to add objectid column in SQL Developer, the table still not show in Catalog. But when I add shape "SHAPE SDE.ST_GEOMETRY" column, it will show up in Catalog. I tried using the Catalog tool "Create unregistered table" to create an empty table. The table is shown with "OBJECTID" in SQL Developer, but not show up in the Catalog. If I use the "Create table" tool, the table shows up in Catalog. Look like using "Create table" tool to create the table and using "Add Field" is the only way to make the table appear in Catalog. But why it does show some of the tables created in the same way in the past, but not all of them?

‎12-13-2018

Not recreate the view, but redrag the view into ArcMap to recalculate the extent. Better to specify a larger extent than using the default calculation.

‎12-13-2018

Not sure about the rational behind recreating the views. I am testing this in ArcSDE 10.5.1 where spatial views are registered with SDE. Got a feeling this issue would not occur in 10.5.1. ESRI made a big mistake when dropping SDE view support in 10.2 and 10.3, and glad it came back in 10.5.1.

‎12-12-2018

All records are valid. The count difference between ArcMap and ArcCatalog is small, usually 1 - 3 missing in ArcMap. When a spatial view is dragged into ArcMap, it asks for selecting an unique field, which is usually objectid, then it calculates the initial extent and add the data to the map. Seems to me the missing ones are the new features that fall outside the initial extent.

‎12-12-2018

David: Yes, found out my ArcGIS Pro license became unregistered. After re-registering, it works now. Many thanks.

‎12-12-2018

One is registered as archived, the other one is not, and both cases we only look at the Default version.

‎12-12-2018

I have been running the following python API in jupyter notebook to access our company AGOL for a while. But it breaks in the last few days. I heard ESRI is changing the authentication model, could this be related or the API call is outdated this week? It worked last week. from arcgis.gis import GIS gis = GIS(url="https://bhp.maps.arcgis.com/home", username='myadminaccount',password='myadminpassword',proxy_host='....', proxy_port='8081') The errors are below: C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\__init__.py in <module>() 1 __version__ = '1.4.1' 2 ----> 3 from . import features, geoanalytics, geocoding, geometry, geoprocessing, network, raster, realtime, schematics, mapping, apps 4 5 from .gis import GIS C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\features\__init__.py in <module>() 19 """ 20 ---> 21 from .feature import Feature, FeatureSet, FeatureCollection 22 from .layer import FeatureLayer, Table, FeatureLayerCollection 23 from ._data.geodataset import SpatialDataFrame C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\features\feature.py in <module>() 13 from arcgis._impl.common._spatial import json_to_featureclass 14 from arcgis._impl.common._utils import _date_handler---> 15 from arcgis.geometry import BaseGeometry, Point, MultiPoint, Polyline, Polygon, Geometry, SpatialReference 16 from arcgis.gis import Layer 17 C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\geometry\__init__.py in <module>() 62 """ 63 ---> 64 from ._types import * 65 from .functions import * 66 from . import filters C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\arcgis\geometry\_types.py in <module>() 7 from six import add_metaclass 8 try:----> 9 import arcpy 10 HASARCPY = True 11 except ImportError:C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\__init__.py in <module>() 70 import _initagsenv 71 ---> 72 from arcpy.geoprocessing import gp 73 from arcpy.geoprocessing import env 74 from arcpy.geoprocessing._base import gptooldoc as _gptooldoc C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\__init__.py in <module>() 12 # 13 #email: contracts@esri.com---> 14 from ._base import *C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py in <module>() 12 # 13 #email: contracts@esri.com---> 14 import arcgisscripting 15 import functools 16 RuntimeError: Not signed into Portal.

‎12-12-2018

We have been at ArcSDE 10.3.1/Oracle 12c for almost 2 years and have a lot of spatial views. Recently we found a few spatial views in existing ArcMap files do not match ArcCatalog (verified in both ArcGIS Desktop 10.3.1 and 10.5.1) in feature count, and we have to drag the spatial views from ArcCatalog into ArcMap to validate the count. Anybody knows why? This behavior really looks like a bug to me.

‎07-23-2018

yes, thanks.

‎07-23-2018

yes, verified created sort is correct. Why not make lastlogin sortable? It is more useful than created.

‎07-20-2018

But I thought my path setting should have taken care of it.

‎07-20-2018

Here is the code. I would think the results will be ordered in desc by lastlogin_str column, but they are not. import pandas as pd import time tbl = [] users = gis.users.search("*",sort_field="lastLogin",sort_order="desc",max_users=500) for user in users: grps = "" for grp in user.groups: try: grps += grp.title + "," except: print("\n") grps = grps[:-1] created_str = time.strftime('%Y-%m-%d', time.gmtime(user.created/1000.0)) modified_str = time.strftime('%Y-%m-%d', time.gmtime(user.modified/1000.0)) lastlogin_str = time.strftime('%Y-%m-%d', time.gmtime(user.lastLogin/1000.0)) num_items = 0 #root items #print("Items under root:") for item in user.items(): #print("\t" + item.title + " - " + item.type) num_items += 1 # folder items for folder in user.folders: #print("Items under " + folder['title'] + ":") for item in user.items(folder=folder['title']): #print("\t" + item.title + " - " + item.type) num_items += 1 tbl.append([user.username,user.fullName,user.role,user.level,user.email,created_str,modified_str,lastlogin_str,grps,str(num_items),str(user.disabled),user.idpUsername,user.userType,user.assignedCredits,user.availableCredits]) #print(user.username + "\t" + str(user.role) + "\t" + created + "\t" + lastlogin + "\t" + grps) columns_all = ['User','fullName','Role','Level','Email','Created','lastModified','lastLogin','Groups','Items','Disabled','idpUsername','userType','assignedCredits','availableCredits'] df = pd.DataFrame(data = tbl,columns = columns_all) columns_show = columns_all df[columns_show]

Online Status	Offline
Date Last Visited	‎05-04-2023 02:03 PM

My Ideas

Latest Contributions by AllenGuan2

Re: Can't See All Oracle Tables in ArcCatolog

Re: ArcCatalog does not show all non-spatial Oracle tables not registered with SDE

ArcCatalog does not show all non-spatial Oracle tables not registered with SDE

Re: Can't See All Oracle Tables in ArcCatolog

Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog

Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog

Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog

Re: Python API unable to connect to AGOL

Re: ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog

Python API unable to connect to AGOL

ArcSDE Spatial view feature count in ArcMap do not match ArcCatalog

Re: How to query and sort on ArcGIS Portal users based on date?

Re: How to query and sort on ArcGIS Portal users based on date?

Re: How to make python calls to arcgis.gis and pandas work outside jupyter?

Re: How to query and sort on ArcGIS Portal users based on date?

Re: Can't See All Oracle Tables in ArcCatolog

Re: ArcSDE Spatial view feature count in ArcMap do...