\u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8<\/title>\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1\" \/>\n<style>\n :root{--bg:#0ea5e9;}\n body{font-family:system-ui,-apple-system,\"Segoe UI\",Roboto,\"Noto Sans JP\",sans-serif;line-height:1.85;color:#222;margin:0}\n header{background:linear-gradient(135deg,#0284c7,var(--bg));color:#fff;padding:24px 20px}\n main{padding:28px;max-width:1080px;margin:auto}\n h1{font-size:1.8rem;margin:0}\n h2{margin-top:2.0em;font-size:1.35rem}\n h3{margin-top:1.1em;font-size:1.1rem}\n p.lead{background:#f0f9ff;border-left:4px solid var(--bg);padding:12px 16px;border-radius:6px}\n code,kbd,pre{font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace}\n pre{background:#0b10221a;border:1px solid #e5e7eb;border-radius:8px;padding:12px;overflow:auto}\n .grid{display:grid;gap:12px}\n .cols-2{grid-template-columns:repeat(auto-fit,minmax(280px,1fr))}\n .tag{display:inline-block;background:#eef2ff;border-radius:999px;padding:2px 10px;margin-right:6px;font-size:.85rem}\n .box{background:#fafafa;border:1px solid #eee;border-radius:10px;padding:12px 14px}\n .table{border-collapse:collapse;width:100%}\n .table td,.table th{border:1px solid #e5e7eb;padding:8px 10px;text-align:left;vertical-align:top}\n .muted{color:#555}\n .ok{color:#0a7f2e;font-weight:600}\n .warn{background:#fff7ed;border-left:4px solid #fb923c;padding:10px;border-radius:6px}\n .small{font-size:.92rem;color:#555}\n .glossary{font-size:.98rem}\n .glossary .table th{white-space:nowrap}\n<\/style>\n<\/head>\n<body>\n<header>\n <h1>\u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8\uff08\u30a2\u30a4\u30c7\u30a2\u30e1\u30e2\u3000\u30d1\u30fc\u30c82\uff09<\/h1>\n <p class=\"small\">\u4e3b\u5f79\u306f\u30c7\u30fc\u30bf\u53ce\u96c6\u3068\u5229\u6d3b\u7528\u3002AI\u306f\u6574\u7406\u30fb\u533f\u540d\u5316\u30fb\u63a8\u8a08\u306e\u9ed2\u5b50\u3002\u307c\u304b\u3057\u306f\u9854\/\u30ca\u30f3\u30d0\u30fc\u3067\u306f\u306a\u304f<strong>\u8eca\u4f53\u307e\u308b\u3054\u3068<\/strong>\u3002\u751f\u30c7\u30fc\u30bf\u306f<strong>\u7ba1\u7406\u56e3\u4f53\u306e\u307f<\/strong>\u3002<\/p>\n<\/header>\n<main>\n\n<p class=\"lead\">\u672c\u7a3f\u306f\u300c\u3044\u307e\u3059\u3050\u4f5c\u308a\u59cb\u3081\u3089\u308c\u308b\u300d\u3053\u3068\u3092\u6700\u512a\u5148\u306b\u3001Web\uff0bWeb\u30a2\u30d7\u30ea\u524d\u63d0\u3067\u306e\u6700\u5c0f\u69cb\u6210\u3001DB\uff08\u30de\u30b9\u30bf\/\u696d\u52d9\/\u76e3\u67fb\uff09\u3001API\u3001\u975e\u540c\u671f\u30bf\u30b9\u30af\u3001\u91cd\u3044\u6f14\u7b97\u3092\u5207\u308a\u96e2\u3057\u305f\u201cAI API\/\u30ef\u30fc\u30ab\u30fc\u201d\u306e\u5f62\u3092\u4e00\u6c17\u306b\u793a\u3057\u307e\u3059\u3002\u96e3\u3057\u3044\u3068\u3053\u308d\u306f\u5f8c\u56de\u3057\u3001\u3067\u3082\u7a74\u306f\u958b\u3051\u306a\u3044\u3002\u76f4\u7403\u3067\u3044\u304d\u307e\u3059\u3002<\/p>\n\n<h2>1. \u5168\u4f53\u89b3\uff08\u6700\u5c0f\u3067\u3082\u56de\u308b\u69cb\u6210\uff09<\/h2>\n<div class=\"box\">\n <div class=\"tag\">\u30d5\u30ed\u30f3\u30c8<\/div><div class=\"tag\">API<\/div><div class=\"tag\">DB\/PostGIS<\/div><div class=\"tag\">S3(anon\/raw)<\/div><div class=\"tag\">Queue<\/div><div class=\"tag\">AI\u30ef\u30fc\u30ab\u30fc<\/div><div class=\"tag\">\u5b9a\u70b9\u30ab\u30e1\u30e9<\/div>\n <pre>\n[\u5229\u7528\u8005PWA\/\u30d6\u30e9\u30a6\u30b6] \u2500\u2500\u2500 HTTPS \u2500\u2500\u2500> [API Gateway\/ALB \u2192 Web API(FastAPI)]\n \u2502 \u2502\n \u2502(\u4e8b\u524d\u7f72\u540dURL\u3067\u76f4UP) \u2502SQL(PostGIS)\n \u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500> [S3 anon\/] \u251c\u2500\u2500\u2500\u2500> [Aurora PG + PostGIS]\n \u2502 \u2502\n \u2502 \u2514\u2500\u2500\u2500\u2500> [SQS] \u2192 [AI\u30ef\u30fc\u30ab\u30fc\u7fa4(\u5185\u90e8API)]\n \u2502 \u251c\u2500 anonymize_vehicle\uff08\u8eca\u4f53\u307c\u304b\u3057\uff09\n \u2502 \u251c\u2500 classify\uff08\u30ab\u30c6\u30b4\u30ea\u63a8\u5b9a\/NG\u691c\u77e5\uff09\n \u2502 \u251c\u2500 dedupe\uff08\u91cd\u8907\u30af\u30e9\u30b9\u30bf\uff09\n \u2502 \u2514\u2500 traffic_aggregate\uff08\u5229\u7528\u7387\u96c6\u8a08\uff09\n[\u5b9a\u70b9\u30ab\u30e1\u30e9\/\u30a8\u30c3\u30b8] \u2500\u2500(\u533f\u540d\u5316\/\u30ab\u30a6\u30f3\u30c8\u6e08\u307f\u30e1\u30bf)\u2500\u2500> [API \/devices\/{id}\/events]\n <\/pre>\n <p class=\"muted\">\u30dd\u30a4\u30f3\u30c8\uff1a\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306f\u533f\u540d\u5316\u5074 <code>S3 anon\/<\/code> \u3092\u30c7\u30d5\u30a9\u3002<code>S3 raw\/<\/code> \u306f\u539f\u5247\u4f7f\u308f\u305a\u3001\u7ba1\u7406\u56e3\u4f53\u306e\u660e\u793a\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u6642\u306e\u307f\u3002\u91cd\u3044\u51e6\u7406\u306fSQS\/\u30ef\u30fc\u30ab\u30fc\u3078\u3002<\/p>\n<\/div>\n\n<h2>2. \u521d\u671f\u306b\u7528\u610f\u3059\u308b\u30af\u30e9\u30a6\u30c9\u8981\u7d20\uff08MVP\uff09<\/h2>\n<ul>\n <li><strong>\u9759\u7684\u30d5\u30ed\u30f3\u30c8\uff1a<\/strong> S3 + CDN\uff08PWA\u3001Map\u63cf\u753b\u3001\u30aa\u30d5\u30e9\u30a4\u30f3\u5bfe\u5fdc\uff09<\/li>\n <li><strong>Web API\uff1a<\/strong> FastAPI\uff08Fargate \u304b Functions\/Lambda\uff09<\/li>\n <li><strong>DB\uff1a<\/strong> Aurora PostgreSQL + <strong>PostGIS<\/strong><\/li>\n <li><strong>\u30b9\u30c8\u30ec\u30fc\u30b8\uff1a<\/strong> S3\uff08<code>anon\/<\/code>\uff1d\u307c\u304b\u3057\u6e08\u307f\u516c\u958b\u7528\u3001<code>raw\/<\/code>\uff1d\u7ba1\u7406\u56e3\u4f53\u9650\u5b9a\uff09<\/li>\n <li><strong>\u30ad\u30e5\u30fc\uff1a<\/strong> SQS\uff08ingest\/anonymize\/classify\/dedupe\/traffic_aggregate\uff09<\/li>\n <li><strong>\u8a8d\u8a3c\uff1a<\/strong> Cognito\/OIDC\uff08LINE\u30ed\u30b0\u30a4\u30f3\u4f75\u7528\u53ef\uff09<\/li>\n <li><strong>\u76e3\u8996\uff1a<\/strong> CloudWatch + APM\uff08\u4f8b\uff1aOpenTelemetry\uff09<\/li>\n<\/ul>\n\n<h2>3. \u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\uff08\u6700\u5c0f\u30bb\u30c3\u30c8\uff09<\/h2>\n<div class=\"grid cols-2\">\n <div class=\"box\">\n <h3>\u30de\u30b9\u30bf<\/h3>\n <ul>\n <li><code>organizations<\/code>\uff1a\u81ea\u6cbb\u4f53\/\u56e3\u4f53<\/li>\n <li><code>categories<\/code>\uff1a\u901a\u5831\u30ab\u30c6\u30b4\u30ea\uff0810\u500b\u7a0b\u5ea6\u306b\u7d5e\u308b\uff09<\/li>\n <li><code>areas<\/code>\uff1a\u62c5\u5f53\u30a8\u30ea\u30a2\uff08MultiPolygon\uff09<\/li>\n <li><code>road_links<\/code>\uff1a\u9053\u8def\u30ea\u30f3\u30af\uff08LineString\uff09<\/li>\n <\/ul>\n <\/div>\n <div class=\"box\">\n <h3>\u696d\u52d9<\/h3>\n <ul>\n <li><code>reports<\/code>\uff1a\u901a\u5831\uff08Point, status, attributes\uff09<\/li>\n <li><code>report_media<\/code>\uff1a\u753b\u50cf\/\u52d5\u753b\uff08<code>anon\/<\/code>, <code>raw\/<\/code>\u9375\uff09<\/li>\n <li><code>report_status_history<\/code>\uff1a\u9032\u6357\u5c65\u6b74<\/li>\n <li><code>devices<\/code>\uff1a\u5b9a\u70b9\u30ab\u30e1\u30e9\/\u30a8\u30c3\u30b8<\/li>\n <li><code>camera_events<\/code>\uff1a\u30ab\u30a6\u30f3\u30c8\u7d50\u679c\uff08\u8eca\/\u4eba\uff09<\/li>\n <li><code>traffic_agg_hourly<\/code>\uff1a\u9053\u8def\u5229\u7528\u7387\uff08\u30ea\u30f3\u30af\u00d7\u6642\u523b\uff09<\/li>\n <\/ul>\n <\/div>\n<\/div>\n<pre>\n-- \u4f4d\u7f6e\u306fPostGIS\u3002\u516c\u958b\u6642\u306f\u4e38\u3081\u308b\uff08\u4f8b\uff1a50m\u683c\u5b50\uff09\nCREATE TABLE core.reports(\n id UUID PRIMARY KEY,\n org_id UUID NOT NULL,\n user_id UUID NULL,\n category_id INT NOT NULL,\n title TEXT, body TEXT,\n status TEXT CHECK(status IN ('received','triaged','in_progress','resolved','rejected')) DEFAULT 'received',\n location geometry(Point,4326),\n location_precision_m INT DEFAULT 50,\n attributes JSONB DEFAULT '{}'::jsonb,\n dedupe_group_id UUID,\n created_at timestamptz DEFAULT now(), updated_at timestamptz DEFAULT now()\n);\nCREATE INDEX ON core.reports USING GIST(location);\n<\/pre>\n\n<h2>4. API\uff08\u516c\u958bREST\uff09<\/h2>\n<table class=\"table\">\n <thead><tr><th>\u30e1\u30bd\u30c3\u30c9<\/th><th>\u30d1\u30b9<\/th><th>\u6982\u8981<\/th><\/tr><\/thead>\n <tbody>\n <tr><td>GET<\/td><td>\/api\/v1\/master\/categories<\/td><td>\u30ab\u30c6\u30b4\u30ea\u4e00\u89a7<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/reports<\/td><td>\u901a\u5831\u4f5c\u6210\uff08\u30e1\u30bf\u767b\u9332\u2192S3\u4e8b\u524d\u7f72\u540d\u8fd4\u5374\uff09<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/media\/presign<\/td><td>S3\u4e8b\u524d\u7f72\u540d\u306e\u767a\u884c<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/media\/confirm<\/td><td>\u30a2\u30c3\u30d7\u5b8c\u4e86\u901a\u77e5\u2192<strong>anonymize_vehicle<\/strong>\u6295\u5165<\/td><\/tr>\n <tr><td>GET<\/td><td>\/api\/v1\/reports?bbox&status<\/td><td>\u5730\u56f3\u7528\u30ea\u30b9\u30c8\uff08\u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0\u6e08\u307f\uff09<\/td><\/tr>\n <tr><td>PATCH<\/td><td>\/api\/v1\/reports\/{id}\/status<\/td><td>\u9032\u6357\u5909\u66f4\uff08operator\u4ee5\u4e0a\uff09<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/devices\/{id}\/events<\/td><td>\u5b9a\u70b9\u306e\u96c6\u8a08\u30e1\u30bf\u6295\u5165\uff08\u533f\u540d\u5316\u6e08\u307f\u8a08\u6570\uff09<\/td><\/tr>\n <tr><td>GET<\/td><td>\/api\/v1\/traffic\/links\/{id}\/hourly<\/td><td>\u9053\u8def\u5229\u7528\u7387\uff08\u6642\u7cfb\u5217\uff09<\/td><\/tr>\n <\/tbody>\n<\/table>\n\n<h3>\u4f8b\uff1a\u901a\u5831\u767b\u9332\u2192\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/h3>\n<pre>\n\/\/ 1) \u30e1\u30bf\u767b\u9332\nPOST \/api\/v1\/reports\n{\n \"category_code\": \"road_damage\",\n \"title\": \"\u8217\u88c5\u306e\u7a74\",\n \"body\": \"\u591c\u9593\u306b\u5371\u306a\u3044\",\n \"event_time\": \"2025-09-14T09:30:00+09:00\",\n \"location\": {\"lat\": 35.68, \"lng\": 139.76, \"precision_m\": 50},\n \"media\": [{\"kind\":\"image\",\"presign\":true}]\n}\n\n\/\/ 2) \u30ec\u30b9\u30dd\u30f3\u30b9\uff08S3 anon\/ \u3078\u306e\u4e8b\u524d\u7f72\u540d\uff09\n{\n \"report_id\": \"d1c7-...\",\n \"uploads\": [\n {\"media_id\":\"m-1\",\"url\":\"https:\/\/s3\/anon\/...\",\"fields\":{\"key\":\"anon\/..\",\"policy\":\"..\"}}\n ]\n}\n\n\/\/ 3) \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304cS3\u3078\u76f4\u63a5PUT\u3057\u305f\u5f8c\nPOST \/api\/v1\/media\/confirm\n{ \"media_id\": \"m-1\", \"sha256\":\"abc...\", \"raw_requested\": false }\n<\/pre>\n\n<h2>5. \u201c\u96e3\u3057\u3044\u6f14\u7b97\u90e8\u201d\u306fAPI\/\u30ef\u30fc\u30ab\u30fc\u306b\u5207\u308a\u96e2\u3059<\/h2>\n<p class=\"warn\"><strong>\u539f\u5247\uff1a<\/strong> \u30d5\u30ed\u30f3\u30c8\u3068Web API\u306f\u8584\u304f\u3002\u91cd\u3044\u51e6\u7406\uff08\u753b\u50cf\u51e6\u7406\u30fb\u985e\u4f3c\u691c\u7d22\u30fb\u6642\u7cfb\u5217\u96c6\u8a08\uff09\u306f\u30ad\u30e5\u30fc\u7d4c\u7531\u3067\u30ef\u30fc\u30ab\u30fc\u304c\u5b9f\u65bd\u3002Web API\u306f\u7d50\u679c\u3060\u3051\u3092\u898b\u308b\u3002<\/p>\n\n<div class=\"grid cols-2\">\n <div class=\"box\">\n <h3>(A) \u5185\u90e8API\uff08\u30b5\u30fc\u30d3\u30b9\u9593\uff09<\/h3>\n <ul>\n <li><code>POST \/_internal\/anonymize\/vehicle<\/code>\uff1a\u8eca\u4f53\u307e\u308b\u3054\u3068\u307c\u304b\u3057<\/li>\n <li><code>POST \/_internal\/classify<\/code>\uff1a\u30ab\u30c6\u30b4\u30ea\u63a8\u5b9a\u30fbNG\u5224\u5b9a<\/li>\n <li><code>POST \/_internal\/dedupe<\/code>\uff1a\u91cd\u8907\u30af\u30e9\u30b9\u30bf\u66f4\u65b0<\/li>\n <li><code>POST \/_internal\/traffic\/aggregate<\/code>\uff1a\u9053\u8def\u5229\u7528\u7387\u96c6\u8a08<\/li>\n <\/ul>\n <p class=\"muted\">VPC\u5185\/\u8a8d\u8a3c\u5fc5\u9808\u3002\u5916\u90e8\u304b\u3089\u30a2\u30af\u30bb\u30b9\u4e0d\u53ef\u3002<\/p>\n <\/div>\n <div class=\"box\">\n <h3>(B) \u30ef\u30fc\u30ab\u30fc\uff08\u64ec\u4f3c\u30b3\u30fc\u30c9\/Python\uff09<\/h3>\n <pre>\n@app.task(name=\"anonymize_vehicle\")\ndef anonymize_vehicle(media_id: str):\n media = db.get_media(media_id)\n img = load_from_s3(media.s3_key) # \u307c\u304b\u3057\u306f\u8eca\u4f53\u5168\u4f53\n boxes = detect_vehicles(img) # car\/bus\/truck\/bike...\n img2 = mosaic_outside_safe_margin(img, boxes)\n save_to_s3(img2, media.s3_key) # anon\/ \u306b\u4e0a\u66f8\u304d\u4fdd\u5b58\n enqueue(\"classify\", {\"report_id\": media.report_id})\n <\/pre>\n <\/div>\n<\/div>\n\n<h3>\u91cd\u8907\u30af\u30e9\u30b9\u30bf\uff08dedupe\uff09\u30a4\u30e1\u30fc\u30b8<\/h3>\n<pre>\ndef recompute_cluster(report_id):\n r = db.reports[report_id]\n candidates = search_nearby(\n point=r.location, radius_m=120,\n time_window=\"\u00b124h\",\n text_embed=r.attributes['text_embed'])\n cluster_id = union_find_by_similarity(candidates + [r])\n db.update(report_id, dedupe_group_id=cluster_id)\n<\/pre>\n\n<h3>\u9053\u8def\u5229\u7528\u7387\uff08\u5b9a\u70b9\u30ab\u30e1\u30e9\u2192\u30ea\u30f3\u30af\u96c6\u8a08\uff09<\/h3>\n<pre>\nPOST \/api\/v1\/devices\/{id}\/events\n{\n \"captured_at\": \"2025-09-14T00:00:00Z\",\n \"counters\": {\"vehicle\": 86, \"pedestrian\": 240},\n \"link_id\": 10234\n}\n\n# \u96c6\u8a08\u30b8\u30e7\u30d6(hourly)\nINSERT INTO traffic_agg_hourly(link_id,hour,vehicle_cnt,ped_cnt)\nVALUES(...) ON CONFLICT (...) DO UPDATE ...\n<\/pre>\n\n<h2>6. \u30d5\u30ed\u30f3\u30c8\uff08PWA\/Map\uff09\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8<\/h2>\n<div class=\"grid cols-2\">\n <div>\n <h3>\u753b\u9762<\/h3>\n <ul>\n <li>\u30db\u30fc\u30e0\uff1a\u5730\u56f3\uff0b\u9032\u6357\u30d5\u30a3\u30eb\u30bf\uff08<span class=\"ok\">\u30af\u30e9\u30b9\u30bf\u8868\u793a<\/span>\uff09<\/li>\n <li>\u65b0\u898f\u901a\u5831\uff1a\u64ae\u308b\u2192\u4f4d\u7f6e\u2192\u9001\u308b\uff083\u30bf\u30c3\u30d7\uff09<\/li>\n <li>\u8a73\u7d30\uff1a\u5199\u771f\uff08<em>\u307c\u304b\u3057\u6e08\u307f<\/em>\uff09\u3001\u9032\u6357\u3001\u985e\u4f3c\u5831\u544a<\/li>\n <li>\u30de\u30a4\u30da\u30fc\u30b8\uff1a\u30dd\u30a4\u30f3\u30c8\u3001\u5c65\u6b74<\/li>\n <li>\u904b\u7528\uff1a\u91cd\u8907\u675f\u306d\u3001\u512a\u5148\u5ea6\u30ad\u30e5\u30fc\u3001\u9053\u8def\u5229\u7528\u7387\u30b0\u30e9\u30d5<\/li>\n <\/ul>\n <\/div>\n <div>\n <h3>\u30b3\u30fc\u30c9\uff08\u8d85\u8981\u70b9\uff09<\/h3>\n <pre>\n\/\/ \u4f4d\u7f6e\u4e38\u3081\u306f\u30b5\u30fc\u30d0\u5074\u3002\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306f\u7d30\u304b\u3044\u3053\u3068\u3057\u306a\u3044\u3002\nasync function createReport(meta){\n const r = await fetch('\/api\/v1\/reports',{method:'POST',\n headers:{'Content-Type':'application\/json'},\n body: JSON.stringify(meta)});\n const {uploads} = await r.json();\n \/\/ presigned URL\u306b\u76f4PUT\n await fetch(uploads[0].url,{method:'PUT',body: selectedFile});\n await fetch('\/api\/v1\/media\/confirm',{method:'POST',\n headers:{'Content-Type':'application\/json'},\n body: JSON.stringify({media_id: uploads[0].media_id, sha256: fileHash})});\n}\n <\/pre>\n <\/div>\n<\/div>\n<p class=\"muted\">\u5730\u56f3\u306f MapLibre GL \u7b49\u3002\u30a2\u30af\u30bb\u30b7\u30d3\u30ea\u30c6\u30a3\u306e\u305f\u3081\u30dc\u30bf\u30f3\u306f\u5927\u304d\u304f\u3001\u97f3\u58f0\u5165\u529b\u3082\u8a31\u5bb9\u3002\u30aa\u30d5\u30e9\u30a4\u30f3\u6642\u306fService Worker\u3067\u4e0b\u66f8\u304d\u4fdd\u5b58\u2192\u5fa9\u5e30\u6642\u306b\u9001\u4fe1\u3002<\/p>\n\n<h2>7. \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\/\u30d7\u30e9\u30a4\u30d0\u30b7\u904b\u7528\u306e\u809d<\/h2>\n<ul>\n <li><strong>\u307c\u304b\u3057\u539f\u5247\uff1a<\/strong> \u9854\/\u30ca\u30f3\u30d0\u30fc\u5358\u4f53\u3067\u306f\u306a\u304f<strong>\u8eca\u4f53\u307e\u308b\u3054\u3068<\/strong>\u3002\u8aa4\u691c\u77e5\u3092\u907f\u3051\u308b\u3002<\/li>\n <li><strong>raw\u306e\u7ba1\u7406\uff1a<\/strong> \u539f\u5247\u4f7f\u308f\u306a\u3044\u3002\u5fc5\u8981\u6642\u306e\u307f\u7ba1\u7406\u56e3\u4f53\u306e\u627f\u8a8d\u4ed8\u304d\u3067\u4fdd\u7ba1\/\u95b2\u89a7\u3002\u30a2\u30af\u30bb\u30b9\u306f\u76e3\u67fb\u30ed\u30b0\u5fc5\u9808\u3002<\/li>\n <li><strong>\u516c\u958b\u30c7\u30fc\u30bf\uff1a<\/strong> \u5ea7\u6a19\u306f\u4e38\u3081\uff08\u4f8b\uff1a50m\uff09\u3001\u671f\u9593\u9650\u5b9a\u3001\u518d\u8b58\u5225\u30c1\u30a7\u30c3\u30af\u3002<\/li>\n <li><strong>RBAC\uff1a<\/strong> resident \/ moderator \/ operator \/ admin \u3092\u5206\u96e2\u3002<\/li>\n <li><strong>\u30ec\u30fc\u30c8\u5236\u5fa1\/WAF\uff1a<\/strong> \u8352\u3089\u3057\u5bfe\u7b56\u306f\u30d5\u30ed\u30f3\u30c8\u3067\u306f\u306a\u304f\u30b2\u30fc\u30c8\u3067\u6b62\u3081\u308b\u3002<\/li>\n<\/ul>\n\n<h2>8. \u904b\u7528KPI\uff08MVP\u3067\u898b\u308b\u6570\u5b57\uff09<\/h2>\n<ul>\n <li>\u91cd\u8907\u7d71\u5408\u7387\uff08dedupe\u6210\u529f\u7387\uff09<\/li>\n <li>\u533f\u540d\u5316\u6210\u529f\u7387\uff08\u8eca\u4f53\u307c\u304b\u3057\u6f0f\u308c0\u3092\u76ee\u6a19\uff09<\/li>\n <li>\u53d7\u4ed8\u2192\u73fe\u5730\u78ba\u8a8d\u30ea\u30fc\u30c9\u30bf\u30a4\u30e0<\/li>\n <li>\u9053\u8def\u30ea\u30f3\u30af\u00d7\u6642\u9593\u306e\u30ab\u30d0\u30ec\u30c3\u30b8\u7387<\/li>\n <li>\u521d\u56de\u2192\u7fcc\u6708\u7d99\u7d9a\u7387\uff08\u30dd\u30a4\u30f3\u30c8\u4f9d\u5b58\u5ea6\u306f\u4f4e\u304f\uff09<\/li>\n<\/ul>\n\n<h2>9. \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3068\u8a2d\u5b9a\u4f8b<\/h2>\n<pre>\nrepo\/\n\u251c\u2500 frontend\/ # Next.js PWA\n\u251c\u2500 api\/ # FastAPI (REST)\n\u2502 \u251c\u2500 routes\/ # reports, media, devices...\n\u2502 \u251c\u2500 services\/ # db, s3, presign, auth\n\u2502 \u2514\u2500 schemas\/ # pydantic\n\u251c\u2500 workers\/ # AI\u30ef\u30fc\u30ab\u30fc\uff08anonymize\/classify\/dedupe\/aggregate\uff09\n\u2502 \u2514\u2500 tasks\/\n\u251c\u2500 infra\/ # IaC(Terraform) \/ pipelines\n\u2514\u2500 docs\/\n<\/pre>\n<pre>\n# .env\uff08\u4f8b\uff1aAPI\uff09\nDATABASE_URL=postgresql+psycopg2:\/\/...\nS3_BUCKET=city-app-bucket\nANON_PREFIX=anon\/\nRAW_PREFIX=raw\/\nQUEUE_URL_ANONYMIZE=...\nJWT_AUDIENCE=...\n<\/pre>\n\n<h2>10. \u30d5\u30a7\u30fc\u30ba2\u3067\u8db3\u3059\u3082\u306e\uff08\u5fc5\u8981\u306b\u306a\u3063\u305f\u3089\uff09<\/h2>\n<ul>\n <li>GraphQL\uff08AppSync\u7b49\uff09\u3067\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u66f4\u65b0<\/li>\n <li>OpenSearch\u3067\u5168\u6587\/\u985e\u4f3c\u691c\u7d22<\/li>\n <li>Step Functions\u3067\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u306e\u53ef\u8996\u5316\uff08\u5931\u6557\u6642\u306e\u518d\u8a66\u884c\/DLQ\uff09<\/li>\n <li>\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\uff08QuickSight\/Looker Studio\uff09<\/li>\n <li>Open311\u4e92\u63dbAPI\u516c\u958b\u3001\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u81ea\u52d5\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/li>\n<\/ul>\n\n<hr \/>\n\n<h2>11. \u7528\u8a9e\u8aac\u660e\u96c6\uff08\u81ea\u6cbb\u4f53\u62c5\u5f53\u8005\u5411\u3051\u30fb\u6a2a\u6587\u5b57\u3092\u565b\u307f\u7815\u304f\uff09<\/h2>\n<p class=\"muted\">\u6280\u8853\u7528\u8a9e\u3092\u300c\u8981\u306f\u3069\u3046\u3044\u3046\u3053\u3068\uff1f\u300d\u306b\u8a00\u3044\u63db\u3048\u307e\u3057\u305f\u3002\u4f1a\u8b70\u3067\u51fa\u3066\u304d\u305f\u3089\u3001\u3053\u306e\u8868\u3092\u305d\u306e\u307e\u307e\u4f7f\u3063\u3066OK\u3067\u3059\u3002<\/p>\n<table class=\"table glossary\">\n <thead><tr><th>\u7528\u8a9e<\/th><th>\u610f\u5473\uff08\u304b\u3093\u305f\u3093\uff09<\/th><th>\u5f79\u5272\u30fb\u305f\u3068\u3048<\/th><\/tr><\/thead>\n <tbody>\n <tr><td>Web\u30a2\u30d7\u30ea \/ PWA<\/td><td>\u30d6\u30e9\u30a6\u30b6\u3067\u52d5\u304f\u30a2\u30d7\u30ea\u3002\u30db\u30fc\u30e0\u753b\u9762\u306b\u5165\u308c\u3089\u308c\u3001\u96fb\u6ce2\u304c\u5f31\u304f\u3066\u3082\u4e00\u90e8\u52d5\u304f\u3002<\/td><td>\u300c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3044\u3089\u305a\u306e\u30a2\u30d7\u30ea\u300d\u3002<\/td><\/tr>\n <tr><td>CDN<\/td><td>\u5168\u56fd\u306b\u3042\u308b\u4e2d\u7d99\u6240\u304b\u3089\u8fd1\u5834\u3067\u914d\u308b\u4ed5\u7d44\u307f\u3002<\/td><td>\u914d\u9054\u62e0\u70b9\u304c\u591a\u3044\u5b85\u914d\u4fbf\u3002<\/td><\/tr>\n <tr><td>S3<\/td><td>\u753b\u50cf\u3084\u52d5\u753b\u3092\u7f6e\u304f\u5927\u304d\u306a\u5009\u5eab\u3002<\/td><td>\u300canon = \u307c\u304b\u3057\u6e08\u307f\u68da\u300d\u300craw = \u751f\u30c7\u30fc\u30bf\u68da\u300d\u3002<\/td><\/tr>\n <tr><td>\u4e8b\u524d\u7f72\u540dURL\uff08Presigned URL\uff09<\/td><td>\u4e00\u6642\u7684\u306b\u5009\u5eab\u3078\u76f4\u63a5\u30a2\u30c3\u30d7\u3067\u304d\u308b\u5408\u9375\u3002<\/td><td>\u671f\u9650\u3064\u304d\u306e\u642c\u5165\u53e3\u30d1\u30b9\u3002<\/td><\/tr>\n <tr><td>API<\/td><td>\u30a2\u30d7\u30ea\u540c\u58eb\u306e\u53d7\u3051\u53e3\uff08\u3084\u308a\u53d6\u308a\u306e\u6c7a\u307e\u308a\uff09\u3002<\/td><td>\u5f79\u6240\u306e\u300c\u7a93\u53e3\u306e\u69d8\u5f0f\u300d\u3002<\/td><\/tr>\n <tr><td>FastAPI \/ NestJS<\/td><td>API\u3092\u4f5c\u308b\u305f\u3081\u306e\u9053\u5177\u3002<\/td><td>\u7a93\u53e3\u306e\u4ed5\u5207\u308a\u3084\u5e33\u7968\u3092\u4f5c\u308b\u30c4\u30fc\u30eb\u3002<\/td><\/tr>\n <tr><td>ALB \/ API Gateway<\/td><td>\u5916\u304b\u3089\u306e\u901a\u4fe1\u306e\u7384\u95a2\u3002<\/td><td>\u6b63\u9762\u30ed\u30d3\u30fc\u306e\u53d7\u4ed8\u3002<\/td><\/tr>\n <tr><td>ECS Fargate<\/td><td>\u30b5\u30fc\u30d0\u7ba1\u7406\u306a\u3057\u3067\u30a2\u30d7\u30ea\u3092\u52d5\u304b\u3059\u53f0\u3002<\/td><td>\u300c\u30ec\u30f3\u30bf\u30ab\u30fc\u3001\u71c3\u6599\u88dc\u7d66\u3082\u81ea\u52d5\u300d\u3002<\/td><\/tr>\n <tr><td>Lambda<\/td><td>\u547c\u3070\u308c\u305f\u3068\u304d\u3060\u3051\u52d5\u304f\u5c0f\u30d7\u30ed\u30b0\u30e9\u30e0\u3002<\/td><td>\u5fc5\u8981\u306a\u6642\u3060\u3051\u547c\u3076\u30bf\u30af\u30b7\u30fc\u3002<\/td><\/tr>\n <tr><td>Aurora PostgreSQL<\/td><td>\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3002<\/td><td>\u53f0\u5e33\u306e\u672c\u4e38\u3002<\/td><\/tr>\n <tr><td>PostGIS<\/td><td>DB\u306b\u5730\u56f3\u306e\u982d\u8133\u3092\u8db3\u3059\u3002<\/td><td>\u70b9\u3084\u9053\u8def\u7dda\u3092\u6271\u3048\u308b\u5730\u56f3\u6a5f\u80fd\u3002<\/td><\/tr>\n <tr><td>OpenSearch<\/td><td>\u5168\u6587\u691c\u7d22\u30fb\u4f3c\u3066\u3044\u308b\u6587\u7ae0\u63a2\u3057\u3002<\/td><td>\u56f3\u66f8\u9928\u306e\u53f8\u66f8\uff0b\u30ec\u30b3\u30e1\u30f3\u30c9\u3002<\/td><\/tr>\n <tr><td>Redis<\/td><td>\u8d85\u901f\u3044\u4e00\u6642\u7f6e\u304d\u5834\u3002<\/td><td>\u53d7\u4ed8\u306e\u624b\u5143\u30e1\u30e2\u3002<\/td><\/tr>\n <tr><td>SQS\uff08\u30ad\u30e5\u30fc\uff09<\/td><td>\u9806\u756a\u5f85\u3061\u306e\u7bb1\u3002\u91cd\u3044\u51e6\u7406\u306f\u3053\u3053\u306b\u4e26\u3079\u308b\u3002<\/td><td>\u6574\u7406\u5238\u767a\u5238\u6a5f\u3002<\/td><\/tr>\n <tr><td>Step Functions<\/td><td>\u51e6\u7406\u306e\u6d41\u308c\u56f3\u3092\u305d\u306e\u307e\u307e\u6a5f\u68b0\u306b\u5b9f\u884c\u3055\u305b\u308b\u3002<\/td><td>\u696d\u52d9\u30d5\u30ed\u30fc\u306e\u6a19\u6e96\u5316\u3002<\/td><\/tr>\n <tr><td>AppSync \/ WebSocket<\/td><td>\u753b\u9762\u3092\u81ea\u52d5\u66f4\u65b0\u3059\u308b\u4ed5\u7d44\u307f\u3002<\/td><td>\u96fb\u5149\u63b2\u793a\u677f\u304c\u52dd\u624b\u306b\u66f4\u65b0\u3002<\/td><\/tr>\n <tr><td>Cognito \/ OIDC<\/td><td>\u30ed\u30b0\u30a4\u30f3\u306e\u4ed5\u7d44\u307f\u3002LINE\u30ed\u30b0\u30a4\u30f3\u3082\u63a5\u7d9a\u53ef\u3002<\/td><td>\u5165\u9928\u8a3c\u306e\u767a\u884c\u30fb\u78ba\u8a8d\u3002<\/td><\/tr>\n <tr><td>RBAC<\/td><td>\u5f79\u5272\u3054\u3068\u306b\u6a29\u9650\u3092\u5206\u3051\u308b\u3002<\/td><td>\u4f4f\u6c11\/\u8077\u54e1\/\u7ba1\u7406\u8005\u3067\u898b\u3048\u308b\u7bc4\u56f2\u304c\u9055\u3046\u3002<\/td><\/tr>\n <tr><td>IAM<\/td><td>\u8ab0\u304c\u4f55\u3092\u3057\u3066\u826f\u3044\u304b\u306e\u8a31\u53ef\u8a3c\u3002<\/td><td>\u5e81\u5185\u306e\u6a29\u9650\u53f0\u5e33\u3002<\/td><\/tr>\n <tr><td>KMS \/ Secrets Manager<\/td><td>\u6697\u53f7\u9375\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u91d1\u5eab\u3002<\/td><td>\u9375\u4ed8\u304d\u30ed\u30c3\u30ab\u30fc\u3002<\/td><\/tr>\n <tr><td>VPC \/ AZ<\/td><td>\u81ea\u5206\u5c02\u7528\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\/\u30c7\u30fc\u30bf\u30bb\u30f3\u30bf\u30fc\u306e\u533a\u753b\u3002<\/td><td>\u5c02\u7528\u30d5\u30ed\u30a2\/\u5225\u9928\u3002<\/td><\/tr>\n <tr><td>VPC Endpoint<\/td><td>\u5009\u5eab\uff08S3\uff09\u3078\u88cf\u53e3\u76f4\u7d50\u3067\u5b89\u5168\u306b\u63a5\u7d9a\u3002<\/td><td>\u8377\u634c\u304d\u5834\u306e\u5c02\u7528\u901a\u8def\u3002<\/td><\/tr>\n <tr><td>CloudWatch \/ X-Ray \/ OpenTelemetry<\/td><td>\u52d5\u4f5c\u72b6\u6cc1\u306e\u898b\u3048\u308b\u5316\u3002<\/td><td>\u76e3\u8996\u30ab\u30e1\u30e9\uff0b\u52d5\u7dda\u306e\u53ef\u8996\u5316\u3002<\/td><\/tr>\n <tr><td>MapLibre GL<\/td><td>\u5730\u56f3\u3092\u753b\u9762\u306b\u63cf\u304f\u9053\u5177\u3002<\/td><td>\u5730\u56f3\u63cf\u753b\u30a8\u30f3\u30b8\u30f3\u3002<\/td><\/tr>\n <tr><td>\u30bf\u30a4\u30eb \/ \u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0<\/td><td>\u5730\u56f3\u3092\u5c0f\u5206\u3051\u306b\u914d\u308b\/\u8fd1\u3044\u30d4\u30f3\u3092\u307e\u3068\u3081\u3066\u8868\u793a\u3002<\/td><td>\u5206\u5272\u914d\u5e03\/\u4eba\u6570\u30ab\u30a6\u30f3\u30c8\u306e\u4e38\u3081\u8868\u793a\u3002<\/td><\/tr>\n <tr><td>bbox<\/td><td>\u4eca\u898b\u3048\u3066\u3044\u308b\u5730\u56f3\u306e\u56db\u89d2\u3044\u7bc4\u56f2\u3002<\/td><td>\u5730\u56f3\u306e\u7a93\u67a0\u3002<\/td><\/tr>\n <tr><td>JSON\/JSONB<\/td><td>\u67d4\u3089\u304b\u3044\u5f62\u5f0f\u306e\u7bb1\u306b\u60c5\u5831\u3092\u5165\u308c\u308b\u3002<\/td><td>\u53ef\u5909\u306e\u8ffd\u8a18\u4e8b\u9805\u30e1\u30e2\u3002<\/td><\/tr>\n <tr><td>GiST \/ GIN\uff08\u7d22\u5f15\uff09<\/td><td>\u5730\u7406\/\u6587\u7ae0\u691c\u7d22\u3092\u901f\u304f\u3059\u308b\u4ed5\u639b\u3051\u3002<\/td><td>\u3057\u304a\u308a\u30fb\u76ee\u6b21\u3002<\/td><\/tr>\n <tr><td>geometry(Point\/LineString)<\/td><td>\u70b9\/\u7dda\u3068\u3057\u3066\u4f4d\u7f6e\u60c5\u5831\u3092\u4fdd\u5b58\u3002<\/td><td>\u5730\u70b9\/\u9053\u8def\u7dda\u3002<\/td><\/tr>\n <tr><td>\u4f4d\u7f6e\u4e38\u3081<\/td><td>50m\u306a\u3069\u5927\u307e\u304b\u306a\u4f4d\u7f6e\u3060\u3051\u516c\u958b\u3002<\/td><td>\u81ea\u5b85\u306e\u771f\u4e0a\u306b\u30d4\u30f3\u3092\u7acb\u3066\u306a\u3044\u3002<\/td><\/tr>\n <tr><td>\u533f\u540d\u5316<\/td><td>\u500b\u4eba\u304c\u7279\u5b9a\u3055\u308c\u306a\u3044\u3088\u3046\u96a0\u3059\u3002<\/td><td>\u753b\u89d2\u30fb\u89e3\u50cf\u5ea6\u30fb\u4f4d\u7f6e\u306e\u914d\u616e\u3002<\/td><\/tr>\n <tr><td>\u8eca\u4f53\u307e\u308b\u3054\u3068\u307c\u304b\u3057<\/td><td>\u9854\/\u30ca\u30f3\u30d0\u30fc\u5358\u4f53\u3088\u308a\u5b89\u5168\u5074\u3067\u96a0\u3059\u3002<\/td><td>\u8aa4\u691c\u77e5\u5bfe\u7b56\u30fb\u518d\u8b58\u5225\u9632\u6b62\u3002<\/td><\/tr>\n <tr><td>\u30a8\u30c3\u30b8\u51e6\u7406<\/td><td>\u30ab\u30e1\u30e9\u5074\u3067\u5148\u306b\u533f\u540d\u5316\u3084\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u9001\u308b\u3002<\/td><td>\u73fe\u5834\u3067\u4e0b\u3054\u3057\u3089\u3048\u3002<\/td><\/tr>\n <tr><td>\u30c7\u30fc\u30bf\u30ec\u30a4\u30af \/ Glue \/ Athena \/ QuickSight<\/td><td>\u5009\u5eab\u306b\u8caf\u3081\u305f\u30c7\u30fc\u30bf\u3092SQL\u3067\u5206\u6790\u30fb\u53ef\u8996\u5316\u3002<\/td><td>\u7d71\u8a08\u5ba4\u3068\u58c1\u4e00\u9762\u306e\u30b0\u30e9\u30d5\u3002<\/td><\/tr>\n <tr><td>Open311<\/td><td>\u901a\u5831\u306e\u6a19\u6e96\u4ed5\u69d8\uff08\u30ab\u30c6\u30b4\u30ea\/\u9032\u6357\uff09\u3002<\/td><td>\u4ed6\u30b7\u30b9\u30c6\u30e0\u3068\u9023\u643a\u3057\u3084\u3059\u3044\u578b\u3002<\/td><\/tr>\n <tr><td>Webhook<\/td><td>\u5916\u90e8\u30b7\u30b9\u30c6\u30e0\u3078\u81ea\u52d5\u3067\u304a\u77e5\u3089\u305b\u3092\u9001\u308b\u3002<\/td><td>\u9023\u7d61\u7968\u306e\u81ea\u52d5FAX\u3002<\/td><\/tr>\n <tr><td>DLQ<\/td><td>\u5931\u6557\u30bf\u30b9\u30af\u306e\u4fdd\u7ba1\u7bb1\u3002<\/td><td>\u8981\u518d\u51e6\u7406\u30c8\u30ec\u30a4\u3002<\/td><\/tr>\n <tr><td>IQR<\/td><td>\u5916\u308c\u5024\uff08\u304a\u304b\u3057\u306a\u6570\uff09\u3092\u898b\u3064\u3051\u308b\u6307\u6a19\u3002<\/td><td>\u7570\u5e38\u691c\u77e5\u306e\u7269\u5dee\u3057\u3002<\/td><\/tr>\n <tr><td>A\/B\u30c6\u30b9\u30c8<\/td><td>2\u6848\u3092\u540c\u6642\u306b\u8a66\u3057\u3066\u826f\u3044\u65b9\u3092\u9078\u3076\u3002<\/td><td>\u6848\u5185\u6587A\u3068B\u3067\u6bd4\u8f03\u3002<\/td><\/tr>\n <tr><td>Embedding\uff08\u57cb\u3081\u8fbc\u307f\uff09<\/td><td>\u6587\u7ae0\u3084\u753b\u50cf\u3092\u6570\u5217\u306b\u5909\u3048\u3066\u4f3c\u3066\u3044\u308b\u5ea6\u5408\u3044\u3092\u898b\u308b\u3002<\/td><td>\u4f3c\u3066\u308b\u5ea6\uff1d\u30b3\u30b5\u30a4\u30f3\u985e\u4f3c\u5ea6\u3002<\/td><\/tr>\n <tr><td>\u91cd\u8907\u691c\u77e5 \/ \u30af\u30e9\u30b9\u30bf<\/td><td>\u4f3c\u305f\u5831\u544a\u3092\u307e\u3068\u3081\u308b\u3002<\/td><td>\u540c\u3058\u7a74\u306e\u5831\u544a\u30921\u675f\u306b\u3002<\/td><\/tr>\n <tr><td>\u30de\u30c3\u30d7\u30de\u30c3\u30c1\u30f3\u30b0 \/ Link ID<\/td><td>\u30ab\u30a6\u30f3\u30c8\u3092\u9053\u8def\u306e\u533a\u9593\u756a\u53f7\u306b\u7d50\u3073\u3064\u3051\u308b\u3002<\/td><td>\u96c6\u8a08\u306e\u3072\u3068\u5358\u4f4d\u3002<\/td><\/tr>\n <\/tbody>\n<\/table>\n\n<h3>\u300c\u3053\u306e\u8a00\u8449\u304c\u51fa\u305f\u3089\u3053\u3046\u7406\u89e3\u300d\u3067OK\uff08\u8d85\u8981\u7d04\uff09<\/h3>\n<ul>\n <li><strong>PWA<\/strong>\uff1d\u30d6\u30e9\u30a6\u30b6\u3067\u52d5\u304f\u30a2\u30d7\u30ea\u3002<\/li>\n <li><strong>API<\/strong>\uff1d\u30b7\u30b9\u30c6\u30e0\u9593\u306e\u7a93\u53e3\u3002<\/li>\n <li><strong>PostGIS<\/strong>\uff1d\u5730\u56f3\u306b\u5f37\u3044DB\u3002<\/li>\n <li><strong>\u30ad\u30e5\u30fc<\/strong>\uff1d\u9806\u756a\u5f85\u3061\u7bb1\uff08\u91cd\u3044\u51e6\u7406\u3092\u5f8c\u3067\uff09\u3002<\/li>\n <li><strong>\u533f\u540d\u5316\/\u307c\u304b\u3057<\/strong>\uff1d\u500b\u4eba\u306b\u7d50\u3073\u3064\u304f\u60c5\u5831\u3092\u96a0\u3059\u3002\u539f\u5247\u306f<strong>\u8eca\u4f53\u307e\u308b\u3054\u3068<\/strong>\u3002<\/li>\n <li><strong>\u30c7\u30fc\u30bf\u30ec\u30a4\u30af<\/strong>\uff1d\u3068\u308a\u3042\u3048\u305a\u8caf\u3081\u3066\u5f8c\u304b\u3089\u5206\u6790\u3002<\/li>\n <li><strong>Open311<\/strong>\uff1d\u901a\u5831\u306e\u5171\u901a\u30eb\u30fc\u30eb\u3002<\/li>\n<\/ul>\n\n<hr \/>\n<p class=\"small\">\n\u307e\u3068\u3081\uff1a\u6a2a\u6587\u5b57\u306f\u591a\u3044\u3067\u3059\u304c\u3001\u8981\u306f\u300c\u30c7\u30fc\u30bf\u3092\u5b89\u5168\u306b\u96c6\u3081\u3001\u898b\u3048\u308b\u5316\u3057\u3001\u6839\u62e0\u3092\u6301\u3063\u3066\u624b\u3092\u6253\u3064\u300d\u305f\u3081\u306e\u9053\u5177\u7acb\u3066\u3067\u3059\u3002<br>\n\u00a9\u682a\u5f0f\u4f1a\u793e\u30d3\u30fc\u30fb\u30ca\u30ec\u30c3\u30b8\u30fb\u30c7\u30b6\u30a4\u30f3\n<\/p>\n\n<\/main>\n<\/body>\n<\/html>\n\n","protected":false},"excerpt":{"rendered":"<p>\u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8 \u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8\uff08\u30a2\u30a4\u30c7\u30a2\u30e1\u30e2\u3000\u30d1\u30fc\u30c82\uff09 […]<\/p>\n","protected":false},"author":1,"featured_media":1652,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","vkExUnit_EyeCatch_disable":"","_veu_custom_css":"","veu_display_promotion_alert":"common","vkexunit_cta_each_option":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-1651","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1"],"aioseo_notices":[],"veu_head_title_object":{"title":"","add_site_title":""},"jetpack_featured_media_url":"https:\/\/beeknowledge.co.jp\/wp-content\/uploads\/2025\/09\/00000.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1651"}],"version-history":[{"count":2,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1651\/revisions"}],"predecessor-version":[{"id":1654,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1651\/revisions\/1654"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/media\/1652"}],"wp:attachment":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

$\"\"$ <\/div>\n\n\n\n\n\u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8<\/title>\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1\" \/>\n<style>\n :root{--bg:#0ea5e9;}\n body{font-family:system-ui,-apple-system,\"Segoe UI\",Roboto,\"Noto Sans JP\",sans-serif;line-height:1.85;color:#222;margin:0}\n header{background:linear-gradient(135deg,#0284c7,var(--bg));color:#fff;padding:24px 20px}\n main{padding:28px;max-width:1080px;margin:auto}\n h1{font-size:1.8rem;margin:0}\n h2{margin-top:2.0em;font-size:1.35rem}\n h3{margin-top:1.1em;font-size:1.1rem}\n p.lead{background:#f0f9ff;border-left:4px solid var(--bg);padding:12px 16px;border-radius:6px}\n code,kbd,pre{font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace}\n pre{background:#0b10221a;border:1px solid #e5e7eb;border-radius:8px;padding:12px;overflow:auto}\n .grid{display:grid;gap:12px}\n .cols-2{grid-template-columns:repeat(auto-fit,minmax(280px,1fr))}\n .tag{display:inline-block;background:#eef2ff;border-radius:999px;padding:2px 10px;margin-right:6px;font-size:.85rem}\n .box{background:#fafafa;border:1px solid #eee;border-radius:10px;padding:12px 14px}\n .table{border-collapse:collapse;width:100%}\n .table td,.table th{border:1px solid #e5e7eb;padding:8px 10px;text-align:left;vertical-align:top}\n .muted{color:#555}\n .ok{color:#0a7f2e;font-weight:600}\n .warn{background:#fff7ed;border-left:4px solid #fb923c;padding:10px;border-radius:6px}\n .small{font-size:.92rem;color:#555}\n .glossary{font-size:.98rem}\n .glossary .table th{white-space:nowrap}\n<\/style>\n<\/head>\n<body>\n<header>\n <h1>\u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8\uff08\u30a2\u30a4\u30c7\u30a2\u30e1\u30e2\u3000\u30d1\u30fc\u30c82\uff09<\/h1>\n <p class=\"small\">\u4e3b\u5f79\u306f\u30c7\u30fc\u30bf\u53ce\u96c6\u3068\u5229\u6d3b\u7528\u3002AI\u306f\u6574\u7406\u30fb\u533f\u540d\u5316\u30fb\u63a8\u8a08\u306e\u9ed2\u5b50\u3002\u307c\u304b\u3057\u306f\u9854\/\u30ca\u30f3\u30d0\u30fc\u3067\u306f\u306a\u304f<strong>\u8eca\u4f53\u307e\u308b\u3054\u3068<\/strong>\u3002\u751f\u30c7\u30fc\u30bf\u306f<strong>\u7ba1\u7406\u56e3\u4f53\u306e\u307f<\/strong>\u3002<\/p>\n<\/header>\n<main>\n\n<p class=\"lead\">\u672c\u7a3f\u306f\u300c\u3044\u307e\u3059\u3050\u4f5c\u308a\u59cb\u3081\u3089\u308c\u308b\u300d\u3053\u3068\u3092\u6700\u512a\u5148\u306b\u3001Web\uff0bWeb\u30a2\u30d7\u30ea\u524d\u63d0\u3067\u306e\u6700\u5c0f\u69cb\u6210\u3001DB\uff08\u30de\u30b9\u30bf\/\u696d\u52d9\/\u76e3\u67fb\uff09\u3001API\u3001\u975e\u540c\u671f\u30bf\u30b9\u30af\u3001\u91cd\u3044\u6f14\u7b97\u3092\u5207\u308a\u96e2\u3057\u305f\u201cAI API\/\u30ef\u30fc\u30ab\u30fc\u201d\u306e\u5f62\u3092\u4e00\u6c17\u306b\u793a\u3057\u307e\u3059\u3002\u96e3\u3057\u3044\u3068\u3053\u308d\u306f\u5f8c\u56de\u3057\u3001\u3067\u3082\u7a74\u306f\u958b\u3051\u306a\u3044\u3002\u76f4\u7403\u3067\u3044\u304d\u307e\u3059\u3002<\/p>\n\n<h2>1. \u5168\u4f53\u89b3\uff08\u6700\u5c0f\u3067\u3082\u56de\u308b\u69cb\u6210\uff09<\/h2>\n<div class=\"box\">\n <div class=\"tag\">\u30d5\u30ed\u30f3\u30c8<\/div><div class=\"tag\">API<\/div><div class=\"tag\">DB\/PostGIS<\/div><div class=\"tag\">S3(anon\/raw)<\/div><div class=\"tag\">Queue<\/div><div class=\"tag\">AI\u30ef\u30fc\u30ab\u30fc<\/div><div class=\"tag\">\u5b9a\u70b9\u30ab\u30e1\u30e9<\/div>\n <pre>\n[\u5229\u7528\u8005PWA\/\u30d6\u30e9\u30a6\u30b6] \u2500\u2500\u2500 HTTPS \u2500\u2500\u2500> [API Gateway\/ALB \u2192 Web API(FastAPI)]\n \u2502 \u2502\n \u2502(\u4e8b\u524d\u7f72\u540dURL\u3067\u76f4UP) \u2502SQL(PostGIS)\n \u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500> [S3 anon\/] \u251c\u2500\u2500\u2500\u2500> [Aurora PG + PostGIS]\n \u2502 \u2502\n \u2502 \u2514\u2500\u2500\u2500\u2500> [SQS] \u2192 [AI\u30ef\u30fc\u30ab\u30fc\u7fa4(\u5185\u90e8API)]\n \u2502 \u251c\u2500 anonymize_vehicle\uff08\u8eca\u4f53\u307c\u304b\u3057\uff09\n \u2502 \u251c\u2500 classify\uff08\u30ab\u30c6\u30b4\u30ea\u63a8\u5b9a\/NG\u691c\u77e5\uff09\n \u2502 \u251c\u2500 dedupe\uff08\u91cd\u8907\u30af\u30e9\u30b9\u30bf\uff09\n \u2502 \u2514\u2500 traffic_aggregate\uff08\u5229\u7528\u7387\u96c6\u8a08\uff09\n[\u5b9a\u70b9\u30ab\u30e1\u30e9\/\u30a8\u30c3\u30b8] \u2500\u2500(\u533f\u540d\u5316\/\u30ab\u30a6\u30f3\u30c8\u6e08\u307f\u30e1\u30bf)\u2500\u2500> [API \/devices\/{id}\/events]\n <\/pre>\n <p class=\"muted\">\u30dd\u30a4\u30f3\u30c8\uff1a\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306f\u533f\u540d\u5316\u5074 <code>S3 anon\/<\/code> \u3092\u30c7\u30d5\u30a9\u3002<code>S3 raw\/<\/code> \u306f\u539f\u5247\u4f7f\u308f\u305a\u3001\u7ba1\u7406\u56e3\u4f53\u306e\u660e\u793a\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u6642\u306e\u307f\u3002\u91cd\u3044\u51e6\u7406\u306fSQS\/\u30ef\u30fc\u30ab\u30fc\u3078\u3002<\/p>\n<\/div>\n\n<h2>2. \u521d\u671f\u306b\u7528\u610f\u3059\u308b\u30af\u30e9\u30a6\u30c9\u8981\u7d20\uff08MVP\uff09<\/h2>\n<ul>\n <li><strong>\u9759\u7684\u30d5\u30ed\u30f3\u30c8\uff1a<\/strong> S3 + CDN\uff08PWA\u3001Map\u63cf\u753b\u3001\u30aa\u30d5\u30e9\u30a4\u30f3\u5bfe\u5fdc\uff09<\/li>\n <li><strong>Web API\uff1a<\/strong> FastAPI\uff08Fargate \u304b Functions\/Lambda\uff09<\/li>\n <li><strong>DB\uff1a<\/strong> Aurora PostgreSQL + <strong>PostGIS<\/strong><\/li>\n <li><strong>\u30b9\u30c8\u30ec\u30fc\u30b8\uff1a<\/strong> S3\uff08<code>anon\/<\/code>\uff1d\u307c\u304b\u3057\u6e08\u307f\u516c\u958b\u7528\u3001<code>raw\/<\/code>\uff1d\u7ba1\u7406\u56e3\u4f53\u9650\u5b9a\uff09<\/li>\n <li><strong>\u30ad\u30e5\u30fc\uff1a<\/strong> SQS\uff08ingest\/anonymize\/classify\/dedupe\/traffic_aggregate\uff09<\/li>\n <li><strong>\u8a8d\u8a3c\uff1a<\/strong> Cognito\/OIDC\uff08LINE\u30ed\u30b0\u30a4\u30f3\u4f75\u7528\u53ef\uff09<\/li>\n <li><strong>\u76e3\u8996\uff1a<\/strong> CloudWatch + APM\uff08\u4f8b\uff1aOpenTelemetry\uff09<\/li>\n<\/ul>\n\n<h2>3. \u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\uff08\u6700\u5c0f\u30bb\u30c3\u30c8\uff09<\/h2>\n<div class=\"grid cols-2\">\n <div class=\"box\">\n <h3>\u30de\u30b9\u30bf<\/h3>\n <ul>\n <li><code>organizations<\/code>\uff1a\u81ea\u6cbb\u4f53\/\u56e3\u4f53<\/li>\n <li><code>categories<\/code>\uff1a\u901a\u5831\u30ab\u30c6\u30b4\u30ea\uff0810\u500b\u7a0b\u5ea6\u306b\u7d5e\u308b\uff09<\/li>\n <li><code>areas<\/code>\uff1a\u62c5\u5f53\u30a8\u30ea\u30a2\uff08MultiPolygon\uff09<\/li>\n <li><code>road_links<\/code>\uff1a\u9053\u8def\u30ea\u30f3\u30af\uff08LineString\uff09<\/li>\n <\/ul>\n <\/div>\n <div class=\"box\">\n <h3>\u696d\u52d9<\/h3>\n <ul>\n <li><code>reports<\/code>\uff1a\u901a\u5831\uff08Point, status, attributes\uff09<\/li>\n <li><code>report_media<\/code>\uff1a\u753b\u50cf\/\u52d5\u753b\uff08<code>anon\/<\/code>, <code>raw\/<\/code>\u9375\uff09<\/li>\n <li><code>report_status_history<\/code>\uff1a\u9032\u6357\u5c65\u6b74<\/li>\n <li><code>devices<\/code>\uff1a\u5b9a\u70b9\u30ab\u30e1\u30e9\/\u30a8\u30c3\u30b8<\/li>\n <li><code>camera_events<\/code>\uff1a\u30ab\u30a6\u30f3\u30c8\u7d50\u679c\uff08\u8eca\/\u4eba\uff09<\/li>\n <li><code>traffic_agg_hourly<\/code>\uff1a\u9053\u8def\u5229\u7528\u7387\uff08\u30ea\u30f3\u30af\u00d7\u6642\u523b\uff09<\/li>\n <\/ul>\n <\/div>\n<\/div>\n<pre>\n-- \u4f4d\u7f6e\u306fPostGIS\u3002\u516c\u958b\u6642\u306f\u4e38\u3081\u308b\uff08\u4f8b\uff1a50m\u683c\u5b50\uff09\nCREATE TABLE core.reports(\n id UUID PRIMARY KEY,\n org_id UUID NOT NULL,\n user_id UUID NULL,\n category_id INT NOT NULL,\n title TEXT, body TEXT,\n status TEXT CHECK(status IN ('received','triaged','in_progress','resolved','rejected')) DEFAULT 'received',\n location geometry(Point,4326),\n location_precision_m INT DEFAULT 50,\n attributes JSONB DEFAULT '{}'::jsonb,\n dedupe_group_id UUID,\n created_at timestamptz DEFAULT now(), updated_at timestamptz DEFAULT now()\n);\nCREATE INDEX ON core.reports USING GIST(location);\n<\/pre>\n\n<h2>4. API\uff08\u516c\u958bREST\uff09<\/h2>\n<table class=\"table\">\n <thead><tr><th>\u30e1\u30bd\u30c3\u30c9<\/th><th>\u30d1\u30b9<\/th><th>\u6982\u8981<\/th><\/tr><\/thead>\n <tbody>\n <tr><td>GET<\/td><td>\/api\/v1\/master\/categories<\/td><td>\u30ab\u30c6\u30b4\u30ea\u4e00\u89a7<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/reports<\/td><td>\u901a\u5831\u4f5c\u6210\uff08\u30e1\u30bf\u767b\u9332\u2192S3\u4e8b\u524d\u7f72\u540d\u8fd4\u5374\uff09<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/media\/presign<\/td><td>S3\u4e8b\u524d\u7f72\u540d\u306e\u767a\u884c<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/media\/confirm<\/td><td>\u30a2\u30c3\u30d7\u5b8c\u4e86\u901a\u77e5\u2192<strong>anonymize_vehicle<\/strong>\u6295\u5165<\/td><\/tr>\n <tr><td>GET<\/td><td>\/api\/v1\/reports?bbox&status<\/td><td>\u5730\u56f3\u7528\u30ea\u30b9\u30c8\uff08\u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0\u6e08\u307f\uff09<\/td><\/tr>\n <tr><td>PATCH<\/td><td>\/api\/v1\/reports\/{id}\/status<\/td><td>\u9032\u6357\u5909\u66f4\uff08operator\u4ee5\u4e0a\uff09<\/td><\/tr>\n <tr><td>POST<\/td><td>\/api\/v1\/devices\/{id}\/events<\/td><td>\u5b9a\u70b9\u306e\u96c6\u8a08\u30e1\u30bf\u6295\u5165\uff08\u533f\u540d\u5316\u6e08\u307f\u8a08\u6570\uff09<\/td><\/tr>\n <tr><td>GET<\/td><td>\/api\/v1\/traffic\/links\/{id}\/hourly<\/td><td>\u9053\u8def\u5229\u7528\u7387\uff08\u6642\u7cfb\u5217\uff09<\/td><\/tr>\n <\/tbody>\n<\/table>\n\n<h3>\u4f8b\uff1a\u901a\u5831\u767b\u9332\u2192\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/h3>\n<pre>\n\/\/ 1) \u30e1\u30bf\u767b\u9332\nPOST \/api\/v1\/reports\n{\n \"category_code\": \"road_damage\",\n \"title\": \"\u8217\u88c5\u306e\u7a74\",\n \"body\": \"\u591c\u9593\u306b\u5371\u306a\u3044\",\n \"event_time\": \"2025-09-14T09:30:00+09:00\",\n \"location\": {\"lat\": 35.68, \"lng\": 139.76, \"precision_m\": 50},\n \"media\": [{\"kind\":\"image\",\"presign\":true}]\n}\n\n\/\/ 2) \u30ec\u30b9\u30dd\u30f3\u30b9\uff08S3 anon\/ \u3078\u306e\u4e8b\u524d\u7f72\u540d\uff09\n{\n \"report_id\": \"d1c7-...\",\n \"uploads\": [\n {\"media_id\":\"m-1\",\"url\":\"https:\/\/s3\/anon\/...\",\"fields\":{\"key\":\"anon\/..\",\"policy\":\"..\"}}\n ]\n}\n\n\/\/ 3) \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304cS3\u3078\u76f4\u63a5PUT\u3057\u305f\u5f8c\nPOST \/api\/v1\/media\/confirm\n{ \"media_id\": \"m-1\", \"sha256\":\"abc...\", \"raw_requested\": false }\n<\/pre>\n\n<h2>5. \u201c\u96e3\u3057\u3044\u6f14\u7b97\u90e8\u201d\u306fAPI\/\u30ef\u30fc\u30ab\u30fc\u306b\u5207\u308a\u96e2\u3059<\/h2>\n<p class=\"warn\"><strong>\u539f\u5247\uff1a<\/strong> \u30d5\u30ed\u30f3\u30c8\u3068Web API\u306f\u8584\u304f\u3002\u91cd\u3044\u51e6\u7406\uff08\u753b\u50cf\u51e6\u7406\u30fb\u985e\u4f3c\u691c\u7d22\u30fb\u6642\u7cfb\u5217\u96c6\u8a08\uff09\u306f\u30ad\u30e5\u30fc\u7d4c\u7531\u3067\u30ef\u30fc\u30ab\u30fc\u304c\u5b9f\u65bd\u3002Web API\u306f\u7d50\u679c\u3060\u3051\u3092\u898b\u308b\u3002<\/p>\n\n<div class=\"grid cols-2\">\n <div class=\"box\">\n <h3>(A) \u5185\u90e8API\uff08\u30b5\u30fc\u30d3\u30b9\u9593\uff09<\/h3>\n <ul>\n <li><code>POST \/_internal\/anonymize\/vehicle<\/code>\uff1a\u8eca\u4f53\u307e\u308b\u3054\u3068\u307c\u304b\u3057<\/li>\n <li><code>POST \/_internal\/classify<\/code>\uff1a\u30ab\u30c6\u30b4\u30ea\u63a8\u5b9a\u30fbNG\u5224\u5b9a<\/li>\n <li><code>POST \/_internal\/dedupe<\/code>\uff1a\u91cd\u8907\u30af\u30e9\u30b9\u30bf\u66f4\u65b0<\/li>\n <li><code>POST \/_internal\/traffic\/aggregate<\/code>\uff1a\u9053\u8def\u5229\u7528\u7387\u96c6\u8a08<\/li>\n <\/ul>\n <p class=\"muted\">VPC\u5185\/\u8a8d\u8a3c\u5fc5\u9808\u3002\u5916\u90e8\u304b\u3089\u30a2\u30af\u30bb\u30b9\u4e0d\u53ef\u3002<\/p>\n <\/div>\n <div class=\"box\">\n <h3>(B) \u30ef\u30fc\u30ab\u30fc\uff08\u64ec\u4f3c\u30b3\u30fc\u30c9\/Python\uff09<\/h3>\n <pre>\n@app.task(name=\"anonymize_vehicle\")\ndef anonymize_vehicle(media_id: str):\n media = db.get_media(media_id)\n img = load_from_s3(media.s3_key) # \u307c\u304b\u3057\u306f\u8eca\u4f53\u5168\u4f53\n boxes = detect_vehicles(img) # car\/bus\/truck\/bike...\n img2 = mosaic_outside_safe_margin(img, boxes)\n save_to_s3(img2, media.s3_key) # anon\/ \u306b\u4e0a\u66f8\u304d\u4fdd\u5b58\n enqueue(\"classify\", {\"report_id\": media.report_id})\n <\/pre>\n <\/div>\n<\/div>\n\n<h3>\u91cd\u8907\u30af\u30e9\u30b9\u30bf\uff08dedupe\uff09\u30a4\u30e1\u30fc\u30b8<\/h3>\n<pre>\ndef recompute_cluster(report_id):\n r = db.reports[report_id]\n candidates = search_nearby(\n point=r.location, radius_m=120,\n time_window=\"\u00b124h\",\n text_embed=r.attributes['text_embed'])\n cluster_id = union_find_by_similarity(candidates + [r])\n db.update(report_id, dedupe_group_id=cluster_id)\n<\/pre>\n\n<h3>\u9053\u8def\u5229\u7528\u7387\uff08\u5b9a\u70b9\u30ab\u30e1\u30e9\u2192\u30ea\u30f3\u30af\u96c6\u8a08\uff09<\/h3>\n<pre>\nPOST \/api\/v1\/devices\/{id}\/events\n{\n \"captured_at\": \"2025-09-14T00:00:00Z\",\n \"counters\": {\"vehicle\": 86, \"pedestrian\": 240},\n \"link_id\": 10234\n}\n\n# \u96c6\u8a08\u30b8\u30e7\u30d6(hourly)\nINSERT INTO traffic_agg_hourly(link_id,hour,vehicle_cnt,ped_cnt)\nVALUES(...) ON CONFLICT (...) DO UPDATE ...\n<\/pre>\n\n<h2>6. \u30d5\u30ed\u30f3\u30c8\uff08PWA\/Map\uff09\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8<\/h2>\n<div class=\"grid cols-2\">\n <div>\n <h3>\u753b\u9762<\/h3>\n <ul>\n <li>\u30db\u30fc\u30e0\uff1a\u5730\u56f3\uff0b\u9032\u6357\u30d5\u30a3\u30eb\u30bf\uff08<span class=\"ok\">\u30af\u30e9\u30b9\u30bf\u8868\u793a<\/span>\uff09<\/li>\n <li>\u65b0\u898f\u901a\u5831\uff1a\u64ae\u308b\u2192\u4f4d\u7f6e\u2192\u9001\u308b\uff083\u30bf\u30c3\u30d7\uff09<\/li>\n <li>\u8a73\u7d30\uff1a\u5199\u771f\uff08<em>\u307c\u304b\u3057\u6e08\u307f<\/em>\uff09\u3001\u9032\u6357\u3001\u985e\u4f3c\u5831\u544a<\/li>\n <li>\u30de\u30a4\u30da\u30fc\u30b8\uff1a\u30dd\u30a4\u30f3\u30c8\u3001\u5c65\u6b74<\/li>\n <li>\u904b\u7528\uff1a\u91cd\u8907\u675f\u306d\u3001\u512a\u5148\u5ea6\u30ad\u30e5\u30fc\u3001\u9053\u8def\u5229\u7528\u7387\u30b0\u30e9\u30d5<\/li>\n <\/ul>\n <\/div>\n <div>\n <h3>\u30b3\u30fc\u30c9\uff08\u8d85\u8981\u70b9\uff09<\/h3>\n <pre>\n\/\/ \u4f4d\u7f6e\u4e38\u3081\u306f\u30b5\u30fc\u30d0\u5074\u3002\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306f\u7d30\u304b\u3044\u3053\u3068\u3057\u306a\u3044\u3002\nasync function createReport(meta){\n const r = await fetch('\/api\/v1\/reports',{method:'POST',\n headers:{'Content-Type':'application\/json'},\n body: JSON.stringify(meta)});\n const {uploads} = await r.json();\n \/\/ presigned URL\u306b\u76f4PUT\n await fetch(uploads[0].url,{method:'PUT',body: selectedFile});\n await fetch('\/api\/v1\/media\/confirm',{method:'POST',\n headers:{'Content-Type':'application\/json'},\n body: JSON.stringify({media_id: uploads[0].media_id, sha256: fileHash})});\n}\n <\/pre>\n <\/div>\n<\/div>\n<p class=\"muted\">\u5730\u56f3\u306f MapLibre GL \u7b49\u3002\u30a2\u30af\u30bb\u30b7\u30d3\u30ea\u30c6\u30a3\u306e\u305f\u3081\u30dc\u30bf\u30f3\u306f\u5927\u304d\u304f\u3001\u97f3\u58f0\u5165\u529b\u3082\u8a31\u5bb9\u3002\u30aa\u30d5\u30e9\u30a4\u30f3\u6642\u306fService Worker\u3067\u4e0b\u66f8\u304d\u4fdd\u5b58\u2192\u5fa9\u5e30\u6642\u306b\u9001\u4fe1\u3002<\/p>\n\n<h2>7. \u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\/\u30d7\u30e9\u30a4\u30d0\u30b7\u904b\u7528\u306e\u809d<\/h2>\n<ul>\n <li><strong>\u307c\u304b\u3057\u539f\u5247\uff1a<\/strong> \u9854\/\u30ca\u30f3\u30d0\u30fc\u5358\u4f53\u3067\u306f\u306a\u304f<strong>\u8eca\u4f53\u307e\u308b\u3054\u3068<\/strong>\u3002\u8aa4\u691c\u77e5\u3092\u907f\u3051\u308b\u3002<\/li>\n <li><strong>raw\u306e\u7ba1\u7406\uff1a<\/strong> \u539f\u5247\u4f7f\u308f\u306a\u3044\u3002\u5fc5\u8981\u6642\u306e\u307f\u7ba1\u7406\u56e3\u4f53\u306e\u627f\u8a8d\u4ed8\u304d\u3067\u4fdd\u7ba1\/\u95b2\u89a7\u3002\u30a2\u30af\u30bb\u30b9\u306f\u76e3\u67fb\u30ed\u30b0\u5fc5\u9808\u3002<\/li>\n <li><strong>\u516c\u958b\u30c7\u30fc\u30bf\uff1a<\/strong> \u5ea7\u6a19\u306f\u4e38\u3081\uff08\u4f8b\uff1a50m\uff09\u3001\u671f\u9593\u9650\u5b9a\u3001\u518d\u8b58\u5225\u30c1\u30a7\u30c3\u30af\u3002<\/li>\n <li><strong>RBAC\uff1a<\/strong> resident \/ moderator \/ operator \/ admin \u3092\u5206\u96e2\u3002<\/li>\n <li><strong>\u30ec\u30fc\u30c8\u5236\u5fa1\/WAF\uff1a<\/strong> \u8352\u3089\u3057\u5bfe\u7b56\u306f\u30d5\u30ed\u30f3\u30c8\u3067\u306f\u306a\u304f\u30b2\u30fc\u30c8\u3067\u6b62\u3081\u308b\u3002<\/li>\n<\/ul>\n\n<h2>8. \u904b\u7528KPI\uff08MVP\u3067\u898b\u308b\u6570\u5b57\uff09<\/h2>\n<ul>\n <li>\u91cd\u8907\u7d71\u5408\u7387\uff08dedupe\u6210\u529f\u7387\uff09<\/li>\n <li>\u533f\u540d\u5316\u6210\u529f\u7387\uff08\u8eca\u4f53\u307c\u304b\u3057\u6f0f\u308c0\u3092\u76ee\u6a19\uff09<\/li>\n <li>\u53d7\u4ed8\u2192\u73fe\u5730\u78ba\u8a8d\u30ea\u30fc\u30c9\u30bf\u30a4\u30e0<\/li>\n <li>\u9053\u8def\u30ea\u30f3\u30af\u00d7\u6642\u9593\u306e\u30ab\u30d0\u30ec\u30c3\u30b8\u7387<\/li>\n <li>\u521d\u56de\u2192\u7fcc\u6708\u7d99\u7d9a\u7387\uff08\u30dd\u30a4\u30f3\u30c8\u4f9d\u5b58\u5ea6\u306f\u4f4e\u304f\uff09<\/li>\n<\/ul>\n\n<h2>9. \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3068\u8a2d\u5b9a\u4f8b<\/h2>\n<pre>\nrepo\/\n\u251c\u2500 frontend\/ # Next.js PWA\n\u251c\u2500 api\/ # FastAPI (REST)\n\u2502 \u251c\u2500 routes\/ # reports, media, devices...\n\u2502 \u251c\u2500 services\/ # db, s3, presign, auth\n\u2502 \u2514\u2500 schemas\/ # pydantic\n\u251c\u2500 workers\/ # AI\u30ef\u30fc\u30ab\u30fc\uff08anonymize\/classify\/dedupe\/aggregate\uff09\n\u2502 \u2514\u2500 tasks\/\n\u251c\u2500 infra\/ # IaC(Terraform) \/ pipelines\n\u2514\u2500 docs\/\n<\/pre>\n<pre>\n# .env\uff08\u4f8b\uff1aAPI\uff09\nDATABASE_URL=postgresql+psycopg2:\/\/...\nS3_BUCKET=city-app-bucket\nANON_PREFIX=anon\/\nRAW_PREFIX=raw\/\nQUEUE_URL_ANONYMIZE=...\nJWT_AUDIENCE=...\n<\/pre>\n\n<h2>10. \u30d5\u30a7\u30fc\u30ba2\u3067\u8db3\u3059\u3082\u306e\uff08\u5fc5\u8981\u306b\u306a\u3063\u305f\u3089\uff09<\/h2>\n<ul>\n <li>GraphQL\uff08AppSync\u7b49\uff09\u3067\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u66f4\u65b0<\/li>\n <li>OpenSearch\u3067\u5168\u6587\/\u985e\u4f3c\u691c\u7d22<\/li>\n <li>Step Functions\u3067\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u306e\u53ef\u8996\u5316\uff08\u5931\u6557\u6642\u306e\u518d\u8a66\u884c\/DLQ\uff09<\/li>\n <li>\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\uff08QuickSight\/Looker Studio\uff09<\/li>\n <li>Open311\u4e92\u63dbAPI\u516c\u958b\u3001\u30aa\u30fc\u30d7\u30f3\u30c7\u30fc\u30bf\u81ea\u52d5\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/li>\n<\/ul>\n\n<hr \/>\n\n<h2>11. \u7528\u8a9e\u8aac\u660e\u96c6\uff08\u81ea\u6cbb\u4f53\u62c5\u5f53\u8005\u5411\u3051\u30fb\u6a2a\u6587\u5b57\u3092\u565b\u307f\u7815\u304f\uff09<\/h2>\n<p class=\"muted\">\u6280\u8853\u7528\u8a9e\u3092\u300c\u8981\u306f\u3069\u3046\u3044\u3046\u3053\u3068\uff1f\u300d\u306b\u8a00\u3044\u63db\u3048\u307e\u3057\u305f\u3002\u4f1a\u8b70\u3067\u51fa\u3066\u304d\u305f\u3089\u3001\u3053\u306e\u8868\u3092\u305d\u306e\u307e\u307e\u4f7f\u3063\u3066OK\u3067\u3059\u3002<\/p>\n<table class=\"table glossary\">\n <thead><tr><th>\u7528\u8a9e<\/th><th>\u610f\u5473\uff08\u304b\u3093\u305f\u3093\uff09<\/th><th>\u5f79\u5272\u30fb\u305f\u3068\u3048<\/th><\/tr><\/thead>\n <tbody>\n <tr><td>Web\u30a2\u30d7\u30ea \/ PWA<\/td><td>\u30d6\u30e9\u30a6\u30b6\u3067\u52d5\u304f\u30a2\u30d7\u30ea\u3002\u30db\u30fc\u30e0\u753b\u9762\u306b\u5165\u308c\u3089\u308c\u3001\u96fb\u6ce2\u304c\u5f31\u304f\u3066\u3082\u4e00\u90e8\u52d5\u304f\u3002<\/td><td>\u300c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3044\u3089\u305a\u306e\u30a2\u30d7\u30ea\u300d\u3002<\/td><\/tr>\n <tr><td>CDN<\/td><td>\u5168\u56fd\u306b\u3042\u308b\u4e2d\u7d99\u6240\u304b\u3089\u8fd1\u5834\u3067\u914d\u308b\u4ed5\u7d44\u307f\u3002<\/td><td>\u914d\u9054\u62e0\u70b9\u304c\u591a\u3044\u5b85\u914d\u4fbf\u3002<\/td><\/tr>\n <tr><td>S3<\/td><td>\u753b\u50cf\u3084\u52d5\u753b\u3092\u7f6e\u304f\u5927\u304d\u306a\u5009\u5eab\u3002<\/td><td>\u300canon = \u307c\u304b\u3057\u6e08\u307f\u68da\u300d\u300craw = \u751f\u30c7\u30fc\u30bf\u68da\u300d\u3002<\/td><\/tr>\n <tr><td>\u4e8b\u524d\u7f72\u540dURL\uff08Presigned URL\uff09<\/td><td>\u4e00\u6642\u7684\u306b\u5009\u5eab\u3078\u76f4\u63a5\u30a2\u30c3\u30d7\u3067\u304d\u308b\u5408\u9375\u3002<\/td><td>\u671f\u9650\u3064\u304d\u306e\u642c\u5165\u53e3\u30d1\u30b9\u3002<\/td><\/tr>\n <tr><td>API<\/td><td>\u30a2\u30d7\u30ea\u540c\u58eb\u306e\u53d7\u3051\u53e3\uff08\u3084\u308a\u53d6\u308a\u306e\u6c7a\u307e\u308a\uff09\u3002<\/td><td>\u5f79\u6240\u306e\u300c\u7a93\u53e3\u306e\u69d8\u5f0f\u300d\u3002<\/td><\/tr>\n <tr><td>FastAPI \/ NestJS<\/td><td>API\u3092\u4f5c\u308b\u305f\u3081\u306e\u9053\u5177\u3002<\/td><td>\u7a93\u53e3\u306e\u4ed5\u5207\u308a\u3084\u5e33\u7968\u3092\u4f5c\u308b\u30c4\u30fc\u30eb\u3002<\/td><\/tr>\n <tr><td>ALB \/ API Gateway<\/td><td>\u5916\u304b\u3089\u306e\u901a\u4fe1\u306e\u7384\u95a2\u3002<\/td><td>\u6b63\u9762\u30ed\u30d3\u30fc\u306e\u53d7\u4ed8\u3002<\/td><\/tr>\n <tr><td>ECS Fargate<\/td><td>\u30b5\u30fc\u30d0\u7ba1\u7406\u306a\u3057\u3067\u30a2\u30d7\u30ea\u3092\u52d5\u304b\u3059\u53f0\u3002<\/td><td>\u300c\u30ec\u30f3\u30bf\u30ab\u30fc\u3001\u71c3\u6599\u88dc\u7d66\u3082\u81ea\u52d5\u300d\u3002<\/td><\/tr>\n <tr><td>Lambda<\/td><td>\u547c\u3070\u308c\u305f\u3068\u304d\u3060\u3051\u52d5\u304f\u5c0f\u30d7\u30ed\u30b0\u30e9\u30e0\u3002<\/td><td>\u5fc5\u8981\u306a\u6642\u3060\u3051\u547c\u3076\u30bf\u30af\u30b7\u30fc\u3002<\/td><\/tr>\n <tr><td>Aurora PostgreSQL<\/td><td>\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3002<\/td><td>\u53f0\u5e33\u306e\u672c\u4e38\u3002<\/td><\/tr>\n <tr><td>PostGIS<\/td><td>DB\u306b\u5730\u56f3\u306e\u982d\u8133\u3092\u8db3\u3059\u3002<\/td><td>\u70b9\u3084\u9053\u8def\u7dda\u3092\u6271\u3048\u308b\u5730\u56f3\u6a5f\u80fd\u3002<\/td><\/tr>\n <tr><td>OpenSearch<\/td><td>\u5168\u6587\u691c\u7d22\u30fb\u4f3c\u3066\u3044\u308b\u6587\u7ae0\u63a2\u3057\u3002<\/td><td>\u56f3\u66f8\u9928\u306e\u53f8\u66f8\uff0b\u30ec\u30b3\u30e1\u30f3\u30c9\u3002<\/td><\/tr>\n <tr><td>Redis<\/td><td>\u8d85\u901f\u3044\u4e00\u6642\u7f6e\u304d\u5834\u3002<\/td><td>\u53d7\u4ed8\u306e\u624b\u5143\u30e1\u30e2\u3002<\/td><\/tr>\n <tr><td>SQS\uff08\u30ad\u30e5\u30fc\uff09<\/td><td>\u9806\u756a\u5f85\u3061\u306e\u7bb1\u3002\u91cd\u3044\u51e6\u7406\u306f\u3053\u3053\u306b\u4e26\u3079\u308b\u3002<\/td><td>\u6574\u7406\u5238\u767a\u5238\u6a5f\u3002<\/td><\/tr>\n <tr><td>Step Functions<\/td><td>\u51e6\u7406\u306e\u6d41\u308c\u56f3\u3092\u305d\u306e\u307e\u307e\u6a5f\u68b0\u306b\u5b9f\u884c\u3055\u305b\u308b\u3002<\/td><td>\u696d\u52d9\u30d5\u30ed\u30fc\u306e\u6a19\u6e96\u5316\u3002<\/td><\/tr>\n <tr><td>AppSync \/ WebSocket<\/td><td>\u753b\u9762\u3092\u81ea\u52d5\u66f4\u65b0\u3059\u308b\u4ed5\u7d44\u307f\u3002<\/td><td>\u96fb\u5149\u63b2\u793a\u677f\u304c\u52dd\u624b\u306b\u66f4\u65b0\u3002<\/td><\/tr>\n <tr><td>Cognito \/ OIDC<\/td><td>\u30ed\u30b0\u30a4\u30f3\u306e\u4ed5\u7d44\u307f\u3002LINE\u30ed\u30b0\u30a4\u30f3\u3082\u63a5\u7d9a\u53ef\u3002<\/td><td>\u5165\u9928\u8a3c\u306e\u767a\u884c\u30fb\u78ba\u8a8d\u3002<\/td><\/tr>\n <tr><td>RBAC<\/td><td>\u5f79\u5272\u3054\u3068\u306b\u6a29\u9650\u3092\u5206\u3051\u308b\u3002<\/td><td>\u4f4f\u6c11\/\u8077\u54e1\/\u7ba1\u7406\u8005\u3067\u898b\u3048\u308b\u7bc4\u56f2\u304c\u9055\u3046\u3002<\/td><\/tr>\n <tr><td>IAM<\/td><td>\u8ab0\u304c\u4f55\u3092\u3057\u3066\u826f\u3044\u304b\u306e\u8a31\u53ef\u8a3c\u3002<\/td><td>\u5e81\u5185\u306e\u6a29\u9650\u53f0\u5e33\u3002<\/td><\/tr>\n <tr><td>KMS \/ Secrets Manager<\/td><td>\u6697\u53f7\u9375\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u91d1\u5eab\u3002<\/td><td>\u9375\u4ed8\u304d\u30ed\u30c3\u30ab\u30fc\u3002<\/td><\/tr>\n <tr><td>VPC \/ AZ<\/td><td>\u81ea\u5206\u5c02\u7528\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\/\u30c7\u30fc\u30bf\u30bb\u30f3\u30bf\u30fc\u306e\u533a\u753b\u3002<\/td><td>\u5c02\u7528\u30d5\u30ed\u30a2\/\u5225\u9928\u3002<\/td><\/tr>\n <tr><td>VPC Endpoint<\/td><td>\u5009\u5eab\uff08S3\uff09\u3078\u88cf\u53e3\u76f4\u7d50\u3067\u5b89\u5168\u306b\u63a5\u7d9a\u3002<\/td><td>\u8377\u634c\u304d\u5834\u306e\u5c02\u7528\u901a\u8def\u3002<\/td><\/tr>\n <tr><td>CloudWatch \/ X-Ray \/ OpenTelemetry<\/td><td>\u52d5\u4f5c\u72b6\u6cc1\u306e\u898b\u3048\u308b\u5316\u3002<\/td><td>\u76e3\u8996\u30ab\u30e1\u30e9\uff0b\u52d5\u7dda\u306e\u53ef\u8996\u5316\u3002<\/td><\/tr>\n <tr><td>MapLibre GL<\/td><td>\u5730\u56f3\u3092\u753b\u9762\u306b\u63cf\u304f\u9053\u5177\u3002<\/td><td>\u5730\u56f3\u63cf\u753b\u30a8\u30f3\u30b8\u30f3\u3002<\/td><\/tr>\n <tr><td>\u30bf\u30a4\u30eb \/ \u30af\u30e9\u30b9\u30bf\u30ea\u30f3\u30b0<\/td><td>\u5730\u56f3\u3092\u5c0f\u5206\u3051\u306b\u914d\u308b\/\u8fd1\u3044\u30d4\u30f3\u3092\u307e\u3068\u3081\u3066\u8868\u793a\u3002<\/td><td>\u5206\u5272\u914d\u5e03\/\u4eba\u6570\u30ab\u30a6\u30f3\u30c8\u306e\u4e38\u3081\u8868\u793a\u3002<\/td><\/tr>\n <tr><td>bbox<\/td><td>\u4eca\u898b\u3048\u3066\u3044\u308b\u5730\u56f3\u306e\u56db\u89d2\u3044\u7bc4\u56f2\u3002<\/td><td>\u5730\u56f3\u306e\u7a93\u67a0\u3002<\/td><\/tr>\n <tr><td>JSON\/JSONB<\/td><td>\u67d4\u3089\u304b\u3044\u5f62\u5f0f\u306e\u7bb1\u306b\u60c5\u5831\u3092\u5165\u308c\u308b\u3002<\/td><td>\u53ef\u5909\u306e\u8ffd\u8a18\u4e8b\u9805\u30e1\u30e2\u3002<\/td><\/tr>\n <tr><td>GiST \/ GIN\uff08\u7d22\u5f15\uff09<\/td><td>\u5730\u7406\/\u6587\u7ae0\u691c\u7d22\u3092\u901f\u304f\u3059\u308b\u4ed5\u639b\u3051\u3002<\/td><td>\u3057\u304a\u308a\u30fb\u76ee\u6b21\u3002<\/td><\/tr>\n <tr><td>geometry(Point\/LineString)<\/td><td>\u70b9\/\u7dda\u3068\u3057\u3066\u4f4d\u7f6e\u60c5\u5831\u3092\u4fdd\u5b58\u3002<\/td><td>\u5730\u70b9\/\u9053\u8def\u7dda\u3002<\/td><\/tr>\n <tr><td>\u4f4d\u7f6e\u4e38\u3081<\/td><td>50m\u306a\u3069\u5927\u307e\u304b\u306a\u4f4d\u7f6e\u3060\u3051\u516c\u958b\u3002<\/td><td>\u81ea\u5b85\u306e\u771f\u4e0a\u306b\u30d4\u30f3\u3092\u7acb\u3066\u306a\u3044\u3002<\/td><\/tr>\n <tr><td>\u533f\u540d\u5316<\/td><td>\u500b\u4eba\u304c\u7279\u5b9a\u3055\u308c\u306a\u3044\u3088\u3046\u96a0\u3059\u3002<\/td><td>\u753b\u89d2\u30fb\u89e3\u50cf\u5ea6\u30fb\u4f4d\u7f6e\u306e\u914d\u616e\u3002<\/td><\/tr>\n <tr><td>\u8eca\u4f53\u307e\u308b\u3054\u3068\u307c\u304b\u3057<\/td><td>\u9854\/\u30ca\u30f3\u30d0\u30fc\u5358\u4f53\u3088\u308a\u5b89\u5168\u5074\u3067\u96a0\u3059\u3002<\/td><td>\u8aa4\u691c\u77e5\u5bfe\u7b56\u30fb\u518d\u8b58\u5225\u9632\u6b62\u3002<\/td><\/tr>\n <tr><td>\u30a8\u30c3\u30b8\u51e6\u7406<\/td><td>\u30ab\u30e1\u30e9\u5074\u3067\u5148\u306b\u533f\u540d\u5316\u3084\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u9001\u308b\u3002<\/td><td>\u73fe\u5834\u3067\u4e0b\u3054\u3057\u3089\u3048\u3002<\/td><\/tr>\n <tr><td>\u30c7\u30fc\u30bf\u30ec\u30a4\u30af \/ Glue \/ Athena \/ QuickSight<\/td><td>\u5009\u5eab\u306b\u8caf\u3081\u305f\u30c7\u30fc\u30bf\u3092SQL\u3067\u5206\u6790\u30fb\u53ef\u8996\u5316\u3002<\/td><td>\u7d71\u8a08\u5ba4\u3068\u58c1\u4e00\u9762\u306e\u30b0\u30e9\u30d5\u3002<\/td><\/tr>\n <tr><td>Open311<\/td><td>\u901a\u5831\u306e\u6a19\u6e96\u4ed5\u69d8\uff08\u30ab\u30c6\u30b4\u30ea\/\u9032\u6357\uff09\u3002<\/td><td>\u4ed6\u30b7\u30b9\u30c6\u30e0\u3068\u9023\u643a\u3057\u3084\u3059\u3044\u578b\u3002<\/td><\/tr>\n <tr><td>Webhook<\/td><td>\u5916\u90e8\u30b7\u30b9\u30c6\u30e0\u3078\u81ea\u52d5\u3067\u304a\u77e5\u3089\u305b\u3092\u9001\u308b\u3002<\/td><td>\u9023\u7d61\u7968\u306e\u81ea\u52d5FAX\u3002<\/td><\/tr>\n <tr><td>DLQ<\/td><td>\u5931\u6557\u30bf\u30b9\u30af\u306e\u4fdd\u7ba1\u7bb1\u3002<\/td><td>\u8981\u518d\u51e6\u7406\u30c8\u30ec\u30a4\u3002<\/td><\/tr>\n <tr><td>IQR<\/td><td>\u5916\u308c\u5024\uff08\u304a\u304b\u3057\u306a\u6570\uff09\u3092\u898b\u3064\u3051\u308b\u6307\u6a19\u3002<\/td><td>\u7570\u5e38\u691c\u77e5\u306e\u7269\u5dee\u3057\u3002<\/td><\/tr>\n <tr><td>A\/B\u30c6\u30b9\u30c8<\/td><td>2\u6848\u3092\u540c\u6642\u306b\u8a66\u3057\u3066\u826f\u3044\u65b9\u3092\u9078\u3076\u3002<\/td><td>\u6848\u5185\u6587A\u3068B\u3067\u6bd4\u8f03\u3002<\/td><\/tr>\n <tr><td>Embedding\uff08\u57cb\u3081\u8fbc\u307f\uff09<\/td><td>\u6587\u7ae0\u3084\u753b\u50cf\u3092\u6570\u5217\u306b\u5909\u3048\u3066\u4f3c\u3066\u3044\u308b\u5ea6\u5408\u3044\u3092\u898b\u308b\u3002<\/td><td>\u4f3c\u3066\u308b\u5ea6\uff1d\u30b3\u30b5\u30a4\u30f3\u985e\u4f3c\u5ea6\u3002<\/td><\/tr>\n <tr><td>\u91cd\u8907\u691c\u77e5 \/ \u30af\u30e9\u30b9\u30bf<\/td><td>\u4f3c\u305f\u5831\u544a\u3092\u307e\u3068\u3081\u308b\u3002<\/td><td>\u540c\u3058\u7a74\u306e\u5831\u544a\u30921\u675f\u306b\u3002<\/td><\/tr>\n <tr><td>\u30de\u30c3\u30d7\u30de\u30c3\u30c1\u30f3\u30b0 \/ Link ID<\/td><td>\u30ab\u30a6\u30f3\u30c8\u3092\u9053\u8def\u306e\u533a\u9593\u756a\u53f7\u306b\u7d50\u3073\u3064\u3051\u308b\u3002<\/td><td>\u96c6\u8a08\u306e\u3072\u3068\u5358\u4f4d\u3002<\/td><\/tr>\n <\/tbody>\n<\/table>\n\n<h3>\u300c\u3053\u306e\u8a00\u8449\u304c\u51fa\u305f\u3089\u3053\u3046\u7406\u89e3\u300d\u3067OK\uff08\u8d85\u8981\u7d04\uff09<\/h3>\n<ul>\n <li><strong>PWA<\/strong>\uff1d\u30d6\u30e9\u30a6\u30b6\u3067\u52d5\u304f\u30a2\u30d7\u30ea\u3002<\/li>\n <li><strong>API<\/strong>\uff1d\u30b7\u30b9\u30c6\u30e0\u9593\u306e\u7a93\u53e3\u3002<\/li>\n <li><strong>PostGIS<\/strong>\uff1d\u5730\u56f3\u306b\u5f37\u3044DB\u3002<\/li>\n <li><strong>\u30ad\u30e5\u30fc<\/strong>\uff1d\u9806\u756a\u5f85\u3061\u7bb1\uff08\u91cd\u3044\u51e6\u7406\u3092\u5f8c\u3067\uff09\u3002<\/li>\n <li><strong>\u533f\u540d\u5316\/\u307c\u304b\u3057<\/strong>\uff1d\u500b\u4eba\u306b\u7d50\u3073\u3064\u304f\u60c5\u5831\u3092\u96a0\u3059\u3002\u539f\u5247\u306f<strong>\u8eca\u4f53\u307e\u308b\u3054\u3068<\/strong>\u3002<\/li>\n <li><strong>\u30c7\u30fc\u30bf\u30ec\u30a4\u30af<\/strong>\uff1d\u3068\u308a\u3042\u3048\u305a\u8caf\u3081\u3066\u5f8c\u304b\u3089\u5206\u6790\u3002<\/li>\n <li><strong>Open311<\/strong>\uff1d\u901a\u5831\u306e\u5171\u901a\u30eb\u30fc\u30eb\u3002<\/li>\n<\/ul>\n\n<hr \/>\n<p class=\"small\">\n\u307e\u3068\u3081\uff1a\u6a2a\u6587\u5b57\u306f\u591a\u3044\u3067\u3059\u304c\u3001\u8981\u306f\u300c\u30c7\u30fc\u30bf\u3092\u5b89\u5168\u306b\u96c6\u3081\u3001\u898b\u3048\u308b\u5316\u3057\u3001\u6839\u62e0\u3092\u6301\u3063\u3066\u624b\u3092\u6253\u3064\u300d\u305f\u3081\u306e\u9053\u5177\u7acb\u3066\u3067\u3059\u3002<br>\n\u00a9\u682a\u5f0f\u4f1a\u793e\u30d3\u30fc\u30fb\u30ca\u30ec\u30c3\u30b8\u30fb\u30c7\u30b6\u30a4\u30f3\n<\/p>\n\n<\/main>\n<\/body>\n<\/html>\n\n","protected":false},"excerpt":{"rendered":"<p>\u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8 \u201c\u901a\u5831\u30a2\u30d7\u30ea \u00d7 \u8efd\u3044SNS \u00d7 \u5730\u56f3 \u00d7 \u30dd\u30a4\u30f3\u30c8 \u00d7 AI\uff08AI\u306f\u9ed2\u5b50\uff09\u201d \u7c21\u6613\u5b9f\u88c5\u30a4\u30e1\u30fc\u30b8\uff08\u30a2\u30a4\u30c7\u30a2\u30e1\u30e2\u3000\u30d1\u30fc\u30c82\uff09 […]<\/p>\n","protected":false},"author":1,"featured_media":1652,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","vkExUnit_EyeCatch_disable":"","_veu_custom_css":"","veu_display_promotion_alert":"common","vkexunit_cta_each_option":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-1651","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1"],"aioseo_notices":[],"veu_head_title_object":{"title":"","add_site_title":""},"jetpack_featured_media_url":"https:\/\/beeknowledge.co.jp\/wp-content\/uploads\/2025\/09\/00000.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1651"}],"version-history":[{"count":2,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1651\/revisions"}],"predecessor-version":[{"id":1654,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/1651\/revisions\/1654"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=\/wp\/v2\/media\/1652"}],"wp:attachment":[{"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beeknowledge.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}