/ - Diff - BIEN 3 - NCEAS Projects

     genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
     family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
     locality,/location/locationnarrative/_merge/1,
     basisOfRecord,,** No non-empty join mapping for basisOfRecord **
     countryCode,,** No non-empty join mapping for countryCode **
     datasetName,,** No non-empty join mapping for datasetName **
     language,,** No non-empty join mapping for language **
     occurrenceRemarks,,** No non-empty join mapping for occurrenceRemarks **
     rights,,** No non-empty join mapping for rights **
     rightsHolder,,** No non-empty join mapping for rightsHolder **
     type,,** No non-empty join mapping for type **
     basisOfRecord,,** No join mapping for basisOfRecord **
     countryCode,,** No join mapping for countryCode **
     datasetName,,** No join mapping for datasetName **
     language,,** No join mapping for language **
     occurrenceRemarks,,** No join mapping for occurrenceRemarks **
     rights,,** No join mapping for rights **
     rightsHolder,,** No join mapping for rightsHolder **
     type,,** No join mapping for type **

     MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
     MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
     Locality,/location/locationnarrative/_merge/1,
     BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
     DateLastModified,,** No non-empty join mapping for DateLastModified **
     JulianDay,,** No non-empty join mapping for JulianDay **
     PreparationType,,** No non-empty join mapping for PreparationType **
     PreviousCatalogNumber,,** No non-empty join mapping for PreviousCatalogNumber **
     RelatedCatalogItem,,** No non-empty join mapping for RelatedCatalogItem **
     RelationshipType,,** No non-empty join mapping for RelationshipType **
     TimeOfDay,,** No non-empty join mapping for TimeOfDay **
     TypeStatus,,** No non-empty join mapping for TypeStatus **
     BasisOfRecord,,** No join mapping for BasisOfRecord **
     DateLastModified,,** No join mapping for DateLastModified **
     JulianDay,,** No join mapping for JulianDay **
     PreparationType,,** No join mapping for PreparationType **
     PreviousCatalogNumber,,** No join mapping for PreviousCatalogNumber **
     RelatedCatalogItem,,** No join mapping for RelatedCatalogItem **
     RelationshipType,,** No join mapping for RelationshipType **
     TimeOfDay,,** No join mapping for TimeOfDay **
     TypeStatus,,** No join mapping for TypeStatus **

     Substrate,"/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value",
     Vegetation,"/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value",
     Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
     BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
     DateLastModified,,** No non-empty join mapping for DateLastModified **
     JulianDay,,** No non-empty join mapping for JulianDay **
     PreparationType,,** No non-empty join mapping for PreparationType **
     PreviousCatalogNumber,,** No non-empty join mapping for PreviousCatalogNumber **
     RelatedCatalogItem,,** No non-empty join mapping for RelatedCatalogItem **
     RelationshipType,,** No non-empty join mapping for RelationshipType **
     TimeOfDay,,** No non-empty join mapping for TimeOfDay **
     TypeStatus,,** No non-empty join mapping for TypeStatus **
     BasisOfRecord,,** No join mapping for BasisOfRecord **
     DateLastModified,,** No join mapping for DateLastModified **
     JulianDay,,** No join mapping for JulianDay **
     PreparationType,,** No join mapping for PreparationType **
     PreviousCatalogNumber,,** No join mapping for PreviousCatalogNumber **
     RelatedCatalogItem,,** No join mapping for RelatedCatalogItem **
     RelationshipType,,** No join mapping for RelationshipType **
     TimeOfDay,,** No join mapping for TimeOfDay **
     TypeStatus,,** No join mapping for TypeStatus **
     key,,Not used because UniqueNYInternalRecordNumber is a better pkey

     locality,/location/locationnarrative/_merge/1,
     habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
     filler,,"Where used, same as family"
     flower,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     fruit,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     infrarank,,** No non-empty join mapping for taxonRank/_alt/2 **
     leaves,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     root,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     sheetno,,** No non-empty join mapping for associatedMedia ** ?
     usdaRank,,** No non-empty join mapping for taxonRank/_alt/1 **
     flower,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     fruit,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     infrarank,,** No join mapping for taxonRank/_alt/2 **
     leaves,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     root,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
     sheetno,,** No join mapping for associatedMedia ** ?
     usdaRank,,** No join mapping for taxonRank/_alt/1 **

     catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
     locality,/location/locationnarrative/_merge/1,
     habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
     basisOfRecord,,** No non-empty join mapping for basisOfRecord **
     bibliographicCitation,,** No non-empty join mapping for bibliographicCitation **
     dynamicProperties,,** No non-empty join mapping for dynamicProperties **
     geodeticDatum,,** No non-empty join mapping for geodeticDatum **
     georeferenceSources,,** No non-empty join mapping for georeferenceSources **
     georeferenceVerificationStatus,,** No non-empty join mapping for georeferenceVerificationStatus **
     identificationRemarks,,** No non-empty join mapping for identificationRemarks **
     language,,** No non-empty join mapping for language **
     locationRemarks,,** No non-empty join mapping for locationRemarks **
     modified,,** No non-empty join mapping for modified **
     municipality,,** No non-empty join mapping for municipality **
     occurrenceRemarks,,** No non-empty join mapping for occurrenceRemarks **
     ownerInstitutionCode,,** No non-empty join mapping for ownerInstitutionCode **
     reproductiveCondition,,** No non-empty join mapping for reproductiveCondition **
     rights,,** No non-empty join mapping for rights **
     rightsHolder,,** No non-empty join mapping for rightsHolder **
     taxonRank,,** No non-empty join mapping for taxonRank **
     type,,** No non-empty join mapping for type **
     verbatimDepth,,** No non-empty join mapping for verbatimDepth **
     basisOfRecord,,** No join mapping for basisOfRecord **
     bibliographicCitation,,** No join mapping for bibliographicCitation **
     dynamicProperties,,** No join mapping for dynamicProperties **
     geodeticDatum,,** No join mapping for geodeticDatum **
     georeferenceSources,,** No join mapping for georeferenceSources **
     georeferenceVerificationStatus,,** No join mapping for georeferenceVerificationStatus **
     identificationRemarks,,** No join mapping for identificationRemarks **
     language,,** No join mapping for language **
     locationRemarks,,** No join mapping for locationRemarks **
     modified,,** No join mapping for modified **
     municipality,,** No join mapping for municipality **
     occurrenceRemarks,,** No join mapping for occurrenceRemarks **
     ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
     reproductiveCondition,,** No join mapping for reproductiveCondition **
     rights,,** No join mapping for rights **
     rightsHolder,,** No join mapping for rightsHolder **
     taxonRank,,** No join mapping for taxonRank **
     type,,** No join mapping for type **
     verbatimDepth,,** No join mapping for verbatimDepth **

