<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Golmok Pin</title>
    <description>The latest articles on DEV Community by Golmok Pin (@_1c7d6ebfd97005c1b5f84).</description>
    <link>https://dev.to/_1c7d6ebfd97005c1b5f84</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4238656%2F18dab442-4c01-4365-b1af-9c2a9ed5cab5.png</url>
      <title>DEV Community: Golmok Pin</title>
      <link>https://dev.to/_1c7d6ebfd97005c1b5f84</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/_1c7d6ebfd97005c1b5f84"/>
    <language>en</language>
    <item>
      <title>Comparing shop locations in Seoul by dropping map pins: three hypotheses and what I've built so far</title>
      <dc:creator>Golmok Pin</dc:creator>
      <pubDate>Wed, 11 Nov 2026 08:44:32 +0000</pubDate>
      <link>https://dev.to/_1c7d6ebfd97005c1b5f84/comparing-shop-locations-in-seoul-by-dropping-map-pins-three-hypotheses-and-what-ive-built-so-far-43dh</link>
      <guid>https://dev.to/_1c7d6ebfd97005c1b5f84/comparing-shop-locations-in-seoul-by-dropping-map-pins-three-hypotheses-and-what-ive-built-so-far-43dh</guid>
      <description>&lt;p&gt;I'm building a free side project for people scouting a location for a shop or café in Seoul. You drop a pin on the map and drag it around to compare nearby spots. No sign-up is needed. It's in public testing and currently covers only the main commercial districts in Seoul (Gangnam Station, Myeongdong, Jamsil, Jongno, Yeouido, Hongdae and a few more). The interface is in Korean.&lt;/p&gt;

&lt;p&gt;Try it: &lt;a href="https://street-trade-area-analysis.vercel.app/?utm_source=web_devto&amp;amp;utm_medium=post&amp;amp;utm_campaign=poc1" rel="noopener noreferrer"&gt;https://street-trade-area-analysis.vercel.app/?utm_source=web_devto&amp;amp;utm_medium=post&amp;amp;utm_campaign=poc1&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  The three hypotheses I started from
&lt;/h2&gt;

&lt;p&gt;I haven't validated these yet. I'm publishing the tool to find out if they hold.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;People scouting a location scroll a map app, count shops one by one, and note the category, floor and opening date separately.&lt;/li&gt;
&lt;li&gt;Existing commercial-area tools report statistics per administrative district or area, so the difference between two neighboring streets is hard to see.&lt;/li&gt;
&lt;li&gt;The number people care about most, "how much does the shop next door sell?", means digging through scattered sources, and the basis for any figure is unclear.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What it does now
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;For a pin, it lists the shops within 100–300 m along the road (name, category, floor, distance along the road) and counts shops by category.&lt;/li&gt;
&lt;li&gt;Because it works on the stretch of road around a pin instead of a whole district, you can drag the pin and compare neighboring spots directly.&lt;/li&gt;
&lt;li&gt;It shows an estimated monthly sales figure per shop, based on the average for the same category and area, with the calculation basis shown.&lt;/li&gt;
&lt;li&gt;You can download the result as CSV.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Data: Seoul Commercial Area Analysis Service (estimated sales), Small Enterprise and Market Service shop data, Seoul permit data, road data © OpenStreetMap contributors, map by Kakao Map.&lt;/p&gt;

&lt;h2&gt;
  
  
  How it works
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Stack: a single Next.js (App Router, TypeScript) app. The data is precomputed into a read-only SQLite database (better-sqlite3), and the geometry uses turf.js: the pin is snapped to the nearest road line, a stretch of road around it is cut out (100–300 m), and the shops that front that stretch are listed.&lt;/li&gt;
&lt;li&gt;Estimated monthly sales: the Seoul Commercial Area Analysis Service publishes estimated sales per commercial area and industry. They are derived from card payment amounts divided by a correction ratio (see the service's own notes). For each shop I take its area and industry (mapped from the small-business registry's category) and compute: area-industry sales total ÷ number of months ÷ number of shops in that area and industry. Every shop in the same area and industry therefore gets the same number.&lt;/li&gt;
&lt;li&gt;If a shop isn't inside a commercial area, or the area has no data for its industry, it falls back to the administrative-district average and the UI labels it as such. If there's no data, it shows "cannot estimate" instead of a number.&lt;/li&gt;
&lt;li&gt;Floor, shop size and brand are not factored in, and the calculation is shown in the detail panel so you can redo it by hand.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What I haven't done, and the limits
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;The sales figures are averages, not actual sales. I haven't checked how well they match real sales yet.&lt;/li&gt;
&lt;li&gt;A shop is matched to a commercial area by approximate distance from the area's center, so the match at the edge of an area can be off.&lt;/li&gt;
&lt;li&gt;Only the main commercial districts in Seoul are covered.&lt;/li&gt;
&lt;li&gt;It opens on mobile, but the table is wider than the screen, so a desktop browser is recommended.&lt;/li&gt;
&lt;li&gt;Usage events (page views, clicks, UTM referrer) are collected for analysis; details are in the privacy policy: &lt;a href="https://street-trade-area-analysis.vercel.app/privacy" rel="noopener noreferrer"&gt;https://street-trade-area-analysis.vercel.app/privacy&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Feedback I'd like
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Is the pin-and-drag flow clear?&lt;/li&gt;
&lt;li&gt;Do the shop list and the estimates help when comparing spots?&lt;/li&gt;
&lt;li&gt;What's missing?&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Comments are welcome.&lt;/p&gt;

</description>
      <category>showdev</category>
      <category>webdev</category>
    </item>
  </channel>
</rss>
