SpaceQry

1
SpaceQry

• Space Query and Extract System

2
Acronyms Terminology

• FMS Frequency Management System
• SNS Space Network System
• SRS Space Radiocommunication Stations
• 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
Capture
SpaceQry
NSL
exported ascii text
IFIC
error report
SRS
SpaceCap
GIBC
GIMS
GIMS DB
SpacePub
IFIC TSUM
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 WIC/IFIC Publications
• SpaceCap Output (MS-Access 97)
• 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/Slot 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
• Date of receipt / date of protection

10
Frequency Overlap Queries (cont.)

• Overlap query results displayed as
• List of Networks with overlapping frequencies
• 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

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

13
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

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 2.3 for Windows 95, 98, and NT4.0
• Reads MS-Access databases
• MS-Access 2.0 (16-bit)
• MS-Access 95, MS-Access 97, MS-Access 2000
  (32-bit)
• Reads Ingres and SQLServer databases
• Interfaces with GIMS (gimapi32.dll)
• Interfaces with SpacePub
• Interfaces with SRSConvert

17
SpaceQry Web Site
Space International Frequency Information
Circulars
Space Radiocommunication Stations on CD-ROM
version 2.3 enhancements
software download
SpaceQry Query Guide
18
SpaceQry Software Download
Installation image SpaceQry2-3.exe
19
SpaceQry Web Site
SpaceQry documentation and updates
20
Documentation / Software Updates
Whats New in version 2.3?
New23.wri
Guide to Specifying Queries
SQryGuide.pdf
21
SpaceQry Web Page
www.itu.int/brsoft/space/spaceqry/index.html
22
SpaceQry Demonstration...
23
ACRONYMS 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 no ) 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 IDWM -
International Digitized World Map IFIC -
International Frequency Information Circular
24
IFL - International Frequency List MIFR - Master
International Frequency Register NSL -
Network/Station List ODBC - Organization for
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 -
Standard Query Language (for querying
databases) SRS - Space Radiocommunications
Stations database TSUM - Transaction Summary
Report WIC - Weekly International Circular