Revision 580
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_wiki.sql | ||
|---|---|---|
| 4 | 4 |
authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying, |
| 5 | 5 |
reference_id integer, |
| 6 | 6 |
parent_id integer, |
| 7 |
reallatitude double precision, |
|
| 8 |
reallongitude double precision, |
|
| 7 |
reallatitude double precision NOT NULL DEFAULT 'NaN'::double precision,
|
|
| 8 |
reallongitude double precision NOT NULL DEFAULT 'NaN'::double precision,
|
|
| 9 | 9 |
locationaccuracy double precision, |
| 10 | 10 |
confidentialitystatus integer NOT NULL DEFAULT 0, |
| 11 | 11 |
confidentialityreason character varying(200), |
| 12 |
latitude double precision, |
|
| 13 |
longitude double precision, |
|
| 12 |
publiclatitude double precision,
|
|
| 13 |
publiclongitude double precision,
|
|
| 14 | 14 |
"... (truncated) ..." integer, |
| 15 | 15 |
accessioncode character varying(255), |
| 16 | 16 |
sublocationxposition double precision, |
Also available in: Unified diff
vegbien.sql: Renamed location.latitude and longitude to publiclatitude, publiclongitude to reflect that they are not the actual lat/long. Switched to requiring reallatitude/reallongitude.