#Mapinfo basic tutorial how to
OK, let’s back now i will show you how to add Mapinfo Extension in Mapinfo.
#Mapinfo basic tutorial windows
Posted in mapinfo | Tagged File Management, File Managers, Mapinfo, Menu bar, Shareware, Tab key, Utilities, Windows | Leave a comment Set Get X Coordinate from Column Longitude and Get Y Coordinate from Column Latitude then using Symbol circle with red colour then click OK and the step and result will be like this :Ĭongrats ! our lesson about how to create site BTS Point in Mapinfo is succeeding inplemented to mapinfo application, you can see the menu bar will like above picture □ Now change your worksheet to the map and go to open menu : Table > Create Points and we will see pop up window about the setting of create point. Here the screenshot of bts_sample file in mapinfo : OK, if it’s right, go to Mapinfo and open your map file that you have created before in LESSON-5 then open the bts_sample excel file also, so you have two windows : the map and the bts_sample. Open that file and you will see the header column is : Longitude
#Mapinfo basic tutorial download
Please download the sample excel file of Site BTS 2G and 3G with longitude and latitude. For this lesson i will choose a Site BTS for example.
Let’s back to our computer guys, i will show you how to create a point based on longitude and latitude. Posted in mapinfo | Tagged Antennas, Base transceiver station, Degree (angle), Mapinfo, Mobile phone, Pop-up ad, Sector antenna, Wi-Fi | Leave a comment Set the window like picture below :Įureka !!!! After you push Make Sector Button it will shows you on a map the BTS sector succeeding to draw like the picture below □ Then from menu tab choose Make Sector > Create Sector and will show pop up windows setting. Open a excel BTS sample file bts_sample_azimuth Then if you already know, here the step : They are used for limited-range distances of around 4 to 5 km”
They are also used for other types of mobile communications, for example in WiFi networks. The largest use of these antennas is as antennas for cell phone base-station sites. 60°, 90° and 120° designs are typical, often with a few degrees ‘extra’ to ensure overlap and mounted in multiples when wider or full-circle coverage is required (see photos below). The word “sector” is used in the geometric sense some portion of the circumference of a circle measured in degrees of arc. “A sector antenna is a type of directional microwave antenna with a sector-shaped radiation pattern.
How to use that extension ?įirst you must know the basic of sector and azimuth in BTS or SITE in telco industry. In that post i have shows you how to add Mapinfo Extension called “ make sectors”. OK, before i start this lesson, please see LESSON-6 about how to add Mapinfo Extension in Mapinfo.
Posted in mapinfo | Tagged Aggregate function, Column, Mapinfo, Menu bar, Order by, Select (SQL), SQL, SQL Query | Leave a comment Order_by_expression : is a reference to a column in the select list – either an exact copy of the select list expression, the alias, a 1-based number indicating the position of the column, or coln where n is a number representing a column. Group_by_expression : is a reference to a column in the select list – either an exact copy of the select list expression, the alias, a 1-based number indicating the position of the column, or coln where n is a number representing a column. Most of the functions in this document can be used in search conditions, but aggregation functions are not supported for this use. Search_condition : is a reference to an expression that results in either true or false. Column names and pseudo columns may be prefixed with a table name or a table alias followed by the dot (“.”) character. Expression : is a column name, pseudo column, column alias, constant, function, or any combination of column names, column aliases, constants, and functions connected by an operator(s).