grmapper245 post(s) |
Hello, I have table I believe was imported from a JSON file. I have two records that clearly have the information I want but now I need to reformat them to something that I can create a drawing from. I suspect the use of a transform to break each record up into parts including the LAT and LONG but not sure of the reformatting process. If anyone can point me to first steps or an example video I'd appreciate it. Here is an example of what went into MF9: {"MMSI":224738000,"TIMESTAMP":"2019-10-03 20:54:54 UTC","LATITUDE":43.47953,"LONGITUDE":-8.25235,"COURSE":246.3,"SPEED":0.1,"HEADING":169,"NAVSTAT":5,"IMO":9237694,"NAME":"BOAT1","CALLSIGN":"AAAA","TYPE":99,"A":25,"B":49,"C":6,"D":10,"DRAUGHT":4.4,"DESTINATION":"ES FRO","LOCODE":"ESFRO","ETA_AIS":"12-17 17:15","ETA":"2019-12-17 17:15:00","SRC":"TER","ZONE":"North East Atlantic Ocean","ECA":false} I have attached my .map file which has the data loaded as a table. Best, GRMapper Attachments: BoatMap.map
|