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

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

Wormholes

 
  • Topic is locked indefinitely.
 

SQL-ifiying statics?
Author
Previous Topic Next Topic
Tarunik Raqalth'Qui
Native Freshfood
Minmatar Republic
#1 - 2012-08-16 04:45:43 UTC  |  Edited by: Tarunik Raqalth'Qui
I was wondering if there'd be any interest in having a table of all static wormholes (by W-space constellation) published in SQL form for people whose (in-house or publically hosted) tools need this data? (This'd be based off the A'J Project Atlas listing, as that seems to be the most authoritative source available for statics.)

Proposed schema (the reason for the use of names instead of IDs here is that it'd be easier to maintain consistency with the A'J source material that way; translating from constellation names back to IDs could be done anyway as a one-time operation joining against the static dump's mapConstellations table):

Quote:

CREATE TABLE mapWormholeStatics (
constellationName AS CHAR(8) PRIMARY KEY,
staticK AS CHAR(4) NULL,
staticW AS CHAR(4) NULL
);


Thoughts?
Durzel
Questionable Ethics.
Ministry of Inappropriate Footwork
#2 - 2012-08-16 09:40:32 UTC
I'd definitely be interested in an up-to-date static list, the one I have was scraped some time ago and I know it has a few anomalies.
Grizzly Kreyszig
Perkone
Caldari State
#3 - 2012-08-16 11:16:50 UTC
I've already done something similar.

http://dl.eve-files.com/media/1208/static_db2.zip

It's a list of all the systems, their static and system effect. The static data was taken from Wormnav and might not be 100% correct.

I'm not very proficient in SQL so I hope I didn't **** up the backup.
Tarunik Raqalth'Qui
Native Freshfood
Minmatar Republic
#4 - 2012-08-19 04:01:59 UTC
The statics list as a generic SQL dump for the schema in the OP and the Python script I used to generate it (requires Python 2.6 or above with lxml and BeautifulSoup4 installed, feel free to modify the script if you need something that spits out, say, JSON): http://eve-files.com/dl/256888

If the A'J list ever changes its contents, you can simply re-run the script to get a new version of the statics-dump (the SQL gets dumped on standard out, so just redirect or pipe it as you wish).

If someone torches the format of the A'J listing (which shouldn't happen), post here.