Skip to main content

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DanM
Contributor II
Contributor II

Return US Postal Code from GeoOperation? (Qlik Sense Cloud)

Greetings!

I have a GEOJson file and would like to know which zipcodes are within the Polygon.

Trying some of the examples using Within and not really finding it returning the PostalCode

Is there a place to look up the different datasources?

 

Here is the sample I was trying and it just returns the state names, not the zip code

MyPoints:
LOAD *
inline "
id;point
1;[-108.1,45.4]
2;[-98.9,40.1]
3;[12.1,57.7]
" (delimiter is ';');


PointsInStates:
Load * Extension GeoOperations.ScriptEval('
Within()
DATASOURCE ZIP LOCATIONSERVICE geometry="AREA", type="Admin1", country="us"
', MyPoints);

 

 

DanM_0-1654537860487.png

 

Labels (1)
3 Replies
Patric_Nordstrom
Employee
Employee

For reverse geocoding on zip or address level, we recommend using Qlik Geocoding.

See https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoOperationsService/Content/connector/connector...

MyAddressPoints: LOAD * inline " 
id;point 1;[-108.1,45.4]
2;[-98.9,40.1]
3;[12.1,57.7] " (delimiter is ';');
Load * Extension GeoOperations.ScriptEval(' PointToAddressLookup() ', MyAddressPoints);

Geocoding requires an additional license.

 

Thanks,

Patric

DanM
Contributor II
Contributor II
Author

Do you have example of  working with Zip code data in the US?

I always get this error, is there a way to limit to a state? or County?

The following error occurred:

Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'GEOOPS-402: Failed to create dataset ZIP: Too large dataset . Maximum allowed is 150000000 bytes.'

The error occurred here:

PointsInStates: Load * Extension GeoOperations.ScriptEval(' Within() DATASOURCE ZIP LOCATIONSERVICE geometry="AREA", type="PostalCode", country="us" ', MyPoints)

Patric_Nordstrom
Employee
Employee

Fyi, we're looking into ways to increase the limits so all us zip codes can be loaded.