1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
|
s = box.schema.space.create('spatial')
_ = s:create_index('primary')
spatial = s:create_index('spatial', { type = 'rtree', unique = false, parts = {2, 'array'}})
spatial.type
s:insert{1,{0.0,0.0}}
s:insert{2,{0.0,10.0}}
s:insert{3,{0.0,50.0}}
s:insert{4,{10.0,0.0}}
s:insert{5,{50.0,0.0}}
s:insert{6,{10.0,10.0}}
s:insert{7,{10.0,50.0}}
s:insert{8,{50.0,10.0}}
s:insert{9,{50.0,50.0}}
-- select all records
s.index.spatial:select({}, {iterator = 'ALL'})
-- select records belonging to rectangle (0,0,10,10)
s.index.spatial:select({0.0,0.0,10.0,10.0}, {iterator = 'LE'})
-- select records with coordinates (10,10)
s.index.spatial:select({10.0,10.0}, {iterator = 'EQ'})
-- select neighbors of point (5,5)
s.index.spatial:select({5.0,5.0}, {iterator = 'NEIGHBOR'})
s:drop()
s = box.schema.space.create('spatial')
_ = s:create_index('primary')
spatial = s:create_index('spatial', { type = 'rtree', unique = false, parts = {2, 'array'}, dimension = 8})
spatial.type
s:insert{ 1,{0, 0, 0, 0, 0, 0, 0, 0}}
s:insert{ 2,{10, 0, 0, 0, 0, 0, 0, 0}}
s:insert{ 3,{0, 10, 0, 0, 0, 0, 0, 0}}
s:insert{ 4,{0, 0, 10, 0, 0, 0, 0, 0}}
s:insert{ 5,{0, 0, 0, 10, 0, 0, 0, 0}}
s:insert{ 6,{0, 0, 0, 0, 10, 0, 0, 0}}
s:insert{ 7,{0, 0, 0, 0, 0, 10, 0, 0}}
s:insert{ 8,{0, 0, 0, 0, 0, 0, 10, 0}}
s:insert{ 9,{0, 0, 0, 0, 0, 0, 0, 10}}
s:insert{10,{50, 0, 0, 0, 0, 0, 0, 0}}
s:insert{11,{0, 50, 0, 0, 0, 0, 0, 0}}
s:insert{12,{0, 0, 50, 0, 0, 0, 0, 0}}
s:insert{13,{0, 0, 0, 50, 0, 0, 0, 0}}
s:insert{14,{0, 0, 0, 0, 50, 0, 0, 0}}
s:insert{15,{0, 0, 0, 0, 0, 50, 0, 0}}
s:insert{16,{0, 0, 0, 0, 0, 0, 50, 0}}
s:insert{17,{0, 0, 0, 0, 0, 0, 0, 50}}
s:insert{18,{10, 10, 10, 10, 10, 10, 10, 10}}
s:insert{19,{10, 50, 10, 50, 10, 50, 10, 50}}
s:insert{20,{0, 10, 50, 0, 10, 50, 0, 10}}
p0 = {0, 0, 0, 0, 0, 0, 0, 0}
p5 = {5, 5, 5, 5, 5, 5, 5, 5}
p10 = {10, 10, 10, 10, 10, 10, 10, 10 }
rt0_10 = {0, 0, 0, 0, 0, 0, 0, 0, 10, 10, 10, 10, 10, 10, 10, 10 }
-- select all records
s.index.spatial:select({}, {iterator = 'ALL'})
-- select records belonging to rectangle (0,0,..10,10,..)
s.index.spatial:select(rt0_10, {iterator = 'LE'})
-- select records with coordinates (10,10)
s.index.spatial:select(p10, {iterator = 'EQ'})
-- select neighbors of point (5,5)
s.index.spatial:select(p5, {iterator = 'NEIGHBOR'})
s:drop()
|