Metacat

# Comma-seperated list of schemas containing spatial bounding boxes

# name corresponds to the docname stored in xml_documents table

spatialDocnameList=eml,fgdc

# These paths must be included in your indexPaths variable in build.properties

# Note the naming convention:

#   {docname}_{direction}BoundingCoordinatePath=.....

# Has not been tested with other schemas besides EML

eml_westBoundingCoordinatePath=geographicCoverage/boundingCoordinates/westBoundingCoordinate

eml_eastBoundingCoordinatePath=geographicCoverage/boundingCoordinates/eastBoundingCoordinate

eml_southBoundingCoordinatePath=geographicCoverage/boundingCoordinates/southBoundingCoordinate

eml_northBoundingCoordinatePath=geographicCoverage/boundingCoordinates/northBoundingCoordinate

fgdc_westBoundingCoordinatePath=spdom/bounding/westbc

fgdc_eastBoundingCoordinatePath=spdom/bounding/eastbc

fgdc_southBoundingCoordinatePath=spdom/bounding/southbc

fgdc_northBoundingCoordinatePath=spdom/bounding/northbc

  String title = "";

    boolean isSpatialDocument = false;

    String thisDocname = null;

    String westPath = null;

    String eastPath = null;

    String northPath = null;

    String southPath = null;

     * Determine the docname/schema and decide how to proceed with

     * spatial harvest

    String query = "SELECT docname FROM xml_documents WHERE docid='" + docid.trim() + "';";

    String docname = "";

        docname = rs.getString(1);	

      log.error(" ---- Could not get docname for " + docid );

    if (docname == null) 

	    docname = "";

    // Loop through all our spatial docnames and determine if the current document matches

    // If so, get the appropriate corner xpaths

    Vector spatialDocnames = MetaCatUtil.getOptionList( MetaCatUtil.getOption("spatialDocnameList") );

    for (int i = 0; i < spatialDocnames.size(); i++) {

	    thisDocname = ((String)spatialDocnames.elementAt(i)).trim();

	    if ( docname.trim().equals(thisDocname) ) {

		    isSpatialDocument = true;

    		    //  determine its east,west,north and south coord xpaths

		    westPath = MetaCatUtil.getOption(thisDocname + "_westBoundingCoordinatePath");

		    eastPath = MetaCatUtil.getOption(thisDocname + "_eastBoundingCoordinatePath");

		    northPath = MetaCatUtil.getOption(thisDocname + "_northBoundingCoordinatePath");

		    southPath = MetaCatUtil.getOption(thisDocname + "_southBoundingCoordinatePath");

	    }

    //  If it is a spatial document, harvest the corners and title 

    if (isSpatialDocument) {

	    /*

	     * Get the bounding coordinates

	     */

	    query = "SELECT path, nodedatanumerical, parentnodeid FROM xml_path_index"

	    + " WHERE docid = '" + docid.trim() + "'"

	    + " AND docid IN (SELECT distinct docid FROM xml_access WHERE docid = '" + docid.trim() 

	    + "' AND principal_name = 'public' AND perm_type = 'allow')"

	    + " AND (path = '" + westPath + "'"

	    + "  OR path = '" + southPath + "'"

	    + "  OR path = '" +  eastPath + "'"

	    + "  OR path = '" + northPath + "'"

	    + " ) ORDER BY parentnodeid;";

	    try {

	      pstmt = dbconn.prepareStatement(query);

	      pstmt.execute();

	      rs = pstmt.getResultSet();

	      while (rs.next()) {

		if ( rs.getString(1).equals(westPath) )

		    this.west.add( new Float(rs.getFloat(2)) );

		else if ( rs.getString(1).equals(southPath) )

		    this.south.add( new Float(rs.getFloat(2)) );

		else if ( rs.getString(1).equals(eastPath) )

		    this.east.add( new Float(rs.getFloat(2)) );

		else if ( rs.getString(1).equals(northPath) )

		    this.north.add( new Float(rs.getFloat(2)) );

		else

		    log.error("** An xml path not related to your bounding coordinates was returned by this query \n" + query + "\n");

	      }

	      rs.close();

	      pstmt.close();

	    }

	    catch(Exception e) {

	      log.error(" ---- Could not get bounding coordinates for " + docid );

	      e.printStackTrace();

	    }      

	    /*

	     * Get the title

	     */

	    String docTitlePath = MetaCatUtil.getOption("docTitle");

	    query = "select nodedata from xml_path_index where path = '" 

		  + docTitlePath.trim() + "' and docid = '" + docid.trim() + "'";

	    try {

	      pstmt = dbconn.prepareStatement(query);

	      pstmt.execute();

	      rs = pstmt.getResultSet();

	      if (rs.next())

		this.title = rs.getString(1);

	      rs.close();

	      pstmt.close();

	    }

	    catch(Exception e) {

	      log.error(" **** Error getting docids from getTitle for docid = "+docid);

	      e.printStackTrace();

	      this.title = docid;

	    }