Changes between Version 34 and Version 35 of CookBook join ROE_CCM

Timestamp:

Mar 23, 2010 9:45:33 AM (15 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCM

@@ -48 +48 @@
 If you want you can choose a "XY Tolerance", because some points in the ROE are in France but they are at the limit.
 (maybe 300meters?).[[BR]]
-{{{
-INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
-SELECT '', 'france', 'departements', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
-FROM france.departement LIMIT 1;
-}}}
 
 ==== With QGis ====
@@ -88 +83 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -h localhost -U postgres -p 5432 -c "CREATE schema france"
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -h localhost -U postgres -p 5432 -f departement.sql
+}}}
+insertion dans la table geometry column
+{{{
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'france', 'departements', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM france.departement LIMIT 1;
 }}}
 mmh so finally I would like a new column saying whether or not the dams are in France [[BR]]