Latest Contributions by DougGreen

‎01-10-2023

Oh that's a good question. The "Split a Feature" functionality is an active-editing, interactive tool where you specify the location at which you want to split the feature. This means it isn't available as a python Geoprocessing operation but I could see a way to perform geometric functions (read and write) to perform the task. However, there's also a geoprocessing tool called "Split" that chops up a set of features using another set of features. This can be run in python using parameters. I imagine you're talking about the first one though?

‎01-10-2023

I've done a similar thing using ephemeris data tables to find which cities received more sunlight during daytime hours and how time zones and daylight savings affected it. There are tables that can be generated using this software. You'll then have to parse the data and convert it to point and then line data for your purposes. Python will be your friend ;). I don't know of existing ephemeris data in GIS format but that doesn't mean it doesn't exist.

‎01-09-2023

I suspect it's due to an incorrect Spatial Reference or the lat/lon being swapped? (Lat = Y, Lon=X). If you are using WGS84 lat lon, the WKID is 4326. This snippet section leads through setting up a spatial reference and constructing a geometry.

‎01-06-2023

Design an interface that allows the user to specify a file or paste text that contains the list of points. Create a new feature class Edit the feature class, looping through each point and adding them. I'd spend some time in the documentation as well as check out this existing post that explains a similar request.

‎01-06-2023

It shouldn't as part of regular updating. That's by design. If it did, they would have to repoint all their maps everytime they update the layer. This can change but it's usually due to a redesign of the layer but I wouldn't expect that to happen. You could check the REST API to see if there's some property that could expose last update. But I'll tell you that most of my layers merely get "edits" performed which would not change the "LastUpdated" property if there is one.

‎01-05-2023

I don't know of a way to determine the most recent update but that doesn't mean there isn't a way. If individual data records were added, deleted or changed, and they store updated dates in the field values, you could loop through the field values to check for any dates newer than the last update time.

‎01-05-2023

It sounds like you want to specifically check if a map is open as a View and then work with it if it is open and if it is not open, you want to open it and then specifically add layers to a certain map correct? There's a post here where it indicates that there's not a way to tell if a map is open in a view and an ESRI employee suggests that it would be good to submit an idea that exposes that property of a map. However, despite knowing whether or not the view is open, explicitly getting a reference to each map using the aprx object that you want to interact with is totally possible and might meet your need. aprx = arcpy.mp.ArcGISProject("CURRENT") map1 = aprx.listMaps("my first map") if map1 == None: print("Could not find map: my first map") # end or raise error here map2 = aprx.listMaps("my second map") if map2 == None: print("Could not find map: my second map") # end or raise error here Each map object could then be used to add layers as you wish.

‎01-04-2023

Yes, I would recommend running these tools through a python script. You can also call OGR2OGR through python using "subprocess" as described here.

‎01-03-2023

Do you have ESRI Desktop Software? If so, you can use the Feature Class to Feature Class tool to convert the data from the feature service to a shapefile first. Then you can use OGR2OGR to convert it to GeoJSON and then add it to your Postgres Database possibly.

‎01-03-2023

Yes there is. The ArcGIS Online Assistant has tools to do this as well as view and modify JSON. Hope that helps.

‎01-03-2023

You might also use the Divide a Polyline functionality to chop up your line into 1 m chunks and then generate points at each midpoint along that line. Or you could use the Generate Points Along Lines tool which would be faster. You could then extract values to points from the DEM and then the attribute table of your point layer would be your table.

‎01-03-2023

I don't think it's saying that STATE_ID is the column that's missing. The error message you posted says "no such column: CatTotal." So is the CatTotal column missing or did it's column name change by chance?

‎01-03-2023

@JohannesLindner, good to hear that it's of value to someone else. I am able to do quite a bit with SQL. However, I think this enables similar things in the web that we cannot currently do. It might be good, however to move away from doing some of the things I've been doing in SQL considering that ESRI is now storing complex geometries such as arcs and multipatch in a separate column called gdb_geomattr_data which makes SQL query layers a bit more cumbersome as the SHAPE column may only contain a simplified version of the actual feature. So having Arcade Layers in Pro and the Web would be beneficial.

‎12-14-2022

In Desktop software, we have the Make Query Layer tool that allows us to perform all sorts dynamic joining and filtering of Geodatabase data to visualize data from multiple feature classes or tables without having to duplicate the data storage. I would find it incredibly handy to have the same capability within web maps using Arcade FeatureSets. If we can define a FeatureSet in popups and label expressions and use them to dynamically access data from multiple layers, could we take it one more step and add functionality to give a map creator the option to say "Add Arcade Layer"? I'm thinking there would need to be requirements that only one spatial field be included in the output and that all the geometries in the final spatial field have consistent coordinate systems etc. But I can see great benefit in being able to add a layer to a map that (for example) combines features from multiple point feature service layers that all have a common status that needs attention so that they could be shown as a single layer in a web map. I can think of many other scenarios that would be useful here too and I would say that there's justification for it because of all the same reasons the "Make Query Layer" tool exists.

‎11-29-2022

@davidchamberlain2, there are some other things I would check in your situation. Projections Do all of the layers in the map have the same projection? If not, when rendering many features in an export, this can cause slower-than-normal export times Using ESRI Basemaps in Web Mercator underneath local data in a local projection is a common cause of this especially when you change the map to be in the local projection. Drawing the basemaps in anything other than their Web Mercator projection really slows things down. Complex label classes When there are many label classes on layers with tens of thousands of features, I've seen this cause really slow draw times. Joins and Relates If any of your layers have joined or related data that are using unindexed fields for the join fields, this can definitely cause some slow export times. SDE Database tuning Rebuild Indexes and statistics (SQL Server) or equivalent in other DBMS Checking all these is bound to give you some improvement.

Online Status	Offline
Date Last Visited	‎04-09-2026 08:22 AM

My Ideas

Latest Contributions by DougGreen

Re: ArcGIS Pro - Modify Features - Python

Re: Lunar Zenith Path

Re: How to add a new layer and add points to it?

Re: How to add a new layer and add points to it?

Re: extract or scrap the data from an arc online Feature Service to a Postgres database

Re: extract or scrap the data from an arc online Feature Service to a Postgres database

Re: How to switch the active map in ArcGIS Pro project

Re: extract or scrap the data from an arc online Feature Service to a Postgres database

Re: extract or scrap the data from an arc online Feature Service to a Postgres database

Re: Repair data source in web map / web app

Re: combining a line with a DEM to create an elevation profile

Re: Displat XY darta versus XY Table to point

Re: Add Arcade FeatureSet as Layer to Map

Add Arcade FeatureSet as Layer to Map

Re: Printing to PDF/Export to PDF taking an age to complete

Re: Solving SSL Errors in Python Requests

Change Default Behavior of Opening Map Package

Re: Add a layer to a hosted feature layer

Re: How to Associate Documents with Polygon Featur...

Re: Add a layer to a hosted feature layer