GROUP BY ""PLOT_ID"", subplot

HAVING count(DISTINCT census_date) > 1

-----"

no_of_individuals,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."

cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,

census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."

        </parent_id>

        <authorlocationcode>$subplot</authorlocationcode>

        <locationevent>

            <taxonoccurrence>

                <aggregateoccurrence>

                    <count>$no_of_individuals</count>

GROUP BY ""PlotID"", ""Line""

HAVING count(DISTINCT census_date) > 1

-----"

census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:

-----

SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count

GROUP BY ""PlotID"", ""Line""

HAVING count(DISTINCT census_date) > 1

-----"

NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."

cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,

census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."

        </parent_id>

        <authorlocationcode>$Line</authorlocationcode>

        <locationevent>

            <taxonoccurrence>

                <aggregateoccurrence>

                    <count>$NoInd</count>

SELECT count(*) FROM ""SpeciesLink"".specimens

WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""

-----"

fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)

-----

SELECT count(*) FROM ""SpeciesLink"".specimens

WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""

-----"

Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

SELECT count(*) FROM ""SpeciesLink"".specimens

WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""

-----"

fieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)

-----

SELECT count(*) FROM ""SpeciesLink"".specimens

WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""

-----"

ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,

scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

                                    <_alt>

                                        <0>$dwc_curatorial_FieldNumber</0>

                                        <1>$conceptual_darwin_2003_1_0_FieldNumber</1>

                                    </_alt>

                                </2>

                            </_alt>

                                    <_alt>

                                        <0>$dwc_curatorial_FieldNumber</0>

                                        <1>$conceptual_darwin_2003_1_0_FieldNumber</1>

                                    </_alt>

                                </2>

                            </_alt>

    map_1_cols = reader.next()

    for row in reader:

        if map_1_core_only: row = row[:2]

    stream.close()

    # Join map 1 to map 0

            suffix = ''

            while True:

                try:

                    break

                except KeyError:

                    # Heuristically look for a match on a parent path.