1713 |
1713 |
geovalid_bien integer,
|
1714 |
1714 |
"isNewWorld_bien" integer,
|
1715 |
1715 |
"projectID" text,
|
|
1716 |
project_contributors text[],
|
1716 |
1717 |
"locationID" text NOT NULL,
|
1717 |
1718 |
"locationName" text,
|
1718 |
1719 |
subplot text,
|
... | ... | |
1924 |
1925 |
analytical_stem.geovalid_bien,
|
1925 |
1926 |
analytical_stem."isNewWorld_bien",
|
1926 |
1927 |
analytical_stem."projectID",
|
|
1928 |
analytical_stem.project_contributors,
|
1927 |
1929 |
analytical_stem."locationID",
|
1928 |
1930 |
analytical_stem."locationName",
|
1929 |
1931 |
analytical_stem.subplot,
|
... | ... | |
2572 |
2574 |
(geoscrub_output.geovalid)::integer AS geovalid_bien,
|
2573 |
2575 |
("newWorldCountries"."isNewWorld")::integer AS "isNewWorld_bien",
|
2574 |
2576 |
COALESCE(project.sourceaccessioncode, project.projectname) AS "projectID",
|
|
2577 |
ARRAY( SELECT project_contributors(project.project_id) AS project_contributors) AS project_contributors,
|
2575 |
2578 |
COALESCE(location.sourceaccessioncode, NULLIF(concat_ws('; '::text, COALESCE(parent_location.sourceaccessioncode, parent_location.authorlocationcode), location.authorlocationcode), ''::text)) AS "locationID",
|
2576 |
2579 |
COALESCE(parent_location.authorlocationcode, location.authorlocationcode) AS "locationName",
|
2577 |
2580 |
CASE
|
... | ... | |
2894 |
2897 |
"plot.**".geovalid_bien,
|
2895 |
2898 |
"plot.**"."isNewWorld_bien",
|
2896 |
2899 |
"plot.**"."projectID",
|
|
2900 |
"plot.**".project_contributors,
|
2897 |
2901 |
"plot.**"."locationID",
|
2898 |
2902 |
"plot.**"."locationName",
|
2899 |
2903 |
"plot.**".subplot,
|
... | ... | |
3024 |
3028 |
|
3025 |
3029 |
|
3026 |
3030 |
--
|
3027 |
|
-- Name: VIEW collected_dates; Type: COMMENT; Schema: public; Owner: -
|
3028 |
|
--
|
3029 |
|
|
3030 |
|
COMMENT ON VIEW collected_dates IS 'runtime: 2.5 min ("155959 ms. 52527 rows retrieved.")';
|
3031 |
|
|
3032 |
|
|
3033 |
|
--
|
3034 |
3031 |
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
3035 |
3032 |
--
|
3036 |
3033 |
|
schemas/vegbien.sql: plot.**, analytical_stem_view, analytical_plot: added project_contributors