fio-l1-paris-kml-pois

Rerun

total 20
drwxr-xr-x 1 agent agent    50 Jun 16 23:17 .
drwxr-xr-x 1 root  root     14 Jun 16 23:17 ..
-rw-r--r-- 1 agent agent 18305 Jun 16 23:17 paris_late_night_pois.kml

cat << 'PYEOF' > /work/solve.py
import geopandas as gpd
import pandas as pd
from shapely.geometry import Point
from lxml import etree
import re
import json

# Parse KML with lxml (handles namespaces)
NS = {"kml": "http://www.opengis.net/kml/2.2"}

tree = etree.parse("/work/paris_late_night_pois.kml")
root = tree.getroot()

rows = []

# Iterate over Folders (each Folder has a <name> which is the category)
for folder in root.findall(".//kml:Folder", NS):
    category = folder.findtext("kml:name", NS)
    if category is None:
        continue
    
    for pm in folder.findall("kml:Placemark", NS):
        name = pm.findtext("kml:name", NS) or ""
        
        # Get description HTML
        desc = pm.findtext("kml:description", NS) or ""
        
        # Extract category from description (Catégorie : ...)
        # Pattern: Cat&eacute;gorie&nbsp;: ... <br/>
        # The description has HTML entities. Let's extract the verified date
        # Pattern: Derni&egrave;re v&eacute;rification&nbsp;: YYYY-MM-DD
        date_match = re.search(r'Derni&egrave;re v&eacute;rification&nbsp;:\s*(\d{4}-\d{2}-\d{2})', desc)
        verified_date = date_match.group(1) if date_match else None
        
        # Also extract category from desc as cross-check, but use folder name as primary
        # The desc says Cat&eacute;gorie&nbsp;: Cafés ouverts tard etc.
        cat_match = re.search(r'Cat&eacute;gorie&nbsp;:\s*(.+?)<br', desc)
        desc_category = cat_match.group(1).strip() if cat_match else None
        
        # Get coordinates
        coord_elem = pm.find(".//kml:coordinates", NS)
        if coord_elem is not None and coord_elem.text:
            parts = coord_elem.text.strip().split(",")
            if len(parts) >= 2:
                lon, lat = float(parts[0]), float(parts[1])
            else:
                continue
        else:
            continue
        
        rows.append({
            "name": name,
            "category": category,
            "verified_date": verified_date,
            "geometry": Point(lon, lat)
        })

gdf = gpd.GeoDataFrame(rows, crs="EPSG:4326")

# Write to GeoJSON
gdf.to_file("/work/paris_pois.geojson", driver="GeoJSON")

print(f"Wrote {len(gdf)} features to /work/paris_pois.geojson")
print(gdf[["name", "category", "verified_date"]].head(10).to_string())
PYEOF
python3 /work/solve.py

Traceback (most recent call last):
  File "/work/solve.py", line 4, in <module>
    from lxml import etree
ModuleNotFoundError: No module named 'lxml'

Traceback (most recent call last):
  File "/work/solve.py", line 30, in <module>
    date_match = re.search(r'Derni&egrave;re v&eacute;rification&nbsp;:\s*(\d{4}-\d{2}-\d{2})', desc)
  File "/usr/local/lib/python3.14/re/__init__.py", line 177, in search
    return _compile(pattern, flags).search(string)
           ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^
TypeError: expected string or bytes-like object, got 'dict'

cd /work && python3 -c "
import xml.etree.ElementTree as ET
tree = ET.parse('/work/paris_late_night_pois.kml')
root = tree.getroot()
ns = {'kml': 'http://www.opengis.net/kml/2.2'}
for folder in root.findall('.//kml:Folder', ns):
    for pm in folder.findall('kml:Placemark', ns):
        desc = pm.findtext('kml:description', ns)
        print(type(desc), repr(desc[:100] if desc else None))
        break
    break
"

Traceback (most recent call last):
  File "<string>", line 9, in <module>
    print(type(desc), repr(desc[:100] if desc else None))
                           ~~~~^^^^^^
KeyError: slice(None, 100, None)

cd /work && python3 -c "
import xml.etree.ElementTree as ET
tree = ET.parse('/work/paris_late_night_pois.kml')
root = tree.getroot()
# Check namespaces used
for elem in root.iter():
    if elem.tag.startswith('{'):
        print(elem.tag)
        break
"

