Project

General

Profile

« Previous | Next » 

Revision 3948

mappings/VegCSV-VegBIEN.specimens.csv: decimalLatitude/decimalLongitude: Added _nullIf suffix for mergability with VegCSV-VegBIEN.specimens.csv

View differences:

inputs/Madidi/test/import.plots.xml.ref
35 35
        <locationdetermination>
36 36
            <latitude>
37 37
                <_alt>
38
                    <1>$Latitude</1>
39
                    <2>$Latitude (DMS)</2>
38
                    <1>
39
                        <_nullIf>
40
                            <null>0</null>
41
                            <type>float</type>
42
                            <value>
43
                                <_alt>
44
                                    <1>$Latitude</1>
45
                                    <2>$Latitude (DMS)</2>
46
                                </_alt>
47
                            </value>
48
                        </_nullIf>
49
                    </1>
40 50
                </_alt>
41 51
            </latitude>
42 52
            <longitude>
43 53
                <_alt>
44
                    <1>$Longitude</1>
45
                    <2>$Longitude (DMS)</2>
54
                    <1>
55
                        <_nullIf>
56
                            <null>0</null>
57
                            <type>float</type>
58
                            <value>
59
                                <_alt>
60
                                    <1>$Longitude</1>
61
                                    <2>$Longitude (DMS)</2>
62
                                </_alt>
63
                            </value>
64
                        </_nullIf>
65
                    </1>
46 66
                </_alt>
47 67
            </longitude>
48 68
        </locationdetermination>
inputs/Madidi/maps/VegBIEN.plots.csv
4 4
Minimum altitude,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
5 5
Minimum altitude,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
6 6
Topographical situation,/location/landform,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/landform,18
7
Latitude,/location/locationdetermination/latitude/_alt/1,,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
8
Latitude (DMS),/location/locationdetermination/latitude/_alt/2,,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
9
Longitude,/location/locationdetermination/longitude/_alt/1,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
10
Longitude (DMS),/location/locationdetermination/longitude/_alt/2,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
7
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
8
Latitude (DMS),"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
9
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
10
Longitude (DMS),"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
11 11
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName",", 1"
12 12
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0"
13 13
Inventory name,/location/locationevent/authorlocationcode,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName,1
inputs/CVS/test/import.organisms.xml.ref
5 5
            <coordsaccuracy><_noCV><value><_alt><1>$locationAccuracy-m</1></_alt></value></_noCV></coordsaccuracy>
6 6
            <latitude>
7 7
                <_alt>
8
                    <1>$realLatitude</1>
9
                    <2>$publicLatitude</2>
8
                    <1>
9
                        <_nullIf>
10
                            <null>0</null>
11
                            <type>float</type>
12
                            <value>
13
                                <_alt>
14
                                    <1>$realLatitude</1>
15
                                    <2>$publicLatitude</2>
16
                                </_alt>
17
                            </value>
18
                        </_nullIf>
19
                    </1>
10 20
                </_alt>
11 21
            </latitude>
12 22
            <longitude>
13 23
                <_alt>
14
                    <1>$realLongitude</1>
15
                    <2>$publicLongitude</2>
24
                    <1>
25
                        <_nullIf>
26
                            <null>0</null>
27
                            <type>float</type>
28
                            <value>
29
                                <_alt>
30
                                    <1>$realLongitude</1>
31
                                    <2>$publicLongitude</2>
32
                                </_alt>
33
                            </value>
34
                        </_nullIf>
35
                    </1>
16 36
                </_alt>
17 37
            </longitude>
18 38
            <namedplace_id>
