weenie_properties_position
Data license: AGPL · Data source: ACEmulator Project
16,766 rows
This data as json, CSV (advanced)
id ▼ | object_Id | position_Type | obj_Cell_Id | origin_X | origin_Y | origin_Z | angles_W | angles_X | angles_Y | angles_Z |
---|---|---|---|---|---|---|---|---|---|---|
1 | 4 4 | 8040 | 3583639587 | 118.682 | 58.5182 | 330.934 | 0.468932 | 0.0 | 0.0 | -0.883235 |
2 | 27547 27547 | 8040 | 3465871412 | 158.128 | 95.0613 | 20.0 | 0.810591 | 0.0 | 0.0 | -0.585612 |
3 | 300 300 | 8040 | 2519662651 | 191.394 | 65.6744 | 82.9304 | 0.610286 | 0.610286 | -0.357144 | -0.357144 |
4 | 305 305 | 8040 | 2536964131 | 99.4278 | 71.7332 | 31.6237 | 0.653282 | 0.653282 | -0.270598 | -0.270598 |
5 | 3599 3599 | 8040 | 1481769411 | 77.5419 | -186.843 | -0.071 | 0.46969 | 0.46969 | -0.528575 | -0.528575 |
6 | 3601 3601 | 8040 | 2309029889 | 17.5833 | 8.78472 | 95.3679 | 0.828489 | 0.0 | 0.0 | -0.560006 |
7 | 3603 3603 | 8040 | 2847146009 | 83.0837 | 8.8176 | 93.929 | 0.683356 | 0.683356 | -0.181729 | -0.181729 |
8 | 4183 4183 | 8040 | 565903367 | 4.43277 | 151.087 | 95.9295 | 0.707107 | 0.707107 | 0.0 | 0.0 |
9 | 4186 4186 | 8040 | 22217440 | 18.0686 | -48.3792 | -18.071 | -0.480897 | -0.480897 | -0.518399 | -0.518399 |
10 | 5304 5304 | 8040 | 2536964124 | 94.4654 | 75.5638 | 32.0993 | 0.612373 | 0.612373 | -0.353553 | -0.353553 |
11 | 5306 5306 | 8040 | 1415119196 | 120.813 | -91.718 | -0.071 | 0.606606 | 0.606606 | 0.363359 | 0.363359 |
12 | 5307 5307 | 8040 | 1415119192 | 106.751 | -100.133 | -0.071 | -0.506649 | -0.506649 | -0.493261 | -0.493261 |
13 | 5308 5308 | 8040 | 1415119315 | 49.9749 | -62.6717 | 5.929 | -0.019975 | -0.019975 | -0.706825 | -0.706825 |
14 | 5309 5309 | 8040 | 1415119190 | 108.566 | -80.1141 | -0.076 | 0.499188 | 0.499188 | 0.50081 | 0.50081 |
15 | 5310 5310 | 8040 | 2847146025 | 135.072 | 22.779 | 94.11 | -0.79192 | 0.0 | 0.0 | -0.610625 |
16 | 5312 5312 | 8040 | 1415119322 | 49.9423 | -97.5993 | 5.924 | 0.706992 | 0.706992 | -0.012727 | -0.012727 |
17 | 5313 5313 | 8040 | 1486880827 | 183.881 | 60.1079 | 13.9295 | 0.701369 | 0.701369 | -0.089895 | -0.089895 |
18 | 5315 5315 | 8040 | 1665663750 | 99.0587 | -133.751 | -0.071 | 0.696743 | 0.696743 | -0.120623 | -0.120623 |
19 | 5316 5316 | 8040 | 3332964379 | 83.9101 | 66.6714 | 42.11 | 0.434404 | 0.0 | 0.0 | -0.900718 |
20 | 5317 5317 | 8040 | 2847080471 | 51.1396 | 159.342 | 94.1896 | 0.615346 | 0.615346 | -0.348353 | -0.348353 |
21 | 5318 5318 | 8040 | 1481769411 | 76.8766 | -192.933 | -0.071 | 0.527394 | 0.527394 | -0.471016 | -0.471016 |
22 | 7995 7995 | 8040 | 2847146025 | 125.566 | 23.5565 | 93.929 | 0.695581 | 0.695581 | -0.12715 | -0.12715 |
23 | 11002 11002 | 8040 | 549060641 | 104.044 | 6.46554 | 89.9305 | 0.707107 | 0.707107 | 0.0 | 0.0 |
24 | 15280 15280 | 8040 | 1415119312 | 40.6726 | -95.178 | 5.9355 | 0.583656 | 0.583656 | 0.399182 | 0.399182 |
25 | 15282 15282 | 8040 | 2711879690 | 37.4384 | 38.2371 | 55.0868 | 0.240374 | 0.0 | 0.0 | -0.97068 |
26 | 15285 15285 | 8040 | 2451701776 | 45.4038 | 177.423 | 105.361 | 0.02043 | 0.02043 | -0.706812 | -0.706812 |
27 | 15287 15287 | 8040 | 1415119184 | 104.882 | -80.0185 | -0.0645 | 0.509167 | 0.509167 | 0.490662 | 0.490662 |
28 | 15292 15292 | 8040 | 1415119104 | 163.447 | -19.8336 | -6.0645 | 0.492646 | 0.492646 | -0.507247 | -0.507247 |
29 | 15293 15293 | 8040 | 1415119172 | 67.9028 | -79.7243 | -0.0645 | -0.4949 | -0.4949 | -0.505049 | -0.505049 |
30 | 15295 15295 | 8040 | 1415119184 | 104.882 | -80.0185 | -0.0645 | 0.509167 | 0.509167 | 0.490662 | 0.490662 |
31 | 15429 15429 | 8040 | 1520697347 | 9.7232 | 55.2281 | 53.9474 | 0.068097 | 0.068097 | -0.70382 | -0.70382 |
32 | 15431 15431 | 8040 | 2295332920 | 157.216 | 185.178 | 166.136 | -0.061353 | -0.061353 | -0.70444 | -0.70444 |
33 | 15432 15432 | 8040 | 1615200999 | 100.022 | -60.0076 | 17.9305 | 0.707107 | 0.707107 | 0.0 | 0.0 |
34 | 15433 15433 | 8040 | 1615134985 | 68.9295 | -53.5716 | -36.07 | 0.707107 | 0.707107 | 0.0 | 0.0 |
35 | 15434 15434 | 8040 | 23855555 | 64.1088 | -42.4529 | 0.441499 | -0.665718 | -0.665718 | -0.23837 | -0.23837 |
36 | 15435 15435 | 8040 | 3102408708 | 20.9287 | 90.2634 | 37.3897 | -0.973943 | 0.0 | 0.0 | -0.226792 |
37 | 15436 15436 | 8040 | 32833803 | 133.426 | -19.7441 | -36.071 | 0.269832 | 0.269832 | -0.653598 | -0.653598 |
38 | 15437 15437 | 8040 | 3600351239 | 1.21029 | 150.376 | 373.929 | -0.653055 | -0.653055 | -0.271145 | -0.271145 |
39 | 15438 15438 | 8040 | 1503920149 | 55.7578 | 114.711 | 59.029 | 0.401753 | 0.401753 | -0.581889 | -0.581889 |
40 | 15440 15440 | 8040 | 1615201068 | 19.9082 | -59.9994 | 23.93 | 0.707107 | 0.707107 | 0.0 | 0.0 |
41 | 15441 15441 | 8040 | 791740439 | 61.2894 | 167.984 | 59.7108 | -0.69241 | -0.69241 | -0.143417 | -0.143417 |
42 | 15442 15442 | 8040 | 1615266611 | 99.0006 | -79.8988 | -0.0695 | 0.5 | 0.5 | -0.5 | -0.5 |
43 | 15444 15444 | 8040 | 4061528110 | 127.025 | 126.951 | -0.071 | 0.707107 | 0.707107 | 0.0 | 0.0 |
44 | 21348 21348 | 8040 | 2114192393 | 202.778 | -360.78 | -0.071 | 0.0 | 0.0 | -0.707107 | -0.707107 |
45 | 21350 21350 | 8040 | 3629514800 | 29.825 | 18.7167 | 28.8554 | 0.191267 | 0.191267 | -0.680747 | -0.680747 |
46 | 21352 21352 | 8040 | 2114192363 | 190.648 | -382.192 | -0.071 | 0.0 | 0.0 | -0.707107 | -0.707107 |
47 | 31715 31715 | 8040 | 2847146009 | 84.0157 | 8.61947 | 93.9295 | -0.637797 | -0.637797 | -0.305311 | -0.305311 |
48 | 31716 31716 | 8040 | 2847146018 | 97.4673 | 28.0318 | 93.9295 | -0.105625 | -0.105625 | -0.699174 | -0.699174 |
49 | 35489 35489 | 8040 | 1481834871 | 62.706 | -200.029 | 5.929 | 0.461699 | 0.461699 | -0.535569 | -0.535569 |
50 | 35621 35621 | 8040 | 2103705619 | 56.6924 | 46.9816 | 11.929 | -0.702912 | -0.702912 | -0.07691 | -0.07691 |
51 | 35622 35622 | 8040 | 16056659 | 29.96 | -77.8149 | -0.071 | 0.707107 | 0.707107 | 0.0 | 0.0 |
52 | 36389 36389 | 8040 | 23855549 | 51.1047 | -37.9493 | -0.071 | 0.310611 | 0.310611 | -0.635233 | -0.635233 |
53 | 36520 36520 | 8040 | 1481703684 | 21.7774 | -21.9567 | -0.071 | -0.05813 | -0.05813 | -0.704713 | -0.704713 |
54 | 36521 36521 | 8040 | 1500184847 | 120.0 | -9.975 | -0.071 | -0.5 | -0.5 | -0.5 | -0.5 |
55 | 36522 36522 | 8040 | 2847146009 | 78.5382 | 1.93576 | 95.1024 | -0.623728 | 0.0 | 0.0 | -0.781642 |
56 | 38780 38780 | 8040 | 3332898832 | 36.7828 | 187.29 | 41.929 | -0.223869 | -0.223869 | -0.670733 | -0.670733 |
57 | 38782 38782 | 8040 | 23855445 | 7.78006 | -55.9775 | 1.21294 | 0.748311 | 0.0 | 0.0 | -0.663348 |
58 | 38849 38849 | 8040 | 2315452941 | 223.002 | -352.984 | -0.071 | 0.0 | 0.0 | -0.707107 | -0.707107 |
59 | 43134 43134 | 8040 | 445644850 | 165.269 | 31.622 | 67.4721 | 0.707038 | 0.707038 | -0.009876 | -0.009876 |
60 | 43150 43150 | 8040 | 23855673 | 96.0678 | -55.5369 | -0.071 | -0.65983 | -0.65983 | -0.254214 | -0.254214 |
61 | 43151 43151 | 8040 | 3111059486 | 83.6784 | 134.305 | 8.9039 | 0.214502 | 0.214502 | 0.673787 | 0.673787 |
62 | 43152 43152 | 8040 | 1481834771 | 31.0403 | -32.1619 | -0.071 | -0.149591 | -0.149591 | -0.691102 | -0.691102 |
63 | 43942 43942 | 8040 | 43058012 | 209.423 | -158.614 | -0.071 | -0.000845 | -0.000845 | -0.707106 | -0.707106 |
64 | 43951 43951 | 8040 | 1676148772 | 117.383 | 86.7828 | 131.49 | 0.64305 | 0.64305 | -0.294087 | -0.294087 |
65 | 43953 43953 | 8040 | 306577452 | 131.821 | 88.7934 | 51.929 | 0.65754 | 0.65754 | -0.260078 | -0.260078 |
66 | 43956 43956 | 8040 | 43058115 | 208.872 | -13.6959 | 17.929 | -0.706532 | -0.706532 | -0.028505 | -0.028505 |
67 | 43957 43957 | 8040 | 4061528110 | 127.022 | 126.923 | -0.071 | -0.651288 | -0.651288 | -0.27536 | -0.27536 |
68 | 43958 43958 | 8040 | 3583574079 | 187.18 | 162.547 | 373.929 | 0.470749 | 0.470749 | 0.527632 | 0.527632 |
69 | 44212 44212 | 8040 | 306577452 | 131.324 | 91.2249 | 51.929 | -0.653276 | -0.653276 | -0.270611 | -0.270611 |
70 | 44213 44213 | 8040 | 15073584 | 130.117 | -51.3805 | -48.071 | 0.41808 | 0.41808 | -0.570271 | -0.570271 |
71 | 44214 44214 | 8040 | 1994981420 | 139.449 | 83.5902 | 105.695 | -0.418003 | -0.418003 | -0.570327 | -0.570327 |
72 | 44368 44368 | 8040 | 306577453 | 133.289 | 102.154 | 51.4179 | -0.322637 | -0.322637 | -0.62921 | -0.62921 |
73 | 44369 44369 | 8040 | 23855554 | 60.525 | -33.1823 | -0.071 | -0.390358 | -0.390358 | -0.589594 | -0.589594 |
74 | 44376 44376 | 8040 | 18809102 | 28.6099 | -29.4684 | 0.125126 | -0.707103 | -0.707103 | -0.0024 | -0.0024 |
75 | 44383 44383 | 8040 | 306577664 | 133.508 | 68.4295 | 46.729 | -0.702707 | -0.702707 | -0.078759 | -0.078759 |
76 | 44385 44385 | 8040 | 3332964402 | 161.181 | 32.9271 | 41.929 | -0.195765 | -0.195765 | -0.679467 | -0.679467 |
77 | 46629 46629 | 8040 | 1482818435 | 209.995 | -380.022 | -0.0735 | 0.5 | 0.5 | -0.5 | -0.5 |
78 | 46630 46630 | 8040 | 1499529482 | 23.6392 | -86.0883 | 1.20131 | -0.26624 | 0.0 | 0.0 | -0.963907 |
79 | 46631 46631 | 8040 | 1289945117 | 79.2394 | 108.132 | 58.5148 | -0.336939 | -0.336939 | -0.621669 | -0.621669 |
80 | 46632 46632 | 8040 | 1289945114 | 81.5502 | 44.9679 | 68.3262 | -0.351266 | -0.351266 | -0.613687 | -0.613687 |
81 | 47057 47057 | 8040 | 2456617018 | 188.487 | 45.8703 | 13.162 | 0.653282 | 0.653282 | -0.270598 | -0.270598 |
82 | 47058 47058 | 8040 | 2393309225 | 136.178 | 6.90009 | 49.0766 | 0.011293 | 0.011293 | -0.707017 | -0.707017 |
83 | 47059 47059 | 8040 | 3747676460 | 59.9879 | 19.1189 | 17.9265 | 0.01064 | 0.01064 | -0.707027 | -0.707027 |
84 | 47060 47060 | 8040 | 3432316950 | 57.122 | 135.565 | 21.9883 | 0.5 | 0.5 | -0.5 | -0.5 |
85 | 47061 47061 | 8040 | 2273771576 | 153.098 | 171.077 | 111.526 | -0.609815 | -0.609815 | -0.357946 | -0.357946 |
86 | 47062 47062 | 8040 | 2273771576 | 152.869 | 173.336 | 111.526 | -0.514584 | -0.514584 | -0.484977 | -0.484977 |
87 | 47063 47063 | 8040 | 669908994 | 10.655 | 30.711 | 7.9265 | 0.421474 | 0.421474 | -0.567767 | -0.567767 |
88 | 47064 47064 | 8040 | 1587740725 | 164.975 | 105.424 | 37.6741 | 0.541675 | 0.541675 | -0.45452 | -0.45452 |
89 | 47065 47065 | 8040 | 873332785 | 155.823 | 1.90974 | -0.5205 | -0.496799 | -0.496799 | -0.503181 | -0.503181 |
90 | 47066 47066 | 8040 | 1615135315 | 90.025 | -90.0057 | -6.071 | 0.707107 | 0.707107 | 0.0 | 0.0 |
91 | 47067 47067 | 8040 | 1615135278 | 30.025 | -70.0063 | -6.0705 | 0.707107 | 0.707107 | 0.0 | 0.0 |
92 | 47068 47068 | 8040 | 151715843 | 14.3835 | 53.1437 | 15.9305 | -0.706632 | -0.706632 | -0.025907 | -0.025907 |
93 | 47069 47069 | 8040 | 15073907 | 29.9961 | -84.0906 | -12.0695 | -0.002973 | -0.002973 | -0.707101 | -0.707101 |
94 | 47070 47070 | 8040 | 15074329 | 181.318 | -23.9661 | -0.0695 | 0.707107 | 0.707107 | 0.0 | 0.0 |
95 | 47071 47071 | 8040 | 4147183668 | 149.157 | 84.9461 | 47.924 | -0.256249 | -0.256249 | -0.659042 | -0.659042 |
96 | 47072 47072 | 8040 | 4150001702 | 104.55 | 133.281 | 31.2527 | 0.305187 | 0.305187 | -0.637857 | -0.637857 |
97 | 47513 47513 | 8040 | 1482555667 | 60.0064 | -39.9751 | -0.071 | 0.505172 | 0.505172 | 0.494774 | 0.494774 |
98 | 47853 47853 | 8040 | 1620705323 | 135.256 | 58.3485 | 6.0315 | -0.616102 | -0.616102 | 0.347014 | 0.347014 |
99 | 47855 47855 | 8040 | 22479144 | 36.979 | -30.8208 | -6.0685 | 0.244814 | 0.244814 | -0.663375 | -0.663375 |
100 | 47857 47857 | 8040 | 32899341 | 110.258 | -171.624 | -24.0685 | 0.707107 | 0.707107 | 0.0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "weenie_properties_position" ( [id] INTEGER PRIMARY KEY, [object_Id] INTEGER REFERENCES [weenie]([class_Id]), [position_Type] INTEGER, [obj_Cell_Id] INTEGER, [origin_X] FLOAT, [origin_Y] FLOAT, [origin_Z] FLOAT, [angles_W] FLOAT, [angles_X] FLOAT, [angles_Y] FLOAT, [angles_Z] FLOAT ); CREATE INDEX [idx_weenie_properties_position_object_Id] ON [weenie_properties_position] ([object_Id]);