cd /work && python3 -c "
import xml.etree.ElementTree as ET
tree = ET.parse('/work/paris_late_night_pois.kml')
root = tree.getroot()
ns = 'http://www.opengis.net/kml/2.2'
folders = root.findall(f'{{{ns}}}Document/{{{ns}}}Folder')
print('Folders:', len(folders))
for f in folders:
    cat = f.findtext(f'{{{ns}}}name')
    print('Category:', cat)
    pms = f.findall(f'{{{ns}}}Placemark')
    print('Placemarks:', len(pms))
    for pm in pms[:1]:
        name = pm.findtext(f'{{{ns}}}name')
        print('Name:', name)
        desc = pm.findtext(f'{{{ns}}}description')
        print('Desc type:', type(desc))
        print('Desc:', repr(desc[:200]))
"

Folders: 3
Category: Cafés ouverts tard
Placemarks: 20
Name: % Arabica
Desc type: <class 'str'>
Desc: '<b>% Arabica</b><br/>Cat&eacute;gorie&nbsp;: Cafés ouverts tard<br/><a href="https://example.org/poi/0">Voir la fiche</a><br/>Derni&egrave;re v&eacute;rification&nbsp;: 2026-01-01'
Category: Bibliothèques de nuit
Placemarks: 15
Name: AUP Housing
Desc type: <class 'str'>
Desc: '<b>AUP Housing</b><br/>Cat&eacute;gorie&nbsp;: Bibliothèques de nuit<br/><a href="https://example.org/poi/20">Voir la fiche</a><br/>Derni&egrave;re v&eacute;rification&nbsp;: 2026-09-09'
Category: Tours et infos touristiques
Placemarks: 10
Name: 24hourstravel
Desc type: <class 'str'>
Desc: '<b>24hourstravel</b><br/>Cat&eacute;gorie&nbsp;: Tours et infos touristiques<br/><a href="https://example.org/poi/35">Voir la fiche</a><br/>Derni&egrave;re v&eacute;rification&nbsp;: 2026-06-08'

Wrote 45 features to /work/paris_pois.geojson
                                                                           name                     category verified_date
0                                                                     % Arabica           Cafés ouverts tard    2026-01-01
1                                                                1T. rue Scribe           Cafés ouverts tard    2026-08-14
2                                                                    1ndix Café           Cafés ouverts tard    2026-03-27
3                                                                  2 Steps Café           Cafés ouverts tard    2026-10-12
4                                         3234 Café - Trente Deux Trente Quatre           Cafés ouverts tard    2026-05-25
5                                                                      360 Cafe           Cafés ouverts tard    2026-12-10
6                                                                 3w Cafe Paris           Cafés ouverts tard    2026-07-23
7                                                             48 Collagen Caf√©           Cafés ouverts tard    2026-02-08
8                                                             86 Champs Elysées           Cafés ouverts tard    2026-09-21
9                                                           A la Ville de Paris           Cafés ouverts tard    2026-04-06
10                                                                A minima cafe           Cafés ouverts tard    2026-11-19
11                                                                  AD DictCafé           Cafés ouverts tard    2026-06-04
12                                                                      ANGIOLO           Cafés ouverts tard    2026-01-17
13                                                                       Abaita           Cafés ouverts tard    2026-08-02
14                                                                Absinthe Café           Cafés ouverts tard    2026-03-15
15                                                                   Acai & You           Cafés ouverts tard    2026-10-28
16                                                       Adulis Cafe Abyssinien           Cafés ouverts tard    2026-05-13
17                                                                  After Place           Cafés ouverts tard    2026-12-26
18                                                                  After Place           Cafés ouverts tard    2026-07-11
19                                                                  After Place           Cafés ouverts tard    2026-02-24
20                                                                  AUP Housing        Bibliothèques de nuit    2026-09-09
21                                                          Academie de Medical        Bibliothèques de nuit    2026-04-22
22                                                            Ancêtres Italiens        Bibliothèques de nuit    2026-11-07
23                                                            Apfelbaum Library        Bibliothèques de nuit    2026-06-20
24                                                          Archives de l'AP-HP        Bibliothèques de nuit    2026-01-05
25                                                       Arthur Rimbaud Library        Bibliothèques de nuit    2026-08-18
26                                   Association Bibliotheque Braille Enfantine        Bibliothèques de nuit    2026-03-03
27                                            Association Francaise de Therapie        Bibliothèques de nuit    2026-10-16
28                                                                   Attractive        Bibliothèques de nuit    2026-05-01
29                                                                          BNF        Bibliothèques de nuit    2026-12-14
30                                      BPI Bibliotheque Publique D Information        Bibliothèques de nuit    2026-07-27
31                                                                BPI-Beaubourg        Bibliothèques de nuit    2026-02-12
32                                                 Beaubourg Librairie des Arts        Bibliothèques de nuit    2026-09-25
33                                      Bib Cent du Service de Sante Des Armees        Bibliothèques de nuit    2026-04-10
34        Bibliothe que Centrale - Muse'um national d'histoire naturelle (MNHN)        Bibliothèques de nuit    2026-11-23
35                                                                24hourstravel  Tours et infos touristiques    2026-06-08
36                                                              2CVPrivateParis  Tours et infos touristiques    2026-01-21
37                                                                    382444404  Tours et infos touristiques    2026-08-06
38                                                       A French Frye in Paris  Tours et infos touristiques    2026-03-19
39                                                          Aeon Tours of Paris  Tours et infos touristiques    2026-10-04
40  Agence ORNIcom : location de gyropode Segway à Paris et sur toute la France  Tours et infos touristiques    2026-05-17
41                                                             Al Abrar Voyages  Tours et infos touristiques    2026-12-02
42                                                               Allison Zinder  Tours et infos touristiques    2026-07-15
43                                            Association Touristique Cheminots  Tours et infos touristiques    2026-02-28
44                                                              Avenir Tourisme  Tours et infos touristiques    2026-09-13

