Project

General

Profile

« Previous | Next » 

Revision 11264

Added by Aaron Marcuse-Kubitza about 11 years ago

bugfix: inputs/CVS/plot_/create.sql: like for VegBank, need to compare place.*PLOT_ID*, not PLOTPLACE_ID, with plot.PLOT_ID

View differences:

inputs/CVS/plot_/create.sql
4 4 
    FROM place
5 5 
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
6 6 
    WHERE
7 
    place."PLOTPLACE_ID" = plot."PLOT_ID"
7 
    place."PLOT_ID" = plot."PLOT_ID"
8 8 
    AND "placeSystem" = 'continent'
9 9 
    LIMIT 1
10 10 
    ) AS continent
......
12 12 
    FROM place
13 13 
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
14 14 
    WHERE
15 
    place."PLOTPLACE_ID" = plot."PLOT_ID"
15 
    place."PLOT_ID" = plot."PLOT_ID"
16 16 
    AND "placeSystem" = 'area|country|territory'
17 17 
    LIMIT 1
18 18 
    ) AS "area|country|territory"
......
20 20 
    FROM place
21 21 
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
22 22 
    WHERE
23 
    place."PLOTPLACE_ID" = plot."PLOT_ID"
23 
    place."PLOT_ID" = plot."PLOT_ID"
24 24 
    AND "placeSystem" = 'region|state|province'
25 25 
    LIMIT 1
26 26 
    ) AS "region|state|province"
......
28 28 
    FROM place
29 29 
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
30 30 
    WHERE
31 
    place."PLOTPLACE_ID" = plot."PLOT_ID"
31 
    place."PLOT_ID" = plot."PLOT_ID"
32 32 
    AND "placeSystem" = 'county'
33 33 
    LIMIT 1
34 34 
    ) AS county_
......
36 36 
    FROM place
37 37 
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
38 38 
    WHERE
39 
    place."PLOTPLACE_ID" = plot."PLOT_ID"
39 
    place."PLOT_ID" = plot."PLOT_ID"
40 40 
    AND "placeSystem" = 'quadrangle'
41 41 
    LIMIT 1
42 42 
    ) AS quadrangle
......
44 44 
    FROM place
45 45 
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
46 46 
    WHERE
47 
    place."PLOTPLACE_ID" = plot."PLOT_ID"
47 
    place."PLOT_ID" = plot."PLOT_ID"
48 48 
    AND "placeSystem" = 'Geographic Name'
49 49 
    LIMIT 1
50 50 
    ) AS "Geographic Name"
......
52 52 
    FROM place
53 53 
    JOIN "namedPlace" USING ("NAMEDPLACE_ID")
54 54 
    WHERE
55 
    place."PLOTPLACE_ID" = plot."PLOT_ID"
55 
    place."PLOT_ID" = plot."PLOT_ID"
56 56 
    AND "placeSystem" = 'River Basin'
57 57 
    LIMIT 1
58 58 
    ) AS "River Basin"

Also available in: Unified diff