Parsing XML with Python - namespaces

Question

I want to work with open data, the xml is stored here:

http://offenedaten.frankfurt.de/dataset/912fe0ab-8976-4837-b591-57dbf163d6e5/resource/48378186-5732-41f3-9823-9d1938f2695e/download/parkdatendyn.xml

with help from this forum i wrote the code

from lxml import etree
from urllib.request import urlopen


root = etree.parse(urlopen(url)).getroot()


ns = { 'd': 'http://datex2.eu/schema/2/2_0' }

parking_area = root.xpath('//d:parkingAreaStatus', namespaces=ns)
parking_facility = root.xpath('//d:parkingFacilityStatus', namespaces=ns)

for pa in parking_area:
    area_ref = pa.find('d:parkingAreaReference', ns)
    ParkingspaceList.append(str((area_ref.get('id'))))


for pf in parking_facility:
    facility_ref = pf.find('d:parkingFacilityReference', ns)
    ParkingspaceList.append(str((facility_ref.get('id'))))

It seems like this works for "pa" but for "pf" i got a failure message:

ParkingspaceList.append(str((facility_ref.get('id')))) AttributeError: 'NoneType' object has no attribute 'get'

Any Tips?

best regards

TR

Jesper · Accepted Answer · 2018-02-06 01:42:20Z

1

There are parkingFacilityStatus elements inside the identically named parkingFacilityStatus elements, which is rather confusing:

<parkingFacilityStatus>
    …
    <parkingFacilityReference targetClass="ParkingFacility" id="24278[Karstadt]" version="1.0"/>
    <parkingFacilityStatus>closed</parkingFacilityStatus>
    …
</parkingFacilityStatus>

It's the

    <parkingFacilityStatus>closed</parkingFacilityStatus>

that gives the error, as that element does not have a parkingFacilityReference subelement.

Use

for pf in parking_facility:
    facility_ref = pf.find('d:parkingFacilityReference', ns)
    if facility_ref is not None:
        ParkingspaceList.append(str((facility_ref.get('id'))))

and it works.

answered Feb 6, 2018 at 1:42

Jesper

1,66914 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing XML with Python - namespaces

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related