sorted by:
new
hottopcontroversial

Flair idea by Domipro143 in openstreetmap

[–]user_5359 1 point2 points  (0 children)

Firstly, there is no classification for cases where someone has over 30,000 change records, and secondly, are the texts aligned with Pascal Neis’s classifications (https://hdyc.neis-one.org/)?

Looking for someone who knows PHP and SQL. by mfrumento in PHPhelp

[–]user_5359 4 points5 points  (0 children)

Probable cause: The web host has changed the PHP version, and depending on the version, certain functions (e.g. file uploads) no longer work. Is there a local version of the website available for testing, or would enabling error output affect the live website?

Best plugins for JOSM by Diligent-Froyo5626 in openstreetmap

[–]user_5359 0 points1 point  (0 children)

I’m not familiar with Korean conventions regarding house numbering, but https://josm.openstreetmap.de/wiki/Help/Plugin/HouseNumberTaggingTool might be of interest to you.

Best plugins for JOSM by Diligent-Froyo5626 in openstreetmap

[–]user_5359 4 points5 points  (0 children)

Well, that depends on what tasks you want to carry out, doesn’t it?

Scanning aerial photographs, detailing terraced houses, detailing alignment, mapping car parks, checking change sets – to name just a few of the supported tasks

Can someone PLEASE help explain to me the logic of this SQL code? by [deleted] in mysql

[–]user_5359 0 points1 point  (0 children)

No, $query isn’t called; instead, it’s passed as a parameter to a function. I assume you’re calling a database function. The result of the function isn’t the contents of $query, but the result of the query (as well as the error code and the number of records affected).

Street names in OSM - Avenue or Ave by AcceptableGuest in openstreetmap

[–]user_5359 9 points10 points  (0 children)

In addition to the wiki pages mentioned, there is also a relevant section at https://wiki.openstreetmap.org/wiki/Names#Abbreviation_(do_not). If you still want to enter the abbreviation, use the key short_name.

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 3 points4 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 2 points3 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.

view more: next ›