11

I think your best chance is OpenStreetMap, e.g. Tag:amenity=school For a list of options for the amenity tag, check http://wiki.openstreetmap.org/wiki/Category:En:Key:amenity I don't know what commercial POI databases are out there, but I doubt that one would cover all countries and topics you're looking for world-wide.


10

Try wrapping the features in the following: {"type":"FeatureCollection","features":[ ****ALL THE DATA HERE -- COMMA SEPARATED**** ]} and separating each feature with a comma. For example, here's the first two features from the IE dataset: {"geometry": {"type": "Point", "coordinates": [-6.422587, 53.293363]}, "type": "Feature", "id": "...


10

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 ...


9

There appear to be 7 major "POI" databases which have a large quantity of API-accessible POI data in the US. (Cribbing much of this from http://www.quora.com/What-are-the-pros-and-cons-of-each-Places-API) TheWebMiner GEO Yelp CitySearch Facebook Foursquare Google SimpleGeo, Factual Depending on what you are looking for, these each offer different benefits....


8

The OSM Wiki has instructions for downloading to different formats. And here is some information about shapefiles. Cloudmade has produced exports to different formats for France and can be found here.


8

It sounds as if GeoNames has everything you need - you can download the whole (or parts of) the database. From your description of the problem it sounds like you need cities1000.zip,


7

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.*, ...


7

One other approach is to use the Overpass javascript library to query the read-only OSM API. You can write a query that will select all of the relevant tags for an area. Here is an example from the wiki: <bbox-query s="51.15" n="51.35" w="7.0" e="7.3"/> <recurse type="node-way"/> <query type="way"> <item/> <has-kv k="highway" ...


7

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 ...


7

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.


7

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 ...


6

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: SimpleGeo Places Yahoo GeoPlanet OpenStreetMap (Using the "amenity" keyword) POI Factory As always, check each site's terms of use to make sure you can use it for your purposes.


6

"Points of interest" is a very subjective thing, it depends on the domain of your interest. Also, I doubt you'll find anything "official". The closest thing would be OpenStreetMap, but you should be aware of certain things: The global coverage is not even: some countries are super-covered (Germany, UK) while others are less so. Getting to OSM data could ...


5

August 1, 2011 blog posting: "SimpleGeo’s CC0 Places data set is now available for download at no cost. If you’d like to get your hands on 21M+ POIs that cover 63 countries, we’re ready to hand that over to you in one file. The file is about 2GB in .ZIP format, and remember, with the CC0 license, this data becomes yours – free and clear – to do whatever ...


5

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. TheWebMiner GEO Factual Places Cloudmade OpenStreetMap APIs (usage restrictions, generally free to a certain level of use) Foursquare Google ...


5

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 ...


5

easy. 1. download *.osm.pbf 2. install osmosis 3. in the command window type osmosis --rbf INPUT.osm.pbf --nk keyList="amenity" --wx OUTPUT.osm


5

You can use the data from openstreetmap. The data is free and can be obtained from overpass api. Here is a link to overpass turbo


4

Michal, 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 ...


4

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 ...


4

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 (...


4

Thank you very much to @fod & @Sasa Ivetic for putting me on the right track! I had to put this project down for a while but finally got back to it today and wanted to pass along my results to help out anyone else who may have struggled with this. Using the information they provided in @fod's answer, I wrote this Python script to convert the dump ...


4

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.


4

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 JOIN line ON ST_DWithin(p.geog, ...


4

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


4

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/


4

I would create a geometry collection from the points using st_collect(): http://postgis.net/docs/ST_Collect.html Then I would create convex hull from the point collection: http://postgis.net/docs/ST_ConcaveHull.html 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 ...


4

The best starting point for overpass queries is the Openstreetmap wiki, follow the overpass-turbo link on the left. It generates the following query: [out:json][timeout:25]; // gather results ( // query part for: “aeroway=aerodrome” node["aeroway"="aerodrome"]({{bbox}}); way["aeroway"="aerodrome"]({{bbox}}); relation["aeroway"="aerodrome"]({{bbox}});...


4

Basically, you can just drop the area parts of your query to get what you want: ( node["aeroway"="aerodrome"]; way["aeroway"="aerodrome"];>; relation["aeroway"="aerodrome"];>>;); out meta; but your query might get cancelled due to server load. Alternatively, you can query by bbox fo parts of the world.


4

Similar to an example in the Overpass by Example library, I'd suggest to use the following query: [timeout:60]; area["name"="Mayenne"]->.boundaryarea; way(area.boundaryarea)["building"="church"]; foreach( node(w)->.n; .n is_in->.a; area.a[name][boundary=administrative][admin_level~"^[2-8]$"] -> .a; out center; convert way ::...


Only top voted, non community-wiki answers of a minimum length are eligible