Opened 15 years ago

Closed 15 years ago

Last modified 7 years ago

#49 closed task (fixed)

Extraire des données d'une zone géographique depuis la couche ccm

Reported by: cedric Owned by: Celine
Priority: major Milestone:
Component: SIG-data Version: EDA2.0
Keywords: ccm21_EDA Cc:

Description (last modified by celine)

Faire une jointure entre france et ccm puis faire une requête pour récupérer les identifiants de bassin et chercher tous les cours d'eaux (donc les cours d'eaux en aval) des bassins correspondants

Change History (5)

comment:1 Changed 15 years ago by celine

  • Description modified (diff)

comment:2 follow-up: Changed 15 years ago by cedric 

SELECT  count(ref_id) from ccm21.riversegments r
join (SELECT ST_Union(f.the_geom) as singlegeom
	 FROM france.departement  As f) as sub
ON ST_DWithin(sub.singlegeom, o.ref_position_etrs89, 300);

comment:3 in reply to: ↑ 2 Changed 15 years ago by cedric

SELECT count(ref_id) from ccm21.riversegments r
join (SELECT ST_Union(f.the_geom) as singlegeom

FROM france.departement As f) as sub

ON ST_DWithin(sub.singlegeom, r.ref_position_etrs89, 300);

comment:4 Changed 15 years ago by cedric

  • Resolution set to fixed
  • Status changed from new to closed

comment:5 Changed 7 years ago by cedric

  • Milestone Data integration deleted

Milestone Data integration deleted

Note: See TracTickets for help on using tickets.