Project

General

Profile

« Previous | Next » 

Revision 11745

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: inputs/CVS/plot_/map.csv: removed filter-less collisions. note that the name county_ is assigned in plot_/create.sql, not cvs.~.clean_up.sql as one might expect, because this is a generated column.

View differences:

inputs/CVS/plot_/map.csv
60 60 
continent,continent,,
61 61 
area|country|territory,DUPLICATE#of:COUNTRY#area|country|territory,,
62 62 
region|state|province,DUPLICATE#of:stateProvince#region|state|province,,
63 
county_,county,,
63 
county_,DUPLICATE#of:county#county_,,
64 64 
quadrangle,*quadrangle,,
65 65 
Geographic Name,*Geographic Name,,
66 66 
River Basin,*River Basin,,
inputs/CVS/plot_/VegBIEN.csv
21 21 
continent,/location/locationplace/*_id/place/continent,
22 22 
COUNTRY,/location/locationplace/*_id/place/country,
23 23 
county,/location/locationplace/*_id/place/county,
24 
county_,/location/locationplace/*_id/place/county,
25 24 
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/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
26 25 
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/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
27 26 
COUNTRY,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2,
28 27 
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
29 
county_,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
30 28 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
31 29 
stateProvince,/location/locationplace/*_id/place/stateprovince,
32 30 
PARENT_ID,/location/parent_id/location/sourceaccessioncode,
......
55 53 
confidentialityReason,,** No join mapping for *confidentialityReason **
56 54 
confidentialityStatus,,** No join mapping for accessRights_verbatim **
57 55 
coordinateUncertaintyInMeters__from_fuzzing,,** No join mapping for coordinateUncertaintyInMeters__from_fuzzing **
56 
county_,,** No non-empty join mapping for DUPLICATE#of:county#county_ **
58 57 
cust_cvs_province,,** No join mapping for *cust_cvs_province **
59 58 
cust_eep_reach,,** No join mapping for *cust_eep_reach **
60 59 
dateentered,,** No join mapping for *dateentered **
inputs/CVS/plot_/test.xml.ref
40 40 
                                    </coordinates_id>
41 41 
                                    <continent>$continent</continent>
42 42 
                                    <country>$COUNTRY</country>
43 
                                    <county>
44 
                                        <_alt>
45 
                                            <0>$county</0>
46 
                                            <1>$county_</1>
47 
                                        </_alt>
48 
                                    </county>
43 
                                    <county>$county</county>
49 44 
                                    <matched_place_id>
50 45 
                                        <place>
51 46 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
......
69 64 
                                                </coordinates>
70 65 
                                            </coordinates_id>
71 66 
                                            <country>$COUNTRY</country>
72 
                                            <county>
73 
                                                <_alt>
74 
                                                    <0>$county</0>
75 
                                                    <1>$county_</1>
76 
                                                </_alt>
77 
                                            </county>
67 
                                            <county>$county</county>
78 68 
                                            <stateprovince>$stateProvince</stateprovince>
79 69 
                                        </place>
80 70 
                                    </matched_place_id>

Also available in: Unified diff