220 likes | 419 Vues
GALS Science Symposium Oct 3, 2013. Don’t Harbor GALS. Giant African Land Snails. D. Martinez 10/03/13. New GALS Database Dashboard. D. Martinez 10/03/13. New GALS Property List. D. Martinez 10/03/13. New GALS Property History. D. Martinez 10/03/13. New GALS Prepop.
E N D
GALS Science Symposium Oct 3, 2013 Don’t Harbor GALS Giant African Land Snails D. Martinez 10/03/13
New GALS Database Dashboard D. Martinez 10/03/13
New GALS Property List D. Martinez 10/03/13
New GALS Property History D. Martinez 10/03/13
New GALS Prepop D. Martinez 10/03/13
Mobile Evaluation within DPI • Smart Phones – display screen too small, poor visibility in sunlight • iPads – rigid development environment, doesn’t work well in • sunlight, pricey • Netbooks – heavy, needs work surface for keyboarding, • old technology • Tablets – 10”, 7” – preferred for easy interaction D. Martinez 10/03/13
Nexus 7”, 2nd Generation (out of the box) • Price point $346 (device, 2 yr replacement, case) • Android – Jelly Bean 4.3 • Quad processor – Snapdragon S4 Pro, 1.5GHz, 2GB RAM • 32GB or 64GB storage (w/aircard-$349) • On-board GPS • 2 Camera (rear 5MP, front 1.2MP) • Video – HD display 1080p • HDMI output port, 2 speakers • Wireless charging • Google Earth • Brighter display for outdoors use • Bluetooth/Wi-Fi enabled, internal aircard(Verizon or AT&T) • KingSoft – MS Office (create, edit) – Word, Excel, PowerPoint • Adapter to attach USB devices via power port • ($1.99 cable, $2.99 Google Play application) D. Martinez 10/03/13
Application • Export data from existing Oracle databases • Import into tablets via Bluetooth • Create Android application to enforce business logic with data D. Martinez 10/03/13
Nexus 7 - Tablet development • Data Mgmt signs out tablet to Crew Leader by tag numbers – i.e. Team 1 gets Tablets # SI026812, SI026813 for the day. • Assumptions: We will have the entire database loaded on this so they will be able to look at the overall map of the cores, and see the map for those Z grids. Maybe GPS points and/or driving instructions on how to get to the different Cores. • In the field, team turns on and completes Daily Team Info • Provides Team Members (name or G###) that will be using that Tablet for the day • All transactions will be tagged by the Tablet SI#### and the Team Members (name of G###) • When you begin, you know what Core/Grid you are going to work OR you can search for an address to find the property to begin. • You can then tap on Z grid map for it to bring up your property or see the list of properties. • It will then alert you if there are any Refusal, No Waiver or Comments that you need to be aware of. • It will ask them if they Want to Proceed and if so, it will capture date and time of starting inspection • They can then record the details of their inspection actions taken on the property: • snails collected yes or no • amount of bait applied • any additional comments • Once they are done they can hit Complete it will save the record and prevent them from ending with any missing data. ( ) • It will capture date and time of completed inspection. • It'll been returned to the Grid map indicate that the property has been completed. • We will need to have a way home which they can capture 24 hour notice is so they'll know which properties they can return to after 24 hrs. • Other Reference documents/tools? • Public Service Announcement videos • Regulatory database • Maps - GALS • Reference materials • Training docs on Tablet use • Note taking abilities White Paper D. Martinez 10/03/13
Mobile Evaluation Interest by many • Consulting with: • OATS • F&V of FDACS • Aquaculture of FDACS • USDA – APHIS • continue to use Windows mobile devices • National Plant Board – NC Department of • Agriculture & Consumer Services D. Martinez 10/03/13
Current Status • Purchased 7 devices for development • Exported Miami-Dade maps (40 mb) • Import CSV file formats – no issues • GPS data points for collecting samples D. Martinez 10/03/13
GALS Project D. Martinez 10/03/13
GALS Project • Can zoom in to get streets visible • Can ‘pinch & zoom’ to change display • Can swipe to move around D. Martinez 10/03/13
GALS Project • Can zoom in further to get House numbers • visible • Can ‘pinch & zoom’ to change display • Can swipe to move around D. Martinez 10/03/13
Nexus 7 GPS Test • GPS Test System Boot D. Martinez 10/03/13
Nexus 7 GPS Test • GPS Test System 35 seconds, first reading D. Martinez 10/03/13
Nexus 7 GPS Test Location from wireless provider Actual location of device • GPS Test System 2:36 (min, sec), 5 readings taken over duration, 16 m accuracy Location GPS Samples after 2:36 D. Martinez 10/03/13
DPI_AGDATA (Agricultural Data) (property/location database • PICS/Pest Incident • Control System • Location details • GIS shapes • Inspections • (observations/surveys) • commercial citrus (MB, • Grower blocks, SB’s) • non-commercial citrus • properties
LISTS (Lab Identification/Sample Tracking Systems) 12 different DPI Labs • Plant Pathology (PPST) • Botany • Entomology • Nematology • Fruit Fly ID • Apiary • CGIP • Budwood • Fly Lab • Methods • Cooperative Agric Pest Survey (CAPS) • Advanced Diagnostic Lab (ADL)
PITR (Plant Industry Trust Revenue $$) Plant Inspection Protocol Certification Apiary Inspection • Regulatory Enforcement • CA’s • HP’s • Violations • Stop Sale • Permits • Regulated Entities • Fee for services • ROC • Future: • eCommerce D. Martinez 10/03/13
Use of data in business decisions Proposed Citrus Nursery Site – review citrus within one-mile of commercial citrus D. Martinez 10/03/13
Use of data in business decisions Helpline Homeowner Call able to determine distance to local outbreak and treatment areas D. Martinez 10/03/13