inputs/CVS/maps/VegBIEN.organisms.csv
1 1
CVS,VegBIEN:,Comments,Source,Order within table
2 2
locationAccuracy-m,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/#coordinateUncertaintyInMeters,88
3
realLatitude,/location/locationdetermination/latitude/_alt/1,,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
4
publicLatitude,/location/locationdetermination/latitude/_alt/2,,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
5
realLongitude,/location/locationdetermination/longitude/_alt/1,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
6
publicLongitude,/location/locationdetermination/longitude/_alt/2,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
3
realLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
4
publicLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
5
realLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
6
publicLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
7 7
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/#county,66
8 8
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/#stateProvince,65
9 9
authorObsCode,/location/locationevent/authorlocationcode,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName,1
inputs/SALVIAS-CSV/test/import.plots.xml.ref
48 48
            </_range>
49 49
        </elevationrange>
50 50
        <locationdetermination>
51
            <latitude>$lat_decimal</latitude>
52
            <longitude>$long_decimal</longitude>
51
            <latitude>
52
                <_alt>
53
                    <1>
54
                        <_nullIf>
55
                            <null>0</null>
56
                            <type>float</type>
57
                            <value>$lat_decimal</value>
58
                        </_nullIf>
59
                    </1>
60
                </_alt>
61
            </latitude>
62
            <longitude>
63
                <_alt>
64
                    <1>
65
                        <_nullIf>
66
                            <null>0</null>
67
                            <type>float</type>
68
                            <value>$long_decimal</value>
69
                        </_nullIf>
70
                    </1>
71
                </_alt>
72
            </longitude>
53 73
            <namedplace_id>
54 74
                <_simplifyPath>
55 75
                    <next>parent_id/namedplace</next>
inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv
5 5
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
6 6
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
7 7
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_rangeEnd/value",,http://rs.tdwg.org/dwc/terms/#maximumElevationInMeters,72
8
lat_decimal,/location/locationdetermination/latitude,,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
9
long_decimal,/location/locationdetermination/longitude,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
8
lat_decimal,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
9
long_decimal,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
10 10
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish,http://rs.tdwg.org/dwc/terms/#county,66
11 11
pol1,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince,http://rs.tdwg.org/dwc/terms/#stateProvince,65
12 12
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
inputs/SALVIAS/test/import.plots.xml.ref
48 48
            </_range>
49 49
        </elevationrange>
50 50
        <locationdetermination>
51
            <latitude>$LatDec</latitude>
52
            <longitude>$LongDec</longitude>
51
            <latitude>
52
                <_alt>
53
                    <1>
54
                        <_nullIf>
55
                            <null>0</null>
56
                            <type>float</type>
57
                            <value>$LatDec</value>
58
                        </_nullIf>
59
                    </1>
60
                </_alt>
61
            </latitude>
62
            <longitude>
63
                <_alt>
64
                    <1>
65
                        <_nullIf>
66
                            <null>0</null>
67
                            <type>float</type>
68
                            <value>$LongDec</value>
69
                        </_nullIf>
70
                    </1>
71
                </_alt>
72
            </longitude>
53 73
            <namedplace_id>
54 74
                <_simplifyPath>
55 75
                    <next>parent_id/namedplace</next>
inputs/SALVIAS/maps/VegBIEN.plots.csv
5 5
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
6 6
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/#minimumElevationInMeters,71
7 7
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_rangeEnd/value",,http://rs.tdwg.org/dwc/terms/#maximumElevationInMeters,72
8
LatDec,/location/locationdetermination/latitude,,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
9
LongDec,/location/locationdetermination/longitude,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
8
LatDec,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
9
LongDec,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
10 10
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish,http://rs.tdwg.org/dwc/terms/#county,66
11 11
PolDiv1,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince,http://rs.tdwg.org/dwc/terms/#stateProvince,65
12 12
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
mappings/VegCSV-VegBIEN.specimens.csv
8 8
landform,/location/landform,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/landform,18
9 9
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/#coordinateUncertaintyInMeters,88
10 10
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91
11
decimalLatitude,/location/locationdetermination/latitude,,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
12
decimalLongitude,/location/locationdetermination/longitude,,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
11
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
12
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
13 13
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/#county,66
14 14
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/#stateProvince,65
15 15
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63

Also available in: Unified diff