{
"type": "FeatureCollection",
"name": "paris_pois",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "name": "% Arabica", "category": "Cafés ouverts tard", "verified_date": "2026-01-01" }, "geometry": { "type": "Point", "coordinates": [ 2.324676, 48.854156 ] } },
{ "type": "Feature", "properties": { "name": "1T. rue Scribe", "category": "Cafés ouverts tard", "verified_date": "2026-08-14" }, "geometry": { "type": "Point", "coordinates": [ 2.329774, 48.870581 ] } },
{ "type": "Feature", "properties": { "name": "1ndix Café", "category": "Cafés ouverts tard", "verified_date": "2026-03-27" }, "geometry": { "type": "Point", "coordinates": [ 2.341361, 48.880764 ] } },
{ "type": "Feature", "properties": { "name": "2 Steps Café", "category": "Cafés ouverts tard", "verified_date": "2026-10-12" }, "geometry": { "type": "Point", "coordinates": [ 2.376626, 48.866261 ] } },
{ "type": "Feature", "properties": { "name": "3234 Café - Trente Deux Trente Quatre", "category": "Cafés ouverts tard", "verified_date": "2026-05-25" }, "geometry": { "type": "Point", "coordinates": [ 2.376249, 48.853167 ] } },
{ "type": "Feature", "properties": { "name": "360 Cafe", "category": "Cafés ouverts tard", "verified_date": "2026-12-10" }, "geometry": { "type": "Point", "coordinates": [ 2.321838, 48.842293 ] } },
{ "type": "Feature", "properties": { "name": "3w Cafe Paris", "category": "Cafés ouverts tard", "verified_date": "2026-07-23" }, "geometry": { "type": "Point", "coordinates": [ 2.32753, 48.85156 ] } },
{ "type": "Feature", "properties": { "name": "48 Collagen Caf√©", "category": "Cafés ouverts tard", "verified_date": "2026-02-08" }, "geometry": { "type": "Point", "coordinates": [ 2.34046, 48.87484 ] } },
{ "type": "Feature", "properties": { "name": "86 Champs Elysées", "category": "Cafés ouverts tard", "verified_date": "2026-09-21" }, "geometry": { "type": "Point", "coordinates": [ 2.303767, 48.871387 ] } },
{ "type": "Feature", "properties": { "name": "A la Ville de Paris", "category": "Cafés ouverts tard", "verified_date": "2026-04-06" }, "geometry": { "type": "Point", "coordinates": [ 2.34428, 48.87053 ] } },
{ "type": "Feature", "properties": { "name": "A minima cafe", "category": "Cafés ouverts tard", "verified_date": "2026-11-19" }, "geometry": { "type": "Point", "coordinates": [ 2.38129, 48.8453 ] } },
{ "type": "Feature", "properties": { "name": "AD DictCafé", "category": "Cafés ouverts tard", "verified_date": "2026-06-04" }, "geometry": { "type": "Point", "coordinates": [ 2.390577, 48.849002 ] } },
{ "type": "Feature", "properties": { "name": "ANGIOLO", "category": "Cafés ouverts tard", "verified_date": "2026-01-17" }, "geometry": { "type": "Point", "coordinates": [ 2.331682, 48.854538 ] } },
{ "type": "Feature", "properties": { "name": "Abaita", "category": "Cafés ouverts tard", "verified_date": "2026-08-02" }, "geometry": { "type": "Point", "coordinates": [ 2.368446, 48.864406 ] } },
{ "type": "Feature", "properties": { "name": "Absinthe Café", "category": "Cafés ouverts tard", "verified_date": "2026-03-15" }, "geometry": { "type": "Point", "coordinates": [ 2.357228, 48.865564 ] } },
{ "type": "Feature", "properties": { "name": "Acai & You", "category": "Cafés ouverts tard", "verified_date": "2026-10-28" }, "geometry": { "type": "Point", "coordinates": [ 2.339001, 48.854247 ] } },
{ "type": "Feature", "properties": { "name": "Adulis Cafe Abyssinien", "category": "Cafés ouverts tard", "verified_date": "2026-05-13" }, "geometry": { "type": "Point", "coordinates": [ 2.346929, 48.851763 ] } },
{ "type": "Feature", "properties": { "name": "After Place", "category": "Cafés ouverts tard", "verified_date": "2026-12-26" }, "geometry": { "type": "Point", "coordinates": [ 2.336121, 48.864266 ] } },
{ "type": "Feature", "properties": { "name": "After Place", "category": "Cafés ouverts tard", "verified_date": "2026-07-11" }, "geometry": { "type": "Point", "coordinates": [ 2.351101, 48.862294 ] } },
{ "type": "Feature", "properties": { "name": "After Place", "category": "Cafés ouverts tard", "verified_date": "2026-02-24" }, "geometry": { "type": "Point", "coordinates": [ 2.36156, 48.8695 ] } },
{ "type": "Feature", "properties": { "name": "AUP Housing", "category": "Bibliothèques de nuit", "verified_date": "2026-09-09" }, "geometry": { "type": "Point", "coordinates": [ 2.306008, 48.861754 ] } },
{ "type": "Feature", "properties": { "name": "Academie de Medical", "category": "Bibliothèques de nuit", "verified_date": "2026-04-22" }, "geometry": { "type": "Point", "coordinates": [ 2.334208, 48.856342 ] } },
{ "type": "Feature", "properties": { "name": "Ancêtres Italiens", "category": "Bibliothèques de nuit", "verified_date": "2026-11-07" }, "geometry": { "type": "Point", "coordinates": [ 2.363314, 48.873246 ] } },
{ "type": "Feature", "properties": { "name": "Apfelbaum Library", "category": "Bibliothèques de nuit", "verified_date": "2026-06-20" }, "geometry": { "type": "Point", "coordinates": [ 2.330685, 48.849518 ] } },
{ "type": "Feature", "properties": { "name": "Archives de l'AP-HP", "category": "Bibliothèques de nuit", "verified_date": "2026-01-05" }, "geometry": { "type": "Point", "coordinates": [ 2.366407, 48.857094 ] } },
{ "type": "Feature", "properties": { "name": "Arthur Rimbaud Library", "category": "Bibliothèques de nuit", "verified_date": "2026-08-18" }, "geometry": { "type": "Point", "coordinates": [ 2.355874, 48.856134 ] } },
{ "type": "Feature", "properties": { "name": "Association Bibliotheque Braille Enfantine", "category": "Bibliothèques de nuit", "verified_date": "2026-03-03" }, "geometry": { "type": "Point", "coordinates": [ 2.372404, 48.868038 ] } },
{ "type": "Feature", "properties": { "name": "Association Francaise de Therapie", "category": "Bibliothèques de nuit", "verified_date": "2026-10-16" }, "geometry": { "type": "Point", "coordinates": [ 2.308679, 48.87096 ] } },
{ "type": "Feature", "properties": { "name": "Attractive", "category": "Bibliothèques de nuit", "verified_date": "2026-05-01" }, "geometry": { "type": "Point", "coordinates": [ 2.326704, 48.866369 ] } },
{ "type": "Feature", "properties": { "name": "BNF", "category": "Bibliothèques de nuit", "verified_date": "2026-12-14" }, "geometry": { "type": "Point", "coordinates": [ 2.338076, 48.867811 ] } },
{ "type": "Feature", "properties": { "name": "BPI Bibliotheque Publique D Information", "category": "Bibliothèques de nuit", "verified_date": "2026-07-27" }, "geometry": { "type": "Point", "coordinates": [ 2.352378, 48.859478 ] } },
{ "type": "Feature", "properties": { "name": "BPI-Beaubourg", "category": "Bibliothèques de nuit", "verified_date": "2026-02-12" }, "geometry": { "type": "Point", "coordinates": [ 2.351867, 48.860532 ] } },
{ "type": "Feature", "properties": { "name": "Beaubourg Librairie des Arts", "category": "Bibliothèques de nuit", "verified_date": "2026-09-25" }, "geometry": { "type": "Point", "coordinates": [ 2.356791, 48.865189 ] } },
{ "type": "Feature", "properties": { "name": "Bib Cent du Service de Sante Des Armees", "category": "Bibliothèques de nuit", "verified_date": "2026-04-10" }, "geometry": { "type": "Point", "coordinates": [ 2.341252, 48.841187 ] } },
{ "type": "Feature", "properties": { "name": "Bibliothe que Centrale - Muse'um national d'histoire naturelle (MNHN)", "category": "Bibliothèques de nuit", "verified_date": "2026-11-23" }, "geometry": { "type": "Point", "coordinates": [ 2.355838, 48.84266 ] } },
{ "type": "Feature", "properties": { "name": "24hourstravel", "category": "Tours et infos touristiques", "verified_date": "2026-06-08" }, "geometry": { "type": "Point", "coordinates": [ 2.34781, 48.864739 ] } },
{ "type": "Feature", "properties": { "name": "2CVPrivateParis", "category": "Tours et infos touristiques", "verified_date": "2026-01-21" }, "geometry": { "type": "Point", "coordinates": [ 2.337967, 48.889998 ] } },
{ "type": "Feature", "properties": { "name": "382444404", "category": "Tours et infos touristiques", "verified_date": "2026-08-06" }, "geometry": { "type": "Point", "coordinates": [ 2.32691, 48.87068 ] } },
{ "type": "Feature", "properties": { "name": "A French Frye in Paris", "category": "Tours et infos touristiques", "verified_date": "2026-03-19" }, "geometry": { "type": "Point", "coordinates": [ 2.34083, 48.86124 ] } },
{ "type": "Feature", "properties": { "name": "Aeon Tours of Paris", "category": "Tours et infos touristiques", "verified_date": "2026-10-04" }, "geometry": { "type": "Point", "coordinates": [ 2.35859, 48.86378 ] } },
{ "type": "Feature", "properties": { "name": "Agence ORNIcom : location de gyropode Segway à Paris et sur toute la France", "category": "Tours et infos touristiques", "verified_date": "2026-05-17" }, "geometry": { "type": "Point", "coordinates": [ 2.303244, 48.852662 ] } },
{ "type": "Feature", "properties": { "name": "Al Abrar Voyages", "category": "Tours et infos touristiques", "verified_date": "2026-12-02" }, "geometry": { "type": "Point", "coordinates": [ 2.31277, 48.88631 ] } },
{ "type": "Feature", "properties": { "name": "Allison Zinder", "category": "Tours et infos touristiques", "verified_date": "2026-07-15" }, "geometry": { "type": "Point", "coordinates": [ 2.398851, 48.862635 ] } },
{ "type": "Feature", "properties": { "name": "Association Touristique Cheminots", "category": "Tours et infos touristiques", "verified_date": "2026-02-28" }, "geometry": { "type": "Point", "coordinates": [ 2.371287, 48.846263 ] } },
{ "type": "Feature", "properties": { "name": "Avenir Tourisme", "category": "Tours et infos touristiques", "verified_date": "2026-09-13" }, "geometry": { "type": "Point", "coordinates": [ 2.35804, 48.868509 ] } }

