def test_centroid(self): r = session.query(Road).filter(Road.road_name=='Graeme Ave').one() l = session.query(Lake).filter(Lake.lake_name=='Lake Blue').one() ok_(not session.scalar(functions.wkt(r.road_geom.centroid))) eq_(session.scalar(functions.wkt(l.lake_geom.centroid)), 'POINT (-88.921453826951719 43.019149768468026)') ok_(session.query(Spot).filter(Spot.spot_location.centroid == WKTSpatialElement('POINT(-88.5945861592357 42.9480095987261)')).first() is None) ok_(session.scalar(functions.wkt(functions.centroid('MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, 0 1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )'))) is None)
def test_centroid(self): r = session.query(Road).filter(Road.road_name=='Graeme Ave').one() l = session.query(Lake).filter(Lake.lake_name=='Lake Blue').one() eq_(session.scalar(functions.wkt(r.road_geom.centroid)), u'POINT(-88.5889975373709 42.941769988935)') eq_(session.scalar(functions.wkt(l.lake_geom.centroid)), u'POINT(-88.9214538261088 43.0191497691548)') ok_(session.query(Spot).filter(Spot.spot_location.centroid == WKTSpatialElement('POINT(-88.5945861592357 42.9480095987261)')).first() is not None) eq_(session.scalar(functions.wkt(functions.centroid('MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, 0 1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )'))), u'POINT(2.30769230769231 3.30769230769231)')
def test_centroid(self): r = session.query(Road).filter(Road.road_name=='Graeme Ave').one() l = session.query(Lake).filter(Lake.lake_name=='Lake Blue').one() eq_(session.scalar(functions.wkt(r.road_geom.centroid)), 'POINT(-88.5889975373709 42.941769988935)') eq_(session.scalar(functions.wkt(l.lake_geom.centroid)), 'POINT(-88.9214538261088 43.0191497691548)') ok_(session.query(Spot).filter(Spot.spot_location.centroid == WKTSpatialElement('POINT(-88.5945861592357 42.9480095987261)')).first() is not None) eq_(session.scalar(functions.wkt(functions.centroid('MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, 0 1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )'))), 'POINT(2.30769230769231 3.30769230769231)')
def test_centroid(self): r = session.query(Road).filter(Road.road_name=='Graeme Ave').one() l = session.query(Lake).filter(Lake.lake_name=='Lake Blue').one() # Oracle does not support centroid for LineString eq_(session.scalar(functions.wkt(r.road_geom.centroid)), None) eq_(session.scalar(functions.wkt(l.lake_geom.centroid)), u'POINT (-88.9213649409212 43.0190392609092)') ok_(session.query(Spot).filter(functions.wkt(Spot.spot_location.centroid) == 'POINT (-88.5945861592357 42.9480095987261)').first() is not None) eq_(session.scalar(functions.wkt(functions.centroid('MULTIPOINT((-1 0), (-1 2), (-1 3), (-1 4), (-1 7), (0 1), (0 3), (1 1), (2 0), (6 0), (7 8), (9 8), (10 6) )', diminfo_))), u'POINT (2.30460703912783 3.31788085910597)')
def test_centroid(self): r = session.query(Road).filter(Road.road_name == 'Graeme Ave').one() l = session.query(Lake).filter(Lake.lake_name == 'Lake Blue').one() ok_(not session.scalar(functions.wkt(r.road_geom.centroid))) eq_(session.scalar(functions.wkt(l.lake_geom.centroid)), u'POINT (-88.921453826951719 43.019149768468026)') ok_( session.query(Spot). filter(Spot.spot_location.centroid == WKTSpatialElement( 'POINT(-88.5945861592357 42.9480095987261)')).first() is None) ok_( session.scalar( functions.wkt( functions.centroid( 'MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, 0 1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )' ))) is None)