Revision 6265
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 287 | 287 |
CREATE TABLE place ( |
| 288 | 288 |
place_id int(11) NOT NULL, |
| 289 | 289 |
source_id int(11) NOT NULL, |
| 290 |
placecode text, |
|
| 291 | 290 |
canon_place_id int(11), |
| 292 | 291 |
matched_place_id int(11), |
| 293 | 292 |
coordinates_id int(11), |
| ... | ... | |
| 5013 | 5012 |
|
| 5014 | 5013 |
|
| 5015 | 5014 |
-- |
| 5016 |
-- Name: place_unique_within_creator_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5017 |
-- |
|
| 5018 |
|
|
| 5019 |
|
|
| 5020 |
|
|
| 5021 |
|
|
| 5022 |
-- |
|
| 5023 | 5015 |
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5024 | 5016 |
-- |
| 5025 | 5017 |
|
Also available in: Unified diff
schemas/vegbien.sql: place: Removed placecode to prevent datasources from creating duplicate entries for the same place, with different placecodes. This was a problem with the original BIEN2 geoscrub dataset, which contained duplicates.