Project

General

Profile

« Previous | Next » 

Revision 10565

Added by Aaron Marcuse-Kubitza almost 11 years ago

mappings/VegCore-VegBIEN.csv: mapped municipality

View differences:

inputs/HVAA/Specimen/test.xml.ref
270 270 
                                            <verbatimcoordinates>$verbatimCoordinates</verbatimcoordinates>
271 271 
                                        </coordinates>
272 272 
                                    </coordinates_id>
273 
                                    <placename_id>
274 
                                        <placename>
275 
                                            <rank>municipality</rank>
276 
                                            <placename>$municipality</placename>
277 
                                        </placename>
278 
                                    </placename_id>
273 279 
                                    <country>$country</country>
274 280 
                                    <county>$county</county>
275 281 
                                    <matched_place_id>
inputs/HVAA/Specimen/unmapped_terms.csv
13 13 
associatedTaxa
14 14 
lifeStage
15 15 
preparations
16 
municipality
17 16 
geodeticDatum
18 17 
coordinateUnits
19 18 
georeferencedBy
inputs/NCU/Specimen/VegBIEN.csv
48 48 
Longitude1,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
49 49 
Loc_AltN,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
50 50 
Loc_AltE,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
51 
CityLocality,/location/locationplace/*_id/place/*_id/placename[rank=municipality]/placename,
51 52 
Country,/location/locationplace/*_id/place/country,
52 53 
county,/location/locationplace/*_id/place/county,
53 54 
Latitude1,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
......
59 60 
BarCode,,"** No non-empty join mapping for OMIT#BarCode ** Omitted because this isn't specified on all rows, but SpecimenPK is"
60 61 
BlockLocationReason,,** No join mapping for *BlockLocationReason **
61 62 
BlockSpecificLocation,,** No join mapping for *BlockSpecificLocation **
62 
CityLocality,,** No join mapping for municipality **
63 63 
CollectionObjectID,,** No join mapping for *CollectionObjectID **
64 64 
CollectionObjectTypeID,,** No join mapping for *CollectionObjectTypeID **
65 65 
Cultivated,,** No join mapping for cultivated_verbatim **
inputs/NCU/Specimen/test.xml.ref
114 114 
                                            <verbatimlongitude>$Loc_AltE</verbatimlongitude>
115 115 
                                        </coordinates>
116 116 
                                    </coordinates_id>
117 
                                    <placename_id>
118 
                                        <placename>
119 
                                            <rank>municipality</rank>
120 
                                            <placename>$CityLocality</placename>
121 
                                        </placename>
122 
                                    </placename_id>
117 123 
                                    <country>$Country</country>
118 124 
                                    <county>$county</county>
119 125 
                                    <matched_place_id>
......
153 159 
        </path>
154 160 
    </_setDefault>
155 161 
</VegBIEN>
156 
Inserted 32 new rows into database
162 
Inserted 34 new rows into database
inputs/NCU/Specimen/unmapped_terms.csv
9 9 
*BlockSpecificLocation
10 10 
eventRemarks
11 11 
*FIPSStateCounty
12 
municipality
13 12 
cultivated_verbatim
14 13 
*LastAnnotationLabelTaxon
15 14 
*LastAnnotationDateVerbatim
inputs/ACAD/Specimen/test.xml.ref
233 233 
                                            </longitude_deg>
234 234 
                                        </coordinates>
235 235 
                                    </coordinates_id>
236 
                                    <placename_id>
237 
                                        <placename>
238 
                                            <rank>municipality</rank>
239 
                                            <placename>$municipality</placename>
240 
                                        </placename>
241 
                                    </placename_id>
236 242 
                                    <continent>$continent</continent>
237 243 
                                    <country>$country</country>
238 244 
                                    <county>$county</county>
inputs/ACAD/Specimen/unmapped_terms.csv
6 6 
language
7 7 
georeferenceVerificationStatus
8 8 
verbatimDepth
9 
municipality
10 9 
modified
11 10 
type
12 11 
identificationRemarks
inputs/WIN/Specimen/test.xml.ref
230 230 
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
231 231 
                                        </coordinates>
232 232 
                                    </coordinates_id>
233 
                                    <placename_id>
234 
                                        <placename>
235 
                                            <rank>municipality</rank>
236 
                                            <placename>$municipality</placename>
237 
                                        </placename>
238 
                                    </placename_id>
233 239 
                                    <country>$country</country>
234 240 
                                    <county>$county</county>
235 241 
                                    <matched_place_id>
inputs/WIN/Specimen/unmapped_terms.csv
1 1 
*row_num
2 
municipality
3 2 
dataOwners
4 3 
associatedMedia
5 4 
verbatimSRS
inputs/HIBG/Specimen/test.xml.ref
234 234 
                                            <verbatimcoordinates>$verbatimCoordinates</verbatimcoordinates>
235 235 
                                        </coordinates>
236 236 
                                    </coordinates_id>
237 
                                    <placename_id>
238 
                                        <placename>
239 
                                            <rank>municipality</rank>
240 
                                            <placename>$municipality</placename>
241 
                                        </placename>
242 
                                    </placename_id>
237 243 
                                    <continent>$continent</continent>
238 244 
                                    <country>$country</country>
239 245 
                                    <county>$county</county>
......
275 281 
        </path>
276 282 
    </_setDefault>
277 283 
</VegBIEN>
278 
Inserted 37 new rows into database
284 
Inserted 38 new rows into database
inputs/HIBG/Specimen/unmapped_terms.csv
18 18 
modified
19 19 
identificationRemarks
20 20 
georeferenceVerificationStatus
21 
municipality
22 21 
type
23 22 
language
24 23 
specimenOwner
inputs/ARIZ/omoccurrences/test.xml.ref
205 205 
                                            <verbatimcoordinates>$verbatimCoordinates</verbatimcoordinates>
206 206 
                                        </coordinates>
207 207 
                                    </coordinates_id>
208 
                                    <placename_id>
209 
                                        <placename>
210 
                                            <rank>municipality</rank>
211 
                                            <placename>$municipality</placename>
212 
                                        </placename>
213 
                                    </placename_id>
208 214 
                                    <country>$country</country>
209 215 
                                    <county>$county</county>
210 216 
                                    <matched_place_id>
inputs/ARIZ/omoccurrences/unmapped_terms.csv
24 24 
cultivated_verbatim
25 25 
lifeStage
26 26 
preparations
27 
municipality
28 27 
*localitySecurity
29 28 
*localitySecurityReason
30 29 
geodeticDatum
inputs/TRT/Specimen/test.xml.ref
270 270 
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
271 271 
                                        </coordinates>
272 272 
                                    </coordinates_id>
273 
                                    <placename_id>
274 
                                        <placename>
275 
                                            <rank>municipality</rank>
276 
                                            <placename>$municipality</placename>
277 
                                        </placename>
278 
                                    </placename_id>
273 279 
                                    <continent>$continent</continent>
274 280 
                                    <country>$country</country>
275 281 
                                    <county>$county</county>
inputs/TRT/Specimen/unmapped_terms.csv
22 22 
coordinateUnits
23 23 
higherClassification
24 24 
verbatimSRS
25 
municipality
26 25 
otherCatalogNumbers
27 26 
language
inputs/TRTE/Specimen/test.xml.ref
232 232 
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
233 233 
                                        </coordinates>
234 234 
                                    </coordinates_id>
235 
                                    <placename_id>
236 
                                        <placename>
237 
                                            <rank>municipality</rank>
238 
                                            <placename>$municipality</placename>
239 
                                        </placename>
240 
                                    </placename_id>
235 241 
                                    <country>$country</country>
236 242 
                                    <county>$county</county>
237 243 
                                    <matched_place_id>
inputs/TRTE/Specimen/unmapped_terms.csv
5 5 
basisOfRecord
6 6 
associatedTaxa
7 7 
verbatimEventDate
8 
municipality
9 8 
geodeticDatum
10 9 
nomenclaturalCode
11 10 
modified
mappings/VegCore-VegBIEN.csv
345 345 
verbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
346 346 
longitude_DMS,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
347 347 
verbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
348 
municipality,/location/locationplace/*_id/place/*_id/placename[rank=municipality]/placename,
348 349 
continent,/location/locationplace/*_id/place/continent,
349 350 
country,/location/locationplace/*_id/place/country,
350 351 
county,/location/locationplace/*_id/place/county,
mappings/for_review/VegCore-VegBIEN.csv
345 345 
verbatimLatitude,//coordinates/verbatimlatitude,
346 346 
longitude_DMS,//coordinates/verbatimlongitude,
347 347 
verbatimLongitude,//coordinates/verbatimlongitude,
348 
municipality,//*_id/placename[rank=municipality]/placename,
348 349 
continent,//place/continent,
349 350 
country,//place/country,
350 351 
county,//place/county,

Also available in: Unified diff