Revision 4101
Added by Aaron Marcuse-Kubitza over 12 years ago
inputs/Madidi/src/+header.plots.csv | ||
---|---|---|
1 |
!Inventory number,Expedition number,Expedition name,Number of inventory (expedition),Inventory name,Inventory code,First evaluation,Installed and evaluated by,Collaborators,Related Epilocs,Area,Number of stems,Number of trees,Coordinates,Latitude,Longitude,Latitude (DMS),Longitude (DMS),Altitude,Minimum altitude,Locality,Locality description,Direction,Vegetation type,Topographical situation,Slope,Soil sample,pH acuoso (ISRIC 4–– 1 - 14),Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),Nitrógeno total (ISRIC 6–%–0.0014),"Carbón Orgánico (WSP S-9,10–%–0.06)","Materia Orgánica (WSP S-9,10–%–0.1)",Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)","Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)","Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)","Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),CIC (ISRIC 11–cmolc/Kg–0.05),Arena (DIN 18 123–%–2.5),Limo (DIN 18 123–%–1),Arcilla (DIN 18 123–%–1),Textural class,Observaciones,Orientación/exposicion |
inputs/REMIB/src/node.0.header.specimens.csv | ||
---|---|---|
1 |
"acronym","accession_number","family","genus","specificEpithet","country","state","county","locality","long_deg","long_min","long_sec","lat_deg","lat_min","lat_sec","coll_day","coll_month","coll_year","collector","habitat","preparation" |
inputs/GBIF/src/GBIF.0.header.specimens.txt | ||
---|---|---|
1 |
0 1 Collector 3 LatestDateCollected InstitutionCD CollectionCD CatalogNO LastDateModified IdentifiedBy ScientificNameOriginal AuthorOfScientificName ScientificName GBIFFamilyOriginal Family GBIFGenusOriginal Genus Country Locality County StateProvince DecimalLatitude VerbatimLatitude DecimalLongitude VerbatimLongitude 25 MinimumElevationInMeter MaximumElevationInMeter SpecificEpithet InfraspecificEpithet |
inputs/SpeciesLink/src/specieslink.0.header.specimens.csv | ||
---|---|---|
1 |
!dwc_dwcore_GlobalUniqueIdentifier,dwc_dwcore_DateLastModified,dwc_dwcore_BasisOfRecord,dwc_dwcore_InstitutionCode,dwc_dwcore_CollectionCode,dwc_dwcore_CatalogNumber,dwc_dwcore_Remarks,dwc_dwcore_ScientificName,dwc_dwcore_Kingdom,dwc_dwcore_Phylum,dwc_dwcore_Class,dwc_dwcore_Order,dwc_dwcore_Family,dwc_dwcore_Genus,dwc_dwcore_SpecificEpithet,dwc_dwcore_InfraspecificEpithet,dwc_dwcore_AuthorYearOfScientificName,dwc_dwcore_Continent,dwc_dwcore_Country,dwc_dwcore_StateProvince,dwc_dwcore_County,dwc_dwcore_Locality,dwc_dwcore_MinimumElevationInMeters,dwc_dwcore_MaximumElevationInMeters,dwc_dwcore_MinimumDepthInMeters,dwc_dwcore_MaximumDepthInMeters,dwc_dwcore_DayOfYear,dwc_dwcore_Collector,dwc_dwcore_Sex,dwc_curatorial_IdentifiedBy,dwc_curatorial_CollectorNumber,dwc_curatorial_FieldNumber,dwc_curatorial_TypeStatus,dwc_curatorial_IndividualCount,dwc_geospatial_DecimalLatitude,dwc_geospatial_DecimalLongitude,dwc_geospatial_VerbatimLatitude,dwc_geospatial_VerbatimLongitude,http__purl_org_dc_terms_modified,dwc_terms_collectionID,dwc_terms_institutionCode,dwc_terms_collectionCode,dwc_terms_basisOfRecord,dwc_terms_identifiedBy,dwc_terms_dateIdentified,dwc_terms_typeStatus,dwc_terms_catalogNumber,dwc_terms_occurrenceRemarks,dwc_terms_recordNumber,dwc_terms_recordedBy,dwc_terms_individualCount,dwc_terms_sex,dwc_terms_preparations,dwc_terms_otherCatalogNumbers,dwc_terms_eventTime,dwc_terms_startDayOfYear,dwc_terms_endDayOfYear,dwc_terms_year,dwc_terms_month,dwc_terms_day,dwc_terms_fieldNumber,dwc_terms_continent,dwc_terms_country,dwc_terms_stateProvince,dwc_terms_county,dwc_terms_locality,dwc_terms_minimumElevationInMeters,dwc_terms_maximumElevationInMeters,dwc_terms_minimumDepthInMeters,dwc_terms_maximumDepthInMeters,dwc_terms_verbatimLatitude,dwc_terms_verbatimLongitude,dwc_terms_decimalLatitude,dwc_terms_decimalLongitude,dwc_terms_coordinateUncertaintyInMeters,dwc_terms_scientificName,dwc_terms_kingdom,dwc_terms_phylum,dwc_terms_class,dwc_terms_order,dwc_terms_family,dwc_terms_genus,dwc_terms_specificEpithet,dwc_terms_infraspecificEpithet,dwc_terms_scientificNameAuthorship,conceptual_darwin_2003_1_0_DateLastModified,conceptual_darwin_2003_1_0_InstitutionCode,conceptual_darwin_2003_1_0_CollectionCode,conceptual_darwin_2003_1_0_CatalogNumber,conceptual_darwin_2003_1_0_ScientificName,conceptual_darwin_2003_1_0_BasisOfRecord,conceptual_darwin_2003_1_0_Kingdom,conceptual_darwin_2003_1_0_Phylum,conceptual_darwin_2003_1_0_Class,conceptual_darwin_2003_1_0_Order,conceptual_darwin_2003_1_0_Family,conceptual_darwin_2003_1_0_Genus,conceptual_darwin_2003_1_0_Species,conceptual_darwin_2003_1_0_Subspecies,conceptual_darwin_2003_1_0_ScientificNameAuthor,conceptual_darwin_2003_1_0_IdentifiedBy,conceptual_darwin_2003_1_0_YearIdentified,conceptual_darwin_2003_1_0_MonthIdentified,conceptual_darwin_2003_1_0_DayIdentified,conceptual_darwin_2003_1_0_TypeStatus,conceptual_darwin_2003_1_0_CollectorNumber,conceptual_darwin_2003_1_0_FieldNumber,conceptual_darwin_2003_1_0_Collector,conceptual_darwin_2003_1_0_YearCollected,conceptual_darwin_2003_1_0_MonthCollected,conceptual_darwin_2003_1_0_DayCollected,conceptual_darwin_2003_1_0_JulianDay,conceptual_darwin_2003_1_0_TimeOfDay,conceptual_darwin_2003_1_0_ContinentOcean,conceptual_darwin_2003_1_0_Country,conceptual_darwin_2003_1_0_StateProvince,conceptual_darwin_2003_1_0_County,conceptual_darwin_2003_1_0_Locality,conceptual_darwin_2003_1_0_Longitude,conceptual_darwin_2003_1_0_Latitude,conceptual_darwin_2003_1_0_CoordinatePrecision,conceptual_darwin_2003_1_0_BoundingBox,conceptual_darwin_2003_1_0_MinimumElevation,conceptual_darwin_2003_1_0_MaximumElevation,conceptual_darwin_2003_1_0_MinimumDepth,conceptual_darwin_2003_1_0_MaximumDepth,conceptual_darwin_2003_1_0_Sex,conceptual_darwin_2003_1_0_PreparationType,conceptual_darwin_2003_1_0_IndividualCount,conceptual_darwin_2003_1_0_PreviousCatalogNumber,conceptual_darwin_2003_1_0_RelationshipType,conceptual_darwin_2003_1_0_RelatedCatalogItem,conceptual_darwin_2003_1_0_Notes |
inputs/Madidi/src/plots/+header.csv | ||
---|---|---|
1 |
!Inventory number,Expedition number,Expedition name,Number of inventory (expedition),Inventory name,Inventory code,First evaluation,Installed and evaluated by,Collaborators,Related Epilocs,Area,Number of stems,Number of trees,Coordinates,Latitude,Longitude,Latitude (DMS),Longitude (DMS),Altitude,Minimum altitude,Locality,Locality description,Direction,Vegetation type,Topographical situation,Slope,Soil sample,pH acuoso (ISRIC 4–– 1 - 14),Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),Nitrógeno total (ISRIC 6–%–0.0014),"Carbón Orgánico (WSP S-9,10–%–0.06)","Materia Orgánica (WSP S-9,10–%–0.1)",Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)","Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)","Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)","Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),CIC (ISRIC 11–cmolc/Kg–0.05),Arena (DIN 18 123–%–2.5),Limo (DIN 18 123–%–1),Arcilla (DIN 18 123–%–1),Textural class,Observaciones,Orientación/exposicion |
inputs/REMIB/src/specimens/node.0.header.csv | ||
---|---|---|
1 |
"acronym","accession_number","family","genus","specificEpithet","country","state","county","locality","long_deg","long_min","long_sec","lat_deg","lat_min","lat_sec","coll_day","coll_month","coll_year","collector","habitat","preparation" |
inputs/GBIF/src/specimens/GBIF.0.header.txt | ||
---|---|---|
1 |
0 1 Collector 3 LatestDateCollected InstitutionCD CollectionCD CatalogNO LastDateModified IdentifiedBy ScientificNameOriginal AuthorOfScientificName ScientificName GBIFFamilyOriginal Family GBIFGenusOriginal Genus Country Locality County StateProvince DecimalLatitude VerbatimLatitude DecimalLongitude VerbatimLongitude 25 MinimumElevationInMeter MaximumElevationInMeter SpecificEpithet InfraspecificEpithet |
inputs/SpeciesLink/src/specimens/specieslink.0.header.csv | ||
---|---|---|
1 |
!dwc_dwcore_GlobalUniqueIdentifier,dwc_dwcore_DateLastModified,dwc_dwcore_BasisOfRecord,dwc_dwcore_InstitutionCode,dwc_dwcore_CollectionCode,dwc_dwcore_CatalogNumber,dwc_dwcore_Remarks,dwc_dwcore_ScientificName,dwc_dwcore_Kingdom,dwc_dwcore_Phylum,dwc_dwcore_Class,dwc_dwcore_Order,dwc_dwcore_Family,dwc_dwcore_Genus,dwc_dwcore_SpecificEpithet,dwc_dwcore_InfraspecificEpithet,dwc_dwcore_AuthorYearOfScientificName,dwc_dwcore_Continent,dwc_dwcore_Country,dwc_dwcore_StateProvince,dwc_dwcore_County,dwc_dwcore_Locality,dwc_dwcore_MinimumElevationInMeters,dwc_dwcore_MaximumElevationInMeters,dwc_dwcore_MinimumDepthInMeters,dwc_dwcore_MaximumDepthInMeters,dwc_dwcore_DayOfYear,dwc_dwcore_Collector,dwc_dwcore_Sex,dwc_curatorial_IdentifiedBy,dwc_curatorial_CollectorNumber,dwc_curatorial_FieldNumber,dwc_curatorial_TypeStatus,dwc_curatorial_IndividualCount,dwc_geospatial_DecimalLatitude,dwc_geospatial_DecimalLongitude,dwc_geospatial_VerbatimLatitude,dwc_geospatial_VerbatimLongitude,http__purl_org_dc_terms_modified,dwc_terms_collectionID,dwc_terms_institutionCode,dwc_terms_collectionCode,dwc_terms_basisOfRecord,dwc_terms_identifiedBy,dwc_terms_dateIdentified,dwc_terms_typeStatus,dwc_terms_catalogNumber,dwc_terms_occurrenceRemarks,dwc_terms_recordNumber,dwc_terms_recordedBy,dwc_terms_individualCount,dwc_terms_sex,dwc_terms_preparations,dwc_terms_otherCatalogNumbers,dwc_terms_eventTime,dwc_terms_startDayOfYear,dwc_terms_endDayOfYear,dwc_terms_year,dwc_terms_month,dwc_terms_day,dwc_terms_fieldNumber,dwc_terms_continent,dwc_terms_country,dwc_terms_stateProvince,dwc_terms_county,dwc_terms_locality,dwc_terms_minimumElevationInMeters,dwc_terms_maximumElevationInMeters,dwc_terms_minimumDepthInMeters,dwc_terms_maximumDepthInMeters,dwc_terms_verbatimLatitude,dwc_terms_verbatimLongitude,dwc_terms_decimalLatitude,dwc_terms_decimalLongitude,dwc_terms_coordinateUncertaintyInMeters,dwc_terms_scientificName,dwc_terms_kingdom,dwc_terms_phylum,dwc_terms_class,dwc_terms_order,dwc_terms_family,dwc_terms_genus,dwc_terms_specificEpithet,dwc_terms_infraspecificEpithet,dwc_terms_scientificNameAuthorship,conceptual_darwin_2003_1_0_DateLastModified,conceptual_darwin_2003_1_0_InstitutionCode,conceptual_darwin_2003_1_0_CollectionCode,conceptual_darwin_2003_1_0_CatalogNumber,conceptual_darwin_2003_1_0_ScientificName,conceptual_darwin_2003_1_0_BasisOfRecord,conceptual_darwin_2003_1_0_Kingdom,conceptual_darwin_2003_1_0_Phylum,conceptual_darwin_2003_1_0_Class,conceptual_darwin_2003_1_0_Order,conceptual_darwin_2003_1_0_Family,conceptual_darwin_2003_1_0_Genus,conceptual_darwin_2003_1_0_Species,conceptual_darwin_2003_1_0_Subspecies,conceptual_darwin_2003_1_0_ScientificNameAuthor,conceptual_darwin_2003_1_0_IdentifiedBy,conceptual_darwin_2003_1_0_YearIdentified,conceptual_darwin_2003_1_0_MonthIdentified,conceptual_darwin_2003_1_0_DayIdentified,conceptual_darwin_2003_1_0_TypeStatus,conceptual_darwin_2003_1_0_CollectorNumber,conceptual_darwin_2003_1_0_FieldNumber,conceptual_darwin_2003_1_0_Collector,conceptual_darwin_2003_1_0_YearCollected,conceptual_darwin_2003_1_0_MonthCollected,conceptual_darwin_2003_1_0_DayCollected,conceptual_darwin_2003_1_0_JulianDay,conceptual_darwin_2003_1_0_TimeOfDay,conceptual_darwin_2003_1_0_ContinentOcean,conceptual_darwin_2003_1_0_Country,conceptual_darwin_2003_1_0_StateProvince,conceptual_darwin_2003_1_0_County,conceptual_darwin_2003_1_0_Locality,conceptual_darwin_2003_1_0_Longitude,conceptual_darwin_2003_1_0_Latitude,conceptual_darwin_2003_1_0_CoordinatePrecision,conceptual_darwin_2003_1_0_BoundingBox,conceptual_darwin_2003_1_0_MinimumElevation,conceptual_darwin_2003_1_0_MaximumElevation,conceptual_darwin_2003_1_0_MinimumDepth,conceptual_darwin_2003_1_0_MaximumDepth,conceptual_darwin_2003_1_0_Sex,conceptual_darwin_2003_1_0_PreparationType,conceptual_darwin_2003_1_0_IndividualCount,conceptual_darwin_2003_1_0_PreviousCatalogNumber,conceptual_darwin_2003_1_0_RelationshipType,conceptual_darwin_2003_1_0_RelatedCatalogItem,conceptual_darwin_2003_1_0_Notes |
inputs/input.Makefile | ||
---|---|---|
105 | 105 |
|
106 | 106 |
##### Existing maps discovery |
107 | 107 |
|
108 |
inputFiles := $(wildcard $(exts:%=src/*.%))
|
|
108 |
inputFiles := $(wildcard $(tablesSort:%=src/%/*))
|
|
109 | 109 |
|
110 | 110 |
srcMaps := $(wildcard maps/src.*.csv) |
111 | 111 |
|
... | ... | |
128 | 128 |
|
129 | 129 |
##### Sources |
130 | 130 |
|
131 |
srcs = $(shell $(bin)/sort_filenames $(wildcard $(exts:%=src/*.$*.%)))
|
|
131 |
srcs = $(shell $(bin)/sort_filenames $(wildcard src/$*/*))
|
|
132 | 132 |
isCsv = $(if $(srcs),$(if $(filter %.xml,$(srcs)),,1)) |
133 | 133 |
# true if $(srcs) non-empty and contains no *.xml |
134 | 134 |
catSrcs = $(bin)/cat$(if $(isCsv),_csv) $(srcs) |
... | ... | |
253 | 253 |
map = $(if $(<in),<$(<in),\ |
254 | 254 |
$(if $(srcs),$(withCatSrcs),\ |
255 | 255 |
$(if $(mapEnv),env $(mapEnv),\ |
256 |
$(error No input file src/*.$*.{$(exts)}))))\
|
|
256 |
$(error No input file src/$*/*.{$(exts)}))))\
|
|
257 | 257 |
$(root)/map $(+maps) |
258 | 258 |
map2db = $(if $(use_staged),env in_database=vegbien in_schema=$(datasrc)\ |
259 | 259 |
in_table=$*) env out_database=vegbien $(map) |
Also available in: Unified diff
inputs: Moved src files into VegCSV subfolders (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCSV#CSV-representation), with table suffixes removed, using the steps at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCSV_subfolders>