ACMA Offline RRL
To update your offline database, please use one of the options below. By downloading the Register of Radiocommunications licence data you agree to Licence Usage Conditions. The daily spectra_rrl.zip can be downloaded from this ACMA Web Page.
Place downloaded Spectra Dataset (spectra_rrl.zip) file here
OrDownload and Import the latest Spectra Dataset (spectra_rrl.zip) now
And Optionally, to bring your offline database up to the present time.
- Open Map (may be useful to download Map baselayer Tiles for later Offline use).
Technical Records SearchDevice Details
Show Linked Sites in Map View - Map View applies to Sited Records only.
Enter SQL statement
Saved QueriesQuery Description [ Sample Queries ]
Once you have imported the daily Spectra Dataset RRL (spectra_rrl.zip) data into this ACMA Offline RRL application (this web page), you will be able to perform core searches in the tabs above, and no connection to the internet will be required. That is, you can search the ACMA RRL offline. You can close and reopen your browser - and open this page without an internet connection. Please consider bookmarking this page so you can reload it when you are offline.
The Offline RRL allows you to perform a variety of searches against the RRL data, navigate, chart and map that data. You can also further extract this data in CSV or KML format. You can customise output and also perform core text based, technical and SQL searches. And at times you have an internet connection, you may be able incrementally update your offline database to bring it up to near live ACMA data. The Offline RRL allows you to perform powerful searches against the full RRL dataset, so you may wish to consider using this application even if you do not intend to work offline.
Browser/Device RequirementsYour browser must support HTML5, File API and WebSQL API to use this page. Current browsers that support this are latest versions of Chrome, Opera, Vivaldi and Safari but not IE, Edge or Firefox. In addition, your device will need to support the creation of a 2Gb WebSQL database (actual size required is approx 1.4Gb) - however this may be further subject to quota restrictions on your device (see the Troubleshooting section below). If your device supports WebSQL but cannot create a 2Gb database, you will be offered the "Sampler Mode" fallback (see below) which will only attempt to import a small subset of the RRL tables.
Getting Started/Loading your Offline Database
To update your offline database, you will need to download a copy of the daily Radiocommunications Licence data (spectra_rrl.zip) from the ACMA website. By downloading the Register of Radiocommunications licence data you agree to Licence Usage Conditions. The daily spectra_rrl.zip can be downloaded from this ACMA Web Page. The RRL extracts are available on the ACMA Website by 6am daily (typically generated around 3am).
There are two options to load your offline database. Under the "Load Data (start here)" tab above, you can either;
- Download the spectra_rrl.zip and manually it into your offline database, or
- the spectra_rrl.zip into your offline database when you have an internet connection
Restrictions on Incremental Updates
Applying Incremental Updates to your offline database is subject to the following restrictions;
- Incremental Updates can not be applied against an offline database that hasn't been either "Downloaded and Imported", or had previous "Incremental Update" applied within the last 24hrs. That is, Incremental Updates cannot "look back" further than 24hrs in the past. Please note that the timestamp (shown at the top of this page) is reflective of either the last Download and Import or last Incremental Update. "Download and Import" timestamp is obtained from the ACMA servers - and is the time the extract file is generated on the server - typically 3am. Whereas when applying an Incremental Update, the timestamp shown will be approximately the time of your request. As such, you may need to perform more than 1 Incremental Update each day (say morning then afternoon) if you are planning an running Incremental Updates on subsequent days without the need to do full Download and Import.
- Requests for Incremental Updates will fail during a reserved blackout period of; Sunday 3am to Monday 3am. This period is reserved for maintenance activities.
- If a request for an Incremental Update takes longer than 4 minutes to complete - it may automatically be terminated during periods of high activity (during normal weekday working hours). Requests for Incremental Updates may actually take up to 10 minutes to complete. If your request fails after 4 minutes, please try again at a time of less activity - eg, outside normal daily working hours.
Searching your Offline Database
Once loaded, you can search your offline database (without an internet connection), by using the tabs above;
- Table Search - This allows you to use text searching across the core RRL tables. You can use text strings to search for any matches across any fields. Or, you can use text strings for individual columns using the "Advanced" option. Result outputs may contain hyperlinks to allow drilling down or looking up further RRL details.
- Technical Records Search - This allows you to perform a structured search across the core RRL tables that make up technical licence records. You can filter results based on certain, Device Details, Site, Licence and Client fields. Result outputs contain hyperlinks to enable further drill down or lookup of specific details. Result sets may also be viewed as a Map View.
- SQL - This tab allows you to run an arbitrary SQL statement against your offline database.
You can use WebSQL syntax in your queries. All of the
core RRL table in the (spectra_rrl.zip) will be imported (unless you are using "Sampler Mode"). Also, for
every RRL table imported, an additional WebSQL table suffixed "_RAW" is created used to facilitate text searching.
To get you started with SQL, there are a set of sample queries available. You will also be able to save and rerun your queries at a later time. Depending upon the characteristics of your result set, you may be able to view your results as a Chart View or a Map View.
Full Text Search - Now Deprecated
This application previously made use of WebSQL (Sqlite) full text searching using FTS3 virtual tables. However, this FTS3 virtual table functionality has now been removed from most browsers still supporting WebSQL. Now, instead, searching text terms is done by simple wildcarding. In that the tokens used in a search term must be present in the underlying data either wholly or as a substring.
Customise Display FieldsResult set output columns can be customised in both the "Table Search" and "Technical Records Search". Click on the button to modify display columns. You will be presented with 2 scrollable lists of fields; "Fields Not Displayed" and "Displayed Fields". Columns only appearing in the "Displayed Fields" list will be shown in the result set. Drag and Drop fields as required between, and within, these two lists to achieve the desired output fields and ordering.
Please note that after field customisation, whereby key linking fields are omitted from result sets, some drilldown/linking hyperlinks contained in these result sets may no longer work correctly.
Results Chart ViewSimple Line and Bar charts can be displayed if your returned result set has the following characteristics;
- The result set has a minimum of 2 columns returned. The first column results will be used for the chart x-axis. Data in subsequent columns (that is from column 2 onwards) will be used as the y-axis datasets
- Data in all subsequent columns, that is column 2 onwards, must consist of only numeric values
- The result set has a maximum of 100 rows
Results Map ViewResult sets can be visualised as a map if the result set has the following characteristics;
- If a numeric field named latitude and a numeric field named longitude are present in the result set, then these are assumed to represent a geographic point (such as site coordinates). These will be rendered in the map as a point marker.
- If a field named geometry is present in the result set, then this field is assumed to be a WKT (Well Known Text) representation of a geographic geometry and will be rendered in the Map View. This may be useful for visualising geometries that are more complex than simple latitude/longitude points - for example, such as visualising Point to Point links.
By default, the "Map View" either requires an internet connection to render the map background baselayer, however, maps can be configured to function offline. There are 2 options for using offline maps;
- If you can setup a tile store on your device, you can use your maps offline by configuring the Tile URL to reference your local tile store. The map tile provider/feed (to render map background tile base layer). Tile Feeds can be configured under the button in the Map View itself. Tile URL's can be based on remote (http://, https://) or local (file:// or relative URL) prefixes, depending on where you setup your offline tile store.
- Or, you can use this button in the Map View itself to prefetch baselayer map tiles (when you have an internet connection) that you can then later use when working offline. To use this option, first zoom to an area of interest on the map, then click this button and select the zoom level of tiles that you want to store for later offline use. The higher the zoom level, the larger the number of tiles that will need to be downloaded. When downloading tiles, a blue numeric progress counter will be shown in the bottom left of the map pane. Depending on your baselayer tile source, the offline tile download may not work under certain circumstances, namely when; either there is mixed content on the page (ie, this page is served via https but your tile provider is served over http) or your tile provider does not support cross origin requests. The downloaded tiles themselves are stored in your offline database in a table called MAP_TILE_STORE. Please Note: Bulk downloading of map tiles may be subject to your tile provider's download and usage policies.
Results as KMLIf your result set is mappable (refer to "Results as Map View" above), that is, there is a latitude and longitude, and/or geometry field present in your result set, then that result set can be opened as KML using the button. Also, if there is a field named name in the result set, then this will be used as the feature label in the KML output. A client program capable of viewing KML will be required on your device. This option may not work on some mobile devices.
Results as CSVResult sets can be opened as CSV by clicking on the button once you have run a search. A client program capable of viewing CSV output will be required on your device. This option may not work on some mobile devices.
Preventing Unresponsive Pages
You may be prompted to confirm an action that has the potential to make the web page unresponsive, such as;
- Listing a large number of results. Eg; "List All?" prompt.
- Drawing a Map with either a high number of features, or large amount of detail in map popups
What Actually Requires an internet ConnectionThe core functionality of this offline application, that is searching the RRL tables ("Table Search", "Technical Records Search" and "SQL" search), is designed to be able to be performed without an internet connection. The following functions/links however may require an internet connection, at the time they are used/invoked;
- - Under the "Load Data (start here)" tab, these require an internet connection to download data from the ACMA Website directly to your offline database.
- - Use of these Geo-location services may require an internet connection at the time they are invoked depending upon your device.
- - The default base layer in the Map View will require an internet connection to render map background layers. However, tile base layers can be configured to not have to rely on an internet connection - refer to Results Map View section above.
- - Viewing KML output entirely depends upon your KML viewing program - which may require an internet connection to render background layers.
- Some hyperlinks to external resources - namely, at the bottom of this help page and the bottom of the main tabs will require an internet connection.
If your browser supports WebSQL but an error is encountered when this application attempts to create a 2Gb database on your device - it is then assumed that you may be using a common older, or mobile, device that only supports the creation of a maximum 50Mb WebSQL database. In this case, you will be prompted to use "Sampler Mode" when you first load this page.
Sampler Mode will attempt to import the SITE table only from the Spectra RRL Dataset in order to try to keep your offline database under 50Mb in size. This will allow basic searching/charting/mapping of the SITE table data only rather than giving no functionality at all. Currently, the creation of the SITE table (along with the SITE_RAW table) in Sampler Mode just barely fits under 50Mb in size. In the future, Sample Mode may be made even more restrictive.
Sampler Mode may indicate that your device has limitations on the amount of offline storage that can been used.
Troubleshooting/Housekeeping your offline database
There may be circumstances where you may wish to remove your offline database. Such as;
- You wish to free up space on your device occupied by the ACMA offline database.
- You wish to turn off Sampler Mode on your device.
- Your ACMA offline database may have become corrupted. Eg, this application hangs when trying to load your offline database.
- You wish to optimise subsequent Import times by dropping your offline database prior to running an Import.
- Navigate to chrome://settings/cookies (or equivalent area on your browser)
- Identify the website web.acma.gov.au
- Then remove either;
- All temporary objects for this domain if you wish to drop all ACMA Offline objects or reset sampler mode
- Or, only remove the WebSQL database named acma_offline_rrl_db if you simply wish to to drop the database to improve subsequent Import times
- After you have removed the temporary objects, or WebSQL database, then reload this page before continuing.
If you experience this error during the Import phase (there was not enough remaining storage space, or the storage quota was reached and the user declined to allow more space), it may indicate that a request for 2Gb storage was initially successful however during actual allocation, your browser is enforcing quota restrictions on the amount of usable storage/disk space on your device for TEMPORARY objects. Common quota restrictions for Chrome and Opera on Windows and Android platforms for TEMPORARY objects (ie, WebSQL database) may mean that it is necessary to have 14Gb - 20Gb of free storage available in order to import the ACMA Spectra RRL dataset. Such quota restrictions commonly apply the following rules; 1) only 50% of remaining storage/disk space on your device will be considered in the usable "pool", 2) of the usable "pool" a single web page may only be permitted to use a maximum of 20% of the pool. In other words, you may need up to 10 times free space on your device that what the ACMA Spectra RRL WebSQL will occupy (ie, 10 x 1.4-2.0Gb = 14Gb-20Gb). So, if you experience this error, please ensure that there is approximately 20Gb free space available on your device and rerun your import.
If you use the Chrome browser and are experiencing the above space issue and you have additional drives available on your device you may find the Chrome command line option --user-data-dir useful. For example by default, on Windows platforms, the Chrome browser will store temporary internet files on your C: drive. If you have less than 20Gb on your C: drive but have an additional disk/storage drive available (say D: drive), you can right click on your Chrome browser shortcut and add the following after "chrome.exe" in the Target section of the shortcut; --user-data-dir=D:\chrome-temp-files - which will instruct Chrome to use an alternative directory for your temporary internet files.
- RRL Licence Usage Conditions [text]
- Download Page for Spectra RRL Dataset (ACMA website) *
- Summary of Spectra RRL format
- Spectra RRL ER diagram
- ACMA Online Register *
Please send feedback about this ACMA Offline RRL directly to; firstname.lastname@example.org