Hi again,
Let me give you some ideas.
Opening a Basemap
Let us start by opening a base map to give your data some context. From the
Open control on the
Home tab, select one of the base maps.
I will open the
Hybrid base map which will open Bing Hybrid with aerial imagery overlayed with streets and area names.
I'll use the
Zoom In tool to zoom to my area of interest. You can also wait, and use the extent of the data file you are loading in the next step to control the extent of the map.
Loading the Data File
The next step is to open your file into MapInfo Pro. From the
Home tab, click on the
Open Table control.
In the
Open dialog change the file type to
Microsoft Excel (*.xls, *.xlsx) from the
Files of Type list. Now browse to the folder where your data file exists and select it.
If you need to edit your data in MapInfo, or if you have a large dataset, it's recommended to save the data file into a native tab format. To do so, check the option
Create copy in MapInfo format for read/write. This will automatically create a copy of the data in a native tab file in the same folder as your data file, and open this copy.
As I chose to open a Microsoft Excel file, I will be presented with a few configuration options.
In the dialog
Excel Information, I will have to select the
Named Rage to open. This will typical refer to a specific sheet in your Microsoft Excel file. Below you can see I have selected
InputData as my sheet.
As I know that the first column in my sheet holds columns names, I check the option
Use Row Above Selected Range for Column Titles.
In the dialog
Set Field Properties, I can rename the columns and change the
Column Types. One thing to pay attention to is that
Integer columns typically are seen as
Float columns. You can in this dialog force MapInfo Pro to load the columns as Integers as you can see I have set for the column
HouseNo. You will of course need to know your data as some Float columns do hold floating values, such as coordinates or lat/long values.
Hit OK to load your data into MapInfo Pro.
At this stage, MapInfo Pro doesn't yet recognize any spatial information in your data. Therefore the data is shown in a browser window.
Mapping the Data
Now you have to tell MapInfo Pro how your data can be mapped. In our example, you have coordinate values in two columns. You can use these to create points for your data.
From the
Spatial tab, select
Create Points from the
Create control in the
Create group. If you have problems locating some of the features, you can use
the Quick Search control to locate them.
In the dialog Create Points, select your data file as input. Then make sure that the coordinate system matches the coordinate system of your coordinate values.
In the
Add to Map section select
Current Mapper and select your map from the dropdown if it isn't preselected. You can also select a symbol you want to use for your points.
Finally, you need to select the columns holdings your coordinate values. Once done, hit OK to create points for your data.
I hope this helps you get your points visualized on a map. From here there are multiple other things you can do to better understand your data.
You can create a theme based on some categorial values assigned to your data points.
You can create a standard heatmap to understand where the density of your data points is high.
I hope this helps
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------
Original Message:
Sent: 08-23-2021 08:18
From: Peter Horsbøll Møller
Subject: Hotspotting in Map Info Pro v17
Hi Rosemary
Thanks for reaching out.
Can you explain a bit more about the data you currently have that you want to show in MapInfo Pro?
Is it CSV or Excel files holding lat/long values along side other values?
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
Original Message:
Sent: 08-23-2021 05:46
From: Rosemary Amy
Subject: Hotspotting in Map Info Pro v17
Good Morning,
I am new to Map Info Pro v17 and an absolute Technodinosaur. Reading the manual is far to technical and when I have searched for youtube videos, they go so fast.
What I have to do is plot some Latitude and Longitude grids onto a map, to show me where my hotspots are. Can someone explain in simple terms. how to do this?
Your time and help in this is greatly appreciated.
Kind Regards
Rosemary
------------------------------
Rosemary Amy
Knowledge Community Shared Account
------------------------------