feat: Add geography support

[jimfulton]

Thank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:

• Make sure to open an issue as a bug/issue before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
• Ensure the tests and linter pass
• Code coverage does not decrease (if any source code was changed)
• Appropriate docs were updated (if necessary)

Fixes #136 🦕

[tswast]

I like it!

I wonder if we want to merge this before the rename just to make the docfx session happy?

[jimfulton]

I wonder if we want to merge this before the rename just to make the docfx session happy?

I'm working on a branch that combines the rename and geography (and snippets to be used in the geography doc).

I suggest we decide next week whether to wait for Dan to fix docfx or to include geography in alpha 1.

[snippet-bot]

Here is the summary of changes.

You are about to add 8 region tags.

• docs/geography.rst:23, tag bigquery_sqlalchemy_create_table_with_geography
• docs/geography.rst:49, tag bigquery_sqlalchemy_insert_geography
• docs/geography.rst:65, tag bigquery_sqlalchemy_query_geography_wkb
• docs/geography.rst:75, tag bigquery_sqlalchemy_query_geography_text
• samples/snippets/geography.py:22, tag bigquery_sqlalchemy_create_table_with_geography
• samples/snippets/geography.py:38, tag bigquery_sqlalchemy_insert_geography
• samples/snippets/geography.py:54, tag bigquery_sqlalchemy_query_geography_wkb
• samples/snippets/geography.py:61, tag bigquery_sqlalchemy_query_geography_text

---

This comment is generated by snippet-bot.
If you find problems with this result, please file an issue at:
https://github.com/googleapis/repo-automation-bots/issues.
To update this comment, add snippet-bot:force-run label or use the checkbox below:

• Refresh this comment

[jimfulton]

I merged the rename branch into this. Maybe that was a mistake.

We'll either want to merge the rename branch first, at which point this will be smaller, or we'll merge this.

[jimfulton]

Everything has been reviewed here except: 6343bee, which changes the geography documentation to use snippets, which found a number of bugs. :) I also improved one of the query examples.

I tried to format the query examples to be more readable in the documentation, but black wouldn't let me. :(

[jimfulton]

The diff is clean after merging master.

[jimfulton]

@tswast I'm going to assume you still approve unless I hear otherwise. 😃

I'm thinking of waiting to merge this until after 1.0.0-a1 is released, unless you want me to include these changes in a1.

[tswast]

Looks good!

I'm okay with waiting to merge this until after the a1 release.