Latest Contributions by StephenM

‎02-26-2019

That's odd. Maybe it has something to do with the version. Are you using ArcGIS Online or Enterprise?

‎02-26-2019

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?

‎02-25-2019

Are you the owner of the dashboard?

‎02-25-2019

You can change number prefixes in the operations dashboard settings under the "General" tab. Dashboard settings—Operations Dashboard for ArcGIS | ArcGIS

‎02-25-2019

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

‎02-21-2019

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.

‎02-14-2019

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

‎02-05-2019

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.

‎02-04-2019

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

‎02-04-2019

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

‎02-01-2019

Those population density numbers look off. Maybe the area didn't calculate correctly. What do your population and area numbers look like?

‎01-24-2019

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.

‎01-23-2019

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().

‎01-23-2019

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().

‎01-10-2019

Stack labels might be what you're looking for.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by StephenM

Re: Dashboard- indicator currency units

Re: Dashboard- indicator currency units

Re: Dashboard- indicator currency units

Re: Dashboard- indicator currency units

Re: How do I make certain fields not appear in my pop up

Re: Model Builder to Create Python Script for xls to csv Conversion

Re: Model Builder to Create Python Script for xls to csv Conversion

Re: Conditionals in Survey 123 Reports

Re: Population Density with graduated colors isn't reflected in map

Re: Conditionals in Survey 123 Reports

Re: Population Density with graduated colors isn't reflected in map

Re: Cut/extract multiple feature classes at once

Re: Python 3.x syntax for refreshing a map series (formerly DDP)

Re: Python 3.x syntax for refreshing a map series (formerly DDP)

Re: Callout problems

Re: Remove layers from a project without opening

Re: ArcMap: Errors on opening map documents

Re: How do I remove labels on the Light Grey Canva...

Re: How do I remove labels on the Light Grey Canva...

Re: Updating Data Source in ArcGIS PRO project wit...