Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JamesCrandall
JamesCrandall
MVP Alum
since
07-04-2014
01-22-2025
1965
Posts created
355
Kudos given
113
Solutions
305
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by JamesCrandall
|
POST
|
I will be processing this feature class in the in_memory workspace -- not sure if that sql will work there. Your pandas solution above will work great. This solution looks good too! But not sure if that ORDER BY clause will work outside of RDMBS sources.
... View more
08-04-2017
07:37 AM
|
0
|
4
|
3767
|
|
POST
|
I was able to get your suggestion to run. However, it only outputs 2 columns and not what the desired result in my OP.
... View more
08-04-2017
07:22 AM
|
0
|
2
|
3767
|
|
POST
|
0.10.0 To exacerbate the issue, user's are on a mix of Citrix and local installs of ArcGIS desktop! I've got a 10.4 install that has pandas 0.16.1 that will run the .loc and I'll see if your example works.
... View more
08-04-2017
07:15 AM
|
0
|
1
|
19339
|
|
POST
|
ArcGIS 10.3 Not sure what version of Pandas it is. Also: I updated main post with current code. I thought it was important to show how I'm getting the numpy array and pandas dataframe setup.
... View more
08-04-2017
06:53 AM
|
0
|
3
|
19340
|
|
POST
|
Thank you Joshua! However, I'm getting: AttributeError: 'DataFrame' object has no attribute 'loc'
... View more
08-04-2017
06:26 AM
|
0
|
5
|
19340
|
|
POST
|
I appreciate it Rebecca. I'm still not sure that will work for this implementation (or I'm just missing the obvious). At this point I'd be happy if someone could show me how to accomplish this manually with default gp tools in ArcGIS Desktop!
... View more
08-04-2017
05:51 AM
|
0
|
0
|
19340
|
|
POST
|
Edit: here's the current code I've got so far: itsct_nparr = arcpy.da.FeatureClassToNumPyArray(prItsct, ['FID_preproc','NAME','Shape_Area'])
#create a pandas DataFrame objects from the NumPy arrays
itsct_df = DataFrame(itsct_nparr, columns=['FID_preproc','NAME','Shape_Area'])
maxarea = itsct_df.groupby(['FID_preproc','NAME'], as_index=False).max()
maxarea.to_csv(csvout)
del itsct_nparr I need to come up with a solution that allows me to summarize an input table, performing a GroupBy on 2 columns ("FID_preproc" and "Shape_Area") and keep all of the fields in the original table in the output/result. From there I'll be joining that result with another table and calculating a field using the NAME column. From the example, I need to maintain the FID_preproc, and NAME fields (see the desired result). GroupBy on FID_preproc and MAX(Shape_Area). Any method is acceptable (numpy, pandas, summarize table, da.SearchCursor, etc.) -- whatever you have I can use! Input: FID_preproc NAME Shape_Area 1340 A 25952.35775 1341 A 118099.5219 1341 B 305220.1244 1342 A 12053.13585 Desired Result: FID_preproc NAME Shape_Area 1340 A 25952.35775 1341 B 305220.1244 1342 A 12053.13585
... View more
08-03-2017
02:04 PM
|
0
|
18
|
57370
|
|
POST
|
Oh I see what you are asking. Yeah, each developer has their own install of node.js running on their workstation, builds their WAB's and then we deploy out to IIS box.
... View more
07-21-2017
01:04 PM
|
0
|
1
|
595
|
|
POST
|
The "fix" is to update the \jimu.js\tokenUtils.js file Line 350 changes to: def = esriNS.id.getCredential(sharingUrl, { oAuthPopupConfirmation: false }); Line 382 changes to: popup: false,
... View more
07-21-2017
12:10 PM
|
1
|
6
|
1812
|
|
POST
|
In your config do you have your appID and cross origin params set? Yes and unknown. Yes, appId is set. Will check on the cross domain attribute -- that's not something we've ever looked at or had to consider in our workflow. Thanks!
... View more
07-20-2017
02:10 PM
|
0
|
1
|
1812
|
|
POST
|
Hi David! In an effort to eliminate that possibility from the equation, I removed all services from the web map! It's totally empty! I've got a ESRI support case working now -- I suspect it has to do with the fact that my AGOL account is an admin role and perhaps applying some extra level of security to any WAB that I build and deploy. Another developer here without that admin role does not get this secondary login challenge with his WAB deployments. Good to hear from you! Take care.
... View more
07-20-2017
01:01 PM
|
0
|
3
|
1812
|
|
POST
|
A colleague imported the app into his WAB Developer, saved it out and deployed it on the same IIS box (different url), it does not have this behavior. Something is wrong with my install of WAB Developer I suppose.
... View more
07-19-2017
05:55 AM
|
0
|
5
|
1812
|
|
POST
|
As a test, I only have the LayersList and Legend widgets in the deployed application. I've also removed all layers/map services from the source web map. I still receive the error above! Any idea what is causing this permissions issue? Also, I've been told that the IIS has .woff, .woff2 and .svg mime types added but I'm not sure if there is a proxy issue. I've been attempting to simply add these references in the web.config but unsure if they have any affect: <?xml version="1.0" encoding="utf-8"?> <configuration> <system.webServer> <staticContent> <!-- Configure site to serve JSON files --> <remove fileExtension=".json" /> <mimeMap fileExtension=".json" mimeType="application/json" /> <!-- Configure site to serve font files --> <remove fileExtension=".otf" /> <mimeMap fileExtension=".otf" mimeType="font/otf" /> <!--more font files --> <remove fileExtension=".svg" /> <mimeMap fileExtension=".svg" mimeType="image/svg+xml" /> <remove fileExtension=".woff" /> <mimeMap fileExtension=".woff" mimeType="application/font-woff" /> <remove fileExtension=".woff2" /> <mimeMap fileExtension=".woff2" mimeType="application/font-woff2" /> </staticContent> </system.webServer> </configuration>
... View more
07-18-2017
06:13 AM
|
0
|
0
|
1812
|
|
POST
|
On loading of WAB app created in WAB Developer 2.3 I am getting a error. How would I track down the source of this? This only occurs when Layers List widget is included. All layers in the source web map are set to public share.
... View more
07-17-2017
01:28 PM
|
0
|
14
|
2653
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 02-17-2020 10:47 AM | |
| 1 | 10-25-2022 11:46 AM | |
| 1 | 08-08-2022 01:40 PM | |
| 1 | 02-15-2019 08:21 AM | |
| 2 | 08-14-2023 07:14 AM |
Activity Feed
- Got a Kudo for Re: Proper REST query for epoch. 04-25-2025 07:57 AM
- Got a Kudo for iterate hosted (AGOL) table attributes. 10-18-2024 08:16 AM
- Posted Re: cx_oracle for py 3.x? on Python Questions. 05-28-2024 01:20 PM
- Kudoed Re: cx_oracle for py 3.x? for BlakeTerhune. 05-28-2024 01:19 PM
- Posted cx_oracle for py 3.x? on Python Questions. 05-28-2024 11:54 AM
- Posted Re: Input geometry point spatial query on ArcGIS REST APIs and Services Questions. 03-27-2024 06:12 AM
- Posted Input geometry point spatial query on ArcGIS REST APIs and Services Questions. 03-26-2024 02:15 PM
- Got a Kudo for Re: How to determine number of records using arcpy.da.SearchCursor. 03-06-2024 10:36 AM
- Posted Re: sdf spatial reference is empty [] on ArcGIS API for Python Questions. 02-16-2024 11:46 AM
- Posted sdf spatial reference is empty [] on ArcGIS API for Python Questions. 02-16-2024 11:23 AM
- Posted Re: Deployed ExB duplicating folder index on ArcGIS Experience Builder Questions. 01-05-2024 09:14 AM
- Kudoed Re: Deployed ExB duplicating folder index for DavidColey. 01-05-2024 09:10 AM
- Posted Deployed ExB duplicating folder index on ArcGIS Experience Builder Questions. 01-05-2024 08:03 AM
- Kudoed Re: Best way to authenticate? for CodyPatterson. 11-09-2023 09:22 AM
- Posted Re: Best way to authenticate? on ArcGIS REST APIs and Services Questions. 11-09-2023 09:16 AM
- Posted Re: Export to KML Widget on Web AppBuilder Custom Widgets Questions. 09-25-2023 07:00 AM
- Got a Kudo for Re: Export to KML Widget. 09-11-2023 09:24 AM
- Got a Kudo for Re: Security model approaches. 08-29-2023 02:45 AM
- Got a Kudo for Re: Python API to update attributes on feature layer. 08-14-2023 11:23 AM
- Got a Kudo for Re: Python API to update attributes on feature layer. 08-14-2023 09:51 AM
User Groups for JamesCrandall
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
01-22-2025
02:28 PM
|