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 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 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 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())