SpaceQry

1
SpaceQry
Capture
IFIC

• Space Query and Extract System

SRS
SpaceQry
SPS
SpacePub
Gims
2
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.

3
What does SpaceQry do?

• Reads Electronic Space Circular Publications
• Queries the SRS (MS-Access) database
• Updates local SRS from Space Circular data
• Maintains a query database

4
Types of Queries

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

5
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

6
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

7
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

8
Quick Queries

• Quick or easy minimal info required
• Display specific information about a network
• Examples
• Validation Report for a Network
• 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

9
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

10
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

11
Using the Queried Data...

• Extract the data to another SRS formatted mdb
• Produce paper report (per network)
• Export subsets of the data to ASCII files
• Display related Graphical data
• Display network structure diagram
• Update SRS from Space Circular Publications

12
Update SRS from Space Circular Publications
1. Open a Space Publication Circular
2. Export Current Query
3. Choose only Status 50
4. Select local SRS mdb
Local SRS
13
SpaceQry Other Features

• Validation Error Report
• SpaceVal View Results or
• Shortcut in SpaceQry Utilities Menu or
• Quick Query
• Direct link to GIMS for graphics
• Direct link to Space Publication system
• Access to BR space data on any (?) ODBC32
  database platform

14
Validation Error Report
1. Shortcut to Validation Report
15
Validation Error Report
16
Current Version

• Version 3.2 for Windows 9x, 2000, ME, XP 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 Home Page (1)
Space International Frequency Information
Circulars
Space Radiocommunication Stations on CD-ROM
version 3.2 enhancements
software download
SpaceQry updates
SpaceQry Query Guide
18
SpaceQry Web Page
www.itu.int/itu-r/software/space/spaceqry/index.ht
ml