diff options
| author | ivar <i@oiee.no> | 2025-12-02 22:38:23 +0100 |
|---|---|---|
| committer | ivar <i@oiee.no> | 2025-12-02 22:38:23 +0100 |
| commit | 68ffad06a6cfd2cd2015ab03fb82bf69629dd7ec (patch) | |
| tree | efab90e59deae00953704059efdec14cb3ad81c7 /api/WhatApi/Endpoints/GetPlacesEndpoint.cs | |
| parent | d2089c0038460504869b27203143e40441a86eff (diff) | |
| download | what-68ffad06a6cfd2cd2015ab03fb82bf69629dd7ec.tar.xz what-68ffad06a6cfd2cd2015ab03fb82bf69629dd7ec.zip | |
Move off razor pages
Diffstat (limited to 'api/WhatApi/Endpoints/GetPlacesEndpoint.cs')
| -rw-r--r-- | api/WhatApi/Endpoints/GetPlacesEndpoint.cs | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/api/WhatApi/Endpoints/GetPlacesEndpoint.cs b/api/WhatApi/Endpoints/GetPlacesEndpoint.cs index 8dbdff6..08068c8 100644 --- a/api/WhatApi/Endpoints/GetPlacesEndpoint.cs +++ b/api/WhatApi/Endpoints/GetPlacesEndpoint.cs @@ -12,7 +12,7 @@ public class GetPlacesEndpoint(Database db) : BaseEndpoint if (w > e) { resultingQuery = db.Places .FromSqlInterpolated($""" - SELECT * FROM "Place" + SELECT * FROM "place" WHERE ST_Intersects( "Location", ST_MakeEnvelope({w}, {s}, 180, {n}, {Constants.Wgs84SpatialReferenceId}) || ST_MakeEnvelope(-180, {n}, {e}, {n}, {Constants.Wgs84SpatialReferenceId}) @@ -21,7 +21,7 @@ public class GetPlacesEndpoint(Database db) : BaseEndpoint } else { resultingQuery = db.Places .FromSqlInterpolated($""" - SELECT * FROM "Place" + SELECT * FROM "place" WHERE ST_Intersects( "Location", ST_MakeEnvelope({w}, {s}, {e}, {n}, {Constants.Wgs84SpatialReferenceId}) |