Changes between Version 33 and Version 34 of CookBook join ROE_CCM

Timestamp:

Mar 23, 2010 9:43:18 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 ====