Revision 4726
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/NCU-NCSC/Specimen/test.xml.ref | ||
|---|---|---|
| 21 | 21 |
<value>$Elevation</value> |
| 22 | 22 |
</_replace> |
| 23 | 23 |
</elevation> |
| 24 |
<locationdetermination>
|
|
| 24 |
<locationcoords>
|
|
| 25 | 25 |
<coordsaccuracy><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy> |
| 26 | 26 |
<latitude> |
| 27 | 27 |
<_nullIf> |
| ... | ... | |
| 47 | 47 |
</value> |
| 48 | 48 |
</_nullIf> |
| 49 | 49 |
</longitude> |
| 50 |
</locationcoords> |
|
| 51 |
<locationevent> |
|
| 52 |
<taxonoccurrence> |
|
| 53 |
<aggregateoccurrence> |
|
| 54 |
<collectiondate><_date><date>$Collect Date</date></_date></collectiondate> |
|
| 55 |
<plantobservation> |
|
| 56 |
<specimenreplicate> |
|
| 57 |
<catalognumber_dwc>$Barcode</catalognumber_dwc> |
|
| 58 |
<collectioncode_dwc>$SeriesName</collectioncode_dwc> |
|
| 59 |
<sourceaccessioncode>$Accession Number</sourceaccessioncode> |
|
| 60 |
</specimenreplicate> |
|
| 61 |
</plantobservation> |
|
| 62 |
</aggregateoccurrence> |
|
| 63 |
<authortaxoncode>$Full Taxon Name</authortaxoncode> |
|
| 64 |
<iscultivated>$Cultivated?</iscultivated> |
|
| 65 |
<taxondetermination><taxonpath_id><taxonpath><scientificname>$Full Taxon Name</scientificname></taxonpath></taxonpath_id></taxondetermination> |
|
| 66 |
</taxonoccurrence> |
|
| 67 |
</locationevent> |
|
| 68 |
<locationplace> |
|
| 50 | 69 |
<namedplace_id> |
| 51 | 70 |
<namedplace> |
| 52 | 71 |
<rank>county</rank> |
| ... | ... | |
| 65 | 84 |
</parent_id> |
| 66 | 85 |
</namedplace> |
| 67 | 86 |
</namedplace_id> |
| 68 |
</locationdetermination> |
|
| 69 |
<locationevent> |
|
| 70 |
<taxonoccurrence> |
|
| 71 |
<aggregateoccurrence> |
|
| 72 |
<collectiondate><_date><date>$Collect Date</date></_date></collectiondate> |
|
| 73 |
<plantobservation> |
|
| 74 |
<specimenreplicate> |
|
| 75 |
<catalognumber_dwc>$Barcode</catalognumber_dwc> |
|
| 76 |
<collectioncode_dwc>$SeriesName</collectioncode_dwc> |
|
| 77 |
<sourceaccessioncode>$Accession Number</sourceaccessioncode> |
|
| 78 |
</specimenreplicate> |
|
| 79 |
</plantobservation> |
|
| 80 |
</aggregateoccurrence> |
|
| 81 |
<authortaxoncode>$Full Taxon Name</authortaxoncode> |
|
| 82 |
<iscultivated>$Cultivated?</iscultivated> |
|
| 83 |
<taxondetermination><taxonpath_id><taxonpath><scientificname>$Full Taxon Name</scientificname></taxonpath></taxonpath_id></taxondetermination> |
|
| 84 |
</taxonoccurrence> |
|
| 85 |
</locationevent> |
|
| 87 |
</locationplace> |
|
| 86 | 88 |
</location> |
| 87 | 89 |
</path> |
| 88 | 90 |
</_simplifyPath> |
| 89 | 91 |
</VegBIEN> |
| 90 |
Inserted 24 new rows into database |
|
| 92 |
Inserted 26 new rows into database |
|
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 8 | 8 |
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 9 | 9 |
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 10 |
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 11 |
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 12 |
County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 13 |
StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 14 |
Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 15 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 10 |
latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 11 |
longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 16 | 12 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 17 | 13 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 18 | 14 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 38 | 34 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 39 | 35 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 40 | 36 |
Locality,/location/locationnarrative/_merge/1, |
| 37 |
County,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 38 |
StateProvince,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 39 |
Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 40 |
ContinentOcean,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 41 | 41 |
BasisOfRecord,,** No join mapping for BasisOfRecord ** |
| 42 | 42 |
DateLastModified,,** No join mapping for dcterms:modified ** |
| 43 | 43 |
TypeStatus,,** No join mapping for TypeStatus ** |
| inputs/VegBank/plot_/test.xml.ref | ||
|---|---|---|
| 14 | 14 |
</_replace> |
| 15 | 15 |
</elevation> |
| 16 | 16 |
<landform>$landform</landform> |
| 17 |
<locationdetermination>
|
|
| 17 |
<locationcoords>
|
|
| 18 | 18 |
<coordsaccuracy><_noCV><value>$locationaccuracy</value></_noCV></coordsaccuracy> |
| 19 | 19 |
<footprintgeometry_dwc>$shape</footprintgeometry_dwc> |
| 20 | 20 |
<latitude> |
| ... | ... | |
| 31 | 31 |
<value>$longitude</value> |
| 32 | 32 |
</_nullIf> |
| 33 | 33 |
</longitude> |
| 34 |
</locationcoords> |
|
| 35 |
<locationnarrative>$locationnarrative</locationnarrative> |
|
| 36 |
<locationplace> |
|
| 34 | 37 |
<namedplace_id> |
| 35 | 38 |
<namedplace> |
| 36 | 39 |
<rank>county</rank> |
| ... | ... | |
| 65 | 68 |
</parent_id> |
| 66 | 69 |
</namedplace> |
| 67 | 70 |
</namedplace_id> |
| 68 |
</locationdetermination> |
|
| 69 |
<locationnarrative>$locationnarrative</locationnarrative> |
|
| 71 |
</locationplace> |
|
| 70 | 72 |
<slopeaspect> |
| 71 | 73 |
<_alt> |
| 72 | 74 |
<1><_compass><value>$slopeaspect</value></_compass></1> |
| ... | ... | |
| 93 | 95 |
</path> |
| 94 | 96 |
</_simplifyPath> |
| 95 | 97 |
</VegBIEN> |
| 96 |
Inserted 7 new rows into database |
|
| 98 |
Inserted 9 new rows into database |
|
| schemas/vegbien.my.sql | ||
|---|---|---|
| 281 | 281 |
|
| 282 | 282 |
|
| 283 | 283 |
-- |
| 284 |
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 284 |
-- Name: locationcoords; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 285 | 285 |
-- |
| 286 | 286 |
|
| 287 |
CREATE TABLE locationdetermination (
|
|
| 288 |
locationdetermination_id int(11) NOT NULL,
|
|
| 287 |
CREATE TABLE locationcoords (
|
|
| 288 |
locationcoords_id int(11) NOT NULL,
|
|
| 289 | 289 |
location_id int(11) NOT NULL, |
| 290 | 290 |
latitude double precision, |
| 291 | 291 |
longitude double precision, |
| ... | ... | |
| 294 | 294 |
verbatimcoordinates text, |
| 295 | 295 |
footprintgeometry_dwc text, |
| 296 | 296 |
coordsaccuracy double precision, |
| 297 |
namedplace_id int(11), |
|
| 298 | 297 |
identifier_id int(11), |
| 299 | 298 |
determinationdate timestamp NULL, |
| 300 | 299 |
isoriginal int(1) DEFAULT false NOT NULL, |
| ... | ... | |
| 304 | 303 |
|
| 305 | 304 |
|
| 306 | 305 |
-- |
| 307 |
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: -
|
|
| 306 |
-- Name: COLUMN locationcoords.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 308 | 307 |
-- |
| 309 | 308 |
|
| 310 | 309 |
|
| 311 | 310 |
|
| 312 | 311 |
|
| 313 | 312 |
-- |
| 314 |
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 313 |
-- Name: COLUMN locationcoords.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
|
|
| 315 | 314 |
-- |
| 316 | 315 |
|
| 317 | 316 |
|
| 318 | 317 |
|
| 319 | 318 |
|
| 320 | 319 |
-- |
| 321 |
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: - |
|
| 322 |
-- |
|
| 323 |
|
|
| 324 |
|
|
| 325 |
|
|
| 326 |
|
|
| 327 |
-- |
|
| 328 | 320 |
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 329 | 321 |
-- |
| 330 | 322 |
|
| ... | ... | |
| 416 | 408 |
|
| 417 | 409 |
|
| 418 | 410 |
-- |
| 411 |
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 412 |
-- |
|
| 413 |
|
|
| 414 |
CREATE TABLE locationplace ( |
|
| 415 |
locationplace_id int(11) NOT NULL, |
|
| 416 |
location_id int(11) NOT NULL, |
|
| 417 |
namedplace_id int(11) NOT NULL |
|
| 418 |
); |
|
| 419 |
|
|
| 420 |
|
|
| 421 |
-- |
|
| 422 |
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: - |
|
| 423 |
-- |
|
| 424 |
|
|
| 425 |
|
|
| 426 |
|
|
| 427 |
|
|
| 428 |
-- |
|
| 419 | 429 |
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 420 | 430 |
-- |
| 421 | 431 |
|
| ... | ... | |
| 846 | 856 |
-- |
| 847 | 857 |
|
| 848 | 858 |
CREATE VIEW analytical_db_view AS |
| 849 |
SELECT datasource.organizationname AS `dataSourceName`, taxonpath.family, taxonpath.genus, taxonpath.species, COALESCE(taxonpath.scientificnamewithauthor, taxonpath.scientificname) AS taxon, taxonpath.scientificnameauthor AS `taxonAuthor`, taxonpath.variety AS `taxonMorphospecies`, country.placename AS country, stateprovince.placename AS `stateProvince`, county.placename AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, location.area AS `plotAreaHa`, method.name AS `plotMethod`, locationdetermination.latitude, locationdetermination.longitude, location.elevation AS elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, aggregateoccurrence.cover AS `pctCover` FROM (((((((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) JOIN locationdetermination USING (location_id)) LEFT JOIN namedplace_ancestor continent_ancestor ON ((continent_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace continent ON (((continent.namedplace_id = continent_ancestor.ancestor_id) AND (continent.rank = CAST('continent' AS placerank))))) LEFT JOIN namedplace_ancestor country_ancestor ON ((country_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace country ON (((country.namedplace_id = country_ancestor.ancestor_id) AND (country.rank = CAST('country' AS placerank))))) LEFT JOIN namedplace_ancestor stateprovince_ancestor ON ((stateprovince_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace stateprovince ON (((stateprovince.namedplace_id = stateprovince_ancestor.ancestor_id) AND (stateprovince.rank = CAST('stateProvince' AS placerank))))) LEFT JOIN namedplace_ancestor county_ancestor ON ((county_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace county ON (((county.namedplace_id = county_ancestor.ancestor_id) AND (county.rank = CAST('county' AS placerank))))) JOIN locationevent USING (location_id)) JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonpath USING (taxonpath_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 859 |
SELECT datasource.organizationname AS `dataSourceName`, taxonpath.family, taxonpath.genus, taxonpath.species, COALESCE(taxonpath.scientificnamewithauthor, taxonpath.scientificname) AS taxon, taxonpath.scientificnameauthor AS `taxonAuthor`, taxonpath.variety AS `taxonMorphospecies`, country.placename AS country, stateprovince.placename AS `stateProvince`, county.placename AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, location.area AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude, locationcoords.longitude, location.elevation AS elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, aggregateoccurrence.cover AS `pctCover` FROM ((((((((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) JOIN locationcoords USING (location_id)) JOIN locationplace USING (location_id)) LEFT JOIN namedplace_ancestor continent_ancestor ON ((continent_ancestor.namedplace_id = locationplace.namedplace_id))) LEFT JOIN namedplace continent ON (((continent.namedplace_id = continent_ancestor.ancestor_id) AND (continent.rank = CAST('continent' AS placerank))))) LEFT JOIN namedplace_ancestor country_ancestor ON ((country_ancestor.namedplace_id = locationplace.namedplace_id))) LEFT JOIN namedplace country ON (((country.namedplace_id = country_ancestor.ancestor_id) AND (country.rank = CAST('country' AS placerank))))) LEFT JOIN namedplace_ancestor stateprovince_ancestor ON ((stateprovince_ancestor.namedplace_id = locationplace.namedplace_id))) LEFT JOIN namedplace stateprovince ON (((stateprovince.namedplace_id = stateprovince_ancestor.ancestor_id) AND (stateprovince.rank = CAST('stateProvince' AS placerank))))) LEFT JOIN namedplace_ancestor county_ancestor ON ((county_ancestor.namedplace_id = locationplace.namedplace_id))) LEFT JOIN namedplace county ON (((county.namedplace_id = county_ancestor.ancestor_id) AND (county.rank = CAST('county' AS placerank))))) JOIN locationevent USING (location_id)) JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonpath USING (taxonpath_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 850 | 860 |
|
| 851 | 861 |
|
| 852 | 862 |
-- |
| ... | ... | |
| 1290 | 1300 |
|
| 1291 | 1301 |
|
| 1292 | 1302 |
-- |
| 1293 |
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 1303 |
-- Name: locationcoords_locationcoords_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 1294 | 1304 |
-- |
| 1295 | 1305 |
|
| 1296 | 1306 |
|
| 1297 | 1307 |
|
| 1298 | 1308 |
|
| 1299 | 1309 |
-- |
| 1300 |
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 1310 |
-- Name: locationcoords_locationcoords_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 1301 | 1311 |
-- |
| 1302 | 1312 |
|
| 1303 | 1313 |
|
| ... | ... | |
| 1376 | 1386 |
|
| 1377 | 1387 |
|
| 1378 | 1388 |
-- |
| 1389 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1390 |
-- |
|
| 1391 |
|
|
| 1392 |
|
|
| 1393 |
|
|
| 1394 |
|
|
| 1395 |
-- |
|
| 1396 |
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1397 |
-- |
|
| 1398 |
|
|
| 1399 |
|
|
| 1400 |
|
|
| 1401 |
|
|
| 1402 |
-- |
|
| 1379 | 1403 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1380 | 1404 |
-- |
| 1381 | 1405 |
|
| ... | ... | |
| 2677 | 2701 |
|
| 2678 | 2702 |
|
| 2679 | 2703 |
-- |
| 2680 |
-- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2704 |
-- Name: locationcoords_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 2681 | 2705 |
-- |
| 2682 | 2706 |
|
| 2683 | 2707 |
|
| ... | ... | |
| 2705 | 2729 |
|
| 2706 | 2730 |
|
| 2707 | 2731 |
-- |
| 2732 |
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2733 |
-- |
|
| 2734 |
|
|
| 2735 |
|
|
| 2736 |
|
|
| 2737 |
|
|
| 2738 |
-- |
|
| 2708 | 2739 |
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: - |
| 2709 | 2740 |
-- |
| 2710 | 2741 |
|
| ... | ... | |
| 3146 | 3177 |
|
| 3147 | 3178 |
|
| 3148 | 3179 |
-- |
| 3149 |
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3180 |
-- Name: locationcoords_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3150 | 3181 |
-- |
| 3151 | 3182 |
|
| 3152 |
ALTER TABLE locationdetermination
|
|
| 3153 |
ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
|
|
| 3183 |
ALTER TABLE locationcoords
|
|
| 3184 |
ADD CONSTRAINT locationcoords_pkey PRIMARY KEY (locationcoords_id);
|
|
| 3154 | 3185 |
|
| 3155 | 3186 |
|
| 3156 | 3187 |
-- |
| 3157 |
-- Name: locationdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3158 |
-- |
|
| 3159 |
|
|
| 3160 |
ALTER TABLE locationdetermination |
|
| 3161 |
ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id); |
|
| 3162 |
|
|
| 3163 |
|
|
| 3164 |
-- |
|
| 3165 | 3188 |
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3166 | 3189 |
-- |
| 3167 | 3190 |
|
| ... | ... | |
| 3186 | 3209 |
|
| 3187 | 3210 |
|
| 3188 | 3211 |
-- |
| 3212 |
-- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3213 |
-- |
|
| 3214 |
|
|
| 3215 |
ALTER TABLE locationplace |
|
| 3216 |
ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id); |
|
| 3217 |
|
|
| 3218 |
|
|
| 3219 |
-- |
|
| 3220 |
-- Name: locationplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3221 |
-- |
|
| 3222 |
|
|
| 3223 |
ALTER TABLE locationplace |
|
| 3224 |
ADD CONSTRAINT locationplace_unique UNIQUE (location_id, namedplace_id); |
|
| 3225 |
|
|
| 3226 |
|
|
| 3227 |
-- |
|
| 3189 | 3228 |
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3190 | 3229 |
-- |
| 3191 | 3230 |
|
| ... | ... | |
| 3670 | 3709 |
|
| 3671 | 3710 |
|
| 3672 | 3711 |
-- |
| 3712 |
-- Name: locationcoords_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3713 |
-- |
|
| 3714 |
|
|
| 3715 |
|
|
| 3716 |
|
|
| 3717 |
|
|
| 3718 |
-- |
|
| 3673 | 3719 |
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3674 | 3720 |
-- |
| 3675 | 3721 |
|
| ... | ... | |
| 4252 | 4298 |
|
| 4253 | 4299 |
|
| 4254 | 4300 |
-- |
| 4255 |
-- Name: locationdetermination_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4301 |
-- Name: locationcoords_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4256 | 4302 |
-- |
| 4257 | 4303 |
|
| 4258 | 4304 |
|
| 4259 | 4305 |
|
| 4260 | 4306 |
|
| 4261 | 4307 |
-- |
| 4262 |
-- Name: locationdetermination_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4308 |
-- Name: locationcoords_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4263 | 4309 |
-- |
| 4264 | 4310 |
|
| 4265 |
ALTER TABLE locationdetermination
|
|
| 4266 |
ADD CONSTRAINT locationdetermination_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 4311 |
ALTER TABLE locationcoords
|
|
| 4312 |
ADD CONSTRAINT locationcoords_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 4267 | 4313 |
|
| 4268 | 4314 |
|
| 4269 | 4315 |
-- |
| 4270 |
-- Name: locationdetermination_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4271 |
-- |
|
| 4272 |
|
|
| 4273 |
ALTER TABLE locationdetermination |
|
| 4274 |
ADD CONSTRAINT locationdetermination_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4275 |
|
|
| 4276 |
|
|
| 4277 |
-- |
|
| 4278 | 4316 |
-- Name: locationevent_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4279 | 4317 |
-- |
| 4280 | 4318 |
|
| ... | ... | |
| 4367 | 4405 |
|
| 4368 | 4406 |
|
| 4369 | 4407 |
-- |
| 4408 |
-- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4409 |
-- |
|
| 4410 |
|
|
| 4411 |
ALTER TABLE locationplace |
|
| 4412 |
ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4413 |
|
|
| 4414 |
|
|
| 4415 |
-- |
|
| 4416 |
-- Name: locationplace_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4417 |
-- |
|
| 4418 |
|
|
| 4419 |
ALTER TABLE locationplace |
|
| 4420 |
ADD CONSTRAINT locationplace_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4421 |
|
|
| 4422 |
|
|
| 4423 |
-- |
|
| 4370 | 4424 |
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4371 | 4425 |
-- |
| 4372 | 4426 |
|
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 3 | 3 |
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1", |
| 4 | 4 |
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1", |
| 5 | 5 |
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2", |
| 6 |
continent,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 7 | 6 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 8 | 7 |
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| 9 | 8 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2, |
| ... | ... | |
| 14 | 13 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 15 | 14 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 16 | 15 |
locality,/location/locationnarrative/_merge/1, |
| 16 |
continent,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 17 | 17 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
| 18 | 18 |
countryCode,,** No join mapping for countryCode ** |
| 19 | 19 |
datasetName,,** No join mapping for datasetName ** |
| inputs/MT/Specimen/test.xml.ref | ||
|---|---|---|
| 20 | 20 |
</2> |
| 21 | 21 |
</_alt> |
| 22 | 22 |
</authorlocationcode> |
| 23 |
<locationdetermination> |
|
| 24 |
<namedplace_id> |
|
| 25 |
<namedplace> |
|
| 26 |
<rank>county</rank> |
|
| 27 |
<parent_id> |
|
| 28 |
<namedplace> |
|
| 29 |
<rank>stateProvince</rank> |
|
| 30 |
<parent_id> |
|
| 31 |
<namedplace> |
|
| 32 |
<rank>country</rank> |
|
| 33 |
<parent_id> |
|
| 34 |
<namedplace> |
|
| 35 |
<rank>continent</rank> |
|
| 36 |
<placename>$continent</placename> |
|
| 37 |
</namedplace> |
|
| 38 |
</parent_id> |
|
| 39 |
</namedplace> |
|
| 40 |
</parent_id> |
|
| 41 |
</namedplace> |
|
| 42 |
</parent_id> |
|
| 43 |
</namedplace> |
|
| 44 |
</namedplace_id> |
|
| 45 |
</locationdetermination> |
|
| 46 | 23 |
<locationevent> |
| 47 | 24 |
<taxonoccurrence> |
| 48 | 25 |
<aggregateoccurrence> |
| ... | ... | |
| 87 | 64 |
</taxonoccurrence> |
| 88 | 65 |
</locationevent> |
| 89 | 66 |
<locationnarrative>$locality</locationnarrative> |
| 67 |
<locationplace> |
|
| 68 |
<namedplace_id> |
|
| 69 |
<namedplace> |
|
| 70 |
<rank>county</rank> |
|
| 71 |
<parent_id> |
|
| 72 |
<namedplace> |
|
| 73 |
<rank>stateProvince</rank> |
|
| 74 |
<parent_id> |
|
| 75 |
<namedplace> |
|
| 76 |
<rank>country</rank> |
|
| 77 |
<parent_id> |
|
| 78 |
<namedplace> |
|
| 79 |
<rank>continent</rank> |
|
| 80 |
<placename>$continent</placename> |
|
| 81 |
</namedplace> |
|
| 82 |
</parent_id> |
|
| 83 |
</namedplace> |
|
| 84 |
</parent_id> |
|
| 85 |
</namedplace> |
|
| 86 |
</parent_id> |
|
| 87 |
</namedplace> |
|
| 88 |
</namedplace_id> |
|
| 89 |
</locationplace> |
|
| 90 | 90 |
</location> |
| 91 | 91 |
</path> |
| 92 | 92 |
</_simplifyPath> |
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
darwin:MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 8 | 8 |
darwin:MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 9 | 9 |
darwin:MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 10 |
darwin:CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2, |
|
| 11 |
darwin:Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 12 |
darwin:Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 13 |
darwin:County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 14 |
darwin:StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 15 |
darwin:Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 16 |
darwin:ContinentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 10 |
darwin:CoordinatePrecision,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/2, |
|
| 11 |
darwin:Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 12 |
darwin:Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 17 | 13 |
darwin:DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 18 | 14 |
darwin:MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 19 | 15 |
darwin:YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 49 | 45 |
darwin:MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 50 | 46 |
darwin:MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 51 | 47 |
darwin:Locality,/location/locationnarrative/_merge/1, |
| 48 |
darwin:County,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 49 |
darwin:StateProvince,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 50 |
darwin:Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 51 |
darwin:ContinentOcean,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 52 | 52 |
darwin:BasisOfRecord,,** No join mapping for BasisOfRecord ** |
| 53 | 53 |
darwin:DateLastModified,,** No join mapping for dcterms:modified ** |
| 54 | 54 |
darwin:JulianDay,,** No join mapping for day ** |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 5 | 5 |
1haPlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 | 6 |
Subplot,/location/authorlocationcode, |
| 7 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 7 |
Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 9 | 9 |
Method,/location/locationevent/*_id/method/name, |
| 10 | 10 |
SiteName,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
Subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| inputs/TEAM/VL/test.xml.ref | ||
|---|---|---|
| 6 | 6 |
<location> |
| 7 | 7 |
<parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id> |
| 8 | 8 |
<authorlocationcode>$Subplot</authorlocationcode> |
| 9 |
<locationdetermination>
|
|
| 9 |
<locationcoords>
|
|
| 10 | 10 |
<latitude> |
| 11 | 11 |
<_nullIf> |
| 12 | 12 |
<null>0</null> |
| ... | ... | |
| 21 | 21 |
<value>$Longitude</value> |
| 22 | 22 |
</_nullIf> |
| 23 | 23 |
</longitude> |
| 24 |
</locationdetermination>
|
|
| 24 |
</locationcoords>
|
|
| 25 | 25 |
<locationevent> |
| 26 | 26 |
<method_id><method><name>$Method</name></method></method_id> |
| 27 | 27 |
<project_id><project><projectname>$SiteName</projectname></project></project_id> |
| ... | ... | |
| 58 | 58 |
</path> |
| 59 | 59 |
</_simplifyPath> |
| 60 | 60 |
</VegBIEN> |
| 61 |
Inserted 18 new rows into database |
|
| 61 |
Inserted 17 new rows into database |
|
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 4 | 4 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 5 | 5 |
1haPlotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 | 6 |
Subplot,/location/authorlocationcode, |
| 7 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 7 |
Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 8 |
Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 9 | 9 |
Method,/location/locationevent/*_id/method/name, |
| 10 | 10 |
SiteName,/location/locationevent/*_id/project/projectname, |
| 11 | 11 |
Subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists/_first/2", |
| inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 12 | 12 |
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 13 | 13 |
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 14 |
LatDec,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 15 |
LongDec,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 16 |
pol2,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish |
|
| 17 |
PolDiv1,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince |
|
| 18 |
Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 19 |
MajorGeo,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 14 |
LatDec,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 15 |
LongDec,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 20 | 16 |
PlotMethod,/location/locationevent/*_id/method/name, |
| 21 | 17 |
project_id,/location/locationevent/*_id/project/sourceaccessioncode, |
| 22 | 18 |
SiteCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| ... | ... | |
| 46 | 42 |
Temp,/location/locationevent/temperature, |
| 47 | 43 |
Locality_Description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX" |
| 48 | 44 |
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?" |
| 45 |
pol2,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish |
|
| 46 |
PolDiv1,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince |
|
| 47 |
Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 48 |
MajorGeo,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 49 | 49 |
plot_notes,/location/notespublic, |
| 50 | 50 |
slope_aspect,/location/slopeaspect/_alt/1/_compass/value, |
| 51 | 51 |
slope_gradient,/location/slopegradient/_alt/1, |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
U,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 3 | 3 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 4 |
Lat,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 5 |
Long,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 6 |
Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 4 |
Lat,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 5 |
Long,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 7 | 6 |
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 8 | 7 |
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 9 | 8 |
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 26 | 25 |
Newgazett,"/location/locationnarrative/_merge/2/_join/1/_label[label=""gazetteer""]/value/_join/2",Only used in 1 row |
| 27 | 26 |
Locnotes,/location/locationnarrative/_merge/2/_join/2, |
| 28 | 27 |
Ecology,"/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?" |
| 28 |
Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 29 | 29 |
Alt,,** No join mapping for Alt ** What is this? |
| 30 | 30 |
Alt2,,** No join mapping for Alt2 ** What is this? |
| 31 | 31 |
Coorsyst,,** No join mapping for Coorsyst ** |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 11 | 11 |
MaximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 12 | 12 |
MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 13 |
CoordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
|
| 14 |
BoundingBox,/location/locationdetermination/footprintgeometry_dwc, |
|
| 15 |
DecimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 16 |
VerbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 17 |
DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 18 |
VerbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 19 |
County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 20 |
StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 21 |
Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 22 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 13 |
CoordinateUncertaintyInMeters,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1, |
|
| 14 |
BoundingBox,/location/locationcoords/footprintgeometry_dwc, |
|
| 15 |
DecimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 16 |
VerbatimLatitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 17 |
DecimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 18 |
VerbatimLongitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 23 | 19 |
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/0, |
| 24 | 20 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 25 | 21 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 60 | 56 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 61 | 57 |
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 62 | 58 |
Locality,/location/locationnarrative/_merge/1, |
| 59 |
County,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 60 |
StateProvince,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 61 |
Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 62 |
ContinentOcean,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 63 | 63 |
AgeClass,,** No join mapping for lifeStage ** |
| 64 | 64 |
BasisOfRecord,,** No join mapping for BasisOfRecord ** |
| 65 | 65 |
DateLastModified,,** No join mapping for dcterms:modified ** |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
MinimumElevationInMeter,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 8 | 8 |
MaximumElevationInMeter,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 9 | 9 |
MinimumElevationInMeter,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 10 |
DecimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 11 |
VerbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 12 |
DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 13 |
VerbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 14 |
County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 15 |
StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 16 |
Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 10 |
DecimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 11 |
VerbatimLatitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 12 |
DecimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 13 |
VerbatimLongitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 17 | 14 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
| 18 | 15 |
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 19 | 16 |
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| ... | ... | |
| 35 | 32 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 36 | 33 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 37 | 34 |
Locality,/location/locationnarrative/_merge/1, |
| 35 |
County,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 36 |
StateProvince,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 37 |
Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 38 | 38 |
0,,** No join mapping for 0 ** |
| 39 | 39 |
1,,** No join mapping for 1 ** |
| 40 | 40 |
25,,** No join mapping for 25 ** |
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 3 | 3 |
SeriesName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1", |
| 4 | 4 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 5 | 5 |
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
| 6 |
Accuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
|
| 7 |
Lat (-=S),"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
|
| 8 |
Long (-=W),"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
|
| 9 |
County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 10 |
State,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 11 |
Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 6 |
Accuracy,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1, |
|
| 7 |
Lat (-=S),"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
|
| 8 |
Long (-=W),"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
|
| 12 | 9 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
| 13 | 10 |
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 14 | 11 |
SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| ... | ... | |
| 17 | 14 |
Cultivated?,/location/locationevent/taxonoccurrence/iscultivated/_alt/1, |
| 18 | 15 |
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/scientificname, |
| 19 | 16 |
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 17 |
County,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 18 |
State,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 19 |
Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 20 | 20 |
Alt E/W,,** No join mapping for Alt E/W ** |
| 21 | 21 |
Alt N/S,,** No join mapping for Alt N/S ** |
| 22 | 22 |
FIPS,,** No join mapping for FIPS ** FIPS county code |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 151 | 151 |
</to> |
| 152 | 152 |
</_range> |
| 153 | 153 |
</elevationrange> |
| 154 |
<locationdetermination>
|
|
| 154 |
<locationcoords>
|
|
| 155 | 155 |
<coordsaccuracy> |
| 156 | 156 |
<_noCV> |
| 157 | 157 |
<value> |
| ... | ... | |
| 221 | 221 |
</2> |
| 222 | 222 |
</_alt> |
| 223 | 223 |
</longitude> |
| 224 |
<namedplace_id> |
|
| 225 |
<namedplace> |
|
| 226 |
<rank>county</rank> |
|
| 227 |
<placename> |
|
| 228 |
<_alt> |
|
| 229 |
<0>$conceptual_darwin_2003_1_0_County</0> |
|
| 230 |
<1>$dwc_dwcore_County</1> |
|
| 231 |
<2>$dwc_terms_county</2> |
|
| 232 |
</_alt> |
|
| 233 |
</placename> |
|
| 234 |
<parent_id> |
|
| 235 |
<namedplace> |
|
| 236 |
<rank>stateProvince</rank> |
|
| 237 |
<placename> |
|
| 238 |
<_alt> |
|
| 239 |
<0>$conceptual_darwin_2003_1_0_StateProvince</0> |
|
| 240 |
<1>$dwc_dwcore_StateProvince</1> |
|
| 241 |
<2>$dwc_terms_stateProvince</2> |
|
| 242 |
</_alt> |
|
| 243 |
</placename> |
|
| 244 |
<parent_id> |
|
| 245 |
<namedplace> |
|
| 246 |
<rank>country</rank> |
|
| 247 |
<placename> |
|
| 248 |
<_alt> |
|
| 249 |
<0>$conceptual_darwin_2003_1_0_Country</0> |
|
| 250 |
<1>$dwc_dwcore_Country</1> |
|
| 251 |
<2>$dwc_terms_country</2> |
|
| 252 |
</_alt> |
|
| 253 |
</placename> |
|
| 254 |
<parent_id> |
|
| 255 |
<namedplace> |
|
| 256 |
<rank>continent</rank> |
|
| 257 |
<placename> |
|
| 258 |
<_alt> |
|
| 259 |
<0>$conceptual_darwin_2003_1_0_ContinentOcean</0> |
|
| 260 |
<1>$dwc_dwcore_Continent</1> |
|
| 261 |
<2>$dwc_terms_continent</2> |
|
| 262 |
</_alt> |
|
| 263 |
</placename> |
|
| 264 |
</namedplace> |
|
| 265 |
</parent_id> |
|
| 266 |
</namedplace> |
|
| 267 |
</parent_id> |
|
| 268 |
</namedplace> |
|
| 269 |
</parent_id> |
|
| 270 |
</namedplace> |
|
| 271 |
</namedplace_id> |
|
| 272 |
</locationdetermination> |
|
| 224 |
</locationcoords> |
|
| 273 | 225 |
<locationevent> |
| 274 | 226 |
<taxonoccurrence> |
| 275 | 227 |
<aggregateoccurrence> |
| ... | ... | |
| 606 | 558 |
<2>$dwc_terms_locality</2> |
| 607 | 559 |
</_alt> |
| 608 | 560 |
</locationnarrative> |
| 561 |
<locationplace> |
|
| 562 |
<namedplace_id> |
|
| 563 |
<namedplace> |
|
| 564 |
<rank>county</rank> |
|
| 565 |
<placename> |
|
| 566 |
<_alt> |
|
| 567 |
<0>$conceptual_darwin_2003_1_0_County</0> |
|
| 568 |
<1>$dwc_dwcore_County</1> |
|
| 569 |
<2>$dwc_terms_county</2> |
|
| 570 |
</_alt> |
|
| 571 |
</placename> |
|
| 572 |
<parent_id> |
|
| 573 |
<namedplace> |
|
| 574 |
<rank>stateProvince</rank> |
|
| 575 |
<placename> |
|
| 576 |
<_alt> |
|
| 577 |
<0>$conceptual_darwin_2003_1_0_StateProvince</0> |
|
| 578 |
<1>$dwc_dwcore_StateProvince</1> |
|
| 579 |
<2>$dwc_terms_stateProvince</2> |
|
| 580 |
</_alt> |
|
| 581 |
</placename> |
|
| 582 |
<parent_id> |
|
| 583 |
<namedplace> |
|
| 584 |
<rank>country</rank> |
|
| 585 |
<placename> |
|
| 586 |
<_alt> |
|
| 587 |
<0>$conceptual_darwin_2003_1_0_Country</0> |
|
| 588 |
<1>$dwc_dwcore_Country</1> |
|
| 589 |
<2>$dwc_terms_country</2> |
|
| 590 |
</_alt> |
|
| 591 |
</placename> |
|
| 592 |
<parent_id> |
|
| 593 |
<namedplace> |
|
| 594 |
<rank>continent</rank> |
|
| 595 |
<placename> |
|
| 596 |
<_alt> |
|
| 597 |
<0>$conceptual_darwin_2003_1_0_ContinentOcean</0> |
|
| 598 |
<1>$dwc_dwcore_Continent</1> |
|
| 599 |
<2>$dwc_terms_continent</2> |
|
| 600 |
</_alt> |
|
| 601 |
</placename> |
|
| 602 |
</namedplace> |
|
| 603 |
</parent_id> |
|
| 604 |
</namedplace> |
|
| 605 |
</parent_id> |
|
| 606 |
</namedplace> |
|
| 607 |
</parent_id> |
|
| 608 |
</namedplace> |
|
| 609 |
</namedplace_id> |
|
| 610 |
</locationplace> |
|
| 609 | 611 |
</location> |
| 610 | 612 |
</path> |
| 611 | 613 |
</_simplifyPath> |
| 612 | 614 |
</VegBIEN> |
| 613 |
Inserted 31 new rows into database |
|
| 615 |
Inserted 33 new rows into database |
|
| inputs/VegBank/plot_/VegBIEN.csv | ||
|---|---|---|
| 7 | 7 |
area,/location/area, |
| 8 | 8 |
elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
| 9 | 9 |
landform,/location/landform, |
| 10 |
locationaccuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
|
| 11 |
shape,/location/locationdetermination/footprintgeometry_dwc, |
|
| 12 |
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 13 |
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 14 |
county,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 15 |
region|state|province,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 16 |
stateprovince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 17 |
area|country|territory,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 18 |
country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 19 |
continent,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 10 |
locationaccuracy,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1, |
|
| 11 |
shape,/location/locationcoords/footprintgeometry_dwc, |
|
| 12 |
latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 13 |
longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 20 | 14 |
authorplotcode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| 21 | 15 |
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode", |
| 22 | 16 |
locationnarrative,/location/locationnarrative/_merge/1, |
| 17 |
county,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 18 |
region|state|province,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 19 |
stateprovince,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 20 |
area|country|territory,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 21 |
country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 22 |
continent,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 23 | 23 |
slopeaspect,/location/slopeaspect/_alt/1/_compass/value, |
| 24 | 24 |
maxslopeaspect,/location/slopeaspect/_alt/2/_avg/max, |
| 25 | 25 |
minslopeaspect,/location/slopeaspect/_alt/2/_avg/min, |
| inputs/QMOR/Specimen/test.xml.ref | ||
|---|---|---|
| 113 | 113 |
</to> |
| 114 | 114 |
</_range> |
| 115 | 115 |
</elevationrange> |
| 116 |
<locationdetermination>
|
|
| 116 |
<locationcoords>
|
|
| 117 | 117 |
<coordsaccuracy><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy> |
| 118 | 118 |
<footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc> |
| 119 | 119 |
<latitude> |
| ... | ... | |
| 152 | 152 |
</2> |
| 153 | 153 |
</_alt> |
| 154 | 154 |
</longitude> |
| 155 |
<namedplace_id> |
|
| 156 |
<namedplace> |
|
| 157 |
<rank>county</rank> |
|
| 158 |
<placename>$county</placename> |
|
| 159 |
<parent_id> |
|
| 160 |
<namedplace> |
|
| 161 |
<rank>stateProvince</rank> |
|
| 162 |
<placename>$stateProvince</placename> |
|
| 163 |
<parent_id> |
|
| 164 |
<namedplace> |
|
| 165 |
<rank>country</rank> |
|
| 166 |
<placename>$country</placename> |
|
| 167 |
<parent_id> |
|
| 168 |
<namedplace> |
|
| 169 |
<rank>continent</rank> |
|
| 170 |
<placename>$continent</placename> |
|
| 171 |
</namedplace> |
|
| 172 |
</parent_id> |
|
| 173 |
</namedplace> |
|
| 174 |
</parent_id> |
|
| 175 |
</namedplace> |
|
| 176 |
</parent_id> |
|
| 177 |
</namedplace> |
|
| 178 |
</namedplace_id> |
|
| 179 |
</locationdetermination> |
|
| 155 |
</locationcoords> |
|
| 180 | 156 |
<locationevent> |
| 181 | 157 |
<method_id><method><name>$samplingProtocol</name></method></method_id> |
| 182 | 158 |
<obsenddate><_date><date><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></date></_date></obsenddate> |
| ... | ... | |
| 252 | 228 |
</3> |
| 253 | 229 |
</_merge> |
| 254 | 230 |
</locationnarrative> |
| 231 |
<locationplace> |
|
| 232 |
<namedplace_id> |
|
| 233 |
<namedplace> |
|
| 234 |
<rank>county</rank> |
|
| 235 |
<placename>$county</placename> |
|
| 236 |
<parent_id> |
|
| 237 |
<namedplace> |
|
| 238 |
<rank>stateProvince</rank> |
|
| 239 |
<placename>$stateProvince</placename> |
|
| 240 |
<parent_id> |
|
| 241 |
<namedplace> |
|
| 242 |
<rank>country</rank> |
|
| 243 |
<placename>$country</placename> |
|
| 244 |
<parent_id> |
|
| 245 |
<namedplace> |
|
| 246 |
<rank>continent</rank> |
|
| 247 |
<placename>$continent</placename> |
|
| 248 |
</namedplace> |
|
| 249 |
</parent_id> |
|
| 250 |
</namedplace> |
|
| 251 |
</parent_id> |
|
| 252 |
</namedplace> |
|
| 253 |
</parent_id> |
|
| 254 |
</namedplace> |
|
| 255 |
</namedplace_id> |
|
| 256 |
</locationplace> |
|
| 255 | 257 |
</location> |
| 256 | 258 |
</path> |
| 257 | 259 |
</_simplifyPath> |
| 258 | 260 |
</VegBIEN> |
| 259 |
Inserted 26 new rows into database |
|
| 261 |
Inserted 28 new rows into database |
|
| inputs/TEAM/VT/test.xml.ref | ||
|---|---|---|
| 6 | 6 |
<location> |
| 7 | 7 |
<parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id> |
| 8 | 8 |
<authorlocationcode>$Subplot</authorlocationcode> |
| 9 |
<locationdetermination>
|
|
| 9 |
<locationcoords>
|
|
| 10 | 10 |
<latitude> |
| 11 | 11 |
<_nullIf> |
| 12 | 12 |
<null>0</null> |
| ... | ... | |
| 21 | 21 |
<value>$Longitude</value> |
| 22 | 22 |
</_nullIf> |
| 23 | 23 |
</longitude> |
| 24 |
</locationdetermination>
|
|
| 24 |
</locationcoords>
|
|
| 25 | 25 |
<locationevent> |
| 26 | 26 |
<method_id><method><name>$Method</name></method></method_id> |
| 27 | 27 |
<project_id><project><projectname>$SiteName</projectname></project></project_id> |
| ... | ... | |
| 58 | 58 |
</path> |
| 59 | 59 |
</_simplifyPath> |
| 60 | 60 |
</VegBIEN> |
| 61 |
Inserted 18 new rows into database |
|
| 61 |
Inserted 17 new rows into database |
|
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value", |
| 9 | 9 |
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 10 | 10 |
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value", |
| 11 |
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2, |
|
| 12 |
BoundingBox,/location/locationdetermination/footprintgeometry_dwc, |
|
| 13 |
Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 14 |
Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 15 |
County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 16 |
StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 17 |
Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 18 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 11 |
CoordinatePrecision,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/2, |
|
| 12 |
BoundingBox,/location/locationcoords/footprintgeometry_dwc, |
|
| 13 |
Latitude,"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 14 |
Longitude,"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value", |
|
| 19 | 15 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 20 | 16 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 21 | 17 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 54 | 50 |
Substrate,"/location/locationnarrative/_merge/1/_join/2/_label[label=""substrate""]/value", |
| 55 | 51 |
Vegetation,"/location/locationnarrative/_merge/1/_join/3/_label[label=""vegetation""]/value", |
| 56 | 52 |
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?" |
| 53 |
County,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 54 |
StateProvince,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 55 |
Country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 56 |
ContinentOcean,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 57 | 57 |
BasisOfRecord,,** No join mapping for BasisOfRecord ** |
| 58 | 58 |
CollectorNumber,,"** No join mapping for OMIT ** Not used [1], so does not need to be mapped. |
| 59 | 59 |
|
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 113 | 113 |
</to> |
| 114 | 114 |
</_range> |
| 115 | 115 |
</elevationrange> |
| 116 |
<locationdetermination>
|
|
| 116 |
<locationcoords>
|
|
| 117 | 117 |
<coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy> |
| 118 | 118 |
<footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc> |
| 119 | 119 |
<latitude> |
| ... | ... | |
| 130 | 130 |
<value>$Longitude</value> |
| 131 | 131 |
</_nullIf> |
| 132 | 132 |
</longitude> |
| 133 |
<namedplace_id> |
|
| 134 |
<namedplace> |
|
| 135 |
<rank>county</rank> |
|
| 136 |
<placename>$County</placename> |
|
| 137 |
<parent_id> |
|
| 138 |
<namedplace> |
|
| 139 |
<rank>stateProvince</rank> |
|
| 140 |
<placename>$StateProvince</placename> |
|
| 141 |
<parent_id> |
|
| 142 |
<namedplace> |
|
| 143 |
<rank>country</rank> |
|
| 144 |
<placename>$Country</placename> |
|
| 145 |
<parent_id> |
|
| 146 |
<namedplace> |
|
| 147 |
<rank>continent</rank> |
|
| 148 |
<placename>$ContinentOcean</placename> |
|
| 149 |
</namedplace> |
|
| 150 |
</parent_id> |
|
| 151 |
</namedplace> |
|
| 152 |
</parent_id> |
|
| 153 |
</namedplace> |
|
| 154 |
</parent_id> |
|
| 155 |
</namedplace> |
|
| 156 |
</namedplace_id> |
|
| 157 |
</locationdetermination> |
|
| 133 |
</locationcoords> |
|
| 158 | 134 |
<locationevent> |
| 159 | 135 |
<taxonoccurrence> |
| 160 | 136 |
<aggregateoccurrence> |
| ... | ... | |
| 328 | 304 |
</3> |
| 329 | 305 |
</_merge> |
| 330 | 306 |
</locationnarrative> |
| 307 |
<locationplace> |
|
| 308 |
<namedplace_id> |
|
| 309 |
<namedplace> |
|
| 310 |
<rank>county</rank> |
|
| 311 |
<placename>$County</placename> |
|
| 312 |
<parent_id> |
|
| 313 |
<namedplace> |
|
| 314 |
<rank>stateProvince</rank> |
|
| 315 |
<placename>$StateProvince</placename> |
|
| 316 |
<parent_id> |
|
| 317 |
<namedplace> |
|
| 318 |
<rank>country</rank> |
|
| 319 |
<placename>$Country</placename> |
|
| 320 |
<parent_id> |
|
| 321 |
<namedplace> |
|
| 322 |
<rank>continent</rank> |
|
| 323 |
<placename>$ContinentOcean</placename> |
|
| 324 |
</namedplace> |
|
| 325 |
</parent_id> |
|
| 326 |
</namedplace> |
|
| 327 |
</parent_id> |
|
| 328 |
</namedplace> |
|
| 329 |
</parent_id> |
|
| 330 |
</namedplace> |
|
| 331 |
</namedplace_id> |
|
| 332 |
</locationplace> |
|
| 331 | 333 |
</location> |
| 332 | 334 |
</path> |
| 333 | 335 |
</_simplifyPath> |
| 334 | 336 |
</VegBIEN> |
| 335 |
Inserted 30 new rows into database |
|
| 337 |
Inserted 32 new rows into database |
|
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
Minimum altitude,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 11 | 11 |
Minimum altitude,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 12 | 12 |
Topographical situation,/location/landform, |
| 13 |
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 14 |
Latitude (DMS),"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 15 |
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 16 |
Longitude (DMS),"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 13 |
Latitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 14 |
Latitude (DMS),"/location/locationcoords/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 15 |
Longitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
|
|
| 16 |
Longitude (DMS),"/location/locationcoords/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
|
|
| 17 | 17 |
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data |
| 18 | 18 |
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data |
| 19 | 19 |
Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode", |
| inputs/Madidi/Plot/test.xml.ref | ||
|---|---|---|
| 77 | 77 |
</_range> |
| 78 | 78 |
</elevationrange> |
| 79 | 79 |
<landform>$Topographical situation</landform> |
| 80 |
<locationdetermination>
|
|
| 80 |
<locationcoords>
|
|
| 81 | 81 |
<latitude> |
| 82 | 82 |
<_alt> |
| 83 | 83 |
<1> |
| ... | ... | |
| 114 | 114 |
</2> |
| 115 | 115 |
</_alt> |
| 116 | 116 |
</longitude> |
| 117 |
</locationdetermination>
|
|
| 117 |
</locationcoords>
|
|
| 118 | 118 |
<locationevent> |
| 119 | 119 |
<project_id> |
| 120 | 120 |
<project> |
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
UNCC,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 3 | 3 |
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1", |
| 4 |
county,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 5 |
state,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 6 |
country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 7 | 4 |
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 8 | 5 |
collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 9 | 6 |
collyear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 34 | 31 |
collector3,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/4, |
| 35 | 32 |
locality,/location/locationnarrative/_merge/1, |
| 36 | 33 |
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?" |
| 34 |
county,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 35 |
state,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 36 |
country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 37 | 37 |
filler,,"** No join mapping for filler ** Where used, same as family" |
| 38 | 38 |
flower,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?" |
| 39 | 39 |
fruit,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?" |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 10 | 10 |
<2>$herbarium</2> |
| 11 | 11 |
</_alt> |
| 12 | 12 |
</authorlocationcode> |
| 13 |
<locationdetermination> |
|
| 14 |
<namedplace_id> |
|
| 15 |
<namedplace> |
|
| 16 |
<rank>county</rank> |
|
| 17 |
<placename>$county</placename> |
|
| 18 |
<parent_id> |
|
| 19 |
<namedplace> |
|
| 20 |
<rank>stateProvince</rank> |
|
| 21 |
<placename>$state</placename> |
|
| 22 |
<parent_id> |
|
| 23 |
<namedplace> |
|
| 24 |
<rank>country</rank> |
|
| 25 |
<placename>$country</placename> |
|
| 26 |
</namedplace> |
|
| 27 |
</parent_id> |
|
| 28 |
</namedplace> |
|
| 29 |
</parent_id> |
|
| 30 |
</namedplace> |
|
| 31 |
</namedplace_id> |
|
| 32 |
</locationdetermination> |
|
| 33 | 13 |
<locationevent> |
| 34 | 14 |
<taxonoccurrence> |
| 35 | 15 |
<aggregateoccurrence> |
| ... | ... | |
| 142 | 122 |
</3> |
| 143 | 123 |
</_merge> |
| 144 | 124 |
</locationnarrative> |
| 125 |
<locationplace> |
|
| 126 |
<namedplace_id> |
|
| 127 |
<namedplace> |
|
| 128 |
<rank>county</rank> |
|
| 129 |
<placename>$county</placename> |
|
| 130 |
<parent_id> |
|
| 131 |
<namedplace> |
|
| 132 |
<rank>stateProvince</rank> |
|
| 133 |
<placename>$state</placename> |
|
| 134 |
<parent_id> |
|
| 135 |
<namedplace> |
|
| 136 |
<rank>country</rank> |
|
| 137 |
<placename>$country</placename> |
|
| 138 |
</namedplace> |
|
| 139 |
</parent_id> |
|
| 140 |
</namedplace> |
|
| 141 |
</parent_id> |
|
| 142 |
</namedplace> |
|
| 143 |
</namedplace_id> |
|
| 144 |
</locationplace> |
|
| 145 | 145 |
</location> |
| 146 | 146 |
</path> |
| 147 | 147 |
</_simplifyPath> |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 5 | 5 |
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2", |
| 6 | 6 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 7 | 7 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
| 8 |
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 9 |
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 10 |
county,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 11 |
stateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 12 |
country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 13 |
continent,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 8 |
decimalLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 9 |
decimalLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 14 | 10 |
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value, |
| 15 | 11 |
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value, |
| 16 | 12 |
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber, |
| ... | ... | |
| 40 | 36 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 41 | 37 |
locality,/location/locationnarrative/_merge/1, |
| 42 | 38 |
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?" |
| 39 |
county,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 40 |
stateProvince,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 41 |
country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 42 |
continent,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 43 | 43 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
| 44 | 44 |
bibliographicCitation,,** No join mapping for dcterms:bibliographicCitation ** |
| 45 | 45 |
dynamicProperties,,** No join mapping for dynamicProperties ** |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 27 | 27 |
<value>$verbatimElevation</value> |
| 28 | 28 |
</_replace> |
| 29 | 29 |
</elevation> |
| 30 |
<locationdetermination>
|
|
| 30 |
<locationcoords>
|
|
| 31 | 31 |
<latitude> |
| 32 | 32 |
<_nullIf> |
| 33 | 33 |
<null>0</null> |
| ... | ... | |
| 42 | 42 |
<value>$decimalLongitude</value> |
| 43 | 43 |
</_nullIf> |
| 44 | 44 |
</longitude> |
| 45 |
<namedplace_id> |
|
| 46 |
<namedplace> |
|
| 47 |
<rank>county</rank> |
|
| 48 |
<placename>$county</placename> |
|
| 49 |
<parent_id> |
|
| 50 |
<namedplace> |
|
| 51 |
<rank>stateProvince</rank> |
|
| 52 |
<placename>$stateProvince</placename> |
|
| 53 |
<parent_id> |
|
| 54 |
<namedplace> |
|
| 55 |
<rank>country</rank> |
|
| 56 |
<placename>$country</placename> |
|
| 57 |
<parent_id> |
|
| 58 |
<namedplace> |
|
| 59 |
<rank>continent</rank> |
|
| 60 |
<placename>$continent</placename> |
|
| 61 |
</namedplace> |
|
| 62 |
</parent_id> |
|
| 63 |
</namedplace> |
|
| 64 |
</parent_id> |
|
| 65 |
</namedplace> |
|
| 66 |
</parent_id> |
|
| 67 |
</namedplace> |
|
| 68 |
</namedplace_id> |
|
| 69 |
</locationdetermination> |
|
| 45 |
</locationcoords> |
|
| 70 | 46 |
<locationevent> |
| 71 | 47 |
<obsenddate><_date><date><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></date></_date></obsenddate> |
| 72 | 48 |
<obsstartdate><_date><date><_dateRangeStart><value>$eventDate</value></_dateRangeStart></date></_date></obsstartdate> |
| ... | ... | |
| 136 | 112 |
</3> |
| 137 | 113 |
</_merge> |
| 138 | 114 |
</locationnarrative> |
| 115 |
<locationplace> |
|
| 116 |
<namedplace_id> |
|
| 117 |
<namedplace> |
|
| 118 |
<rank>county</rank> |
|
| 119 |
<placename>$county</placename> |
|
| 120 |
<parent_id> |
|
| 121 |
<namedplace> |
|
| 122 |
<rank>stateProvince</rank> |
|
| 123 |
<placename>$stateProvince</placename> |
|
| 124 |
<parent_id> |
|
| 125 |
<namedplace> |
|
| 126 |
<rank>country</rank> |
|
| 127 |
<placename>$country</placename> |
|
| 128 |
<parent_id> |
|
| 129 |
<namedplace> |
|
| 130 |
<rank>continent</rank> |
|
| 131 |
<placename>$continent</placename> |
|
| 132 |
</namedplace> |
|
| 133 |
</parent_id> |
|
| 134 |
</namedplace> |
|
| 135 |
</parent_id> |
|
| 136 |
</namedplace> |
|
| 137 |
</parent_id> |
|
| 138 |
</namedplace> |
|
| 139 |
</namedplace_id> |
|
| 140 |
</locationplace> |
|
| 139 | 141 |
</location> |
| 140 | 142 |
</path> |
| 141 | 143 |
</_simplifyPath> |
| 142 | 144 |
</VegBIEN> |
| 143 |
Inserted 26 new rows into database |
|
| 145 |
Inserted 28 new rows into database |
|
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 12 | 12 |
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value", |
| 13 | 13 |
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value", |
| 14 |
lat_decimal,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 15 |
long_decimal,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 16 |
pol2,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish |
|
| 17 |
pol1,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince |
|
| 18 |
country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 19 |
major_geo,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 14 |
lat_decimal,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 15 |
long_decimal,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 20 | 16 |
plot_methodology,/location/locationevent/*_id/method/name, |
| 21 | 17 |
project,/location/locationevent/*_id/project/projectname, |
| 22 | 18 |
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| ... | ... | |
| 45 | 41 |
soil_texture,/location/locationevent/soilobs/texture, |
| 46 | 42 |
temp_c,/location/locationevent/temperature, |
| 47 | 43 |
locality_description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX" |
| 44 |
pol2,"/location/locationplace/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish |
|
| 45 |
pol1,"/location/locationplace/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince |
|
| 46 |
country,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
|
| 47 |
major_geo,"/location/locationplace/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
|
| 48 | 48 |
slope_aspect,/location/slopeaspect/_alt/1/_compass/value, |
| 49 | 49 |
slope_gradient,/location/slopegradient/_alt/1, |
| 50 | 50 |
observation_type,,"** No join mapping for observation_type ** Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type" |
| inputs/SALVIAS-CSV/Plot/test.xml.ref | ||
|---|---|---|
| 99 | 99 |
</to> |
| 100 | 100 |
</_range> |
| 101 | 101 |
</elevationrange> |
| 102 |
<locationdetermination>
|
|
| 102 |
<locationcoords>
|
|
| 103 | 103 |
<latitude> |
| 104 | 104 |
<_nullIf> |
| 105 | 105 |
<null>0</null> |
| ... | ... | |
| 114 | 114 |
<value>$long_decimal</value> |
| 115 | 115 |
</_nullIf> |
| 116 | 116 |
</longitude> |
| 117 |
<namedplace_id> |
|
| 118 |
<namedplace> |
|
| 119 |
<rank>county</rank> |
|
| 120 |
<placename>$pol2</placename> |
|
| 121 |
<parent_id> |
|
| 122 |
<namedplace> |
|
| 123 |
<rank>stateProvince</rank> |
|
| 124 |
<placename>$pol1</placename> |
|
| 125 |
<parent_id> |
|
| 126 |
<namedplace> |
|
| 127 |
<rank>country</rank> |
|
| 128 |
<placename>$country</placename> |
|
| 129 |
<parent_id> |
|
| 130 |
<namedplace> |
|
| 131 |
<rank>continent</rank> |
|
| 132 |
<placename>$major_geo</placename> |
|
| 133 |
</namedplace> |
|
| 134 |
</parent_id> |
|
| 135 |
</namedplace> |
|
| 136 |
</parent_id> |
|
| 137 |
</namedplace> |
|
| 138 |
</parent_id> |
|
| 139 |
</namedplace> |
|
| 140 |
</namedplace_id> |
|
| 141 |
</locationdetermination> |
|
| 117 |
</locationcoords> |
|
| 142 | 118 |
<locationevent> |
| 143 | 119 |
<method_id><method><name>$plot_methodology</name></method></method_id> |
| 144 | 120 |
<project_id><project><projectname>$project</projectname></project></project_id> |
| ... | ... | |
| 267 | 243 |
<temperature>$temp_c</temperature> |
| 268 | 244 |
</locationevent> |
| 269 | 245 |
<locationnarrative>$locality_description</locationnarrative> |
| 246 |
<locationplace> |
|
| 247 |
<namedplace_id> |
|
| 248 |
<namedplace> |
|
| 249 |
<rank>county</rank> |
|
| 250 |
<placename>$pol2</placename> |
|
| 251 |
<parent_id> |
|
| 252 |
<namedplace> |
|
| 253 |
<rank>stateProvince</rank> |
|
| 254 |
<placename>$pol1</placename> |
|
| 255 |
<parent_id> |
|
| 256 |
<namedplace> |
|
| 257 |
<rank>country</rank> |
|
| 258 |
<placename>$country</placename> |
|
| 259 |
<parent_id> |
|
| 260 |
<namedplace> |
|
| 261 |
<rank>continent</rank> |
|
| 262 |
<placename>$major_geo</placename> |
|
| 263 |
</namedplace> |
|
| 264 |
</parent_id> |
|
| 265 |
</namedplace> |
|
| 266 |
</parent_id> |
|
| 267 |
</namedplace> |
|
| 268 |
</parent_id> |
|
| 269 |
</namedplace> |
|
| 270 |
</namedplace_id> |
|
| 271 |
</locationplace> |
|
| 270 | 272 |
<slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect> |
| 271 | 273 |
<slopegradient>$slope_gradient</slopegradient> |
| 272 | 274 |
</location> |
| 273 | 275 |
</path> |
| 274 | 276 |
</_simplifyPath> |
| 275 | 277 |
</VegBIEN> |
| 276 |
Inserted 16 new rows into database |
|
| 278 |
Inserted 18 new rows into database |
|
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
authorObsCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else", |
| 3 |
locationAccuracy-m,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
|
| 4 |
publicLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 5 |
publicLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 6 |
county,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
|
| 7 |
state,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
|
| 3 |
locationAccuracy-m,/location/locationcoords/coordsaccuracy/_noCV/value/_alt/1, |
|
| 4 |
publicLatitude,"/location/locationcoords/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 5 |
publicLongitude,"/location/locationcoords/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
|
| 8 | 6 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode", |
| 9 | 7 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2", |
| 10 | 8 |
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode", |
| ... | ... | |
| 12 | 10 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
Also available in: Unified diff
schemas/vegbien.sql: Split locationdetermination into locationcoords and locationplace, so that coordinate determinations can be made separately from place determinations