Skip to main content
SpringerLink
Log in
Book cover

Asian Conference on Intelligent Information and Database Systems

ACIIDS 2019: Intelligent Information and Database Systems pp 431–441Cite as

Towards Formal, Graph-Based Spatial Data Processing: The Case of Lighting Segments for Pedestrian Crossings

  • Conference paper
  • First Online:

  • 1809 Accesses

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 11431))

Abstract

The paper proposes a graph formalism for flexible and efficient manipulation of geospatial data. Its main practical application is preparation of data for lighting optimisation projects in conformance with regulations. The formalism is based on the extended Semantic Environment Graph, already proposed in our previous work. A simple example of a one-way street with a pedestrian crossing is used to illustrate each step of the proposed procedure. The process involves executing a series of graph productions, which introduce the new shapes into the data. Implementation is not the main focus of the paper, but results of conducted studies are provided to present the practical implications of the proposed method, compared to the traditional approach used by lighting designers.

This research was supported by the AGH University of Science and Technology grant number 11.11.120.859 and co-financed by the Polish National Centre for Research and Development grant number POIR.01.01.01-00-0037/17 funded from European Funds and granted to GRADIS Ltd.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Notes

  1. 1.

    A lighting segment is an area with uniform lighting requirements; this is usually achieved by assigning a single lighting class to the entire area.

  2. 2.

    http://www.openstreetmap.org.

References

  1. PostGIS 2.4 Documentation. https://postgis.net/docs/manual-2.4/. Accessed 4 Oct 2018

  2. NBN L 18–002: Recommendations for special cases of public lighting. Technical report, Bureau voor Normalisatie, January 1988

    Google Scholar 

  3. Technical Report 12: Lighting of Pedestrian Crossings. Technical report, Institution of Lighting Engineers (2007)

    Google Scholar 

  4. DIN 67523–2:2010–06: Beleuchtung von Fußgängerüberwegen (Zeichen 293 StVO) mit Zusatzbeleuchtung - Teil 2: Berechnung und Messung. Technical report, Deutsches Institut für Normung, June 2010

    Google Scholar 

  5. Linee guida per la progettazione degli attraversamenti pedonali. Technical report, Automobile Club d’Italia (2011)

    Google Scholar 

  6. CEN/TR 13201–1: Road lighting – Part 1: Guidelines on selection of lighting classes. Technical report, European Committee for Standarization, December 2014

    Google Scholar 

  7. EN 13201–2: Road lighting – Part 2: Performance requirements. Technical report, European Committee for Standarization, December 2014

    Google Scholar 

  8. EN 13201–3: Road lighting – Part 3: Calculation of performance. Technical report, European Committee for Standarization, December 2014

    Google Scholar 

  9. EN 13201–4: Road lighting – Part 4: methods of measuring lighting performance. Technical report, European Committee for Standarization, December 2014

    Google Scholar 

  10. Håndbok N100: Veg-og gateutforming. Technical report, Statens vegvesen (2014)

    Google Scholar 

  11. prEN 13201–5: Road lighting – Part 5: Energy performance indicators. Technical report, European Committee for Standarization, December 2014

    Google Scholar 

  12. Vägbelysningshandboken. Technical report, Trafikverket (2014)

    Google Scholar 

  13. Krav för vägars och gators utformning. Technical report Trafikverkets publikation 2015:086, Trafikverket, Sveriges Kommuner och Landsting (2015)

    Google Scholar 

  14. Osvětlení pozemních komunikací. In: Technické Kvalitativní Podmínky Staveb. Ministerstvo Dopravy (2015)

    Google Scholar 

  15. Beleuchtung von Fussgänger-Überwegen. In: SLG Richtlinie 202:2016. Schweizer Licht Gesellschaft (2016)

    Google Scholar 

  16. Date, C.J.: A Guide to the SQL Standard: A User’s Guide to the Standard Relational Language SQL. Addison-Wesley Longman Publishing Co., Inc., Boston (1987)

    Google Scholar 

  17. Ernst, S., Łabuz, M., Środa, K., Kotulski, L.: Graph-based spatial data processing and analysis for more efficient road lighting design. Sustainability 10(11), 3850 (2018). https://doi.org/10.3390/su10113850

    Article  Google Scholar 

  18. Gómez-Lorente, D., Rabaza, O., Espín Estrella, A., Peña-García, A.: A new methodology for calculating roadway lighting design based on a multi-objective evolutionary algorithm. Expert Syst. Appl. 40(6), 2156–2164 (2013). https://doi.org/10.1016/j.eswa.2012.10.026

    Article  Google Scholar 

  19. Hölker, F., Wolter, C., Perkin, E.K., Tockner, K.: Light pollution as a biodiversity threat. Trends Ecol. Evol. 25(12), 681–682 (2010). https://doi.org/10.1016/j.tree.2010.09.007

    Article  Google Scholar 

  20. Jamroz, K., Tomczuk, P., Mackun, T., Chrzanowicz, M.: Wytyczne prawidłowego oświetlenia przejść dla pieszych. Technical report, Ministerstwo Infrastruktury (2018)

    Google Scholar 

  21. Ministerie van de Vlaamse Gemeenschap Ministerie van de Vlaamse Gemeenschap: Ontwerprichtlijnen voor Voetgangersvoorzieningen. In: Vademecum Voetgangersvoorzieningen (2003)

    Google Scholar 

  22. Rabaza, O., Peña-García, A., Pérez-Ocón, F., Gómez-Lorente, D.: A simple method for designing efficient public lighting, based on new parameter relationships. Expert Syst. Appl. 40(18), 7305–7315 (2013). https://doi.org/10.1016/j.eswa.2013.07.037

    Article  Google Scholar 

  23. Sędziwy, A.: Sustainable street lighting design supported by hypergraph-based computational model. Sustainability 8(1), 13 (2015). https://doi.org/10.3390/su8010013

    Article  Google Scholar 

  24. Wojnicki, I., Kotulski, L.: Empirical study of how traffic intensity detector parameters influence dynamic street lighting energy consumption: a case study in Krakow, Poland. Sustainability 10(4), 1221 (2018). https://doi.org/10.3390/su10041221

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Applied Computer Science, AGH University of Science and Technology, Al. Mickiewicza 30, 30-059, Kraków, Poland

    Sebastian Ernst & Leszek Kotulski

Authors
  1. Sebastian Ernst
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Leszek Kotulski
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Sebastian Ernst .

Editor information

Editors and Affiliations

  1. Ton Duc Thang University, Ho Chi Minh City, Vietnam

    Ngoc Thanh Nguyen

  2. Bina Nusantara University, Jakarta, Indonesia

    Ford Lumban Gaol

  3. National University of Kaohsiung, Kaohsiung, Taiwan

    Tzung-Pei Hong

  4. Wrocław University of Science and Technology, Wrocław, Poland

    Bogdan Trawiński

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Ernst, S., Kotulski, L. (2019). Towards Formal, Graph-Based Spatial Data Processing: The Case of Lighting Segments for Pedestrian Crossings. In: Nguyen, N., Gaol, F., Hong, TP., Trawiński, B. (eds) Intelligent Information and Database Systems. ACIIDS 2019. Lecture Notes in Computer Science(), vol 11431. Springer, Cham. https://doi.org/10.1007/978-3-030-14799-0_37

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-14799-0_37

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-14798-3

  • Online ISBN: 978-3-030-14799-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation