Play Now Login Create Account
illyriad
  New Posts New Posts RSS Feed - CSV format datafiles
  FAQ FAQ  Forum Search   Register Register  Login Login

CSV format datafiles

 Post Reply Post Reply
Author
Tensmoor View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 07 Apr 2015
Location: Scotland
Status: Offline
Points: 1504
Post Options Post Options   Thanks (1) Thanks(1)   Quote Tensmoor Quote  Post ReplyReply Direct Link To This Post Topic: CSV format datafiles
    Posted: 26 Jan 2021 at 21:45
Given the number of folks that have got in touch with me regarding problems using the XML datafiles in spreadsheets I thought I'd publish CSV versions of some of them (these are a by-product of my processing the files to put them in a database) and are updated daily at just after 00:30 Illy time each day.

The datafiles are available at: https://illystuff.uk/illydata/data/csv/

The complex structure of the alliances datafile has been simplified by splitting it into three parts. alliances.csv is the main data, allianceRoles.csv is the various roles defined in each alliance and allianceRels.csv is the various diplomatic relationships for each alliance.

There is also a coastalTowns.csv file which holds the full town data but only for those towns which are within 5 tiles of the coast.

Each file has a description line at the start showing what fields are in each.

More 'specialist' files may be added in the future.

Tens
Back to Top
Hopper View Drop Down
Wordsmith
Wordsmith
Avatar

Joined: 02 Jul 2016
Location: Paris, France
Status: Offline
Points: 110
Post Options Post Options   Thanks (0) Thanks(0)   Quote Hopper Quote  Post ReplyReply Direct Link To This Post Posted: 27 Jan 2021 at 19:33
if anybody needs tools to extract data from xml files, I'd be ready to develop the  necessary xslt transforms…
(this is within my main skills, ;-) )
aka ibn(whatever), or computer science developers…
Back to Top
Tensmoor View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 07 Apr 2015
Location: Scotland
Status: Offline
Points: 1504
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tensmoor Quote  Post ReplyReply Direct Link To This Post Posted: 08 Mar 2021 at 09:30
There have been problems with the csv version of the towns datafile when trying to load it into Google sheets due to the size of it (all those folks with too many cities Wink) so I've split this into 3 files each covering approximately 1/3 of the map. These are named towns1.csv (the northern most 1/3) to towns3.csv (the southern most 1/3).

If anyone is experiencing problems using any of these files please let me know.
Tens
Back to Top
Tensmoor View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 07 Apr 2015
Location: Scotland
Status: Offline
Points: 1504
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tensmoor Quote  Post ReplyReply Direct Link To This Post Posted: 15 Mar 2021 at 02:18
An example google spreadsheet with each of the csv files loaded in it:

Note: This sheet is read-only. You are however free to take a copy of it yourself and that copy will be completely editable.
Back to Top
Tensmoor View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 07 Apr 2015
Location: Scotland
Status: Offline
Points: 1504
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tensmoor Quote  Post ReplyReply Direct Link To This Post Posted: 24 May 2021 at 22:33
Updated link & new files
I've now added some new csv files based on datasets I've gathered over the years and there are full descriptions of the contents of each file along with links available on Illystuff here.

I'll continue addingmore files as and when I can.

Tens
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.