I had hoped to it would be possible using a single source twice to create:
a) /state/city/ and then
b) /state/
I just tried creating ‘b’ and while it did create example.com/washington/ and that page resolved, when i clicked the “See all URLs” and viewed the sitemap it had created one entry per city in the state, so hundreds or repeated URLs. I was hoping it automatically (or with the checking of a checkbox) would return only unique values. So it looks like using a local file won’twork for this.
I tried another option that looks to be working – create a Google Sheet with 2 worksheets – the second worksheet using =UNIQUE to filter just state, and using this worksheet ID for the source. This looks to have worked.
I’m sill curious what other have done.
This mostly answers my questions – https://docs.themeisle.com/article/1465-how-to-generate-list-of-nested-pages
You can’t use multiple projects in the free version – and I can’t test in a paid version so that’s as far as I got.