andrewheekin / geonotes.io

GeoNotes.io is the open source platform for community-contributed Street View notes
https://geonotes.io
GNU Affero General Public License v3.0
10 stars 2 forks source link
geoguess geoguessr geonotes nextjs streetview

GeoNotes.io

GeoNotes.io is the open source platform for community-contributed
Street View notes for GeoGuessr

geonotes.io


GitHub Repo stars License


GeoNotes.io is the open source platform for community-contributed Street View notes. Built with Next.js on Vercel and Supabase.

Demo

Home page


With cateogry filter

Contributing

GeoNotes is open source and contributions are welcome!

Supabase

Installing the Supabase CLI.

You can easily pull the database schema down to your local project with the Supabase CLI by running the db pull command. Read the local development docs for detailed instructions.

supabase link --project-ref <project-id>
# You can get <project-id> from your project's dashboard URL: https://supabase.com/dashboard/project/<project-id>
supabase db pull

Guide to Supabase Database migrations

Sync the remote database schema to local project

# Capture any changes that you have made to your remote database
supabase db pull

# To apply the new migration to your local database:
supabase migration up

Create a local database migration

supabase migration new your_migration_name

Deploy any local database migrations

# To apply the new migration to your local database:
supabase db reset

# To apply the new migration to your remote database:
supabase db push

If a local migration says it has been applied, but isn't showing up in the remote database

On the Supabase dashboard, go to Table Editor > supabase_migrations schema > schema_migrations table. Delete the row for the migration that is not showing up. Then run supabase db push again. Note, this must be done from the SQL editor. Ex:

delete from supabase_migrations.schema_migrations where version='20231219141738'

Google Street View and Maps Notes

Street View Static API Docs

Street View Panorama Docs

Ex, https://www.google.com/maps/@?api=1&map_action=pano&parameters

Google Maps Street View link format

Ex, https://www.google.com/maps/@35.6934524,139.7344228,3a,73.9y,7.76h,85.87t/data=!3m6!1e1!3m4!1svBVErdzbPNOtYbPQAd57FA!2e0!7i16384!8i8192?entry=ttu