For Symfony application I’m developing I needed all the Region separated by continent (7 continents model). I converted the MySql World Database (http://dev.mysql.com/doc/world-setup/en/world-setup.html) to a YAML NestedSet fixture file.
I just had to make 4 minor changes to it:
- rename the 3 continents that had region with the same name name (North America, South America, Antarctica)
- rename the Micronesia/Caribbean region to Micronesia-Caribbean.
thats’ all, enjoy the file Region.yml