inputs/REMIB/src/specimens/VegBIEN.csv
27	27	lat_sec,, No input mapping for lat_sec
28	28	long_min,, No input mapping for long_min
29	29	long_sec,, No input mapping for long_sec
30		preparation,, No non-empty join mapping for preparation
	30	preparation,, No join mapping for preparation

inputs/U/src/specimens/VegBIEN.csv
39	39	EW,, No input mapping for EW
40	40	Majorarea,, No input mapping for Majorarea
41	41	NS,, No input mapping for NS
42		Phenology,, No non-empty join mapping for ReproductiveCondition
	42	Phenology,, No join mapping for ReproductiveCondition
43	43	Prefix,,Not used
44	44	Suffix,,Not used

     MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
     MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
     Locality,/location/locationnarrative/_merge/1,
     AgeClass,,** No non-empty join mapping for lifeStage **
     BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
     AgeClass,,** No join mapping for lifeStage **
     BasisOfRecord,,** No join mapping for BasisOfRecord **
     CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
     DateLastModified,,** No non-empty join mapping for DateLastModified **
     GenBankNum,,"** No non-empty join mapping for associatedSequences/_label[label=""GenBank""]/value ** "
     GeorefMethod,,** No non-empty join mapping for georeferenceProtocol **
     HigherGeography,,** No non-empty join mapping for HigherGeography **
     DateLastModified,,** No join mapping for DateLastModified **
     GenBankNum,,"** No join mapping for associatedSequences/_label[label=""GenBank""]/value ** "
     GeorefMethod,,** No join mapping for georeferenceProtocol **
     HigherGeography,,** No join mapping for HigherGeography **
     HorizontalDatum,,Not used
     Island,,** No non-empty join mapping for Island **
     IslandGroup,,** No non-empty join mapping for IslandGroup **
     JulianDay,,** No non-empty join mapping for JulianDay **
     LatLongComments,,** No non-empty join mapping for georeferenceRemarks **
     OriginalCoordinateSystem,,** No non-empty join mapping for verbatimSRS **
     OtherCatalogNumbers,,** No non-empty join mapping for RelatedCatalogItem/_alt/1 **
     Preparations,,** No non-empty join mapping for Preparations **
     RelatedCatalogedItems,,** No non-empty join mapping for RelatedCatalogItem/_alt/2 ** Used only when OtherCatalogNumbers is NULL
     TimeCollected,,** No non-empty join mapping for TimeOfDay **
     Island,,** No join mapping for Island **
     IslandGroup,,** No join mapping for IslandGroup **
     JulianDay,,** No join mapping for JulianDay **
     LatLongComments,,** No join mapping for georeferenceRemarks **
     OriginalCoordinateSystem,,** No join mapping for verbatimSRS **
     OtherCatalogNumbers,,** No join mapping for RelatedCatalogItem/_alt/1 **
     Preparations,,** No join mapping for Preparations **
     RelatedCatalogedItems,,** No join mapping for RelatedCatalogItem/_alt/2 ** Used only when OtherCatalogNumbers is NULL
     TimeCollected,,** No join mapping for TimeOfDay **
     Tissues,,Not used
     TypeStatus,,** No non-empty join mapping for TypeStatus **
     VerbatimDepth,,** No non-empty join mapping for VerbatimDepth **
     TypeStatus,,** No join mapping for TypeStatus **
     VerbatimDepth,,** No join mapping for VerbatimDepth **

     Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
     CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
     Locality,/location/locationnarrative/_merge/1,
     GBIFFamilyOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations
     GBIFGenusOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations
     LastDateModified,,** No non-empty join mapping for DateLastModified **
     ScientificNameOriginal,,** No non-empty join mapping for originalNameUsage/_alt/1 ** DwC doesn't fully support taxonomic redeterminations
     GBIFFamilyOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations
     GBIFGenusOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations
     LastDateModified,,** No join mapping for DateLastModified **
     ScientificNameOriginal,,** No join mapping for originalNameUsage/_alt/1 ** DwC doesn't fully support taxonomic redeterminations

