Project

General

Profile

« Previous | Next » 

Revision 1023

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: locationdetermination: Reordered fields

View differences:

schemas/vegbien.my.sql
1018 1018 
CREATE TABLE locationdetermination (
1019 1019 
    locationdetermination_id int(11) NOT NULL,
1020 1020 
    location_id int(11) NOT NULL,
1021 
    calculated int(1),
1022 
    namedplace_id int(11),
1023 
    identifier_id int(11),
1024 1021 
    latitude double precision,
1025 1022 
    longitude double precision,
1023 
    footprintgeometry_dwc text,
1026 1024 
    coordsaccuracy double precision,
1027 
    footprintgeometry_dwc text,
1025 
    namedplace_id int(11),
1026 
    identifier_id int(11),
1027 
    determinationdate timestamp NULL,
1028 1028 
    isoriginal int(1) DEFAULT false NOT NULL,
1029 1029 
    iscurrent int(1) DEFAULT false NOT NULL,
1030 
    determinationdate timestamp NULL
1030 
    calculated int(1)
1031 1031 
);
1032 1032 

  		




  1033
  1033
  
    

  		




  ......




  1039
  1039
  
    

  		




  1040
  1040
  
    

  		




  1041
  1041
  
    
--


  		




  1042
  
  
    
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -


  		




  
  1042
  
    
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  1043
  1043
  
    
--


  		




  1044
  1044
  
    

  		




  1045
  1045
  
    

  		




  1046
  1046
  
    

  		




  1047
  1047
  
    

  		




  1048
  1048
  
    
--


  		




  1049
  
  
    
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  
  1049
  
    
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -


  		




  1050
  1050
  
    
--


  		




  1051
  1051
  
    

  		




  1052
  1052
  
    

  		












  

    
      schemas/vegbien.sql
    
  





  1187
  1187
  
    
CREATE TABLE locationdetermination (


  		




  1188
  1188
  
    
    locationdetermination_id integer NOT NULL,


  		




  1189
  1189
  
    
    location_id integer NOT NULL,


  		




  1190
  
  
    
    calculated boolean,


  		




  1191
  
  
    
    namedplace_id integer,


  		




  1192
  
  
    
    identifier_id integer,


  		




  1193
  1190
  
    
    latitude double precision,


  		




  1194
  1191
  
    
    longitude double precision,


  		




  
  1192
  
    
    footprintgeometry_dwc text,


  		




  1195
  1193
  
    
    coordsaccuracy double precision,


  		




  1196
  
  
    
    footprintgeometry_dwc text,


  		




  
  1194
  
    
    namedplace_id integer,


  		




  
  1195
  
    
    identifier_id integer,


  		




  
  1196
  
    
    determinationdate timestamp with time zone,


  		




  1197
  1197
  
    
    isoriginal boolean DEFAULT false NOT NULL,


  		




  1198
  1198
  
    
    iscurrent boolean DEFAULT false NOT NULL,


  		




  1199
  
  
    
    determinationdate timestamp with time zone


  		




  
  1199
  
    
    calculated boolean


  		




  1200
  1200
  
    
);


  		




  1201
  1201
  
    

  		




  1202
  1202
  
    

  		




  ......




  1208
  1208
  
    

  		




  1209
  1209
  
    

  		




  1210
  1210
  
    
--


  		




  1211
  
  
    
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -


  		




  
  1211
  
    
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  1212
  1212
  
    
--


  		




  1213
  1213
  
    

  		




  1214
  
  
    
COMMENT ON COLUMN locationdetermination.coordsaccuracy 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.';


  		




  
  1214
  
    
COMMENT ON COLUMN locationdetermination.footprintgeometry_dwc IS 'DwC''s footprintWKT field. "A Well-Known Text (WKT) representation of the shape (footprint, geometry) that defines the Location" (http://rs.tdwg.org/dwc/terms/#footprintWKT).';


  		




  1215
  1215
  
    

  		




  1216
  1216
  
    

  		




  1217
  1217
  
    
--


  		




  1218
  
  
    
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -


  		




  
  1218
  
    
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -


  		




  1219
  1219
  
    
--


  		




  1220
  1220
  
    

  		




  1221
  
  
    
COMMENT ON COLUMN locationdetermination.footprintgeometry_dwc IS 'DwC''s footprintWKT field. "A Well-Known Text (WKT) representation of the shape (footprint, geometry) that defines the Location" (http://rs.tdwg.org/dwc/terms/#footprintWKT).';


  		




  
  1221
  
    
COMMENT ON COLUMN locationdetermination.coordsaccuracy 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.';


  		




  1222
  1222
  
    

  		




  1223
  1223
  
    

  		




  1224
  1224
  
    
--


  		












Also available in:  Unified diff