Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
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.