Revision 5991
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 333 | 333 |
|
| 334 | 334 |
|
| 335 | 335 |
-- |
| 336 |
-- Name: sync_geoscrub_input_to_view(); Type: FUNCTION; Schema: public; Owner: - |
|
| 337 |
-- |
|
| 338 |
|
|
| 339 |
|
|
| 340 |
|
|
| 341 |
|
|
| 342 |
-- |
|
| 336 | 343 |
-- Name: taxonlabel_0_matched_label_id_self_ref(); Type: FUNCTION; Schema: public; Owner: - |
| 337 | 344 |
-- |
| 338 | 345 |
|
| ... | ... | |
| 1777 | 1784 |
|
| 1778 | 1785 |
|
| 1779 | 1786 |
-- |
| 1787 |
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1788 |
-- |
|
| 1789 |
|
|
| 1790 |
CREATE TABLE geoscrub_input ( |
|
| 1791 |
country text, |
|
| 1792 |
`stateProvince` text, |
|
| 1793 |
county text, |
|
| 1794 |
`decimalLatitude` double precision, |
|
| 1795 |
`decimalLongitude` double precision |
|
| 1796 |
); |
|
| 1797 |
|
|
| 1798 |
|
|
| 1799 |
-- |
|
| 1800 |
-- Name: geoscrub_input_view; Type: VIEW; Schema: public; Owner: - |
|
| 1801 |
-- |
|
| 1802 |
|
|
| 1803 |
|
|
| 1804 |
|
|
| 1805 |
|
|
| 1806 |
-- |
|
| 1780 | 1807 |
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1781 | 1808 |
-- |
| 1782 | 1809 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added geoscrub_input derived table with associated view. Build geoscrub_input as part of make_analytical_db().