Revision 10938
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/VegBank/plot_/postprocess.sql | ||
|---|---|---|
| 49 | 49 |
COST 100; |
| 50 | 50 |
|
| 51 | 51 |
SELECT mk_derived_col((:table_str, 'coordinateUncertaintyInMeters__from_fuzzing'), $$map_fuzzing("confidentialitystatus")$$); -- runtime: 1 s ("Time: 1134.143 ms") @starscream
|
| 52 |
|
|
| 53 |
|
|
| 54 |
SELECT mk_derived_col((:table_str, 'coordinateUncertaintyInMeters'), |
|
| 55 |
$$_alt("coordinateUncertaintyInMeters__from_fuzzing", "locationaccuracy")$$)
|
|
| 56 |
; -- runtime: 1 s ("Time: 734.562 ms") @starscream
|
|
| inputs/VegBank/plot_/map.csv | ||
|---|---|---|
| 3 | 3 |
authorplotcode,locationName,, |
| 4 | 4 |
reference_id,*reference_id,, |
| 5 | 5 |
parent_id,parentLocationID,, |
| 6 |
locationaccuracy,coordinateUncertaintyInMeters,/_alt/2,
|
|
| 6 |
locationaccuracy,coordinateUncertaintyInMeters__from_coords,,
|
|
| 7 | 7 |
confidentialitystatus,accessRights_verbatim,, |
| 8 | 8 |
confidentialityreason,*confidentialityreason,, |
| 9 | 9 |
latitude,decimalLatitude,, |
| ... | ... | |
| 54 | 54 |
quadrangle,*quadrangle,, |
| 55 | 55 |
Geographic Name,*Geographic Name,, |
| 56 | 56 |
accessRights,accessRights,, |
| 57 |
coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters,/_alt/1, |
|
| 57 |
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,, |
|
| inputs/VegBank/plot_/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
authorplotcode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 15 | 15 |
plot_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 16 | 16 |
locationnarrative,/location/locationnarrative/_merge/1, |
| 17 |
coordinateUncertaintyInMeters__from_fuzzing,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1, |
|
| 18 |
locationaccuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2, |
|
| 17 |
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value, |
|
| 19 | 18 |
shape,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc, |
| 20 | 19 |
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 21 | 20 |
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 54 | 53 |
elevationrange,,** No non-empty join mapping for UNUSED#elevationrange ** |
| 55 | 54 |
emb_plot,,** No join mapping for *emb_plot ** |
| 56 | 55 |
layoutnarrative,,** No join mapping for *layoutnarrative ** |
| 56 |
locationaccuracy,,** No join mapping for coordinateUncertaintyInMeters__from_coords ** |
|
| 57 | 57 |
notesmgt,,** No join mapping for *notesmgt ** |
| 58 | 58 |
notespublic,,** No join mapping for *notespublic ** |
| 59 | 59 |
permanence,,** No join mapping for *permanence ** |
| inputs/VegBank/plot_/test.xml.ref | ||
|---|---|---|
| 20 | 20 |
<place> |
| 21 | 21 |
<coordinates_id> |
| 22 | 22 |
<coordinates> |
| 23 |
<coordsaccuracy_m> |
|
| 24 |
<_noCV> |
|
| 25 |
<value> |
|
| 26 |
<_alt> |
|
| 27 |
<1>$coordinateUncertaintyInMeters__from_fuzzing</1> |
|
| 28 |
<2>$locationaccuracy</2> |
|
| 29 |
</_alt> |
|
| 30 |
</value> |
|
| 31 |
</_noCV> |
|
| 32 |
</coordsaccuracy_m> |
|
| 23 |
<coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m> |
|
| 33 | 24 |
<footprintgeometry_dwc>$shape</footprintgeometry_dwc> |
| 34 | 25 |
<latitude_deg> |
| 35 | 26 |
<_nullIf> |
| inputs/VegBank/plot_/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
parent_id,parentLocationID,, |
| 2 |
locationaccuracy,coordinateUncertaintyInMeters,/_alt/2,
|
|
| 2 |
locationaccuracy,coordinateUncertaintyInMeters__from_coords,,
|
|
| 3 | 3 |
confidentialitystatus,accessRights_verbatim,, |
| 4 | 4 |
shape,footprintWKT,, |
| 5 | 5 |
area|country|territory,DUPLICATE#of:country#area|country|territory,, |
| 6 | 6 |
region|state|province,DUPLICATE#of:stateprovince#region|state|province,, |
| 7 |
coordinateUncertaintyInMeters__from_fuzzing,coordinateUncertaintyInMeters,/_alt/1, |
|
| inputs/VegBank/plot_/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
*reference_id |
| 2 |
coordinateUncertaintyInMeters__from_coords |
|
| 2 | 3 |
accessRights_verbatim |
| 3 | 4 |
*confidentialityreason |
| 4 | 5 |
*authore |
Also available in: Unified diff
inputs/VegBank/plot_/: translated multi-column filters to postprocessing derived columns, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns