Turning an array of arrays into objects with jq

Input:

[
    ["mm.domus.SW230"," A LA RONDE","Buildings:Houses:Medium houses",50.642781,-3.405508],
    ["mm.domus.SW193"," ALEXANDER KEILLER MUSEUM","Archaeology:Prehistory",51.427927,-1.857344],
    ["mm.domus.SE416"," ANNE OF CLEVES HOUSE MUSEUM","Buildings:Houses:Medium houses",50.869227,0.005329],
]

I want an array of objects. Here's what I came up with, using jqplay.org:

[.[] | {id: .[0], name: .[1], category: .[2], latitude: .[3], longitude: .[4]}]

This outputs:

[
  {
    "id": "mm.domus.SW230",
    "name": " A LA RONDE",
    "category": "Buildings:Houses:Medium houses",
    "latitude": 50.642781,
    "longitude": -3.405508
  },
  {
    "id": "mm.domus.SW193",
    "name": " ALEXANDER KEILLER MUSEUM",
    "category": "Archaeology:Prehistory",
    "latitude": 51.427927,
    "longitude": -1.857344
  },
  {
    "id": "mm.domus.SE416",
    "name": " ANNE OF CLEVES HOUSE MUSEUM",
    "category": "Buildings:Houses:Medium houses",
    "latitude": 50.869227,
    "longitude": 0.005329
  }
]

If you remove the outer [ and ] and use the "Compact output" option you get back this instead:

{"id":"mm.domus.SW230","name":" A LA RONDE","category":"Buildings:Houses:Medium houses","latitude":50.642781,"longitude":-3.405508}
{"id":"mm.domus.SW193","name":" ALEXANDER KEILLER MUSEUM","category":"Archaeology:Prehistory","latitude":51.427927,"longitude":-1.857344}
{"id":"mm.domus.SE416","name":" ANNE OF CLEVES HOUSE MUSEUM","category":"Buildings:Houses:Medium houses","latitude":50.869227,"longitude":0.005329}

Related

• jq Flattening nested JSON objects with jq - 2021-03-11
• jq Converting no-decimal-point latitudes and longitudes using jq - 2021-03-11
• jq Extracting objects recursively with jq - 2021-07-24
• jq Loading radio.garden into SQLite using jq - 2021-02-17
• jq Converting Airtable JSON for use with sqlite-utils using jq - 2020-08-28
• jq Convert git log output to JSON using jq - 2023-03-25
• gpt3 Using GPT-3 to figure out jq recipes - 2022-08-10
• observable Using jq in an Observable notebook - 2023-03-25
• postgresql Constructing GeoJSON in PostgreSQL - 2021-04-24
• reddit Scraping Reddit via their JSON API - 2021-06-21

Created 2021-05-25T08:33:46-07:00 · Edit