Project

General

Profile

« Previous | Next » 

Revision 12633

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/vegbien.sql: plot: removed explicit column lists added in the autorename of plot.location_id->plot_id

View differences:

trunk/schemas/vegbien.sql
7340 7340 
CREATE VIEW _plots_06_list_of_plots_with_stem_measurements AS
7341 7341 
 SELECT project.projectname AS project_name,
7342 7342 
    plot.authorlocationcode AS plot_code
7343 
   FROM ((public.plot plot(location_id, source_id, sourceaccessioncode, plot, parent_id, authorlocationcode, place_id, accesslevel, accessconditions, sublocationxposition_m, sublocationyposition_m, iscultivated, authorzone, authordatum, authorlocation, locationnarrative, azimuth, shape, area_m2, standsize, placementmethod, permanence, layoutnarrative, elevation_m, elevationaccuracy_m, elevationrange_m, verbatimelevation, slopeaspect_deg, minslopeaspect_deg, maxslopeaspect_deg, slopegradient_fraction, minslopegradient_fraction, maxslopegradient_fraction, topoposition, landform, surficialdeposits, rocktype, submitter_surname, submitter_givenname, submitter_email, notespublic, notesmgt, revisions, dateentered, locationrationalenarrative)
7344 
   JOIN public.locationevent USING (location_id))
7343 
   FROM ((public.plot
7344 
   JOIN public.locationevent USING (plot_id))
7345 7345 
   LEFT JOIN public.project USING (project_id))
7346 7346 
  WHERE ((plot.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown
7347 7347 
   FROM (((((public.location
......
7350 7350 
   JOIN public.aggregateoccurrence USING (taxonoccurrence_id))
7351 7351 
   JOIN public.plantobservation USING (aggregateoccurrence_id))
7352 7352 
   JOIN public.stemobservation USING (plantobservation_id))
7353 
  WHERE ((location.plot_location_id = plot.location_id) AND ((stemobservation.sourceaccessioncode IS NOT NULL) OR (stemobservation.authorstemcode IS NOT NULL)))
7353 
  WHERE ((location.plot_location_id = plot.plot_id) AND ((stemobservation.sourceaccessioncode IS NOT NULL) OR (stemobservation.authorstemcode IS NOT NULL)))
7354 7354 
 LIMIT 1)))
7355 7355 
  ORDER BY plot.authorlocationcode;
7356 7356 

  		












Also available in:  Unified diff