Changes between Version 13 and Version 14 of Ecological region Download and load

Timestamp:

Jul 10, 2010 8:36:47 AM (15 years ago)

Author:

cedric

Comment:

--

Ecological region Download and load

@@ -61 +61 @@
 ALTER TABLE dmeer2003.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
 }}} 
+
+{{{
+!#sql
+
+
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'dmeer2003', 'ecologicalregion_label', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM dmeer2003.ecologicalregion_label LIMIT 1;
+
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'dmeer2003', 'ecologicalregion_polygon', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM dmeer2003.ecologicalregion_polygon LIMIT 1;
+
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'dmeer2003', 'ecologicalregion_tic', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM dmeer2003.ecologicalregion_tic LIMIT 1;
+}}}