Hi,
My end goal is to have a database connection where I can use my fire data (incident types, lat and long) inside ArcDesktop. I currently export a .csv file and use "Make XY Event layer" in order to use the data. I have made a connection to my database inside ArcDesktop, but the my lat and long are stored as (char(20)) and don't work with the tool. I have tired to CAST the values in a SQL query, but hit a roadblock with errors.
Any suggestions on how I could accomplish my end goal of using my fire data directly in ArcDesktop without exporting from my SQL database first?
Thanks!