Changes between Version 5 and Version 6 of EMU Download and load
- Timestamp:
- Sep 14, 2010 5:03:29 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
EMU Download and load
v5 v6 67 67 INSERT INTO bassin_pose 68 68 SELECT DISTINCT bassin.wso_id, 'Britanny' as EMU FROM ccm21.riversegments as bassin, (SELECT *, ST_Transform(the_geom,3035) as the_geom2 FROM uga2010.uga WHERE libelle='Bretagne') as rbd_selection WHERE bassin.the_geom && rbd_selection.the_geom2 AND (within(bassin.the_geom, rbd_selection.the_geom2)) AND NOT bassin.wso_id =291111; -- 164 lines 69 70 ALTER TABLE bassin_pose SET SCHEMA rbd_f1v3; 71 69 72 }}} 70 73