block group sqlalchemy model

bg.py

# coding: utf-8
from geoalchemy2 import Geometry
from sqlalchemy import Column, Float, ForeignKey, Text
from sqlalchemy.ext.declarative import declarative_base


Base = declarative_base()
metadata = Base.metadata


class Geoheader(Base):
    __tablename__ = 'geoheader'
    __table_args__ = {u'schema': 'acs2014_5yr'}

    fileid = Column(Text)
    stusab = Column(Text, primary_key=True, nullable=False)
    sumlevel = Column(Text)
    component = Column(Text)
    logrecno = Column(Text, primary_key=True, nullable=False)
    us = Column(Text)
    region = Column(Text)
    division = Column(Text)
    statece = Column(Text)
    state = Column(Text)
    county = Column(Text)
    cousub = Column(Text)
    place = Column(Text)
    tract = Column(Text)
    blkgrp = Column(Text)
    concit = Column(Text)
    aianhh = Column(Text)
    aianhhfp = Column(Text)
    aihhtli = Column(Text)
    aitsce = Column(Text)
    aits = Column(Text)
    anrc = Column(Text)
    cbsa = Column(Text)
    csa = Column(Text)
    metdiv = Column(Text)
    macc = Column(Text)
    memi = Column(Text)
    necta = Column(Text)
    cnecta = Column(Text)
    nectadiv = Column(Text)
    ua = Column(Text)
    blank1 = Column(Text)
    cdcurr = Column(Text)
    sldu = Column(Text)
    sldl = Column(Text)
    blank2 = Column(Text)
    blank3 = Column(Text)
    zcta5 = Column(Text)
    submcd = Column(Text)
    sdelm = Column(Text)
    sdsec = Column(Text)
    sduni = Column(Text)
    ur = Column(Text)
    pci = Column(Text)
    blank4 = Column(Text)
    blank5 = Column(Text)
    puma5 = Column(Text)
    blank6 = Column(Text)
    geoid = Column(Text)
    name = Column(Text)
    bttr = Column(Text)
    btbg = Column(Text)
    blank7 = Column(Text)
    tiger_geoid = Column(Text, unique=True)


class Bg(Geoheader):
    __tablename__ = 'bg'
    __table_args__ = {u'schema': 'tiger2015'}

    geom = Column(Geometry(geometry_type='MULTIPOLYGON', srid=2913))
    statefp = Column(Text)
    countyfp = Column(Text)
    tractce = Column(Text)
    blkgrpce = Column(Text)
    geoid = Column(ForeignKey(u'acs2014_5yr.geoheader.tiger_geoid'), primary_key=True)
    namelsad = Column(Text)
    mtfcc = Column(Text)
    funcstat = Column(Text)
    aland = Column(Float(53))
    awater = Column(Float(53))
    intptlat = Column(Text)
    intptlon = Column(Text)