Changes between Version 74 and Version 75 of CookBook join ROE_CCM
- Timestamp:
- May 4, 2010 11:10:01 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join ROE_CCM
v74 v75 19 19 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -p 5432 -U postgres -f roe_schema.sql 20 20 }}} 21 22 21 23 == We have to reproject our data == 22 24 The constraint CONSTRAINT enforce_srid_ref_position_locale CHECK (srid(ref_position_locale) = 27572) … … 31 33 32 34 33 34 35 35 == Select only the dams within France == 36 36 === Extract the data within the french boundaries === 37 37 this is ticket #45 38 38 39 ==== With !ArcGis ==== 39 40 Use the french limits (see ["French boundaries"]) in RGF93[[BR]] … … 121 122 [[Image(source:data/Docs/trac/barrages_cutfrance.png,600px)]][[BR]] 122 123 124 123 125 == Build a view allowing to know the score of the different dams == 124 126 this is ticket #46 125 127 128 126 129 == Joining CCM and Dams == 127 130 … … 129 132 130 133 -- Création de la table correspondance, je rajoute un the_geom a la requete pour pouvoir voir la table dans Qgis 134 '''La distance de projection entre la CCM et la base geobs est choisie à : 1000 m (?)''' 135 131 136 {{{ 132 137 CREATE INDEX indexgeobs ON geobs2010.obstacle_referentiel USING GIST (ref_position_etrs89 GIST_GEOMETRY_OPS); … … 142 147 ); --53s 143 148 149 144 150 -- mise à jour de la table geometry_columns 145 151 select Probe_Geometry_Columns(); … … 169 175 select * from geobs2010.obstacle_referentiel where goodproj=TRUE 170 176 }}} 177 178 171 179 == Some statistics about the dam projection == 172 180 We create a table of regions
