Good location services

Location lookups are a part of pretty much every app these days, but I constantly find myself searching for good data providers or services to give me what I need. Here is a list of some good ones, some of which I have used first hand. Hopefully this will help someone hours of Googling!

https://www.townslist.co.uk – UK town list service, updated regularly, Paid

http://www.sqldumpster.com/databases/geographic/ – Many geo databases, infrequent updates, Free

http://dev.maxmind.com/geoip/geoip2/geolite2/ – The daddy of location services, not cheap, but fast and pretty accurate. Their CSVs are massive and can be a nightmare to tailor to your app.

https://www.freemaptools.com/download-uk-postcode-lat-lng.htm – UK postcode database, last updated 2015, Free

 

Web deploy and TLS V1.0

Recently I have been using the excellent IISCrypto tool to lock down some servers for PCI compliance. One of the main steps in this process was to close off TLS V1.0.  In the past on Windows 2008R2, this was a problem as disabling it used to kill RDP services too. However on Windows 2012 boxes, the default is TLS V1.2 so you can safely do this.

The gotcha came when using web deploy to push my applications to this server, connections failed to the server. This was a client issue. By default, my Windows 10 install seems to be defaulting to TLS V1.0.

To fix the issue, a registry edit is required.  Simply create a .reg file with the exact content below, run it, happy days again.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]
"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319]
"SchUseStrongCrypto"=dword:00000001