3 ms·
Breasal is a handy tool for doing the conversion. https://github.com/theodi/breasal https://github.com/theodi/breasal
by petepete 11y ago
Breasal is a handy tool for doing the conversion.
https://github.com/theodi/breasal https://github.com/theodi/breasal
- ZenoArrow 11y agoThanks for the tip. I'm planning on doing this conversion soon, I intended to use the following C# library as a SQL Server CLR function, but I probably would've used breasal (or something similar) if I was using Linux: https://code.google.com/p/geocoordconversion/ https://code.google.com/p/geocoordconversion/ For anyone who wants to use this C# library, worth reading this: http://webcache.googleusercontent.com/search?q=cache:er_vqaKhr3YJ:www.adathedev.co.uk/2013/03/gb-post-code-importer-conversion.html+&cd=2&hl=en&ct=clnk&gl=uk&client=opera http://webcache.googleusercontent.com/search?q=cache:er_vqaK...
- petepete 11y agoAnother good source of UK Postcode data is doogal.co.uk. The author (Chris Bell) combines the Codepoint Open dataset with other ones from the ONS; that gives a more comprehensive list of postcodes (including ones that are no-longer in use and codes in Northern Ireland and the Isle of Man). In his datasets he's already done the conversion to regular lat/lon. http://www.doogal.co.uk/UKPostcodes.php http://www.doogal.co.uk/UKPostcodes.php
- rmc 11y agoConversion between any 2 arbitary spatial reference systems (e.g. to/from lat/long) is quite easy and trivial with any GIS library. PostGIS can do it with "ST_Transform(ST_SetSRID(ST_Point(X, Y), ORIGINAL_SRS), 4326)"