spaceqry
DESCRIPTION
SpaceQry. Space Query and Extract System. Steve Boswell Space Administrative Software Division. E. E. E. Acronyms & Terminology. FMS: F requency M anagement S ystem SNS: S pace N etwork S ystem SRS: S pace R adiocommunication S tations - PowerPoint PPT PresentationTRANSCRIPT
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
SpaceQrySpaceQry
Space Query and Extract SystemSpace Query and Extract System
Steve BoswellSteve BoswellSpace Administrative Software DivisionSpace Administrative Software Division
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
• FMSFMS : : FFrequency requency MManagement anagement SSystemystem• SNSSNS : : SSpace pace NNetwork etwork SSystemystem• SRSSRS : : SSpace pace RRadiocommunication adiocommunication SStations tations • SWICSWIC: : SSpace pace WWeekly eekly IInternational nternational CCircularircular• IFICIFIC : : IInternational nternational FFrequency requency IInfo nfo CCircularircular• NSLNSL : : NNetwork / etwork / SStation tation LListist• GIMSGIMS: : GGraphical raphical IInterference nterference MManagement anagement SysSystemtem• GIBCGIBC : : GGraphical raphical IInterface to nterface to BBatch atch CCalculationsalculations• IDWMIDWM : : IITU TU DDigitized igitized WWorld orld MMapap
Acronyms & TerminologyAcronyms & Terminology
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQrySpace Software SuiteSpace Software Suite
SPSSPS(MSPACEg)(MSPACEg)
SPSSPS(MSPACEg)(MSPACEg)
SPSSPSSPSSPS
NSLNSLNSLNSL
CaptureCaptureCaptureCapture
GIMSGIMSGIMSGIMS
ExportedExportedhtml &html &
ascii textascii text
ExportedExportedhtml &html &
ascii textascii text
SpaceQrySpaceQrySpaceQrySpaceQry
SRSSRSSRSSRS
IFICIFICIFICIFIC
exportexportGXTGXT
exportexportGXTGXT
SpacePubSpacePubSpacePubSpacePub
IFICIFICTSUMTSUM
IFICIFICTSUMTSUM
Local DBLocal DBLocal DBLocal DB
GIMS DBGIMS DBGIMS DBGIMS DB
Exported Exported tablestables
Exported Exported tablestables
SpaceComSpaceComSpaceComSpaceCom
Ap7CapAp7CapAp7CapAp7Cap
GIBCGIBC(App7 / Tex)(App7 / Tex)
GIBCGIBC(App7 / Tex)(App7 / Tex)
SpaceValSpaceValSpaceValSpaceVal
Draft CR/DDraft CR/DDraft CR/DDraft CR/D
SpaceCapSpaceCapSpaceCapSpaceCap
ESCCESCCESCCESCC
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
What is SpaceQry?What is SpaceQry?
The BR’s The BR’s Space Data and Publication Space Data and Publication Circular Query and Extract SystemCircular Query and Extract System, known , known as as SpaceQrySpaceQry, is a software package that , is a software package that supplies both the BR’s internal and external supplies both the BR’s internal and external users with a tool that accesses and queries users with a tool that accesses and queries all BR formatted Space Databases.all BR formatted Space Databases.
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
What does SpaceQry do?What does SpaceQry do?
Reads Electronic Space Circular PublicationsReads Electronic Space Circular Publications Queries the SRS/SPS/SNS databasesQueries the SRS/SPS/SNS databases Creates Subset Databases Creates Subset Databases ((Space Space NNetwork / Earth etwork / Earth SStation tation LLists) ists)
Updates SRS/NSLs from Space IFIC dataUpdates SRS/NSLs from Space IFIC data Maintains a “query database”Maintains a “query database”
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
What can SpaceQry Query?What can SpaceQry Query?
SRS/SPS/SNS/NSL DatabasesSRS/SPS/SNS/NSL Databases Electronic Space IFIC PublicationsElectronic Space IFIC Publications
• Show only data relative to Publication Show only data relative to Publication (IFIC filter on)(IFIC filter on)
• Show all data for networks Show all data for networks (IFIC filter off)(IFIC filter off) SpaceCap Output (Capture databases)SpaceCap Output (Capture databases) SNS-Online Download DatabasesSNS-Online Download Databases
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Types of QueriesTypes of Queries
Standard Perusal QueriesStandard Perusal Queries Frequency Overlap / Slot QueriesFrequency Overlap / Slot Queries Predefined “Quick” QueriesPredefined “Quick” Queries AdHoc SQL QueriesAdHoc SQL Queries
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Standard QueriesStandard Queries
Intended for perusing the dataIntended for perusing the data Standard query criteria:Standard query criteria:
• Notification Reason Notification Reason • Administration, Organization, CountryAdministration, Organization, Country• Satellite / Earth station typeSatellite / Earth station type• Satellite / Earth Station namesSatellite / Earth Station names• Orbital position / geographical locationOrbital position / geographical location• Publication number & partPublication number & part
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Frequency Overlap QueriesFrequency Overlap Queries
What networks overlap a given frequency band?What networks overlap a given frequency band? What networks operate within a freq. band (slot)?What networks operate within a freq. band (slot)? Overlap/Slot query criteria:Overlap/Slot query criteria:
• All criteria available to Standard queriesAll criteria available to Standard queries• Multiple frequency bandsMultiple frequency bands• Beam type (receiving / transmitting)Beam type (receiving / transmitting)• Group-level publication numbersGroup-level publication numbers• BR (examination) findings valuesBR (examination) findings values• Date of receipt / date of protectionDate of receipt / date of protection
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Frequency Overlap Queries Frequency Overlap Queries (cont.)(cont.)
Overlap query results displayed as…Overlap query results displayed as…• List of Networks with overlapping frequenciesList of Networks with overlapping frequencies• List of Networks with a sample overlapping frequencyList of Networks with a sample overlapping frequency• List of Groups with overlapping frequenciesList of Groups with overlapping frequencies• List of all overlapping frequencies List of all overlapping frequencies
Overlap query results printed as a reportOverlap query results printed as a report Overlap query results exported as…Overlap query results exported as…
• Fixed-length, delimited, or HTML text filesFixed-length, delimited, or HTML text files• Network / Station ListNetwork / Station List• MS-Access database tablesMS-Access database tables• MS-Excel spreadsheetMS-Excel spreadsheet
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
““Quick” QueriesQuick” Queries
““Quick” or “easy” = minimal info requiredQuick” or “easy” = minimal info required Display specific information about a networkDisplay specific information about a network Examples:Examples:
• List frequencies by emission/reception, beamList frequencies by emission/reception, beam• List BR findings for all frequency groupsList BR findings for all frequency groups• List Special Section publications for all groupsList Special Section publications for all groups• List unique frequency bands and the beams in List unique frequency bands and the beams in
which they appearwhich they appear
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Ad Hoc SQL QueriesAd Hoc SQL Queries
Allow you to design your own queries Allow you to design your own queries Allow you to modify Allow you to modify generatedgenerated queries queries Supply aids for query designSupply aids for query design
• ““select” statement templatesselect” statement templates• database table and field listsdatabase table and field lists
NB: Require a basic knowledge of the SQL “Select” NB: Require a basic knowledge of the SQL “Select” statement syntax & SRS database Structurestatement syntax & SRS database Structure
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Ad Hoc SQL Queries Ad Hoc SQL Queries (cont.)(cont.)
Supplement SpaceQry’s pre-defined queries Supplement SpaceQry’s pre-defined queries When to use Adhoc Queries:When to use Adhoc Queries:
• need to specify additional criteria need to specify additional criteria • additional sorting order required additional sorting order required • specific result requiredspecific result required
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Using the Queried Data...Using the Queried Data...
Produce query-extraction databases (NSLs)Produce query-extraction databases (NSLs) Update NSLs from Space Circular PublicationsUpdate NSLs from Space Circular Publications Update SRS from Space Circular PublicationsUpdate SRS from Space Circular Publications Produce paper report (per network)Produce paper report (per network) Export subsets of the data to ASCII & HTML filesExport subsets of the data to ASCII & HTML files Export results of queries to MS-Access tablesExport results of queries to MS-Access tables Export results of queries to MS-Excel spreadsheetsExport results of queries to MS-Excel spreadsheets Display related Graphical dataDisplay related Graphical data Display network structure diagramDisplay network structure diagram
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
SpaceQry: Other FeaturesSpaceQry: Other Features
Direct link to GIMS for graphicsDirect link to GIMS for graphics Direct link to Space Publication system Direct link to Space Publication system Access to BR space data on any (?) ODBC32 Access to BR space data on any (?) ODBC32
database platformdatabase platform
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
Current VersionCurrent Version Version 6.1 Version 6.1 for Windows 9x, 2000, ME, XP and Vistafor Windows 9x, 2000, ME, XP and Vista
• Reads MS-Access databasesReads MS-Access databases• Reads Ingres and SQLServer databasesReads Ingres and SQLServer databases• Interfaces with GIMS (gimapi32.dll) Interfaces with GIMS (gimapi32.dll) • Interfaces with SpacePubInterfaces with SpacePub• Interfaces with SRSConvertInterfaces with SRSConvert• Interfaces with SpaceCap Interfaces with SpaceCap (RES49 capture wizard)(RES49 capture wizard)
• Interfaces with SpaceVal Interfaces with SpaceVal (validation report)(validation report)
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
SPSSPS(MSPACEg)(MSPACEg)
SPSSPS(MSPACEg)(MSPACEg)
SpaceQrySpaceQry in the in the Software SuiteSoftware Suite
NSLNSLNSLNSL
CaptureCaptureCaptureCapture
GIMSGIMSGIMSGIMS
GIBCGIBCGIBCGIBC
SpaceQrySpaceQrySpaceQrySpaceQry
SRSSRSSRSSRS
IFICIFICIFICIFIC
SpaceValSpaceValSpaceValSpaceVal
exportexportGXTGXT
exportexportGXTGXT
>
SpacePubSpacePubSpacePubSpacePub
Local DBLocal DBLocal DBLocal DB
GIMS DBGIMS DBGIMS DBGIMS DB IFICIFICTSUMTSUM
IFICIFICTSUMTSUM
(updated) SpaceCapSpaceCapSpaceCapSpaceCap
lists &images
SPSSPSSPSSPS
Exported Exported tablestables
Exported Exported tablestables (RS49)
(Val. Report)
ExportedExportedhtml &html &
ascii textascii text
ExportedExportedhtml &html &
ascii textascii text
Ap7CapAp7CapAp7CapAp7Cap
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQrySpaceQry Home Page SpaceQry Home Page (1)(1)
Space International Frequency Information CircularsSpace International Frequency Information CircularsSpace International Frequency Information CircularsSpace International Frequency Information Circulars
Space Radiocommunication Stations on DVD-ROMSpace Radiocommunication Stations on DVD-ROMSpace Radiocommunication Stations on DVD-ROMSpace Radiocommunication Stations on DVD-ROMversion 6.1 enhancementsversion 6.1 enhancementsversion 6.1 enhancementsversion 6.1 enhancements
software downloadsoftware downloadsoftware downloadsoftware download
SpaceQry Query GuideSpaceQry Query GuideSpaceQry Query GuideSpaceQry Query Guide
SpaceQry updatesSpaceQry updates
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
SpaceQry Software DownloadSpaceQry Software Download
Installation image File
SpaceQrySetup.exeInstallation image File
SpaceQrySetup.exe
…currently no updates to SpaceQry version 6.1…currently no updates to SpaceQry version 6.1
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
SpaceQry Home Page SpaceQry Home Page (2)(2)
SpaceQry documentationSpaceQry documentation
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQrySpaceQry Documentation PageSpaceQry Documentation Page
What’s New in version 6.1? New61.pdfWhat’s New in version 6.1? New61.pdfSpaceQry Query Guide SQryGuide.pdfSpaceQry Query Guide SQryGuide.pdf
SpaceQry presentation (BR Seminar) SpaceQry2008.pptSpaceQry presentation (BR Seminar) SpaceQry2008.ppt
SRS database (v6) description srs-dbv6.docSRS database (v6) description srs-dbv6.docBR Preface to the IFIC & SRS-DVD preface_e.pdfBR Preface to the IFIC & SRS-DVD preface_e.pdf
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
SpaceQry Web PageSpaceQry Web Page
www.itu.int/ITU-R/software/space/spaceqry/www.itu.int/ITU-R/software/space/spaceqry/index.htmlindex.html
[email protected]@[email protected]@itu.int
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQry
SpaceQry Demonstration...SpaceQry Demonstration...
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQryAcronyms & Abbreviations: Acronyms & Abbreviations: for BR Space Software Presentations (1)for BR Space Software Presentations (1)
AP30AP30 - - ApAppendix pendix 3030 (of RR: Broadcasting Satellite Services Plan)(of RR: Broadcasting Satellite Services Plan) AP30AAP30A - - ApAppendix pendix 30A30A (of RR: Broadcasting Satellite Services Plan)(of RR: Broadcasting Satellite Services Plan) AP30BAP30B - - ApAppendix pendix 30B30B (of RR: Fixed Satellite Services Plan) (of RR: Fixed Satellite Services Plan) AP4AP4 - - ApAppendix pendix 44 (of RR: characteristics of data and their use for SRS)(of RR: characteristics of data and their use for SRS) ASCIIASCII - - AAmerican merican SStandard tandard CCode for ode for IInformation nformation IInterchangenterchangeBRBR - - BBureau des ureau des RRadiocommunications adiocommunications (Radiocommunication Bureau)(Radiocommunication Bureau)BSSBSS - - BBroadcasting roadcasting SSatellite atellite SServiceservicesCR...CR... - - RRadiocommunication adiocommunication CCircular ... ircular ... (circular letter number …)(circular letter number …)CSVCSV - - CComma-omma-SSeparated eparated VValues file alues file (spreadsheet import/export format)(spreadsheet import/export format)EIRPEIRP - - EEquivalent quivalent IIsotropic sotropic RRadiated adiated PPowerowerFMSFMS - - FFrequency requency MManagement anagement SSystemystemFSSFSS - - FFixed ixed SSatellite atellite SServiceservicesGIBCGIBC - - GGraphical raphical IInterface to nterface to BBatch atch CCalculationsalculationsGIMSGIMS - - GGraphical raphical IInterference nterference MManagement anagement SSystemystemGXTGXT - - GGraphical Eraphical Exxchange change TText format (GIMS)ext format (GIMS)IDWMIDWM - - IITU TU DDigitized igitized WWorld orld MMapap
ITU-R World Radiocommunication Seminar ITU-R World Radiocommunication Seminar Geneva, 8–12 December 2008 Geneva, 8–12 December 2008
SpaceQrySpaceQryAcronyms & Abbreviations: Acronyms & Abbreviations: for BR Space Software Presentations (2)for BR Space Software Presentations (2)
IFICIFIC - - IInternational nternational FFrequency requency IInformation nformation CCircularircularIFLIFL - - IInternational nternational FFrequency requency LLististMIFRMIFR - - MMaster aster IInternational nternational FFrequency requency RRegisteregisterNSLNSL - - NNetwork/etwork/SStation tation LLististODBCODBC - - OOpen pen DDataatabbase ase CConnectivityonnectivityPFDPFD - - PPower ower FFlux lux DDensityensityPDFPDF - - PPortable ortable DDocument ocument FFormat ormat (Acrobat file format)(Acrobat file format)PXTPXT - - PPlanning Elanning Exxercise ercise TTeam eam (special PFD calculations for BSS)(special PFD calculations for BSS)RDDRDD - - RRadiocommunication adiocommunication DData ata DDictionary ictionary (Study Group I)(Study Group I)RRRR...... - - RRadio adio RRegulation ...egulation ...SNLSNL - - SSpace pace NNetwork etwork LLististSNSSNS - - SSpace pace NNetwork etwork SSystemystemSQLSQL - - SStructured tructured QQuery uery LLanguageanguage (for querying databases) (for querying databases)SRSSRS - - SSpace pace RRadiocommunications adiocommunications SStations databasetations databaseTSUMTSUM - - TTransaction ransaction SumSummary Reportmary ReportWICWIC - - WWeekly eekly IInternational nternational CCircularircular