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;