Revision 1020
Added by Aaron Marcuse-Kubitza almost 13 years ago
| 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 |
|
Also available in: Unified diff
vegbien.sql: locationdetermination: Added coordinates-related fields