金子邦彦研究室プログラミングRuby による Web/データベース・プログラミングJSON 時系列データの例

JSON 時系列データの例

JSON で表現されたデータを Ruby, シェルスクリプトを使って処理する例を示します

JSON ファイルを csv ファイルに変換

Ruby プログラム

この Web ページの末尾の JSON ファイルを csv ファイルに変換する Ruby プログラム. JSON ファイル名は起動時のパラメータで指定.csv ファイルは標準出力に出力される.

require 'rubygems'
require 'json'

lines = 0 
open( ARGV[0] ) {|file|
  while d = file.gets
    lines += 1
    parsed = JSON.parse(d)
    parsed.each do |key,val|
      printf "%6.6d, ", lines 
      printf "%s, ", key[0]
      printf "%6.6d, ", key[1..key.length]
      printf "%f", val
      puts "\n"
    end
  end
}
exit 

Linux コマンド

前準備として、上記の Ruby プログラムを hoge.rb というファイル名で保存しておくこと. JSON ファイル(ファイル名 1.json) を、CSV ファイルに変換した後、文字「m」を含む行を除去し、ソートして、ファイル名 1.csv で保存.

ruby hoge.rb 1.json | fgrep -v m | sort > 1.csv

JSON ファイル (ファイル名 1.json ) の先頭部分

[image]

CSV ファイル (ファイル名 1.csv ) の先頭部分

[image]

CSV ファイルの自己結合

CSV ファイルでは、通し番号が同じであるようなデータが3行に分かれている(x の値で1行,y の値で1行, z の値で1行).それを自己結合により1行にまとめる

下記のプログラムでは 1.csv ファイルを入力とし a.csv を出力とする.

rm -f /tmp/1.db
sqlite3 /tmp/1.db
create table dat (
  id  integer, 
  axis  text,
  num  integer, 
  val  number );
.mode csv
.import 1.csv dat
create table  XX  as select * from dat where axis = ' x';
create table  YY  as select * from dat where axis = ' y';
create table  ZZ  as select * from dat where axis = ' z';
create table  A   as select * from XX, YY, ZZ where XX.id = YY.id AND XX.id = ZZ.id AND XX.num = YY.num AND XX.num = ZZ.num;
.mode csv
.output a.csv
select * from A;
.exit
rm -f /tmp/1.db

CSV ファイル (ファイル名 a.csv ) の先頭部分

[image]

必要な列の抜き出し

下のプログラムでは,a.csv から 1, 3, 4, 8, 12 列目を取り出して b.csv に保存している.

cut -d , -f 1,3,4,8,12 a.csv > b.csv

以上の手順で、データファイルとして b.csv が完成する

CSV ファイル (ファイル名 b.csv ) の先頭部分

[image]

グラフ作成

3次元の散布図(gnuplot を使う場合の例)

準備

Ubuntu での実行手順例

sudo apt -y update
sudo apt -y install gnuplot-x11

3次元の散布図の作成 (b.csv から3次元の散布図を作成する)

cut -d , -f 3,4,5 b.csv | sed 's/,/ /g' > /tmp/bb.csv
gnuplot 
splot "/tmp/bb.csv"
exit

[image]

[image]

3次元の散布図(R システムを使う場合の例)

準備

Ubuntu での実行手順例

sudo apt -y update
sudo apt -y install r-cran-rgl 
sudo R
chooseCRANmirror()
install.packages('scatterplot3d')
q()

3次元の散布図の作成 (b.csv から3次元の散布図を作成する)

rm -f /tmp/bb.csv
echo '"S","N","X","Y","Z"' > /tmp/bb.csv
cat b.csv >> /tmp/bb.csv
R
library(rgl)
library(scatterplot3d)
T <- read.table("/tmp/bb.csv", header=TRUE, sep=",", na.strings="NA", dec=".", strip.white=TRUE);
T
plot3d( x = T$X, y = T$Y, z = T$Z )
q()

[image]

3次元の散布図に関する参考Web ページは、こちら

データ解析の例

rm -f /tmp/bb.csv
echo '"S","N","X","Y","Z"' > /tmp/bb.csv
cat b.csv >> /tmp/bb.csv
R
T <- read.table("/tmp/bb.csv", header=TRUE, sep=",", na.strings="NA", dec=".", strip.white=TRUE);
Y <- ( T[,c("X")] * T[,c("X")] ) + ( T[,c("Y")] * T[,c("Y")] ) + ( T[,c("Z")] * T[,c("Z")] ) 
plot(Y)
q()