Wrote 45 features to /work/paris_pois.geojson
Stale records: 10
                                                                           name                     category verified_date  stale
0                                                                     % Arabica           Cafés ouverts tard    2026-01-01   True
1                                                                1T. rue Scribe           Cafés ouverts tard    2026-08-14  False
2                                                                    1ndix Café           Cafés ouverts tard    2026-03-27  False
3                                                                  2 Steps Café           Cafés ouverts tard    2026-10-12  False
4                                         3234 Café - Trente Deux Trente Quatre           Cafés ouverts tard    2026-05-25  False
5                                                                      360 Cafe           Cafés ouverts tard    2026-12-10  False
6                                                                 3w Cafe Paris           Cafés ouverts tard    2026-07-23  False
7                                                             48 Collagen Caf√©           Cafés ouverts tard    2026-02-08   True
8                                                             86 Champs Elysées           Cafés ouverts tard    2026-09-21  False
9                                                           A la Ville de Paris           Cafés ouverts tard    2026-04-06  False
10                                                                A minima cafe           Cafés ouverts tard    2026-11-19  False
11                                                                  AD DictCafé           Cafés ouverts tard    2026-06-04  False
12                                                                      ANGIOLO           Cafés ouverts tard    2026-01-17   True
13                                                                       Abaita           Cafés ouverts tard    2026-08-02  False
14                                                                Absinthe Café           Cafés ouverts tard    2026-03-15   True
15                                                                   Acai & You           Cafés ouverts tard    2026-10-28  False
16                                                       Adulis Cafe Abyssinien           Cafés ouverts tard    2026-05-13  False
17                                                                  After Place           Cafés ouverts tard    2026-12-26  False
18                                                                  After Place           Cafés ouverts tard    2026-07-11  False
19                                                                  After Place           Cafés ouverts tard    2026-02-24   True
20                                                                  AUP Housing        Bibliothèques de nuit    2026-09-09  False
21                                                          Academie de Medical        Bibliothèques de nuit    2026-04-22  False
22                                                            Ancêtres Italiens        Bibliothèques de nuit    2026-11-07  False
23                                                            Apfelbaum Library        Bibliothèques de nuit    2026-06-20  False
24                                                          Archives de l'AP-HP        Bibliothèques de nuit    2026-01-05   True
25                                                       Arthur Rimbaud Library        Bibliothèques de nuit    2026-08-18  False
26                                   Association Bibliotheque Braille Enfantine        Bibliothèques de nuit    2026-03-03   True
27                                            Association Francaise de Therapie        Bibliothèques de nuit    2026-10-16  False
28                                                                   Attractive        Bibliothèques de nuit    2026-05-01  False
29                                                                          BNF        Bibliothèques de nuit    2026-12-14  False
30                                      BPI Bibliotheque Publique D Information        Bibliothèques de nuit    2026-07-27  False
31                                                                BPI-Beaubourg        Bibliothèques de nuit    2026-02-12   True
32                                                 Beaubourg Librairie des Arts        Bibliothèques de nuit    2026-09-25  False
33                                      Bib Cent du Service de Sante Des Armees        Bibliothèques de nuit    2026-04-10  False
34        Bibliothe que Centrale - Muse'um national d'histoire naturelle (MNHN)        Bibliothèques de nuit    2026-11-23  False
35                                                                24hourstravel  Tours et infos touristiques    2026-06-08  False
36                                                              2CVPrivateParis  Tours et infos touristiques    2026-01-21   True
37                                                                    382444404  Tours et infos touristiques    2026-08-06  False
38                                                       A French Frye in Paris  Tours et infos touristiques    2026-03-19  False
39                                                          Aeon Tours of Paris  Tours et infos touristiques    2026-10-04  False
40  Agence ORNIcom : location de gyropode Segway à Paris et sur toute la France  Tours et infos touristiques    2026-05-17  False
41                                                             Al Abrar Voyages  Tours et infos touristiques    2026-12-02  False
42                                                               Allison Zinder  Tours et infos touristiques    2026-07-15  False
43                                            Association Touristique Cheminots  Tours et infos touristiques    2026-02-28   True
44                                                              Avenir Tourisme  Tours et infos touristiques    2026-09-13  False

cd /work && python3 -c "
import json
with open('paris_pois.geojson') as f:
    data = json.load(f)
print('Type:', data['type'])
print('Features count:', len(data['features']))
print('CRS:', data.get('crs'))
# Check first and last feature properties
print('First props:', data['features'][0]['properties'])
print('Last props:', data['features'][-1]['properties'])
# Check stale counts
stale_count = sum(1 for f in data['features'] if f['properties'].get('stale'))
print('Stale count:', stale_count)
"

Type: FeatureCollection
Features count: 45
CRS: {'type': 'name', 'properties': {'name': 'urn:ogc:def:crs:OGC:1.3:CRS84'}}
First props: {'name': '% Arabica', 'category': 'Cafés ouverts tard', 'verified_date': '2026-01-01', 'stale': True}
Last props: {'name': 'Avenir Tourisme', 'category': 'Tours et infos touristiques', 'verified_date': '2026-09-13', 'stale': False}
Stale count: 10