车辆关锁

This commit is contained in:
yanglei 2026-01-07 10:21:44 +08:00
parent b1de55eb9a
commit 09bbd42e10

View File

@ -15,7 +15,7 @@
AND s.site_type = 1
AND ST_Contains(
s.site_polygon::geometry,
ST_MakePoint((b.location[0])::float, (b.location[1])::float)::geometry
ST_SetSRID(ST_MakePoint(ST_X(b.location), ST_Y(b.location)), 4326)
)
) as in_parking_area;
</select>
@ -33,7 +33,7 @@
AND s.site_type = 2
AND ST_Contains(
s.site_polygon::geometry,
ST_MakePoint((b.location[0])::float, (b.location[1])::float)::geometry
ST_SetSRID(ST_MakePoint(ST_X(b.location), ST_Y(b.location)), 4326)
)
) as in_no_parking_area;
</select>