Project

General

Profile

« Previous | Next » 

Revision 6250

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: coordinates: Changed coordinates.coordsaccuracy_deg units to m

View differences:

inputs/XAL/Specimen/VegBIEN.csv
56 56 
darwin:MaximumDepth,/location/locationevent/waterdepth_m/_avg/max,
57 57 
darwin:MinimumDepth,/location/locationevent/waterdepth_m/_avg/min,
58 58 
darwin:Locality,/location/locationnarrative/_merge/1,
59 
darwin:CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/2,
59 
darwin:CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2,
60 60 
darwin:Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
61 61 
darwin:Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
62 62 
darwin:ContinentOcean,/location/locationplace/*_id/place/continent,
inputs/SpeciesLink/Specimen/VegBIEN.csv
192 192 
conceptual_darwin_2003_1_0_Locality,/location/locationnarrative/_merge/1,
193 193 
dwc_dwcore_Locality,/location/locationnarrative/_merge/1,
194 194 
dwc_terms_locality,/location/locationnarrative/_merge/1,
195 
dwc_terms_coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
196 
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/2,
195 
dwc_terms_coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,
196 
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2,
197 197 
conceptual_darwin_2003_1_0_BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
198 198 
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
199 199 
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
inputs/SpeciesLink/Specimen/test.xml.ref
567 567 
                        <place>
568 568 
                            <coordinates_id>
569 569 
                                <coordinates>
570 
                                    <coordsaccuracy_deg>
570 
                                    <coordsaccuracy_m>
571 571 
                                        <_noCV>
572 572 
                                            <value>
573 573 
                                                <_alt>
......
576 576 
                                                </_alt>
577 577 
                                            </value>
578 578 
                                        </_noCV>
579 
                                    </coordsaccuracy_deg>
579 
                                    </coordsaccuracy_m>
580 580 
                                    <footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc>
581 581 
                                    <latitude_deg>
582 582 
                                        <_nullIf>
inputs/NY/Specimen/VegBIEN.csv
63 63 
Substrate,"/location/locationnarrative/_merge/1/_join/2/_label[label=""substrate""]/value",
64 64 
Vegetation,"/location/locationnarrative/_merge/1/_join/3/_label[label=""vegetation""]/value",
65 65 
Habitat,"/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?"
66 
CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/2,
66 
CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2,
67 67 
BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
68 68 
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
69 69 
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
inputs/NY/Specimen/test.xml.ref
310 310 
                        <place>
311 311 
                            <coordinates_id>
312 312 
                                <coordinates>
313 
                                    <coordsaccuracy_deg><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy_deg>
313 
                                    <coordsaccuracy_m><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy_m>
314 314 
                                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
315 315 
                                    <latitude_deg>
316 316 
                                        <_nullIf>
inputs/CVS/Organism/VegBIEN.csv
12 12 
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
13 13 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
14 14 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
15 
locationAccuracy-m,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
15 
locationAccuracy-m,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,
16 16 
publicLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
17 17 
publicLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
18 18 
county,/location/locationplace/*_id/place/county,
inputs/CVS/Organism/test.xml.ref
36 36 
                        <place>
37 37 
                            <coordinates_id>
38 38 
                                <coordinates>
39 
                                    <coordsaccuracy_deg><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy_deg>
39 
                                    <coordsaccuracy_m><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy_m>
40 40 
                                    <latitude_deg>
41 41 
                                        <_nullIf>
42 42 
                                            <null>0</null>
inputs/ARIZ/Specimen/VegBIEN.csv
67 67 
MaximumDepthInMeters,/location/locationevent/waterdepth_m/_avg/max,
68 68 
MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/min,
69 69 
Locality,/location/locationnarrative/_merge/1,
70 
CoordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
70 
CoordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,
71 71 
BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
72 72 
DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
73 73 
DecimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
inputs/ARIZ/Specimen/test.xml.ref
286 286 
                        <place>
287 287 
                            <coordinates_id>
288 288 
                                <coordinates>
289 
                                    <coordsaccuracy_deg><_noCV><value>$CoordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_deg>
289 
                                    <coordsaccuracy_m><_noCV><value>$CoordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
290 290 
                                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
291 291 
                                    <latitude_deg>
292 292 
                                        <_nullIf>
inputs/NCU-NCSC/Specimen/VegBIEN.csv
15 15 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
16 16 
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
17 17 
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
18 
Accuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
18 
Accuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,
19 19 
Lat (-=S),"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
20 20 
Long (-=W),"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
21 21 
Country,/location/locationplace/*_id/place/country,
inputs/NCU-NCSC/Specimen/test.xml.ref
61 61 
                        <place>
62 62 
                            <coordinates_id>
63 63 
                                <coordinates>
64 
                                    <coordsaccuracy_deg><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy_deg>
64 
                                    <coordsaccuracy_m><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy_m>
65 65 
                                    <latitude_deg>
66 66 
                                        <_nullIf>
67 67 
                                            <null>0</null>
inputs/VegBank/plot_/VegBIEN.csv
13 13 
authorplotcode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
14 14 
plot_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
15 15 
locationnarrative,/location/locationnarrative/_merge/1,
16 
locationaccuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
16 
locationaccuracy,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,
17 17 
shape,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
18 18 
latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
19 19 
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
inputs/VegBank/plot_/test.xml.ref
27 27 
                        <place>
28 28 
                            <coordinates_id>
29 29 
                                <coordinates>
30 
                                    <coordsaccuracy_deg><_noCV><value>$locationaccuracy</value></_noCV></coordsaccuracy_deg>
30 
                                    <coordsaccuracy_m><_noCV><value>$locationaccuracy</value></_noCV></coordsaccuracy_m>
31 31 
                                    <footprintgeometry_dwc>$shape</footprintgeometry_dwc>
32 32 
                                    <latitude_deg>
33 33 
                                        <_nullIf>
inputs/QMOR/Specimen/VegBIEN.csv
67 67 
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
68 68 
locality,/location/locationnarrative/_merge/1,
69 69 
habitat,"/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?"
70 
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,
70 
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,
71 71 
footprintWKT,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
72 72 
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
73 73 
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
inputs/QMOR/Specimen/test.xml.ref
247 247 
                        <place>
248 248 
                            <coordinates_id>
249 249 
                                <coordinates>
250 
                                    <coordsaccuracy_deg><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_deg>
250 
                                    <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
251 251 
                                    <footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc>
252 252 
                                    <latitude_deg>
253 253 
                                        <_nullIf>
schemas/vegbien.my.sql
757 757 
    verbatimlongitude text,
758 758 
    verbatimcoordinates text,
759 759 
    footprintgeometry_dwc text,
760 
    coordsaccuracy_deg double precision
760 
    coordsaccuracy_m double precision
761 761 
);
762 762 

  		




  763
  763
  
    

  		




  ......




  769
  769
  
    

  		




  770
  770
  
    

  		




  771
  771
  
    
--


  		




  772
  
  
    
-- Name: COLUMN coordinates.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -


  		




  
  772
  
    
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -


  		




  773
  773
  
    
--


  		




  774
  774
  
    

  		




  775
  775
  
    

  		












  

    
      schemas/vegbien.sql
    
  





  1414
  1414
  
    
    verbatimlongitude text,


  		




  1415
  1415
  
    
    verbatimcoordinates text,


  		




  1416
  1416
  
    
    footprintgeometry_dwc text,


  		




  1417
  
  
    
    coordsaccuracy_deg double precision


  		




  
  1417
  
    
    coordsaccuracy_m double precision


  		




  1418
  1418
  
    
);


  		




  1419
  1419
  
    

  		




  1420
  1420
  
    

  		




  ......




  1426
  1426
  
    

  		




  1427
  1427
  
    

  		




  1428
  1428
  
    
--


  		




  1429
  
  
    
-- Name: COLUMN coordinates.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -


  		




  
  1429
  
    
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -


  		




  1430
  1430
  
    
--


  		




  1431
  1431
  
    

  		




  1432
  
  
    
COMMENT ON COLUMN coordinates.coordsaccuracy_deg IS 'Accuracy of latitude/longitude or footprint geometry, in meters. This should generally be at least 1 m, which is the accuracy of the best GPSes.';


  		




  
  1432
  
    
COMMENT ON COLUMN coordinates.coordsaccuracy_m IS 'Accuracy of latitude/longitude or footprint geometry, in meters. This should generally be at least 1 m, which is the accuracy of the best GPSes.';


  		




  1433
  1433
  
    

  		




  1434
  1434
  
    

  		




  1435
  1435
  
    
--


  		












  

    
      mappings/VegCore-VegBIEN.csv
    
  





  314
  314
  
    
locality,/location/locationnarrative/_merge/1,


  		




  315
  315
  
    
verbatimLocality,/location/locationnarrative/_merge/2,


  		




  316
  316
  
    
habitat,"/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?"


  		




  317
  
  
    
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/1,


  		




  318
  
  
    
coordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_deg/_noCV/value/_alt/2,


  		




  
  317
  
    
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,


  		




  
  318
  
    
coordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2,


  		




  319
  319
  
    
footprintWKT,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,


  		




  320
  320
  
    
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",


  		




  321
  321
  
    
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",


  		












  

    
      mappings/for_review/VegCore-VegBIEN.csv
    
  





  314
  314
  
    
locality,//location/locationnarrative,


  		




  315
  315
  
    
verbatimLocality,//location/locationnarrative,


  		




  316
  316
  
    
habitat,"//location/locationnarrative/_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?"


  		




  317
  
  
    
coordinateUncertaintyInMeters,//coordinates/coordsaccuracy_deg,


  		




  318
  
  
    
coordinatePrecision,//coordinates/coordsaccuracy_deg,


  		




  
  317
  
    
coordinateUncertaintyInMeters,//coordinates/coordsaccuracy_m,


  		




  
  318
  
    
coordinatePrecision,//coordinates/coordsaccuracy_m,


  		




  319
  319
  
    
footprintWKT,//coordinates/footprintgeometry_dwc,


  		




  320
  320
  
    
decimalLatitude,//coordinates/latitude_deg,


  		




  321
  321
  
    
decimalLongitude,//coordinates/longitude_deg,


  		












Also available in:  Unified diff