[image]

より大きな実データでの例

サンプルデータ (クリックでデータファイルがダウンロードできる) (測定日: 2013/05, 測定回数: 230回,サンプル総数: 30611)

◇ gnuplot を用いた 3次元散布図

[image]

R システムを用いた 3次元散布図

[image]

◇ 「Y <- sqrt( ( T[,c("X")] * T[,c("X")] ) + ( T[,c("Y")] * T[,c("Y")] ) + ( T[,c("Z")] * T[,c("Z")] ) ) 」のプロット(R システムを使用)

[image]

JSON ファイルの例

ファイル名「1.json」で保存して使って下さい

{"y119":6.803811550140381,"y120":1.5982792377471924,"y121":6.872852802276611,"y128":1.5049054622650146,"y129":7.080511569976807,"y126":1.5120880603790283,"y127":7.10031270980835,"y124":1.4270938634872437,"y125":7.056854248046875,"y122":1.5480010509490967,"y123":6.9680328369140625,"y130":1.4031518697738647,"y131":6.976683616638184,"y132":1.418714165687561,"y101":6.840125560760498,"y100":1.6222212314605713,"y103":1.7024270296096802,"y102":1.6449662446975708,"y105":1.706018328666687,"y104":6.738496780395508,"y107":1.6461633443832397,"y106":6.696284294128418,"y114":6.712310314178467,"y113":1.704821228981018,"y112":6.694040775299072,"y111":1.5683517456054688,"y118":1.6485575437545776,"y117":1.7981951236724854,"y116":6.749040126800537,"y115":1.5910966396331787,"y110":6.687458515167236,"y108":6.690804958343506,"y109":1.5468039512634277,"y92":1.6282068490982056,"z62":9.623194694519043,"y93":6.9643731117248535,"z63":-0.9129040837287903,"y90":1.7443255186080933,"z60":9.617208480834961,"x59":10.216448783874512,"y91":6.898630619049072,"z61":-0.9238869547843933,"y96":1.6210241317749023,"x57":-0.8450035452842712,"z0":9.76205825805664,"y97":6.986303806304932,"x58":-0.8270470499992371,"z1":-0.8090861439704895,"y94":1.662922739982605,"x55":-0.8689455986022949,"y95":6.998620986938477,"x56":10.2341947555542,"x53":-0.6738181114196777,"z4":9.648333549499512,"x54":10.270713806152344,"z5":-0.8592524528503418,"y98":1.6270097494125366,"z68":9.520243644714355,"x51":-0.6642413139343262,"z2":9.720159530639648,"y99":6.937689781188965,"z69":-0.8846743106842041,"x52":10.331402778625488,"z3":-0.8431822061538696,"z66":9.656713485717773,"z8":9.85184097290039,"z67":-0.8847949504852295,"x50":10.40027904510498,"z9":-0.7567698359489441,"z64":9.60404109954834,"z6":9.73093318939209,"z65":-0.9018905758857727,"z7":-0.8140454292297363,"y9":7.447696208953857,"z50":-1.0913684368133545,"z51":9.712977409362793,"z52":-1.0193754434585571,"x66":-0.7492355108261108,"x67":10.259503364562988,"x68":-0.6474819183349609,"x69":10.306434631347656,"y0":1.1792939901351929,"x62":-0.8785223960876465,"z57":9.60523796081543,"y1":6.365993976593018,"x63":10.221165657043457,"z58":9.684247016906738,"y2":1.2259808778762817,"x64":-0.8426093459129333,"z59":-0.9475229978561401,"y3":6.617770671844482,"x65":10.236456871032715,"y4":1.2331634759902954,"z53":9.790788650512695,"y5":6.949693202972412,"z54":-0.9828903675079346,"y6":1.155351996421814,"x60":-0.910844087600708,"z55":9.624391555786133,"y7":7.237689971923828,"x61":10.211181640625,"z56":-0.9705862402915955,"y8":0.9877578616142273,"x9":9.6336030960083,"x8":-0.36975452303886414,"z80":-0.9593268632888794,"x79":-0.5349544286727905,"y74":7.2150068283081055,"z81":9.57052230834961,"y75":1.4665981531143188,"x77":-0.5744587779045105,"y72":1.5096938610076904,"x78":10.646808624267578,"y73":1.5695488452911377,"z84":-0.8416805267333984,"y70":1.5025112628936768,"z85":9.812335968017578,"y71":7.2926201820373535,"z82":-0.9048603177070618,"z83":9.596858024597168,"z88":9.826701164245605,"x71":10.388473510742188,"x6":-0.4080617427825928,"z89":-0.8761606812477112,"x72":-0.5732616782188416,"x7":9.087538719177246,"z86":-0.8363333344459534,"x4":-0.46073418855667114,"z87":9.729736328125,"x70":-0.6750152707099915,"x5":8.453352928161621,"y78":7.0527167320251465,"x75":-0.562487781047821,"x2":-0.6379051208496094,"y79":1.441459059715271,"x76":10.564563751220703,"x3":7.862987041473389,"y76":7.131173133850098,"x73":-0.5265747308731079,"x0":-0.6007949709892273,"y77":1.4522329568862915,"x74":10.479287147521973,"x1":7.505457401275635,"x88":-0.8402151465415955,"y83":1.5001169443130493,"x89":10.556329727172852,"y84":6.845762252807617,"y85":1.3947721719741821,"y86":6.825371742248535,"z70":9.790788650512695,"z71":-0.892684817314148,"y80":6.984111309051514,"z72":9.568127632141113,"y81":1.5061025619506836,"z73":9.553762435913086,"y82":6.9090495109558105,"z74":-0.8947449922561646,"x80":10.703076362609863,"z75":9.809942245483398,"x81":-0.685789167881012,"z76":-0.9182990193367004,"x82":10.71105670928955,"z77":9.832687377929688,"x83":-0.607977569103241,"z78":-0.9557034373283386,"y87":1.4510358572006226,"x84":10.66140365600586,"z79":9.680655479431152,"y88":1.5013140439987183,"x85":-0.6223428249359131,"y89":6.845999240875244,"x86":10.59405517578125,"x87":-0.8581717014312744,"x98":-0.44158056378364563,"z27":9.830292701721191,"x97":10.649658203125,"z26":-0.8158531188964844,"x96":-0.5421370267868042,"z25":9.7512845993042,"x95":10.628091812133789,"z24":-0.757616400718689,"x94":-0.6139631271362305,"z23":9.7512845993042,"x93":10.591726303100586,"z22":-0.7397757172584534,"x92":-0.9599252343177795,"z21":9.540594100952148,"x91":10.556717872619629,"z20":-0.7448341846466064,"x99":10.676383018493652,"x90":-0.8833107948303223,"z19":9.928455352783203,"z17":9.5501708984375,"z18":-0.7612037062644958,"z14":-0.7685224413871765,"z13":9.96556568145752,"z16":-0.7772020697593689,"z15":9.718962669372559,"z10":10.064924240112305,"z12":8.675090789794922,"z11":-0.7463077902793884,"z45":9.90810489654541,"z44":-1.2550733089447021,"z43":9.739313125610352,"z42":9.680655479431152,"z49":9.124003410339355,"z48":-1.1733289957046509,"z47":10.100837707519531,"z46":-1.2421882152557373,"z41":-1.2144955396652222,"z40":9.626786231994629,"z39":-1.182412028312683,"z32":9.69382381439209,"z31":-0.9572996497154236,"z34":9.659107208251953,"z33":-1.0325709581375122,"z36":9.79797077178955,"z35":-1.113292932510376,"z38":9.72853946685791,"z37":-1.1641428470611572,"z30":9.721356391906738,"z28":9.610026359558105,"z29":-0.8901019096374512,"x104":10.68280029296875,"x103":-0.3577835261821747,"x106":10.671757698059082,"x105":-0.33862990140914917,"x100":-0.2620154619216919,"x102":-0.28236615657806396,"x101":10.692033767700195,"y10":1.0069113969802856,"y11":7.570634365081787,"y12":1.5372271537780762,"y13":1.4354735612869263,"y14":7.619404315948486,"y15":1.219995379447937,"y16":7.614850997924805,"y17":1.3504793643951416,"y19":1.1409868001937866,"y18":7.569235801696777,"y20":7.513040065765381,"y23":1.2235866785049438,"y24":7.444414138793945,"y21":1.2630910873413086,"y22":7.471162796020508,"y27":1.3265373706817627,"y28":1.3121721744537354,"y25":1.2235866785049438,"y26":7.413691520690918,"z131":-1.2537636756896973,"z130":9.601646423339844,"z132":9.712977409362793,"z129":-1.2916429042816162,"y55":1.607856035232544,"y54":7.460133075714111,"z127":-1.3227802515029907,"y57":1.6246155500411987,"x10":-0.5086182355880737,"z128":9.623194694519043,"y56":7.4454216957092285,"z125":-1.3441637754440308,"y59":7.4532389640808105,"z126":9.736919403076172,"y58":1.5491981506347656,"z123":-1.3535311222076416,"z124":9.902118682861328,"z121":-1.3511251211166382,"x16":10.432708740234375,"z122":9.698612213134766,"x15":-0.4619312882423401,"x18":10.442091941833496,"z120":9.66030502319336,"x17":-0.6283283233642578,"y51":1.5695488452911377,"x12":-0.6606500148773193,"y50":7.571033954620361,"x11":10.045980453491211,"y53":1.4031518697738647,"x14":10.312873840332031,"y52":7.498645782470703,"x13":-0.8689455986022949,"x132":-0.2751835584640503,"x19":-0.5445312261581421,"x130":-0.2189198136329651,"x131":10.347212791442871,"z109":9.617208480834961,"z116":-1.3238208293914795,"y68":1.5982792377471924,"x21":-0.49784430861473083,"z117":9.156325340270996,"y67":7.428286552429199,"x20":10.40511417388916,"z118":9.812335968017578,"y66":1.5683517456054688,"z119":-1.3423349857330322,"y65":7.489441394805908,"z112":-1.247788667678833,"z113":9.554959297180176,"z99":-0.809417724609375,"z114":-1.292620301246643,"z98":9.5717191696167,"z115":9.795577049255371,"z97":-0.8029986023902893,"y69":7.359580039978027,"z96":9.691429138183594,"y60":1.5551836490631104,"x29":10.30926513671875,"z95":-0.8057662844657898,"x28":-0.4918588101863861,"z110":-1.1929986476898193,"z94":9.49271011352539,"x27":-0.6175544261932373,"z111":9.578901290893555,"z93":-0.8438918590545654,"x26":10.327570915222168,"z92":9.81832218170166,"y64":1.564760446548462,"x25":-0.5876268744468689,"z91":-0.8884397149085999,"y63":7.509433269500732,"x24":10.36109733581543,"z90":9.143157005310059,"y62":1.583914041519165,"x23":-0.5325602293014526,"x129":10.32503890991211,"y61":7.4867634773254395,"x22":10.378058433532715,"x121":10.318172454833984,"x122":-0.2560299336910248,"x123":10.295246124267578,"x124":-0.3637690246105194,"x125":10.296650886535645,"x126":-0.35179799795150757,"x127":10.309399604797363,"x128":-0.24645313620567322,"y29":7.3706560134887695,"x120":-0.3027168810367584,"z103":9.714174270629883,"y37":7.568467140197754,"z104":-0.9362896680831909,"y36":1.277456283569336,"z101":-0.8519449830055237,"y39":7.666759490966797,"z102":9.633968353271484,"y38":1.299004077911377,"z107":9.82071590423584,"y33":7.388517379760742,"x30":-0.5529109835624695,"z108":-1.1227974891662598,"y32":1.2547112703323364,"z105":9.684247016906738,"y35":7.463622570037842,"x32":-0.5588964819908142,"z106":-1.0321571826934814,"y34":1.2487257719039917,"x31":10.343093872070313,"x119":10.365269660949707,"x34":-0.433200865983963,"x118":-0.607977569103241,"x33":10.419866561889648,"x36":-0.5086182355880737,"y31":7.3550028800964355,"x35":10.501952171325684,"y30":1.2523170709609985,"x38":-0.5876268744468689,"z100":9.510666847229004,"x37":10.537332534790039,"x39":10.518660545349121,"x112":10.59987735748291,"x113":-0.4056675434112549,"x110":10.657182693481445,"x111":-0.37813422083854675,"x116":10.426187515258789,"x117":-0.49545010924339294,"x114":10.508061408996582,"x115":-0.3984849452972412,"y49":1.5958850383758545,"y48":7.649806499481201,"y47":1.3049895763397217,"y46":7.7092976570129395,"x43":-0.5086182355880737,"y45":1.3504793643951416,"x42":-0.6307225227355957,"y44":7.7382965087890625,"x41":10.494364738464355,"y43":1.300201177597046,"x40":-0.6750152707099915,"x47":-0.6115688681602478,"y42":1.3552677631378174,"x109":-0.30032268166542053,"x46":10.484780311584473,"y41":7.725969314575195,"x108":10.6702880859375,"x45":-0.6175544261932373,"y40":1.3109750747680664,"x107":-0.4308066666126251,"x44":10.488688468933105,"x49":-0.6666355133056641,"x48":10.457748413085938}
{"y92":5.142894744873047,"z62":10.255263328552246,"y93":11.610801696777344,"z63":-0.4450957477092743,"y90":5.310489177703857,"z60":12.15865421295166,"x59":10.782212257385254,"y91":11.744726181030273,"z61":-0.8507232069969177,"y96":3.7422869205474854,"x57":-0.9826701879501343,"z0":8.998308181762695,"y97":11.435277938842773,"x58":-1.2603975534439087,"z1":-1.878435730934143,"y94":3.931428909301758,"x55":-1.4267945289611816,"y95":11.487655639648438,"x56":11.321606636047363,"x53":-0.8473977446556091,"z4":8.804377555847168,"x54":11.654256820678711,"z5":-2.1750872135162354,"y98":3.4130842685699463,"z68":9.825504302978516,"x51":-0.09681553393602371,"z2":9.112031936645508,"y99":11.46005630493164,"z69":-0.4570789635181427,"x52":11.813333511352539,"z3":-1.9740912914276123,"z66":10.228927612304688,"z8":8.312369346618652,"z67":-0.23915447294712067,"x50":11.871163368225098,"z9":-2.904672622680664,"z64":9.96676254272461,"z6":8.3399019241333,"z65":-0.22274081408977509,"z7":-2.4938251972198486,"y9":13.016066551208496,"z50":-2.9170241355895996,"z51":8.627206802368164,"z52":-2.529750108718872,"x66":-1.4603134393692017,"x67":7.8771891593933105,"x68":-0.9000701904296875,"x69":7.023575305938721,"y0":2.309357166290283,"x62":-0.8761281967163086,"z57":12.696152687072754,"y1":11.044398307800293,"x63":9.382866859436035,"z58":11.884517669677734,"y2":2.2147862911224365,"x64":-0.9838672876358032,"z59":-1.3165361881256104,"y3":11.493328094482422,"x65":8.654847145080566,"y4":2.1250035762786865,"z53":9.655516624450684,"y5":12.108940124511719,"z54":-2.142669439315796,"y6":2.510470151901245,"x60":-1.1203367710113525,"z55":11.473912239074707,"y7":12.657548904418945,"x61":10.102394104003906,"z56":-1.7498297691345215,"y8":2.8719944953918457,"x9":-4.269038677215576,"x8":-1.6578350067138672,"z80":-2.9551894664764404,"x79":-1.2663830518722534,"y74":12.049138069152832,"z81":9.048585891723633,"y75":2.068739891052246,"x77":-1.1239280700683594,"y72":1.8592472076416016,"x78":3.7833023071289063,"y73":1.9598037004470825,"z84":-3.9012646675109863,"y70":1.320551872253418,"z85":10.128371238708496,"y71":11.761670112609863,"z82":-3.4413273334503174,"z83":8.737339973449707,"z88":9.305962562561035,"x71":6.1047186851501465,"x6":-1.453130841255188,"z89":-4.593958854675293,"x72":-0.8545803427696228,"x7":-4.800991535186768,"z86":-4.290631294250488,"x4":-1.1358990669250488,"z87":9.772831916809082,"x70":-1.255609154701233,"x5":-5.054276466369629,"y78":12.286938667297363,"x75":-0.7240963578224182,"x2":-0.8390180468559265,"y79":2.2411224842071533,"x76":4.415157318115234,"x3":-5.050831317901611,"y76":12.213678359985352,"x73":-0.003441664855927229,"x0":-0.5768529772758484,"y77":2.1980268955230713,"x74":5.196385860443115,"x1":-4.925732135772705,"x88":1.728763222694397,"y83":2.4817397594451904,"x89":1.5620229244232178,"y84":11.995107650756836,"y85":3.2323219776153564,"y86":11.893221855163574,"z70":9.072527885437012,"z71":-0.8270769715309143,"y80":12.25261402130127,"z72":9.777620315551758,"y81":2.5439889430999756,"z73":9.616011619567871,"y82":12.132463455200195,"z74":-1.3036811351776123,"x80":3.2323997020721436,"z75":9.040205955505371,"x81":-2.019359588623047,"z76":-1.852320671081543,"x82":2.6890029907226563,"z77":9.364620208740234,"x83":-0.1016039326786995,"z78":-2.4257290363311768,"y87":3.640533208847046,"x84":2.1825308799743652,"z79":9.003096580505371,"y88":4.257040023803711,"x85":0.4969464838504791,"y89":11.828445434570313,"x86":1.8186986446380615,"x87":0.5029320120811462,"x98":3.259855270385742,"z27":8.892963409423828,"x97":-0.7409378886222839,"z26":-5.259817600250244,"x96":2.7929859161376953,"z25":9.236531257629395,"x95":0.22381120920181274,"z24":-5.208172798156738,"x94":2.7187657356262207,"z23":8.488343238830566,"x93":0.8661905527114868,"z22":-5.086359024047852,"x92":1.6880618333816528,"z21":8.464401245117188,"x91":1.275370478630066,"z20":-4.850841999053955,"x99":-1.998579740524292,"x90":1.3744213581085205,"z19":8.36384391784668,"z17":8.895357131958008,"z18":-4.509409427642822,"z14":-3.7598161697387695,"z13":9.133580207824707,"z16":-4.1395392417907715,"z15":8.819939613342285,"z10":8.193856239318848,"z12":8.950424194335938,"z11":-3.3441617488861084,"z45":7.52587366104126,"z44":-4.140961170196533,"z43":8.382997512817383,"z42":8.603264808654785,"z49":8.41771411895752,"z48":-3.299607038497925,"z47":7.461230278015137,"y119":9.338861465454102,"z46":-3.7037534713745117,"z41":-4.569788932800293,"z40":7.622838973999023,"y120":3.908684015274048,"y121":9.124547004699707,"y126":4.926219463348389,"z39":-4.941483020782471,"y127":8.696358680725098,"y124":4.64130973815918,"y125":8.82547378540039,"y122":3.879953384399414,"y123":8.952071189880371,"z32":8.50749683380127,"z31":-5.261428356170654,"z34":8.750508308410645,"z33":-5.274336338043213,"z36":8.556577682495117,"z35":-5.285614013671875,"z38":7.737760543823242,"z37":-5.194906234741211,"z30":7.762899875640869,"z28":8.116044044494629,"z29":-5.267725944519043,"y101":11.50853157043457,"y100":3.3604116439819336,"y103":3.0970494747161865,"y102":3.21675968170166,"y105":2.886359691619873,"y104":11.484498023986816,"y107":3.263446569442749,"y106":11.339865684509277,"x104":-4.967596054077148,"x103":2.7905917167663574,"x106":-6.402013301849365,"x105":2.6828527450561523,"x100":3.2311248779296875,"x102":3.131765365600586,"x101":-3.4523115158081055,"y10":3.0336031913757324,"y11":13.138598442077637,"y12":3.0934581756591797,"y13":3.155707359313965,"y14":13.06643009185791,"y15":3.0108582973480225,"y16":12.866077423095703,"y17":3.129371166229248,"y114":9.933831214904785,"y113":4.042759418487549,"y112":10.315385818481445,"y19":2.95698881149292,"y111":4.039167881011963,"y18":12.586431503295898,"y118":3.6034231185913086,"y117":3.466953754425049,"y116":9.603753089904785,"y115":3.749469518661499,"y110":10.715654373168945,"y20":12.200554847717285,"y23":3.310133457183838,"y24":10.870931625366211,"y108":11.075542449951172,"y21":3.0970494747161865,"y109":3.705176830291748,"y22":11.634137153625488,"y27":4.683207988739014,"y28":4.76580810546875,"y25":4.058321475982666,"y26":9.958629608154297,"y55":2.75348162651062,"y54":5.57215690612793,"z127":-1.3675401210784912,"y57":2.779817819595337,"x10":-1.5931916236877441,"y56":6.296145915985107,"z125":-1.6584844589233398,"y59":7.205935955047607,"z126":8.068160057067871,"y58":2.1453542709350586,"z123":-1.8947480916976929,"z124":8.872611999511719,"z121":-2.091285467147827,"x16":-0.9648705720901489,"z122":8.48714542388916,"x15":-1.6291046142578125,"x18":0.46493780612945557,"z120":8.533832550048828,"x17":-1.7859247922897339,"y51":2.473360061645508,"x12":-1.6482582092285156,"y50":4.5990376472473145,"x11":-3.4371232986450195,"y53":3.0946552753448486,"x14":-2.304969310760498,"y52":5.036478519439697,"x13":-1.718887209892273,"x19":-1.8134582042694092,"z109":8.888175010681152,"z116":-2.4898669719696045,"y68":1.2594997882843018,"x21":-1.3717279434204102,"z117":8.742128372192383,"y67":10.750999450683594,"x20":1.9184764623641968,"z118":8.588899612426758,"y66":1.0464158058166504,"z119":-2.278604745864868,"y65":10.071117401123047,"z112":-3.0276007652282715,"z113":8.440459251403809,"z99":-5.786633491516113,"z114":-2.7327730655670166,"z98":8.590096473693848,"z115":8.621220588684082,"z97":-5.882324695587158,"y69":11.318695068359375,"z96":9.129988670349121,"y60":1.4821604490280151,"x29":7.563230514526367,"z95":-5.6686859130859375,"x28":0.8776245713233948,"z110":-3.3607468605041504,"z94":8.68945598602295,"x27":0.13542203605175018,"z111":8.537424087524414,"z93":-5.275845527648926,"x26":6.254725456237793,"z92":8.433276176452637,"y64":1.034444808959961,"x25":0.12704232335090637,"z91":-4.895121097564697,"y63":9.230903625488281,"x24":4.835643768310547,"z90":8.234557151794434,"y62":0.9602245092391968,"x23":-0.36975452303886414,"y61":8.23055648803711,"x22":3.3760323524475098,"x121":-11.059730529785156,"x122":2.863614797592163,"x123":-11.304039001464844,"x124":3.6106057167053223,"x125":-11.512168884277344,"x126":4.148104190826416,"x127":-11.703058242797852,"y29":8.957772254943848,"x120":2.822913408279419,"z103":8.3399019241333,"y37":5.12521505355835,"z104":-4.812595367431641,"y36":4.280982494354248,"z101":-5.397196292877197,"y39":4.477993965148926,"z102":8.501510620117188,"y38":4.409071922302246,"z107":8.283638954162598,"y33":6.903783798217773,"x30":0.356885701417923,"z108":-3.7223875522613525,"y32":5.630115032196045,"z105":7.968801021575928,"y35":5.953460216522217,"x32":1.033247709274292,"z106":-4.201026439666748,"y34":5.007622718811035,"x31":8.675362586975098,"x119":-10.771855354309082,"x34":1.8161516189575195,"x118":2.7654526233673096,"x33":9.539533615112305,"x36":2.552368640899658,"y31":7.9230499267578125,"x35":10.204935073852539,"y30":5.657648086547852,"x38":2.603843927383423,"z100":8.749310493469238,"x37":10.717913627624512,"x39":11.097787857055664,"x112":-9.543243408203125,"x113":2.5870845317840576,"x110":-8.732484817504883,"x111":2.7235541343688965,"x116":-10.460274696350098,"x117":2.779817819595337,"x114":-10.090046882629395,"x115":2.6349685192108154,"y49":2.4170961380004883,"y48":4.220487594604492,"y47":2.7175686359405518,"y46":3.966723918914795,"x43":0.22520460188388824,"y45":3.2921769618988037,"x42":0.8620622754096985,"y44":3.906731605529785,"x41":11.404873847961426,"y43":4.076278209686279,"x40":1.9969139099121094,"x47":-0.685789167881012,"y42":4.904671669006348,"x109":2.6996121406555176,"x46":11.799138069152832,"y41":4.070096492767334,"x108":-7.670559406280518,"x45":-0.35419222712516785,"y40":4.735880374908447,"x107":2.5727193355560303,"x44":11.649395942687988,"x49":-0.8031050562858582,"x48":11.86572265625}