Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JoshuaBixby
JoshuaBixby
MVP Esteemed Contributor
since
07-04-2014
Online
5436
Posts created
1264
Kudos given
521
Solutions
4407
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(16 Idea Submissions)Latest Contributions by JoshuaBixby
|
POST
|
Honestly, I have no idea what the question is for this post, or are you just sharing a story about working with a consultant?
... View more
03-24-2024
08:50 AM
|
0
|
0
|
218
|
|
POST
|
There are several tools available for moving data around, maybe give Export Features (Conversion)—ArcGIS Pro | Documentation a try.
... View more
03-21-2024
07:46 AM
|
0
|
1
|
297
|
|
POST
|
Not to get hung up on semantics, but the title and description say "Search Cursor" but the code says "UpdateCursor". I assume the code is correct?
... View more
03-20-2024
04:06 PM
|
2
|
1
|
212
|
|
POST
|
The major issue you are having is that arcpy.ListFields returns just that, fields or field objects, and not field names. var = [field.name for field in arcpy.ListFields('df')]
... View more
03-20-2024
07:03 AM
|
1
|
1
|
219
|
|
POST
|
I updated the code in my original post, try it out and let me know.
... View more
03-19-2024
11:49 AM
|
1
|
0
|
46
|
|
POST
|
If you want to run a cursor against the selected records then pass itemsToRetire to the cursor since it is a table view or layer (depends on data source) that has the records selected.
... View more
03-19-2024
07:01 AM
|
0
|
0
|
166
|
|
POST
|
When you say "it fails to access the services," what exactly is happening? Giving specific error types and codes is helpful.
... View more
03-18-2024
06:37 AM
|
0
|
0
|
250
|
|
POST
|
It is best to keep a post to a single question because asking multiple questions in the same post tends to make the comments a mess when some people will reply to one question, some to the other, and some to both. These two questions are closely related enough one could argue it is just one question, but please keep this in mind for future questions. Regarding your first question of Get Count, it is expected behavior. As its name states, Select Layer By Attribute works on layers, not data sets. Somewhere back a few years ago, Esri decided to augment Select Layer By Attribute to accept an input data set and it will create a layer, select on it, and return it. This is what is happening in your case. When you use Get Count on the data set directly, it is returning the total number of records on the data set, which is should.
... View more
03-18-2024
06:33 AM
|
0
|
3
|
193
|
|
POST
|
@Ed_, the updated code was close to working, you just need to use Python zip() function and change 2 lines: import arcpy
# To allow overwriting outputs change overwriteOutput option to True.
arcpy.env.overwriteOutput = True
# Import the surtax projects geodatabase table subset
in_df = r"O:\MyProject.gdb\Projects_City"
arcpy.management.CreateTable(
out_path=r"O:\MyProject.gdb",
out_name="Projects_City_Updated",
template=in_df,
config_keyword="",
out_alias=""
)
out_df = r"O:\MyProject.gdb\Projects_City_Updated"
fldlst = ["PRJTID", "MUNICIPALI", "ZIPCODE"]
with arcpy.da.InsertCursor(out_df, fldlst) as insertCursor:
with arcpy.da.SearchCursor(in_df, fldlst) as searchCursor:
for row in searchCursor:
for z in zip(*(map(str.strip, str.split(i, ",")) for i in row[1:])):
insertCursor.insertRow(row[0:1] + z)
... View more
03-17-2024
08:38 AM
|
1
|
3
|
465
|
|
POST
|
Esri seldom share this information ahead of time, unless it is maybe a couple or few days away. That said, one can make a reasonable guess now that ArcGIS Enterprise has jettisoned support for the ArcMap runtime and ArcGIS Pro has a more frequent release cycle. Since ArcGIS Enterprise contains the ArcGIS Pro runtime, the releases of ArcGIS Enterprise seem to be getting closer to releases for ArcGIS Pro. I suspect April release, May at the latest.
... View more
03-13-2024
07:33 AM
|
2
|
0
|
1398
|
|
POST
|
Comments like "that didn't work" aren't helpful. If there was an error, what exactly was the error, and provide a traceback if one exists. If there was no error but the results are unexpected, state what you expected and what you got.
... View more
03-12-2024
03:01 PM
|
0
|
0
|
215
|
|
POST
|
I can't say I have seen documentation specifically addressing that question, but I have never seen ArcGIS Server change a certificate on its own, i.e., I have always seen it stick with the expired certificate if that is the certificate it is told to use.
... View more
03-08-2024
10:00 AM
|
2
|
0
|
294
|
|
POST
|
@CharmiPatel21, welcome to Esri Community. Esri Community is a great resource for Esri users to learn about ArcGIS products, and what helps users learn is providing documentation or references to documentation when talking about good, bad, or any time of practices. The certificate that ArcGIS Server, Portal, etc... use is explicitly specified as a machine-level setting (webServerCertificateAlias) in Edit Machine—ArcGIS REST APIs | ArcGIS Developers. Whether there is 1 certificate, 2 certificates, or 10 certificates on the machine; it is only the one specified in the property that is used by ArcGIS so leaving the original self-signed certificate does not create any risk of confusion for the software.
... View more
03-08-2024
06:42 AM
|
1
|
0
|
302
|
|
POST
|
It would help if you provided a bit more information. It sounds like you are talking about an ArcGIS Enterprise deployment with portal and federated ArcGIS Servers (as opposed to stand-alone ArcGIS Server), correct? When an ArcGIS Server is federated with a portal, the authentication goes through the portal except for the built-in PSA account. The portal provides a token to use with the federated ArcGIS Server, you don't login directly to AGS with portal credentials. What REST calls specifically are you using?
... View more
03-04-2024
06:51 AM
|
0
|
1
|
432
|
|
POST
|
Although referring to earthquakes and not subsidence, the same abbreviations are used: Peak ground acceleration - Wikipedia During an earthquake, ground acceleration is measured in three directions: vertically (V or UD, for up-down) and two perpendicular horizontal directions (H1 and H2), often north–south (NS) and east–west (EW). Sigma is the uncertainty around the value.
... View more
03-01-2024
02:32 PM
|
1
|
0
|
272
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | Tuesday | |
| 1 | 06-03-2016 11:46 AM | |
| 1 | a month ago | |
| 2 | 03-20-2024 04:06 PM | |
| 1 | 03-20-2024 07:03 AM |
Activity Feed
- Kudoed Re: Most efficient way to concatenate strings in millions of records ignoring nulls and spaces for DanPatterson. 4 hours ago
- Posted Re: Most efficient way to concatenate strings in millions of records ignoring nulls and spaces on ArcGIS Pro Questions. yesterday
- Got a Kudo for Re: ArcGIS Pro Field Calculator just converts entire column to null values. yesterday
- Posted Re: ArcGIS Pro Field Calculator just converts entire column to null values on ArcGIS Pro Questions. Tuesday
- Posted Re: Syntax for arcpy.management.CalculateField on ArcGIS Pro Questions. Friday
- Got a Kudo for Re: Automating date calculations in field calculator. a week ago
- Got a Kudo for Re: field calc (pro 2.7) - reduce WKT length by Rounding/Truncating decimal places. a week ago
- Kudoed Re: How to improve arcpy.da.UpdateCursor / InsertCursor performance? for JakeSkinner. a week ago
- Posted Re: How to Stop "SelectLayerByAttribute_management" creating temporary tables, while running script in ArcPro on Python Questions. a week ago
- Kudoed Re: arcpy.SelectLayerByAttribute_management Issues - how to use with an update cursor. for EdX1. a week ago
- Got a Kudo for ArcGIS Data Store(s) Supported Data Types and Limits. 2 weeks ago
- Posted Re: Calculate Field won't update a date field on ArcGIS Pro Questions. 2 weeks ago
- Got a Kudo for Re: Need help getting year from a date field (field calculator). 2 weeks ago
- Kudoed Re: Installing SSL Certificate for danielwill. 2 weeks ago
- Posted Re: ArcGIS Desktop crashing at start on ArcMap Questions. 2 weeks ago
- Kudoed Re: if statement always returning false parameter for Raul. 3 weeks ago
- Kudoed Summary Statistic Tool - Weighted average for CarstenSchuermann. 3 weeks ago
- Posted Re: Is is possible to share an Image Service to a standalone Server from ArcGIS Pro? on ArcGIS Pro Questions. 3 weeks ago
- Kudoed In Arcpy, add a way to detect query layers and their query definition in aprx files for AndrewRudin1. 3 weeks ago
- Posted Re: efficient code for field calculation on ArcGIS Pro Questions. 3 weeks ago
Contact Me
| Online Status |
Online
|
| Date Last Visited |
2 hours ago
|