Project

General

Profile

« Previous | Next » 

Revision 7681

Added by Aaron Marcuse-Kubitza almost 12 years ago

mappings/VegCore-VegBIEN.csv: Mapped latitude/longitude_DMS to coordinates.latitude_deg using new _dms_to_dd(text)

View differences:

inputs/TEX/Specimen2/VegBIEN.csv
47 47 
COLLECTOR NUMBER,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
48 48 
LOCALITY,/location/locationnarrative/_merge/1,
49 49 
VEGETATION,"/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?"
50 
LATITUDE,/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_dms_to_dd/value,
51 
LONGITUDE,/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_dms_to_dd/value,
50 52 
LATITUDE,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
51 53 
LONGITUDE,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
52 54 
COUNTY,/location/locationplace/*_id/place/county,
55 
LATITUDE,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_dms_to_dd/value",
56 
LONGITUDE,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_dms_to_dd/value",
53 57 
COUNTY,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
54 58 
STATE,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
55 59 
STATE,/location/locationplace/*_id/place/stateprovince,
inputs/TEX/Specimen2/test.xml.ref
207 207 
                                <place>
208 208 
                                    <coordinates_id>
209 209 
                                        <coordinates>
210 
                                            <latitude_deg><_dms_to_dd><value>$LATITUDE</value></_dms_to_dd></latitude_deg>
211 
                                            <longitude_deg><_dms_to_dd><value>$LONGITUDE</value></_dms_to_dd></longitude_deg>
210 212 
                                            <verbatimlatitude>$LATITUDE</verbatimlatitude>
211 213 
                                            <verbatimlongitude>$LONGITUDE</verbatimlongitude>
212 214 
                                        </coordinates>
......
215 217 
                                    <matched_place_id>
216 218 
                                        <place>
217 219 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
220 
                                            <coordinates_id>
221 
                                                <coordinates>
222 
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
223 
                                                    <latitude_deg><_dms_to_dd><value>$LATITUDE</value></_dms_to_dd></latitude_deg>
224 
                                                    <longitude_deg><_dms_to_dd><value>$LONGITUDE</value></_dms_to_dd></longitude_deg>
225 
                                                </coordinates>
226 
                                            </coordinates_id>
218 227 
                                            <county>$COUNTY</county>
219 228 
                                            <stateprovince>$STATE</stateprovince>
220 229 
                                        </place>
......
230 239 
        </path>
231 240 
    </_setDefault>
232 241 
</VegBIEN>
233 
Inserted 11 new rows into database
242 
Inserted 13 new rows into database

Also available in: Unified diff