| Column Name | Column Data Type |
|---|
index_name Required Input Column
The name of the place index resource that you want to use for the search. | VARCHAR |
place_id Required Input Column
The identifier of the place to find. | VARCHAR |
key Input Column
The optional API key to authorize the request. | VARCHAR |
language Input Column
The preferred language used to return results. The value must be a valid BCP 47 language tag, for example, en for English. This setting affects the languages used in the results, but not the results themselves. If no language is specified, or not supported for a particular result, the partner automatically chooses a language for the result. For an example, we'll use the Greek language. You search for a location around Athens, Greece, with the language parameter set to en. The city in the results will most likely be returned as Athens. If you set the language parameter to el, for Greek, then the city in the results will more likely be returned as Αθήνα. If the data provider does not have a value for Greek, the result will be in a language that the provider does support. | VARCHAR |
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
place
Details about the result, such as its address and position. | STRUCT(
"label" VARCHAR,
"geometry" STRUCT(
"point" DOUBLE[]
),
"address_number" VARCHAR,
"street" VARCHAR,
"neighborhood" VARCHAR,
"municipality" VARCHAR,
"sub_region" VARCHAR,
"region" VARCHAR,
"country" VARCHAR,
"postal_code" VARCHAR,
"interpolated" BOOLEAN,
"time_zone" STRUCT(
"name" VARCHAR,
"offset" BIGINT
),
"unit_type" VARCHAR,
"unit_number" VARCHAR,
"categories" VARCHAR[],
"supplemental_categories" VARCHAR[],
"sub_municipality" VARCHAR
) |
Show child fields- place.address_number
The numerical portion of an address, such as a building number. - place.categories[]
- place.country
A country/region specified using ISO 3166 3-digit country/region code. For example, CAN. - place.geometry
Places uses a point geometry to specify a location or a Place. Show child fields- place.geometry.point[]
- place.interpolated
True if the result is interpolated from other known places. False if the Place is a known place. Not returned when the partner does not provide the information. For example, returns False for an address location that is found in the partner data, but returns True if an address does not exist in the partner data and its location is calculated by interpolating between other known addresses. - place.label
The full name and address of the point of interest such as a city, region, or country. For example, 123 Any Street, Any Town, USA. - place.municipality
A name for a local area, such as a city or town name. For example, Toronto. - place.neighborhood
The name of a community district. For example, Downtown. - place.postal_code
A group of numbers and letters in a country-specific format, which accompanies the address for the purpose of identifying a location. - place.region
A name for an area or geographical division, such as a province or state name. For example, British Columbia. - place.street
The name for a street or a road to identify a location. For example, Main Street. - place.sub_municipality
An area that's part of a larger municipality. For example, Blissville is a submunicipality in the Queen County in New York. This property supported by Esri and OpenData. The Esri property is district, and the OpenData property is borough. - place.sub_region
A county, or an area that's part of a larger region. For example, Metro Vancouver. - place.supplemental_categories[]
- place.time_zone
The time zone in which the Place is located. Returned only when using HERE or Grab as the selected partner. Show child fields- place.time_zone.name
The name of the time zone, following the IANA time zone standard. For example, America/Los_Angeles. - place.time_zone.offset
The time zone's offset, in seconds, from UTC.
- place.unit_number
For addresses with multiple units, the unit identifier. Can include numbers and letters, for example 3B or Unit 123. Returned only for a place index that uses Esri or Grab as a data provider. Is not returned for SearchPlaceIndexForPosition. - place.unit_type
For addresses with a UnitNumber, the type of unit. For example, Apartment. Returned only for a place index that uses Esri as a data provider.
|