convert_points_xml_to_csv

Script

import org.dom4j.Document;
import org.dom4j.Node;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;

if ((sourceString == void) || (sourceString == null)) {
        throw new RuntimeException("sourceString must be specified");
}

SAXReader reader = new SAXReader(false);
reader.setIncludeInternalDTDDeclarations(false);
reader.setIncludeExternalDTDDeclarations(false);

Document document = reader.read(new StringReader(sourceString));
List nodelist = document.selectNodes("//*[local-name(.)=\"Point\"]");

// Process the elements in the nodelist
int num_points = 0;
String outputString = "occurrenceID,nameComplete,decimalLongitude,decimalLatitude\n";
String id = null;
String latitude = null;
String longitude = null;
for (Iterator iter = nodelist.iterator(); iter.hasNext();) {
	Node node = (Node) iter.next();
	Element element = (Element) node;
	id = element.attributeValue("Id");
	longitude = element.attributeValue("X");
	latitude = element.attributeValue("Y");
	outputString += id+","+species_label+","+longitude+","+latitude+"\n";
	num_points += 1;
}
xsltReader.close();