Revision 10682
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/VegBank/plot_/map.csv | ||
|---|---|---|
| 49 | 49 |
plotrationalenarrative,*plotrationalenarrative,, |
| 50 | 50 |
accessioncode,*accessioncode,, |
| 51 | 51 |
continent,continent,, |
| 52 |
area|country|territory,country,,
|
|
| 53 |
region|state|province,stateProvince,,
|
|
| 52 |
area|country|territory,DUPLICATE#of:country#area|country|territory,,
|
|
| 53 |
region|state|province,DUPLICATE#of:stateprovince#region|state|province,,
|
|
| 54 | 54 |
county,county,, |
| 55 | 55 |
quadrangle,*quadrangle,, |
| 56 | 56 |
Geographic Name,*Geographic Name,, |
| inputs/VegBank/plot_/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 21 | 21 |
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 22 | 22 |
continent,/location/locationplace/*_id/place/continent, |
| 23 |
area|country|territory,/location/locationplace/*_id/place/country, |
|
| 24 | 23 |
country,/location/locationplace/*_id/place/country, |
| 25 | 24 |
county,/location/locationplace/*_id/place/county, |
| 26 | 25 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
| 27 | 26 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
| 28 |
area|country|territory,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2, |
|
| 29 | 27 |
country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2, |
| 30 | 28 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
| 31 |
region|state|province,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
|
| 32 | 29 |
stateprovince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2, |
| 33 |
region|state|province,/location/locationplace/*_id/place/stateprovince, |
|
| 34 | 30 |
stateprovince,/location/locationplace/*_id/place/stateprovince, |
| 35 | 31 |
parent_id,/location/parent_id/location/sourceaccessioncode, |
| 36 | 32 |
slopeaspect,/location/slopeaspect_deg/_alt/1/_compass/value, |
| ... | ... | |
| 43 | 39 |
plot_id,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
| 44 | 40 |
Geographic Name,,** No join mapping for *Geographic Name ** |
| 45 | 41 |
accessioncode,,** No join mapping for *accessioncode ** |
| 42 |
area|country|territory,,** No non-empty join mapping for DUPLICATE#of:country#area|country|territory ** |
|
| 46 | 43 |
authordatum,,** No join mapping for *authordatum ** |
| 47 | 44 |
authore,,** No join mapping for *authore ** |
| 48 | 45 |
authorlocation,,** No join mapping for *authorlocation ** |
| ... | ... | |
| 63 | 60 |
plotrationalenarrative,,** No join mapping for *plotrationalenarrative ** |
| 64 | 61 |
quadrangle,,** No join mapping for *quadrangle ** |
| 65 | 62 |
reference_id,,** No join mapping for *reference_id ** |
| 63 |
region|state|province,,** No non-empty join mapping for DUPLICATE#of:stateprovince#region|state|province ** |
|
| 66 | 64 |
revisions,,** No join mapping for *revisions ** |
| 67 | 65 |
rocktype,,** No join mapping for *rocktype ** |
| 68 | 66 |
standsize,,** No join mapping for *standsize ** |
| inputs/VegBank/plot_/test.xml.ref | ||
|---|---|---|
| 74 | 74 |
</coordinates> |
| 75 | 75 |
</coordinates_id> |
| 76 | 76 |
<continent>$continent</continent> |
| 77 |
<country> |
|
| 78 |
<_alt> |
|
| 79 |
<0>$area|country|territory</0> |
|
| 80 |
<1>$country</1> |
|
| 81 |
</_alt> |
|
| 82 |
</country> |
|
| 77 |
<country>$country</country> |
|
| 83 | 78 |
<county>$county</county> |
| 84 | 79 |
<matched_place_id> |
| 85 | 80 |
<place> |
| ... | ... | |
| 103 | 98 |
</longitude_deg> |
| 104 | 99 |
</coordinates> |
| 105 | 100 |
</coordinates_id> |
| 106 |
<country> |
|
| 107 |
<_alt> |
|
| 108 |
<0>$area|country|territory</0> |
|
| 109 |
<1>$country</1> |
|
| 110 |
</_alt> |
|
| 111 |
</country> |
|
| 101 |
<country>$country</country> |
|
| 112 | 102 |
<county>$county</county> |
| 113 |
<stateprovince> |
|
| 114 |
<_alt> |
|
| 115 |
<0>$region|state|province</0> |
|
| 116 |
<1>$stateprovince</1> |
|
| 117 |
</_alt> |
|
| 118 |
</stateprovince> |
|
| 103 |
<stateprovince>$stateprovince</stateprovince> |
|
| 119 | 104 |
</place> |
| 120 | 105 |
</matched_place_id> |
| 121 |
<stateprovince> |
|
| 122 |
<_alt> |
|
| 123 |
<0>$region|state|province</0> |
|
| 124 |
<1>$stateprovince</1> |
|
| 125 |
</_alt> |
|
| 126 |
</stateprovince> |
|
| 106 |
<stateprovince>$stateprovince</stateprovince> |
|
| 127 | 107 |
</place> |
| 128 | 108 |
</place_id> |
| 129 | 109 |
</locationplace> |
| inputs/VegBank/plot_/new_terms.csv | ||
|---|---|---|
| 3 | 3 |
confidentialitystatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription¶ms=1581>
|
| 4 | 4 |
confidentialitystatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription¶ms=1581>
|
| 5 | 5 |
shape,footprintWKT,, |
| 6 |
area|country|territory,country,, |
|
| 7 |
region|state|province,stateProvince,, |
|
| 6 |
area|country|territory,DUPLICATE#of:country#area|country|territory,, |
|
| 7 |
region|state|province,DUPLICATE#of:stateprovince#region|state|province,, |
|
Also available in: Unified diff
inputs/VegBank/plot_/map.csv: area|country|territory, region|state|province (from place table): remapped to DUPLICATE, since these have the same data as, and are populated less often than, their country/stateprovince couterparts