[openstreetmap/openstreetmap-website] Add moderation zones where anonymous notes are not allowed (PR #6713)

[Paul Norman]

@pnorman commented on this pull request.



> @@ -0,0 +1,40 @@
+# frozen_string_literal: true
+
+# == Schema Information
+#
+# Table name: moderation_zones
+#
+#  id            :bigint           not null, primary key
+#  name          :string           not null
+#  reason        :string           not null
+#  reason_format :enum             default("markdown")
+#  zone          :st_geometry      not null, geometry, 0

Forcing polygons also improves indexing. If you represent the US as a multipolygon most of Europe is within its bounding box. If you split it into 2-4 the bounding boxes become sensible.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/6713#discussion_r2769737904
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/6713/review/3757796134 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20260205/69a19a6f/attachment.htm>