Skip to content
AWS for Query.Farm

aws.iotwireless.get_position_estimate

Example SQL Queries

SELECT * FROM
aws.iotwireless.get_position_estimate;

Description

Get estimated position information as a payload in GeoJSON format. The payload measurement data is resolved using solvers that are provided by third-party vendors.

Table Definition

Column NameColumn Data Type
cell_towers Input Column

Retrieves an estimated device position by resolving measurement data from cellular radio towers. The position is resolved using HERE's cellular-based solver.

STRUCT(
    "gsm" STRUCT(
        "mcc" BIGINT,
        "mnc" BIGINT,
        "lac" BIGINT,
        "geran_cid" BIGINT,
        "gsm_local_id" STRUCT(
            "bsic" BIGINT,
            "bcch" BIGINT
        ),
        "gsm_timing_advance" BIGINT,
        "rx_level" BIGINT,
        "gsm_nmr" STRUCT(
            "bsic" BIGINT,
            "bcch" BIGINT,
            "rx_level" BIGINT,
            "global_identity" STRUCT(
                "lac" BIGINT,
                "geran_cid" BIGINT
            )
        )[]
    )[],
    "wcdma" STRUCT(
        "mcc" BIGINT,
        "mnc" BIGINT,
        "lac" BIGINT,
        "utran_cid" BIGINT,
        "wcdma_local_id" STRUCT(
            "uarfcndl" BIGINT,
            "psc" BIGINT
        ),
        "rscp" BIGINT,
        "path_loss" BIGINT,
        "wcdma_nmr" STRUCT(
            "uarfcndl" BIGINT,
            "psc" BIGINT,
            "utran_cid" BIGINT,
            "rscp" BIGINT,
            "path_loss" BIGINT
        )[]
    )[],
    "tdscdma" STRUCT(
        "mcc" BIGINT,
        "mnc" BIGINT,
        "lac" BIGINT,
        "utran_cid" BIGINT,
        "tdscdma_local_id" STRUCT(
            "uarfcn" BIGINT,
            "cell_params" BIGINT
        ),
        "tdscdma_timing_advance" BIGINT,
        "rscp" BIGINT,
        "path_loss" BIGINT,
        "tdscdma_nmr" STRUCT(
            "uarfcn" BIGINT,
            "cell_params" BIGINT,
            "utran_cid" BIGINT,
            "rscp" BIGINT,
            "path_loss" BIGINT
        )[]
    )[],
    "lte" STRUCT(
        "mcc" BIGINT,
        "mnc" BIGINT,
        "eutran_cid" BIGINT,
        "tac" BIGINT,
        "lte_local_id" STRUCT(
            "pci" BIGINT,
            "earfcn" BIGINT
        ),
        "lte_timing_advance" BIGINT,
        "rsrp" BIGINT,
        "rsrq" DOUBLE,
        "nr_capable" BOOLEAN,
        "lte_nmr" STRUCT(
            "pci" BIGINT,
            "earfcn" BIGINT,
            "eutran_cid" BIGINT,
            "rsrp" BIGINT,
            "rsrq" DOUBLE
        )[]
    )[],
    "cdma" STRUCT(
        "system_id" BIGINT,
        "network_id" BIGINT,
        "base_station_id" BIGINT,
        "registration_zone" BIGINT,
        "cdma_local_id" STRUCT(
            "pn_offset" BIGINT,
            "cdma_channel" BIGINT
        ),
        "pilot_power" BIGINT,
        "base_lat" DOUBLE,
        "base_lng" DOUBLE,
        "cdma_nmr" STRUCT(
            "pn_offset" BIGINT,
            "cdma_channel" BIGINT,
            "pilot_power" BIGINT,
            "base_station_id" BIGINT
        )[]
    )[]
)
Show child fields
cell_towers.cdma[]
Show child fields
cell_towers.cdma[].base_lat

CDMA base station latitude in degrees.

cell_towers.cdma[].base_lng

CDMA base station longitude in degrees.

cell_towers.cdma[].base_station_id

CDMA base station ID (BSID).

cell_towers.cdma[].cdma_local_id

CDMA local identification (local ID) parameters.

Show child fields
cell_towers.cdma[].cdma_local_id.cdma_channel

CDMA channel information.

cell_towers.cdma[].cdma_local_id.pn_offset

Pseudo-noise offset, which is a characteristic of the signal from a cell on a radio tower.

cell_towers.cdma[].cdma_nmr[]
Show child fields
cell_towers.cdma[].cdma_nmr[].base_station_id

CDMA base station ID (BSID).

cell_towers.cdma[].cdma_nmr[].cdma_channel

CDMA channel information.

cell_towers.cdma[].cdma_nmr[].pilot_power

Transmit power level of the pilot signal, measured in dBm (decibel-milliwatts).

cell_towers.cdma[].cdma_nmr[].pn_offset

Pseudo-noise offset, which is a characteristic of the signal from a cell on a radio tower.

cell_towers.cdma[].network_id

CDMA network ID (NID).

