Import/UKRNAFTA

From OpenStreetMap Wiki
Jump to navigation Jump to search

UKRNAFTA Fuel Station Import

Summary

This page documents the import of the official list of gas stations from PJSC “Ukrnafta” into OpenStreetMap.

---

Goals

  • Improve the accuracy and completeness of gas station data in Ukraine.
  • Provide verified brand, service, and contact information.
  • Enable easier routing and location-based services through OSM-based tools.

---

Data Overview

The dataset contains ~600 gas stations with:

  • Geocoordinates
  • Address details
  • Fuel types (diesel, LPG, octane_92/95/98, adblue)
  • Services (Wi-Fi, toilets, parking, shop, etc.)
  • Contact and branding info

---

Source Data

---

Mapping

CSV Field OSM Tag Example
ref ref 01/001
lat / lon node coordinates lat=48.12345" lon=37.67890
addr:formated addr:full вул. Центральна, 10, м. Краматорськ, Донецька область,, Україна, 84300
addr:state addr:state Донецька область,
addr:district addr:district Краматорський район
addr:municipality addr:municipality Краматорська міська громада
addr:city addr:city OR addr:village OR addr:hamlet Краматорськ
addr:road addr:road OR addr:street вул. Центральна
addr:postcode addr:postcode 84300
fuel:lpg fuel:lpg yes
fuel:diesel fuel:diesel yes
fuel:octane_92 fuel:octane_92 yes
fuel:octane_95 fuel:octane_95 yes
fuel:octane_98 fuel:octane_98 yes
fuel:adblue fuel:adblue yes
toilets toilets yes
wifi internet_access wlan
compressed_air compressed_air yes
payment_terminal payment:terminal yes
name, name:en,name:uk name,name:en, name:uk Укрнафта, Ukrnafta, Укрнафта
brand, brand:en,brand:uk brand,brand:en, brand:uk Ukrnafta, Ukrnafta, Укрнафта
operator operator ПАТ Укрнафта
website contact:website https://www.azs.ukrnafta.com
email contact:email hotline@ukrnafta.com
phone contact:phone +30800404000
instagram contact:instagram https://www.instagram.com/ukrnafta_azk
facebook contact:facebook https://www.facebook.com/Ukrnafta
twitter contact:twitter https://x.com/Ukrnafta_com
tiktok contact:tiktok https://www.tiktok.com/@ukrnafta_people
youtube contact:youtube https://www.youtube.com/@Ukrnafta_azk
linkedin contact:linkedin https://ua.linkedin.com/company/ukrnaftapeople
opening_hours opening_hours 24/7
amenity amenity fuel
brand:wikidata brand:wikidata Q4503721
brand:wikipedia brand:wikipedia uk:Укрнафта

---


Changeset Tags

comment = Import of PJSC Ukrnafta gas stations
created_by = ukrnafta-script v1.0
source = PJSC Ukrnafta
import = yes

---

Data Preparation

Data Reduction & Simplification

  • Removal of duplicate or inconsistent coordinates.
  • Address formatting using standard OSM practices.
  • Conversion to UTF-8 to prevent encoding issues.
  • Data cleansing and validation using Google Colab.

Tagging Plan

  • Automatic field-to-tag mapping based on CSV header names.
  • Manual corrections for inconsistent address formatting.
  • Addition of contact and service-related tags.

---

Workflow

Step-by-Step Process

  1. **Data Preparation:**
  - Clean data using Google Colab.
  - Validate data for duplicates and errors.
  - Ensure UTF-8 encoding for CSV.
  1. **Tagging and Mapping:**
  - Map CSV fields to OSM tags.
  - Test sample data conversion.
  1. **Validation:**
  - Validate data with JOSM Conflation Plugin.
  - Manual review of 10% of imported data.
  1. **Conflation:**
  - Matching with existing nodes using JOSM Conflation.
  - Manual resolution of conflicts.
  1. **Staged Upload:**
  - Upload region-by-region to minimize conflicts.
  - Verify changesets with OSM community feedback.
  1. **Final Review:**
  - Conduct Overpass Turbo queries to check duplicates.
  - Ensure compliance with OSM import guidelines.

---

Team Approach

The import is managed by the following team:

  • Project Lead: Vitaly Vlasyuk – v.vlasyuk@4service-group.com
  • Community Liaison: OSM Ukraine Telegram Group
  • Validator: 4Service UA Import Team

---

Community Involvement

  • Initial discussion through:
 - OSM Ukraine Telegram Group
 - import@openstreetmap.org
  • Pre-import review of data and staged uploads.
  • Post-import review of uploaded data with community feedback.

---

Conflation

Strategy

  • Data conflated using JOSM Conflation Plugin.
  • Existing nodes matched with lat/lon within a 10-meter tolerance.
  • Nodes with matching addresses but different coordinates flagged for manual review.
  • Merging of new data into existing nodes to prevent duplication.

Manual Review

  • 5–10% of nodes manually reviewed before uploading.
  • Special focus on nodes near urban centers and high-traffic areas.

---

QA & Verification

  • Overpass Turbo queries used to detect duplicate data.
  • Manual review of sample changesets.
  • Comparison with existing data to prevent overwriting.
  • Community feedback collected after test uploads.

---

Uploaded

Uploaded Changesets

Changeset ID Number of Objects Notes

---

Import Process & Progress

Progress by Region

Region Number of Stations OSM-user Import Interested State Comments
Вінницька область 17 Completed -
Волинська область 25 Completed -
Дніпропетровська область 83 Completed -
Житомирська область 5 Completed -
Закарпатська область 27 Completed -
Запорізька область 33 Completed -
Івано-Франківська область 14 Completed -
Київська область 53 Completed -
Львівська область 66 Completed -
Одеська область 29 Completed -
Полтавська область 27 Completed -
Рівненська область 29 Completed -
Тернопільська область 19 Completed -
Харківська область 19 Completed -
Херсонська область 2 Completed -
Хмельницька область 17 Completed -
Черкаська область 33 Completed -
Чернівецька область 9 Completed -
Чернігівська область 9 Completed -

---

QA

Issues Detected

  • Duplicate nodes detected and removed.
  • Minor discrepancies in address formats corrected.
  • Nodes with conflicting coordinates reviewed manually.

---

References

---

Retrieved from "https://wiki.openstreetmap.org/w/index.php?title=Import/UKRNAFTA&oldid=2830075"