diff options
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}) |