9

POSTGIS now supports outputting vector tiles as endpoint to a Query. https://postgis.net/docs/ST_AsMVT.html I honestly don't recommend this approach because currently that's just geometry and no attributes. You can also pair POSTGIS with GeoServer and GeoWebCache to produce vector tiles but also don't recommend that. But probably your best bet now is ...


9

NULL is not equal to an empty string. NULL is by definition an "unknown value" of which we cannot assume anything. Whereas an empty string is a string without contents. You can test for NULL by using "column_name" IS NULL and for an empty string by using "column_name" = '' Apparently in your data there are no NULL values but only empty strings. What you ...


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


7

You're asking two questions here: administrative borders related to territorial disputes, and map label localization. Since you mention OpenStreetMap, I feel obliged to answer: The OpenStreetMap Foundation changed the policy regarding territorial disputes in 2013. You can find the full document here, but let me quote the relevant paragraph: Borders and ...


6

Same here, it seems to be an internal error in the postprocessing of the OSM data at bbike. You can take the osm.pbf file from the same website, which works for me, or take the shapefiles from Geofabrik and cut out the area you need.


6

If it's for specific cities and regions, you can use Overpass Turbo to create queries like admin_level=6 to find border ways. You'll want to consult the Tag:boundary=administrative wiki page to make sure that you're using the right admin level for the country you're looking at. If, however, you want to just extract those borders for the whole planet, you'll ...


5

To label only one lane of a two-lane road I'm using the expression: angle_at_vertex($geometry,1) <= 180 and use it as filter. This works because in OSM each lane is drawn in their direction. In the example below I'm using the expression angle_at_vertex($geometry,1) as label and in the second picture the expression angle_at_vertex($geometry,1) <= ...


5

The basic OSM data model (nodes, ways and relations) is described at Elements. The XML format is described at OSM XML, larger extracts usually use PBF instead of XML, PBF has performance advantages (size, speed). OSM is mainly a geographic database. It doesn't contain "colors" (well, there are a few exceptions like the color of a particular building). ...


5

Despite its name, OpenStreetMap is a collaborative geodatabase (or geodata collection) first, and a map only second (if at all). Anyone with an OpenStreetMap account can edit the data. Live. That is, changes made that way are reflected in the database right away, without having to go though any review or approval process first. Kinda like edits on Wikipedia, ...


4

No, it doesn't. A bicycle relation includes all ways that are part of this specific cycle route. A specific relation can represent a certain local/regional/national/international cycle network, for example. Not every cycle lane is part of a cycle network. Likewise, a cycle lane can be part of more than one network and thus be contained in more than one ...


4

OpenStreetMap doesn't contain timetable information, which is essential to any public transport routing. Instead, you'll need to find timetable data for the services you're interested in. This is often provided in a format called GTFS. Transitland is a good place to start looking. Then you'll need routing software which can consume GTFS feeds. ...


4

If you install the GDAL and OGR tools (open source, available for all major operating systems, see osgeo.org for downloads and details) you can do this on a command line: $ ogr2ogr maps map.osm and it will extract the OSM file into an existing folder called "maps" as several shapefiles. Note that OSM layers can contain more than one geometry type, but ...


4

Read the message! No 'Access-Control-Allow-Origin' header is present on the requested resource. The response had HTTP status code 404. You got a "404 Not Found" error from the tile server because openstreetmap.org does not serve tiles on levels higher than 19. openstreetmap.org does not include a "Access-Control-Allow-Origin" header when ...


4

With raster tiles you can usually see it on the tile URLs. For example the tile https://a.tile.openstreetmap.org/16/35270/21925.png corresponds to zoom level 16. This works for all XYZ tile servers. For details see slippy map tilenames.


4

From the README: Unoffical builds for Windows are available from AppVeyor but you need to find the right build artifacts. However, the the links in the README to builds of the latest release 0.96.0 are broken as the artifacts are no longer available: Artifacts older than 6 months are automatically deleted. For more details see Artifacts retention ...


4

The QuickOSM plugin queries the Overpass API, and that will definitely block any attempt to get large-scale data download. Otherwise the service would be permanently overloaded and hence unusuable. The only way you can go is to download the Geofabrik extract, and filter that on the command line. Feeding the data to QGIS will kill it due to the large amount ...


