These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Solar System Static Data Annomolies.
Author
Previous Topic Next Topic
stu2000
Perkone
Caldari State
#1 - 2012-07-23 21:28:06 UTC  |  Edited by: stu2000
Dear all,
I am confused by the static data. I discovered that if you run the query:
SELECT * FROM `mapSolarSystemJumps` GROUP BY `toSolarSystemID`
you discover there are just 5,428 systems according to that table. The same result occurs if you group by fromSolarSystemID

However, there are 7,929 systems in the mapSolarSystems table.

Also, whilst doing some breadth first searches on some systems, I am not getting up to 5,427 systems, though this could just be a bug in my code.

Are there some systems that have no stargates to jump in and out of?

Are some groups of systems separated by wormholes? or perhaps some of the systems form 'wormhole' space, and the other systems are the 'normal' systems?

Regards,
Stu

---
The following system ids are found in the systems table but do not appear in the mapSolarSystemJumps table

30000377 30000380 30000381 31000007 31000008 31000009 31000010 31000011 31000012 31000013 31000014 31000015 31000016 31000017 31000018 31000019 31000020 31000021 31000022 31000023 31000024 31000025 31000026 31000027 31000028 31000029 31000030 31000031 31000032 31000033 31000034 31000035 31000036 31000037 31000038 31000039 31000040 31000041 31000042 31000043 31000044 31000045 31000046 31000047 31000048 31000049 31000050 31000051 31000052 31000053 31000054 31000055 31000056 31000057 31000058 31000059 31000060 31000061 31000062 31000063 31000064 31000065 31000066 31000067 31000068 31000069 31000070 31000071 31000072 31000073 31000074 31000075 31000076 31000077 31000078 31000079 31000080 31000081 31000082 31000083 31000084 31000085 31000086 31000087 31000088 31000089 31000090 31000091 31000092 31000093 31000094 31000095 31000096 31000097 31000098 31000099 31000100 31000101 31000102 31000103 31000104 31000105 31000106 31000107 31000108 31000109 31000110 31000111 31000112 31000113 31000114 31000115 31000116 31000117 31000118 31000119 31000120 31000121 31000122 31000123 31000124 31000125 31000126 31000127 31000128 31000129 31000130 31000131 31000132 31000133 31000134 31000135 31000136 31000137 31000138 31000139 31000140 31000141 31000142 31000143 31000144 31000145 31000146 31000147 31000148 31000149 31000150 31000151 31000152 31000153 31000154 31000155 31000156 31000157 31000158 31000159 31000160 31000161 31000162 31000163 31000164 31000165 31000166 31000167 31000168
...
stu2000
Perkone
Caldari State
#2 - 2012-07-23 22:00:06 UTC
continued....
31000169 31000170 31000171 31000172 31000173 31000174 31000175 31000176 31000177 31000178 31000179 31000180 31000181 31000182 31000183 31000184 31000185 31000186 31000187 31000188 31000189 31000190 31000191 31000192 31000193 31000194 31000195 31000196 31000197 31000198 31000199 31000200 31000201 31000202 31000203 31000204 31000205 31000206 31000207 31000208 31000209 31000210 31000211 31000212 31000213 31000214 31000215 31000216 31000217 31000218 31000219 31000220 31000221 31000222 31000223 31000224 31000225 31000226 31000227 31000228 31000229 31000230 31000231 31000232 31000233 31000234 31000235 31000236 31000237 31000238 31000239 31000240 31000241 31000242 31000243 31000244 31000245 31000246 31000247 31000248 31000249 31000250 31000251 31000252 31000253 31000254 31000255 31000256 31000257 31000258 31000259 31000260 31000261 31000262 31000263 31000264 31000265 31000266 31000267 31000268 31000269 31000270 31000271 31000272 31000273 31000274 31000275 31000276 31000277 31000278 31000279 31000280 31000281 31000282 31000283 31000284 31000285 31000286 31000287 31000288 31000289 31000290 31000291 31000292 31000293 31000294 31000295 31000296 31000297 31000298 31000299 31000300 31000301 31000302 31000303 31000304 31000305 31000306 31000307 31000308 31000309 31000310 31000311
31000312 31000313 31000314 31000315 31000316 31000317 31000318 31000319 31000320 31000321 31000322 31000323 31000324 31000325 31000326 31000327 31000328 31000329 31000330 31000331 31000332 31000333 31000334 31000335 31000336 31000337 31000338 31000339 31000340 31000341 31000342 31000343 31000344 31000345 31000346 31000347 31000348 31000349 31000350 31000351 31000352 31000353 31000354 31000355 31000356 31000357 31000358 31000359 31000360 31000361 31000362 31000363 31000364 31000365 31000366 31000367 31000368 31000369 31000370 31000371 31000372 31000373 31000374 31000375 31000376 31000377 31000378 31000379 31000380 31000381 31000382 31000383 31000384 31000385 31000386 31000387 31000388 31000389 31000390 31000391 31000392 31000393 31000394 31000395 31000396 31000397 31000398 31000399 31000400 31000401 31000402 31000403 31000404 31000405 31000406 31000407 31000408 31000409 31000410 31000411 31000412 31000413 31000414 31000415 31000416 31000417 31000418 31000419 31000420 31000421 31000422 31000423 31000424 31000425 31000426 31000427 31000428 31000429 31000430 31000431 31000432 31000433 31000434 31000435 31000436 31000437 31000438 31000439 31000440 31000441 31000442 31000443 31000444 31000445 31000446 31000447 31000448 31000449 31000450 31000451 31000452 31000453 31000454 31000455 31000456 31000457 31000458 31000459 31000460 31000461 31000462 31000463 31000464 31000465 31000466 31000467 31000468 31000469 31000470 31000471 31000472 31000473 31000474 31000475 31000476 31000477 31000478 31000479 31000480 31000481 31000482 31000483 31000484 31000485 31000486 31000487 31000488 31000489 31000490 31000491 31000492 31000493 31000494 31000495 31000496 31000497 31000498 31000499 31000500 31000501 31000502 31000503 31000504 31000505 31000506 31000507 31000508 31000509 31000510 31000511 31000512 31000513 31000514 31000515 31000516 31000517 31000518 31000519 31000520 31000521 31000522 31000523 31000524 31000525 31000526 31000527 31000528 31000529 31000530 31000531 31000532 31000533 31000534 31000535 31000536 31000537 31000538 31000539 31000540 31000541 31000542 31000543 31000544 31000545 31000546 31000547 31000548 31000549 31000550 31000551 31000552 31000553 31000554 31000555 31000556 31000557 31000558 31000559 31000560 31000561 31000562 31000563 31000564 31000565 31000566 31000567 31000568 31000569 31000570 31000571 31000572 31000573 31000574 31000575 31000576 3100057
Cyerus
University of Caille
Gallente Federation
#3 - 2012-07-23 23:12:39 UTC  |  Edited by: Cyerus
I didn't check the ids you mentioned, but wormhole systems are in the that table too.
And as we all know, wormhole systems don't have gates.
stu2000
Perkone
Caldari State
#4 - 2012-07-24 06:59:43 UTC
I have never been in wormhole space and did not know this so thank you Im guessing all the systems that start with id 31xxxx are wormhole space and the others that start 30xxx are not.
Desmont McCallock
#5 - 2012-07-24 07:04:32 UTC
There are no gates to the Jove (CCP) region.
stu2000
Perkone
Caldari State
#6 - 2012-07-24 08:00:21 UTC
Desmont McCallock wrote:
There are no gates to the Jove (CCP) region.

