Latest Contributions by simoxu

‎04-30-2023

ArcGIS Server feature layers are similar to hosted feature layers with the following differences: • The data is not copied into a system-maintained data store; it stays in the data source you registered with the ArcGIS Server site. • When you delete the ArcGIS Server feature layer, the data is not deleted. • Much of the configuration for ArcGIS Server feature layers is performed in ArcGIS Server Manager, not the portal. • Functionality available in the portal is different for ArcGIS Server feature layers than for hosted feature layers. Please see the official document for details: https://enterprise.arcgis.com/en/portal/latest/use/feature-layers.htm

‎03-25-2023

The following thread has a similar question with a good answer: https://community.esri.com/t5/arcgis-enterprise-questions/do-hosted-feature-layers-consume-arcgis-server/m-p/1241421#M34810

‎09-27-2022

To get the geometry, In your query to ArcGIS online / Enterprise endpoint, you need to set the specific parameter returnGeometry to true.

‎09-27-2022

Yes it is basically pulling in the JSON result of your REST query. In the PBI query Editor, put something like the following for the source and followed with some data transformation steps: =Json.Document(Web.Contents("ArcGIS Rest Query here")) The ESRIJSON part will be a little tricky to deal with, but it's doable. To avoid the license issue for the viewers, your content needs to be shared with everyone in AGOL or Enterprise.

‎09-22-2022

Hi Tyler Please see if the example 4 in the following document helps. Summary Statistics (Analysis)—ArcGIS Pro | Documentation I tried to use the following code to read a layer in ArcGIS Pro, and it also works: sedf_from_FL = pd.DataFrame.spatial.from_featureclass("your layer name") Cheers, Simo

‎05-17-2022

When will this feature be released roughly? it will make jupyter notebook in ArcGIS Pro more useful for data analysis.

‎04-07-2022

I am trying do an service area analysis for the dots in the map with polygon barriers as shown above. but the barriers are ignored for the area analysis. same polygon barriers work for the routing analysis. but it works for the service area analysis in ArcMap 10.8 ! I know the facilities and the polygons are different, they are from the same data source, only different selection of points and polygons. Is it a bug for ArcGIS Pro? I am using ArcGIS Pro 1.9.2.

‎02-22-2022

Hi, what's the link for the merged idea? I'll give it my vote. I was caught up by this when I was running a large model which runs for nearly 24 hours, it is really annoying that I could not stop it after the progress window disappeared..

‎11-26-2021

Great news to know this is going to be fixed in the new release. I look forward to the new version. Is upgrading MS PowerBI itself is the only way to upgrade ArcGIS for PowerBI? or it can be upgraded seperately? Thanks.

‎09-23-2021

update: It turns out deploying the SDE database in the cloud is only one of the causes. The biggest cause is: The Text columns is extremely long (>1 billion), this is a result of creating these layers at the backend using SQL directly, and ArcGIS translates the nVarchar(MAX) to Text (length: 1073741822 ). I created a new featureclass based on one of the original layers but with limited length for the Text columns, then loaded original layer data into it. The performance of this new featureclass is far better, I can copy the whole layer in less than 1 minute instead of 4 hours. A useful link: https://community.esri.com/t5/data-management-questions/text-data-type-and-length-size-problem/td-p/257295 Hope this is useful for others.

‎09-07-2021

Thanks George. We may have to move back to on-prem spatial database, since we need to use the Pro on the desktop machines.

‎09-06-2021

Just called the ICT department, and was told the VM is actaully on-prem! that partially explains it.

‎09-06-2021

Hi George, The ArcGIS Pro is on my desktop. Today I also tested on a VM which I am not sure if it is in the same region as the DB. The strange thing is, it was using lots of network bandwidth (>5MPS ) , and for 3 hours it only copied 13K records out of 180K records of a POINT featureclass. This only happens when I copy and paste featureclass in ArcGIS. If I directly copy the featureclass table (using SQL or pyodbc+Python), it will only take minutes. I just don't understand what it was doing with 5MPS bandwidth for 3 hours... Thanks, Simo

‎09-02-2021

Hi, I am trying to copy / export about 180K records from a freatureclass in Azure SQL Geodatabase to a local FGDB, It only exports a very small amount of records before ArcGIS Pro becomes dead after hours. In my geodatabase config table, the settinig is already ATTRBUFSIZE = 1000000 (1 million), my SDE schema version is 10.8.1 According to ESRI support article, you have to intall ArcGIS Pro in Azure vm to use Azure enterprise geodatabase... https://community.esri.com/t5/geodatabase-questions/move-egdb-to-azure-cloud/m-p/1072113 I am confused... if you could give some advice, that would be great. Thanks

‎09-02-2021

We recently moved our geodatabase into MS SQL Server in Azure, and we are experiencing strange issues. I am trying to export a large featureclass into an FGDB in ArcGIS Pro, which is installed on the desktop machine, it will take many hours and only export a small amount of records. (2900 of 180,000 records of the featureclass) If the featureclass is not that big, let’s say only hundreds of records, it can be exported very quickly. After monitoring the SQL Server in Azure, the DB guy told me there were some small activities, but nothing major to stress the server. On my client machine, I can see lots of network activities, but the progress bar barely move. I tried to use ArcGIS Python API to load data from featureclass, the script will hang. Never experience this issue before on the on-prem SQL Server. If anyone can share some experience here, that would be much appreciated.

Online Status	Offline
Date Last Visited	‎01-17-2025 07:39 AM

My Ideas

Latest Contributions by simoxu

Re: Difference between Feature Service and Hosted Feature Layer?

Re: Understanding Hosted Service Performance

Re: Shape in Geojson

Re: Can PowerBI display on a map from a ArcGIS REST endpoint?

Re: Allow ArcPy Geoprocessing Tools to output to Spatially Enabled DataFrame (SEDF)

Re: Add support for Pandas Dataframes to arcpy

Polygon barriers not working for service area analysis

Re: Button to re-open model progression pop-up or ribbon model terminate button

Re: ArcGIS for power bi not saving symbology

Re: Exporting data from ArcGIS Enterprise geodatabase on MS Azure SQL Server

Re: Exporting data from ArcGIS Enterprise geodatabase on MS Azure SQL Server

Re: Exporting data from ArcGIS Enterprise geodatabase on MS Azure SQL Server

Re: Exporting data from ArcGIS Enterprise geodatabase on MS Azure SQL Server

Re: Azure SQL SDE fetch_buffer_size

Exporting data from ArcGIS Enterprise geodatabase on MS Azure SQL Server

Re: Error while authenticating when displaying map

Error while authenticating when displaying map

Re: Error while authenticating when displaying map

Re: Error while authenticating when displaying map

Re: Primary and Secondary Maintenance

Web AppBuilder Custom Widgets