topic Re: Global Zip codes. Best done in JMP or SAS? in Discussions

Global Zip codes. Best done in JMP or SAS?

Residentx — Sun, 11 Jun 2023 11:18:40 GMT

ISO has standards for zipcodes around the world. Is this feature available in JMP, SAS or Both.

I guess since this is a JMP forum, I should limit this to JMP.

Here's the ISO standard, https://en.wikipedia.org/wiki/ISO_3166-2

China I need to map. China has prefectures but they have these subvisions at the local level.

Also, is there a way to list both chinese simpllified, chinese traditional, romanized or all?

Thanks in advance.

Re: Global Zip codes. Best done in JMP or SAS?

Craige_Hales — Wed, 27 Oct 2021 12:03:14 GMT

https://www.iso.org/glossary-for-iso-3166.html

seems to be a good explainer for

https://www.iso.org/iso-3166-country-codes.html

which seems to offer a way to get some information about standard names for large regions.

I don't think it offers anything for what I'd call zip codes in the US. I believe it goes to the state level, probably not to the county or city level.

Depending what you are trying to do, you might find these interesting

https://osmnames.org/

https://www.maptiler.com/news/2016/10/osmnames-place-names-data-geocoder/

https://github.com/OSMNames/OSMNames

Also: boundaries and place names change. One or more additional counties appeared in the US during the 1980s, when SAS/Graph was producing county level maps for the first time. It was an eye-opener. https://www.census.gov/programs-surveys/geography/technical-documentation/county-changes.1980.html . It is impossible to stay completely up-to-date. https://xkcd.com/1688/

A reminder about ZIP codes in the US is in .

Re: Global Zip codes. Best done in JMP or SAS?

Residentx — Wed, 27 Oct 2021 15:19:37 GMT

My question is whether this is integrated into JMP so I can display it in graphs. I can do this in excel now but not all areas.

Do you need me to list some examples with picture? I have files now for oblasts in Ukraine.

Re: Global Zip codes. Best done in JMP or SAS?

Craige_Hales — Thu, 28 Oct 2021 00:30:30 GMT

Pictures might help, and maybe an indication of what you've tried so far, and what you are trying to accomplish.

JMP 16 has a few maps built in (so do earlier versions of JMP.) I did this with a big class graph by right->click add a map and right-click->customize (to thicken+color the line and clip the simple earth bitmap to the border.)

Mainland China Provinces

dt=open("$sample_data/big class.jmp");
dt<<Graph Builder(
	Size( 1190, 900 ),
	Show Control Panel( 0 ),
	Variables( X( :weight ), Y( :height ) ),
	Elements( Points( X, Y, Legend( 3 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"weight",
			ScaleBox,
			{Scale( "Geodesic" ), Min( 78.9121725050727 ), Max( 131.391068563684 ),
			Inc( 10 ), Minor Ticks( 1 )}
		),
		Dispatch(
			{},
			"height",
			ScaleBox,
			{Scale( "Geodesic" ), Min( 17.4684154783393 ), Max( 55.4083033940635 ),
			Inc( 5 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{Background Map(
				Images( "Simple Earth" ),
				Boundaries( "Mainland China Provinces" )
			), Marker Size( 1 ), Marker Drawing Mode( "Normal" ),
			Grid Line Order( 3 ), Reference Line Order( 4 ),
			DispatchSeg(
				MapSeg( 1 ),
				{Clip Shape( Boundaries( "Mainland China Provinces" ) )}
			), DispatchSeg( Shape Seg( 1 ), {Color( "Black" ), Line Width( 3 )} )}
		)
	)
);

If these are not the boundaries you need, you can use SHP files to make them. I've not been through the process, but others have: https://www.google.com/search?q=jmp+shp+file shows several hits.

You might also look at the street map overlay and see if that does what you need.

Re: Global Zip codes. Best done in JMP or SAS?

Residentx — Thu, 28 Oct 2021 02:35:56 GMT

@Craige_Hales @Craig

This looks good but let me show you what I've done or tried in Excel and we'll start there. I didn't use lat/long though.

I work on JMP the next few days so I'll compare and post back.

Re: Global Zip codes. Best done in JMP or SAS?

Residentx — Fri, 29 Oct 2021 07:51:36 GMT

I recreated some of it tonight but I have to do it better. Excel has the ability to pull the shapefiles. I don't have to load them. I give the ISO code and they plot them.

Re: Global Zip codes. Best done in JMP or SAS?

Residentx — Fri, 29 Oct 2021 07:52:35 GMT