Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About StephenM
StephenM
Occasional Contributor II
since
04-04-2017
11-11-2020
99
Posts created
13
Kudos given
23
Solutions
74
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 StephenM
|
POST
|
That's odd. Maybe it has something to do with the version. Are you using ArcGIS Online or Enterprise?
... View more
02-26-2019
01:00 PM
|
0
|
4
|
2532
|
|
POST
|
If you're the owner of the dashboard I don't know why you wouldn't see those settings. What do you see if you click on the settings button?
... View more
02-26-2019
10:06 AM
|
0
|
6
|
2532
|
|
POST
|
You can change number prefixes in the operations dashboard settings under the "General" tab. Dashboard settings—Operations Dashboard for ArcGIS | ArcGIS
... View more
02-25-2019
12:02 PM
|
1
|
2
|
2532
|
|
POST
|
You can use custom Arcade expressions to conditionally hide fields in the pop-up: https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2017/07/18/conditional-field-display-with-arcade-in-pop-ups
... View more
02-25-2019
11:14 AM
|
0
|
0
|
467
|
|
POST
|
Yeah, I tried using FieldMappings and also tried using table view FieldInfo. With field mapping, the ObjectID field didn't seem to be accessible using the fields property of the FieldMappings object. With FieldInfo, even if I hid the ObjectID field it still showed up in the output CSV. Hiding fields worked with all the other fields, just not ObjectID.
... View more
02-21-2019
12:04 PM
|
1
|
0
|
784
|
|
POST
|
To overwrite outputs, set arcpy.env.overwriteOutput = True. overwriteOutput (Read and Write) Controls whether tools will automatically overwrite any existing output when run. When set to True, tools will execute and overwrite the output dataset. When set to False, existing outputs will not be overwritten, and the tool will return an error. Boolean env—Help | ArcGIS Desktop You could do this using Excel To Table to convert the Excel sheet to a table, then Table To Table to convert the table to a CSV. In my testing the output CSV always had an OID field added to it, so I used the pandas library to drop the OID field. import arcpy
import pandas as pd
arcpy.env.overwriteOutput = True
# Input Excel file
excel_file = r"C:\Users\Username\Desktop\test_book.xlsx"
# Intermediate converted table
interm_table = r"C:\Users\Username\Documents\ArcGIS\Default.gdb\test_book"
# Convert Excel file to table
arcpy.ExcelToTable_conversion(excel_file, interm_table, "Sheet1")
# Directory and name for the output CSV
output_dir = r"C:\Users\Username\Desktop"
csv_name = "test_book.csv"
# Convert intermediate table to CSV
arcpy.TableToTable_conversion(interm_table, output_dir, csv_name)
# Set full path of the CSV
csv_fullpath = output_dir + "\\" + csv_name
# Read CSV into pandas DataFrame
df = pd.read_csv(csv_fullpath)
# Drop OID column
df.drop('OID', axis=1, inplace=True)
# Write DataFrame to the same CSV as the input
df.to_csv(csv_fullpath, index=False) pandas.read_csv — pandas 0.24.1 documentation pandas.DataFrame.drop — pandas 0.24.1 documentation pandas.DataFrame.to_csv — pandas 0.24.1 documentation
... View more
02-14-2019
11:51 AM
|
0
|
3
|
2626
|
|
POST
|
Ah, the question being a select multiple is probably the issue. I tested the conditional with text and select one questions. I don't think you can isolate selections from a select multiple question. You can use select multiple questions in conditionals, but you have to test for the whole string that's returned by the field name code in the template (selections from select multiple questions are returned as a comma-separated string). I tried setting up an "if" statement with multiple "or" operators to test for multiple combinations of selections, but it seems that everything beyond the first "or" is ignored. For example, given a record with color_sel = "blue , white , green": ${if color_sel==”blue , white” || color_sel==”blue , white , green” || color_sel==”blue , green” || color_sel==”blue”}${details}${/} ${if color_sel==”blue” || color_sel==”blue , white” || color_sel==”blue , green” || color_sel==” blue , white , green”}${details}${/} The first statement displays the contents of the details field, but the second does not.
... View more
02-05-2019
02:26 PM
|
1
|
0
|
4416
|
|
POST
|
That's the correct way to calculate geometry. Those areas definitely look too small though. Block group 481210202024 (the top one in your attribute table) looks like it should be around 48.26 square miles (based on Esri's USA Block Groups ArcGIS Online layer). You might try making sure the projections are all set up correctly. Someone in this thread had a similar issue: Calculating area using Calculate Geometry
... View more
02-04-2019
06:32 PM
|
0
|
4
|
2184
|
|
POST
|
I saw that you got a reply in another thread that said this isn't supported, but this worked for me: In my report template (the selected record has city = "Los Angeles"): ${test_yes_no} (${if city=="Los Angeles"}${time_stamp}${/}) ${test_yes_no} (${if city=="San Francisco"}${time_stamp}${/}) Output in the generated report: No (Oct 5, 2018) No () I thought maybe there could be an issue with field length or something, but I also tested this with a field containing a 450-character description and it worked. What's the data type of the LD_Other_Sign_Details field? Edited to add: This looks like the most detailed documentation that discusses this type of conditional statement: https://community.esri.com/groups/survey123/blog/2018/07/06/bull-release-30
... View more
02-04-2019
05:23 PM
|
0
|
3
|
4416
|
|
POST
|
Those population density numbers look off. Maybe the area didn't calculate correctly. What do your population and area numbers look like?
... View more
02-01-2019
05:19 PM
|
0
|
6
|
2184
|
|
POST
|
One option might be to use batch clip and batch project. A quick tour of batch processing—Help | ArcGIS Desktop Another option would be to do this using a few tools in ArcPy: ListFeatureClasses to list the feature classes in a workspace, Clip to clip the feature classes to the project boundary, and Project and SpatialReference to reproject them. A quick example: ws = "C:\\Users\\username\\Desktop\\temp.gdb"
arcpy.env.workspace = ws
fcs = arcpy.ListFeatureClasses()
output = "C:\\Users\\username\\Desktop\\temp\\"
out_cs = arcpy.SpatialReference(####)
i = 1
for fc in fcs:
arcpy.Clip_analysis(fc,"clipper",output+"temp"+str(i)+".shp")
arcpy.Project_management(output+"temp"+str(i)+".shp",output+"temp"+str(i)+"_sp.shp",out_cs)
i += 1 In this example, some feature classes are located in a geodatabase (temp.gdb), one of which is the target shape ("clipper"). Each feature class in the geodatabase is clipped to the "clipper" shape and output as a shapefile to a folder named "temp". The shapefiles are named "temp_#.shp", where the number is incremented on each iteration of the "for" loop. After clipping, the shapefiles are projected to another coordinate system—which is selected using arcpy.SpatialReference—and "_sp" is appended to the projected shapefile name.
... View more
01-24-2019
06:55 PM
|
0
|
1
|
964
|
|
POST
|
Yeah, based on the documentation it sounds like it might be a bug (maybe related to the inability to set the map extent in a map view using arcpy.mp). Are you using the PIN to update the layer's definition query? I notice that in ArcMap refreshing the data driven pages zooms to the visible features, but as you say, refreshing the map series doesn't change the map's extent in Pro. If you're using definition queries, the zoomToAllLayers() method of the MapFrame class might provide what you're looking for. Something like lyt.mapSeries.mapFrame.zoomToAllLayers().
... View more
01-23-2019
04:47 PM
|
0
|
1
|
2215
|
|
POST
|
You need to access the mapSeries property of the Layout object, since refresh() is a method of the mapSeries object. Something like lyt.mapSeries.refresh().
... View more
01-23-2019
02:19 PM
|
1
|
3
|
2215
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-02-2018 05:55 PM | |
| 1 | 10-30-2018 01:58 PM | |
| 1 | 01-07-2019 11:49 AM | |
| 1 | 01-07-2019 12:27 PM | |
| 1 | 03-25-2019 01:33 PM |
Activity Feed
- Got a Kudo for Re: Arcpy.mp Map Series- Field Name from code. 06-07-2024 12:35 PM
- Got a Kudo for Re: Arcade and pop-ups, Replace function issues with 1 char strings. 04-15-2024 10:55 PM
- Got a Kudo for Re: Remove layers from a project without opening. 04-15-2024 11:28 AM
- Got a Kudo for Re: ArcMap: Errors on opening map documents. 04-03-2024 06:50 AM
- Got a Kudo for Re: Survey123 Multiple conditional calculations . 10-27-2023 02:15 AM
- Got a Kudo for Re: How do I remove labels on the Light Grey Canvas basemap? Or download a new basemap that has NO labels? The basemaps in ArcGIS all have some small labels and I need a map that I can easily download and load with absolutely NO labels and I cannot find t. 10-19-2023 02:46 PM
- Got a Kudo for Re: How do I remove labels on the Light Grey Canvas basemap? Or download a new basemap that has NO labels? The basemaps in ArcGIS all have some small labels and I need a map that I can easily download and load with absolutely NO labels and I cannot find t. 10-19-2023 02:45 PM
- Got a Kudo for Re: Arcpy.mp Map Series- Field Name from code. 06-21-2023 10:55 AM
- Got a Kudo for Re: How to use multiple 'Replace' Arcade functions?. 06-14-2023 08:07 AM
- Got a Kudo for Re: Arcpy.mp Map Series- Field Name from code. 07-15-2022 02:23 AM
- Got a Kudo for Re: Operations Dashboard - Filtering Data. 03-10-2022 08:16 AM
- Got a Kudo for Re: How do I change the file location of layers under the Table of Contents?. 10-04-2021 10:09 AM
- Got a Kudo for Re: In Survey 123 Connect is there a way to format the number values as currency? I can concatenate the $ in front of the numbers, but not sure how to get the commas in. . 07-30-2021 07:33 AM
- Got a Kudo for Re: Updating Data Source in ArcGIS PRO project with arcpy. 05-23-2021 04:17 PM
- Got a Kudo for Re: Survey123 Multiple conditional calculations . 05-19-2021 01:29 PM
- Got a Kudo for Re: How to Import csv data with modelbuilder. 11-11-2020 02:06 AM
- Got a Kudo for Re: Users search by Group name?. 11-11-2020 02:06 AM
- Got a Kudo for Re: How do I change the file location of layers under the Table of Contents?. 11-11-2020 02:06 AM
- Got a Kudo for Re: Model Builder to Create Python Script for xls to csv Conversion. 11-11-2020 02:06 AM
- Got a Kudo for Re: Conditionals in Survey 123 Reports. 11-11-2020 02:06 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|