Skip to content

String IDs don't appear to show up #2

@C-Loftus

Description

@C-Loftus

Thank you for your great work on this tool. I find it super useful for checking my files locally.

I was trying to import a geoparquet file with a string id column and it loads fine, but it seems like the id values don't get populated in the popup.

I was wondering if this is an issue or limitation in the tool in some way.

Example of the issue
Image


File Metadata for Context

I believe my test file is compliant to the spec and shouldn't have any issues.

gpio inspect  /tmp/test.parquet --tail 5

📄 test.parquet (61.27 KB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Rows: 581
Row Groups: 1
Compression: UNCOMPRESSED
Parquet Type: No Parquet geo logical type
GeoParquet Version: 1.1.0
CRS: OGC:CRS84 (default)
Geometry Types: Point
Bbox: [-147.179950, 26.721840, -71.518060, 64.792510]

Columns (2):
┏━━━━━━━━━━━━━┳━━━━━━━━━━┓
┃ Name        ┃ Type     ┃
┡━━━━━━━━━━━━━╇━━━━━━━━━━┩
│ geometry 🌍 │ GEOMETRY │
│ id          │ VARCHAR  │
└─────────────┴──────────┘

Preview (last 5 rows):
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ geometry                              ┃ id                                                 ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ POINT (-111.72855 46.647670000000005) │ <https://api.wwdh.internetofwater.app/collectio... │
│ POINT (-120.11332999999999 39.32667)  │ <https://api.wwdh.internetofwater.app/collectio... │
│ POINT (-80.00997999999998 39.58247)   │ <https://api.wwdh.internetofwater.app/collectio... │
│ POINT (-92.98062 41.3692)             │ <https://api.wwdh.internetofwater.app/collectio... │
│ POINT (-82.9668 40.185719999999996)   │ <https://api.wwdh.internetofwater.app/collectio... │
└───────────────────────────────────────┴────────────────────────────────────────────────────┘

gpio validate  /tmp/test.parquet
GeoParquet Validation Report
================================
Detected: 1.1.0
Core Metadata:
  ✓ file includes a "geo" metadata key
  ✓ metadata is a valid JSON object
  ✓ metadata includes a "version" string: 1.1.0
  ✓ metadata includes a "primary_column" string: geometry
  ✓ metadata includes a "columns" object
  ✓ column metadata includes primary_column "geometry"
Column Validation:
  ✓ column "geometry" has valid encoding: WKB
  ✓ column "geometry" has valid geometry_types: ['Point']
  ✓ column "geometry" has no CRS (defaults to OGC:CRS84)
  ✓ column "geometry" has no orientation (defaults to counterclockwise)
  ✓ column "geometry" has no edges (defaults to planar)
  ✓ column "geometry" has valid bbox: [-147.17995, 26.72184, -71.51806000000002, 64.79251]
  ✓ column "geometry" has no epoch
Parquet Schema:
  ✓ geometry column "geometry" is not grouped
  ✓ geometry column "geometry" uses BYTE_ARRAY type
  ✓ geometry column "geometry" is optional
Data Validation:
  ✓ all geometry values match "WKB" encoding (581 checked)
  ✓ all geometry types match declared "geometry_types" (581 checked)
  ○ no orientation specified, skipping check
  ✓ all geometries fall within declared bbox (581 checked)
  ✓ coordinates within valid bounds for None (OGC:CRS84) (581 checked)
GeoParquet 1.1:
  ✓ column "geometry" has no covering (optional)
  ✓ file extension is ".parquet"

Summary: 22 passed, 0 warnings, 0 failed

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions