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

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,


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.


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.


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

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

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

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

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

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


3

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


3

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


3

I was also trying to open obf file in GIS Software. But it is not possible to convert an obf file into kml or shape file. The obf format is a binary format used only for osmand.


3

You can use the wikimapia API http://wikimapia.org/api/ Specifically, you can use the API box to get the data from the category such as 'Schools' as KML http://wikimapia.org/wiki/API_box


3

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


3

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


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