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

Leveraging the Wikia API

What is the best way to assign a specific attribute to just one type within a hierarchy of inherited classes?

Transform a traditional class component into a functional component

Mastering the Art of Integrating API and JSON!

Struggling with continuously re-rendering a color background when using useMemo in React?

I need help with customizing the progress bar in HTML and CSS

"Uncaught ReferenceError: $ is not defined in a JavaScript/Vue.js

Angular2's change detection mechanism does not behave as anticipated after receiving a message from a Worker

Angular 4 encounters performance issues when rendering numerous base64 images simultaneously

Organize the JSON formatting in cakePHP for optimal output

Automatically shutting windows using jQuery after a certain number of seconds

Tips for accessing information from an Angular Resource promise

Creating dynamic rows for Firebase data in React BootstrapTable can be accomplished by dynamically rendering each row

ES6 promises: the art of connecting functions with parameters

What are the various ways to display time zone in a different format?

The latest version of Spring MVC, 4.1.x, is encountering a "Not Acceptable" error while trying

Outputting a variable using javascript

What could be causing the Uncaught ReferenceError message that says scrollToM is not defined in my code?

Retrieve data from Json array

Checking with Protractor to see if the modal is displayed