SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Stop Food Waste - OS Open Data & SQL Azure


Stop Food Waste - OS Open Data & SQL Azure

Author
Message
Paul Brewer
Paul Brewer
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1089 Visits: 1339
Comments posted to this topic are about the item Stop Food Waste - OS Open Data & SQL Azure
UKGav
UKGav
Old Hand
Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)

Group: General Forum Members
Points: 312 Visits: 257
Just for starters, are you @pdbrewer on twitter?
Paul Brewer
Paul Brewer
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1089 Visits: 1339
Pablobrewster , long story but Paul Brewer was taken.
UKGav
UKGav
Old Hand
Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)

Group: General Forum Members
Points: 312 Visits: 257
Oh, strange! @pdbrewer is also doing Open Data stuff as he works for B&H Council. Check him out..

Anyway, I'll be looking at your article in detail when I have time, looks great on the surface.

Gavin
@ukgav
+ @godhackday (Government Open Data Hack Day)
Paul Brewer
Paul Brewer
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1089 Visits: 1339
Thanks Gavin , that is a coincidence, I'll look him up.
Cheers
BarneyL
BarneyL
Right there with Babe
Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)Right there with Babe (721 reputation)

Group: General Forum Members
Points: 721 Visits: 992
Interesting project,.
I know the person who runs the food bank\homless charity in a town near to me and this could turn out to be useful when up and running. It might be useful if everything worked in reverse too i.e. organisations in need of food can register and suppliers search for them as well.
Getting the food is another matter though - her son used to have the job of pouring bleach over the leftover bread at a local supermarket to make sure no one made use of it and they won't give away a thing. Local restaurants might be more willing to help as they might not see it as lost sales.
UKGav
UKGav
Old Hand
Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)Old Hand (312 reputation)

Group: General Forum Members
Points: 312 Visits: 257
The fine line between sellable and edible is a time critial problem, but not impossible.
I'll help where I can - contact me on twitter @ukgav

I'm sure there is a website which already deals with this subject as well, I'll try to find it later tonight.
Paul Brewer
Paul Brewer
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1089 Visits: 1339
It was impossible to get a SQL Azure instance, hopefully there will be some sort of developer edition eventually.
davoscollective
davoscollective
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3085 Visits: 1008
Very interesting project. I've also made use of that Shape2SQL program.
I find that a lot of the shape files available are way too detailed for most practical mapping purposes. Loading a few hundred megabyte shape file into SSRS makes for a very slow report.

I am wondering about the financial problems. I'm not sure how it works in the UK but I know in Australia you can get a business number for your organisation and register it as a not-for-profit or charity. If you use a tax agent there is a fee but if you apply directly with the government then there is no fee.

You could also register for tax deductible donations which might encourage people to donate to your "stop food waste" charity.

I think there is a lot of value in what you are trying to do here, not just as an excercise for you to learn Azure but that this can actually work. If you set up a basic wordpress website for this and set up a kickstarter account people would definitely donate to help with the setup and ongoing costs. I would!
These numbers on kickstarter success & failure rates are quite interesting
http://www.appsblogger.com/kickstarter-infographic/
Paul Brewer
Paul Brewer
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1089 Visits: 1339
Ukgav suggested getting a proto type running which I'll try to do (on a local instance of sql) but it won't be until the end of July. It's a good point about reporting services being slow loading huge shape files and thanks for that link.

Best wishes
Paul
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search