Changes between Version 31 and Version 32 of CookBook join BDMAP_CCM
- Timestamp:
- Feb 11, 2010 10:34:03 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join BDMAP_CCM
v31 v32 55 55 * also I'm using 4533 port and you probably use 5432... 56 56 * this was ticket : #21 57 58 Press F5 on BDMAP in pgAdminIII, the table stationsp has been created in BDMAP-Schémas-public-Tables (not in BDMAP-Schémas-bdmap-tables ? is it normal ?)[[BR]] 57 59 4. Now we will join the new station table '' (with wrong geom but new data) '' to the old table stationsp ''( which has been properly projected by Hélène) '' 58 60 * We first create a table using the AS SELECT command, it is populated with colums from station, and with columns from stationsp2, note the CASE WHEN syntax, which allow to use station.the_geom when stationsp.the_geom is not present in the table. So in practise we use all the old coordinates plus the new ones which have not been verified. Also noteworthy in the script is the CREATE TABLE ... WITH OIDS. The OIDS are mandatory if you want to display the table in Qgis.
