Changes between Version 10 and Version 11 of OriaEda

Timestamp:

Nov 23, 2010 2:36:58 PM (14 years ago)

Author:

cedric

Comment:

--

OriaEda

@@ -115 +115 @@
   USING GIST ( the_geom GIST_GEOMETRY_OPS );
 
+-- joining operations and stations
+drop table if exists oria.operation_station;
+create table oria.operation_station as (
+        select * from oria.estaciones_st join oria.operation_op on op_st_id=st_id
+        where st_id in (select st_id from oria.oria_ccm_500));
+alter table oria.operation_station add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table oria.operation_station add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);
+alter table oria.operation_station add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+
 -- Obstacles