Transcript GIS Based Agricultural Geo-Traceability Model

w w w. g r a i n l a b. o r g
GIS Based Agricultural Geo-Traceability Model
1
Gemesi
2
Hurburgh
Hafize Gunsu
([email protected]), Charles R.
([email protected])
1 Department of Agricultural and Biosystems Engineering, Iowa State University, Ames, IA, 1,2
IOWA STATE UNIVERSITY
Definition of Traceability: ISO 8402
GIS for Field Activity Mapping
GIS connects to simultaneous serial real-time data streams in the field (i.e.
GPS, SCUFA, 10-AU)
GIS combines incoming data and maps the readings in real-time as
subsequent dots.
The subsequent GPS readings (combine, cart) are overlaid on a rectified aerial
“The ability to trace the history, application
location of an entity by means of recorded
Identifications”
Project Objectives
Provide information for specific production practices (IP,
organic, etc.)
Visualize traceability data in a clear and intuitive way on
photograph so that the actual position of each activity in relation to the study
area (Farm) can be determined.
maps and make use of GIS to study the relationships between
environment and the production parcels
Creation of information system that is compliant with legal
requirements (FDA Bioterrorism Act, ISO 22000: 2005, etc.)
Visual demonstration of product movement
Geographical Traceability in Agriculture
Acquisition and processing of geographic referenced farm level data
Geographical traceability indicators will relate production lots and their
environment.
web based infrastructure manage geographical traceability information


Tools
Lot Dynamics
Results
Responsible
Party:
Responsible
Party:
Responsible
Party:
Responsible
Party:
Combine_GPS
Cart_GPS
Truck_GPS
Storage_GPS
Ø
{Pre_Alteration_Lot}
{Post_Alteration_Lot}
Aggregated
Aggregated
Geo_Identifiers
Alteration
Geo_Identifiers
(LOT)
(LOT)
{Pre_Aggregation_Lot}
Lot Features
preserved, only
Location changed
Responsible Party:
Transporter_GPS
A lot Split into
number of LOTS
{Post_Integration_Lot}
Aggregated
Geo_Identifiers
(LOT)
Integration
{Post_Division_Lot}
{Pre_Integration_Lot}
{Post_Integration_Lot}
Number of Lots
Integrated into a
unique LOT
Lot Features preserved,
only Location changed
{Pre_Alteration_Lot}
Aggregated
Geo_Identifiers
(LOT)
{Post_Alteration_Lot}
Alteration
Aggregated
Geo_Identifiers
(LOT)
{Pre_Aggregation_Lot}
Aggregated
Integration
Geo_Identifiers
(LOT)
{Pre_Division_Lot}
{Post_Integration_Lot}
data can
be related to specific geographic location (LOT) by using GIS
based database management tool
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
GeoID
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
GeoID
Time
(x,y)
M/D/Y/Min/Sec
v Alteration The movement of a lot from one location to
another can be considered as a LOT alteration
v Responsible_Party of the LOT creates an link between
the pre_movement LOT and the post_movement LOT
v A LOT can be identified with a unique site, the
responsible party has to form a new LOT with a new
identifier
Creation of Geo-identifier
A geo-identifier locates a map object or a production parcel while an agricultural
product is processed.
GeoID
Time
CART_ID
(x,y)
M/D/Y/Min/Sec
Serial_No
Truck GPS Recording
Truck
Time
Load Ends
Truck_ID
bushels
CART_ID
M/D/Y/Min/Sec
Plate_No
1000
Serial_No
GeoID
Time
(x,y)
M/D/Y/Min/Sec
BIN_1
Amount
CART_2 Loading
Ends
GeoID
Time
CART_ID
(x,y)
M/D/Y/Min/Sec
Serial_No
Truck
Movement
Time
Recieved
Geo_ID
(x,y)
Received Unit_Id
(Truck_ID)
M/D/Y/Min/Sec
(x,y)
Aggregated
Geo_Identifiers
(LOT)
CART_1 Loading
Ends
Truck
Aggregated
Geo_Identifiers
(LOT)
Division
Cart GPS Recording
Time
Time
Figure 3 above shows the lot dynamics and transformation of lots at the farm
Figure 1 above shows the how farm management
Time
GeoID
Number of Lots
Integrated into a
unique LOT
{Pre_Integration_Lot}
Aggregated
Integration
Geo_Identifiers
(LOT)
GeoID
{Post_Division_Lot}
{Post_Division_Lot}
{Pre_Aggregation_Lot}
Aggregated
Geo_Identifiers
Alteration
(LOT)
{Post_Alteration_Lot}
Ø
Aggregated
Geo_Identifiers
(LOT)
{Pre_Alteration_Lot}
Ø
Ø
Aggregated
Geo_Identifiers
(LOT)
{Pre_Alteration_Lot}
{Pre_Aggregation_Lot}
Aggregated
Alteration
Geo_Identifiers
(LOT)
{Post_Alteration_Lot}
Aggregated
Geo_Identifiers
(LOT)
Combine Aggregated
Geo_Identifiers
(Sub_Lots)
Figure 2 above shows partial GIS based Farm Traceability Model
Combine Aggregated
Geo_Identifiers
(Sub_Lots)
Combine GPS Recording
Combine Aggregated
Geo_Identifiers
(Sub_Lots)
ArcGIS 9.2
ArcSDE Enterprise Database Management Software
2005 SQL Server database
Real-Time Data Acquisition Model for Single LOT
Time
Load Ends
Truck_ID
bushels
CART_ID
M/D/Y/Min/Sec
Plate_No
1000
Serial_No
CART_1 Loading
Ends
GeoID
Time
CART_ID
(x,y)
M/D/Y/Min/Sec
Serial_No
Cart
Movement
LOT
(X,Y) Boundaries
Defined as combine
movement from start to the
end in particular field
Figure 4 above shows the real-time data acquisition
for a single lot
Next Steps
Creation of web based infrastructure that will
traceability information
help to manage geographical
integrated
Analysis of new ISO 22000 Food Safety and TraceCore Standards and
of GIS traceability concept