Project

General

Profile

« Previous | Next » 

Revision 9415

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: place.geovalid: added latLongDomainValid to the values to _and together

View differences:

inputs/.geoscrub/geoscrub_output/unmapped_terms.csv
1 
latLongDomainValid
inputs/.geoscrub/geoscrub_output/VegBIEN.csv
10 10 
stateprovincestd,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub,matched_place_id=0]/stateprovince/_first/1",
11 11 
country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2,
12 12 
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
13 
countryvalidity,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/1/_map:[./{""-1"",0}=,1=false,./{2,3}=true]/value","""For countryvalidity/stateprovincevalidity/countyvalidity:
13 
latlonvalidity,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/1/_map:[""-1""=,0=false,1=true]/value","""For latlonvalidity:
14 
-1: Latitude and/or longitude is null
15 
 0: Coordinate is not a valid geographic location
16 
 1: Coordinate is a valid geographic location
17 
"" (http://vegpath.org/fs/inputs/.geoscrub/_src/README.TXT)"
18 
countryvalidity,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/2/_map:[./{""-1"",0}=,1=false,./{2,3}=true]/value","""For countryvalidity/stateprovincevalidity/countyvalidity:
14 19 
-1: Name is null at this or some higher level
15 20 
 0: Complete name provided, but couldn't be scrubbed to GADM
16 21 
 1: Point is >5km from putative GADM polygon
17 22 
 2: Point is <=5km from putative GADM polygon, but still outside it
18 23 
 3: Point is in (or on border of) putative GADM polygon
19 24 
"" (http://vegpath.org/fs/inputs/.geoscrub/_src/README.TXT)"
20 
stateprovincevalidity,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/2/_map:[./{""-1"",0}=,1=false,./{2,3}=true]/value","""For countryvalidity/stateprovincevalidity/countyvalidity:
25 
stateprovincevalidity,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/3/_map:[./{""-1"",0}=,1=false,./{2,3}=true]/value","""For countryvalidity/stateprovincevalidity/countyvalidity:
21 26 
-1: Name is null at this or some higher level
22 27 
 0: Complete name provided, but couldn't be scrubbed to GADM
23 28 
 1: Point is >5km from putative GADM polygon
24 29 
 2: Point is <=5km from putative GADM polygon, but still outside it
25 30 
 3: Point is in (or on border of) putative GADM polygon
26 31 
"" (http://vegpath.org/fs/inputs/.geoscrub/_src/README.TXT)"
27 
countyvalidity,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/3/_map:[./{""-1"",0}=,1=false,./{2,3}=true]/value","""For countryvalidity/stateprovincevalidity/countyvalidity:
32 
countyvalidity,"/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/4/_map:[./{""-1"",0}=,1=false,./{2,3}=true]/value","""For countryvalidity/stateprovincevalidity/countyvalidity:
28 33 
-1: Name is null at this or some higher level
29 34 
 0: Complete name provided, but couldn't be scrubbed to GADM
30 35 
 1: Point is >5km from putative GADM polygon
......
33 38 
"" (http://vegpath.org/fs/inputs/.geoscrub/_src/README.TXT)"
34 39 
stateprovince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
35 40 
stateprovince,/location/locationplace/*_id/place/stateprovince,
36 
latlonvalidity,,"** No join mapping for latLongDomainValid/_map:[""-1""=,0=false,1=true]/value ** ""For latlonvalidity:
37 
-1: Latitude and/or longitude is null
38 
 0: Coordinate is not a valid geographic location
39 
 1: Coordinate is a valid geographic location
40 
"" (http://vegpath.org/fs/inputs/.geoscrub/_src/README.TXT)"
inputs/.geoscrub/geoscrub_output/test.xml.ref
63 63 
                                                        <1>
64 64 
                                                            <_map>
65 65 
                                                                <-1></-1>
66 
                                                                <0>false</0>
67 
                                                                <1>true</1>
68 
                                                                <value>$latlonvalidity</value>
69 
                                                            </_map>
70 
                                                        </1>
71 
                                                        <2>
72 
                                                            <_map>
73 
                                                                <-1></-1>
66 74 
                                                                <0></0>
67 75 
                                                                <1>false</1>
68 76 
                                                                <2>true</2>
69 77 
                                                                <3>true</3>
70 78 
                                                                <value>$countryvalidity</value>
71 79 
                                                            </_map>
72 
                                                        </1>
73 
                                                        <2>
80 
                                                        </2>
81 
                                                        <3>
74 82 
                                                            <_map>
75 83 
                                                                <-1></-1>
76 84 
                                                                <0></0>
......
79 87 
                                                                <3>true</3>
80 88 
                                                                <value>$stateprovincevalidity</value>
81 89 
                                                            </_map>
82 
                                                        </2>
83 
                                                        <3>
90 
                                                        </3>
91 
                                                        <4>
84 92 
                                                            <_map>
85 93 
                                                                <-1></-1>
86 94 
                                                                <0></0>
......
89 97 
                                                                <3>true</3>
90 98 
                                                                <value>$countyvalidity</value>
91 99 
                                                            </_map>
92 
                                                        </3>
100 
                                                        </4>
93 101 
                                                    </_and>
94 102 
                                                </_alt>
95 103 
                                            </geovalid>
mappings/VegCore-VegBIEN.csv
368 368 
distanceToCountry_km,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/distance_to_country_m/_km_to_m/value,
369 369 
distanceToStateProvince_km,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/distance_to_state_m/_km_to_m/value,
370 370 
geovalid,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/1,
371 
latLongInCountry,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/1,
372 
latLongInStateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/2,
373 
latLongInCounty,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/3,
371 
latLongDomainValid,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/1,
372 
latLongInCountry,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/2,
373 
latLongInStateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/3,
374 
latLongInCounty,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_alt:[2=false]/_first/2/_and/4,
374 375 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
375 376 
stateProvince,/location/locationplace/*_id/place/stateprovince,
376 377 
parentPlotName,/location/parent_id/location/authorlocationcode,
mappings/for_review/VegCore-VegBIEN.csv
368 368 
distanceToCountry_km,//place/distance_to_country_m/_km_to_m/value,
369 369 
distanceToStateProvince_km,//place/distance_to_state_m/_km_to_m/value,
370 370 
geovalid,//place/geovalid/1,
371 
latLongDomainValid,//place/geovalid/2,
371 372 
latLongInCountry,//place/geovalid/2,
372 373 
latLongInStateProvince,//place/geovalid/2,
373 374 
latLongInCounty,//place/geovalid/2,

Also available in: Unified diff