GetLatitudeLongitude ( ukPostcode )

Retuns a value list with the latitude and longitude for a UK Postcode.

Average rating: 4.6 (26 votes) Log in to vote

ChrisJ
CJ
http://gmail.com

Sample input:

GetLatitudeLongitude ( "SW1A 2AA" )

Sample output:

51.503540
-0.127681

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( 
[
_source = GetURLasText( "http://uk-postcodes.com/postcode/" & Substitute ( ukPostcode ; " " ; "" ) & ".xml" ) ; 
_lat = Middle ( _source ; Position ( _source ; "<lat>" ; 1 ; 1 ) + 5 ; Position ( _source ; "</lat>" ; 1 ; 1 ) - Position ( _source ; "<lat>" ; 1 ; 1 ) -5 ) ;
_lng = Middle ( _source ; Position ( _source ; "<lng>" ; 1 ; 1 ) + 5 ; Position ( _source ; "</lng>" ; 1 ; 1 ) - Position ( _source ; "<lng>" ; 1 ; 1  ) -5 ) 
]; 

_lat & ¶ & _lng

)

Retuns a value list with the latitude and longitude for a UK Postcode. Requires internet access and 360ScriptMaster Plugin with GetURLasText registered.

Comments

		Anatole Beams, Anatole Beams Digital Media Jun 21, 2023
I think uk-postcodes.com is not available any more. Does anyone know if there any other alternative sites that work with this function?

		Anatole Beams, Anatole Beams Digital Media Jun 21, 2023
Further to my previous comment, you can substitute the service from Fetchify into the function: http://pcls1.craftyclicks.co.uk/json/geocode?key=xxxxx-xxxxx-xxxxx-xxxxx&postcode=SW1A2AA (Note: you have to register to receive an access key)

		Anatole Beams, Anatole Beams Digital Media Jun 21, 2023
... plus the returned text gives you Lat/Long, OS coords, country code, country, nhs region, county code, admin codes, district, & ward

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetLatitudeLongitude ( ukPostcode )

Comments

Support this website.

Support this website.