You can achieve the following using some expression-based SVG symbols.
Basically, you'd have multiple attributes that determine icon #1, #2, and so on.
As far as I know, it is currently not possible to make the SVG location depend on the corresponding label location though. So you'll want to avoid placing labels in the lower right corner, a setting for ...
Bring your data into PostgreSQL with something like mysql_fdw, or other methods.
Once you have this table, add a geography column, and populate the new column:
ALTER TABLE places ADD COLUMN geog geography(Point,4326);
UPDATE places SET geog = ST_MakePoint(longitude, latitude);
Now select the nearest 10 places that are within 100 kms:
SELECT places.*, ...
<bbox-query s="51.15" n="51.35" w="7.0" e="7.3"/>
<has-kv k="highway" ...
The coordinates seem to be are in "Swiss grid" coordinate System. EPSG:21781
-> Copy paste the table to a Text file (it will be tab-separated CSV), remove the ' between the numbers. Replace the / between the coordinates with a tab (\t) and import into QGIS with the corresponding fields for X and Y and EPSG:21781 as CRS. From here you can convert the data to ...
If you want a really simple algorithm how about this:
Take your point and draw a straight line to the bounding box of your polygon.
Count how many times it crosses the polygon boundary.
If number is odd it must be inside, if even it must be outside.
Simple answer: You can not.
Unlike Google maps API, these icons are part of the pre-rendered tiles you get from openstreetmap.org, and there is nothing you can do about it.
You may however look for other tile sorces based on Openstreetmap data, like Stamen .
Or render your own tiles with tools like Maperitive. Then you are free to leave out any data you ...
I would suggest checking the other other questions that have the POI tag for a more comprehensive list, but a couple that come to mind right away are:
OpenStreetMap (Using the "amenity" keyword)
Well here's a few:
Proper Databases (Cheap / free but of variable quality) - you will probably have to convert to mySQL yourself as this is not a standard geospatial format given its relatively poor geo extensions.
APIs (usage restrictions, generally free to a certain level of use)
No. I am unaware of any legal way to bulk download Google's POI database. Many alternates exists including free options such as OSM and purchase options such as HERE. A simple web search will reveal many more.
Now, although you cannot download Google's POIs in a traditional manner the Google Places API will give you access to over 100 million Google POIs or ...
One-liner, assuming the POI points are stored in a "geography" column, you supply the ids of the two points and the search radius in meters:
WITH line AS (
SELECT ST_MakeLine(p.geog::geometry, q.geog::geometry)::geography AS geog
FROM pois p, pois q
WHERE p.id = :id1 and q.id = :id2
SELECT p.name, p.id
FROM pois p
ON ST_DWithin(p.geog, ...
Based on the additional information in your comment, there are a few things you could do. One thing to remember is that flexibility is key. If you put all of your polygon features in one table and all of your point features in another table, it makes it very difficult to compare different features. For example, if you have a polygon layer that ...
As Underdark noted, you don't need to use planet.osm, but instead use the link she provided contains all data (included restaurants) within Germany.
You'll want to use Osmosis, an OSM data parser. (Check out the detailed usage page to find out more of how to use osmosis, if you're interested.
There may be other ways in osmosis to do it,
The following ...
There is a website which you can look into: www.motomapia.com.
Here you can download POIs from wikipedia for a particular location.
All the POIs visible in the browser would be downloaded.
Regarding Obf , its a binary format and I dont think it can be converted to any other format.
Since you are interested in city/town level resolution, the best one is geonames.org.
"The GeoNames geographical database covers all countries and contains over eight million placenames that are available for download free of charge."
In case you are interested in your user's IP address, you can use ipinfodb. It returns the location of an IP address (...
OpenStreetMap has an API to retrieve data.
See the manual at: http://wiki.openstreetmap.org/wiki/API_v0.6 .
Also at openstreet maps there is some "extracts" like you want available.
Check if someone matchs: http://wiki.openstreetmap.org/wiki/Planet.osm#Downloading
The Natural Earth data sets may meet your needs. Take a look at the Cultural Features http://www.naturalearthdata.com/features/
The data is available at 1:10 million, 1:50 million, and 1:110 million scales and it is published under a very liberal Public Domain license. http://www.naturalearthdata.com/about/terms-of-use/
I would create a geometry collection from the points using st_collect():
Then I would create convex hull from the point collection:
If you have a table of point geometries called testpoints where geometry column name was the_geom, this should create the polygon that you are ...
The best starting point for overpass queries is the Openstreetmap wiki, follow the overpass-turbo link on the left. It generates the following query:
// gather results
// query part for: “aeroway=aerodrome”
Basically, you can just drop the area parts of your query to get what you want:
but your query might get cancelled due to server load.
Alternatively, you can query by bbox fo parts of the world.
Similar to an example in the Overpass by Example library, I'd suggest to use the following query:
area.a[name][boundary=administrative][admin_level~"^[2-8]$"] -> .a;
convert way ::...
There are 2 similar questions that contain answers that may guide you to find the Points of Interest data you are looking for:
Seeking GIS data for fast food industry?
POI Datasets for North America
Particularly take a look at OpenStreetMap, SimpleGEO, and POI Factory.
Additionally, you should browse the questions tagged as POI, business, data, and ...
There are similar questions:
Seeking GIS data for fast food industry?
POI Datasets for North America
Seeking shapefiles of business locations
that contain answers that may guide you to find the Points of Interest data you are looking for. Particularly take a look at OpenStreetMap, SimpleGEO, and POI Factory.
Additionally, you should browse the questions ...
You may not absolutely need to create geometries, but you will want to do it so that you can take advantage of indexes. The below code works with Postgres 9.1+
CREATE TABLE mypoints(gid SERIAL PRIMARY KEY, latitude double precision, longitude double precision, address varchar(100), types varchar (25), geom geometry(POINT, 4326));
INSERT INTO mypoints (...
One way to investigate this sort of thing is to use the "Export" tab on a sample area on the main OSM site.
If you export it as OSM XML, you will get a fairly large file, part of which will contain something like:
-<node version="12" timestamp="2012-10-29T00:16:52Z" changeset="13668746" visible="true" uid="158826" user="cquest" lon="2.3549579" lat="48....