Revision 1020
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 991 | 991 |
|
| 992 | 992 |
|
| 993 | 993 |
-- |
| 994 |
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: - |
|
| 995 |
-- |
|
| 996 |
|
|
| 997 |
|
|
| 998 |
|
|
| 999 |
|
|
| 1000 |
-- |
|
| 994 | 1001 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 995 | 1002 |
-- |
| 996 | 1003 |
|
| ... | ... | |
| 1012 | 1019 |
locationdetermination_id int(11) NOT NULL, |
| 1013 | 1020 |
location_id int(11) NOT NULL, |
| 1014 | 1021 |
calculated int(1), |
| 1015 |
namedplace_id int(11) NOT NULL, |
|
| 1016 |
identifier_id int(11) |
|
| 1022 |
namedplace_id int(11), |
|
| 1023 |
identifier_id int(11), |
|
| 1024 |
latitude double precision, |
|
| 1025 |
longitude double precision, |
|
| 1026 |
coordsaccuracy double precision, |
|
| 1027 |
footprintgeometry_dwc text |
|
| 1017 | 1028 |
); |
| 1018 | 1029 |
|
| 1019 | 1030 |
|
| 1020 | 1031 |
-- |
| 1032 |
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 1033 |
-- |
|
| 1034 |
|
|
| 1035 |
|
|
| 1036 |
|
|
| 1037 |
|
|
| 1038 |
-- |
|
| 1021 | 1039 |
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1022 | 1040 |
-- |
| 1023 | 1041 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1155 | 1155 |
|
| 1156 | 1156 |
|
| 1157 | 1157 |
-- |
| 1158 |
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: - |
|
| 1159 |
-- |
|
| 1160 |
|
|
| 1161 |
COMMENT ON TABLE location IS 'VegBank''s plot table.'; |
|
| 1162 |
|
|
| 1163 |
|
|
| 1164 |
-- |
|
| 1158 | 1165 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1159 | 1166 |
-- |
| 1160 | 1167 |
|
| ... | ... | |
| 1181 | 1188 |
locationdetermination_id integer NOT NULL, |
| 1182 | 1189 |
location_id integer NOT NULL, |
| 1183 | 1190 |
calculated boolean, |
| 1184 |
namedplace_id integer NOT NULL, |
|
| 1185 |
identifier_id integer |
|
| 1191 |
namedplace_id integer, |
|
| 1192 |
identifier_id integer, |
|
| 1193 |
latitude double precision, |
|
| 1194 |
longitude double precision, |
|
| 1195 |
coordsaccuracy double precision, |
|
| 1196 |
footprintgeometry_dwc text |
|
| 1186 | 1197 |
); |
| 1187 | 1198 |
|
| 1188 | 1199 |
|
| 1189 | 1200 |
-- |
| 1201 |
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 1202 |
-- |
|
| 1203 |
|
|
| 1204 |
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).'; |
|
| 1205 |
|
|
| 1206 |
|
|
| 1207 |
-- |
|
| 1190 | 1208 |
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1191 | 1209 |
-- |
| 1192 | 1210 |
|
Also available in: Unified diff
vegbien.sql: locationdetermination: Added coordinates-related fields