GeoAnalytics

[pedrobergo]

Hello,

I'm testing the GeoAnalytics connector, I choose TRAVELAREAS function to identify the vendors overlapping areas. Always get this error message:

QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset AreaCliente: Malformed POINT geometry: -19.3101506.

[TravelAreas]:

SQL SELECT * FROM TravelAreas(dataset='AreaCliente',costValue='2',costField='',costUnit='Hours',transportation='car')

DATASOURCE AreaCliente INLINE tableName='Clientes',tableFields='CHAVE_CLIENTE,LATITUDE,LOGITUDE',geometryType='POINT',loadDistinct='YES',suffix='',crs='Auto' {CHAVE_CLIENTE LATITUDE LOGITUDE

0102205201 -19.3101506 -48.9277299

(...)

0103820901 -19.3101506 -48.9277299}

I check the post QVX_SYNTAX_ERROR Failed to process query Failed to create dataset  but its didn´t work for me.

Follow my connection parameters:

Where is the error? Can I fix this?

Tks,

Pedro

[Patric_Nordstrom · Accepted solution]

Hi Pedro,

Choose "Latitude, longitude point" instead of Point.

The geometry type "Latitude, longitude point" is when there are two separate fields for latitude and longitude.

Point is a point string in one field: '[lat, long]'

Thanks,

Patric

[pedrobergo]

Ok, It´s working now !

Tks a lot !

Pedro

[Glaci]

Hi Pedro almost the same problem hapened with me, but in my table have 2 field for Latitude, longitude, i had choose the option "Latitude, longitude point" and doesnt working 

for each city hapened this error:

Ocorreram os seguintes erros:

Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset POINTS: Invalid latitude or longitude value in CSV, [,]

O erro ocorreu aqui:

[ClusterAssociations]: SQL SELECT [CH_UF_MUNICIPIO], [Clusters_ClusterID] FROM Cluster(distance='100000', dataset='POINTS') DATASOURCE POINTS INLINE tableName='ESTRUTURA', tableFields='CH_UF_MUNICIPIO,LATITUDE,LONGITUDE', geometryType='POINTLATLON', loadDistinct='NO', suffix='', crs='Auto' {CH_UF_MUNICIPIO LATITUDE LONGITUDE ROCACOAL -11,433865028685 -61,442944211822