inputs/NCU-NCSC/src/specimens/VegBIEN.csv
23	23	Alt E/W,, No input mapping for Alt E/W
24	24	Alt N/S,, No input mapping for Alt N/S
25	25	FIPS,,FIPS county code
26		Format,, No non-empty join mapping for PreparationType
27		Typology,, No non-empty join mapping for typeStatus
	26	Format,, No join mapping for PreparationType
	27	Typology,, No join mapping for typeStatus

     minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
     Locality,/location/locationnarrative/_merge/1,
     locality,/location/locationnarrative/_merge/1,
     BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
     DateLastModified,,** No non-empty join mapping for DateLastModified **
     DayOfYear,,** No non-empty join mapping for JulianDay/_alt/2 **
     JulianDay,,** No non-empty join mapping for JulianDay/_alt/1 **
     PreparationType,,** No non-empty join mapping for PreparationType **
     PreviousCatalogNumber,,** No non-empty join mapping for PreviousCatalogNumber **
     RelatedCatalogItem,,** No non-empty join mapping for RelatedCatalogItem **
     RelationshipType,,** No non-empty join mapping for RelationshipType **
     TimeOfDay,,** No non-empty join mapping for TimeOfDay **
     TypeStatus,,** No non-empty join mapping for TypeStatus **
     basisOfRecord,,** No non-empty join mapping for basisOfRecord **
     day,,** No non-empty join mapping for day **
     dc_terms_modified,,** No non-empty join mapping for dcterms:modified **
     endDayOfYear,,** No non-empty join mapping for endDayOfYear **
     eventTime,,** No non-empty join mapping for eventTime **
     month,,** No non-empty join mapping for month **
     occurrenceRemarks,,** No non-empty join mapping for occurrenceRemarks **
     otherCatalogNumbers,,** No non-empty join mapping for otherCatalogNumbers **
     preparations,,** No non-empty join mapping for preparations **
     startDayOfYear,,** No non-empty join mapping for startDayOfYear **
     typeStatus,,** No non-empty join mapping for typeStatus **
     year,,** No non-empty join mapping for year **
     BasisOfRecord,,** No join mapping for BasisOfRecord **
     DateLastModified,,** No join mapping for DateLastModified **
     DayOfYear,,** No join mapping for JulianDay/_alt/2 **
     JulianDay,,** No join mapping for JulianDay/_alt/1 **
     PreparationType,,** No join mapping for PreparationType **
     PreviousCatalogNumber,,** No join mapping for PreviousCatalogNumber **
     RelatedCatalogItem,,** No join mapping for RelatedCatalogItem **
     RelationshipType,,** No join mapping for RelationshipType **
     TimeOfDay,,** No join mapping for TimeOfDay **
     TypeStatus,,** No join mapping for TypeStatus **
     basisOfRecord,,** No join mapping for basisOfRecord **
     day,,** No join mapping for day **
     dc_terms_modified,,** No join mapping for dcterms:modified **
     endDayOfYear,,** No join mapping for endDayOfYear **
     eventTime,,** No join mapping for eventTime **
     month,,** No join mapping for month **
     occurrenceRemarks,,** No join mapping for occurrenceRemarks **
     otherCatalogNumbers,,** No join mapping for otherCatalogNumbers **
     preparations,,** No join mapping for preparations **
     startDayOfYear,,** No join mapping for startDayOfYear **
     typeStatus,,** No join mapping for typeStatus **
     year,,** No join mapping for year **

     Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
     CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
     Locality,/location/locationnarrative/_merge/1,
     BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
     DateLastModified,,** No non-empty join mapping for DateLastModified **
     TypeStatus,,** No non-empty join mapping for TypeStatus **
     BasisOfRecord,,** No join mapping for BasisOfRecord **
     DateLastModified,,** No join mapping for DateLastModified **
     TypeStatus,,** No join mapping for TypeStatus **

     catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
     locality,/location/locationnarrative/_merge/1,
     habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
     acceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage **
     basisOfRecord,,** No non-empty join mapping for basisOfRecord **
     behavior,,** No non-empty join mapping for behavior **
     bibliographicCitation,,** No non-empty join mapping for bibliographicCitation **
     datasetID,,** No non-empty join mapping for datasetID **
     datasetName,,** No non-empty join mapping for datasetName **
     eventRemarks,,** No non-empty join mapping for eventRemarks **
     eventTime,,** No non-empty join mapping for eventTime **
     geodeticDatum,,** No non-empty join mapping for geodeticDatum **
     georeferenceProtocol,,** No non-empty join mapping for georeferenceProtocol **
     georeferenceRemarks,,** No non-empty join mapping for georeferenceRemarks **
     georeferenceSources,,** No non-empty join mapping for georeferenceSources **
     georeferencedBy,,** No non-empty join mapping for georeferencedBy **
     georeferencedDate,,** No non-empty join mapping for georeferencedDate **
     identificationRemarks,,** No non-empty join mapping for identificationRemarks **
     institutionID,,** No non-empty join mapping for institutionID **
     language,,** No non-empty join mapping for language **
     lifeStage,,** No non-empty join mapping for lifeStage **
     locationRemarks,,** No non-empty join mapping for locationRemarks **
     modified,,** No non-empty join mapping for modified **
     municipality,,** No non-empty join mapping for municipality **
     nomenclaturalCode,,** No non-empty join mapping for nomenclaturalCode **
     occurrenceRemarks,,** No non-empty join mapping for occurrenceRemarks **
     ownerInstitutionCode,,** No non-empty join mapping for ownerInstitutionCode **
     preparations,,** No non-empty join mapping for preparations **
     rights,,** No non-empty join mapping for rights **
     rightsHolder,,** No non-empty join mapping for rightsHolder **
     taxonRank,,** No non-empty join mapping for taxonRank **
     type,,** No non-empty join mapping for type **
     typeStatus,,** No non-empty join mapping for typeStatus **
     verbatimCoordinateSystem,,** No non-empty join mapping for verbatimCoordinateSystem **
     verbatimCoordinates,,** No non-empty join mapping for verbatimCoordinates **
     verbatimEventDate,,** No non-empty join mapping for verbatimEventDate **
     verbatimSRS,,** No non-empty join mapping for verbatimSRS **
     waterBody,,** No non-empty join mapping for waterBody **
     acceptedNameUsage,,** No join mapping for acceptedNameUsage **
     basisOfRecord,,** No join mapping for basisOfRecord **
     behavior,,** No join mapping for behavior **
     bibliographicCitation,,** No join mapping for bibliographicCitation **
     datasetID,,** No join mapping for datasetID **
     datasetName,,** No join mapping for datasetName **
     eventRemarks,,** No join mapping for eventRemarks **
     eventTime,,** No join mapping for eventTime **
     geodeticDatum,,** No join mapping for geodeticDatum **
     georeferenceProtocol,,** No join mapping for georeferenceProtocol **
     georeferenceRemarks,,** No join mapping for georeferenceRemarks **
     georeferenceSources,,** No join mapping for georeferenceSources **
     georeferencedBy,,** No join mapping for georeferencedBy **
     georeferencedDate,,** No join mapping for georeferencedDate **
     identificationRemarks,,** No join mapping for identificationRemarks **
     institutionID,,** No join mapping for institutionID **
     language,,** No join mapping for language **
     lifeStage,,** No join mapping for lifeStage **
     locationRemarks,,** No join mapping for locationRemarks **
     modified,,** No join mapping for modified **
     municipality,,** No join mapping for municipality **
     nomenclaturalCode,,** No join mapping for nomenclaturalCode **
     occurrenceRemarks,,** No join mapping for occurrenceRemarks **
     ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
     preparations,,** No join mapping for preparations **
     rights,,** No join mapping for rights **
     rightsHolder,,** No join mapping for rightsHolder **
     taxonRank,,** No join mapping for taxonRank **
     type,,** No join mapping for type **
     typeStatus,,** No join mapping for typeStatus **
     verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
     verbatimCoordinates,,** No join mapping for verbatimCoordinates **
     verbatimEventDate,,** No join mapping for verbatimEventDate **
     verbatimSRS,,** No join mapping for verbatimSRS **
     waterBody,,** No join mapping for waterBody **

     import opts
     import util
     def non_empty(row): return row[0] != '' and row[1] != ''
     def main():
         ignore = opts.env_flag('ignore')
         header_num = util.cast(int, opts.get_env_var('header_num'))
