lekss361
  • Joined on 2026-05-15
lekss361 commented on issue lekss361/gendesign#2007 2026-06-27 17:44:24 +00:00
[tradein][yandex] SERP _entity_to_lot: писать ceiling_height + kitchen_area_m2 в колонки + нормализовать house_type

Working on this in PR #2016. code-reviewer (2 minor исправлены: ceiling cap 2.0–6.0 м против overflow numeric(3,2); backfill 'other'(299)→NULL для паритета…

lekss361 created pull request lekss361/gendesign#2016 2026-06-27 17:44:04 +00:00
feat(tradein/yandex): normalize house_type + promote kitchen/ceiling to columns (#2007)
lekss361 deleted branch fix/tradein-remove-tier-ratio-footgun from lekss361/gendesign 2026-06-27 17:34:56 +00:00
lekss361 pushed to main at lekss361/gendesign 2026-06-27 17:34:56 +00:00
50684ce87e fix(tradein/estimator): remove dead tier-aware-ratio path — truncation artifact + footgun (#2002)
lekss361 merged pull request lekss361/gendesign#2015 2026-06-27 17:34:55 +00:00
fix(tradein/estimator): remove dead tier-aware-ratio path — truncation artifact + footgun (#2002)
lekss361 created pull request lekss361/gendesign#2015 2026-06-27 17:34:44 +00:00
fix(tradein/estimator): remove dead tier-aware-ratio path — truncation artifact + footgun (#2002)
lekss361 commented on issue lekss361/gendesign#2002 2026-06-27 17:34:00 +00:00
[tradein][analytics] Elite/premium estimate accuracy — data-research findings + roadmap

Tier-aware ratio (#928) — measured + diagnosed dead-end (removed)

Ran the live full-spine harness (700 prod deals) with tier_aware_ratio_enabled OFF vs ON:

  • бизнес bias −14.8→−…
lekss361 deleted branch feat/tradein-2009-avito-detail-house-type from lekss361/gendesign 2026-06-27 17:30:36 +00:00
lekss361 merged pull request lekss361/gendesign#2014 2026-06-27 17:30:35 +00:00
fix(tradein/avito): persist house_type + house_catalog_url in save_detail_enrichment (#2009)
lekss361 pushed to main at lekss361/gendesign 2026-06-27 17:30:35 +00:00
4a93a9297c fix(tradein/avito): persist house_type + house_catalog_url in save_detail_enrichment (#2009)
lekss361 commented on issue lekss361/gendesign#2009 2026-06-27 17:29:38 +00:00
[tradein][avito] detail: дописать house_type + house_catalog_url (+5 house-level полей) в save_detail_enrichment

Working on this in PR #2014 (house_type + house_catalog_url→house_url в save_detail_enrichment; миграция не нужна — обе колонки существуют). code-reviewer…

lekss361 created pull request lekss361/gendesign#2014 2026-06-27 17:29:23 +00:00
fix(tradein/avito): persist house_type + house_catalog_url in save_detail_enrichment (#2009)
lekss361 commented on issue lekss361/gendesign#2010 2026-06-27 17:21:58 +00:00
[tradein][avito] IMV: персист comparables + searchSimilarUrl (сейчас полностью выбрасываются)

Прод-замер перед работой (2026-06-27, ssh gendesign → tradein-postgres):

  • avito_imv_evaluations: всего 16 записей, за последние 7 дней —…
lekss361 opened issue lekss361/gendesign#2013 2026-06-27 17:21:54 +00:00
[tradein][avito] year_built = 0% — источник не отдаёт год постройки (потолок ~1.7% через houses-catalog)
lekss361 opened issue lekss361/gendesign#2012 2026-06-27 17:21:40 +00:00
[tradein][estimator] Подключить house_type/kitchen/ceiling как фичи comp-scoring (+ обязательный backtest)
lekss361 commented on issue lekss361/gendesign#1967 2026-06-27 16:58:13 +00:00
[tradein][data] avito 54% NULL lat → невидим PostGIS-радиусу: geo-backfill + dedup на ингесте (рычаг точности массы оценок)

Свежий замер 2026-06-27 (ssh→tradein-postgres, active listings) подтверждает проблему:

  • avito geo (lat NOT NULL): 53% active → **~47% (≈14k из 30327…
lekss361 opened issue lekss361/gendesign#2011 2026-06-27 16:57:55 +00:00
[tradein] Аудит покрытия полей скрапперов avito/cian/yandex — сводка + прод-замер (2026-06-27)
lekss361 opened issue lekss361/gendesign#2010 2026-06-27 16:57:24 +00:00
[tradein][avito] IMV: персист comparables + searchSimilarUrl (сейчас полностью выбрасываются)
lekss361 opened issue lekss361/gendesign#2009 2026-06-27 16:57:13 +00:00
[tradein][avito] detail: дописать house_type + house_catalog_url (+5 house-level полей) в save_detail_enrichment
lekss361 opened issue lekss361/gendesign#2008 2026-06-27 16:56:53 +00:00
[tradein][cian] SERP: промоут полей из raw_payload в колонки — kitchen_area_m2, mortgage_available (+ новые is_apartments, is_rosreestr_checked)