cell_towers.cdma[].pilot_power

Transmit power level of the pilot signal, measured in dBm (decibel-milliwatts).

cell_towers.cdma[].registration_zone

CDMA registration zone (RZ).

cell_towers.cdma[].system_id

CDMA system ID (SID).

cell_towers.gsm[]
Show child fields
cell_towers.gsm[].geran_cid

GERAN (GSM EDGE Radio Access Network) Cell Global Identifier.

cell_towers.gsm[].gsm_local_id

GSM local identification (local ID) information.

Show child fields
cell_towers.gsm[].gsm_local_id.bcch

GSM broadcast control channel.

cell_towers.gsm[].gsm_local_id.bsic

GSM base station identity code (BSIC).

cell_towers.gsm[].gsm_nmr[]
Show child fields
cell_towers.gsm[].gsm_nmr[].bcch

GSM broadcast control channel.

cell_towers.gsm[].gsm_nmr[].bsic

GSM base station identity code (BSIC).

cell_towers.gsm[].gsm_nmr[].global_identity

Global identity information of the GSM object.

Show child fields
cell_towers.gsm[].gsm_nmr[].global_identity.geran_cid

GERAN (GSM EDGE Radio Access Network) cell global identifier.

cell_towers.gsm[].gsm_nmr[].global_identity.lac

Location area code of the global identity.

cell_towers.gsm[].gsm_nmr[].rx_level

Rx level, which is the received signal power, measured in dBm (decibel-milliwatts).

cell_towers.gsm[].gsm_timing_advance

Timing advance value, which corresponds to the length of time a signal takes to reach the base station from a mobile phone.

cell_towers.gsm[].lac

Location area code.

cell_towers.gsm[].mcc

Mobile Country Code.

cell_towers.gsm[].mnc

Mobile Network Code.

cell_towers.gsm[].rx_level

Rx level, which is the received signal power, measured in dBm (decibel-milliwatts).

cell_towers.lte[]
Show child fields
cell_towers.lte[].eutran_cid

E-UTRAN (Evolved Universal Terrestrial Radio Access Network) Cell Global Identifier.

cell_towers.lte[].lte_local_id

LTE local identification (local ID) information.

Show child fields
cell_towers.lte[].lte_local_id.earfcn

Evolved universal terrestrial radio access (E-UTRA) absolute radio frequency channel number (FCN).

cell_towers.lte[].lte_local_id.pci

Physical cell ID.

cell_towers.lte[].lte_nmr[]
Show child fields
cell_towers.lte[].lte_nmr[].earfcn

E-UTRA (Evolved universal terrestrial Radio Access) absolute radio frequency channel Number (EARFCN).

cell_towers.lte[].lte_nmr[].eutran_cid

E-UTRAN (Evolved Universal Terrestrial Radio Access Network) cell global identifier (EUTRANCID).

cell_towers.lte[].lte_nmr[].pci

Physical cell ID.

cell_towers.lte[].lte_nmr[].rsrp

Signal power of the reference signal received, measured in dBm (decibel-milliwatts).

cell_towers.lte[].lte_nmr[].rsrq

Signal quality of the reference Signal received, measured in decibels (dB).

cell_towers.lte[].lte_timing_advance

LTE timing advance.

cell_towers.lte[].mcc

Mobile Country Code.

cell_towers.lte[].mnc

Mobile Network Code.

cell_towers.lte[].nr_capable

Parameter that determines whether the LTE object is capable of supporting NR (new radio).

cell_towers.lte[].rsrp

Signal power of the reference signal received, measured in dBm (decibel-milliwatts).

cell_towers.lte[].rsrq

Signal quality of the reference Signal received, measured in decibels (dB).

cell_towers.lte[].tac

LTE tracking area code.

cell_towers.tdscdma[]
Show child fields
cell_towers.tdscdma[].lac

Location Area Code.

cell_towers.tdscdma[].mcc

Mobile Country Code.

cell_towers.tdscdma[].mnc

Mobile Network Code.

cell_towers.tdscdma[].path_loss

Path loss, or path attenuation, is the reduction in power density of an electromagnetic wave as it propagates through space.

cell_towers.tdscdma[].rscp

Signal power of the received signal (Received Signal Code Power), measured in decibel-milliwatts (dBm).

cell_towers.tdscdma[].tdscdma_local_id

TD-SCDMA local identification (local ID) information.

Show child fields
cell_towers.tdscdma[].tdscdma_local_id.cell_params

Cell parameters for TD-SCDMA.

cell_towers.tdscdma[].tdscdma_local_id.uarfcn

TD-SCDMA UTRA (Universal Terrestrial Radio Access Network) absolute RF channel number (UARFCN).

cell_towers.tdscdma[].tdscdma_nmr[]
Show child fields
cell_towers.tdscdma[].tdscdma_nmr[].cell_params

Cell parameters for TD-SCDMA network measurement reports object.

cell_towers.tdscdma[].tdscdma_nmr[].path_loss

