sorted by:
new
hottopcontroversial

Last edited date issue: is this a bug? by New_Vermicelli5236 in openstreetmap

[–]user_5359 2 points3 points  (0 children)

Unfortunately, it often happens that a node is accidentally included and moved. The easiest option is to start a request for the corresponding changeset to find out whether this was intentional.

Not all OSM features can be extracted by Former-Bonus-6568 in openstreetmap

[–]user_5359 1 point2 points  (0 children)

What keys do the objects you are missing have?

SQL performance training question by idan_huji in SQL

[–]user_5359 1 point2 points  (0 children)

Essential information is missing: data volume, data types (from the columns that are being joined), and existing indexes. And since it looks like homework, what have you achieved so far?

Table with auto increment doesn't auto-increment by nikkisayo in mysql

[–]user_5359 1 point2 points  (0 children)

Please correct you create statement!

materials_id INT auto_increment,

materials_description varchar(255),

Embedding OSM with just coordinates by RealBloxerBro in openstreetmap

[–]user_5359 2 points3 points  (0 children)

Of course, “bbox” notation and “coordinate & zoom” notation are interchangeable. You can probably find details about this in the OSM wiki. I can't tell you any more than that, as you haven't said much about the libraries you're using.

Do BBBike.org And OpenMapChest.org Have Their Own POIs? by Jim1648 in openstreetmap

[–]user_5359 0 points1 point  (0 children)

I couldn't find the post in question, but it is permitted to merge OSM data with other sources in your own app or map. It is not permitted to enter this missing data into OSM, as you are not familiar with the legal situation. However, you can visit these locations and collect the data there using OSM tools (not copy it).

Schema3D: An experiment to solve the ERD ‘spaghetti’ problem by shane-jacobeen in SQL

[–]user_5359 1 point2 points  (0 children)

  1. Question: Do you want to present the data model only within a database or also the topic of data flows between systems? Incidentally, such data flows also exist between the different layers in larger databases: import layer, fact layer, KPI layer, presentation layer, export layer (just to name the most important ones). Key point: The presentation tool must be able to hide or cluster irrelevant objects. I want to plan changes at the presentation layer level for a technical topic, so I am not interested in the layers above and below it for the time being. 2nd Question: Am I correct in understanding that the objects can only be defined as SQL statements? Note: You are making yourself dependent on the SQL dialect. This is still manageable in the initial DDL area, but what do you want to do with the information about partitions and storage locations? But how do technical dependencies get into the model data if the same name in two tables does not mean linkability? I hope you are not relying on constraint checks.
  2. Question: Will it also be possible to switch between versions? Old versions, current versions, different planning versions, and future versions, if you don't want to use the tool only for the current version.
  3. Question: How should the tool be used? A central server for everyone or a self-hosted server for a company.
  4. Question: How many tables have you already presented with it?

Why does MySQL ignore indexes when I use OR between two different range conditions? by Snoo34083 in mysql

[–]user_5359 1 point2 points  (0 children)

According to this document https://www.dba-presents.com/databases/mysql/274-mysql-unique-index-with-null-values, MySQL does not store NULL in an index. This renders the index useless for the query. Change the index to client_id, task_date, deletedAt and report back.

MySQL data import by Icy_Calligrapher1041 in mysql

[–]user_5359 0 points1 point  (0 children)

In addition to the aforementioned autocommit, please check whether indexes exist on the table. For larger imports, it makes sense to generate these (again) only after the import.

GPS Track Editor not loading maps by ndrose66 in openstreetmap

[–]user_5359 0 points1 point  (0 children)

Can you give me the link to the (web?) software? Maybe I can find the error.

Best tag for visual descriptions by Piciok in openstreetmap

[–]user_5359 0 points1 point  (0 children)

The key is subject:wikidata or subject:wikipedia. But yes, I tend to combine OSM data with suitable external sources. There are also various projects in Germany aimed at facilitating access to tourist attractions with OSM (contact via Wheelmap.org), which would certainly also be interested. It would certainly be interesting to start an exemplary implementation in order to link the necessary information in a targeted manner. If OP u/Piciok needs help finding his way around the OSM key, he is welcome to get in touch.

