POI Maintenance Tools
Database maintenance and data management for Points of Interest
Database Statistics
Current state of POIs, photos, and relationships
Rebuild All Photos
Create photo records for all POIs that have photos in their raw data
This will:
- Scan all POIs in the database
- Extract photo references from raw data
- Create missing photo records
- Skip existing photos
Cleanup Orphaned Photos
Remove photo records that no longer have an associated POI
This will:
- Find photo records with missing POIs
- Delete orphaned photo records
- Free up database space
This action is irreversible. Make sure to backup your database first.
Rebuild POI to Geoname Relationships
Recreate all geographic relationships between POIs and cities/neighborhoods
This will:
- Delete all existing POI-to-GeoName relationships
- Analyze each POI's location data
- Create new relationships based on proximity
- Link POIs to their nearest cities