Latest Contributions by JeffThomasILM

Thanks for your quick reply, @AubriOtis. This looks very promising! I'll give it a shot and report back. It's great that this option would retain my project as a "real" map series that can be seen in Pro. Whereas the Python option (as I'm envisioning it) would mean the resulting map pages only exist as exported PDFs. ... View more

I did not realize until just now that those 2 options existed! I was using the Table Attribute Value, but for my situation the Map Series Attribute is exactly what I need. Learn something new every day! Thanks! ... View more

Ah! MS vs. Layout also explains why the code complete wasn't working. You were of course right about removing the single quotes from the field name. I thought they were required if using a file GDB, but apparently not. A lot of trial and error went into formatting the SQL statement properly for Python, and that was what I finally arrived at that didn't create an error. However, it also didn't create a selection! Thanks again! ... View more

I'm trying to actually implement the knowledge this morning I got from this thread yesterday. I'm getting an error when I try to run my script. I can't figure out what I've done wrong.   import arcpy, os, sys aprx = arcpy.mp.ArcGISProject('CURRENT') HPCcase = aprx.listLayouts('HPC Case Layout')[0] ms = HPCcase.mapSeries if ms.enabled: ms = HPCcase.mapSeries indexLyr = ms.indexLayer PDFpath = 'V:\\projects\\DevSvcs\\Planning\\HistoricDistrict\\HPC\\' HPCdate = '20210513' arcpy.management.SelectLayerByAttribute(in_layer_or_view=indexLyr, selection_type="NEW_SELECTION", where_clause=f"'HPCDate'='2021-05-13'") pageName = ms.pageRow.ConcatAddr HPCcase.exportToPDF(out_pdf=os.path.join(PDFpath, HPCdate, f"HPC_{HPCdate}_{pageName}.pdf"), page_range_type="SELECTED", multiple_files="PDF_MULTIPLE_FILES_PAGE_NAME", resolution=300) Traceback (most recent call last): File "<string>", line 19, in <module> File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\utils.py", line 191, in fn_ return fn(*args, **kw) TypeError: exportToPDF() got an unexpected keyword argument 'page_range_type'   In addition to the export error, I'm pretty sure nothing is getting selected in my index layer. Since a date is the selecting criterion, it's an additional syntax hurdle to make sure I'm doing it exactly right. When I create the features, I only care about the date, not the time. (Time should always be 00:00:00, but I'd rather it not be a factor just in case.)  Also, I want to make sure I understand how the selected page range works for exporting in Python. Does it only work by selecting index features also in Python? Is it possible to select one or more pages manually in the Contents pane, then export with Python without further specifying a selection? Thanks! ... View more

Thank you, @JeffBarrette and @DanPatterson. I'm realizing a few good nuggets of information from your responses. What I called a loop in my o.p. is not a loop; it's a conditional. You don't have to specify every single parameter for the method (but you can, as long as you follow the specified order); you just need to specify the name of the parameter(s) you want. Booleans are like integers, no quotes. A few outstanding questions: Why are the page_range parameters not included in the full, non-named parameter array for the method? Are there other (hidden) parameters? Is it common to have additional parameters that can only be called by name? Thanks! ... View more

Unfortunately, the bus routes would need to geometrically match the streets exactly. There may be some ways to get them to align, but in the end it's probably no quicker or easier than doing it manually, sorry! I'm still not entirely sure what you're trying to do. Assign street names to bus routes? So that only those street names are labeled? One last idea. You did mention you envision "clipping" the street data. You might be able to do that. Create as thin of a buffer on your bus routes as you can to get the traversed streets in their entirety. Clip the streets and export them as a new feature class. This will still include very short segments of cross streets, but you can set a minimum feature length for labeling, which hopefully would result in a pretty clean selection of streets that actually have bus routes. ... View more

It's tough to link one layer to another if there's no attribute or geometry match between them. You could create a buffer (width TBD) on your bus routes and do a spatial join with streets to pick up street attributes, but that's going to be tough with cross streets. Presumably your bus routes are on arterial streets; could you filter your streets on some sort of road classification? ... View more

Assuming you have a common field between bus routes and streets (street name?), you could join the streets layer to the bus routes layer and uncheck "keep all target features". That will hide any streets that aren't matched with a bus route. ... View more

If I try to insert the {page_range_type}, {page_range_string}, and {multiple_files} parameters, I get an error that the value for the image_quality parameter — the parameter that should come next if you ignore the page_range parameters — isn't valid:   if not HPCcase.mapSeries is None: ms = HPCcase.mapSeries if ms.enabled: ms = HPCcase.mapSeries indexLyr = ms.indexLayer arcpy.management.SelectLayerByAttribute(indexLyr, "NEW_SELECTION") pageName = ms.pageRow.ConcatAddr HPCcase.exportToPDF(os.path.join(PDFpath, "20210513", f"HPC_20210513_{pageName}.pdf"),'SELECTED','','PDF_MULTIPLE_FILES_PAGE_NAME',300, 'BEST','True', 'ADAPTIVE','True', 'LAYERS_ONLY','True',80,'False','False','False','True') <Result 'Sites'> Traceback (most recent call last): File "<string>", line 8, in <module> File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\utils.py", line 163, in fn_ arg_name].keys()))) ValueError: Invalid value for image_quality: '' (choices are: ['BEST', 'BETTER', 'NORMAL', 'FASTER', 'FASTEST'])   ... View more

Since I barely know what I'm doing with Python 😀, I've only tried to write code that is very similar to the examples. I was attempting to write a cross between example 2 (which writes each page to a separate PDF) and example 3 (which exports selected pages): import arcpy, os, sys PDFpath = 'V:\\projects\\DevSvcs\\Planning\\HistoricDistrict\\HPC\\' aprx = arcpy.mp.ArcGISProject('CURRENT') HPCcase = aprx.listLayouts('HPC Case Layout')[0] relpath = os.path.dirname(sys.argv[0]) if not HPCcase.mapSeries is None: ms = HPCcase.mapSeries if ms.enabled: ms = HPCcase.mapSeries indexLyr = ms.indexLayer arcpy.management.SelectLayerByAttribute(indexLyr, "NEW_SELECTION", "'HPCDate'= '2021-05-13'") pageName = ms.pageRow.ConcatAddr HPCcase.exportToPDF(os.path.join(PDFpath, "20210513", f"HPC_20210513_{pageName}.pdf"))  I have run this in the interactive Python window. It exports only the page active in the map frame, even if I have multiple pages selected/highlighted in the Contents pane. It also ignores my SQL query. ... View more

I hadn't thought about a database view rather than a join, but I might give it a shot now that I'm fully in troubleshooting mode. It's very weird (to me, at least) that my model does work as-is, but it apparently doesn't write out to the table (or at least Pro doesn't notice that it has) until after Pro is restarted. Perhaps a db view would work better, though even if it does, that seems more like a workaround than a fix for my model (which works in ArcMap). ... View more

Unfortunately, layer refresh doesn't seem to fix my problem. However, that's irrelevant because I just realized that the non-spatial table actually isn't updating. If I update the table directly, it does immediately update on the map. But I'm actually using a model I built to update the table, and that's when edits don't show up until I restart Pro. Back to dealing with my models. 🤣 😒 Specifically, migrating models that worked fine in ArcMap that have proven problematic in Pro. Thanks for following me on 2 model-related wild goose chases in as many days. ... View more