In the "PostGIS - using sqlpage with geographic data" example, no points with latitude 0 are shown. - Githubissues

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly

https://sql.ophir.dev

MIT License

880 stars 62 forks source link

In the "PostGIS - using sqlpage with geographic data" example, no points with latitude 0 are shown. #462

Closed matthieupeeters closed 6 days ago

matthieupeeters commented 1 week ago

Introduction

When adding points to the "PostGIS - using sqlpage with geographic data" example, when adding a point with latitude 0 it is ignored.

Points with any other latitude are shown.

Example fix at the end of the report.

To Reproduce

Run the example code.
Add a point with lat/long 0 0,

Actual behavior

The point will not show up on the map.

Expected behavior

The point with lat/long 0 0 shows up on the map

Version information

OS: Windows
Database Postgres
SQLPage Version: 0.24.1

Additional context

The map.handlebars template has a bug which filters out latitudes of 0. A fix is in the fork here:

https://github.com/matthieupeeters/SQLpage.bugfixes

PR here: https://github.com/lovasoa/SQLpage/pull/463

lovasoa commented 6 days ago

Thanks for both reporting and fixing this !

https://github.com/lovasoa/SQLpage/pull/463