I wondered if I could pick your brains for a second!
I have an existing (Arc GIS) dataset of a 10,000 household survey taken a
couple years ago in northern Nigeria. We are looking to revisit a sample
of these households for a follow up survey. I have been having a play with
ODK Collect with a view to capturing survey data electronically in the
future (possibly on a repeating annual basis).
What I would like to do is link new survey data back to the original
dataset. This has been mapped in Arc GIS, probably with a locational
accuracy of +-10m.
As I see it ODK Collect will only ever let me download a blank form (new
record) and begin data capture. The only ways I can think of matching new
records back to the original data set is either:
by manually entering the unique identifier for an existing household
onto the new form at the time of survey (though potential for operator
error here)
taking a new GPS tag at the location and spatially 'joining' the new
data back to the old records in my GIS. I'm not massively confident with
this though given the close proximity of households to each other in some
locations (e.g. within 5 m of each other) and the potential inaccuracies of
my GPS.
Can anyone suggest any other ways of achieving this?? (Whilst minimising
operator error or other technical constraints)
As I said this is with a view to repeating a household survey on an annual
basis in order to track change. The key constraints would be a lack of
geo-positional accuracy in the field (using fairly cheap Android phones)
and being able to identify a previously surveyed household.
I've been looking at this blog http://bryanmcbride.com/fun-with-the-open-data-kit which seems to instruct
on how to marry ODK with Geoserver/PostGIS which is something else I want
to explore a little further. Any clues in that somehow?
Additionally you could create an an already started form instances in the
instances folder and have your workers reopen those surveys with some data
pre-populated. This is a less than ideal approach.
We plan to solve this use case soon with the release of a new tool called
ODK Tables. However, it is not complete yet and needs some redesign so in
the mean time we do not have a great off the shelf solution for you it will
take some approach like you have mentioned or some custom code.
We are working hard to get the next round of tools out (aka ODK 2.0).
Regards,
Waylon
···
On Sun, Sep 30, 2012 at 3:21 AM, marty wrote:
Hi,
I wondered if I could pick your brains for a second!
I have an existing (Arc GIS) dataset of a 10,000 household survey taken a
couple years ago in northern Nigeria. We are looking to revisit a sample
of these households for a follow up survey. I have been having a play with
ODK Collect with a view to capturing survey data electronically in the
future (possibly on a repeating annual basis).
What I would like to do is link new survey data back to the original
dataset. This has been mapped in Arc GIS, probably with a locational
accuracy of +-10m.
As I see it ODK Collect will only ever let me download a blank form (new
record) and begin data capture. The only ways I can think of matching new
records back to the original data set is either:
by manually entering the unique identifier for an existing household
onto the new form at the time of survey (though potential for operator
error here)
taking a new GPS tag at the location and spatially 'joining' the new
data back to the old records in my GIS. I'm not massively confident with
this though given the close proximity of households to each other in some
locations (e.g. within 5 m of each other) and the potential inaccuracies of
my GPS.
Can anyone suggest any other ways of achieving this?? (Whilst minimising
operator error or other technical constraints)
As I said this is with a view to repeating a household survey on an annual
basis in order to track change. The key constraints would be a lack of
geo-positional accuracy in the field (using fairly cheap Android phones)
and being able to identify a previously surveyed household.
I've been looking at this blog http://bryanmcbride.com/fun-with-the-open-data-kit which seems to
instruct on how to marry ODK with Geoserver/PostGIS which is something else
I want to explore a little further. Any clues in that somehow?
I think a unique ID sounds like the way to go to link the data. If you are
looking for a way to navigate to each of the 10,000 locations for
follow-up, I recommend the android app Locus Free. We've had a great
experience using it for navigation on Android tablets. You can load up the
points (from a kml file), and using the built in compass to confirm the
direction and distance to your point. You can store base maps (yours or
free ones) for offline use, and you can even record your track if your team
are traveling on previously uncharted roads.
I've high school educated ag extension workers using it after 3 days of
training.
···
--
Eric A. Couper
Technical Adviser, Ethiopian Soil Information Service
Ethiopian Agricultural Transformation Agency
Jomo Kenyatta Avenue, Zequala Towers, 7th Floor
m. +251 923 79 75 94
e. eric.couper@ata.gov.et
w. www.ericcouper.com
w. www.ata.gov.et
On Sunday, September 30, 2012 1:21:57 PM UTC+3, marty wrote:
Hi,
I wondered if I could pick your brains for a second!
I have an existing (Arc GIS) dataset of a 10,000 household survey taken a
couple years ago in northern Nigeria. We are looking to revisit a sample
of these households for a follow up survey. I have been having a play with
ODK Collect with a view to capturing survey data electronically in the
future (possibly on a repeating annual basis).
What I would like to do is link new survey data back to the original
dataset. This has been mapped in Arc GIS, probably with a locational
accuracy of +-10m.
As I see it ODK Collect will only ever let me download a blank form (new
record) and begin data capture. The only ways I can think of matching new
records back to the original data set is either:
by manually entering the unique identifier for an existing household
onto the new form at the time of survey (though potential for operator
error here)
taking a new GPS tag at the location and spatially 'joining' the new
data back to the old records in my GIS. I'm not massively confident with
this though given the close proximity of households to each other in some
locations (e.g. within 5 m of each other) and the potential inaccuracies of
my GPS.
Can anyone suggest any other ways of achieving this?? (Whilst minimising
operator error or other technical constraints)
As I said this is with a view to repeating a household survey on an annual
basis in order to track change. The key constraints would be a lack of
geo-positional accuracy in the field (using fairly cheap Android phones)
and being able to identify a previously surveyed household.
I've been looking at this blog http://bryanmcbride.com/fun-with-the-open-data-kit which seems to
instruct on how to marry ODK with Geoserver/PostGIS which is something else
I want to explore a little further. Any clues in that somehow?