search

ioda-net / geo-front3

frontend from geoadmin/mf-geoadmin3
Other
1 stars 0 forks source link

Print city name #27

Closed tigerfoot closed 9 years ago

tigerfoot commented 9 years ago

Check with vhe if we can't have a special layers off to get only the label of the city on the map drawed at a specific location (like bottom left)

verogis commented 9 years ago

More explanation ?

tigerfoot commented 9 years ago

On Friday 10 July 2015 08.21:24 verogis wrote:

More explanation ? tomorrow :-)

Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch

openSUSE Member & Board, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot

Jenselme commented 9 years ago

The request to get the commune is: select nom from communes where ST_Contains(the_geom, ST_SetSRID(ST_Point(594131, 236280), 21781))

Jenselme commented 9 years ago

The API is ready for this request. I still have to add a plugin in the front end to connect to communes?x=594131&y=236280&srid=21781.

verogis commented 9 years ago

The table communes got a column code which differentiate de "true" communes (code = 1) from the "arrondissement" (kreis) which got code = 2. You should not show them. You got to add WHERE code=1 to get it right (once you got the right db)

Jenselme commented 9 years ago

You got to add WHERE code=1 to get it right (once you got the right db)

Modify request in API once I have the good db.

tigerfoot commented 9 years ago

Should be Monday

Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch

openSUSE Member & Board, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot

Jenselme commented 9 years ago

Done in view definition:

CREATE OR REPLACE VIEW api3.communes AS
SELECT gid, nom, st_curvetoline(the_geom) AS the_geom
FROM userdata.communes
WHERE code == 1;
ALTER TABLE api3.communes
  OWNER TO sit_dev;