NMEA 0183 $GPGGA,123519.00,4807.038,N,01131.000,E,1,08,0.9,545.4,M,46.9,M,,*47 $GPRMC,123519.00,A,4807.038,N,01131.000,E,022.4,084.4,230394,003.1,W*6A $GPGSA,A,3,04,05,,09,12,,,24,,,,,2.5,1.3,2.1*39 $GPGSV,2,1,08,01,40,083,46,02,17,308,41,12,07,344,39,14,22,228,45*75 $GPGSV,2,2,08,18,15,120,42,24,08,295,38,22,05,088,41*7A $GPVTG,054.7,T,034.4,M,005.5,N,010.2,K,A*3D $GPZDA,123519.00,23,03,2024,00,00*60
$GPVTG,054.7,T,034.4,M,005.5,N,010.2,K,A*3D $GPGLL,4807.038,N,01131.000,E,123519.00,A,A*6C $GPHDT,084.4,T*2A $HCHDG,084.4,,,12.5,E*1C $GPGGA,123525.00,4807.040,N,01131.002,E,1,08,0.9,545.5,M,46.9,M,,*42 $GPRMC,123525.00,A,4807.040,N,01131.002,E,022.5,084.5,230394,003.1,W*61
$GPGGA,092725.00,4717.113,N,00833.915,E,1,12,0.8,436.2,M,46.9,M,,*4B $GPRMC,092725.00,A,4717.113,N,00833.915,E,018.2,270.5,291224,,*2F $GPGSA,A,3,02,05,09,12,15,18,24,,,,,,2.2,1.2,1.9*3E $GPGSV,2,1,07,02,65,083,44,05,22,308,40,09,12,344,38*72
<event version="2.0" uid="ANDROID-1" type="a-f-G-E-V-C" how="m-g" time="2024-01-15T12:35:19Z"><point lat="48.1173" lon="11.5167" hae="545.4" ce="9" le="9"/><detail><contact callsign="Squirrel-1"/></detail></event> <event uid="UAV-3" type="a-f-G-U-C" how="m-p"><point lat="48.198" lon="11.578" hae="1100"/><detail><track speed="14" course="265"/></detail></event> <event uid="SENSOR-1" type="b-m-p-s-p"><point lat="48.11" lon="11.51" hae="550"/><detail><link type="a-f-G" uid="ANDROID-1"/></detail></event>
<event uid="UAV-7" type="a-f-G-U-C" how="m-p"><point lat="48.201" lon="11.582" hae="1200"/><detail><track speed="15" course="270"/></detail></event>
<event uid="BOAT-ALPHA" type="a-f-G-E-V-C"><point lat="47.892" lon="11.412" hae="0"/><detail><contact callsign="Alpha"/><remarks>patrol</remarks></detail></event>
<ContinuousMove xmlns="http://www.onvif.org/ver20/ptz/wsdl"><ProfileToken>Profile_1</ProfileToken><Velocity><PanTilt x="0.5" y="0.2"/></Velocity></ContinuousMove> <AbsoluteMove><ProfileToken>Profile_1</ProfileToken><Position><PanTilt x="0.0" y="0.3"/><Zoom x="0.5"/></Position></AbsoluteMove> <Stop><ProfileToken>Profile_1</ProfileToken><PanTilt>true</PanTilt><Zoom>false</Zoom></Stop>
<AbsoluteMove><ProfileToken>Profile_1</ProfileToken><Position><PanTilt x="0.0" y="0.3"/><Zoom x="0.5"/></Position></AbsoluteMove>
<Stop><ProfileToken>Profile_1</ProfileToken><PanTilt>true</PanTilt><Zoom>false</Zoom></Stop>
!AIVDM,1,1,,A,13HOI:0P00PD>OH1pR1NR1@CqUo400,0*6F !AIVDM,2,1,,A,53nFBv01Sq<LdH@E=FP0000<0@0000<0@0000<0@0000,0*09 !AIVDM,1,1,,B,33aDqPP000P9d>NR<9H;<6000@53,0*6E !AIVDM,1,1,,A,B52K>h;0000>o>4<60W5@P4,0*3C !AIVDM,1,1,,A,H42O>h0000>o>4<60W5@P4,0*1A
!AIVDM,1,1,,B,33aDqPP000P9d>NR<9H;<6000@53,0*6E !AIVDM,1,1,,A,B52K>h;0000>o>4<60W5@P4,0*3C
!AIVDO,1,1,,A,13HOI:0P00PD>OH1pR1NR1@CqUo400,0*6F !AIVDM,1,1,,A,H42O>h0000>o>4<60W5@P4,0*1A
ASTERIX CAT-240 FSPEC=0x38 SAC=1 SIC=2 TNO=1234 TID=0x0102 LAT=48.117300 LON=11.516700 ALT=545 HGT=0 GS=022 I240/015 TNO=1235 GS=023 ROC=11.2 I240/020 TNO=1236 FSPEC=0x3E SAC=1 SIC=2 LAT=48.118 LON=11.517 ALT=546
CAT240 I240/010 TNO=5678 FSPEC=0x3E SAC=2 SIC=7 TID=0x0A1B LAT=47.892 LON=11.412 ALT=1200
I240/015 TNO=9012 GS=018 ROC=12.5 TAR=0x01 TRK=3
MAVLink #0 HEARTBEAT type=MAV_TYPE_QUADROTOR autopilot=MAV_AUTOPILOT_ARDUPILOTMEGA base_mode=81 custom_mode=0 fd 09 00 00 00 00 00 00 00 00 00 00 GLOBAL_POSITION_INT lat=48117300 lon=11516700 alt=545400 rel_alt=0 vx=120 vy=-80 vz=0 ATTITUDE roll=0.12 pitch=-0.05 yaw=1.57 SYS_STATUS onboard=1 sensors=131071
MAV GLOBAL_POSITION_INT lat=48117300 lon=11516700 alt=545400 rel_alt=0 vx=120 vy=-80 vz=0
ATTITUDE roll=0.12 pitch=-0.05 yaw=1.57 rollspeed=0.0 pitchspeed=0.0 yawspeed=0.02 fd 1d 00 00 00 00 00 00 00 00
$GPGGA,184532.00,4832.112,N,00912.445,E,1,10,0.7,312.1,M,46.9,M,,*5A $GPRMC,184532.00,A,4832.112,N,00912.445,E,012.1,145.2,291224,,*2C $GPVTG,145.2,T,,M,012.1,N,022.4,K,A*2D $GPZDA,184532.00,29,12,2024,00,00*65
$GPZDA,123519.00,23,03,2024,00,00*60 $GPGST,123519.00,2.1,1.8,1.2,270.5,1.1,1.0,1.2*4E
<event uid="SENSOR-1" type="b-m-p-s-p"><point lat="48.11" lon="11.51" hae="550"/><detail><link type="a-f-G" uid="ANDROID-1"/></detail></event>
<event uid="GROUND-3" type="a-f-G-U-C-I" how="h-g-i-g-o"><point lat="48.09" lon="11.48"/><detail><contact endpoint="*:-1:stcp"/></detail></event>
<GetConfiguration><PTZConfigurationToken>default</PTZConfigurationToken></GetConfiguration>
<RelativeMove><ProfileToken>Profile_1</ProfileToken><Translation><PanTilt x="0.1" y="-0.05"/></Translation></RelativeMove>
!AIVDM,1,1,,B,4025?q`000H>bd<P00:2T@53,0*5A !AIVDM,1,1,,A,4h3Ovk1<59<9e><;0<0?1>1@53,0*0F
I240/020 TNO=3456 FSPEC=0x38 SAC=1 SIC=3 LAT=48.201 LON=11.582 ALT=800 GS=025
SYS_STATUS onboard=1 sensors=131071 load=512 battery=11800 drop_rate_comm=0
MISSION_CURRENT seq=3 fd 42 00 03 00 00 00 00 00 00
$GPGGA,204512.00,4712.045,N,00845.120,E,1,10,0.8,320.0,M,46.9,M,,*4A $GPRMC,204512.00,A,4712.045,N,00845.120,E,008.5,195.2,291224,,*24
$GPHDT,092.3,T*1F $GPVTG,092.3,T,,M,012.0,N,022.2,K,A*2B
<event uid="ROVER-2" type="a-f-G-U-C"><point lat="48.05" lon="11.52" hae="420"/><detail><track course="180"/></detail></event>
<event uid="C2-ALPHA" type="a-f-G-E-V-C" how="h-e-m"><point lat="48.15" lon="11.55" hae="0"/><detail><contact callsign="C2"/></detail></event>
<GetStatus><ProfileToken>Profile_1</ProfileToken></GetStatus>
!AIVDM,1,1,,A,23aDqPP000P9d>NR<9H;<6000@53,0*7E !AIVDM,1,1,,B,H42O>h0000>o>4<60W5@P4,0*2A
CAT240 I240/008 TNO=7890 SAC=1 SIC=5 LAT=48.050 LON=11.520
PARAM_VALUE id=0 name=SYSID value=1.000000 type=6 fd 22 00 00 00 00 00 00 00
GPS_RAW_INT fix_type=3 lat=48117300 lon=11516700 alt=545400 eph=120 epv=80
$GPGGA,154212.00,4831.200,N,01128.500,E,1,09,0.8,398.2,M,46.9,M,,*4A $GPRMC,154212.00,A,4831.200,N,01128.500,E,014.1,185.3,291224,,*21
<event uid="DRONE-5" type="a-f-G-U-C"><point lat="48.22" lon="11.60" hae="800"/><detail><track speed="12" course="090"/></detail></event>
<GetPresets><ProfileToken>Profile_1</ProfileToken></GetPresets>
!AIVDM,1,1,,A,35NTK5000P9d>NR<9H;<6000@53,0*5E !AIVDM,1,1,,B,63nFBv01Sq<LdH@E=FP0000<0@0000,0*0A
I240/012 TNO=4567 SAC=2 SIC=4 LAT=48.092 LON=11.445 ALT=320 GS=015 ROC=8.2
COMMAND_ACK command=16 result=0 result_param=0 fd 77 00 00 00 00 00 00
$GPGSV,3,2,10,18,65,120,42,22,41,265,38,25,12,045,41,31,08,312,39*7A $GPGGA,092104.00,4718.200,N,00830.100,E,1,11,0.7,410.0,M,46.9,M,,*4C
<event uid="SENSOR-2" type="b-m-p-s-p"><point lat="48.08" lon="11.46" hae="520"/><detail><link type="a-f-G" uid="ROVER-2"/></detail></event>
<SetPreset><ProfileToken>Profile_1</ProfileToken><PresetToken>Home</PresetToken><PresetName>Home</PresetName></SetPreset>
!AIVDM,1,1,,A,23aDqPP000P9d>NR<9H;<6000@53,0*7E !AIVDM,1,1,,A,43HOI:0P00PD>OH1pR1NR1@CqUo400,0*6A
CAT240 I240/018 TNO=1122 FSPEC=0x3E SAC=1 SIC=6 LAT=48.155 LON=11.535 ALT=600
BATTERY_STATUS id=0 battery_remaining=87 voltage=11800 current_consumed=-1 energy_consumed=-1
$GPGGA,204512.00,4712.045,N,00845.120,E,1,10,0.8,320.0,M,46.9,M,,*4A $GPRMC,204512.00,A,4712.045,N,00845.120,E,008.5,195.2,291224,,*24
<event uid="C2-BRAVO" type="a-f-G-E-V-C"><point lat="48.12" lon="11.50" hae="0"/><detail><contact callsign="C2-Bravo"/></detail></event>
<GetNodes><NodeToken>PTZNode_1</NodeToken></GetNodes>
!AIVDM,1,1,,A,55P5TLG>0@<9H;<6000@53,0*4E !AIVDM,1,1,,B,65nFBv01Sq<LdH@E=FP0000<0@0000,0*0B
I240/022 TNO=3344 SAC=1 SIC=8 LAT=48.201 LON=11.582 ALT=720 GS=030 ROC=15
NAV_CONTROLLER_OUTPUT nav_roll=2.1 nav_pitch=-1.2 alt_error=0.0 aspd_error=0.0 xtrack_error=0.0
$GPZDA,123519.00,23,03,2024,00,00*60 $GPGST,123519.00,2.1,1.8,1.2,270.5,1.1,1.0,1.2*4E
<event uid="UAV-9" type="a-f-G-U-C" how="m-p"><point lat="48.18" lon="11.55" hae="950"/><detail><track speed="18" course="180"/></detail></event>
<GetStatus><ProfileToken>Profile_2</ProfileToken></GetStatus>
!AIVDO,1,1,,A,13HOI:0P00PD>OH1pR1NR1@CqUo400,0*6F !AIVDM,1,1,,A,H42O>h0000>o>4<60W5@P4,0*1A
CAT240 I240/010 TNO=6677 FSPEC=0x38 SAC=2 SIC=3 LAT=48.092 LON=11.445
SCALED_PRESSURE time_boot_ms=12345 press_abs=101325.0 press_diff=0.0 temperature=2200
$GPVTG,054.7,T,034.4,M,005.5,N,010.2,K,A*3D $GPGLL,4807.038,N,01131.000,E,123519.00,A,A*6C
<event uid="BOAT-BRAVO" type="a-f-G-E-V-C"><point lat="47.88" lon="11.40" hae="0"/><detail><contact callsign="Bravo"/></detail></event>
<RelativeMove><ProfileToken>Profile_1</ProfileToken><Translation><PanTilt x="-0.2" y="0.1"/></Translation></RelativeMove>
!AIVDM,1,1,,A,43HOI:0P00PD>OH1pR1NR1@CqUo400,0*6A !AIVDM,1,1,,B,53nFBv01Sq<LdH@E=FP0000<0@0000,0*08
I240/015 TNO=8899 SAC=1 SIC=9 GS=022 ROC=10.5 TAR=0x01
RC_CHANNELS channels_count=16 ch1=1500 ch2=1500 ch3=1000 ch4=1500 ch5=1800 ch6=1000
$GPGGA,081234.00,4845.100,N,01055.200,E,1,09,0.8,445.2,M,46.9,M,,*5B $GPRMC,081234.00,A,4845.100,N,01055.200,E,015.2,092.4,291224,,*2A $GPGSA,A,3,02,06,09,11,,,22,,,,,2.4,1.4,1.9*38
<event uid="ROVER-4" type="a-f-G-U-C"><point lat="48.06" lon="11.48" hae="380"/><detail><track course="045"/></detail></event> <event uid="SENSOR-3" type="b-m-p-s-p"><point lat="48.14" lon="11.52" hae="560"/></event>
<GotoHomePosition><ProfileToken>Profile_1</ProfileToken><Speed><PanTilt x="0.5" y="0.5"/></Speed></GotoHomePosition>
!AIVDM,1,1,,A,23aDqPP000P9d>NR<9H;<6000@53,0*7E !AIVDM,1,1,,B,43HOI:0P00PD>OH1pR1NR1@CqUo400,0*6A !AIVDM,1,1,,A,53nFBv01Sq<LdH@E=FP0000<0@0000,0*09
I240/018 TNO=2233 SAC=2 SIC=5 LAT=48.165 LON=11.528 ALT=650 GS=020 ROC=9.0 TAR=0x02
HOME_POSITION lat=48117300 lon=11516700 alt=545.0 x=0.0 y=0.0 z=0.0 approach_x=0.0 approach_y=0.0 approach_z=0.0
$GPGSV,3,1,10,01,65,083,44,02,45,308,42,05,32,344,40,08,28,228,38*7B $GPGGA,165432.00,4722.300,N,00852.100,E,1,11,0.7,385.0,M,46.9,M,,*4D
<event uid="UAV-12" type="a-f-G-U-C" how="m-p"><point lat="48.21" lon="11.59" hae="1050"/><detail><track speed="20" course="315"/></detail></event>
<GetPresetTours><ProfileToken>Profile_1</ProfileToken></GetPresetTours>
!AIVDM,1,1,,A,63nFBv01Sq<LdH@E=FP0000<0@0000,0*0C !AIVDM,1,1,,B,73aDqPP000P9d>NR<9H;<6000@53,0*5F
CAT240 I240/008 TNO=4455 FSPEC=0x38 SAC=1 SIC=4 LAT=48.102 LON=11.468 ALT=480
VFR_HUD airspeed=12.5 groundspeed=11.8 heading=85 throttle=72 alt=545.4 climb=-0.2
$GPGGA,112045.00,4810.500,N,01115.300,E,1,10,0.9,412.0,M,46.9,M,,*4E $GPRMC,112045.00,A,4810.500,N,01115.300,E,009.8,158.2,291224,,*27 $GPHDT,158.2,T*2B
<event uid="GROUND-5" type="a-f-G-U-C-I"><point lat="48.08" lon="11.47"/><detail><contact endpoint="*:-1:stcp"/></detail></event>
<RemovePreset><ProfileToken>Profile_1</ProfileToken><PresetToken>Preset_3</PresetToken></RemovePreset>
!AIVDM,1,1,,A,33aDqPP000P9d>NR<9H;<6000@53,0*6E !AIVDM,1,1,,A,4025?q`000H>bd<P00:2T@53,0*5A
I240/025 TNO=7788 SAC=1 SIC=7 LAT=48.188 LON=11.562 ALT=890 GS=028 ROC=14.2 TAR=0x01 TRK=2
SERVO_OUTPUT_RAW port=0 servo1_raw=1500 servo2_raw=1500 servo3_raw=1000 servo4_raw=1500 servo5_raw=1000 servo6_raw=1000
ADS-B DF17 *8D4840D62020CC586C40287D0B72; *8D40621D58196C392000000000; icao=4840D6 alt=38000 lat=48.12 lon=11.52 gs=450 track=085 squawk=4521
*8D75804B580FF2CF7E9BA6F701; *8D4065D859195E39200049D381; icao=4065D8 callsign=BAW123 alt=35000 baro=1013.2
ADS-B MSG df=17 icao24=4840d6 type=11 (AC) subtype=1 alt=38000 lat=48.117 lon=11.516
*8D4840D62020CC586C40287D0B72; *8D40621D58196C392000000000; velocity=450 heading=85 vrate=-1200
sqlite> SELECT id, name, ST_AsText(geom) FROM places WHERE ST_Within(geom, BuildMbr(11.4, 47.8, 11.7, 48.3));
SELECT * FROM spatial_ref_sys WHERE srid=4326; 4326|EPSG|4326|WGS 84|...
INSERT INTO roads (name, geom) VALUES
('A1', GeomFromText('LINESTRING(11.5 48.1, 11.6 48.2)'));
.schema geometry_columns CREATE TABLE geometry_columns (f_table_name, f_geometry_column, ...);
SELECT AsGeoJSON(geom), name FROM pois WHERE MbrContains(BuildMbr(11.4, 47.9, 11.6, 48.2), geom);
SELECT Distance(Point(11.5, 48.1), geom) AS d FROM waypoints ORDER BY d LIMIT 5;
Coming soon.