OOB database and found errors

[dmnt]

I dumped all the csvs and loaded them into a Postgres database. Then I started to cross check because it is much more easy to do when the data is in a proper database.

Here's the database as a zipped .sql file. It's made for Postgresql 8.3.11, but any 8.x should be ok. It's for people who are already familiar with SQL databases. The tables should go to a new "obat" schema.

The bmu table contains the self-organizing map cell where that particular unit is located. (http://en.wikipedia.org/wiki/Self-organizing_map) Only the #1 weapon was used in positioning the unit. In theory, similar units should be close to each others, but YMMV. You can use that to check if there are differences between the same weapon across nationalities as the units should be in the same hex. If they are not it's a clear sign that there is some difference in them. The maps are here http://users.tkk.fi/u/tvenhola/oobSOM.pdf in a single PDF. I'm sorry for some of them are smaller than others, but I hope you can cope with that. Red areas are where that number is high, blue means low. The hexes are numbered from 1 to 3740, in a rectangular lattice of 85x44. I'll probably make a http interface too, but it'll take time.

For Rocket launchers I did a separate thread, but I think I'll list the strange things found in here from now on.

AGL:
Load cost is 1 for some countries, 0 for others, even with the same gun and crew count.