-...
         writer.writerow(maps.merge_headers(*headers, **dict(prefer=header_num)))
         mappings = set()
         for row in map_0_reader:
             if not all_ and row[0] != '' and row[1] != '':
                 mappings.add(row[0])
                 mappings.add(row[1])
             writer.writerow(row)
             if all_ or non_empty(row):
                 if not all_:
                     mappings.add(row[0])
                     mappings.add(row[1])
                 writer.writerow(row)
         if combinable:
             # Add mappings in map 1 that weren't already defined or mapped to
             for row in map_1_reader:
                 if row[0] != '' and row[0] not in mappings: writer.writerow(row)
                 if non_empty(row) and row[0] not in mappings: writer.writerow(row)
         stream.close()

     PlotID,/location/sourceaccessioncode,
     locationID,/location/sourceaccessioncode,
     plotID,/location/sourceaccessioncode,
     AcceptedNameUsage,
     AcceptedNameUsageID,
     AccessRights,
     AssociatedMedia,
     AssociatedOccurrences,
     AssociatedReferences,
     AssociatedSequences,
     AssociatedTaxa,
     BasisOfRecord,
     Bed,
     Behavior,
     BibliographicCitation,
     CountryCode,
     DataGeneralizations,
     DatasetID,
     DatasetName,
     DateLastModified,
     Day,
     Dcterms:accessRights,
     Dcterms:bibliographicCitation,
     Dcterms:language,
     Dcterms:modified,
     Dcterms:references,
     Dcterms:rights,
     Dcterms:rightsHolder,
     Dcterms:type,
     Disposition,
     DynamicProperties,
     EarliestAgeOrLowestStage,
     EarliestEonOrLowestEonothem,
     EarliestEpochOrLowestSeries,
     EarliestEraOrLowestErathem,
     EarliestPeriodOrLowestSystem,
     EndDayOfYear,
     EventID,
     EventRemarks,
     EventTime,
     FootprintSRS,
     FootprintSpatialFit,
     Formation,
     GeodeticDatum,
     GeologicalContextID,
     GeoreferenceProtocol,
     GeoreferenceRemarks,
     GeoreferenceSources,
     GeoreferenceVerificationStatus,
     GeoreferencedBy,
     GeoreferencedDate,
     Group,
     HigherClassification,
     HigherGeography,
     HigherGeographyID,
     HighestBiostratigraphicZone,
     IdentificationID,
     IdentificationReferences,
     IdentificationRemarks,
     IdentificationVerificationStatus,
     InformationWithheld,
     InstitutionID,
     Island,
     IslandGroup,
     JulianDay,
     Language,
     LatestAgeOrHighestStage,
     LatestEonOrHighestEonothem,
     LatestEpochOrHighestSeries,
     LatestEraOrHighestErathem,
     LatestPeriodOrHighestSystem,
     LifeStage,
     LithostratigraphicTerms,
     LocationAccordingTo,
     LocationRemarks,
     LowestBiostratigraphicZone,
     MaximumDistanceAboveSurfaceInMeters,
     MeasurementAccuracy,
     MeasurementDeterminedBy,
     MeasurementDeterminedDate,
     MeasurementID,
     MeasurementMethod,
     MeasurementRemarks,
     MeasurementType,
     MeasurementUnit,
     MeasurementValue,
     Member,
     MinimumDistanceAboveSurfaceInMeters,
     Modified,
     Month,
     Municipality,
     NameAccordingTo,
     NameAccordingToID,
     NamePublishedIn,
     NamePublishedInID,
     NamePublishedInYear,
     NomenclaturalCode,
     NomenclaturalStatus,
     OccurrenceRemarks,
     OccurrenceStatus,
     OriginalNameUsage,
     OriginalNameUsageID,
     OtherCatalogNumbers,
     OwnerInstitutionCode,
     ParentNameUsage,
     ParentNameUsageID,
     PlotEventID,
     PointRadiusSpatialFit,
     Preparation,
     PreparationType,
     Preparations,
     PreviousCatalogNumber,
     PreviousIdentifications,
     References,
     RelatedCatalogItem,
     RelatedResourceID,
     RelationshipAccordingTo,
     RelationshipEstablishedDate,
     RelationshipOfResource,
     RelationshipRemarks,
     RelationshipType,
     ReproductiveCondition,
     ResourceID,
     ResourceRelationshipID,
     Rights,
     RightsHolder,
     SamplingEffort,
     ScientificNameID,
     StartDayOfYear,
     Subgenus,
     TaxonConceptID,
     TaxonID,
     TaxonRank,
     TaxonomicStatus,
     TimeOfDay,
     Type,
     TypeStatus,
     VerbatimCoordinateSystem,
     VerbatimCoordinates,
     VerbatimDepth,
     VerbatimEventDate,
     VerbatimSRS,
     VerbatimTaxonRank,
     VernacularName,
     WaterBody,
     Year,
     acceptedNameUsage,,
     acceptedNameUsageID,,
     accessRights,,
     associatedMedia,,
     associatedOccurrences,,
     associatedReferences,,
     associatedSequences,,
     associatedTaxa,,
     basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.
     bed,,
     behavior,,
     bibliographicCitation,,
     countryCode,,
     dataGeneralizations,,
     datasetID,,
     datasetName,,
     dateLastModified,,
     day,,Brad: OMIT
     dcterms:accessRights,,
     dcterms:bibliographicCitation,,
     dcterms:language,,
     dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source."
     dcterms:references,,
     dcterms:rights,,
     dcterms:rightsHolder,,
     dcterms:type,,
     disposition,,
     dynamicProperties,,
     earliestAgeOrLowestStage,,
     earliestEonOrLowestEonothem,,
     earliestEpochOrLowestSeries,,
     earliestEraOrLowestErathem,,
     earliestPeriodOrLowestSystem,,
     endDayOfYear,,
     eventID,,
     eventRemarks,,
     eventTime,,Brad: OMIT
     footprintSRS,,
     footprintSpatialFit,,
     formation,,
     geodeticDatum,,
     geologicalContextID,,
     georeferenceProtocol,,
     georeferenceRemarks,,
     georeferenceSources,,
     georeferenceVerificationStatus,,
     georeferencedBy,,
     georeferencedDate,,
     group,,
     higherClassification,,
     higherGeography,,
     higherGeographyID,,
     highestBiostratigraphicZone,,
     identificationID,,
     identificationReferences,,
     identificationRemarks,,
     identificationVerificationStatus,,
     informationWithheld,,
     institutionID,,
     island,,
     islandGroup,,
     julianDay,,
     language,,
     latestAgeOrHighestStage,,
     latestEonOrHighestEonothem,,
     latestEpochOrHighestSeries,,
     latestEraOrHighestErathem,,
     latestPeriodOrHighestSystem,,
     lifeStage,,
     lithostratigraphicTerms,,
     locationAccordingTo,,
     locationRemarks,,
     lowestBiostratigraphicZone,,
     maximumDistanceAboveSurfaceInMeters,,
     measurementAccuracy,,
     measurementDeterminedBy,,
     measurementDeterminedDate,,
     measurementID,,
     measurementMethod,,
     measurementRemarks,,
     measurementType,,
     measurementUnit,,
     measurementValue,,
     member,,
     minimumDistanceAboveSurfaceInMeters,,
     modified,,
     month,,
     municipality,,
     nameAccordingTo,,
     nameAccordingToID,,
     namePublishedIn,,
     namePublishedInID,,
     namePublishedInYear,,
     nomenclaturalCode,,
     nomenclaturalStatus,,
     occurrenceRemarks,,
     occurrenceStatus,,
     originalNameUsage,,
     originalNameUsageID,,
     otherCatalogNumbers,,
     ownerInstitutionCode,,
     parentNameUsage,,
     parentNameUsageID,,
     plotEventID,,
     pointRadiusSpatialFit,,
     preparation,,
     preparationType,,
     preparations,,Brad: OMIT
     previousCatalogNumber,,According to <http://rs.tdwg.org/dwc/terms/history/index.htm#PreviousCatalogNumber-2003-06-13>
     previousIdentifications,,Brad: OMIT
     references,,
     relatedCatalogItem,,
     relatedResourceID,,Brad: OMIT
     relationshipAccordingTo,,
     relationshipEstablishedDate,,
     relationshipOfResource,,Brad: OMIT
     relationshipRemarks,,
     relationshipType,,
     reproductiveCondition,,
     resourceID,,
     resourceRelationshipID,,
     rights,,
     rightsHolder,,
     samplingEffort,,
     scientificNameID,,
     startDayOfYear,,
     subgenus,,
     taxonConceptID,,
     taxonID,,
     taxonRank,,
     taxonomicStatus,,
     timeOfDay,,
     type,,
     typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN
     verbatimCoordinateSystem,,
     verbatimCoordinates,,
     verbatimDepth,,
     verbatimEventDate,,
     verbatimSRS,,
     verbatimTaxonRank,,
     vernacularName,,
     waterBody,,
     year,,

     slopeGradient,/location/slopegradient,
     locationID,/location/sourceaccessioncode,
     plotID,/location/sourceaccessioncode,
     acceptedNameUsage,,
     acceptedNameUsageID,,
     accessRights,,
     associatedMedia,,
     associatedOccurrences,,
     associatedReferences,,
     associatedSequences,,
     associatedTaxa,,
     basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.
     bed,,
     behavior,,
     bibliographicCitation,,
     countryCode,,
     dataGeneralizations,,
     datasetID,,
     datasetName,,
     dateLastModified,,
     day,,Brad: OMIT
     dcterms:accessRights,,
     dcterms:bibliographicCitation,,
     dcterms:language,,
     dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source."
     dcterms:references,,
     dcterms:rights,,
     dcterms:rightsHolder,,
     dcterms:type,,
     disposition,,
     dynamicProperties,,
     earliestAgeOrLowestStage,,
     earliestEonOrLowestEonothem,,
     earliestEpochOrLowestSeries,,
     earliestEraOrLowestErathem,,
     earliestPeriodOrLowestSystem,,
     endDayOfYear,,
     eventID,,
     eventRemarks,,
     eventTime,,Brad: OMIT
     footprintSRS,,
     footprintSpatialFit,,
     formation,,
     geodeticDatum,,
     geologicalContextID,,
     georeferenceProtocol,,
     georeferenceRemarks,,
     georeferenceSources,,
     georeferenceVerificationStatus,,
     georeferencedBy,,
     georeferencedDate,,
     group,,
     higherClassification,,
     higherGeography,,
     higherGeographyID,,
     highestBiostratigraphicZone,,
     identificationID,,
     identificationReferences,,
     identificationRemarks,,
     identificationVerificationStatus,,
     informationWithheld,,
     institutionID,,
     island,,
     islandGroup,,
     julianDay,,
     language,,
     latestAgeOrHighestStage,,
     latestEonOrHighestEonothem,,
     latestEpochOrHighestSeries,,
     latestEraOrHighestErathem,,
     latestPeriodOrHighestSystem,,
     lifeStage,,
     lithostratigraphicTerms,,
     locationAccordingTo,,
     locationRemarks,,
     lowestBiostratigraphicZone,,
     maximumDistanceAboveSurfaceInMeters,,
     measurementAccuracy,,
     measurementDeterminedBy,,
     measurementDeterminedDate,,
     measurementID,,
     measurementMethod,,
     measurementRemarks,,
     measurementType,,
     measurementUnit,,
     measurementValue,,
     member,,
     minimumDistanceAboveSurfaceInMeters,,
     modified,,
     month,,
     municipality,,
     nameAccordingTo,,
     nameAccordingToID,,
     namePublishedIn,,
     namePublishedInID,,
     namePublishedInYear,,
     nomenclaturalCode,,
     nomenclaturalStatus,,
     occurrenceRemarks,,
     occurrenceStatus,,
     originalNameUsage,,
     originalNameUsageID,,
     otherCatalogNumbers,,
     ownerInstitutionCode,,
     parentNameUsage,,
     parentNameUsageID,,
     plotEventID,,
     pointRadiusSpatialFit,,
     preparation,,
     preparationType,,
     preparations,,Brad: OMIT
     previousCatalogNumber,,According to <http://rs.tdwg.org/dwc/terms/history/index.htm#PreviousCatalogNumber-2003-06-13>
     previousIdentifications,,Brad: OMIT
     references,,
     relatedCatalogItem,,
     relatedResourceID,,Brad: OMIT
     relationshipAccordingTo,,
     relationshipEstablishedDate,,
     relationshipOfResource,,Brad: OMIT
     relationshipRemarks,,
     relationshipType,,
     reproductiveCondition,,
     resourceID,,
     resourceRelationshipID,,
     rights,,
     rightsHolder,,
     samplingEffort,,
     scientificNameID,,
     startDayOfYear,,
     subgenus,,
     taxonConceptID,,
     taxonID,,
     taxonRank,,
     taxonomicStatus,,
     timeOfDay,,
     type,,
     typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN
     verbatimCoordinateSystem,,
     verbatimCoordinates,,
     verbatimDepth,,
     verbatimEventDate,,
     verbatimSRS,,
     verbatimTaxonRank,,
     vernacularName,,
     waterBody,,
     year,,

Project

General

Profile

Revision 4164

Added by Aaron Marcuse-Kubitza over 12 years ago