Select to view content in your preferred language

Simple AVL from CSV

3423
0
11-13-2014 04:28 PM
StevenDague
Occasional Contributor

Our Goal: Take a Lat/Lon in CSV file from GPS device and update the XY on a web map.

Original solution: Created a VB service to write GPS data to CSV, used Python to covert CSV to Shapefile and refresh map layer programmatically in Flex Viewer.  Worked in testing, failed during event. Python would crash and corrupt the layer.  Had to delete the python working directory and restart the python script to get it working again.  PITA.

Solution 2: Display CSV table as XY data in ArcMap, publish as map service and use Query widget to refresh the map layer. Problem here is that the Lat/Lon in the CSV does not match displayed location.  Example: Query widget shows 34,-117 but Flex Viewer shows the point at 0, 0 or 27, -139.

Thoughts? Recommendations?  Any assistance will be greatly appreciated.

Steven Dague
GIS Analyst
0 Kudos
0 Replies