SpaceQry

1
SpaceQry

• Space Query and Extract System
• Regional Radiocommunication Seminar
• (Bali, Indonesia 16-20 May 2005)

Veronica Román, BR/IAP/STS
2
Acronyms Terminology

• SNS Space Network System
• SRS Space Radiocommunication Stations
• FMS Frequency Management System
• WIC Weekly International Circular
• IFIC International Frequency Info Circular
• NSL Network / Station List
• GIMS Graphical Interference Management System
• GIBC Graphical Interface to Batch Calculations
• IDWM International Digitized World Map

3
Space PC-Software Suite
SpaceVal
SpaceQry
Capture
exported ascii text
NSL
IFIC
error report
SRS
GIBC
SpaceCap
GIMS
MSPACEg
SPS
SpacePub
IFIC TSUM
GIMS DB
export GXT
Local DB
4
What is SpaceQry?

• The BRs Space Data and Publication Circular
  Query and Extract System, known as SpaceQry, is a
  software package that supplies both the BRs
  internal and external users with a tool that
  accesses and queries all BR formatted Space
  Databases.

5
What does SpaceQry do?

• Reads Electronic Space Circular Publications
• Queries the SRS (MS-Access) database
• Creates Space Network / Earth Station Lists
  (NSLs)
• Updates SRS/NSLs from Space Circular data
• Maintains a query database

6
What can SpaceQry Query?

• SRS Database
• Electronic Space IFIC Publications
• Show only data relative to Publication (IFIC
  filter on)
• Show all data for networks (IFIC filter off)
• SpaceCap Output (MS-Access 97, 2000)
• SNS PC-Capture Output (MS-Access 2.0)
• Network / Station Lists (NSLs)

7
Types of Queries

• Standard Perusal Queries
• Frequency Overlap / Slot Queries
• Predefined Quick Queries
• AdHoc SQL Queries

8
Standard Queries

• Intended for perusing the data
• Standard query criteria
• Notification Reason
• Administration, Organization, Country
• Satellite / Earth station type
• Satellite / Earth Station names
• Orbital position / geographical location
• Publication number part

9
Frequency Overlap Queries

• What networks overlap a given frequency band?
• What networks operate within a freq. band (slot)?
• Overlap/Slot query criteria
• All criteria available to Standard queries
• Multiple frequency bands
• Beam type (receiving / transmitting)
• Group-level publication numbers
• BR (examination) findings values
• Date of receipt / date of protection

10
Frequency Overlap Queries (cont.)

• Overlap query results displayed as
• List of Networks with overlapping frequencies
• List of Networks with a sample overlapping
  frequency
• List of Groups with overlapping frequencies
• List of all overlapping frequencies
• Overlap query results printed as a report
• Overlap query results exported as
• Fixed-length or delimited text files
• Network / Station List

11
Quick Queries

• Quick or easy minimal info required
• Display specific information about a network
• Examples
• List frequencies by emission/reception, beam
• List BR findings for all groups
• List Special Section publications for all groups
• List unique frequency bands and the beams in
  which they appear

12
Ad Hoc SQL Queries (cont.)

• Supplement SpaceQrys pre-defined queries
• When to use Adhoc Queries
• need to specify additional criteria
• additional sorting order required
• specific result required

13
Ad Hoc SQL Queries

• Allow you to design your own queries
• Allow you to modify generated queries
• Supply aids for query design
• select statement templates
• database table and field lists
• NB Require a basic knowledge of the SQL
  Select statement syntax

14
Using the Queried Data...

• Produce query-extraction databases (NSLs)
• Update NSLs from Space Circular Publications
• Update SRS from Space Circular Publications
• Produce paper report (per network)
• Export subsets of the data to ASCII files
• Display related Graphical data
• Display network structure diagram

15
SpaceQry Other Features

• Direct link to GIMS for graphics
• Direct link to Space Publication system
• Access to BR space data on any (?) ODBC32
  database platform

16
Current Version

• Version 5.2 for Windows 9x, 2000, ME, XP and
  NT4.0
• Reads MS-Access databases
• Reads Ingres and SQLServer databases
• Interfaces with GIMS (gimapi32.dll)
• Interfaces with SpacePub
• Interfaces with SRSConvert
• Interfaces with SpaceCap (RES49 filing capture)
• Interfaces with SpaceVal (validation report)

17
SpaceQry in the PC-Software Suite
SpaceVal
Capture
SpaceQry
NSL
exported ascii text
IFIC
error report
SRS
GIBC
SpaceCap
GIMS
MSPACEg
SPS
GIMS DB
SpacePub
IFIC TSUM
export GXT
Local DB
gt
18
SpaceQry Home Page (1)
Space International Frequency Information
Circulars
Space Radiocommunication Stations on CD-ROM
version 5.2 enhancements
software download
SpaceQry updates
SpaceQry Query Guide
19
SpaceQry Software Download
Installation image File SpaceQryFull52.exe
currently no updates to the SpaceQry 5.2 release
of the SpaceQry Software
20
SpaceQry Home Page (2)
SpaceQry documentation
21
SpaceQry Documentation Page
Whats New in version 5.2?
New52.wri
SpaceQry Query Guide SQryGuide.pdf
SpaceQry presentation (BR Seminar)
SpaceQry2004.ppt
SRS database description
srs-dbv5.doc
BR Preface to the IFIC SRS-CD
preface.pdf
22
SpaceQry Web Page
www.itu.int/itu-r/software/space/spaceqry/index.ht
ml
23
SpaceQry Demonstration...
24
Acronyms Abbreviations for BR Space Software
Presentations (1)

• AP30 - Appendix S30 (of RR Broadcasting
  Satellite Services Plan)
• AP30A - Appendix S30A (of RR Broadcasting
  Satellite Services Plan)
• AP30B - Appendix S30B (of RR Fixed Satellite
  Services Plan)
• APS4 - Appendix S4 (of RR characteristics of
  data and their use for SRS)
• ASCII - American Standard Code for Information
  Interchange
• BR - Bureau des Radiocommunications
  (Radiocommunication Bureau)
• BSS - Broadcasting Satellite Services
• CR... - Radiocommunication Circular ...
  (circular letter number )
• CSV - Comma-Separated Values file (spreadsheet
  import/export format)
• EIRP - Equivalent Isotropic Radiated Power
• FMS - Frequency Management System
• FSS - Fixed Satellite Services
• GIBC - Graphical Interface to Batch Calculations
• GIMS - Graphical Interference Management System
• GXT - Graphical Exchange Text format (GIMS)
• IDWM - International Digitized World Map

25
Acronyms Abbreviations for BR Space Software
Presentations (2)

• IFIC - International Frequency Information
  Circular
• IFL - International Frequency List
• MIFR - Master International Frequency Register
• NSL - Network/Station List
• ODBC - Open Database Connectivity
• PFD - Power Flux Density
• PDF - Portable Document Format (Acrobat file
  format)
• PXT - Planning Exercise Team (special PFD
  calculations for BSS)
• RDD - Radiocommunication Data Dictionary (Study
  Group I)
• RR... - Radio Regulation ...
• SNL - Space Network List
• SNS - Space Network System
• SQL - Structured Query Language (for querying
  databases)
• SRS - Space Radiocommunications Stations database
• TSUM - Transaction Summary Report
• WIC - Weekly International Circular