Title: SpaceQry
1SpaceQry
- Space Query and Extract System
Steve Boswell
2Acronyms 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
3Space PC-Software Suite
SpaceVal
SpaceQry
Capture
exported ascii text
NSL
IFIC
error report
SRS
GIBC
SpaceCap
GIMS
MSPACEg
SpacePub
IFIC TSUM
GIMS DB
export GXT
Local DB
4What 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.
5What 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
6What 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)
7Types of Queries
- Standard Perusal Queries
- Frequency Overlap / Slot Queries
- Predefined Quick Queries
- AdHoc SQL Queries
8Standard 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
9Frequency 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
10Frequency 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
11Quick 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
12Ad 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
13Ad 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
14Using 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
15SpaceQry Other Features
- Direct link to GIMS for graphics
- Direct link to Space Publication system
- Access to BR space data on any (?) ODBC32
database platform
16Current Version
- Version 3.0 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
17SpaceQry in the PC-Software Suite
SpaceVal
Capture
SpaceQry
NSL
exported ascii text
IFIC
error report
SRS
GIBC
SpaceCap
GIMS
MSPACEg
GIMS DB
SpacePub
IFIC TSUM
export GXT
Local DB
gt
18SpaceQry Web Site
Space International Frequency Information
Circulars
Space Radiocommunication Stations on CD-ROM
version 3.0 enhancements
software download
SpaceQry updates
SpaceQry Query Guide
19SpaceQry Software Download
Installation image File SpaceQry3-0.exe
currently no updates to the SpaceQry 3.0 software
20SpaceQry Web Site
SpaceQry documentation
21Documentation / Software Updates
Whats New in version 3.0?
New30.wri
SpaceQry Query Guide SQryGuide.pdf
SpaceQry presentation (BR Seminar)
SpaceQry2002.ppt
SRS database description
srs-dbv4.doc
BR Preface to the IFIC SRS-CD
preface.pdf
22SpaceQry Web Page
www.itu.int/itu-r/software/space/spaceqry/index.ht
ml
23SpaceQry Demonstration...
24Acronyms 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
25Acronyms 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