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 ...
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 ...
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.
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 ...
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) <= ...
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). ...
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, ...
OSM usually doesn't contain the exact outline of a junction or intersection (except in very few cases where area:highway has been mapped) and most roads don't have a width set.
However you can try to estimate it by looking at the highway class (i.e. primary, secondary, tertiary...) and the number of lanes.
Data use and ownership depend on the publishing agency, the data, and the license level of those data. You can read about the specifics of OpenStreetMap data here, and JOSM data here. For USA data available from the National Map there are no restrictions. You will have to investigate deeper for other data.
Read the message!
No 'Access-Control-Allow-Origin' header is present on the requested
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 ...
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.
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 ...
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 ...
Is it possible to change the position of the anchor point for the popup without using markers?
If you read the API documentation for L.Popup, you should notice it inherits options from L.DivOverlay. One of those options is offset:
default Point(0, 7)
The offset of the popup position. Useful to control the anchor ...
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 ...
The ability to edit OSM data has been removed from QGIS a long time ago, because noone was willing to update the 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 ...
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 ...
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:
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:
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 ...
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 ...
download.geofabrik.de is a good data source for Open Street Map data (they are extracts from the OSM data). Within nigeria-latest-free.shp.zip (from http://download.geofabrik.de/africa/nigeria.html), there is a roads shapefile gis_osm_roads_free_1.shp. Example output:
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:
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.
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 ...
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 ...
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.
Without a copy of your Osmconfig.ini, I've put here my solution for achieving the extraction of this Poland's water stream :
Download the PBF file from Geofabrik (one of OSM Download Center)
Run a terminal and use the following code :
ogr2ogr -overwrite -skipfailures -f "ESRI Shapefile" kujawsko_pomorskie_water -sql "select * from multipolygons where ...
I found a solution that fits my needs:
Dump all points from a street geometry.
Collect all points, create a Voronoi Diagram from the collection, then Dump the geometries to split them in individual, orderable polygons.
Finally, order the polygons from their area, limit the result to 2 (2 biggest polygons, the first and last points)
This is what it looks ...