Google Maps beta
Validate addresses, get completions and search for locations and places
by Dashkit
One-time download. No subscription.
This extension is currently in free beta. Note that the functionality can still be incomplete and that the tables can still change.
- Version 0.1.0
- Operating systems Linux & Mac (ARM)
This SQLite extension connects directly to the Google Maps Platform, allowing you to easily validate and suggest addresses and to lookup businesses and places using a live connection.
Example
Key points
- Calls Google Maps directly from your local machine
- Works with any SQLite program or programming language
- Fast in-memory cache for the duration of the connection
- One-time download, no subscription needed
- Lifetime updates
Tables 5
maps_autocomplete
Completions for an address using fields from Autocomplete Requests SKU. To use this table, your API key must be allowed to call the Places API (new).
Note that query is needed to query this table.
| Column | Type | Description |
|---|---|---|
| query | text | Text to search |
| place_id | text | Place ID |
| name | text | Full name |
| primary | text | Primary name |
| secondary | text | Additional name |
| types | json | List of place types |
maps_place_detail
Place details using fields from Place Details Enterprise SKU. To use this table, your API key must be allowed to call the Places API (new).
Note that place_id is needed to query this table.
| Column | Type | Description |
|---|---|---|
| place_id | text | Place ID |
| name | text | Name |
| primary_type | text | Primary place type |
| status | text | Place status |
| street | text | Street |
| street_number | text | Street number |
| postal | text | Postal code |
| city | text | City name |
| region | text | Region |
| country | text | Country ISO 3166 code |
| country_name | text | Country name |
| latitude | text | Latitude |
| longitude | text | Longitude |
| timezone | text | IANA database time zone |
| phone | text | International phone |
| accessibility | json | List of accessibility features |
| mail_lines | text | Mailing address lines |
| mail_postal | text | Mailing address postal code |
| mail_city | text | Mailing address city name |
| mail_region | text | Mailing address region |
| rating_average | real | Rating average |
| rating_times | int | Rated times |
| address_short | text | Short format format |
| address_long | text | Long format address |
| website_url | text | Website URL |
| maps_url | text | Google Maps URL |
maps_search_detail
Search for a location or place details using fields from Place Text Search Enterprise SKU. To use this table, your API key must be allowed to call the Places API (new).
Note that query is needed to query this table.
| Column | Type | Description |
|---|---|---|
| query | text | Text to search |
| place_id | text | Place ID |
| name | text | Name |
| primary_type | text | Primary place type |
| status | text | Place status |
| street | text | Street |
| street_number | text | Street number |
| postal | text | Postal code |
| city | text | City name |
| region | text | Region |
| country | text | Country ISO 3166 code |
| country_name | text | Country name |
| latitude | text | Latitude |
| longitude | text | Longitude |
| timezone | text | IANA database time zone |
| phone | text | International phone |
| accessibility | json | List of accessibility features |
| mail_lines | text | Mailing address lines |
| mail_postal | text | Mailing address postal code |
| mail_city | text | Mailing address city name |
| mail_region | text | Mailing address region |
| rating_average | real | Rating average |
| rating_times | int | Rated times |
| address_short | text | Short format format |
| address_long | text | Long format address |
| website_url | text | Website URL |
| maps_url | text | Google Maps URL |
maps_validate
Validate a street address using fields from Address Validation Pro SKU. To use this table, your API key must be allowed to call the Address Validation API.
Note that query is needed to query this table.
| Column | Type | Description |
|---|---|---|
| query | text | Address to validate |
| place_id | text | Place ID |
| address | text | Long format address |
| street | text | Street |
| street_number | text | Street number |
| postal | text | Postal code |
| city | text | City name |
| region | text | Region |
| country | text | Country ISO 3166 code |
| country_name | text | Country name |
| latitude | text | Latitude |
| longitude | text | Longitude |
| mail_lines | text | Mailing address lines |
| mail_postal | text | Mailing address postal code |
| mail_city | text | Mailing address city name |
| mail_region | text | Mailing address region |
| is_residential | bool | Whether address is residential |
| is_business | bool | Whether address is business |
| is_po_box | bool | Whether address is PO box |
| is_complete | bool | Whether address is complete |
| next_action | text | Suggested next action |
| missing | json | List of missing address parts |
| input_granularity | text | Input granularity |
| address_granularity | text | Validation granularity |
| geocode_granularity | text | Geocode granularity |
maps_validate_part
Validation result for each address part using fields from Address Validation Pro SKU. To use this table, your API key must be allowed to call the Address Validation API.
Note that query is needed to query this table.
| Column | Type | Description |
|---|---|---|
| query | text | Address to validate |
| name | text | Address part name |
| value | text | Address part value |
| confidence | text | Confidence level |
| is_inferred | bool | Whether part was inferred |
| is_corrected | bool | Whether part was spell-corrected |
| is_replaced | bool | Whether part was replaced with another |
| is_unexpected | bool | Whether part was unexpected but left in |
Configuration
Every new SQLite connection should call function
maps_config
with authentication details. This information is not saved,
and kept in-memory for the duration of the connection.
select maps_config('api_key: ..');
- api_key API key from Google Cloud Console
-
prefix
Prefix for table names, defaults to
maps_
FAQ
For any questions, support, or feedback regarding this extension, please contact support
Why use SQLite extensions?
SQLite extensions can make your development faster and more efficient. They are helpful for both developers and users who are comfortable with SQL. Extensions provide privacy, control, and locality to your data and credentials. Read more
Why should I try this beta extension?
This extension is currently available for free to anyone who wants to try the Google Maps extension. If you send your feedback to support, you will receive the personal version for free when it is released.
Where do I find my Google Maps API key?
Please refer to Google documentation for detailed onboarding to Google Cloud Platform.
You will need a billing-enabled account to call the Google Maps services. However, at the time of writing, a free tier is provided.
What Google APIs do I need to enable?
- Places API (new) – to get addresses and places
- Address Validation API – to validate addresses
What other software do I need?
You will need either Linux or Mac (ARM) 64-bit operating system. Windows is currently not supported.
In addition, you should have SQLite version 3.45.1 or newer installed, with support for extensions.
How do I receive updates?
We will email you when an update to the same extension version has been released.