# coding: utf-8
"""
四县三种用电土地利用类型模型
Four County Three Type Land Use Model
"""

from sqlalchemy import Column, Integer, String, Float, Numeric
from geoalchemy2.types import Geometry
from app.models.base import Base


class FourCountyLandUse(Base):
    """
    四县三种用电土地利用类型表
    Four County Three Type Land Use Table
    """
    __tablename__ = 'four_county_land'
    __table_args__ = {'comment': '四县三种用电土地利用类型数据'}

    # 主键
    gid = Column(Integer, primary_key=True, autoincrement=True, comment='主键ID')
    
    # 对象标识
    objectid = Column(Integer, name='objectid', comment='对象标识符')
    
    # 标识码
    bsm = Column(String(18), name='bsm', comment='标识码')
    
    # 要素代码
    ysdm = Column(String(10), name='ysdm', comment='要素代码')
    
    # 图斑编号
    tbybh = Column(String(18), name='tbybh', comment='图斑预编号')
    tbbh = Column(String(8), name='tbbh', comment='图斑编号')
    
    # 地类信息
    dlbm = Column(String(5), name='dlbm', comment='地类编码')
    dlmc = Column(String(60), name='dlmc', comment='地类名称')
    
    # 权属信息
    qsxz = Column(String(2), name='qsxz', comment='权属性质')
    qsdwdm = Column(String(19), name='qsdwdm', comment='权属单位代码')
    qsdwmc = Column(String(60), name='qsdwmc', comment='权属单位名称')
    
    # 坐落单位
    zldwdm = Column(String(19), name='zldwdm', comment='坐落单位代码')
    zldwmc = Column(String(60), name='zldwmc', comment='坐落单位名称')
    
    # 面积信息
    tbmj = Column(Numeric(19, 11), name='tbmj', comment='图斑面积')
    kcdlbm = Column(String(5), name='kcdlbm', comment='扣除地类编码')
    kcxs = Column(Numeric(19, 11), name='kcxs', comment='扣除系数')
    kcmj = Column(Numeric(19, 11), name='kcmj', comment='扣除面积')
    tbdlmj = Column(Numeric(19, 11), name='tbdlmj', comment='图斑地类面积')
    
    # 耕地信息
    gdlx = Column(String(2), name='gdlx', comment='耕地类型')
    gdpdjb = Column(String(2), name='gdpdjb', comment='耕地坡度级别')
    xzdwkd = Column(Numeric(19, 11), name='xzdwkd', comment='线状地物宽度')
    
    # 图斑细化
    tbxhdm = Column(String(6), name='tbxhdm', comment='图斑细化代码')
    tbxhmc = Column(String(20), name='tbxhmc', comment='图斑细化名称')
    
    # 种植属性
    zzsxdm = Column(String(6), name='zzsxdm', comment='种植属性代码')
    zzsxmc = Column(String(20), name='zzsxmc', comment='种植属性名称')
    
    # 耕地等别
    gddb = Column(Integer, name='gddb', comment='耕地等别')
    
    # 其他属性
    frdbs = Column(String(1), name='frdbs', comment='非入等标识')
    czcsxm = Column(String(4), name='czcsxm', comment='城镇村属性码')
    sjnf = Column(Integer, name='sjnf', comment='数据年份')
    mssm = Column(String(2), name='mssm', comment='模式识别码')
    hdmc = Column(String(100), name='hdmc', comment='河道名称')
    bz = Column(String(254), name='bz', comment='备注')
    
    # 形状信息
    shape_leng = Column(Numeric(19, 11), name='shape_leng', comment='形状长度')
    shape_le_1 = Column(Numeric(19, 11), name='shape_le_1', comment='形状长度1')
    shape_area = Column(Numeric(19, 11), name='shape_area', comment='形状面积')
    
    # 几何信息 - 使用EPSG:4526坐标系
    geom = Column(
        Geometry('POLYGON', 4526, from_text='ST_GeomFromEWKT', name='geometry'), 
        index=True, 
        comment='几何位置信息-多边形'
    )