aha! this is probably the main thing I was looking for. I take it this region has gates within it though?
Desmont McCallock
#7 - 2012-07-24 08:08:49 UTC
AFAIK, yes.
stu2000
Perkone
Caldari State
#8 - 2012-07-24 08:21:38 UTC
Im trying to look up Jove's region id (in order to find the matching solar system ids and exclude these systems) however I cannot find it in the mapRegions Table, but I do see: J7HZ-F this isnt it is it?

Stu
Desmont McCallock
#9 - 2012-07-24 08:41:51 UTC
CCP Region: UUA-F4 ID: 10000004

Jove Empire
Region: A821-A ID: 10000019
Region: J7HZ-F ID: 10000017
stu2000
Perkone
Caldari State
#10 - 2012-07-24 19:15:31 UTC
thanks! after adding all of the systems tied to those regions to an ignore list I can see there is no 'bug' in my breadth first search and all remaining systems are connected.
Helios Mech'ai
Native Freshfood
Minmatar Republic
#11 - 2012-09-10 12:09:41 UTC
Yup, 2498 wormhole systems plus the 3 CCP ones mentioned above Big smile
Seara Arrodan
Whiskey and Cigars
#12 - 2012-09-10 15:39:29 UTC
3 Jove "Systems" or 3 Jove "Regions" if regions how many systems does that contain?

Hmm.... Not sure if troll?...
Byteflux
Stimulus
Rote Kapelle
#13 - 2012-09-10 19:48:59 UTC
Seara Arrodan wrote:
3 Jove "Systems" or 3 Jove "Regions" if regions how many systems does that contain?

They are regions, each with many systems:

http://evemaps.dotlan.net/map/UUA-F4
http://evemaps.dotlan.net/map/A821-A
http://evemaps.dotlan.net/map/J7HZ-F