OSM postgresql query does not show all hospitals?
Hi,
I have OSM dataset on Postgresql via osm2pgsql. Now I am trying to query all public buildings in UK such as hospitals, schools, fire stations and churches. In order to do that, I use something like this query:
SELECT *
FROM planet_osm_point pop
WHERE pop.amenity IN ('hospital','fire_station','place_of_worship','school')
By looking at the results, it just extracts some of the hospitals. I can see the red plus logo for hospitals that I also know that they exist there. But it does not show them in the query results.
How can I include all of these buildings?
I could Here is the example picture: https://imgur.com/a/jjTlZ4N
Blue color is from the results. But the red circle hsopitals are not provide image due to reputation limits. But i can provide on request.
included in the query results.