Home

SDL Network Viewer Version R1_27 User Manual

1. If the field structure is unknown to the SDL Network Viewer export engine the fields will have to be mapped in order to export the Latitude Longitude and Site Elevation fields which are critical to the KML mapping process The KML Options also do not know the structure of the Generic Path List Database It must be told which fields belong in the Sites Balloon and which fields belong in the Path Balloon After the fields are mapped and the balloon fields are chosen then the database can be exported to KML like any other database Import ULS Query The Universal Licensing System Query Database is like a MW Paths Database in that it has a similar field structure however the source of the database is completely different The source of the ULS Query Database is a text delimited file that contains all of the tables that apply to a MW Paths Database in one file The ULS Query Database text file is downloaded separately from any other database but it too comes from the ULS site based upon a specific query made of the the entire ULS site In this sense it is slightly different SDL Network Viewer R1_27 Manual from a MW Paths Database in that it can contain frequencies from other bands than those normally shown Since it is not known in advance what all of the bands may be the Band Selector may not be able to filter on all of the bands in the database But with this exception the ULS Query Database can be imported filtered and export
2. Zip County Type Height MTA BTA Contact SDL Network Viewer R1_27 Manual Phone Email RSM RSM Email The number of rows imported is shown in the Status Strip at the bottom of the Database Viewer when import completed The Database Viewer can be resized as necessary to accommodate various screen sizes The number of rows is a useful metric when the database is manipulated in follow on tasks as it always represents the number of rows that are currently in the Database Viewer This number obviously changes as the user selects different filter criteria A short message is displayed after the import informs the user of how much time the import process has taken Large standard databases such as the ASR Database and the MW Paths Database will take longer importing than the smaller standard databases such as the SBA Communications Database and American Tower Database Import MW Paths Database Importing a MW Paths Database requires that the database already be downloaded Select the MW Paths Database from the Imports Option located in the Main Menu and the user will be provided with a Browse for Folder prompt Select the folder of the MW Paths Database for import by highlighting and then select OR Once the folder is selected the SDL Network Viewer database engine takes over and creates the appropriate queries by which to import the data Note the Status Strip display in the lower left hand corner of the Database Viewer It displa
3. 1 Annual multipath unavailability sec 2 Annual 2 way multipath availability Annual 2 way multipath unavailability sec Polarization Rain region 0 01 rain rate mm hr Rain rate mm hr Flat fade margin rain dB Rain attenuation dB Annual rain availability Annual rain unavailability min Annual rain multipath availability Annual rain multipath unavailability min TX1 MHz 1 TX1 MHz 2 TX2 MHz 1 TX2 MHz 2 TX3 MHz 1 TX3 MHz 2 TX4 MHz 1 TX4 MHz 2 TX5 MHZ 1 TX5 MHz 2 TX6 MHZ 1 TX6 MHz 2 TX7 MHz 1 TX7 MHz 2 TX8 MHZ 1 TX8 MHz 2 TX9 MHz 1 SDL Network Viewer R1_27 Manual TX9 MHz 2 TX10 MHz 1 TX10 MHz 2 TX11 MHz 1 TX11 MHz 2 TX12 MHz 1 TX12 MHz 2 NoName PathLabel The number of rows imported is shown in the Status Strip at the bottom of the Database Viewer when import completed The Database Viewer can be resized as necessary to accommodate various screen sizes The number of rows is a useful metric when the database is manipulated in follow on tasks as it always represents the number of rows that are currently in the Database Viewer This number obviously changes as the user selects different filter criteria A short message is displayed after the import informs the user of how much time the import process has taken Import Frequency Coordination Report Importing the Frequency Coordination Database requires that the database alr
4. 24 29 30 Link List database 29 30 M Main Menu 2 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 33 34 37 38 39 40 41 43 44 45 46 47 48 Main Menu Options 7 0 Menu Item 2 2 16 17 18 19 20 Menu Items 2 2 16 Menu Itemsmenm minimum bounding box 4 mports 2 7 8 10 11 24 25 26 27 29 33 34 MW Paths 2 4 7 8 20 21 22 24 25 26 27 29 35 36 MW Paths Database 2 8 21 22 24 25 26 27 29 35 36 MW Paths Import Type 27 N NationalSiteList 23 New Folder 2 22 23 O Operator 38 39 41 P Path Balloon 35 38 42 Path Balloon Items 42 Path Colors 8 42 Path Line Color 7 Perimeter Filter 2 3 12 13 18 39 40 41 Perimeter Filter Tab 73 41 Perimeter Filtering 72 39 Perimeter Search 40 41 Perimeter Search Type 4 Pipe 3 8 16 17 21 22 37 pipe delimited 8 16 21 22 37 pipe delimited text 37 Q Qui 2 7 12 Quit 2 12 1 R RACodeDescriptions 2 Registrations 4 7 20 21 Release Notes 3 8 46 48 6 19 20 24 25 26 27 29 33 34 38 40 41 42 45 1 1 6 19 20 45 SDL Network Viewer R1_27 Manual Release Notes Option Release Notes Selection 46 48 Roll Your Own 40 RX Lat 28 29 RX Lat Dec Degrees 28 29 RX Site 33 43 RX Call Sign 28 29 S Save Filter to Clipboard 40 SBA Communications Company 4 7 20 21 SBA Communications Corporation Database 23 SBA Communications Database 26 27
5. One way to that is for the user click Save Filter to Clipboard Go to saved clipboard copy and then paste it to Roll Your Own text box Note that using the Roll Your Own text box takes precedence over the field name selections User will need to clear the Roll Your Own text box in order to use the field name selections If user plans to do a Perimeter Filter the Perimeter Search button needs to be set to On as it defaults to Off Also notice that Band Filters are supplied so that the database can be Frequency Selective This allows for much greater flexibility in exporting a filtered database in that not only can the Field Names be filtered but the database can be further sub filtered based on frequency as well This becomes advantageous if the user wants to have multiple KML maps with separate frequencies shown with different colors See the KML Options for more information Perimeter Filter a Filtering and KML Palette Options Export Clearltems Apply Filter ApplySort Quit Column Filtering Perimeter Fiter KML Options Field Mapper Custom Sorter Center Distance The location references Fees ne Lat Long Bounding Box parcial Lat Long Bounding Box Location References Latitude TX Latitude Min TX Longitude we BS Latitude RX Latitude Min RX Longitude Lait ES Center Distance The minimum or smallest bounding or enclosing box is atem used in geometry The FilterPalette Option is locat
6. 29 SBA Database 2 8 23 24 25 26 39 SBA Sites 23 SDL Database Viewer 11 39 SDL Network Viewer 4 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 30 33 34 35 37 38 39 45 46 47 48 SDELNetworkViewer Manual Version R1 082214 SDLNetworkViewer Manual Version RI 42 090114 49 SDLNetworkViewer R1 Version 082214 Serial Number 7 Site Colors 7 Site Balloon 38 42 Site Balloon Items 42 Site Code 26 39 Site Colors 8 42 Site Icon Color 7 Site Icon Style 7 Site Icons 8 42 Sites and Paths 4 42 43 Sites Balloon 35 Sites Only 42 43 Sort Field Hierarchy 44 Sort Level 44 Sort Selector 44 Sort Selectors 44 Spacial Datalyst 4 5 8 46 Spacial Datalyst Network Viewer 4 Spatial Datalyst 4 48 Standard Database 4 7 10 20 21 24 25 26 27 29 30 33 35 43 Standard Databases 4 7 10 20 21 25 26 27 29 Status Strip 2 22 23 24 25 26 27 29 30 33 34 T text delimited file 35 Tool Bar 7 TX Lat 28 29 TX Lat Dec Degrees 28 29 TX_Ground Elevation 28 29 SDL Network Viewer R1_27 Manual TX Site 28 29 TX Site Status 28 29 TX_Tower Registration Number 28 29 TX Unique 27 29 TX_Unique System Identifier 27 29 U ULS 2 4 7 8 20 21 24 35 36 37 ULS MW Apps 2 4 7 8 20 24 36 ULS Query 2 4 7 8 20 24 35 36 ULS Query Database 35 36 ULS Query Databases 7 Universal Licensing System Query 35 V Values1 39 Values2 39
7. Link Lists ULS Query ULS MW Apps These databases are imported into the Database Viewer where they can be viewed filtered sorted and exported using the convenience of an extensive GUI interface The databases can also be downloaded at any time their availability is only limited by the provider of the internet service and the database themselves This means that for every new design complete databases can be downloaded and then exported for each design task With the aid of the SDL Network Viewer the designer can now literally not only see all of the other sites in the geographical regions of interest but also when available the paths as well The insight that this provides is enormous and unofficial studies suggest that design time can be reduced by as much as 60 percent We at Spatial Datalyst are happy to provide this new and exciting product and hope to hear about our user s experiences SDL Network Viewer R1_27 Manual Support Spacial Datalyst uses an email trouble shouting reporting system User will send an email to the following email address describing the issue and Spacial Datalyst will respond within 24 hours or less sdi tx rr com SDL Network Viewer R1_27 Manual Order SDL Network Viewer R1_27 Manual Getting Started To get started the user has to have an official serial number which will be validated against a web server hosting a validation service The serial number will be required upon launch
8. and KML Palette HELP Option Help User documentation About Information about Spacial Datalyst Release Notes Releases EXIT Option Exits the tool SDL Network Viewer R1_27 Manual Screen Display It may be necessary to adjust the Screen Options when using SDL Network Viewer with very high resolution displays The screen resolution for high DPI monitors is defined to be 100 percent other values will cause control sizing distortions Use the Program Compatibility troubleshooter to make sure your screen uses standard settings instead of the expanded landscape setting Unusual results may occur causing the Database Viewer to not display correctly Additionally the FilterPalette may be sized incorrectly SDL Network Viewer R1_27 Manual Tutorial The following is a tutorial that will be helpful to the user in executing the SDL Network Viewer By reviewing the screenshots of the Main Menu options Imports Downloads and FilterPalette the user can begin to get familiar with the capability of the SDL Network Viewer Screenshots Screenshots are provided of Downloads and Imports Downloads consist of the four standard databases that can be downloaded to the SDL Network Viewer Imports includes all those databases that can be imported into the Database Viewer to be viewed filtered sorted and exported to files Downloads Imports Downloads FilterPalette Help Exit American Tower ASR SBA MW Paths Scre
9. level The main export of the Viewer is to a KML file which offers a rich Imports according to at least four standard database sources Exports FCC Part 101 MW Paths Ka Reports FCC Antenna Structure Registrations ru SBA Communications Company Help American Tower Site List The Help Selection is located in the Help Option of the Main Menu of the SDL Network Viewer The Help Selection displays the user manual and describes in detail all aspects of the SDL Network Viewer It describes how to get started a tutorial of screen displays and explanation of downloading importing and exporting databases About Spatial DataLyst 2014 Spatial Datalyst i R1_42 RegisteredName Activated Unknown www spatialdatalyst com www sdiblog com www sditwitter com www sdifacebook com ES The About Selection is located Help Option of the Main Menu of the SDL Network Viewer SDL Network Viewer R1_27 Manual The About Selection describes the Spatial Datalyst version currently loaded and pertinent information for the user Release Notes The Release Notes Selection is located the Help Option of the Main Menu of the SDL Network Viewer Release Notes Selection describes the changes made for each release Videos Videos introductions of various aspects of the SDL Network Viewer SDL Network Viewer R1_27 Manual Version The latest version of the manual is SDLNetworkViewer_Manual_Version_R1_42_090114 CHM SDL Network Viewer R1
10. 2 Emission designator 1 Emission designator 2 EIRP dBm 1 EIRP dBm 2 ERP dbm 1 ERP dbm 2 ERP watts 1 ERP watts 2 RX threshold criteria 1 RX threshold criteria 2 RX threshold level dBm 1 RX threshold level dBm 2 RX threshold level uv 1 RX threshold level uv 2 Main receive signal dBm 1 Main receive signal dBm 2 Diversity receive signal dBm 1 Diversity receive signal dBm 2 Thermal fade margin dB 1 SDL Network Viewer R1_27 Manual Thermal fade margin dB 2 Number of interference cases 1 Number of interference cases 2 Composite interference level multipath dBm 1 Composite interference level multipath dBm 2 Interference fade margin multipath dB 1 Interference fade margin multipath dB 2 XPD fade margin multipath dB 1 XPD fade margin multipath dB 2 Flat fade margin multipath dB 1 Flat fade margin multipath dB 2 Dispersive fade margin dB 1 Dispersive fade margin dB 2 Dispersive fade occurrence factor Effective fade margin dB 1 Effective fade margin dB 2 Climatic factor Terrain roughness ft C factor Average annual temperature F Fade occurrence factor Po Worst month multipath availability 1 Worst month multipath availability 2 Worst month multipath unavailability sec 1 Worst month multipath unavailability sec 2 Annual multipath availability 1 Annual multipath availability 2 Annual multipath unavailability sec
11. DL Network Viewer When selected the import opton asks the location of the database folder and then begins the import process In general the import process consists of establishing a connection to the database and then using SQL constructions builds all of the database rows and columns When the import process is completed the resultant dataset is displayed in the Database Viewer Note that the user can scroll to the right and left and up and down to see all columns and rows The user can then sort any column at this point by simply clicking on the column name SDL Network Viewer R1_27 Manual Additionally the user can use the FilterPalette from the Main Menu against the database view and create complex filtering constructs When exporting to KML the FilterPalette can be used to select Site Colors Site Icons and Path Colors The FilterPalette can then be used to export the filtered database to a CSV pipe delimited or KML file as needed See the FilterPalette section for more details Toolbar Imports Downloads FilterPalette Help Exit American Tower ASR SBA MW Paths Datak The Toolbar at the top of the Main Menu consists of the following selections IMPORTS Option American Tower Database ASR Database SBA Database MW Paths Database Link List FC Report Generic ULS Query and ULS MW Apps DOWNLOADS Option American Tower Database ASR Database SBA Database MW Paths Database FILTER PALETTE Option Filters
12. Export to CVS Export to KML 3 38 Export to Pipe 3 37 F FC Report 8 24 FCC Antenna Structure Registrations 4 7 20 21 FCC Part 101 MW Paths 4 7 20 21 FCC Registration Number FRN 27 29 FCC ULS 21 Field Mapper 2 3 12 14 15 18 35 39 42 43 Field Mapper Tab 5 42 43 Field Names 27 28 40 Fileld Name 39 Filter Expression 40 Filter Tab 72 13 16 17 39 41 Filter Tabs 72 39 FilterPalette 2 3 7 8 9 10 11 12 13 14 15 16 17 18 19 20 24 25 26 27 30 33 34 35 37 38 39 40 41 43 44 FilterPalette Option 71 39 40 41 43 44 Frequency Coordination Database 33 Frequency Coordination Report 2 4 7 20 33 Frequency Coordination Reports 4 7 Frequency Selective 40 G Generic 2 4 7 8 20 24 34 35 43 Generic Link Lists 4 7 Generic Path List 2 20 24 34 35 43 Generic Path List Database 34 35 43 Google Earth Keyhole Markup Language 38 H Hardware ID 7 Help 3 7 8 10 20 46 47 48 Help Option 8 20 46 47 48 Help Selection 47 Help 3 46 47 Help Option Help Selection 46 47 l Import Type 27 Imports 2 7 8 10 11 24 25 26 27 29 33 34 SDL Network Viewer R1_27 Manual Imports Option 7 8 11 24 25 26 27 29 33 34 K KML 2 3 4 8 12 13 14 16 17 18 35 37 38 39 40 41 42 43 KML Options 2 3 12 13 14 18 35 39 40 41 43 KML Options Tab 4 KML OptionsTab 4 KML Template 35 43 L Link List 2 4 7 8 20
13. SDL Network Viewer Version R1_27 User Manual Copyright 2014 Spatial Datalyst SDL Network Viewer R1_27 Manual Table of Contents ADO a a 4 TI en en anne teen nee E Men eee ten nente ences iter tpte tert re reer a tree atte tr pe mere te 5 LS LC TEE 6 GOING Started rime 7 Main M n E 7 Re ARE 8 Screen Display nn idea tan 9 Duterte Zeg eegene GEES Eege 10 Screenshots 2 eee eaa an aeaaaee eae enone mentee errr 10 Ree EE 10 eut EE 10 PP E Eiana idana iiai 11 C l mn E EE 12 Perimeter FINER resisae saeia eei a ae ee e EE G a a aa E Deaan 12 ETag 13 Ree 14 CUSTOM SOMBRE Don 15 Menu R eee a ce 16 OGL a oo cu Du 17 Clear GIES PR RE 17 APPIY E 17 et EE 18 CR an les 19 Downloading Importing and Exporting 20 Video Tutorials ee ER 20 Nees e TE 21 ASR Database ea ee mnene 21 MW Paths Database eege sees nnne 21 American Tower Database s s sessceeeeeeeeeeeeeeeeesesseseeeneaeaaneaeeees 23 SBA Properties A ni he na 23 DONS ne a en ne 24 Import ASR EE 24 Import American Tower Database 25 import SBA Database cesse munies 26 Import MW Paths Database sn 27 Import Link List esse 29 Import Frequency Coordination Report ss 33 Import Generic Path List ni nnen 34 Import WLS QUETY ne tu 35 Import ULS MW ADS 2 us eae ce eceche eccdas caadvedbedaaceubereseenetnas 36 EE 37 SDL Network Viewer R1_27 Manual Export t C
14. SV nd ne ae ass coude came feeds 37 Export to Pipe ee sananne an aAA Eaa a EANA ANKANA ARNALA SEES 37 Export to KML sea dm 38 FilterPalette EH 39 Column Filtering EE 39 Perimeter FIG an EE 40 KML OPti O S ier eee iinan ninnaa pi em ne nnn mee nee eae mee renee orn ter 41 Field Mapper E 42 Custom Sorter aaasssssunnnnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnmnnn nnmnnn ee 43 d EE 45 AO in dadia 46 RSR A enon eee OMe Per Sn ae eee senna Eon on Sree cee ee me neie ner 46 ee Tt ganar tera se ne Tce Se 47 EN Ve dE 48 WEG EE 48 Ve RE 49 D a a a ia a 50 SDL Network Viewer R1_27 Manual About The Spacial Datalyst Network Viewer offers today s modern network designer a new tool to expedite design speed and thoroughness Using Relational Database techniques and publicly available databases the SDL Network Viewer can display complete attribute lists on a per site and or per path level The four Standard Databases that can be downloaded to the SDL Network Viewer are FCC Part 101 MW Paths FCC Antenna Structure Registrations SBA Communications Company American Tower Site List The main export of the SDL Network Viewer is to a KML file which offers a rich designer experience that locates sites and paths according to at least these four Standard Database sources Additional databases are also available that are frequently used in the Telecom Design industry These include Link List Frequency Coordination Reports Generic
15. Sort Quit Screenshot of the Custom Sorter Tab in the Filter Palette which is located in the Main Menu of the SDL Network Viewer Menu Items E a Menu Items which include Export Clear Items Apply Filter and Quit is located in the FilterPalette of the Main Menu in the SDL Network Viewer Export is used to export the filtered data to CSV Pipe delimited or KML files Clear Items is used to clear all the fields in the Filter Tab the user is currently working with Apply Filter is used when the user has completed the filter criteria and wants to execute the filter Quit enables the user to get out of the FilterPalette SDL Network Viewer R1_27 Manual Export Export to CSV Export to Pipe Export to KML Export a Menu Item located in the FilterPalette enables the user to export filtered data to a CSV Pipe or KML file The FilterPalette is found in the Main Menu of the SDL Network Viewer Clear Items iJ Filtering and KML E Export Clearltems Apply Filter ApplySort Quit Clear Column Filters Clear Freq Bands Clear Perimeter Search Clear Roll Your Own Clear Site Balloon Populator Clear Path Balloon Populator Clear Items a Menu Item located in the FilterPalette allows the user to clear all of the filtering criteria entered when in a Filter Tab The FilterPalette is in the Main Menu of the SDL Network Viewer Apply Filter SDL Network Viewer R1_27 Manu
16. Unique System Identifier TX_Call Sign SDL Network Viewer R1_27 Manual RX_Call Sign TX_Site Status TX_Location Address TX_Location City TX_Location County Borough Parish TX_Location State TX_Ground Elevation TX Lat Dec Degrees TX Long Dec Degrees TX_Tower Registration Number TX_Structure Type TX_Height of Support Structure TX_Overall Height of Structure RX_Site Status RX_Location Address RX_Location City RX_Location County Borough Parish RX_Location State RX_Ground Elevation RX Lat Dec Degrees RX Long Dec Degrees RX_Tower Registration Number RX_Structure Type RX_Height of Support Structure RX_Overall Height of Structure RX Height to Center RAAT TX_Antenna Make TX Antenna Model RX_Antenna Make RX_Antenna Model Transmitter Make Transmitter Model Frequency Assigned License Status Type Il Field Names Entity Licensee Name Contact Licensee Name L Contact Person L Phone L Fax L Email L Street Address L City L State L Zip Code L PO Box L Attention Line CL Contact Person CL Phone CL Fax CL Email CL Street Address CL City CL State CL Zip Code SDL Network Viewer R1_27 Manual CL PO Box CL Attention Line FCC Registration Number FRN TX_Unique System Identifier TX_Call Sign RX_Call Sign TX_Site Status TX_Location Address TX_Location City TX_Location County Borough Parish TX_Location State TX_Ground Elevation TX Lat Dec Degrees TX Long Dec Degrees TX_Tower Registratio
17. _27 Manual Index 30 SBA 7 A Abou 2 3 4 8 46 47 48 About Option 46 About Selection 46 47 48 Activate License 46 Activate License Option Activate License Selection 46 ads Option 7 8 10 American Tower 2 4 7 8 20 21 23 24 25 26 27 29 American Tower Database 2 8 23 24 25 26 27 29 American Tower Site List 4 7 20 21 Antenna downtilt 1 29 Antenna Structure Registration 4 7 20 21 Antenna Structure Registrations 4 7 20 21 Apply Filter 2 12 16 17 18 40 41 42 43 Apply Filter Menu Item Apply Sort 2 18 19 44 ASC 44 ASR 2 7 8 21 24 25 26 27 29 34 ASR Database 2 8 21 24 25 26 27 29 ASR Master Database 8 B Band Filters 40 Band Selector 36 C CFR 21 CHM 49 Clause 39 Clear Items 2 12 16 17 Cluster Report 20 Column Filtering 2 3 12 18 39 41 Column Filtering Tab 72 39 41 Column Name 7 42 44 Column Names 42 44 CSV 3 8 16 17 37 38 Custom Sorter 2 3 12 15 16 19 39 43 44 Custom Sorter Tab 16 44 D Database Type 42 43 Database Viewer 4 7 9 10 11 20 21 22 23 24 25 26 27 29 30 33 34 39 40 41 42 43 44 DESC 5 21 44 46 47 48 Direction 44 SDL Network Viewer R1_27 Manual Downloads 2 7 8 10 21 22 23 37 Downloads Option 7 8 10 DPI 9 E Exit 3 7 6 45 Exit Option 8 45 Export 2 3 4 7 8 10 11 12 16 17 20 34 35 36 37 38 39 40 41 42 47 Export to CSV 3 37
18. ain dBd 2 Antenna diameter ft 1 Antenna diameter ft 2 Antenna 3 dB beamwidth H 1 Antenna 3 dB beamwidth H 2 Antenna height ft 1 Antenna height ft 2 Antenna azimuth 1 Antenna azimuth 2 Antenna down tilt 1 Antenna down tilt 2 Orientation loss dB 1 Orientation loss dB 2 TX line model 1 TX line model 2 TX line unit loss dB 100 ft 1 TX line unit loss dB 100 ft 2 TX line length ft 1 TX line length ft 2 TX line loss dB 1 SDL Network Viewer R1_27 Manual TX line loss dB 2 Connector loss dB 1 Connector loss dB 2 Miscellaneous loss dB 1 Miscellaneous loss dB 2 Circulator branching loss dB 1 Circulator branching loss dB 2 TX switch loss dB 1 TX switch loss dB 2 TX filter loss dB 1 TX filter loss dB 2 Other TX loss dB 1 Other TX loss dB 2 RX hybrid loss dB 1 RX hybrid loss dB 2 RX filter loss dB 1 RX filter loss dB 2 Other RX loss dB 1 Other RX loss dB 2 Diversity RX circulator loss dB 1 Diversity RX circulator loss dB 2 Other diversity RX loss dB 1 Other diversity RX loss dB 2 Frequency MHz Path length mi Free space loss dB Atmospheric absorption loss dB Field margin dB Diffraction loss Main net path loss dB 1 Main net path loss dB 2 Diversity net path loss dB 1 Diversity net path loss dB 2 Configuration 1 Configuration 2 Radio model 1 Radio model 2 TX power dBm 1 TX power dBm
19. al Ka hd Roll Your Own Ex gt TX_Call Sign KAB87 Apply Filter a Menu Item located in the FilterPalette executes the filtering criteria of the Column Filtering Perimeter Filter KML Options and Field Mapper The FilterPalette is found in the Main Menu of the SDL Network Viewer Apply Sort SDL Network Viewer R1_27 Manual ad Filtering and K ML F Ge Export Clearltems Apply Filter Quit v Roll Your Own Ex gt TX_Call Sign KAB87 11 Ghz 18 Ghz Apply Sort a Menu Item executes the sort criteria of the Custom Sorter The FilterPalette is found in the Main Menu of the SDL Network Viewer Quit SDL Network Viewer R1_27 Manual Export Clearltems Apply Filter Apply Sort Column Deng Perimeter Fiter KML Options Field Mapper Custom Sorter Field Names Clause Values1 Values2 Operator Yv LA Roll Your Own Ex gt TX_Call Sign KAB87 Band Filters 18 Ghz 23 Ghz Save Filter to Clipboard C 11Ghz Quit a Menu Item allows user to quit the FilterPalette which is found in the Main Menu of the SDL Network Viewer Downloading Importing and Exporting The four Standard Databases which can be downloaded to the SDL Network Viewer are FCC Part 101 MW Paths FCC Antenna Structure Registrations SBA Communications Company American Tower Site List All four of the above databases have to be downloaded before they c
20. an be imported to the Database Viewer Additional databases Link List Frequency Coordination Report Generic Path List ULS Query and ULS MW Apps can all be imported Once the databases are imported into the Database Viewer they can be viewed filtered and exported Video Tutorials Video tutorials are available in the Help Option which is found in the Main Menu of the SDL Network Viewer SDL Network Viewer R1_27 Manual Downloads The four Standard Databases which can be downloaded to the SDL Network Viewer are FCC Part 101 MW Paths FCC Antenna Structure Registrations SBA Communications Company American Tower Site List ASR Database The ASR Database is downloaded from the FCC ULS site at the following location http wireless fcc gov uls index htm job transaction amp page weekly The specific file is under the Antenna Structure Registration section and it is called Registrations It downloads as r tower zip The zip file contains seven text files in pipe delimited format Those tables are listed below CO dat EN dat HS dat RA dat RE dat SC dat These files are renamed and another file is added called RACodeDescriptions txt A schema file is also built that tells the database engine how the files are organized From the Main Menu select the ASR Database to be downloaded A drop down box labeled Browse For Folder will be displayed in the Database Viewer When creating a new download the user will need to cre
21. at its column structure is not predefined Once the query has executed the data is then populated into the Database Viewer which looks like an ordinary spreadsheet The user can immediately start to surf the columns and rows using the Database Viewer sliders as appropriate Additionally the column can be sorted at this point by simply clicking in the column header It is recommended that the user get acquainted with the column structure and the size of the database that has been imported as this information is useful when using the FilterPalette The column structure for the Generic Path List Database is not predefined so that the SDL Network Viewer export engine does not know SDL Network Viewer R1_27 Manual its structure Therefore in order to export to file as a KML the fields must be mapped This is done with the Field Mapper in the Filter Palette as shown below ali Filtering and KML Palette Option Export Clearltems Apply Filter Apply Sort Quit Column Filtering Perimeter Filter KML Options Field Mapper Custom Sorter Database Type Field Names CO Stes and Paths Sites Only KML Templates o No Template ASR Template SBA Template Am Tower Template MW Paths Template Link List Template FC Template ULS Template Filter If the user knows in advance that the field structure is the same as a Standard Database then a KML Template may be chosen as its field structure
22. ata for latitude longitude and site elevations can be specified through this page When the filter criteria has been specified then the option can be invoked by clicking Apply Filter Related Topics KML Options Custom Sorter SDL Network Viewer R1_27 Manual Export Clearltems Apply Filter Apply Sort Quit Column Fitering Perimeter Fiter KML Options Field Mapper Custom Sorter Sort Selectors Sort Level 1 Select gt Total Height AMSL FCC FAA The FilterPalette is located in the Main Menu Once you have a database imported to the Database Viewer click on the FilterPalette Option A six level Custom Sorter is available through the FilterPalette as well Simple sorting can be accomplished by clicking on the Column Name in the Database Viewer This may not always be sufficient especially for large complex databases The six level Sort Selectors in the Custom Sorter Tab allow for as many as six different fields to be individually or collectively selected as either Ascending or Descending sorts To begin the sort click on a field in the Column Names then click on one of the Sort Selectors The Column Name for that Sort Selector will be displayed in the Sort Field Hierarchy box Then choose the Direction of the sort either ASC or DESC The user can clear all sort fields by clicking on the Clear All Sort Fields tab If user wants to clear an individual Column Name and leave the others sc
23. ate a New Folder location to store the contents as listed above Any previously created downloads will be displayed Highlight a folder and select OK The Database Viewer will now start the download process The user will note at the bottom left corner of the Database Viewer the SDL Network Viewer creates a Status Strip and bar indicating it is downloading the chosen database Once the database has completed loading the Status Strip bar will be filled in completely The download process concludes with a short message indicating the database has been downloaded and how much time was used to conduct the transaction At this point the ASR Database is ready for importing The folder created above is used as the reference location when doing an ASR Database Import MW Paths Database The MW Paths Database is downloaded from the FCC ULS site at the following location http wireless fcc gov uls index htm job transaction amp page weekly The specific file is under the Microwave 47 CFR Parts 74 and 101 and 3650 3700 MHz section and it is SDL Network Viewer R1_27 Manual called Licenses and downloads as tower zip The zip file contains thirty six text files in pipe delimited format Those tables are listed below a3 dat AN dat BC dat BF dat CO dat CP dat CS dat EM dat EN dat F2 dat D dat ID dat IG dat FE dat ER dat HD dat HS dat Ir dat L2 dat LA dat ic dat LF dat Il dat LO dat LS dat MF dat Mk dat MW dat OP da
24. ave a database imported to the Database Viewer click on the FilterPalette Option The KML Options Tab is a complete KML customization tool that allows for the database to be exported to a KML file with user selectable criteria A KML Options example using the following criteria will export to a KML file consisting of a sites only database that has Red Dots for sites SDL Network Viewer R1_27 Manual a Filtering and KML Palette Options l Export Clearltems Apply Filter Apply Sort Quit Column Filtering Perimeter Fiter KML Options Field Mapper Custom Sorter Site Colors Useful Information Site A Keyword Se Ot Blue very large and EI e therefore it is dificult to Site Icons assign Site Balloons in Site B Keyword Path Colors Mode Yellow 7 3D es joe KE Selector Site A Site B Latitude Latitude ke Longitude Longitude v Site E RAAT Ground Elevation Filter There are six different colors for Site Colors and Path Colors as well as six different icons for Site Icons thus allowing for a vast array of options in tailoring in the KML maps for very specific displays Sites and Paths databases can be exported as well and when Paths are an option then the color of the path lines can be selected too Site Balloon Items options and Path Balloon Items options are fully user selectable as well Default values assume that the all Column Names will be used in the balloons for the colum
25. eady be downloaded or otherwise built Select the Frequency Coordination Database from the Imports Option located in the Main Menu and a directory list will be displayed Select and open the desired file Once a file is selected the SDL Network Viewer database engine takes over and creates the appropriate queries by which to import the data The Status Strip in the lower left hand corner of the Database Viewer will note the database being imported The Frequency Coordination Database is called a Standard Database in the terminology of this tool in that its column structure is predefined Once the query has executed the data is then populated into the Database Viewer which looks like an ordinary spreadsheet The user can immediately start to surf the columns and rows using the Database Viewer sliders as appropriate Additionally the column can be sorted at this point by simply clicking in the column header It is recommended that the user get acquainted with the column structure and the size of the database that has been imported as this information is useful when using the FilterPalette The column structure for the Frequency Coordination Database is as follows Market State Path number TX Site name RX Site name Main or space antenna Frequency band TX power dBm Transmit pad dB TX loss dB RX loss dB Antenna height ft Antenna model Receive signal dBm SDL Network Viewer R1_27 Manual Radio model FCC radio identi
26. ed in the Main Menu Once you have a database imported to the Database Viewer click on the FilterPalette Option SDL Network Viewer R1_27 Manual The Perimeter Filter uses a minimum bounding box method of determining candidate locations for inclusion in a database search The minimum bounding box can be defined using a latitude and longitude as the center of the box Center as used here is equidistant between the latitude and longitude minima and maxima midpoints The operator also defines the distance criteria in either miles or kilometers and the resulting database is filtered accordingly The Perimeter Filter can be used separately or in conjunction with all other filters of the FilterPalette A second form of perimeter searching is also available The user can specify the minimum and maximum of both the latitude and longitude search area directly All sites corresponding to this search criteria will be included in the resulting data selection The Perimeter Search Type selection is mutually exclusive but either selection can be used in conjunction with other filters The Perimeter Filter Tab must be turned on or off from the Column Filtering Tab by setting the Perimeter Search button But once the feature has been selected it is an option with its own tab When the filter criteria has been specified then the option can be invoked by clicking Apply Filter KML Options The FilterPalette Option is located in the Main Menu Once you h
27. ed just like the MW Paths Database Import ULS MW Apps The Universal Licensing System MW Apps Database is like a MW Paths Database The ULS MW Apps Database is created by the user and can be imported filtered and exported just like the MW Paths Database The ULS MW Apps import is a ULS Query of the existing at the time of query MW license applications that are in the FCC database SDL Network Viewer R1_27 Manual Exports Exporting to a CSV Pipe or KML file is available through the FilterPalette found in the Main Menu of the SDL Network Viewer Export to CSV Export to CSV Export to Pipe Export to KML The export to a CSV file is available through the FilterPalette found in the Main Menu of the SDL Network Viewer When the Export to CSV option is chosen the database as filtered and sorted will be output directly to a CSV file Export to Pipe Export Clear Items Apply Filter ApplySort Quit Export to CSV Export to Pipe Export to KML The export to a pipe delimited file is available through the FilterPalette found in the Main Menu of the SDL Network Viewer When the Export to Pipe is chosen the database as filtered and sorted will be output directly to a pipe delimited text file The pipe delimited text file is presented at this time as it is the same format as the the files downloaded from the ULS site It has no specific application other than to be consistent with the ULS downloads at
28. enshot of the Downloads Option which is located in the Main Menu of the SDL Network Viewer The four databases have to be downloaded before being imported to the tool Imports SDL Network Viewer R1_27 Manual Imports Downloads FilterPalette Help Exit ASR SBA MWPaths LinkList FC Report AmericanTower Screenshot of the Imports Option located in the Main Menu of the SDL Network Viewer The above databases can be imported into the Database Viewer where they can be viewed filtered sorted and exported FilterPalette aJ Filtering and KML Palette Options Export ClearItems Apply Filter ApplySort Quit Column Fitering Field Names Clause Values1 Values2 Operator The FilterPalette Option is located in the Main Menu of the SDL Database Viewer This option allows the user to filter sort and or export imported databases SDL Network Viewer R1_27 Manual The FilterPalette Filter Tabs include Column Filtering Perimeter Filtering KML Options Field Mapper and Custom Sorter These features allow the user to filter and sort the imported database While using the various Filter Tabs the user can execute any of the Menu Items which are Export Clear Items Apply Filter and Quit These allow the user to export the filtered data clear the filter criteria execute the filter criteria or quit the FilterPalette Column Filtering aJ Filtering and KML Palette Options Export C
29. fier FCC emission type Fade margin dB EIRP dBm Latitude Longitude Datum Ground elevation ft True azimuth Path length mi Comments ASR Structure type Address Tower height w App ft Tower height w o App ft City Zip code TX frequency MHz Polarization PathLabel The number of rows imported is shown in the Status Strip at the bottom of the Database Viewer when import completed The Database Viewer can be resized as necessary to accommodate various screen sizes The number of rows is a useful metric when the database is manipulated in follow on tasks as it always represents the number of rows that are currently in the Database Viewer This number obviously changes as the user selects different filter criteria A short message is displayed after the import informs the user of how much time the import process has taken Import Generic Path List Importing the Generic Path List Database requires that the database already be downloaded or otherwise build Select the Generic Path List Database from the Imports Option located in the Main Menu and a directory list will be displayed Select and open the desired file Once a file is selected the SDL Network Viewer database engine takes over and creates the appropriate queries by which to import the data The Status Strip in the lower left hand corner of the Database Viewer will note the database being imported The Generic Path List Database is non standard in the sense th
30. he Imports Option located in the Main Menu and a directory list will be SDL Network Viewer R1_27 Manual displayed Select and open the desired file Once a file is selected the SDL Network Viewer database engine takes over and creates the appropriate queries that import the data The Status strip in the lower left hand corner of the Database Viewer will note the database being imported The Link List Database is called Standard Database in the terminology of this tool in that its column structure is predefined Once the query has executed the data is then populated into the Database Viewer which looks like an ordinary spreadsheet The user can immediately start to surf the columns and rows using the Database Viewer sliders as appropriate Additionally the column can be sorted at this point by simply clicking in the column header It is recommended that the user get acquainted with the column structure and the size of the database that has been imported as this information is useful when using the FilterPalette The column structure for the Link List Database is as follows Site name 1 Site name 2 Call sign 1 Call sign 2 Station code 1 Station code 2 Latitude 1 Latitude 2 Longitude 1 Longitude 2 True azimuth 1 True azimuth 2 Vertical angle 1 Vertical angle 2 Elevation ft 1 Elevation ft 2 Antenna model 1 Antenna model 2 Antenna gain dBi 1 Antenna gain dBi 2 Antenna gain dBd 1 Antenna g
31. learltems Apply Filter ApplySort Quit Column Filtering Perimeter Fitter KML Options Field Mapper Custom Sorter Field Names d Values1 Values2 2 v Roll Your Own Ex gt TX_Call Sign KAB87 11 Ghz 18 Ghz 23 Ghz Save Filter to Clipboard Screenshot of the Column Filtering Tab in the FilterPalette which is located in the Main Menu of the SDL Network Viewer Perimeter Filter SDL Network Viewer R1_27 Manual Screenshot of the Perimeter Filter Tab in the FilterPalette which is located in the Main Menu of the SDL Network Viewer KML Options SDL Network Viewer R1_27 Manual al Filtering and KML Palette Options 8 L Export Clearltems Apply Filter Apply Sort Quit KML Options Site Colors Useful Information Site A Keyword Link lists are typically CC RB ie R EI AL therefore it is dificult to Site Icons assign Site Balloons in Site B Keyword gege Oz Path Colors GE Mode Screenshot of the KML OptionsTab in the FilterPalette which is located in the Main Menu of the SDL Network Viewer Field Mapper SDL Network Viewer R1_27 Manual Filtering and KML Palette RE Export Clearltems Apply Elter ApplySort Quit Screenshot of the Field Mapper Tab in the FilterPalette which is located in the Main Menu of the SDL Network Viewer Custom Sorter SDL Network Viewer R1_27 Manual a Filtering and KML P Export ue Apply Filter pres
32. leld Name Clause Values1 Values2 and Operator Each layer of the filter is applied in context with any previous layer such that complex filtering tasks are straight forward An example below using the Column Filtering Tab to filter the SBA Database on a Site Code that contains the letters ab Export Clearltems Apply Filter Apply Sort Quit Column Filtering Perimeter Filter KML Options Field Mapper Custom Sorter Field Names Clause Values 1 Values2 Operator Site Code Contains ab s h Roll Your Own Ex gt TX_Call Sign KAB87 Filter Site Code LIKE ab SDL Network Viewer R1_27 Manual By clicking Apply Filter the result of this filter would be to display only those values in the database that fit the filter criteria Notice that the complete Filter Expression is shown at the bottom of the FilterPalette As the user gets more proficient using the filter capabilities the built in features may become too restrictive At that point the user can build the Filter Expression precisely as required and then enter it into the Roll Your Own text box This allows for ANY expression that can be defined to be expressed so that the six layers provided for manually building a filter do not become a restriction For most users this will never be a problem as six layers are enough for almost all applications Using the Roll Your Own text box requires that the Filter Expression be inserted into it
33. loads will be displayed Highlight the folder and select OK The SDL Network Viewer will now start the download process The user will note at the bottom left corner of the Database Viewer the SDL Network Viewer creates a Status Strip and bar indicating it is downloading the chosen database Once the database has completed loading the Status Strip bar will be filled in completely The download process concludes with a short message indicating the database has been downloaded and how much time was used to conduct the transaction At this point the SBA Communications Corporation Database is ready for importing The folder created above is used as the reference location when doing an SBA Communications Corporation Database import SDL Network Viewer R1_27 Manual Imports All the databases can be imported to the Database Viewer American Tower Database ASR Database SBA Database MW Paths Database Link List FC Report Generic Path List ULS Query and ULS MW Apps Import ASR Master Importing the ASR Database requires that it already be downloaded Select the ASR Database from the Imports Option located in the Main Menu and the user will be provided with a Browse for Folder prompt Select the folder of the ASR Database for import and then select OK Once the folder is selected the SDL Network Viewer database engine takes over and creates the appropriate queries by which to import the data Note the Status Strip display in the
34. lower left hand corner of the Database Viewer It displays the current database being imported The ASR Database is called a Standard Database in the terminology of this tool in that its column structure is predefined Once the query has executed the data is then populated into the Database Viewer which looks like an ordinary spreadsheet The user can immediately start to surf the columns and rows using the Database Viewer sliders as appropriate Additionally the column can be sorted at this point by simply clicking in the column header It is recommended that the user get acquainted with the column structure and the size of the database that has been imported as this information is useful when using the FilterPalette The column structure for the ASR Database is as follows ASR Structure Status Unique System Identifier Height AGL w o app feet Height AGL w app feet Ground Level amsl feet Structure Site Address Structure City Structure State Filer Title Owner Corp Owner Name Owner Attention Owner Email Owner Address Owner PO Box Owner City Owner State Owner Zip Rep Corp Rep Name Rep Attention SDL Network Viewer R1_27 Manual Rep Email Rep Address Rep PO Box Rep City Rep State Rep Zip Latitude Dec Degrees Longitude Dec Degrees The number of rows imported is shown in the Status Strip at the bottom of the Database Viewer when import completed The Database Viewer can be resized as necessary t
35. n Number TX_Structure Type TX_Height of Support Structure TX_Overall Height of Structure TX_Height to Center RAAT RX_Site Status RX_Location Address RX_Location City RX_Location County Borough Parish RX_Location State RX_Ground Elevation RX Lat Dec Degrees RX Long Dec Degrees RX_Tower Registration Number RX_Structure Type RX_Height of Support Structure RX_Overall Height of Structure RX Height to Center RAAT TX_Antenna Make TX Antenna Model RX_Antenna Make RX_Antenna Model Transmitter Make Transmitter Model The number of rows imported is shown in the Status Strip at the bottom of the Database Viewer when import completed The Database Viewer can be resized as necessary to accommodate various screen sizes The number of rows is a useful metric when the database is manipulated in follow on tasks as it always represents the number of rows that are currently in the Database Viewer This number obviously changes as the user selects different filter criteria A short message is displayed after the import informs the user of how much time the import process has taken Large standard databases such as the ASR Database and the MW Paths Database will take longer importing than the smaller standard databases such as the SBA Communications Database and American Tower Database Import Link List Importing the Link List database requires that the database already be downloaded or otherwise built Select the Link List Database from t
36. ns that apply to sites or paths but the user can tailor the balloon contents as required The Database Type can either be Sites Only or Sites and Paths The selector for this option is located in the Field Mapper Tab Depending on the type of database some of the selection criteria may be disabled so that only those selections that are applicable can be defined Once the user has completed the filtering process click Apply Filter and the results will be displayed in the Database Viewer Related Topics Field Mapper Field Mapper SDL Network Viewer R1_27 Manual 2 Filtering and KML Palette Option Export Clearltems Apply Filter ApplySort Quit Column Fitering Perimeter Fiter KML Options Field Mapper Custom Sorter Field Names The FilterPalette Option is located in the Main Menu Once you have a database imported to the Database Viewer click on the FilterPalette Option The Field Mapper Tab allows for the Database Type to be specified as either Sites Only or Sites and Paths This determination disables other selector fields as necessary Additionally a KML Template may be specified if using a Generic Path List Database This feature allows for field mapping similar to a known Standard Database when dealing with generic path lists A future feature will allow for specific field mappings to be saved and recalled using a named string for the reference Finally Site A and Site B or TX and RX Site d
37. o accommodate various screen sizes The number of rows is a useful metric when the database is manipulated in follow on tasks as it always represents the number of rows that are currently in the Database Viewer This number obviously changes as the user selects different filter criteria A short message is displayed after the import informs the user of how much time the import process has taken Large standard databases such as the ASR Database and the MW Paths Database will take longer importing than the smaller standard databases such as the SBA Database and American Tower Database Import American Tower Database Importing the American Tower Database requires that it already be downloaded Select the American Tower Database from the Imports Option located in the Main Menu and the user will be provided with a Browse for Folder prompt Select the folder of the American Tower Database for import by highlighting and then select OK Once the folder is selected the SDL Network Viewer database engine takes over and creates the appropriate queries by which to import the data Note the Status strip display in the lower left hand corner of the Database Viewer It displays the current database being imported The American Tower Database is called a Standard Database in the terminology of this tool in that its column structure is predefined Once the query has executed the data is then populated into the Database Viewer which looks like an ordinar
38. of the product but each subsequent launch will not require you to resubmit your serial number The serial number will be tied to a Hardware ID thus allowing usage on one machine per serial number Once the user has successfully installed the software the user can now open the SDL Network Viewer and the Main Menu Tool Bar will be displayed Five options are available through the Main Menu which are Imports Downloads FilterPalette Help and Exit All of the four databases shown below have to be downloaded through the Downloads Option FCC Part 101 MW Paths FCC Antenna Structure Registrations SBA Communications Company American Tower Site List Other databases are also available through the Imports Option and include Link List Frequency Coordination Reports Generic Link Lists ULS Query ULS MW Apps Main Menu Main Menu Options The SDL Network Viewer contains several options that allow the user to download import filter and export their databases The standard databases are American Tower Site List American Tower FCC Antenna Structure Registrations ASR SBA Communications Company SBA FCC Part 101 MW Paths MW Paths Each database has it s own download option from the Main Menu This option automatically downloads the database file unzips if necessary and builds a schema file where required The Imports Option from the Main Menu allows the user to select the database they want to import into the S
39. ower database to be downloaded A drop down box labeled Browse For Folder will be displayed in the Database Viewer When creating a new download the user will need to create a New Folder location to store the contents as listed above Any previously created downloads will be displayed Highlight the folder and select OR The SDL Network Viewer will now start the download process The user will note at the bottom left corner of the Database Viewer the SDL Network Viewer creates a Status Strip and bar indicating it is downloading the chosen database Once the database has completed loading the Status Strip bar will be filled in completely The download process concludes with a short message indicating the database has been downloaded and how much time was used to conduct the transaction At this point the American Tower database is ready for importing The folder created above is used as the reference location when doing an American Tower Database import SBA Properties The SBA Communications Corporation Database is downloaded from the following location http www sbasite com The download results in a single Excel file called SBA Sites xlsx From the Main Menu select the SBA Database to be downloaded A drop down box labeled Browse For Folder will be displayed in the Database Viewer When creating a new download the user will need to create a New Folder location to store the contents as listed above Any previously created down
40. roll to the top of the list click on the blank highlight it click the Sort Level to replace with spaces When the sort criteria has been specified then the Custom Sorter Tab option can be invoked by clicking Apply Sort SDL Network Viewer R1_27 Manual Exit The Exit Option located in the Main Menu shuts the program down by deleting all existing viewers filters and sorts and then quits the SDL Network Viewer SDL Network Viewer R1_27 Manual Help Imports Downloads FilterPalette Help Exit Qe tion S ea a e se LD ELL About Release Notes Introduction Download Column Filter Datab The Help Option is located in the Main Menu of the SDL Network Viewer Help Selection displays the user manual and describes in detail all aspects of the SDL Network Viewer About Selection displays the current release of Spacial Datalyst that is being used Release Notes Selection displays all releases and their content Activate License Selection displays an Activate box whereby the user will input the activation code and have it verified Help SDL Network Viewer R1_27 Manual E SDLNetworkViewer2 SO Gg Hide Back Forward Home Print Options Contents aon About Support Order Getting Started The SDL Network Viewer offers today s modern network designer a new tool to expedi Tutorial Relational Database techniques and publicly available database the SDL Network Vie Downloads and or per path
41. such as the SBA Database and American Tower Database Import SBA Database Importing the SBA Communications Database requires that it already be downloaded Select the SBA Communications Database from the Imports Option located in the Main Menu and the user will be provided with a Browse for Folder prompt Select the folder of the SBA Communications Database for import by highlighting and then select OK Once the folder is selected the SDL Network Viewer database engine takes over and creates the appropriate queries by which to import the data Note the Status Strip display in the lower left hand corner of the Database Viewer It displays the current database being imported The SBA Communications Database is called a Standard Database in the terminology of this tool in that its column structure is predefined Once the query has executed the data is then populated into the Database Viewer which looks like an ordinary spreadsheet The user can immediately start to surf the columns and rows using the Database Viewer sliders as appropriate Additionally the column can be sorted at this point by simply clicking in the column header It is recommended that the user get acquainted with the column structure and the size of the database that has been imported as this information is useful when using the FilterPalette The column structure for the SBA Communications Database is as follows Site Code Site Name Latitude Longitude City State
42. t p2 dat PA dat RC dat SC dat GE dat GG dat tp dat These files are renamed and a schema file is also built that tells the database engine how the files are organized From the Main Menu select the MW Paths database to be downloaded A drop down box labeled Browse For Folder will be displayed in the Database Viewer When creating a new download the user will need to create a New Folder location to store the contents as listed above Any previously created downloads will be displayed Highlight the folder and select OK The SDL Network Viewer will now start the download process The user will note at the bottom left corner of the Database Viewer the SDL Network Viewer creates a Status Strip and bar indicating it is downloading the chosen database Once the database has completed loading the Status Strip bar will be filled in completely The download process concludes with a short message indicating the database has been downloaded and how much time was used to conduct the transaction At this point the MW Paths Database is ready for importing The folder created above is used as the reference location when doing an MW Paths Database import SDL Network Viewer R1_27 Manual American Tower Database The American Tower Database is downloaded from the following location http www americantower com corporateus The download results in a single Excel file called NationalSiteList xls From the Main Menu select the American T
43. this time SDL Network Viewer R1_27 Manual Generally the CSV files and the KML files are all that is required to interface to other path manipulation software database programs and spreadsheet programs Export to KML Export Clearltems Apply Filter Apply Sort Quit Export to CSV Export to Pipe Export to KML The export to a KML file is available through the FilterPalette found in the Main Menu of the SDL Network Viewer The Export to KML file is a Google Earth Keyhole Markup Language compatible file The SDL Network Viewer export engine formats the file so that latitude longitude and site elevation are tagged as needed to make the KML file display properly The FilterPalette is used to define those fields that the operator wants to have displayed in either the Site Balloon or the Path Balloon objects SDL Network Viewer R1_27 Manual FilterPalette The FilterPalette Option is located in the Main Menu of the SDL Database Viewer Once the user has a database imported the FilterPalette will be used to filter sort and export by executing the following Filter Tabs Column Filtering Perimeter Filtering KML Options Field Mapper Custom Sorter Column Filtering The FilterPalette Option is located in the Main Menu of the SDL Network Viewer Once you have a database imported to the Database Viewer click on the FilterPalette Option The Column Filtering Tab is a six deep filter that allows for any combination of Fi
44. y spreadsheet The user can immediately start to surf the columns and rows using the Database Viewer sliders as appropriate Additionally the column can be sorted at this point by simply clicking in the column header It is recommended that the user get acquainted with the column structure and the size of the database that has been imported as this information is useful when using the FilterPalette The column structure for the American Tower Database is as follows Asset Number Former GTP Asset Name Asset Class Structure Type Structure Height AGL Ground Elevation AMSL Clearance Total Height AMSL FCC FAA Backup Power Address City SDL Network Viewer R1_27 Manual County State Zip Code BTA MTA Area Latitude Longitude The number of rows imported is shown in the Status Strip at the bottom of the Database Viewer when import completed The Database Viewer can be resized as necessary to accommodate various screen sizes The number of rows is a useful metric when the database is manipulated in follow on tasks as it always represents the number of rows that are currently in the Database Viewer This number obviously changes as the user selects different filter criteria A short message is displayed after the import informs the user of how much time the import process has taken Large standard databases such as the ASR Database and the MW Paths Database will take longer importing than the smaller standard databases
45. ys the current database being imported The MW Paths Database is called a Standard Database in the terminology of this tool in that its column structure is predefined Once the query has executed the data is then populated into the Database Viewer which looks like an ordinary spreadsheet The user can immediately start to surf the columns and rows using the Database Viewer sliders as appropriate Additionally the column can be sorted at this point by simply clicking in the column header To import the MW Paths database the user will go to the Imports Option select the MW Paths Database and a MW Paths Import Type box will be displayed The MW Paths Database is very large and a lot of memory is consumed therefore it is necessary to have two imports hardware and entity This box allows the user to select either Type 1 for Hardware or Type Il for Entity Once the Import Type is selected the user will select GO and then the user will import the MW Paths Database previously downloaded When the import is loaded the Database Viewer will indicate which Import Type you have selected to import your data It is recommended that the user get acquainted with the column structure and the size of the database that has been imported as this information is useful when using the FilterPalette The column structure for the MW Paths Database is as follows Type I Field Names Hardware Licensee Name Contact Licensee Name FCC Registration Number FRN TX_

SDL Network Viewer Version R1_27 User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents