Freegle / Iznik

71%

master: 71%

LAST BUILD ON BRANCH fix/spatial-postcodes-centroid

branch: fix/spatial-postcodes-centroid

CHANGE BRANCH

x

Reset

• fix/spatial-postcodes-centroid
• chore/coverage-adapter
• chore/coverage-amp
• chore/coverage-app-release-classifier
• chore/coverage-dashboard-go
• chore/coverage-database
• chore/coverage-donations-helpers
• chore/coverage-emailtracking
• chore/coverage-embedding
• chore/coverage-export
• chore/coverage-handler
• chore/coverage-image
• chore/coverage-isochrone
• chore/coverage-merge
• chore/coverage-misc
• chore/coverage-namegen
• chore/coverage-reusebenefit
• chore/coverage-sentrylog
• chore/coverage-sso
• chore/coverage-team
• chore/coverage-use-blur-detector
• chore/coverage-use-distance
• chore/coverage-use-suppress-exception
• chore/coverage-use-typewriter
• chore/coverage-useTimeFormat
• chore/coverage-useTwem
• chore/coverage-utils
• chore/coverage-utils-flex-json
• chore/coverage-vectorsearch-20260422
• chore/coverage-worrywords-edge-cases
• chore/pr-template
• chore/purge-email-tracking-30d
• chore/skip-iznik-server-ci-tests
• ci/spatial-tests-serial
• cleanup/retire-cake-for-mods
• coverage/Go-tdd
• coverage/event-filtering-tests
• coverage/go-1714999056
• coverage/go-status-readgithead-2026-04-29
• coverage/go-tryst-20260503
• coverage/laravel-gemini-service-20260504
• coverage/laravel-message-commands-2026-05-02
• coverage/useModMessages-uncovered-branches-1777447042
• coverage/vitest-uppy-retry-coalescer-2026-05-07
• coverage/vitest-use-trace-20260425
• diagnose/repost-group-change-dom-dump
• docs/pr-discourse-link-standard
• feat/android-app-shortcuts
• feat/app-native-features
• feat/archive-attachments
• feat/batch-migrate-non-email-jobs
• feat/batch-migrate-remaining-scripts
• feat/birthday-emails
• feat/chat-chaseup-mods
• feat/chat-review-notify
• feat/chat-review-pending
• feat/contentcheck-pipeline
• feat/digest-reply-notice
• feat/donations-daily-summary
• feat/engage-emails
• feat/events-digest
• feat/group-customisation
• feat/groups-closed-reminder
• feat/groups-no-messages
• feat/haptics-feedback
• feat/lovejunk-tn-invoice
• feat/microvolunteering-notify
• feat/mod-active-welfare
• feat/modtools-capacitor-app
• feat/newsfeed-mod-notif
• feat/noticeboard-thank-email
• feat/share-into-freegle
• feat/share-into-freegle-ios
• feat/spatial-remove-expanding-bbox
• feat/spatial-routing-ui-yesterday
• feat/stories-ask
• feat/stories-to-central
• feat/tn-names-fix
• feat/tryst-calendar-reminders
• feat/user-support-dump
• feat/volunteering-digest
• feat/welcome-review
• feature/ai-image-prompt-improvements
• feature/ai-image-regen
• feature/android-coldstart-safe
• feature/autoapprove-delay
• feature/batch-deadlock-fixes
• feature/batch-deadlock-fixes-v2
• feature/batch-jobs-dry-run-and-fixes
• feature/bounce-users-suspension
• feature/bulk-offer-clearance
• feature/bulk-offer-management
• feature/cansubmit-messagevalid
• feature/charity-badge
• feature/chat-api-test-coverage
• feature/chat-button-modifier-keys
• feature/chat-expected-migration
• feature/chat-process-migration
• feature/chat-spam-migration
• feature/check-spammers-migration
• feature/cloudflare-ai-images
• feature/cls-improvements
• feature/compose-single-call-rework
• feature/concern-keywords
• feature/coverage-20260429
• feature/coverage-laravel-event-listeners
• feature/coverage-message
• feature/coverage-postcode-remapping
• feature/coverage-vitest-1777133352
• feature/coverage-vitest-20260504
• feature/daily-posts-push
• feature/eee-identification
• feature/enable-batch-jobs
• feature/engage-update-migration
• feature/explore-mobile-finder
• feature/exports-migration
• feature/frontend-design-refresh
• feature/giftaid-chaseup-migration
• feature/go-coverage-group
• feature/go-coverage-pr
• feature/hybrid-embedding-search
• feature/leave-freegle-notice
• feature/memberships-process-migration
• feature/message-search-index-migration
• feature/migrate-http-endpoints
• feature/mobile-feel
• feature/mod-notifs-migration
• feature/modtools-mod-mail-logging-9518
• feature/monitor-fsm-process-quality
• feature/monitor-fsm-sqlite
• feature/multi-group-messages
• feature/multi-group-messages-join
• feature/notification-chaseup-email
• feature/putmessage-item-validation
• feature/reengagement-mails
• feature/reply-to-chat
• feature/retire-subject-line-settings
• feature/rippling-browse
• feature/rippling-held-replies
• feature/rippling-immediate-mails
• feature/rippling-location-velocity
• feature/rippling-mod-location-changes
• feature/rippling-mod-ui
• feature/rippling-reach-engine
• feature/rippling-relax-seen-threshold
• feature/rippling-secondary-reject
• feature/rippling-self-tuning
• feature/rippling-single-group-posting
• feature/rippling-tighten-spam-checks
• feature/search-filter-tests
• feature/search-relevance-fix-9585
• feature/session-settings-defaults
• feature/social-login-profile-pictures
• feature/spatial-improvements
• feature/tdd-coverage-changes-endpoint
• feature/test-go-location-isochrones
• feature/unified-digest-revision
• feature/users-modmails-migration
• feature/vector-search
• feature/vite8-build-speed
• feature/volunteering-maintenance
• feature/wire-concern-keywords
• fix-295
• fix/add-member-409
• fix/ai-image-test
• fix/ai-images-9646-1
• fix/approved-members-infinite-scroll
• fix/auth-userlist-non-array-crash
• fix/authority-autocomplete-crash
• fix/auto-repost-excessive-9481
• fix/auto-repost-missing-items-9481
• fix/banned-members-pagination-test
• fix/banned-no-post-digest
• fix/chat-delivery-9800-1
• fix/chat-notifications-closed-blocked
• fix/chat-phone-warning-false-positive-9518
• fix/chat-review-message-merge
• fix/chitchat-image-size-9749-5
• fix/chitchat-ios-cardinality
• fix/chitchat-ios-limited-posts
• fix/chitchat-reply-dots-padding-9749
• fix/chitchat-scroll-history
• fix/ci-clear-stale-status-labels
• fix/ci-npm-install-retry
• fix/config-9793-5
• fix/content-moderation-9620-283
• fix/digest-came-and-went-dedup
• fix/digest-wanted-no-image-wait
• fix/discourse-rate-limit-retry
• fix/duplicate-link-collection
• fix/eee-browser-submitting-flag
• fix/email-9363-29
• fix/email-rendering-9363-31
• fix/email-tracking-sent-at-index-name
• fix/enforce-discourse-quote-hook
• fix/event-email-images-broken-url
• fix/exclude-location-triggers-postcode-remap
• fix/external-da-pointer-events-block-clicks
• fix/gradle-plugin-portal
• fix/group-config-editing-9793-8
• fix/group-contact-label-9643-1
• fix/index-vue-onserverprefetch-deterministic-coverage
• fix/ios-nse-wiring-absolute-path
• fix/ip-abuse-warning-9768-5
• fix/jobimg-9630-6
• fix/jobmodeltest-jobs-lock-wait
• fix/katapult-reaper-zombie-fallback
• fix/log-history-group-filter-9672-3
• fix/member-deletion-status
• fix/member-review-ignore-noop-9618
• fix/member-seen-on-many-groups-review
• fix/merge-api-return-logins-v1-parity
• fix/message-log-historical-name
• fix/message-log-historical-subject
• fix/message-summary-eager-image-loading
• fix/messagelist-crosspost-dedup-9733-7
• fix/missing-received-logs
• fix/mod-admin-send-pending-400
• fix/modconfig-404-v1-parity
• fix/modlog-historical-blank-and-auto-approved-label
• fix/modlog-self-delete-label
• fix/modlogs-dedup
• fix/modmail-log-pending-subject-9518-211
• fix/modmail-log-test-9518
• fix/modnotif-chitchat-clarity-avatar
• fix/modtools-badge-count-9654-19
• fix/modtools-banned-pagination-9518-246
• fix/modtools-chat-badge-stuck
• fix/modtools-chat-name-9719-1
• fix/modtools-chat-review-hover-reveal
• fix/modtools-chat-review-member-details
• fix/modtools-chat-review-member-details-9518-219
• fix/modtools-config-9793-1
• fix/modtools-deleted-message-log-9622
• fix/modtools-duplicate-highlight-9518-341
• fix/modtools-email-branding
• fix/modtools-feedback-scroll
• fix/modtools-images-badge-9630-44
• fix/modtools-infinite-scroll-pagination
• fix/modtools-ios-add-note-chat-review-9518-234
• fix/modtools-login-port-assertion
• fix/modtools-member-history-9672-3
• fix/modtools-member-review-buttons
• fix/modtools-members-9518-238
• fix/modtools-members-9518-238-modmail-filter-test
• fix/modtools-members-9518-238-work
• fix/modtools-members-9518-239
• fix/modtools-photo-permissions
• fix/modtools-postcode-edit-iphone-ui
• fix/modtools-related-members-9631-16
• fix/modtools-related-members-9631-19
• fix/modtools-related-members-flash-and-filter
• fix/modtools-stdmsg-9644-1
• fix/monitor-bugs-batch
• fix/mt-calendar-icon-padding
• fix/mt-duplicate-highlight-9518
• fix/mt-stdmsg-autogrow-boxes
• fix/myposts-old-posts-pinned-by-room-chat-9481-583
• fix/myposts-old-rejected-9481-583
• fix/national-volunteers-v2-parity
• fix/out-of-area-postcode-test
• fix/patch-message-groupid-draft
• fix/pending-app-9783-6
• fix/pending-message-visibility
• fix/pending-url-spam-collection
• fix/photos-vanished-9629
• fix/playwright-coverage-sourcefilter-exclusions
• fix/post-creation-9788-28
• fix/post-validation-9788-32
• fix/post-warnings-9766-14
• fix/queue-fatal-error-sentry
• fix/rejected-message-item-when-no-locationid
• fix/related-members-9631-16
• fix/related-members-9642-1
• fix/related-members-counter-9631
• fix/related-members-counter-stuck-9631
• fix/related-members-deleted-filter
• fix/related-members-group-filter
• fix/reopen-closed-chat-on-message
• fix/reply-pane-photo-zoom
• fix/reply-statemachine-formref-race
• fix/retire-unused-kudos
• fix/review-ignore-held-members
• fix/scheduler-minute-drift
• fix/search-white-goods-relevance-9585-18
• fix/sentry-7384446789-merge-logins-forEach
• fix/sentry-7421179445-mymessage-repost-null
• fix/sentry-failed-to-fetch-image-freegletusd
• fix/sentry-ftutils-getinnerdimensions-null
• fix/sentry-ftutils-getplacementposition-nuxt3-ces
• fix/sentry-ignore-freestar-ftutils-null
• fix/sentry-ignore-notreadable-io
• fix/sentry-in-operator-error-undefined
• fix/sentry-leaflet-tooltip-nullmap-nuxt3-d7b
• fix/sentry-nuxt3-d45-filter-undefined-error
• fix/session-series-bigint
• fix/spammer-patch-preserve-reporter
• fix/spammer-v1-parity-unconfirmed
• fix/stats-chart-types-and-ad-cssbind
• fix/stdmsg-delete-and-config
• fix/stdmsg-delete-config-9518
• fix/stdmsg-editable-body-tn-editlink
• fix/stdmsg-instruction-red
• fix/stdmsg-textarea-min-3-lines
• fix/support-purge-queues-forget-task
• fix/test-failures-investigation
• fix/tn-crosspost-photo-scrape
• fix/uppy-debounce-retry-all
• fix/v2-api-user-emails-message-postings
• fix/v2-patch-user-trustlevel-not-persisted
• fix/vector-keyword-whole-word
• fix/vector-search-keyword-boost
• fix/vector-search-subject-tier
• fix/vectorsearch-non-determinism-and-irrelevance
• fix/vectorsearch-threshold-white-goods
• fix/withdrawn-pending-soft-delete-403
• master
• messages-multiple-groups
• monorepo/partnerships-page
• perf/email-stats-force-index
• perf/modtools-messages-union-all
• pr-234
• pr-289
• production
• temp-rebase
• test-modspammer-crash-bug
• test/ai-image-regen-history
• test/auth-google-autoselect-coverage
• test/coverage-changes-handler
• test/coverage-chat-notifications
• test/coverage-go-auth-hashpassword
• test/coverage-go-group-create
• test/coverage-go-utils
• test/coverage-location-isochrone
• test/coverage-vitest-uppy-retry-coalescer-1777621557
• test/go-coverage-namevalidation-helpers
• test/group-mod-dismiss-403
• test/katapult-runner-e2e
• test/laravel-coverage-mail-helper
• test/message-package-coverage
• test/message-pure-coverage
• test/related-members-count-stale
• test/session-flexint-coverage
• tn-integration-refactor
• tn-sync-port-testing
• tn-sync-port-testing-local

Build # 21578

Build Type

Pull #767

circleci

Committed by invalid-email-address

Commit Message

fix(spatial): centroid postcode geometry so 2M-row load doesn't error on non-point rows

The postcodes dataset loader called ST_X/ST_Y directly on
COALESCE(ourgeometry, geometry). A handful of type='Postcode' rows carry a
non-point ourgeometry (a LINESTRING/polygon override), and ST_X only accepts a
POINT, so the whole prod load aborted with:

  Error 3516 (22S01): POINT value is a geometry of unexpected type LINESTRING in st_x.

leaving the postcodes index empty (count 0, ready false) and breaking
Location::closestPostcode / apiv2 ClosestPostcode in production. CI passed
because its seeded test postcodes are all points.

Wrap the geometry in ST_Centroid first (a POINT is its own centroid;
LINESTRING/POLYGON collapse to a representative point), matching the existing
expression in compare.go. Verified against prod: 1,961,927 postcodes load and
KNN returns the correct nearest full postcode (WC2N 5DU for Charing Cross,
M2 4NG for central Manchester, both within ~90m).

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

Pull Request Pull Request #767: fix(spatial): centroid postcode geometry so the 2M-row load doesn't error on non-point rows

Coverage Stats

10979 of 14580 branches covered (75.3%)

Branch coverage included in aggregate %.

118917 of 168850 relevant lines covered (70.43%)

36.26 hits per line