I have retrieving all types of data from a small B-box using the Overpass Api and i have populated Postgres(postGis) using "osm2pgsql" with the default style.I can extract the ways into geoJson format but in the visualization some layer is drawn twice, possible this depend by relations?
This is the query i use to extract datas:
SELECT row_to_json(fc)::textFROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As featuresFROM (SELECT 'Feature' As type,ST_AsGeoJSON(ST_Transform(lg.way,4326))::json As geometry,(select row_to_json(t)from (select osm_id, highway, surface) t)As propertiesFROM planet_osm_line As lg ) As f ) As fc;
أكثر...
This is the query i use to extract datas:
SELECT row_to_json(fc)::textFROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As featuresFROM (SELECT 'Feature' As type,ST_AsGeoJSON(ST_Transform(lg.way,4326))::json As geometry,(select row_to_json(t)from (select osm_id, highway, surface) t)As propertiesFROM planet_osm_line As lg ) As f ) As fc;
أكثر...