Shows the section of the script that deals with transforming the XML into something MongoDB-shaped.

populate-database-xml.groovy

def xmlSlurper = new XmlSlurper().parse(new File('resources/all-coffee-shops.xml'))

xmlSlurper.node.each { child ->
    Map coffeeShop = ['openStreetMapId': child.@id.text(),
                      'location'       : ['coordinates': [Double.valueOf(child.@lon.text()), Double.valueOf(child.@lat.text())],
                                          'type'       : 'Point']]
    child.tag.each { theNode ->
        def fieldName = theNode.@k.text()
        if (isValidFieldName(fieldName)){
            coffeeShop.put(fieldName, theNode.@v.text())
        }
    }
    if (coffeeShop.name != null) {
        println coffeeShop
        collection.insert(new BasicDBObject(coffeeShop))
    }
}