Turning an array of arrays into objects with jq#

Input:

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

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

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

This outputs:

1
[
2
  {
3
    "id": "mm.domus.SW230",
4
    "name": " A LA RONDE",
5
    "category": "Buildings:Houses:Medium houses",
6
    "latitude": 50.642781,
7
    "longitude": -3.405508
8
  },
9
  {
10
    "id": "mm.domus.SW193",
11
    "name": " ALEXANDER KEILLER MUSEUM",
12
    "category": "Archaeology:Prehistory",
13
    "latitude": 51.427927,
14
    "longitude": -1.857344
15
  },
16
  {
17
    "id": "mm.domus.SE416",
18
    "name": " ANNE OF CLEVES HOUSE MUSEUM",
19
    "category": "Buildings:Houses:Medium houses",
20
    "latitude": 50.869227,
21
    "longitude": 0.005329
22
  }
23
]

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

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