Path loss, or path attenuation, is the reduction in power density of an electromagnetic wave as it propagates through space.

cell_towers.tdscdma[].tdscdma_nmr[].rscp

Code power of the received signal, measured in decibel-milliwatts (dBm).

cell_towers.tdscdma[].tdscdma_nmr[].uarfcn

TD-SCDMA UTRA (Universal Terrestrial Radio Access Network) absolute RF channel number.

cell_towers.tdscdma[].tdscdma_nmr[].utran_cid

UTRAN (UMTS Terrestrial Radio Access Network) cell global identifier.

cell_towers.tdscdma[].tdscdma_timing_advance

TD-SCDMA Timing advance.

cell_towers.tdscdma[].utran_cid

UTRAN (UMTS Terrestrial Radio Access Network) Cell Global Identifier.

cell_towers.wcdma[]
Show child fields
cell_towers.wcdma[].lac

Location Area Code.

cell_towers.wcdma[].mcc

Mobile Country Code.

cell_towers.wcdma[].mnc

Mobile Network Code.

cell_towers.wcdma[].path_loss

Path loss, or path attenuation, is the reduction in power density of an electromagnetic wave as it propagates through space.

cell_towers.wcdma[].rscp

Received Signal Code Power (signal power) (dBm).

cell_towers.wcdma[].utran_cid

UTRAN (UMTS Terrestrial Radio Access Network) Cell Global Identifier.

cell_towers.wcdma[].wcdma_local_id

WCDMA local ID information.

Show child fields
cell_towers.wcdma[].wcdma_local_id.psc

Primary Scrambling Code.

cell_towers.wcdma[].wcdma_local_id.uarfcndl

WCDMA UTRA Absolute RF Channel Number downlink.

cell_towers.wcdma[].wcdma_nmr[]
Show child fields
cell_towers.wcdma[].wcdma_nmr[].path_loss

Path loss, or path attenuation, is the reduction in power density of an electromagnetic wave as it propagates through space.

cell_towers.wcdma[].wcdma_nmr[].psc

Primary Scrambling Code.

cell_towers.wcdma[].wcdma_nmr[].rscp

Received Signal Code Power (signal power) (dBm)

cell_towers.wcdma[].wcdma_nmr[].uarfcndl

WCDMA UTRA Absolute RF Channel Number downlink.

cell_towers.wcdma[].wcdma_nmr[].utran_cid

UTRAN (UMTS Terrestrial Radio Access Network) Cell Global Identifier.

gnss Input Column

Retrieves an estimated device position by resolving the global navigation satellite system (GNSS) scan data. The position is resolved using the GNSS solver powered by LoRa Cloud.

STRUCT(
    "payload" VARCHAR,
    "capture_time" DOUBLE,
    "capture_time_accuracy" DOUBLE,
    "assist_position" DOUBLE[],
    "assist_altitude" DOUBLE,
    "use2_d_solver" BOOLEAN
)
Show child fields
gnss.assist_altitude

Optional assistance altitude, which is the altitude of the device at capture time, specified in meters above the WGS84 reference ellipsoid.

gnss.assist_position[]
gnss.capture_time

Optional parameter that gives an estimate of the time when the GNSS scan information is taken, in seconds GPS time (GPST). If capture time is not specified, the local server time is used.

gnss.capture_time_accuracy

Optional value that gives the capture time estimate accuracy, in seconds. If capture time accuracy is not specified, default value of 300 is used.

gnss.payload

Payload that contains the GNSS scan result, or NAV message, in hexadecimal notation.

gnss.use2_d_solver

Optional parameter that forces 2D solve, which modifies the positioning algorithm to a 2D solution problem. When this parameter is specified, the assistance altitude should have an accuracy of at least 10 meters.

ip Input Column

Retrieves an estimated device position by resolving the IP address information from the device. The position is resolved using MaxMind's IP-based solver.

STRUCT(
    "ip_address" VARCHAR
)
Show child fields
ip.ip_address

IP address information.

timestamp Input Column

Optional information that specifies the time when the position information will be resolved. It uses the Unix timestamp format. If not specified, the time at which the request was received will be used.

TIMESTAMP_S
wi_fi_access_points Input Column

Retrieves an estimated device position by resolving WLAN measurement data. The position is resolved using HERE's Wi-Fi based solver.

STRUCT(
    "mac_address" VARCHAR,
    "rss" BIGINT
)[]
Show child fields
wi_fi_access_points[]
Show child fields
wi_fi_access_points[].mac_address

Wi-Fi MAC Address.

wi_fi_access_points[].rss

Received signal strength (dBm) of the WLAN measurement data.

_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.

_aws_region Input Column

The AWS region to use.

VARCHAR
geo_json_payload

The position information of the resource, displayed as a JSON payload. The payload is of type blob and uses the GeoJSON format, which a format that's used to encode geographic data structures. A sample payload contains the timestamp information, the WGS84 coordinates of the location, and the accuracy and confidence level. For more information and examples, see Resolve device location (console).

BLOB