[Air-L] SOS: want to randomly fill address field in a spreadsheet

[Raphael Velt]

Hello,

I think it depends a lot on what you want your sample to be. Should it be evenly distributed in terms of geographic area, in terms of population, etc.?

Possible approaches may be:
- Generate random GPS coordinates then use some reverse geocoding service (I think Google does it)
- Use public open data, such as the areas covered by voting locations
- Parse the Open Street Map database for a certain type of amenities

I think it varies from country to country. In the UK, the Post Office database has all addresses and can be licensed, but I don't know about equivalents elsewhere.

Regards,

Raphael Velt
PhD student, Mixed Reality Lab, University of Nottingham

Sent from my Windows Phone
________________________________
From: Babiga Birregah<mailto:bbirregah at gmail.com>
Sent: ‎29/‎04/‎2014 00:30
To: Lovaas,Steven<mailto:Steven.Lovaas at colostate.edu>
Cc: air-l at listserv.aoir.org<mailto:air-l at listserv.aoir.org>
Subject: Re: [Air-L] SOS: want to randomly fill address field in a spreadsheet

thanks but my concerns is that:
1) how to pick a list of postal addresses corresponding to a given area or
city (from a map)
2) and then randomly choose some of them to fill my
excel column of addresses
regards
Babiga


2014-04-29 1:26 GMT+02:00 Lovaas,Steven <Steven.Lovaas at colostate.edu>:

> I would number another column in your address list and then run your
> random-number generator against that.
>
> Steve Lovaas
>
> Sent from my iPhone
>
> > On Apr 28, 2014, at 5:11 PM, "Babiga Birregah" <bbirregah at gmail.com>
> wrote:
> >
> > Dear all
> > I am wondering if anyone knows how to fill randomly a spreadsheet with a
> > list of address picked from a given area or region or city?
> > thanks for your help
> >
> > Regards,
> > Babiga
> > --
> >
> > --
> > BIRREGAH Babiga, Phd
> > Enseignant-Chercheur/ Assistant professor
> > ICD UMR-CNRS 6279 STMR
> > Sciences et Technologies pour la Maîtrise des Risques
> > Joint Research Unit in Sciences and Technologies for Risk Management
> > Department of Operational Research, Applied Statistics and Simulation
> > UTT - ROSAS LM2S H107
> > 12 Rue Marie Curie
> > CS 42060
> > 10004 TROYES CEDEX
> > Tél. +33 (0) 325715869
> > Fax. +33 (0) 325715649
> > QR: http://goo.gl/Et0A4
> > _______________________________________________
> > The Air-L at listserv.aoir.org mailing list
> > is provided by the Association of Internet Researchers http://aoir.org
> > Subscribe, change options or unsubscribe at:
> http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org
> >
> > Join the Association of Internet Researchers:
> > http://www.aoir.org/
>



--

--
BIRREGAH Babiga, Phd
Enseignant-Chercheur/ Assistant professor
ICD UMR-CNRS 6279 STMR
Sciences et Technologies pour la Maîtrise des Risques
Joint Research Unit in Sciences and Technologies for Risk Management
Department of Operational Research, Applied Statistics and Simulation
UTT - ROSAS LM2S H107
12 Rue Marie Curie
CS 42060
10004 TROYES CEDEX
Tél. +33 (0) 325715869
Fax. +33 (0) 325715649
QR: http://goo.gl/Et0A4
_______________________________________________
The Air-L at listserv.aoir.org mailing list
is provided by the Association of Internet Researchers http://aoir.org
Subscribe, change options or unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org

Join the Association of Internet Researchers:
http://www.aoir.org/