Latest Contributions by SusanZwillinger

‎10-04-2019

I've seen screen captures of other users showing dates for feature classes showing in the Catalog View for ArcGIS Pro. I don't see any dates in my Catalog View. I am using ArcGIS Pro 2.4.2. How do I get the dates to show up? It would also be nice to be able to search a folder and find all feature classes that had been modified on a specific date or date range. Thanks, Susan

‎09-09-2019

Hi Praveen, Can you confirm that the 2019 data is available for desktop now? Our company is current on maintenance and I have not received any email notification and I don't see the data available for download on my.esricom. Thanks, -Susan-

‎07-01-2019

A few more things to try: check the label setting for the highway shields and make sure that they do not have a high priority or have a setting that allows overlap. Also, make sure that your Labeling toolbar is set to "Best" instead of "Fast". The "Best" option will make your map re-draw a bit slower but it should also help to remove any overlapping labels. If all of that fails, you could always create a "highway shield" type of label for your points that is larger than your points but make the circle and label text transparent. If you make that label the highest priority and increase the label buffer in the Placement Properties settings for that label, it should prevent anything from overlapping the point itself. Regards, -Susan-

‎06-28-2019

Hi Sara, You are correct that you need to change the feature weight for your point layer. However, in order to avoid overlap completely, the value that you need to use is 1000. This is how I typically set this: You can also set the feature weight from the Layer Properties-->Labels tab-->Placement Properties-->Conflict Resolution tab: This should solve your problem. As a side note, you may also notice that sometimes when you use a large symbol for your point layer, the labels for the point layer may be overlapping the point. To fix this issue, you would use Layer Properties-->Labels tab-->Placement Properties-->Label Offset ...-->Measure offset from the exact symbol outline option. I have found the the above solution works better than increasing the label buffer percentage (and/or setting this as a hard constraint) in the Label Density tab of Placement Properties. I have often wondered whether this may make your labels draw a bit slower since you are increasing the amount of computation required to calculate the label placement, but I have never tested that. Regards, -Susan-

‎06-26-2019

Hi Stone, If your SQL data has a spatial data type (Geometry or Geography), sometimes a simple drag and drop from the Catalog to the map view will be enough to display the data in ArcMap. From there, you can right-click on the map layer in the Table of Contents and use the Data-->Export Data option to create a shapefile or a file geodatabase feature class. This export takes the data out of SQL and puts it into a file based Esri format as Bill mentioned. However, if all you need to do is display points on a map from the SQL table, then I would probably leave the data in the SQL format since the data could change. Obviously, once you export the data, you lose the live connection to the data and it might become out of date. On the other hand, exporting the data to a shapefile or a feature class may improve your spatial analysis capabilities and performance. Regards, -Susan-

‎03-08-2016

Thanks, Ciro. It is good to know why the model was not working properly. I still hope that Esri will log this as a bug because the row selection should work with any text field, regardless of whether there are numbers, parentheses and other characters in the text.

‎02-26-2016

While I would still like to know how to get my original model to work (or how to get this to work in python), I have found an alternative solution that works very well. See Canton Hall's post on LinkedIn: ArcMap 10.2 - One to Many Join | Canton Hall | LinkedIn Note: Canton's solution works well with 10.3.1.

‎02-26-2016

I attached a zip file that contains the file geodatabase with some sample data, the toolbox with the model, and an MXD with the bg_prj map layer loaded. (The reason for this is that I've found that if I load the bg_prj into the model from the data source, the join will fail, but if I load the bg_prj from a layer in the Table of Contents, then the join works as expected.)

‎02-26-2016

Here's the result when I run the model first on the table named tbl_CA_AppleValley_Origins and then run it again with tbl_CA_RanchoSanta_Origins. And here's what happens when I delete all of the output data and run the same model again:

‎02-26-2016

All of the tables are in the same workspace and have the exactly the same fields. I've read all of the online help related to iterators and I've used them successfully in many other situations. The model that I created works perfectly when I run with the table that I use when creating the model. Of course, I can simply duplicate the first model in a new model to get it to run with the next table, but that defeats the purpose of automation. The model should work the same way when I enter a new input table since this is a parameter in the model, but unfortunately, it does not. It doesn't give me any error messages when I run the model a second time with the new input table and output feature class parameters. It does create an output feature class, but only one, when it should be creating 15. I tried using %n% and %i% as a way to get the iteration to have unique names when I run the model again, and neither results in the correct output, so I think this may be a limitation in the way that ModelBuilder works, which is why I tried to get this to work in Python.

‎02-25-2016

Thanks, Wes, but the code you provided is not quite what I'm trying to achieve (or perhaps I'm just not understanding it correctly). There is no "where" clause in this case since I don't want to manually specify the value that I'm looking for in the table. I want the code to select the first in the set (e.g. "0: Average Day (M-Su), 0: All Day (12am-12am)") and associate that with the number 1 and then when it creates the table in the arcpy.CopyRows_management(InTable, OutTable), I want the OutTable to be automatically named something like "tbl_1". At the end of the iteration, there should be many tables---tbl_1, tbl_2, tbl_3, etc. I can then use these tables to join to the block group feature class and export these as new feature classes where I can set the symbology for each new map layer. Does that make sense?

‎02-25-2016

