ht80/houduan/ai_planner/management/commands/import_red_spots.py

from django.core.management.base import BaseCommand
from django.core.files import File
from django.db import transaction
from ai_planner.models import Attraction, City
import os


class Command(BaseCommand):
    help = '清空并重新导入所有红色旅游景点数据（含图片）'

    def add_arguments(self, parser):
        parser.add_argument(
            '--image-dir',
            type=str,
            default=r'G:\其他\image',
            help='指定图片存储目录路径'
        )
        parser.add_argument(
            '--skip-clear',
            action='store_true',
            help='跳过清空表步骤'
        )

    @transaction.atomic
    def handle(self, *args, **options):
        # 1. 清空现有数据（除非指定跳过）
        if not options['skip_clear']:
            self.stdout.write("正在清空现有景点数据...")
            Attraction.objects.all().delete()
            self.stdout.write(self.style.SUCCESS("√ 已清空景点表"))

        # 2. 导入新数据
        IMAGE_BASE_PATH = options['image_dir']
        stats = {
            'created': 0,
            'images_added': 0,
            'errors': 0
        }

        for spot_data in red_spots_data:
            try:
                # 处理城市
                city, _ = City.objects.get_or_create(
                    name=spot_data['city'],
                    defaults={
                        'code': spot_data['city'][:2].lower(),
                        'description': f"{spot_data['city']}红色旅游城市",
                        'is_hot': spot_data['city'] in ['济南市', '青岛市', '烟台市']
                    }
                )

                # 处理门票价格
                ticket_price = 0.0
                if '免费' not in spot_data.get('ticket_info', ''):
                    try:
                        ticket_price = float(''.join(
                            c for c in spot_data['ticket_info'] if c.isdigit() or c == '.'
                        ))
                    except (ValueError, TypeError):
                        ticket_price = 0.0

                # 创建景点
                attraction, created = Attraction.objects.get_or_create(
                    name=spot_data['name'],
                    city=city,
                    defaults={
                        'description': spot_data['description'],
                        'short_desc': spot_data['short_desc'],
                        'address': spot_data['address'],
                        'latitude': spot_data['latitude'],
                        'longitude': spot_data['longitude'],
                        'ticket_price': ticket_price,
                        'ticket_info': spot_data.get('ticket_info', ''),
                        'open_hours': spot_data['open_hours'],
                        'tags': spot_data['tags'],
                        'history': spot_data.get('history', ''),
                        'history_significance': spot_data.get('history_significance', ''),
                        'learning_point': spot_data.get('learning_point', ''),
                        'is_featured': spot_data['is_featured']
                    }
                )

                if created:
                    stats['created'] += 1
                    self.stdout.write(f"创建景点: {spot_data['name']}")
                else:
                    self.stdout.write(f"已存在景点: {spot_data['name']}")

                # 处理图片 - 使用景点名称+.png作为文件名
                image_filename = f"{spot_data['name']}.png"
                image_path = os.path.join(IMAGE_BASE_PATH, image_filename)

                self.stdout.write(f"正在查找图片: {image_path}")

                if os.path.exists(image_path):
                    if not attraction.image:  # 如果景点还没有图片才添加
                        with open(image_path, 'rb') as f:
                            attraction.image.save(
                                image_filename,
                                File(f),
                                save=True
                            )
                        stats['images_added'] += 1
                        self.stdout.write(self.style.SUCCESS(f"√ 成功添加图片: {spot_data['name']}"))
                    else:
                        self.stdout.write(self.style.WARNING(f"- 景点已有图片，跳过: {spot_data['name']}"))
                else:
                    self.stdout.write(self.style.WARNING(f"× 图片不存在: {image_filename}"))

            except Exception as e:
                stats['errors'] += 1
                self.stdout.write(self.style.ERROR(f"! 导入失败: {spot_data['name']} - {str(e)}"))
                continue

        # 输出结果
        self.stdout.write("\n" + "=" * 50)
        self.stdout.write(self.style.SUCCESS(
            f"导入结果统计:\n"
            f"• 新建景点: {stats['created']}个\n"
            f"• 添加图片: {stats['images_added']}张\n"
            f"• 失败记录: {stats['errors']}个"
        ))
        self.stdout.write("=" * 50)

