Guide on extracting data from a specific column in an object and converting it into a list using JavaScript

Question

Guide on extracting data from a specific column in an object and converting it into a list using JavaScript

Imagine we are working with the following JSON information

var example = [{
    latitude: 11.1111,
    longitude: 111.111,
    name: "for example1",
    altitude: 88
},
{
    latitude: 22.2222,
    longitude: 222.222,
    name: "for example2",
    altitude: 89
},
{
    latitude: 33.3333,
    longitude: 333.333,
    name: "for example3",
    altitude: 90
}
]

I am looking to extract only the latitude and longitude data from the list or object provided, as my Map API in my react-native application specifically requires this information. Due to performance concerns, I cannot use a loop to achieve this. While querying a database like MySQL separately could solve this problem, I am hesitant to take this approach as it may not be ideal. (I would appreciate any alternate suggestions if available)

Thank you for taking the time to read this. How would you recommend solving this issue?

javascript arrays json react-native object

Answer 1

Answer №1

Here's a solution for you. It creates a fresh array containing only latitude and longitude properties from objects.

const filteredArray = originalArray.map(item => {
    return {
        lat: item.lat,
        long: item.long
    }  
})

Answer 2

Here's a solution for you. It creates a fresh array containing only latitude and longitude properties from objects.

const filteredArray = originalArray.map(item => {
    return {
        lat: item.lat,
        long: item.long
    }  
})

Answer 3

Answer №2

sample.map(element => ('lat' && 'lon') in element && element);

Answer 4

sample.map(element => ('lat' && 'lon') in element && element);

Answer 5

Answer №3

Transforming the data from example using ES6 arrow functions: example.map(({latitude, longitude}) => ({latitude, longitude}))

Necessitated by the Map API in my react-native application.

Would an iterator solution suffice?

[edit]

Creating a generator function to transform the data in 'example' object:
const projected = ( function* () {
  for (record of example) yield {
    latitude:  record.latitude,
    longitude: record.longitude,
  };
})()

Answer 6

Transforming the data from example using ES6 arrow functions: example.map(({latitude, longitude}) => ({latitude, longitude}))

Necessitated by the Map API in my react-native application.

Would an iterator solution suffice?

[edit]

Creating a generator function to transform the data in 'example' object:
const projected = ( function* () {
  for (record of example) yield {
    latitude:  record.latitude,
    longitude: record.longitude,
  };
})()

Answer 7

Answer №4

It seems like you are attempting to store all the filtered data in your database. Is that correct? If so, one approach could be to map or loop through the data first as follows ->

const filteredData = example.map(({latitude, longitude}) => ({latitude, longitude}));

Afterwards, you can bulk insert into your MySQL database. Here is an example of how you can do this ->

INSERT INTO tbl_name(col1, col2, col3) VALUES(val1, val2, val3), (val4, val5, val6), (val7, val8, val9);

Answer 8

It seems like you are attempting to store all the filtered data in your database. Is that correct? If so, one approach could be to map or loop through the data first as follows ->

const filteredData = example.map(({latitude, longitude}) => ({latitude, longitude}));

Afterwards, you can bulk insert into your MySQL database. Here is an example of how you can do this ->

INSERT INTO tbl_name(col1, col2, col3) VALUES(val1, val2, val3), (val4, val5, val6), (val7, val8, val9);

Guide on extracting data from a specific column in an object and converting it into a list using JavaScript

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

Next.js encountered an issue: React.Children.only function was expecting to receive only one React element child, but received more

Access a folder in JavaScript using Flask

Issue with reCAPTCHA callback in Firebase Phone Authentication not functioning as expected

Exploring AngularJS Navigation in Windows 8 App Store Applications

Displaying a div when a radio button is clicked in React

How does gray-matter function in Node.js affect the matter within?

PHP: In search of an optimal method to iterate through arrays to find matching elements

How does the onclick event trigger even without physically clicking the button?

Modify an HTML table and record any modifications as POST requests using Javascript

Analyzing the network requests of a specified URL with Python programming

What could be causing my Node application to give a 404 error when making a POST request?

Issues with FullCalendar functionality in CakePHP 1.2.5 are arising when using jQuery version 1.4.1

Executing program through Socket.io alert

Having difficulty utilizing the express.session module in conjunction with HTTPS

Refresh the content with an embedded iframe

Is it more advantageous to create two distinct projects for the frontend and backend along with an API, or should I consolidate them into a

Is it possible to capture a submit event from a form within an iframe using jQuery or JavaScript

PHP's json_encode() compared to using an empty NSDictionary in iOS development

Is it advisable to send an object as an argument in a function?

Animate the transition effect as soon as the block is displayed