710 likes | 819 Views
Centre of Excellence Workshop Kiev - 2003 Principles and techniques for spectrum planning and utilization. DATABASE AND SOFTWARE FOR AUTOMATION OF THE RADIO REGULATIONS. B ontcho Balabanov NBU-Sofia. Introduction Problems for using the Radio Regulations
E N D
Centre of Excellence Workshop Kiev - 2003 Principles and techniques for spectrum planning and utilization DATABASE AND SOFTWARE FOR AUTOMATION OF THE RADIO REGULATIONS Bontcho Balabanov NBU-Sofia CoE SM Workshop Kiev- 2003
Introduction Problems for using the Radio Regulations How to Automat of the Radio Regulations Database with RR provisions Automation of the Radio Regulations Software modules Harmonization of the frequency tables. Examples Conclutions Автоматизиране на Радио регламента (RR) Automation of the Radio Regulations (RR) CoE SM Workshop Kiev- 2003
ITU- Radio Regulations - RR Automation of the Radio Regulations Specification- SG-4, NTIA, FSS, ITU-BR Database Software modules Conections betwean databases Efficient selection of the information 1.Introduction 1. Introduction CoE SM Workshop Kiev- 2003
2.a)Radio Regulations ITU Radio Regulations • TABLE OF FREQUENCY ALLOCATION • REGULATORY PROCEDURES - advance publication / coordination / notification & plans ITU ITU ITU ITU RR RR RR RR • ARTICLES • APPENDICES • RESOLUTIONS • Recommendations RR 4 volums- over 1500 pages + Recommendations by reference CoE SM Workshop Kiev- 2003
2.b) Radio Regulations 2.a)ITU-BRRadio Regulations (RR) • a) The Radio Regulations and the Recommendations of the BR, are based primarily on defining radio services, allocating frequency bands to these services and specifying administrative and technical procedures for the operation of stations in the services. • For example the maritime mobile and the aeronautical mobile services are involve in standardized practices that are intended to ensure their international operability and connectivity • the Radio Regulations serve as the primary international agreement covering rules and procedures for operating radio equipment and for resolving interference. The Table of Frequency Allocations, contained in Article 8, serves as a basis for national allocation of frequencies. CoE SM Workshop Kiev- 2003
2.b) Radio Regulations 2.b)Radio Regulations • Who decides on their content? • Administrations, Regional Organizations • How? • At Radiocommunication Conferences • When? • Every two or three years CoE SM Workshop Kiev- 2003
Allocation to services Region 3 Region 1 Region 2 • 1 613.8-1 626.5MHz • MOBILE-SATELLITE(Earth-to-space) 5.351A • AERONAUTICAL RADIONAVIGATION • Mobile-satellite (space-to-Earth) • Radiodetermination-satellite(Earth-to-space) • 1 613.8-1 626.5MHz • MOBILE-SATELLITE(Earth-to-space) 5.351A • AERONAUTICALRADIONAVIGATION • Mobile-satellite • (space-to-Earth • 1 613.8-1 626.5MHz • MOBILE-SATELLITE(Earth-to-space) 5.351A • AERONAUTICALRADIONAVIGATION • RADIODETERMINATION-SATELLITE(Earth-to-space) • Mobile-satellite • (space-to-Earth) 5.341 5.355 5.359 5.364 5.365 5.366 5.367 5.368 5.369 5.372 5.341 5.355 5.359 363 5.364 5.365 5.366 5.367 5.368 5.369 5.371 5.372 5.341 5.364 5.365 5.366 5.367 5.368 5.370 5.372 RR Example CoE SM Workshop Kiev- 2003
Example Footnotes 1 FTN 1 5.364 The use of the band 1 610-1 626.5 MHz by the mobile-satellite service (Earth-to-space) and by the radiodetermination-satellite service (Earth‑to‑space) is subject to coordination under No. 9.11A. A mobile earth station operating in either of the services in this band shall not produce a peak e.i.r.p. density in excess of in the part of the band used by systems operating in accordance with the provisions of No. 5.366 (to which No. 4.10 applies), unless otherwise agreed by the affected administrations. In the part of the band where such systems are not operating, the mean e.i.r.p. density of a mobile earth station shall not exceed –3 dB(W/4 kHz). Stations of the mobile-satellite service shall not claim protection from stations in the aeronautical radionavigation service, stations operating in accordance with the provisions of No. 5.366 and stations in the fixed service operating in accordance with the provisions of No. 5.359. Administrations responsible for the coordination of mobile-satellite networks shall make all practicable efforts to ensure protection of stations operating in accordance with the provisions of No. 5.366. CoE SM Workshop Kiev- 2003
Example Footnotes 2 FTN 2 5.367Additional allocation: The bands 1 610-1 626.5 MHz and 5 000-5 150 MHz are also allocated to the aeronautical mobile-satellite (R) service on a primary basis, subject to agreement obtained under No. 9.21. 5.369 Different category of service:in Angola, Australia, Burundi, China, Côte d’Ivoire, Eritrea, Ethiopia, India, Iran (Islamic Republic of), Israel, Jordan, Lebanon, Liberia, Libya, Madagascar, Mali, Pakistan, Papua New Guinea, Dem. Rep.of the Congo, Syria, Senegal, Sudan, Swaziland, Togo and Zambia, the allocation of the band 1 610-1 626.5 MHz to the radiodetermination-satellite service (Earth-to-space) is on a primary basis (see No. 5.33), subject to agreement obtained under No. 9.21 from countries not listed in this provision. (WRC-97) CoE SM Workshop Kiev- 2003
RR Art. 9.35 • Examinations with respect to: • i) Any power limits referred to in applicable footnotes, Resolutions or Recommendations; • ii) The power limits for earth stations as specified in Nos 21.8, 21.10, 21.12 and 21.13; • iii) The limits of power flux-density from space stations produced at the Earth's surface as specified in Table 21-4 (21.16), as well as in Tables 22-1A to 22-1D (22.5C); • iv) The limits of power flux-density from space stations produced at the geostationary orbit as specified in Nos 22.5 and 22.5A; • v) The limits of power flux‑density from earth stations produced at the GSO as specified in Table 22.2 (22.5D); • vi) The limits of power flux‑density from space stations produced at any point in the geostationary orbit as specified in Table 22.3 (22.5F); and • vii) The off-axis power limits of earth stations in the fixed‑satellite service specified in Nos 22.26 to 22.39. CoE SM Workshop Kiev- 2003
3.а)RR Problems 1e 2e 3e Itu Itu Itu Problems for using the Radio Regulations 4 volums- over 1500 pages a lot of manual operations are implemented for network coordinations in BR CoE SM Workshop Kiev- 2003
Examinations of the frequency assignments. Frequency allocation tables. Radio services Footnotes Appendixes Recommendations Resolutions Contradictions in the footnotes Interest of different administrations Additional allocation and different category of service 3.b)Problems for using the Radio Regulations CoE SM Workshop Kiev- 2003
3. AutomationAttempt Specification - Expert group NTIA, FSS, ITU-BR, SG-4 RR database- MSACCESS Connections between Tables Connections to other databases Software modules • Attempt for automation of the RR CoE SM Workshop Kiev- 2003
Expert group • Software and DB Specification: • The development and the implementation (by BR and by administrations) of the software according to the New Recomendation ITU-R SF-[Doc. 4/117] “Outline of a software specification for automating the examination of satellite network filings for compliance with Article 5” (SG-4), including PFD calculation to help the automation of the satellite examination procedure. CoE SM Workshop Kiev- 2003
4. RR Database • RR Database • Database with RR provisions • Main Tables: • - Frequency allocation table RRArt. 5 • Table with Radio services • Table with Footnote Text • Table with Pa, PFD, EIRP, Da Limits • Table with Footnote Categories • Information tables • Table with extra conditions • Queries for Data selection • Macros and modules to generate these tables from RR texts. CoE SM Workshop Kiev- 2003
RR texts to Tables • TransferRR Word text to Table. • Processing RR Word Table – separate fields (kHz, MHz, GHz). • Transfer RR Word Table to MS Excel. • Processing MS Excel Table – add missed fields and correct data. • Transfer MS Excel Table to MS Access. • Processing MS Access Table in MS Access-all frequencies as Hz. • Select proper Cyrillic font for MS Access (if applicable). • Separate fields with footnotes and services. • Generate table “Frequency_Allocation”. • Start MS C++ Software. • First Processing MS Access Table with MS C++ function. • Generate separate record for every footnote and service. • Second Processing MS Access Table in MS Access. • Second Processing MS Access Table with MS C++ function. • Third Processing MS Access Table in MS Access. • Test and correction MS Access Table. CoE SM Workshop Kiev- 2003
Tables CoE SM Workshop Kiev- 2003
Frequency • Frequency allocation table • Frequency limits [Hz] • Radio service ID numbers (codes) • Type of the Emissions (E/R) • Regions codes • Footnote numbers • Appendix numbers • Recommendation numbers • Resolution numbers CoE SM Workshop Kiev- 2003
Fr Table Frequency allocation table (Art. 5) CoE SM Workshop Kiev- 2003
Radio services Table with Radio services CoE SM Workshop Kiev- 2003
Footnotes Table with Footnote Texts CoE SM Workshop Kiev- 2003
FTH categories Footnote Categories Auto check Allocation Coordination PFD limit PFD threshold Date Elevation angle Gain Power Antenna diameter Publication date Emission Permissive use Use restriction Additional allocation Alternative allocation Different category of service Protection restriction Authorisation Undefined Other type CoE SM Workshop Kiev- 2003
Category Table Table with Footnote Categories CoE SM Workshop Kiev- 2003
Фиг.3.3.1. Query CoE SM Workshop Kiev- 2003
Algorithm Footnote Examination CoE SM Workshop Kiev- 2003
Algorithm FTN CoE SM Workshop Kiev- 2003
Software The example software main features: • Satellite data extraction from SRS database; • Unique database generation for extracted satellite data with the name of the network; • Data validation for correct satellite data (Pd, Bw); • Selection of the examination options; • Art. 5 examination; • Shows results of the Art.5 examination; • Shows results of the footnote examination; • Generates output reports in table and text format; • PFD calculations; • Satellite data and examination results are saved for future use. CoE SM Workshop Kiev- 2003
Update Art.5 -1 CoE SM Workshop Kiev- 2003
Select Service CoE SM Workshop Kiev- 2003
Select FTN category CoE SM Workshop Kiev- 2003
Test Art.5 CoE SM Workshop Kiev- 2003
Select Satellite Select Stellite CoE SM Workshop Kiev- 2003
Exam Art5 Фиг.1. Examination Art5 CoE SM Workshop Kiev- 2003
Result Ftn Footnote Result CoE SM Workshop Kiev- 2003
Results (short) CoE SM Workshop Kiev- 2003
Results Group Level CoE SM Workshop Kiev- 2003
Results with Services and FTN categories CoE SM Workshop Kiev- 2003
Results test date and FTN CoE SM Workshop Kiev- 2003
Results test areas and regions CoE SM Workshop Kiev- 2003
a)Harmonization of the frequency tables As a result from the work done by the ITU WP4A “Software Rapporteur Group tools for Harmonization of the national and international Frequency Tables are proposed. Software tools and databases are developed an extension to this problem, to help the harmonization of the national and international frequency allocation tables. - Database with national frequency allocation table (MSACCESS). - Database with international frequency allocation table (MSACCESS). - Database with results of comparing the national and the international frequency allocation tables (MSACCESS). National and International frequency tables? CoE SM Workshop Kiev- 2003
b)Harmonization of the frequency tables -Software tools for examination of the national and the international frequency allocation tables including: - Module with dialogs for updating of the national and international frequency tables. - Module with dialog for comparing two plans and for generating new result table for frequency overlapping and with extra fields for conditions of the frequency harmonization. - Module with dialog for examination and updating of the result table. - Module for generating output report on table and text format. All software modules and databases are connected to main navigating module for uninterrupted examinations CoE SM Workshop Kiev- 2003
Фиг.4.5.1. Select Database CoE SM Workshop Kiev- 2003
Фиг.3.1. Tables in frequency database CoE SM Workshop Kiev- 2003
Фиг.4.5.2. Select necessary table CoE SM Workshop Kiev- 2003
Фиг.3.3.1. Query for Harmonization CoE SM Workshop Kiev- 2003
Fields in the result table ServID1 Service1 Ca1 Reg1 Users1 ReqMil1 CondUse1 SpecSysID1 DateFrom1 DateTo1 FootNote1 FrAl1 FrAl2 E_R2 ServID2 Service2 Cat2 Reg2 Users2 SpecSysID2 FootNote2 DateFrom2 DateTo2 IncompExt ActionDo DateFromHA DateToHA; Finance Notes CoE SM Workshop Kiev- 2003
Фиг.3.4.1. Query for Result Table CoE SM Workshop Kiev- 2003
Harmonization Examination The software examines the overlapping of the national and the international frequency allocation bands. The frequencies and the radio services are compared, Freq. Overlapping • Fn1- the lower limit of the national frequency allocation; • Fn2- the higher limit of the national frequency allocation; • Fi1- the lower limit of the international frequency allocation; • Fi2- the higher limit of the international frequency allocation. CoE SM Workshop Kiev- 2003
a)Example of the result table CoE SM Workshop Kiev- 2003
b)Example of the result table CoE SM Workshop Kiev- 2003