"delightfully dense" = really intriguing, but I couldn't quite understand it - really hoping for more info
On Wed, Aug 26, 2015, at 03:49 PM, Upayavira wrote: > Darren, > > That was delightfully dense. Do you think you could unpack it a bit > more? Possibly some sample (pseudo) queries? > > Upayavira > > On Wed, Aug 26, 2015, at 03:02 PM, Darren Spehr wrote: > > If you wanted to try a spatial approach that blended times like above, > > you > > could try a polygon of minimum width that spans the globe - this is > > literally using spatial search (geocodes) against time. So in this > > scenario > > you logically subdivide the polygon into 7 distinct regions (for days) > > and > > then within this you can defined, like a timeline, what open and closed > > means. The problem of 3AM is taken care of because of it's continuous > > nature - ie one day is adjacent to the next, with Sunday and Monday > > backing > > up to each other. Just a thought. > > > > On Wed, Aug 26, 2015 at 5:38 AM, Upayavira <u...@odoko.co.uk> wrote: > > > > > > > > > > > On Wed, Aug 26, 2015, at 10:17 AM, O. Klein wrote: > > > > Those options don't fix my problem with closing times the next morning, > > > > or is > > > > there a way to do this? > > > > > > Use the spatial model, and a time window of a week. There are 10,080 > > > minutes in a week, so you could use that as your scale. > > > > > > Assuming the week starts at 00:00 Monday morning, you might index Monday > > > 9:00-23:00 as 540:1380 > > > > > > Tuesday 9am-Wednesday 1am would be 1980:2940 > > > > > > You convert your NOW time into a "minutes since Monday 00:00" and do a > > > spatial search within that time. > > > > > > If it is now Monday, 11:23am, that would be 11*60+23=683, so you would > > > do a search for 683:683. > > > > > > If you have a shop that is open over Sunday night to Monday, you just > > > list it as open until Sunday 23:59 and open again Monday 00:00. > > > > > > Would that do it? > > > > > > Upayavira > > > > > > > > > > > -- > > Darren