Yunique

SELECT CAST(SUBSTRING_INDEX(column, 'D', -1) as UNSIGNED) AS col
FROM table
ORDER BY col;

SELECT  substring_index(substring_index(coordinates, '"', -4), '"', 1) AS latitude,
              substring_index(substring_index(coordinates, '"', -2), '"', 1) AS longitude
FROM mapper;