API tools faq
paste
Guest User

Промт для теста text-to-SQL 2 (alien_3)

a guest
Jul 5th, 2025
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 59.18 KB | None | 0 0
raw download clone embed print report
  1. <НАЗВАНИЕ ТЕСТА>alien_3</НАЗВАНИЕ ТЕСТА>
  2. <ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>Нужно преобразовать запрос в свободной форме (тег «ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ») в SQL-запрос, воспользовавшись схемой базы данных (тег «СХЕМА БАЗЫ ДАННЫХ») и словарём знаний (тег «СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ»). При наличии комментариев и пояснений пишите их на русском языке.</ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>
  3. <ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>Analyze how lunar interference affects observations by station. For each observatory, compute average Lunar Interference Factor (LIF). Sort by average LIF in descending order.</ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>
  4. <ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>Проанализируйте, как лунные помехи влияют на наблюдения по станциям. Для каждой обсерватории вычислите средний фактор лунных помех (LIF) и отсортируйте по убыванию.</ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>
  5. <СХЕМА БАЗЫ ДАННЫХ>
  6. CREATE TABLE "observatories" (
  7. observstation character NOT NULL, /* 'Observatory Name'. Explanation: This field holds the name or unique identifier for the observatory station. Data type: CHAR(60). Example: 'OBS_STATION_ALPHA'. */
  8. weathprofile character varying NULL, /* 'Weather Profile'. Explanation: A short description of weather conditions during observation. Data type: VARCHAR(40). Possible categories: Clear, Cloudy, Partially Cloudy. */
  9. seeingprofile character varying NULL, /* 'Seeing Profile'. Explanation: Assessment of sky seeing conditions (atmospheric steadiness). Data type: VARCHAR(50). Possible categories: Excellent, Good, Poor. */
  10. atmostransparency numeric NULL, /* 'Atmospheric Transparency'. Explanation: A numeric measure of how transparent the atmosphere is. Data type: NUMERIC(5,3). Example: '0.867'. */
  11. lunarstage character varying NULL, /* 'Lunar Phase'. Explanation: The current phase of the Moon during observation. Data type: VARCHAR(25). Possible categories: First Quarter, Full, Last Quarter, New. */
  12. lunardistdeg numeric NULL, /* 'Moon Distance (Degrees)'. Explanation: Angular distance to the Moon in degrees. Data type: DECIMAL(7,2). Example: '97.52'. */
  13. solarstatus character varying NULL, /* 'Solar Activity'. Explanation: The level of solar activity at the time of observation. Data type: VARCHAR(35). Possible categories: High, Low, Moderate. */
  14. geomagstatus character varying NULL, /* 'Geomagnetic Activity'. Explanation: The level of geomagnetic activity during observation. Data type: VARCHAR(35). Possible categories: Active, Quiet, Storm. */
  15. sidereallocal character NULL, /* 'Local Sidereal Time'. Explanation: Sidereal time at the observatory in HH:MM:SS format. Data type: CHAR(8). Example: '12:34:56'. */
  16. airtempc numeric NULL, /* 'Air Temperature (°C)'. Explanation: Ambient temperature in Celsius. Data type: NUMERIC(5,2). Example: '18.45'. */
  17. humidityrate numeric NULL, /* 'Humidity (%)'. Explanation: Relative humidity as a percentage. Data type: NUMERIC(6,3). Example: '62.300'. */
  18. windspeedms numeric NULL, /* 'Wind Speed (m/s)'. Explanation: Wind speed in meters per second. Data type: NUMERIC(4,2). Example: '3.45'. */
  19. presshpa numeric NULL, /* 'Pressure (hPa)'. Explanation: Atmospheric pressure in hectopascals. Data type: DECIMAL(6,1). Example: '1013.2'. */
  20. PRIMARY KEY (observstation)
  21. );
  22.  
  23. First 3 rows:
  24. observstation weathprofile seeingprofile atmostransparency lunarstage lunardistdeg solarstatus geomagstatus sidereallocal airtempc humidityrate windspeedms presshpa
  25. --------------------------- -------------- --------------- ------------------- ------------- -------------- ------------- -------------- --------------- ---------- -------------- ------------- ----------
  26. Observatory-East Darrenport Clear Good 0.04 First Quarter 125.94 High Quiet 17.2762 37.6 21.5 26.7 1028
  27. Observatory-Pearsonstad Clear Poor 0.25 Full 100.56 Low Quiet 17.5804 -16.9 67.7 22 1022.3
  28. Observatory-New Lindastad Cloudy Good 0.21 Last Quarter 98.09 High Storm 10.9481 -12.5 25.7 4.4 1011
  29. ...
  30.  
  31.  
  32. CREATE TABLE "signaldynamics" (
  33. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Foreign key referencing the main signal. Data type: CHAR(36). Example: 'SIG-JKL-3456'. */
  34. sigintegrity character varying NULL, /* 'Signal Integrity'. Explanation: Rating of how intact or uncorrupted the signal is. Data type: VARCHAR(30). If no fixed categories, example: 'HighIntegrity'. */
  35. sigrecurr character varying NULL, /* 'Signal Recurrence'. Explanation: Whether the signal recurs over time. Data type: VARCHAR(25). Possible categories: None, Regular, Sporadic. */
  36. sigevolve character varying NULL, /* 'Signal Evolution'. Explanation: Indicates if the signal changes/evolves during observation. Data type: VARCHAR(25). Possible categories: Dynamic, Static, Unknown. */
  37. tempstab character varying NULL, /* 'Temporal Stability'. Explanation: How stable the signal remains over time. Data type: VARCHAR(20). If no fixed categories, example: 'Stable'. */
  38. spatstab character varying NULL, /* 'Spatial Stability'. Explanation: How stable the signal is spatially (e.g., consistent direction). Data type: VARCHAR(20). If no fixed categories, example: 'Moderate'. */
  39. freqstab character varying NULL, /* 'Frequency Stability'. Explanation: How stable the signal’s frequency is. Data type: VARCHAR(35). If no fixed categories, example: 'HighlyStable'. */
  40. phasestab character varying NULL, /* 'Phase Stability'. Explanation: Any variation in signal phase. Data type: VARCHAR(35). If no fixed categories, example: 'VaryingPhase'. */
  41. ampstab character varying NULL, /* 'Amplitude Stability'. Explanation: Consistency of signal amplitude. Data type: VARCHAR(20). If no fixed categories, example: 'Unstable'. */
  42. modstab character varying NULL, /* 'Modulation Stability'. Explanation: Consistency in the signal’s modulation scheme. Data type: VARCHAR(30). If no fixed categories, example: 'Consistent'. */
  43. sigcoherence character varying NULL, /* 'Signal Coherence'. Explanation: How coherent the signal remains over its duration. Data type: VARCHAR(25). If no fixed categories, example: 'HighCoherence'. */
  44. sigdisp character varying NULL, /* 'Signal Dispersion'. Explanation: The degree to which the signal is dispersed (time/frequency smearing). Data type: VARCHAR(25). If no fixed categories, example: 'SignificantDisp'. */
  45. sigscint character varying NULL, /* 'Signal Scintillation'. Explanation: Fluctuation in signal amplitude due to propagation effects. Data type: VARCHAR(45). If no fixed categories, example: 'MildScintillation'. */
  46. PRIMARY KEY (signalref),
  47. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  48. );
  49.  
  50. First 3 rows:
  51. No data available in this table.
  52.  
  53.  
  54. CREATE TABLE "telescopes" (
  55. telescregistry character NOT NULL, /* 'Telescope Registry'. Explanation: A unique identifier for the telescope. Data type: CHAR(20). Example: 'TELESC_0001'. */
  56. observstation character NOT NULL, /* 'Observatory Name Reference'. Explanation: Foreign key linking to the observatory station. Data type: CHAR(60). Example: 'OBS_STATION_ALPHA'. */
  57. equipstatus character varying NULL, /* 'Equipment Status'. Explanation: Operational state of the telescope. Data type: VARCHAR(35). Possible categories: Degraded, Maintenance, Operational. */
  58. calibrstatus character varying NULL, /* 'Calibration Status'. Explanation: Status of telescope’s calibration. Data type: VARCHAR(50). Possible categories: Current, Due, Overdue. */
  59. pointaccarc numeric NULL, /* 'Pointing Accuracy (arcsec)'. Explanation: How precise the telescope can point, in arcseconds. Data type: NUMERIC(6,2). Example: '0.45'. */
  60. trackaccarc numeric NULL, /* 'Tracking Accuracy (arcsec)'. Explanation: How accurately the telescope can track a target, in arcseconds. Data type: NUMERIC(6,2). Example: '1.20'. */
  61. focusquality character varying NULL, /* 'Focus Quality'. Explanation: Quality of the telescope’s focusing system. Data type: VARCHAR(25). Possible categories: Excellent, Good, Poor. */
  62. detecttempk numeric NULL, /* 'Detector Temperature (K)'. Explanation: Temperature of the telescope’s primary detector in Kelvin. Data type: DECIMAL(7,2). Example: '123.45'. */
  63. coolsysstatus character varying NULL, /* 'Cooling System Status'. Explanation: Status of the telescope’s cooling system. Data type: VARCHAR(35). Possible categories: Critical, Normal, Warning. */
  64. powerstatus character varying NULL, /* 'Power Supply Status'. Explanation: Indicates which power source or level is in use. Data type: VARCHAR(30). Possible categories: Backup, Critical, Main. */
  65. datastorstatus character varying NULL, /* 'Data Storage Status'. Explanation: Capacity and status of local data storage. Data type: VARCHAR(35). Possible categories: Available, Critical, Low. */
  66. netstatus character varying NULL, /* 'Network Status'. Explanation: Status of the network connection for telescope data transfer. Data type: VARCHAR(40). Possible categories: Connected, Disconnected, Limited. */
  67. bandusagepct numeric NULL, /* 'Bandwidth Usage (%)'. Explanation: Network bandwidth usage as a percentage. Data type: NUMERIC(5,2). Example: '73.25'. */
  68. procqueuestatus character varying NULL, /* 'Processing Queue Status'. Explanation: Indicates how full the processing queue is. Data type: VARCHAR(40). Possible categories: Empty, Full, Normal. */
  69. PRIMARY KEY (telescregistry),
  70. FOREIGN KEY (observstation) REFERENCES observatories(observstation)
  71. );
  72.  
  73. First 3 rows:
  74. telescregistry observstation equipstatus calibrstatus pointaccarc trackaccarc focusquality detecttempk coolsysstatus powerstatus datastorstatus netstatus bandusagepct procqueuestatus
  75. ---------------- --------------------------- ------------- -------------- ------------- ------------- -------------- ------------- --------------- ------------- ---------------- ------------ -------------- -----------------
  76. T4621 Observatory-East Darrenport Operational Current 3.85 5.47 Poor 227.34 Critical Main Available Limited 77.2 Full
  77. T3182 Observatory-Pearsonstad Degraded Due 3.96 1.58 Good 94.66 Warning Backup Available Disconnected 8.5 Empty
  78. T6585 Observatory-New Lindastad Degraded Current 6.93 9.4 Good 233.2 Normal Main Available Disconnected 48.2 Normal
  79. ...
  80.  
  81.  
  82. CREATE TABLE "researchprocess" (
  83. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Foreign key referencing the main signal record. Data type: CHAR(36). Example: 'SIG-MNO-7890'. */
  84. analysisprio text NULL, /* 'Analysis Priority'. Explanation: Priority assigned for analyzing this signal. Data type: TEXT. Possible categories: High, Low, Medium, Urgent. */
  85. followstat character varying NULL, /* 'Follow-up Status'. Explanation: Status of any follow-up observations. Data type: VARCHAR(25). Possible categories: Completed, Required, Scheduled. */
  86. peerrevstat character varying NULL, /* 'Peer Review Status'. Explanation: Where this signal stands in peer review. Data type: VARCHAR(25). Possible categories: Completed, In Progress, Pending. */
  87. pubstat character NULL, /* 'Publication Status'. Explanation: Whether findings about the signal have been published. Data type: CHAR(25). Possible categories: Draft, Published, Submitted. */
  88. resprio character varying NULL, /* 'Research Priority'. Explanation: How urgently this signal needs scientific attention. Data type: VARCHAR(30). Possible categories: High, Low, Medium. */
  89. fundstat character NULL, /* 'Funding Status'. Explanation: Funding situation for further study. Data type: VARCHAR(30). Possible categories: Funded, Pending, Unfunded. */
  90. collabstat character NULL, /* 'Collaboration Status'. Explanation: The nature of collaboration on this signal. Data type: VARCHAR(35). Possible categories: International, Solo, Team. */
  91. secclass character NULL, /* 'Security Classification'. Explanation: Visibility and clearance level for the data. Data type: CHAR(35). Possible categories: Classified, Public, Restricted. */
  92. discstat character varying NULL, /* 'Disclosure Status'. Explanation: How much information about the signal is shared publicly. Data type: VARCHAR(40). Possible categories: Full, None, Partial. */
  93. notesmemo text NULL, /* 'Research Notes'. Explanation: Any extra remarks or context by researchers. Data type: TEXT. Example: 'Project requires further funding...' */
  94. PRIMARY KEY (signalref),
  95. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  96. );
  97.  
  98. First 3 rows:
  99. signalref analysisprio followstat peerrevstat pubstat resprio fundstat collabstat secclass discstat notesmemo
  100. ----------- -------------- ------------ ------------- --------- --------- ---------- ------------- ---------- ---------- ----------------------------------------
  101. AS796980 Low Completed Completed Submitted Medium Unfunded International Classified
  102. AS745021 Medium Completed In Progress Published Low Pending Team Public Full
  103. AS499555 Urgent Scheduled Completed Published High Pending Solo Classified While why recognize what probably sport.
  104. ...
  105.  
  106.  
  107. CREATE TABLE "signals" (
  108. signalregistry character NOT NULL, /* 'Signal Registry'. Explanation: Unique ID for each signal record. Data type: CHAR(36). Example: 'SIG-123E4567-E89B'. */
  109. timemark timestamp with time zone NULL, /* 'Timestamp'. Explanation: The moment of signal detection. In some CSVs, it may be stored as an Excel serial date/time (e.g., '44302.55648' ≈ 2021-05-16 13:20:20 UTC). Data type: TIMESTAMPTZ. Example: '2025-08-01 13:45:00+00'. */
  110. telescref character NOT NULL, /* 'Telescope Reference'. Explanation: Foreign key to the telescope used for detection. Data type: CHAR(20). Example: 'TELESC_0001'. */
  111. detectinstr character varying NULL, /* 'Detection Instrument'. Explanation: The instrument type employed for detecting the signal. Data type: VARCHAR(50). Possible categories: Infrared Array, Optical Telescope, Quantum Detector, Radio Telescope. */
  112. signalclass character varying NULL, /* 'Signal Type'. Explanation: Broad classification of the detected signal. Data type: VARCHAR(50). Possible categories: Broadband, Continuous, Modulated, Narrowband, Pulsed. */
  113. sigstrdb numeric NULL, /* 'Signal Strength (dB)'. Explanation: Measured strength of the signal in decibels. Data type: NUMERIC(7,2). Example: '12.35'. */
  114. freqmhz numeric NULL, /* 'Frequency (MHz)'. Explanation: Signal’s nominal frequency in MHz. Data type: DECIMAL(9,3). Example: '1420.405'. */
  115. bwhz numeric NULL, /* 'Bandwidth (Hz)'. Explanation: Signal’s bandwidth in Hertz. Data type: DECIMAL(10,3). Example: '500000.000'. */
  116. centerfreqmhz numeric NULL, /* 'Center Frequency (MHz)'. Explanation: Center frequency of the detected signal in MHz. Data type: NUMERIC(8,3). Example: '1420.500'. */
  117. freqdrifthzs numeric NULL, /* 'Frequency Drift (Hz/s)'. Explanation: How fast the signal drifts in frequency over time. Data type: NUMERIC(9,3). Example: '0.123'. */
  118. doppshifthz double precision NULL, /* 'Doppler Shift (Hz)'. Explanation: Measured Doppler shift of the signal in Hertz. Data type: DOUBLE PRECISION. Example: '142.75'. */
  119. sigdursec numeric NULL, /* 'Signal Duration (s)'. Explanation: Total duration of the signal in seconds. Data type: NUMERIC(6,2). Example: '12.50'. */
  120. pulsepersec numeric NULL, /* 'Pulse Rate (pulses/sec)'. Explanation: Rate of pulse repetition in the signal. Data type: NUMERIC(6,3). Example: '4.500'. */
  121. pulsewidms numeric NULL, /* 'Pulse Width (ms)'. Explanation: Duration of each pulse in milliseconds. Data type: NUMERIC(6,3). Example: '2.300'. */
  122. modtype character varying NULL, /* 'Modulation Type'. Explanation: The method of signal modulation. Data type: VARCHAR(30). Possible categories: AM, FM, PM, QAM, Unknown. */
  123. modindex numeric NULL, /* 'Modulation Index'. Explanation: Numerical index describing modulation depth. Data type: DECIMAL(6,4). Example: '0.2875'. */
  124. carrierfreqmhz numeric NULL, /* 'Carrier Frequency (MHz)'. Explanation: Frequency of the carrier wave in MHz. Data type: DECIMAL(9,3). Example: '1000.000'. */
  125. phaseshiftdeg numeric NULL, /* 'Phase Shift (°)'. Explanation: Phase shift in degrees for the signal. Data type: NUMERIC(6,2). Example: '45.00'. */
  126. polarmode character varying NULL, /* 'Polarization Mode'. Explanation: Type of signal polarization. Data type: VARCHAR(30). Possible categories: Circular, Elliptical, Linear, Unknown. */
  127. polarangledeg numeric NULL, /* 'Polarization Angle (°)'. Explanation: Angle of polarization in degrees. Data type: DECIMAL(5,1). Example: '90.0'. */
  128. snrratio numeric NULL, /* 'Signal-to-Noise Ratio'. Explanation: SNR measured for the signal. Data type: DECIMAL(6,2). Example: '18.75'. */
  129. noisefloordbm double precision NULL, /* 'Noise Floor (dBm)'. Explanation: Measured noise floor in dBm. Data type: DOUBLE PRECISION. Example: '-85.3'. */
  130. interflvl character varying NULL, /* 'Interference Level'. Explanation: Degree of interference around the signal. Data type: VARCHAR(30). Possible categories: High, Low, Medium, None. */
  131. rfistat character varying NULL, /* 'RFI Status'. Explanation: Radio Frequency Interference status. Data type: VARCHAR(30). Possible categories: Clean, Contaminated, Unknown. */
  132. atmointerf character varying NULL, /* 'Atmospheric Interference'. Explanation: Impact of atmospheric conditions on signal. Data type: VARCHAR(30). Possible categories: Minimal, Moderate, Severe. */
  133. PRIMARY KEY (signalregistry),
  134. FOREIGN KEY (telescref) REFERENCES telescopes(telescregistry)
  135. );
  136.  
  137. First 3 rows:
  138. signalregistry timemark telescref detectinstr signalclass sigstrdb freqmhz bwhz centerfreqmhz freqdrifthzs doppshifthz sigdursec pulsepersec pulsewidms modtype modindex carrierfreqmhz phaseshiftdeg polarmode polarangledeg snrratio noisefloordbm interflvl rfistat atmointerf
  139. ---------------- -------------------------------- ----------- ----------------- ------------- ---------- --------- ------ --------------- -------------- ------------- ----------- ------------- ------------ --------- ---------- ---------------- --------------- ----------- --------------- ---------- --------------- ----------- ------------ ------------
  140. AS796980 2021-04-16 13:21:19.864197+08:00 T4621 Quantum Detector Narrowband -186.96 95636.3 401.34 4363.09 0.072 143.65 2660.7 4.286 480.95 FM 0.384 65710.4 268.84 Unknown 127.4 26.19 -140.27 High Unknown Severe
  141. AS745021 2022-06-15 16:04:26.868816+08:00 T3182 Optical Telescope Broadband -154.72 43019.4 316.03 82505.9 2.204 777.42 3513.05 9.047 695.24 Unknown 0.532 81576.6 343.61 Linear 16.4 18.01 -105.55 High Contaminated Moderate
  142. AS499555 2019-01-18 07:53:35.868816+08:00 T6585 Radio Telescope Modulated -111.19 28682.2 563.64 6161.35 5.668 -665.39 1627.84 1.072 6.78 Unknown 0.893 52348.2 339.52 Elliptical 119.6 20.82 -128.04 High Unknown Moderate
  143. ...
  144.  
  145.  
  146. CREATE TABLE "observationalconditions" (
  147. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Primary key referencing the signal. Data type: CHAR(36). Example: 'SIG-PQR-9876'. */
  148. obstime time without time zone NULL, /* 'Observation Time'. Explanation: Local time of the observation in HH:MM:SS. Data type: TIME. Example: '13:45:59'. */
  149. obsdate date NULL, /* 'Observation Date'. Explanation: Local date of the observation (YYYY-MM-DD). Data type: DATE. Example: '2025-08-01'. */
  150. obsdurhrs numeric NULL, /* 'Observation Duration (hours)'. Explanation: How long the observation lasted in hours. Data type: NUMERIC(5,2). Example: '2.50'. */
  151. PRIMARY KEY (signalref),
  152. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  153. );
  154.  
  155. First 3 rows:
  156. signalref obstime obsdate obsdurhrs
  157. ----------- --------- ---------- -----------
  158. AS796980 00:00:00 2018-11-27 22.04
  159. AS745021 00:00:00 2024-09-02 2.35
  160. AS499555 00:00:00 2023-03-15 6.88
  161. ...
  162.  
  163.  
  164. CREATE TABLE "signalprobabilities" (
  165. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Primary key referencing the main signal record. Data type: CHAR(36). Example: 'SIG-XYZ-9876'. */
  166. falseposprob numeric NULL, /* 'False Positive Probability'. Explanation: Probability that the signal is falsely detected. Data type: DECIMAL(5,4). Example: '0.0135'. */
  167. sigunique numeric NULL, /* 'Signal Uniqueness'. Explanation: A measure of how unique the signal is compared to others. Data type: DECIMAL(7,4). Example: '99.1234'. */
  168. simindex numeric NULL, /* 'Similarity Index'. Explanation: Compares the signal to known references. Data type: NUMERIC(5,4). Example: '0.8222'. */
  169. corrscore numeric NULL, /* 'Correlation Score'. Explanation: How well the signal aligns with expected patterns. Data type: DECIMAL(5,4). Example: '0.9950'. */
  170. anomscore double precision NULL, /* 'Anomaly Score'. Explanation: How unusual or unexpected the signal is. Data type: FLOAT. Example: '1.23'. */
  171. techsigprob numeric NULL, /* 'Technosignature Probability'. Explanation: Probability that the signal is of artificial technological origin. Data type: DECIMAL(5,4). Example: '0.6789'. */
  172. biosigprob numeric NULL, /* 'Biosignature Probability'. Explanation: Probability that the signal indicates a biological origin. Data type: DECIMAL(6,2). Example: '45.21'. */
  173. natsrcprob numeric NULL, /* 'Natural Source Probability'. Explanation: Probability the signal is from a natural source. Data type: NUMERIC(7,3). Example: '98.761'. */
  174. artsrcprob numeric NULL, /* 'Artificial Source Probability'. Explanation: Probability the signal is from an artificial source. Data type: NUMERIC(3,1). Example: '3.4'. */
  175. PRIMARY KEY (signalref),
  176. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  177. );
  178.  
  179. First 3 rows:
  180. signalref falseposprob sigunique simindex corrscore anomscore techsigprob biosigprob natsrcprob artsrcprob
  181. ----------- -------------- ----------- ---------- ----------- ----------- ------------- ------------ ------------ ------------
  182. AS796980 0.033 0.73 0.198 0.937 0.941 0.317 0.88 0.574 0.1
  183. AS745021 0.758 0.744 0.986 -0.109 0.488 0.179 0 0.14 0.9
  184. AS499555 0.467 0.301 0.803 0.333 0.139 0.273 0.33 0.226 0.8
  185. ...
  186.  
  187.  
  188. CREATE TABLE "sourceproperties" (
  189. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Foreign key referencing the main signal. Data type: CHAR(36). Example: 'SIG-STU-5432'. */
  190. sourceradeg numeric NULL, /* 'Right Ascension (°)'. Explanation: RA of the source in degrees (0 to 360). Data type: DECIMAL(7,4). Example: '123.4567'. */
  191. sourcedecdeg numeric NULL, /* 'Declination (°)'. Explanation: Declination of the source in degrees (-90 to +90). Data type: DECIMAL(7,4). Example: '-20.4567'. */
  192. sourcedistly numeric NULL, /* 'Distance (ly)'. Explanation: Approximate distance to the source in light-years. Data type: NUMERIC(10,2). Example: '26000.45'. */
  193. gallong numeric NULL, /* 'Galactic Longitude (°)'. Explanation: Galactic longitude of the source. Data type: DECIMAL(6,2). Example: '12.34'. */
  194. gallat numeric NULL, /* 'Galactic Latitude (°)'. Explanation: Galactic latitude of the source. Data type: DECIMAL(6,2). Example: '-5.67'. */
  195. celestobj character varying NULL, /* 'Celestial Object'. Explanation: Broad classification of the object. Data type: VARCHAR(75). Possible categories: Galaxy, Planet, Star, Unknown. */
  196. objtype character varying NULL, /* 'Object Subtype'. Explanation: More specific object type. Data type: VARCHAR(50). Possible categories: Dwarf, Giant, Main Sequence, Unknown. */
  197. objmag numeric NULL, /* 'Apparent Magnitude'. Explanation: Brightness of the object as seen from Earth. Data type: NUMERIC(5,2). Example: '7.35'. */
  198. objtempk integer NULL, /* 'Object Temperature (K)'. Explanation: Approximate surface temperature in Kelvin. Data type: INTEGER. Example: '5800'. */
  199. objmasssol numeric NULL, /* 'Object Mass (solar)'. Explanation: Mass relative to the Sun. Data type: DECIMAL(6,3). Example: '1.005'. */
  200. objagegyr numeric NULL, /* 'Object Age (Gyr)'. Explanation: Estimated age in billions of years. Data type: DECIMAL(6,3). Example: '4.500'. */
  201. objmetal numeric NULL, /* 'Metallicity'. Explanation: Ratio of elements heavier than helium in the object. Data type: NUMERIC(5,3). Example: '0.012'. */
  202. objpropmotion numeric NULL, /* 'Proper Motion (mas/yr)'. Explanation: Apparent motion across the sky in milliarcseconds/year. Data type: DECIMAL(7,2). Example: '55.12'. */
  203. objradvel numeric NULL, /* 'Radial Velocity (km/s)'. Explanation: Speed at which the object is moving toward/away from us. Data type: DECIMAL(7,2). Example: '-23.45'. */
  204. PRIMARY KEY (signalref),
  205. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  206. );
  207.  
  208. First 3 rows:
  209. No data available in this table.
  210.  
  211.  
  212. CREATE TABLE "signaladvancedphenomena" (
  213. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Primary key referencing the main signal. Data type: CHAR(36). Example: 'SIG-ABC-1234'. */
  214. intermedeffects character varying NULL, /* 'Interstellar Medium Effects'. Explanation: Impact of interstellar medium on the signal. Data type: VARCHAR(40). Possible categories: Minimal, Moderate, Severe. */
  215. gravlens character varying NULL, /* 'Gravitational Lensing'. Explanation: Whether the signal is affected by gravitational lensing. Data type: VARCHAR(50). Possible categories: None, Strong, Weak. */
  216. quanteffects character varying NULL, /* 'Quantum Effects'. Explanation: Quantum-level phenomena observed in the signal. Data type: VARCHAR(85). Possible categories: None, Observed, Significant. */
  217. encryptevid character varying NULL, /* 'Encryption Evidence'. Explanation: Whether there is indication the signal is encrypted. Data type: VARCHAR(40). Possible categories: None, Possible, Strong. */
  218. langstruct text NULL, /* 'Language Structure'. Explanation: Presence of linguistic or structured patterns. Data type: TEXT. Possible categories: Complex, None, Simple. */
  219. msgcontent text NULL, /* 'Message Content'. Explanation: Indicates whether an actual message was detected. Data type: TEXT. Possible categories: Identified, None, Possible. */
  220. cultsig character varying NULL, /* 'Cultural Significance'. Explanation: The level of cultural impact or interest. Data type: VARCHAR(60). Possible categories: High, Low, None. */
  221. sciimpact character varying NULL, /* 'Scientific Impact'. Explanation: Significance of the signal to scientific research. Data type: VARCHAR(50). Possible categories: Major, Minor, Moderate. */
  222. PRIMARY KEY (signalref),
  223. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  224. );
  225.  
  226. First 3 rows:
  227. signalref intermedeffects gravlens quanteffects encryptevid langstruct msgcontent cultsig sciimpact
  228. ----------- ----------------- ---------- -------------- ------------- ------------ ------------ --------- -----------
  229. AS796980 Severe Weak Significant Strong Complex Identified High Major
  230. AS745021 Minimal Significant Strong Simple Major
  231. AS499555 Minimal Weak Strong Simple Possible Major
  232. ...
  233.  
  234.  
  235. CREATE TABLE "signalclassification" (
  236. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Foreign key referencing the main signal. Data type: CHAR(36). Example: 'SIG-DEF-5678'. */
  237. sigclasstype character varying NULL, /* 'Classification Type'. Explanation: High-level category for the signal. Data type: VARCHAR(40). Possible categories: Artificial, Candidate, Natural, Unknown. */
  238. sigpattern character varying NULL, /* 'Signal Pattern'. Explanation: Pattern observed in the signal. Data type: VARCHAR(60). Possible categories: Periodic, Random, Structured, Unknown. */
  239. repeatcount smallint NULL, /* 'Repetition Count'. Explanation: Number of times the signal has repeated. Data type: SMALLINT. Example: '3'. */
  240. periodsec numeric NULL, /* 'Period (s)'. Explanation: Duration of each cycle if periodic. Data type: NUMERIC(7,3). Example: '12.345'. */
  241. complexidx numeric NULL, /* 'Complexity Index'. Explanation: Numeric measure of the signal’s complexity. Data type: DECIMAL(6,3). Example: '5.678'. */
  242. entropyval numeric NULL, /* 'Entropy'. Explanation: Entropy measurement of the signal. Data type: DECIMAL(6,2). Example: '3.45'. */
  243. infodense numeric NULL, /* 'Information Density'. Explanation: Estimated information per unit time/frequency. Data type: DECIMAL(6,3). Example: '2.345'. */
  244. classconf numeric NULL, /* 'Classification Confidence (%)'. Explanation: How confident we are in the assigned signal class. Data type: DECIMAL(5,2). Example: '92.50'. */
  245. PRIMARY KEY (signalref),
  246. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  247. );
  248.  
  249. First 3 rows:
  250. No data available in this table.
  251.  
  252.  
  253. CREATE TABLE "signaldecoding" (
  254. signalref character NOT NULL, /* 'Signal Registry Reference'. Explanation: Foreign key referencing the main signal entry. Data type: CHAR(36). Example: 'SIG-GHI-9012'. */
  255. encodetype character varying NULL, /* 'Encoding Type'. Explanation: The type of signal encoding used (e.g., Binary). Data type: VARCHAR(40). Possible categories: Binary, Complex, Tertiary, Unknown. */
  256. compressratio numeric NULL, /* 'Compression Ratio'. Explanation: Factor by which the raw signal data was compressed. Data type: DECIMAL(6,3). Example: '2.500'. */
  257. errcorrlvl character varying NULL, /* 'Error Correction Level'. Explanation: Degree of error correction applied. Data type: VARCHAR(35). Possible categories: High, Low, Medium, None. */
  258. decodeconf numeric NULL, /* 'Decoding Confidence (%)'. Explanation: Confidence level that the decoding is correct. Data type: DECIMAL(5,2). Example: '88.75'. */
  259. decodemethod character varying NULL, /* 'Decoding Method'. Explanation: Method used to decode the signal. Data type: VARCHAR(35). Possible categories: FFT, Neural Network, Quantum, Wavelet. */
  260. decodestat character varying NULL, /* 'Decoding Status'. Explanation: Status of the decoding process. Data type: VARCHAR(25). Possible categories: Completed, Failed, In Progress. */
  261. decodeiters smallint NULL, /* 'Decoding Iterations'. Explanation: Number of algorithmic passes attempted. Data type: SMALLINT. Example: '7'. */
  262. proctimehrs numeric NULL, /* 'Processing Time (hours)'. Explanation: Total hours spent decoding. Data type: DECIMAL(6,2). Example: '3.50'. */
  263. compresources character varying NULL, /* 'Computational Resources'. Explanation: Level of computing power used. Data type: VARCHAR(50). Possible categories: Extreme, High, Low, Medium. */
  264. analysisdp character varying NULL, /* 'Analysis Depth'. Explanation: How thoroughly the signal was analyzed. Data type: VARCHAR(25). Possible categories: Comprehensive, Detailed, Preliminary. */
  265. veriflvl character varying NULL, /* 'Verification Level'. Explanation: Extent to which decoding has been verified. Data type: VARCHAR(30). Possible categories: Partially, Unverified, Verified. */
  266. confirmstat character varying NULL, /* 'Confirmation Status'. Explanation: Whether the decoding results have been confirmed. Data type: VARCHAR(30). Possible categories: Confirmed, Pending, Rejected. */
  267. PRIMARY KEY (signalref),
  268. FOREIGN KEY (signalref) REFERENCES signals(signalregistry)
  269. );
  270.  
  271. First 3 rows:
  272. signalref encodetype compressratio errcorrlvl decodeconf decodemethod decodestat decodeiters proctimehrs compresources analysisdp veriflvl confirmstat
  273. ----------- ------------ --------------- ------------ ------------ -------------- ------------ ------------- ------------- --------------- ------------- ---------- -------------
  274. AS796980 Unknown 5.03 Medium 98.6 Wavelet Completed 103 193.8 High Comprehensive Partially Pending
  275. AS745021 Unknown 1.28 Medium 76.3 FFT In Progress 684 276.22 Low Detailed Partially Confirmed
  276. AS499555 Unknown 9.2 Low 25.6 FFT Completed 486 796.01 High Comprehensive Unverified Pending
  277. ...
  278. </СХЕМА БАЗЫ ДАННЫХ>
  279. <СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
  280. {"id": 0, "knowledge": "Signal-to-Noise Quality Indicator (SNQI)", "description": "Combines SNR and noise floor to provide a unified signal quality metric.", "definition": "$\\text{SNQI} = \\text{SnrRatio} - 0.1 \\times |\\text{NoiseFloorDbm}|$, where higher values indicate better detection quality. Positive values generally indicate analyzable signals.", "type": "calculation_knowledge", "children_knowledge": -1}
  281. {"id": 1, "knowledge": "Atmospheric Observability Index (AOI)", "description": "Quantifies how conducive atmospheric conditions are for signal detection.", "definition": "$\\text{AOI} = \\text{AtmosTransparency} \\times (1 - \\frac{\\text{HumidityRate}}{100}) \\times (1 - 0.02 \\times \\text{WindSpeedMs})$, where values closer to 1 indicate ideal observation conditions.", "type": "calculation_knowledge", "children_knowledge": -1}
  282. {"id": 2, "knowledge": "Signal Complexity Ratio (SCR)", "description": "Measures the relationship between signal complexity and information density.", "definition": "$\\text{SCR} = \\frac{\\text{ComplexIdx} \\times \\text{InfoDense}}{\\log(\\text{BwHz})}$, where higher values suggest potential artificial origin rather than natural phenomena.", "type": "calculation_knowledge", "children_knowledge": -1}
  283. {"id": 3, "knowledge": "Technological Origin Likelihood Score (TOLS)", "description": "Combines multiple factors to estimate likelihood of technological origin.", "definition": "$\\text{TOLS} = \\text{TechSigProb} \\times (1 - \\text{NatSrcProb}) \\times \\text{SigUnique} \\times (0.5 + \\frac{\\text{AnomScore}}{10})$, where values above 0.75 warrant further investigation as potential technosignatures.", "type": "calculation_knowledge", "children_knowledge": -1}
  284. {"id": 4, "knowledge": "Bandwidth-Frequency Ratio (BFR)", "description": "Measures the proportion of bandwidth to center frequency, helping identify signal type.", "definition": "$\\text{BFR} = \\frac{\\text{BwHz}}{\\text{CenterFreqMhz} \\times 10^6}$, where narrow ratios ($<0.001$) often indicate technological signals while wider ratios suggest natural phenomena.", "type": "calculation_knowledge", "children_knowledge": -1}
  285. {"id": 5, "knowledge": "Detection Instrument Sensitivity Factor (DISF)", "description": "Calculates the effective sensitivity of the detection setup based on telescope and environmental factors.", "definition": "$\\text{DISF} = (10 - \\frac{|\\text{AirTempC} - 15|}{10}) \\times \\text{AtmosTransparency} \\times (1 - \\frac{\\text{HumidityRate}}{200}) \\times \\frac{100 - \\text{LunarDistDeg}}{100}$, where values closer to 10 indicate optimal detection sensitivity.", "type": "calculation_knowledge", "children_knowledge": -1}
  286. {"id": 6, "knowledge": "Encoding Complexity Index (ECI)", "description": "Evaluates the sophistication of potential encoding in the signal.", "definition": "$\\text{ECI} = \\frac{\\text{CompressRatio} \\times \\text{ComplexIdx} \\times \\text{EntropyVal}}{10}$, where values above 1.5 suggest deliberate information encoding rather than random patterns.", "type": "calculation_knowledge", "children_knowledge": -1}
  287. {"id": 7, "knowledge": "Signal Stability Metric (SSM)", "description": "Quantifies overall temporal and spectral stability of a signal.", "definition": "$\\text{SSM} = (1 - \\frac{|\\text{FreqDriftHzs}|}{\\text{FreqMhz} \\times 1000}) \\times \\frac{\\text{SigDurSec}}{1 + \\frac{\\text{DoppShiftHz}}{1000}}$, where higher values indicate more stable signals typical of fixed transmitters.", "type": "calculation_knowledge", "children_knowledge": -1}
  288. {"id": 8, "knowledge": "Research Priority Index (RPI)", "description": "Helps researchers prioritize signals for follow-up based on multiple factors.", "definition": "$\\text{RPI} = (\\text{TechSigProb} \\times 4 + \\frac{\\text{BioSigProb}}{100} + \\text{SigUnique} \\times 2 + \\frac{\\text{AnomScore}}{2}) \\times (1 - \\text{FalsePosProb})$, where values above 3 indicate high research priority.", "type": "calculation_knowledge", "children_knowledge": -1}
  289. {"id": 9, "knowledge": "Lunar Interference Factor (LIF)", "description": "Calculates the potential interference from lunar illumination on observations.", "definition": "$\\text{LIF} = (1 - \\frac{\\text{LunarDistDeg}}{180}) \\times (1 - \\text{AtmosTransparency})$, where higher values indicate more lunar interference. Values above 0.5 suggest significant lunar contamination in data.", "type": "calculation_knowledge", "children_knowledge": -1}
  290. {"id": 10, "knowledge": "Technosignature", "description": "Defines the concept of signals that indicate technological activity.", "definition": "A signal with $\\text{TechSigProb} > 0.7$, $\\text{NatSrcProb} < 0.3$, and $\\text{ArtSrcProb} < 50$ that exhibits narrow bandwidth ($\\text{BFR} < 0.001$) and high information density ($\\text{InfoDense} > 0.8$).", "type": "domain_knowledge", "children_knowledge": [4]}
  291. {"id": 11, "knowledge": "Coherent Information Pattern (CIP)", "description": "Identifies signals showing patterns consistent with deliberate information transmission.", "definition": "Signals characterized by high signal stability ($\\text{SSM} > 0.8$), organized information structure ($\\text{EntropyVal}$ between 0.4-0.8), and consistent modulation ($\\text{ModType}$ with $\\text{ModIndex} > 0.5$).", "type": "domain_knowledge", "children_knowledge": [7]}
  292. {"id": 12, "knowledge": "Target of Opportunity (TOO)", "description": "Identifies high-value signals requiring immediate follow-up observation.", "definition": "Any signal with $\\text{RPI} > 3.5$, $\\text{TechSigProb} > 0.8$, and $\\text{AnomScore} > 5$ that has not been previously documented or explained by known phenomena.", "type": "domain_knowledge", "children_knowledge": [8]}
  293. {"id": 13, "knowledge": "Optimal Observing Window (OOW)", "description": "Defines conditions when observational quality is maximized.", "definition": "Time periods when $\\text{AOI} > 0.85$, $\\text{LunarStage}$ is 'New' or 'First Quarter', $\\text{LunarDistDeg} > 45$, and $\\text{SolarStatus}$ is 'Low' or 'Moderate'.", "type": "domain_knowledge", "children_knowledge": [1, 9]}
  294. {"id": 14, "knowledge": "Signal Degradation Scenario (SDS)", "description": "Characterizes situations where signal quality is compromised by environmental factors.", "definition": "Observation conditions where one or more of: $\\text{AtmosTransparency} < 0.7$, $\\text{HumidityRate} > 70$, $\\text{WindSpeedMs} > 8$, or $\\text{GeomagStatus}$ contains 'Storm', resulting in compromised data quality.", "type": "domain_knowledge", "children_knowledge": [1]}
  295. {"id": 15, "knowledge": "Narrowband Technological Marker (NTM)", "description": "Identifies a specific signature associated with technological transmission.", "definition": "Signals with extremely narrow bandwidth ($\\text{BFR} < 0.0001$), stable frequency ($\\text{FreqDriftHzs} < 0.1$).", "type": "domain_knowledge", "children_knowledge": [4]}
  296. {"id": 16, "knowledge": "Observational Confidence Level (OCL)", "description": "Rates the reliability of observations based on conditions and equipment.", "definition": "A classification system with three tiers: 'High' ($\\text{AOI} > 0.8$, $\\text{EquipStatus} = \\text{'Operational'}$, $\\text{CalibrStatus} = \\text{'Current'}$), 'Medium' ($\\text{AOI}$ 0.5-0.8, minor equipment issues), and 'Low' ($\\text{AOI} < 0.5$ or significant equipment problems).", "type": "domain_knowledge", "children_knowledge": [1]}
  297. {"id": 17, "knowledge": "Potential Biosignature", "description": "Defines characteristics of signals potentially associated with biological processes.", "definition": "Signals with $\\text{BioSigProb} > 0.6$, $\\text{TechSigProb} < 0.4$, and spectral features that match known biological emission patterns, often associated with specific molecular transitions.", "type": "domain_knowledge", "children_knowledge": -1}
  298. {"id": 18, "knowledge": "Encoded Information Transfer (EIT)", "description": "Characterizes signals that appear to contain deliberate information encoding.", "definition": "Signals with $\\text{ECI} > 1.8$, $\\text{EntropyVal}$ between 0.3-0.7 (not random but structured), and consistent internal patterns that suggest language or data encoding schemes.", "type": "domain_knowledge", "children_knowledge": [6]}
  299. {"id": 19, "knowledge": "Fast Radio Transient (FRT)", "description": "Defines a specific class of brief, high-energy radio emissions.", "definition": "Signals with extremely short duration ($\\text{SigDurSec} < 0.1$), high signal strength ($\\text{SigStrDb} > 15$), broad bandwidth ($\\text{BwHz} > 1000000$), and no periodicity ($\\text{RepeatCount} = 1$).", "type": "domain_knowledge", "children_knowledge": -1}
  300. {"id": 20, "knowledge": "WeathProfile: Clear", "description": "Illustrates optimal weather conditions for signal detection.", "definition": "Indicates pristine sky conditions with no clouds, usually associated with $\\text{AtmosTransparency} > 0.9$, low $\\text{HumidityRate} (< 40\\%)$, and minimal $\\text{WindSpeedMs} (< 3.0)$. Provides ideal visibility for optical observations and minimal atmospheric interference for radio observations.", "type": "value_illustration", "children_knowledge": -1}
  301. {"id": 21, "knowledge": "SeeingProfile: Excellent", "description": "Illustrates superior atmospheric seeing conditions.", "definition": "Describes atmospheric conditions with minimal turbulence, allowing for sharp, detailed observations. Typically corresponds to image stability better than 1 arcsecond and is often associated with stable temperature gradients and low wind speeds ($\\text{WindSpeedMs} < 2.5$).", "type": "value_illustration", "children_knowledge": -1}
  302. {"id": 22, "knowledge": "SignalClass: Narrowband", "description": "Illustrates characteristics of narrowband signal detections.", "definition": "Describes signals occupying a very narrow portion of the spectrum (typically $\\text{BFR} < 0.0001$). Often associated with technological origins as natural sources rarely produce such spectrally confined emissions. These signals are particularly interesting in SETI research.", "type": "value_illustration", "children_knowledge": [4]}
  303. {"id": 23, "knowledge": "GeomagStatus: Major Storm", "description": "Illustrates severe geomagnetic disturbance conditions.", "definition": "Indicates intense solar-induced geomagnetic activity with Kp index ≥ 7. During such conditions, ionospheric perturbations significantly affect radio observations below 100 MHz, aurora may be visible at mid-latitudes, and satellite communications may experience disruptions.", "type": "value_illustration", "children_knowledge": -1}
  304. {"id": 24, "knowledge": "CIP Classification Label", "description": "Three-tier rating system for evaluating signal coherence against intelligent transmission criteria.", "definition": "Classification labels: 'Coherent Information Pattern Detected' ($\\text{SSM} > 0.8$, $\\text{EntropyVal}$ between 0.4-0.8, and $\\text{ModIndex} > 0.5$), 'Potential Information Pattern' ($\\text{SSM} > 0.6$ and $\\text{EntropyVal}$ between 0.3-0.9$), or 'No Clear Pattern' (all other signals).", "type": "domain_knowledge", "children_knowledge": [7, 11]}
  305. {"id": 25, "knowledge": "SigClassType: Broadband Transient", "description": "Illustrates a class of brief signals covering wide frequency ranges.", "definition": "Describes short-duration signals ($\\text{SigDurSec}$ typically $< 5$) that span a large portion of the spectrum ($\\text{BFR} > 0.1$). Examples include solar radio bursts, lightning discharges, and certain types of cosmic explosions like Fast Radio Bursts (FRBs).", "type": "value_illustration", "children_knowledge": [4]}
  306. {"id": 26, "knowledge": "PolarMode: Circular", "description": "Illustrates circular polarization in detected signals.", "definition": "Describes electromagnetic waves where the electric field vector rotates in a circular pattern as the wave propagates. Circular polarization maintaining high purity across frequency (indicated by $\\text{PolarAngleDeg}$ stability) is rare in natural sources and may indicate technological origin.", "type": "value_illustration", "children_knowledge": -1}
  307. {"id": 27, "knowledge": "EncryptEvid: Strong Pattern", "description": "Illustrates characteristics suggesting deliberate signal encoding.", "definition": "Indicates detection of non-random, internally consistent patterns that resist simple decoding but show hallmarks of designed encryption or encoding. Characterized by high $\\text{EntropyVal} (> 0.7)$ combined with structural regularity that defies natural explanation.", "type": "value_illustration", "children_knowledge": -1}
  308. {"id": 28, "knowledge": "EncodeType: Frequency Hopping", "description": "Illustrates a sophisticated encoding method used in telecommunications.", "definition": "Describes a transmission technique where the signal rapidly switches frequencies according to a predetermined sequence. Detection would be characterized by discontinuous spectral features that follow a pattern. This technique is used on Earth to secure communications and reduce interference.", "type": "value_illustration", "children_knowledge": -1}
  309. {"id": 29, "knowledge": "FalsePosProb: <0.01", "description": "Illustrates extremely high confidence in signal detection.", "definition": "Indicates less than 1% probability that the signal is a false detection or artifact. Such low false positive probability typically results from multiple independent confirmations, excellent signal strength (high $\\text{SnrRatio}$), and elimination of all known terrestrial and instrumental sources.", "type": "value_illustration", "children_knowledge": -1}
  310. {"id": 30, "knowledge": "Modulation Complexity Score (MCS)", "description": "Quantifies the sophistication of signal modulation based on type and stability.", "definition": "$\\text{MCS} = \\text{ModIndex} \\times (1 + \\text{SSM}) \\times M_{\\text{factor}}$, where $M_{\\text{factor}}$ is 2 for $\\text{ModType} = \\text{'AM'}$, 1.5 for 'FM', and 1 for other types. Incorporates Signal Stability Metric (SSM) to weight stable modulations higher.", "type": "calculation_knowledge", "children_knowledge": [7]}
  311. {"id": 31, "knowledge": "Artificial Intelligence Detection Probability (AIDP)", "description": "Calculates likelihood of artificial intelligence origin based on encoding complexity and technosignature indicators.", "definition": "$\\text{AIDP} = \\frac{\\text{ECI} \\times \\text{TOLS}}{1 + \\text{NatSrcProb}}$, where ECI (Encoding Complexity Index) and TOLS (Technological Origin Likelihood Score) are weighted against natural source probability.", "type": "calculation_knowledge", "children_knowledge": [6, 3]}
  312. {"id": 32, "knowledge": "Observation Quality Factor (OQF)", "description": "Provides a comprehensive measure of observational conditions quality.", "definition": "$\\text{OQF} = \\text{AOI} \\times (1 - \\text{LIF}) \\times (\\text{PointAccArc} < 2 ? 1 : \\frac{2}{\\text{PointAccArc}})$, where AOI (Atmospheric Observability Index) and LIF (Lunar Interference Factor) are combined with telescope pointing accuracy.", "type": "calculation_knowledge", "children_knowledge": [1, 9]}
  313. {"id": 33, "knowledge": "Information Entropy Ratio (IER)", "description": "Compares signal entropy to expected natural background entropy.", "definition": "$\\text{IER} = \\frac{\\text{EntropyVal}}{\\text{NatSrcProb} \\times 0.9 + 0.1}$, where values significantly greater than 1 suggest non-natural information content. Uses NatSrcProb as a baseline for expected natural entropy.", "type": "calculation_knowledge", "children_knowledge": -1}
  314. {"id": 34, "knowledge": "Signal Processing Efficiency Index (SPEI)", "description": "Evaluates the computational efficiency of signal processing relative to complexity.", "definition": "$\\text{SPEI} = \\frac{\\text{DecodeIters} \\times \\text{ProcTimeHrs}}{\\text{ECI} \\times \\text{ComplexIdx}}$, where ECI (Encoding Complexity Index) provides the complexity component to normalize processing time and iterations.", "type": "calculation_knowledge", "children_knowledge": [6]}
  315. {"id": 35, "knowledge": "Celestial Location Significance Factor (CLSF)", "description": "Calculates significance of signal source location based on astronomical targets of interest.", "definition": "$\\text{CLSF} = (\\text{CelestObj} ? 2 : 1) \\times (\\text{ObjType} == \\text{'Giant'} \\&\\& \\text{ObjMassSol} \\text{ between } 0.8 \\text{ and } 1.2 ? 1.5 : 1) \\times (\\text{ObjMetal} > 0 ? \\text{ObjMetal} + 1 : 0.5)$, where higher values indicate source locations more likely to harbor intelligent life.", "type": "calculation_knowledge", "children_knowledge": -1}
  316. {"id": 36, "knowledge": "Confirmation Confidence Score (CCS)", "description": "Quantifies overall confidence in signal verification across multiple parameters.", "definition": "$\\text{CCS} = (1 - \\text{FalsePosProb}) \\times \\text{DecodeConf} \\times \\text{ClassConf} \\times (\\text{SNQI} > 0 ? \\frac{\\text{SNQI}}{10} + 0.5 : 0.1)$, where SNQI (Signal-to-Noise Quality Indicator) provides a quality weighting factor.", "type": "calculation_knowledge", "children_knowledge": [0]}
  317. {"id": 37, "knowledge": "Habitable Zone Signal Relevance (HZSR)", "description": "Assesses signal relevance based on source's position in habitable zone.", "definition": "$\\text{HZSR} = \\text{TOLS} \\times (\\text{ObjType} == \\text{'Dwarf'} ? (0.7 \\leq \\text{ObjMassSol} \\leq 1.4 ? (0.8 \\leq \\frac{\\text{SourceDistLy}}{\\sqrt{\\text{ObjMassSol}}} \\leq 1.7 ? 2 : 0.5) : 0.3) : 0.1)$, where TOLS (Technological Origin Likelihood Score) is weighted by stellar habitability factors.", "type": "calculation_knowledge", "children_knowledge": [3]}
  318. {"id": 38, "knowledge": "Pattern Recognition Confidence (PRC)", "description": "Measures confidence in identified signal patterns based on multiple factors.", "definition": "$\\text{PRC} = (\\text{RepeatCount} > 1 ? 1 + \\log_{10}(\\text{RepeatCount}) : 0.5) \\times (\\text{EntropyVal} < 0.9 ? 1 : 0.3) \\times \\text{SCR}$, where SCR (Signal Complexity Ratio) provides complexity weighting.", "type": "calculation_knowledge", "children_knowledge": [2]}
  319. {"id": 39, "knowledge": "NTM Classification System", "description": "A tiered classification system for Narrowband Technological Markers based on signal characteristics.", "definition": "Three-tier classification: 'Strong NTM' (BFR < 0.0001 AND FreqDriftHzs < 0.1 AND non-natural modulation), 'Moderate NTM' (BFR < 0.0005 AND FreqDriftHzs < 0.5 AND non-natural modulation), and 'Not NTM' (all other signals).", "type": "domain_knowledge", "children_knowledge": [15, 4]}
  320. {"id": 40, "knowledge": "High-Confidence Technosignature", "description": "Defines signals with extremely high likelihood of technological origin.", "definition": "A Technosignature with $\\text{CCS} > 0.9$, $\\text{MCS} > 1.5$, and $\\text{AIDP} > 0.8$, indicating a signal that meets the basic Technosignature criteria with additional confirmation through modulation complexity and artificial intelligence detection markers.", "type": "domain_knowledge", "children_knowledge": [10, 30, 31, 36]}
  321. {"id": 41, "knowledge": "Habitable Zone Transmission", "description": "Identifies signals originating from stellar habitable zones with technological characteristics.", "definition": "A signal with $\\text{HZSR} > 1.5$ and Technosignature characteristics, originating from a star system with conditions potentially suitable for life, making it a priority candidate for SETI research.", "type": "domain_knowledge", "children_knowledge": [10, 37]}
  322. {"id": 42, "knowledge": "Multi-Channel Communication Protocol", "description": "Identifies signal patterns consistent with sophisticated communication protocols.", "definition": "Signal exhibiting Coherent Information Pattern (CIP) characteristics across multiple frequency channels with coordinated timing ($\\text{RepeatCount} > 3$, $\\text{PeriodSec}$ consistent across observations) and $\\text{ECI} > 2.0$, suggesting a designed communication system.", "type": "domain_knowledge", "children_knowledge": [11, 6]}
  323. {"id": 43, "knowledge": "Quantum-Coherent Transmission", "description": "Describes signals potentially employing quantum properties for communication.", "definition": "Signals with $\\text{QuantEffects}$ containing 'Significant' or 'Observed' patterns, exhibiting unusually high information density ($\\text{InfoDense} > 1.5$) while maintaining an $\\text{ECI} > 2.5$, suggesting advanced transmission technologies beyond conventional radiofrequency methods.", "type": "domain_knowledge", "children_knowledge": [6]}
  324. {"id": 44, "knowledge": "Research Critical Signal", "description": "Defines signals requiring immediate and extensive scientific resources.", "definition": "Signals meeting Target of Opportunity (TOO) criteria with additional $\\text{PRC} > 0.8$ and $\\text{IMDF} < 0.5$, indicating high-quality, minimally distorted signals that show recognizable patterns warranting priority allocation of research resources.", "type": "domain_knowledge", "children_knowledge": [12, 38, 39]}
  325. {"id": 45, "knowledge": "Directed Transmission", "description": "Identifies signals that appear specifically directed rather than omnidirectional.", "definition": "Signals with high spatial stability ($\\text{SpatStab} = \\text{'Moderate'}$), narrow beam characteristics ($\\text{PolarMode} = \\text{'Linear'}$ with stable $\\text{PolarAngleDeg}$), and high $\\text{TOLS} > 0.85$, suggesting intentional transmission toward our location.", "type": "domain_knowledge", "children_knowledge": [3]}
  326. {"id": 46, "knowledge": "Signal of Galactic Significance", "description": "Classifies signals with potential importance to galactic civilization models.", "definition": "Signals originating from regions of high $\\text{CLSF} (> 2.0)$ that display Technosignature characteristics and have $\\text{AIDP} > 0.7$, representing potential evidence of advanced civilizations at galactic-relevant locations.", "type": "domain_knowledge", "children_knowledge": [10, 31, 35]}
  327. {"id": 47, "knowledge": "CCS Approximation", "description": "Simplified CCS calculation using direct signal-to-noise ratio values when full Signal-to-Noise Quality Indicator (SNQI) data is unavailable.", "definition": "$(1 - \\text{FalsePosProb}) \\times \\text{DecodeConf} \\times (\\text{SNR} - 0.1 \\times |\\text{NoiseFloorDbm}| > 0 ? \\frac{\\text{SNR} - 0.1 \\times |\\text{NoiseFloorDbm}|}{10} + 0.5 : 0.1)$", "type": "calculation_knowledge", "children_knowledge": [36]}
  328. {"id": 48, "knowledge": "Observation-Verified Signal", "description": "Defines signals that have undergone rigorous verification processes.", "definition": "Signals observed under Optimal Observing Window (OOW) conditions with $\\text{OQF} > 0.85$ and $\\text{CCS} > 0.8$, indicating high-quality observations with multiple verification methods applied.", "type": "domain_knowledge", "children_knowledge": [13, 32, 36]}
  329. {"id": 49, "knowledge": "Anomalous Quantum Signal", "description": "Describes signals exhibiting quantum properties inconsistent with current physics models.", "definition": "Signals with $\\text{QuantEffects}$ indicating anomalous behavior, $\\text{AnomScore} > 8$, and unusually high $\\text{MCS} (> 2.0)$, suggesting either unknown natural quantum phenomena or extremely advanced transmission technologies beyond current human capabilities.", "type": "domain_knowledge", "children_knowledge": [30]}
  330. {"id": 50, "knowledge": "Analyzable Signals", "description": "Signals of sufficient quality to be considered useful for further analysis.", "definition": "Signals with SNQI > 0 are considered analyzable.", "type": "domain_knowledge", "children_knowledge": [0]}
  331. {"id": 51, "knowledge": "Bandwidth-to-Frequency Ratio (BFR)", "description": "Normalized signal width relative to its central frequency.", "definition": "$\\text{BFR} = \\frac{\\text{BwHz}}{\\text{CenterFreqMhz} \\times 1{,}000{,}000}$, used to characterize signal spread relative to its frequency band.", "type": "calculation_knowledge", "children_knowledge": -1}
  332. {"id": 52, "knowledge": "TOLS Category", "description": "Classification of signals based on TOLS thresholds.", "definition": "Categorized as 'Low' if TOLS < 0.25, 'Medium' if TOLS < 0.75, and 'High' otherwise.", "type": "domain_knowledge", "children_knowledge": [3]}
  333. {"id": 53, "knowledge": "High Lunar Interference Events", "description": "Observations with significant lunar interference.", "definition": "Events where the calculated LIF is greater than 0.5, indicating strong lunar contamination in the data.", "type": "domain_knowledge", "children_knowledge": [9]}
  334. {"id": 54, "knowledge": "High Confidence Signals", "description": "Signal with Confirmation Confidence Score (CCS) > 0.8, indicating high reliability.", "definition": "Signals where $\\text{CCS} > 0.8$", "type": "domain_knowledge", "children_knowledge": [36]}
  335. {"id": 55, "knowledge": "Equipment Problems", "description": "Defines what counts as an abnormal condition for a telescope’s subsystems.", "definition": "A telescope is considered to have an equipment problem whenever **any** of its key subsystem states are not in their nominal condition: • Equipment status is not “Operational”; • Calibration status is not “Current”; • Cooling-system status is not “Normal”.", "type": "domain_knowledge", "children_knowledge": -1}
  336. </СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!