CartoDB latlon change to lonlat

Question

I have this script I am trying to use to search for a value within a CartoDB table. I can't seem to figure out how to reverse the order of the lat & long coordinates so they appear as lonlat... instead of latlon

Here is what I am trying to do:

function parcelSearch(layer) {
        var sql = new cartodb.SQL({ user: 'dchadney' });
        var $options = $('#searchParcel');
        $options.click(function(e) {
            var streetNam = document.getElementById('parcelid').value;
            if(streetNam === "") {
                alert("Please enter the parcel ID");
            } else {
                query = "SELECT * FROM parcels_sa WHERE parcel_id ILIKE '%" + streetNam + "%'";
                console.log(query);
                layer.getSubLayer(0).show();

                sql.getBounds(query).done(function(bounds) {
                    latlon = bounds[0];
                    console.log(latlon);

                    $('.latlongit').val(latlon);
                   // map.fitBounds(bounds);
                });

                    $('#step1').modal('hide');
                    $('#step1A').hide('fast');
                    setTimeout(function() {
                    $("#submitModal").modal({
                    backdrop: 'static'
                    });
                    }, 7000);
                    $('button#step3indicator').addClass('active');  
                    $('.line2').css('width', '42%');  
            }

            // change the query in the layer to update the map
            layer.setSQL(query);

        });

Seems to me that latlon is a function coming from leaflet? How do I modify this?

Answer 1

I'm pretty sure the CartoDB javascript API is the Leaflet API, so have a look at their doco: http://leafletjs.com/reference.html#latlng

You can either just pull the values out of there, something like this:

var coord = L.latLng(50.5, 30.5);
var lng = coord.lng;
var lat = coord.lat;

Or you could store it as your own object, like this:

var lnglat = {lng:12.33, lat:44.11};
var lat = lnglat.lat;
var lng = lnglat.lng;

But perhaps if you describe what you're actually trying to do, there will be a more elegant way of doing it than reversing the values?

Answer 2

You can access to the specific coordinates of the bounds this way:

            console.log(bounds[0][0]);
            console.log(bounds[0][1]);
            console.log(bounds[1][0]);
            console.log(bounds[1][1]);

But take into account that in the bounds you'll have two coordinates that form the two corners of the bounding box, so perhaps you want to try to get the center of the box by using:

            console.log((bounds[0][0]+bounds[1][0]/2));
            console.log((bounds[0][1]+bounds[1][1]/2));