I have data in a table that represents values over 3 different categories (Average Day, Weekday, Weekend) and 5 different time periods (All Day, Morning, Mid-Day, Afternoon, and Evening). The data is by block group and there is a one to many relationship (i.e. duplicate block group IDs in the table), so a simple join to my block group feature class is not the answer. I created the model below to help me visualize the data in separate map layers. The model iterates through the unique combination of categories and times (e.g. "0: Average Day (M-Su), 0: All Day (12am-12am)", "0: Average Day (M-Su), 1: Morning (6am-10am)", etc.) and creates a table with unique block groups by day type and time that I can join to the main block group feature class and export each iteration into a new feature class. The %n% variable names the output feature class with a unique number. Normally, I would use %Value%, but the field data (shown above) is rather long and contains spaces, dashes, and parentheses that we would not want that in the feature class name. The model below works perfectly the first time that I run it, but when I give it a new input table (I have lots of tables to process), the iteration no longer gives me all of the output data. It looks like it is overwriting the data for each iteration and just giving me a single output feature class. Any ideas on how to fix this? It seems like it should be pretty simple and I have no idea why the iteration doesn't continue to work with the new input data. I also tried to convert this to Python code and I'm getting stuck on how to create a unique number for each string in the unique set of field values. (FYI - I am not a developer/programmer so my Python skills are minimal.) # Import arcpy module import arcpy from arcpy import env import os # Load required toolboxes arcpy.ImportToolbox("C:\\Program Files (x86)\\ArcGIS\Desktop10.3\\ArcToolbox\\Toolboxes\\Data Management Tools.tbx") # Set up workspace environment arcpy.env.workspace = "c:\\test\\TimeDatabyBG.gdb" arcpy.env.overwriteOutput = True # Script arguments InTable = arcpy.GetParameterAsText(0) InName = arcpy.GetParameterAsText(1) Field = arcpy.GetParameterAsText(2) OutTable = arcpy.GetParameterAsText(3) OutWorkspace = arcpy.GetParameterAsText(4) Blockgroups = arcpy.GetParameterAsText(5) OutFC = arcpy.GetParameterAsText(6) # InTable example = "c:\\test\\TimeDatabyBG.gdb\\tbl_CA_RanchoSanta_Origins" # InName example = "CA_RanchoSanta" # Field example = "Day_Type_Part" # OutTable example = os.path.join(OutWorkspace, "InName") # OutWorkspace example = "c:\\test\\TimeDatabyBG.gdb\\" # Blockgroups example = "c:\\test\\TimeDatabyBG.gdb\\"bg_prj" # OutFC example = os.path.join(OutWorkspace, "BG_" + InName + iterated number # or "c:\\test\\TimeDatabyBG.gdb\\"BG_CA_RanchoSanta_1" # Iteration cursor = arcpy.da.SearchCursor(InTable, Field) values = [row[0] for row in arcpy.da.SearchCursor(InTable, Field)] uniqueValues = set(values) print(uniqueValues) #the script works up to this point in that it can print out a list of the unique values in the "Day_Type_Part" field, but I don't know how to translate this into a unique selection and value for the name of the output table in the line below. # Process: Copy Rows arcpy.CopyRows_management(InTable, OutTable) # Process: Add Join arcpy.AddJoin_management(Blockgroups, "ID", OutTable, "BG_ID", "KEEP_COMMON") # Process: Copy Features arcpy.CopyFeatures_management(Blockgroups, OutFC, "", "0", "0", "0") # Process: Remove Join arcpy.RemoveJoin_management(Blockgroups, "") Any help will be greatly appreciated! Thanks, -Susan-

‎01-28-2016

Wow, that was fast! The code runs fine, but I'll have to play around with the spatial references. 3005 is for NAD_1983_BC_Environment_Albers so if you use latitude and longitude coordinates as the x,y input, it is not going to work. What did you use as your inputs?

‎01-28-2016

Here's something to think about for fun: Calculating an Expanding Square (Microsoft Excel) The link provides a download for a spreadsheet that will calculate the points for a search and rescue effort that starts at a center point and then expands from that location in a spiraling rectangle. (It says that it creates an expanding square, but that only sort of works near the equator; for other areas it is a rectangle.) Once you download the spreadsheet, you can "unprotect" the worksheet (there is no password) so that you can format the table array to bring the data into ArcMap. If you add a column for "Line" and calculate all of the rows to be "1", you can use the Data Management Tools-->Features-->Point to Line script to convert the points into a line using the "Seg" column as the sort order. The spreadsheet formulas have some obvious issues, but it is a quick approximation of what someone might need. If you were going to improve the solution in ArcGIS so that it was a more accurate expanding square, how would you do it?

‎10-15-2015

Ronald, I created a toolbox with a Python script that iterates through each attribute in one layer and does a "Select by Location" in another layer. I'm sure that you can edit the script to do what you need. You can download the zip file on my previous post Select by Location Toolbox - Python script automation used to work and now shows ERROR 000210 (I fixed the error and uploaded the corrected version of the script.) Regards, -Susan-

Online Status	Offline
Date Last Visited	‎02-01-2024 09:31 PM

My Ideas

Latest Contributions by SusanZwillinger

Dates not showing in ArcGIS Pro Catalog

Re: Business Analyst 2019 Demographics

Re: Business Analyst basemap labels cover my features

Re: Business Analyst basemap labels cover my features

Re: How can I Get Shapefiles from Connected Database?

Re: Help with time series data by block groups automation

Re: Help with time series data by block groups automation

Re: Help with time series data by block groups automation

Re: Help with time series data by block groups automation

Re: Help with time series data by block groups automation

Re: Help with time series data by block groups automation

Help with time series data by block groups automation

Re: Creating an expanding square for search and rescue

Creating an expanding square for search and rescue

Re: Modeling Select By Location

Re: ArcGIS Pro 3.0.2 patch -- Now Available

Generate Grids and Hexagons Update

Re: Single Sign On experience with SAML on ArcGIS ...

Re: Round or truncate latitude and longitude field...

Re: Help with time series data by block groups aut...