class SegmentToPano3(db.Model):
linkId = db.Column(db.Integer, primary_key=True)
segmentId = db.Column(db.Integer,
db.ForeignKey(SidewalkSegment3.segmentId))
whichEndpoint = db.Column(db.Text())
panoId = db.Column(db.Integer)
headingDegree = db.Column(db.Float)
class SidewalkSegment2(db.Model):
segmentId = db.Column(db.Integer, primary_key=True)
directionInd = db.Column(db.String(length=50), primary_key=True)
linearId = db.Column(db.Integer, nullable=False)
streetName = db.Column(db.Text(), nullable=True)
startLat = db.Column(db.Float, nullable=False)
startLong = db.Column(db.Float, nullable=False)
endLat = db.Column(db.Float, nullable=False)
endLong = db.Column(db.Float, nullable=False)
whichArcgisFile = db.Column(db.String(length=10))
geoJson = db.Column(db.JSON, nullable=False)
class PanoFeature(db.Model):
id = db.Column(db.Integer, primary_key=True)
panoId = db.Column(db.String(length=50))
linearId = db.Column(db.Integer, nullable=False)
headingDegree = db.Column(db.Float, nullable=False)
label = db.Column(db.Integer, nullable=False)
source = db.Column(db.Text(), nullable=False)
updateTs = db.Column(db.DateTime(), server_default=func.now())
class InSituFeedback(db.Model):
id = db.Column(db.Integer, primary_key=True)
lat = db.Column(db.Float, nullable=False)
long = db.Column(db.Float, nullable=False)
mode = db.Column(db.String(length=50), nullable=False)
label = db.Column(db.String(length=50), nullable=False)
updateTs = db.Column(db.DateTime(), server_default=func.now())
def __init__(self, lat, long, mode, label):
self.lat = lat
self.long = long
self.mode = mode
self.label = label
class Pano(db.Model):
panoId = db.Column(db.String(length=50), primary_key=True)
headingDegree = db.Column(db.Float, primary_key=True)
linearId = db.Column(db.Integer, nullable=False)
lat = db.Column(db.Float, nullable=False)
long = db.Column(db.Float, nullable=False)
class SidewalkSegment4(db.Model):
segmentId = db.Column(db.Integer, primary_key=True)
directionInd = db.Column(db.String(length=50), primary_key=True)
roadObjectId = db.Column(db.Integer, nullable=False)
streetName = db.Column(db.Text(), nullable=True)
startLat = db.Column(db.Float, nullable=False)
startLong = db.Column(db.Float, nullable=False)
endLat = db.Column(db.Float, nullable=False)
endLong = db.Column(db.Float, nullable=False)
whichArcgisFile = db.Column(db.String(length=10))
roadGrade = db.Column(db.Float, nullable=False)
geoJson = db.Column(db.JSON, nullable=False)
updateTs = db.Column(db.DateTime(), server_default=func.now())