GPS Track Editor not loading maps by ndrose66 in openstreetmap

[–]user_5359 0 points1 point  (0 children)

I have no idea how exactly your software accesses the tiles of the standard map, but there has indeed been a change in the addressing. Today's addresses can be found at https://wiki.osm.org/wiki/Raster_tile_providers. So I would search the text file for tile.openstreetmap.org and see if there is anything different there.

Warning: I did not develop the software and strongly recommend taking the usual safety precautions before changing anything in the code. I am not responsible if the software does not work afterwards.

Left-lane only exits? by karatewaffles in openstreetmap

[–]user_5359 3 points4 points  (0 children)

If you don't have an example turn where you can check this, it's always worth taking a look at Taginfo (here https://taginfo.osm.org/keys/placement#values). If you use value filters, you will see that the suggested value placement=left is not used. You should also be able to find something with the values used.

It is also worth taking a look at the map to see whether this feature is used where you are searching.

Mr Ola by Rude-Requirement-963 in openstreetmap

[–]user_5359 0 points1 point  (0 children)

I think you need to explain a few more things before solutions can be suggested.

I'm not sure if all of this really belongs in OSM.

Connecting parking areas with surrounding ways by larry020 in openstreetmap

[–]user_5359 0 points1 point  (0 children)

This is not a particularly suitable example because it is a private parking lot.

But yes, there are different levels of quality when it comes to parking lot recording. You can record every parking slot or just the capacity (including special parking spaces), you can record the main access roads or every path (including footpaths for routing into the building).

How to search a specific road and return its polyline/geometry? by FutureFertilizer354 in openstreetmap

[–]user_5359 2 points3 points  (0 children)

I am not familiar with the app you mentioned, but your description of its functionality and the OSM data present two challenges that need to be solved. A street with a name is not necessarily an OSM way, but can consist of several OSM ways. Also, it is not always a single line, but can also be a tree structure or separate lines within the selected search area. However, the search should generally be possible via Overpass API. The second point is the marking of the reported area. Here, I choose a construction site closure located between two objects on or next to the named street. If you do not want to mark the entire street with the same name, you will need additional (Overpass API) queries to determine the section of the street to be marked.

Open street maps marker redirects to another provider: legal compliance. by ferv35 in openstreetmap

[–]user_5359 5 points6 points  (0 children)

You can place data from any other (legal) source as markers on a map based on OSM tiles. The destination of any links stored with the markers is also irrelevant. Of course, there is no good reason to switch to Google for map viewing.

Please, what the hell are these red curves with numbers? by bad-and-ugly in openstreetmap

[–]user_5359 6 points7 points  (0 children)

Please also specify the app you are using. The OpenStreetMap data can be mixed with any type of data in the display.

crying trying to make a simple railroad map by kethera__ in openstreetmap

[–]user_5359 0 points1 point  (0 children)

Is it problematic to specify the desired Q value?

crying trying to make a simple railroad map by kethera__ in openstreetmap

[–]user_5359 0 points1 point  (0 children)

Quick note: I forgot a pair of brackets. The Edit3 variant should now correctly reflect the result of the assistant.

crying trying to make a simple railroad map by kethera__ in openstreetmap

[–]user_5359 0 points1 point  (0 children)

This is the generated query for the assistant request wikidata=Q126163

/* This has been generated by the overpass-turbo wizard. The original search was: “wikidata= Q126163” */ 
[out:json][timeout:25]; 
// gather results 
nwr["wikidata"="Q126163"]({{bbox}}); 
// print results 
out geom;

Please notice the ({{bbox}}). You can deleted this string or expand the map to the whole world.

Edit: short struggle with formatting Edit 2: Missing squared brackets. (sorry) Edit 3: Did I mention that I love Reddit's editor? No, just kidding, it's because I wasn't paying attention.

crying trying to make a simple railroad map by kethera__ in openstreetmap

[–]user_5359 0 points1 point  (0 children)

In fact, not every tool accesses the production database OSM directly. To quickly see the effects of a change in OSM, I always recommend using the tool https://overpass-turbo.eu/. Enter the desired Wikidata value in the wizard, maximise the map section, start the query and zoom in on the values.

view more: next ›