4

Is it possible to change the position of the anchor point for the popup without using markers? Yes. If you read the API documentation for L.Popup, you should notice it inherits options from L.DivOverlay. One of those options is offset: offset type Point default Point(0, 7) The offset of the popup position. Useful to control the anchor ...


4

OSM data is crowd-sourced. It's created by many people who volunteer their time. As such, it's often incomplete. The cycling apps you're referring to have most likely filled in the gaps of OSM data with their own proprietary data. Such data is obtained by tracking the cycling routes of the people using the app. This creates a positive feedback cycle where ...


4

The ability to edit OSM data has been removed from QGIS a long time ago, because noone was willing to update the plugin: https://wiki.openstreetmap.org/wiki/QGIS_OSM_Plugin JOSM is the tool to import GIS data: https://wiki.openstreetmap.org/wiki/JOSM/Plugins/OpenData Apart from the license question, you have to keep an eye on existing data in your working ...


4

It is not so easy to answer your question when we don't know exactly how your map should look like, or what is your detailed usecase. But what about NOT asking what data shouls be removed, but asking yourself what data to KEEP before proceeding? See the --keep parameter of osmfilter! So why not ask yourself: Do you need streets and highways? Same for ...


4

One way of getting around this is to use the center function in an Overpass query. (Documentation here.) Normally, a query for museums gives us what you picture above: nodes as well as ways, depending on how the object exists in OSM. By appending center to your out statement, you'll get the centroid for the object. Here is an example query: [out:json][...


4

Looking at the .PBF file for Colorado, there are 2 line layers when importing into a QGIS project. The colorado-latest lines (NOT multistring) contains the HSTORE-type column "other_tags" In there, you can see this value: "bicycle"=>"yes","cycleway"=>"lane","cycleway:both:buffer"=>"yes","lanes"=>"2","maxspeed"=>"20 mph","maxspeed:type"=>"sign","...


3

pgAdmin 4 has now a Geometry Data Viewer since version 4.3.3 (release date: sept/2018; see pgAdmin release notes). PostGIS extension needs to be enabled in the PostgreSQL database. The Geometry Data Viewer will display results on a map canvas from queries returning geometry and geography columns. If the SRID is 4326 results will be displayed over an ...


3

You must increase either the page size, the export resolution, or both. To change the page size right-click the layout --> go to Page Properties --> select or define a larger page dimension in the Item Properties panel (screen-right by default). The export resolution may be changed at the time of (image) export, or within the Layout panel under Export ...


3

Making your map look exactly like the OSM renderer is a little more complex, but in basic terms, what you want to do is symbolize by unique values of ONEWAY and then vary your Cartographic Line Symbol Properties when ONEWAY = 1. In your layer's symbology, categorize by Categories/ Unique values/ Value Field = ONEWAY. Edit the symbol for the condition where ...


3

Using regular expressions for numeric comparisons is no longer needed since release 0.7.55 and discouraged these days. Instead you can use numeric comparisons like described in the following blog post: http://dev.overpass-api.de/blog/numbers.html For your example, the respective query should look as follows: [out:json][timeout:60]; relation[admin_level] ...


3

I've made an experiment. Just closed one of the isolated roads. Before this I got result of pgr_analyzeGraph NOTICE: Ring geometries: 6 After closing that road I've got NOTICE: Ring geometries: 7 So the ring geometry is just a closed and isolated linestring.


3

I assume an offline vector basemap? I've made a style for geofabrik osm extracts (.shp). You can use it as template to create your own. Of course it will also work with a PostGIS database as long as it has the same fields and values. But you can also refer to other fields if needed. Created it because I was looking for a vector offline style for OSM as well ...


3

If you're familiar with the command line: Download boundaries as JSON (not GeoJSON!) file directly from Overpass API into a local file, via Export --> raw data directly from Overpass API in overpass turbo. Convert the JSON file via a nodejs script from JSON into GeoJSON. In case you want to use the same library that is in place for overpass turbo, you ...


3

In wizard of overpass-turbo it looks something like this: railway=tram_stop or public_transport=station. See query below. Check osm for the exactly used types and tags: When doing the query in overpass turbo make sure to zoom on that area you want to have your result at. All stops in VBB: /* This has been generated by the overpass-turbo wizard. The ...


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