# 数据定义（保持不变）
red_spots_data = [
    {
        "name": "台儿庄大战纪念馆",
        "city": "枣庄市",
        "description": "台儿庄大战纪念馆是为纪念1938年台儿庄战役而建，展示了大量珍贵的历史照片和文物。",
        "history_significance": "1938年3-4月，中国军队在台儿庄地区歼灭日军1万余人，是抗战初期正面战场首次重大胜利。纪念馆1993年建成，占地3400平方米。",
        "learning_point": "学习中国军队英勇抗战精神，了解正面战场重大胜利的历史意义",
        "short_desc": "纪念1938年台儿庄战役的专题纪念馆",
        "address": "山东省枣庄市台儿庄区沿河南路6号",
        "latitude": 34.5628,
        "longitude": 117.7389,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:30-17:30",
        "image": "attractions/taierzhuang.jpg",
        "tags": ["memorial", "红色旅游", "抗日战争"],
        "is_featured": True
    },
    {
        "name": "孟良崮战役遗址",
        "city": "临沂市",
        "description": "孟良崮战役遗址包含纪念馆、烈士陵园和战场遗迹，通过实物和场景复原展示战役全过程。",
        "history_significance": "1947年5月，华东野战军全歼国民党军整编74师，击毙师长张灵甫。此役扭转华东战局，遗址现存战壕、指挥所等遗迹。",
        "learning_point": "学习解放军英勇作战精神，了解运动战歼灭战的经典战例",
        "short_desc": "解放战争重要战役遗址",
        "address": "山东省临沂市蒙阴县垛庄镇",
        "latitude": 35.4025,
        "longitude": 117.9867,
        "ticket_info": "门票50元",
        "open_hours": "08:30-17:00",
        "image": "attractions/menglianggu.jpg",
        "tags": ["revolution", "红色旅游", "解放战争"],
        "is_featured": True
    },
    {
        "name": "华东革命烈士陵园",
        "city": "临沂市",
        "description": "华东地区规模最大的革命烈士纪念地，含革命烈士纪念塔、纪念馆和6万烈士墓区。",
        "history_significance": "始建于1949年，占地288亩。安葬着包括罗炳辉、王麓水等著名烈士，毛泽东题写'革命烈士纪念塔'。",
        "learning_point": "缅怀革命先烈，学习无私奉献精神",
        "short_desc": "安葬6万余名革命烈士的陵园",
        "address": "山东省临沂市兰山区陵园前街4号",
        "latitude": 35.0516,
        "longitude": 118.3439,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:00-17:00",
        "image": "attractions/huadong_martyrs.jpg",
        "tags": ["martyrs", "红色旅游", "爱国主义教育"],
        "is_featured": True
    },
    {
        "name": "济南战役纪念馆",
        "city": "济南市",
        "description": "通过文物、图片和全景画展示1948年济南战役，包含攻城突破口遗址和英烈事迹展区。",
        "history_significance": "1948年9月16-24日，华东野战军攻克济南，歼敌10万。纪念馆2003年开放，全景画高18米、周长128米。",
        "learning_point": "学习解放军攻坚精神，了解城市攻坚战的历史经验",
        "short_desc": "全景展示济南战役历史的纪念馆",
        "address": "济南市市中区英雄山路18号",
        "latitude": 36.6186,
        "longitude": 117.0014,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/jinan_battle.jpg",
        "tags": ["memorial", "红色旅游", "解放战争"],
        "is_featured": True
    },
    {
        "name": "沂蒙革命纪念馆",
        "city": "临沂市",
        "description": "全面展示沂蒙革命根据地历史，含红嫂厅、支前厅等专题展区，运用多媒体技术还原历史场景。",
        "history_significance": "沂蒙山区是抗战时期山东党政军机关驻地，2014年建馆，收藏文物500余件，包括'沂蒙母亲'王换于相关文物。",
        "learning_point": "学习沂蒙精神，了解革命根据地建设历史",
        "short_desc": "展示沂蒙革命老区历史的专题纪念馆",
        "address": "山东省临沂市兰山区银雀山路与沂蒙路交汇处",
        "latitude": 35.0522,
        "longitude": 118.3478,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/yimeng_revolution.jpg",
        "tags": ["museum", "红色旅游", "革命根据地"],
        "is_featured": True
    },
    {
        "name": "铁道游击队纪念园",
        "city": "枣庄市",
        "description": "包含纪念碑、影视厅和微山湖抗战场景复原，展示铁道游击队扒火车、炸桥梁的传奇历史。",
        "history_significance": "1940-1945年，鲁南铁道大队在津浦铁路沿线作战百余次，小说《铁道游击队》原型。纪念园2005年建成。",
        "learning_point": "学习游击战术，了解敌后抗战的艰苦卓绝",
        "short_desc": "纪念抗日战争时期铁道游击队的专题园区",
        "address": "山东省枣庄市薛城区临山路",
        "latitude": 34.8025,
        "longitude": 117.2639,
        "ticket_info": "门票30元",
        "open_hours": "08:30-17:30",
        "image": "attractions/railway_guerrillas.jpg",
        "tags": ["memorial", "红色旅游", "游击队"],
        "is_featured": True
    },
    {
        "name": "八路军115师司令部旧址",
        "city": "临沂市",
        "description": "完整保留抗战时期八路军办公场所，含罗荣桓故居、作战指挥室等历史原貌陈列。",
        "history_significance": "1941-1945年八路军115师师部驻地，现存四合院建筑群54间，2006年被列为全国重点文物保护单位。",
        "learning_point": "学习八路军抗战历史，了解敌后抗日根据地建设",
        "short_desc": "抗日战争时期八路军115师司令部驻地",
        "address": "山东省临沂市莒南县大店镇",
        "latitude": 35.1758,
        "longitude": 118.8267,
        "ticket_info": "门票40元",
        "open_hours": "08:30-17:00",
        "image": "attractions/115division.jpg",
        "tags": ["revolution", "红色旅游", "八路军"],
        "is_featured": True
    },
    {
        "name": "莱芜战役纪念馆",
        "city": "济南市",
        "description": "通过全景画、文物和沙盘展示1947年莱芜战役，包含陈毅、粟裕指挥所复原场景。",
        "history_significance": "1947年2月华东野战军歼灭国民党军5.6万，创运动战典范。纪念馆全景画高17米，周长120米。",
        "learning_point": "学习运动战战术，了解解放战争重大战役",
        "short_desc": "展示1947年莱芜战役的专题馆",
        "address": "济南市莱芜区英雄北路",
        "latitude": 36.2139,
        "longitude": 117.6767,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:30-17:00",
        "image": "attractions/laiwu_battle.jpg",
        "tags": ["memorial", "红色旅游", "解放战争"],
        "is_featured": True
    },
    {
        "name": "红嫂纪念馆",
        "city": "临沂市",
        "description": "展示明德英、王换于等沂蒙红嫂感人事迹，含乳汁救伤员场景复原和400余件革命文物。",
        "history_significance": "抗战时期沂蒙妇女用乳汁救治伤员、抚养革命后代。2004年建馆，江泽民题写馆名。",
        "learning_point": "学习沂蒙红嫂无私奉献精神，了解军民鱼水情",
        "short_desc": "纪念沂蒙红嫂感人事迹的专题馆",
        "address": "山东省临沂市沂南县马牧池乡",
        "latitude": 35.4625,
        "longitude": 118.2872,
        "ticket_info": "门票30元",
        "open_hours": "08:30-17:00",
        "image": "attractions/red_sisters.jpg",
        "tags": ["memorial", "红色旅游", "革命精神"],
        "is_featured": True
    },
    {
        "name": "大青山突围战遗址",
        "city": "临沂市",
        "description": "保存战壕、指挥部等战场遗迹，纪念馆通过影像资料展示1941年突围战全过程。",
        "history_significance": "1941年11月，抗大一分校在此掩护机关突围，以牺牲300人代价保护了山东党政军领导机关。",
        "learning_point": "学习革命先烈英勇牺牲精神，了解突围战历史",
        "short_desc": "抗日战争时期著名突围战遗址",
        "address": "山东省临沂市费县薛庄镇",
        "latitude": 35.3528,
        "longitude": 117.9875,
        "ticket_info": "门票30元",
        "open_hours": "08:30-17:00",
        "image": "attractions/daqingshan.jpg",
        "tags": ["revolution", "红色旅游", "抗日战争"],
        "is_featured": True
    },
    {
        "name": "胶东革命纪念馆",
        "city": "烟台市",
        "description": "系统展示胶东地区革命史，含许世友指挥所复原、地下印刷所场景等特色展区。",
        "history_significance": "胶东地区是山东革命重要根据地，纪念馆2014年开放，展出历史照片1200余幅，文物300余件。",
        "learning_point": "学习胶东革命历史，了解根据地建设经验",
        "short_desc": "展示胶东地区革命历史的专题纪念馆",
        "address": "山东省烟台市芝罘区南大街61号",
        "latitude": 37.5328,
        "longitude": 121.3850,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/jiaodong.jpg",
        "tags": ["museum", "红色旅游", "革命历史"],
        "is_featured": True
    },
    {
        "name": "解放阁",
        "city": "济南市",
        "description": "济南战役攻城突破口遗址上建立的纪念性建筑，登阁可俯瞰护城河及老城区风貌。",
        "history_significance": "1948年解放军由此突破城墙，1965年建阁，1986年改建为战役纪念建筑，陈毅题写阁名。",
        "learning_point": "了解济南战役突破城垣历史，学习攻坚精神",
        "short_desc": "济南战役突破城垣遗址纪念建筑",
        "address": "济南市历下区黑虎泉北路",
        "latitude": 36.6667,
        "longitude": 117.0333,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:30-17:00",
        "image": "attractions/jiefangge.jpg",
        "tags": ["memorial", "红色旅游", "解放战争"],
        "is_featured": True
    },
    {
        "name": "天福山起义纪念馆",
        "city": "威海市",
        "description": "纪念1937年天福山起义，展示山东人民抗日救国军第三军创建历程和历史文物。",
        "history_significance": "1937年12月24日，胶东特委在此发动起义，建立党领导的第一支胶东人民抗日武装。纪念馆1985年建成。",
        "learning_point": "学习武装起义历史，了解早期抗日武装创建",
        "short_desc": "纪念1937年天福山起义的专题馆",
        "address": "山东省威海市文登区文登营镇",
        "latitude": 37.2528,
        "longitude": 122.0567,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/tianfushan.jpg",
        "tags": ["memorial", "红色旅游", "武装起义"],
        "is_featured": True
    },
    {
        "name": "沂蒙山小调诞生地",
        "city": "临沂市",
        "description": "《沂蒙山小调》诞生地纪念馆展示歌曲创作背景和手稿，复原抗大文工团创作场景。",
        "history_significance": "1940年抗大一分校文工团在此创作《沂蒙山小调》，后成为歌颂沂蒙精神的代表性歌曲。",
        "learning_point": "了解革命文艺创作背景，学习沂蒙精神",
        "short_desc": "著名革命歌曲《沂蒙山小调》的创作地",
        "address": "山东省临沂市费县薛庄镇",
        "latitude": 35.3828,
        "longitude": 117.9875,
        "ticket_info": "门票20元",
        "open_hours": "08:30-17:00",
        "image": "attractions/yimeng_song.jpg",
        "tags": ["revolution", "红色旅游", "革命文化"],
        "is_featured": True
    },
    {
        "name": "鲁南人民抗日武装起义纪念馆",
        "city": "枣庄市",
        "description": "通过历史照片和文物展示1938年鲁南人民抗日武装起义全过程，含起义领导人雕塑群。",
        "history_significance": "1938年5月中共苏鲁豫皖边区特委在此发动起义，创建鲁南抗日根据地。纪念馆2015年建成。",
        "learning_point": "学习武装起义历史，了解早期抗日根据地创建",
        "short_desc": "纪念1938年鲁南人民抗日武装起义的专题馆",
        "address": "山东省枣庄市山亭区北庄镇",
        "latitude": 35.2025,
        "longitude": 117.5639,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/lunan_uprising.jpg",
        "tags": ["memorial", "红色旅游", "武装起义"],
        "is_featured": True
    },
    {
        "name": "胶东抗日烈士陵园",
        "city": "烟台市",
        "description": "胶东地区规模最大的抗日烈士纪念地，含烈士纪念碑、纪念馆和3000余座烈士墓。",
        "history_significance": "建于1945年，安葬着理琪、林江等著名烈士。主纪念碑高21米，象征21响礼炮致敬英烈。",
        "learning_point": "缅怀抗日先烈，学习革命精神",
        "short_desc": "纪念胶东抗日斗争中牺牲烈士的陵园",
        "address": "山东省烟台市牟平区龙泉镇",
        "latitude": 37.3828,
        "longitude": 121.6872,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:00-17:00",
        "image": "attractions/jiaodong_martyrs.jpg",
        "tags": ["martyrs", "红色旅游", "抗日战争"],
        "is_featured": True
    },
    {
        "name": "山东省政府旧址",
        "city": "临沂市",
        "description": "中国共产党领导的第一个省级人民政府旧址，复原省政府办公厅、会议室等历史场景。",
        "history_significance": "1945年8月13日山东省政府在此成立，是中国共产党领导的第一个省级政权。现存四合院建筑群42间。",
        "learning_point": "了解早期人民政权建设历史，学习民主政府经验",
        "short_desc": "中国共产党领导的第一个省级政府旧址",
        "address": "山东省临沂市莒南县大店镇",
        "latitude": 35.1758,
        "longitude": 118.8267,
        "ticket_info": "门票30元",
        "open_hours": "08:30-17:00",
        "image": "attractions/shandong_gov.jpg",
        "tags": ["revolution", "红色旅游", "政府旧址"],
        "is_featured": True
    },
    {
        "name": "徂徕山抗日武装起义旧址",
        "city": "泰安市",
        "description": "保存起义指挥部旧址、誓师大会遗址等，纪念馆展示起义文物和历史照片200余件。",
        "history_significance": "1938年1月1日中共山东省委在此发动起义，打响省委独立领导山东抗战第一枪。现存石刻标语30余处。",
        "learning_point": "学习武装起义历史，了解早期抗日斗争",
        "short_desc": "1938年徂徕山抗日武装起义发生地",
        "address": "山东省泰安市岱岳区徂徕镇",
        "latitude": 36.1028,
        "longitude": 117.2567,
        "ticket_info": "门票20元",
        "open_hours": "08:30-17:00",
        "image": "attractions/culai_uprising.jpg",
        "tags": ["revolution", "红色旅游", "武装起义"],
        "is_featured": True
    },
    {
        "name": "黑铁山抗日武装起义旧址",
        "city": "淄博市",
        "description": "起义指挥部旧址复原展示，含起义使用过的武器、文件等文物，配套建有纪念广场。",
        "history_significance": "1937年12月26日中共山东省委在此发动起义，是山东最早的抗日武装起义之一。纪念馆1985年建成。",
        "learning_point": "学习早期抗日武装起义历史，了解游击战争经验",
        "short_desc": "1937年黑铁山抗日武装起义发生地",
        "address": "山东省淄博市张店区卫固镇",
        "latitude": 36.8528,
        "longitude": 118.0567,
        "ticket_info": "门票20元",
        "open_hours": "08:30-17:00",
        "image": "attractions/heitie_mountain.jpg",
        "tags": ["revolution", "红色旅游", "武装起义"],
        "is_featured": True
    },
    {
        "name": "马石山十勇士纪念馆",
        "city": "威海市",
        "description": "通过雕塑、影像展示十勇士掩护群众突围事迹，收藏烈士遗物和战斗武器30余件。",
        "history_significance": "1942年冬，十位八路军战士为掩护群众突围与日军激战牺牲。纪念馆2014年建成，习近平曾视察。",
        "learning_point": "学习革命战士舍己为人精神，了解军民鱼水情",
        "short_desc": "纪念1942年十位英勇牺牲的八路军战士",
        "address": "山东省威海市乳山市马石山",
        "latitude": 36.9528,
        "longitude": 121.5872,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:30-17:00",
        "image": "attractions/mashi_mountain.jpg",
        "tags": ["memorial", "红色旅游", "英雄事迹"],
        "is_featured": True
    },
    {
        "name": "沂蒙革命根据地旧址群",
        "city": "临沂市",
        "description": "包含中共山东分局、八路军115师司令部等12处革命旧址，配套建设红色体验区。",
        "history_significance": "抗战时期山东党政军机关驻地，现存革命旧址42处，被誉为'山东的小延安'。2015年整体保护开发。",
        "learning_point": "全面了解沂蒙革命根据地历史，学习根据地建设经验",
        "short_desc": "包含多处重要革命旧址的遗址群",
        "address": "山东省临沂市沂南县",
        "latitude": 35.5522,
        "longitude": 118.4478,
        "ticket_info": "门票60元",
        "open_hours": "08:30-17:00",
        "image": "attractions/yimeng_base.jpg",
        "tags": ["revolution", "红色旅游", "旧址群"],
        "is_featured": True
    },
    {
        "name": "英雄山革命烈士陵园",
        "city": "济南市",
        "description": "济南规模最大的革命烈士纪念地，含烈士墓区、革命烈士纪念塔和济南战役纪念馆。",
        "history_significance": "始建于1949年，安葬1502名烈士。1968年毛泽东题词'革命烈士纪念塔'，塔高34.328米。",
        "learning_point": "缅怀革命先烈，学习革命精神",
        "short_desc": "济南规模最大的革命烈士陵园",
        "address": "济南市市中区英雄山路18号",
        "latitude": 36.6186,
        "longitude": 117.0014,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "全天开放",
        "image": "attractions/hero_mountain.jpg",
        "tags": ["martyrs", "红色旅游", "烈士陵园"],
        "is_featured": True
    },
    {
        "name": "五三惨案纪念园",
        "city": "济南市",
        "description": "含'五三'纪念碑、纪念亭和蔡公时纪念馆，通过历史照片展示1928年惨案真相。",
        "history_significance": "1928年5月3日日军杀害中国外交官蔡公时及军民6000余人。纪念园1995年建成，存有惨案见证钟。",
        "learning_point": "了解近代屈辱历史，激发爱国情怀",
        "short_desc": "纪念1928年'五三惨案'的遗址",
        "address": "济南市趵突泉公园内",
        "latitude": 36.6667,
        "longitude": 117.0333,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:00-18:00",
        "image": "attractions/wusan_memorial.jpg",
        "tags": ["memorial", "红色旅游", "历史事件"],
        "is_featured": True
    },
    {
        "name": "大峰山革命遗址",
        "city": "济南市",
        "description": "包含中共长清县委旧址、八路军山东纵队第六支队成立旧址等8处革命遗迹。",
        "history_significance": "1938-1945年长清县革命活动中心，现存石屋、地道等遗址，被誉为'长清的小延安'。",
        "learning_point": "了解地方革命历史，学习地下斗争经验",
        "short_desc": "抗战时期长清县革命活动中心遗址",
        "address": "济南市长清区孝里镇",
        "latitude": 36.4028,
        "longitude": 116.7567,
        "ticket_info": "门票50元",
        "open_hours": "08:30-17:00",
        "image": "attractions/dafeng_mountain.jpg",
        "tags": ["revolution", "红色旅游", "遗址群"],
        "is_featured": True
    },
    {
        "name": "辛锐纪念馆",
        "city": "济南市",
        "description": "展示革命烈士辛锐的书画作品、生平事迹，复原其创作环境和牺牲场景。",
        "history_significance": "辛锐（1918-1941）为著名革命艺术家，在沂蒙山区反扫荡中壮烈牺牲。2014年在其家乡建馆。",
        "learning_point": "学习革命艺术家的爱国精神，了解抗战文化工作",
        "short_desc": "纪念革命艺术家辛锐的专题馆",
        "address": "济南市章丘区刁镇",
        "latitude": 36.7028,
        "longitude": 117.5267,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/xinrui_memorial.jpg",
        "tags": ["memorial", "红色旅游", "革命烈士"],
        "is_featured": True
    },
    {
        "name": "历城革命烈士陵园",
        "city": "济南市",
        "description": "安葬历城战役等各时期烈士1276名，建有22米高革命烈士纪念碑和革命历史展馆。",
        "history_significance": "始建于1955年，2014年改造升级。园内革命历史展馆详载历城区重大战役史料。",
        "learning_point": "缅怀地方革命先烈，了解历城革命历史",
        "short_desc": "安葬1276名革命烈士的陵园",
        "address": "济南市历城区英雄山路",
        "latitude": 36.6828,
        "longitude": 117.0767,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:00-17:00",
        "image": "attractions/licheng_martyrs.jpg",
        "tags": ["martyrs", "红色旅游", "烈士陵园"],
        "is_featured": True
    },
    {
        "name": "济南市党史陈列馆",
        "city": "济南市",
        "description": "系统展示济南党组织1921年成立以来的发展历程，含珍贵党史档案500余件。",
        "history_significance": "2011年建党90周年时建成开放，2021年完成展陈升级，包括'齐鲁曙光''浴血奋战'等六大展区。",
        "learning_point": "系统学习济南党史，了解地方党组织发展历程",
        "short_desc": "展示济南党组织发展历程的专题馆",
        "address": "济南市历下区经十路21028号",
        "latitude": 36.6528,
        "longitude": 117.0267,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-17:00",
        "image": "attractions/jinan_party.jpg",
        "tags": ["museum", "红色旅游", "党史教育"],
        "is_featured": True
    },
    {
        "name": "泺口九烈士纪念碑",
        "city": "济南市",
        "description": "纪念1933年8月被国民党杀害的9名中共山东地下党领导人，建有12米高纪念碑和浮雕墙。",
        "history_significance": "1933年山东省委遭破坏，李春亭、段亦民等9人在此英勇就义。1989年立碑纪念，碑文由谷牧题写。",
        "learning_point": "学习地下党人英勇不屈精神，了解白色恐怖时期斗争历史",
        "short_desc": "纪念1933年牺牲的9名中共地下党领导人",
        "address": "济南市天桥区泺口街道黄河大坝南侧",
        "latitude": 36.7028,
        "longitude": 116.9867,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "全天开放",
        "image": "attractions/luokou_martyrs.jpg",
        "tags": ["martyrs", "红色旅游", "历史事件"],
        "is_featured": True
    },
    {
        "name": "平阴县委旧址纪念馆",
        "city": "济南市",
        "description": "抗日战争时期平阴县委驻地，复原县委办公室、地道等历史场景，展示抗战文物200余件。",
        "history_significance": "1939-1942年间中共平阴县委在此领导抗日斗争，现存石砌民居6间及抗战时期地道遗址。",
        "learning_point": "了解地方党组织抗战历史，学习地下工作方法",
        "short_desc": "抗战时期平阴县委驻地旧址",
        "address": "济南市平阴县孔村镇",
        "latitude": 36.2528,
        "longitude": 116.4567,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:30-17:00",
        "image": "attractions/pingyin_memorial.jpg",
        "tags": ["revolution", "红色旅游", "县委旧址"],
        "is_featured": True
    },
    {
        "name": "历城抗日纪念馆",
        "city": "济南市",
        "description": "依托大南营战斗遗址建设，展示历城军民1937-1945年抗日斗争史实和22处抗战石刻标语。",
        "history_significance": "1944年八路军在此歼灭日军一个小队，现存战场遗址和22处抗战时期石刻标语。",
        "learning_point": "了解地方抗日历史，学习军民团结抗战经验",
        "short_desc": "展示历城军民抗日斗争史的专题馆",
        "address": "济南市历城区西营镇",
        "latitude": 36.5528,
        "longitude": 117.1267,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/licheng_anti_japanese.jpg",
        "tags": ["memorial", "红色旅游", "抗日战争"],
        "is_featured": True
    },
    {
        "name": "商河县革命烈士陵园",
        "city": "济南市",
        "description": "安葬抗日战争、解放战争时期烈士863名，中央矗立19.49米高纪念碑和革命历史展馆。",
        "history_significance": "始建于1955年，2015年改建。园内'商河革命历史展馆'详载本县重大战役史料。",
        "learning_point": "缅怀地方革命先烈，了解商河革命历史",
        "short_desc": "安葬863名革命烈士的陵园",
        "address": "济南市商河县青年路东首",
        "latitude": 37.3028,
        "longitude": 117.1567,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "08:00-18:00",
        "image": "attractions/shanghe_martyrs.jpg",
        "tags": ["martyrs", "红色旅游", "烈士陵园"],
        "is_featured": True
    },
    {
        "name": "钢城区莱芜战役指挥所旧址",
        "city": "济南市",
        "description": "陈毅、粟裕在此指挥莱芜战役的四合院旧址，保留作战地图、电报机等历史场景。",
        "history_significance": "1947年2月华东野战军前线指挥所设此，现为省级文保单位，院内保留百年古梨树。",
        "learning_point": "了解战役指挥艺术，学习军事指挥经验",
        "short_desc": "莱芜战役前线指挥所旧址",
        "address": "济南市钢城区辛庄镇石湾子村",
        "latitude": 36.1028,
        "longitude": 117.8067,
        "ticket_info": "门票15元",
        "open_hours": "08:30-17:00",
        "image": "attractions/laiwu_command.jpg",
        "tags": ["revolution", "红色旅游", "战役遗址"],
        "is_featured": True
    },
    {
        "name": "济南乡师党史陈列室",
        "city": "济南市",
        "description": "山东省立乡村师范学校旧址，山东党组织重要活动地，现存'红色乡师'专题展和地下印刷所复原。",
        "history_significance": "1932-1937年间该校培养200余名党员，赵健民、姚仲明等曾在此开展地下工作。",
        "learning_point": "了解党的地下工作历史，学习革命教育经验",
        "short_desc": "山东党组织重要活动地旧址",
        "address": "济南市天桥区明湖西路",
        "latitude": 36.6828,
        "longitude": 116.9967,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "预约开放",
        "image": "attractions/jinan_normal_school.jpg",
        "tags": ["education", "红色旅游", "党史教育"],
        "is_featured": True
    },
    {
        "name": "章丘第一支抗日武装纪念馆",
        "city": "济南市",
        "description": "展示1937年成立的章丘人民抗日救国军斗争史，含武器、文件等实物展品和战斗场景复原。",
        "history_significance": "1937年12月李曼村等在此建立章丘首支抗日武装，后编入八路军山东纵队。",
        "learning_point": "了解地方抗日武装创建历史，学习早期抗战经验",
        "short_desc": "展示章丘首支抗日武装斗争史的专题馆",
        "address": "济南市章丘区普集街道三山峪村",
        "latitude": 36.7528,
        "longitude": 117.5267,
        "ticket_info": "凭身份证免费参观",
        "open_hours": "09:00-16:30",
        "image": "attractions/zhangqiu_anti_japanese.jpg",
        "tags": ["memorial", "红色旅游", "武装起义"],
        "is_featured": True
    }
]