MapInfo Pro

I have started creating an add-in for MapInfo Pro dedicated to the use case around telco.

I have started small but want to add more as needed. Eventually, I'll get the tool loaded into the MapInfo Marketplace for easy access.

The current version, 1.0.0, has these capabilities:

• Create Sectors: Allows you to create sector cells from a point (or lat/long values), a direction, and a horizontal width.

• Update Bearing: Calculate the bearing between the first and last point of a (poly)line. 

• Nearest Cells: Finds the nearest cell for all the cells in the table. The direction of the cell is taken into account. You can specify a maximum search distance to avoid searching across the country.

• TTLineDirection: Calculates the direction of a polyline, East is zero, counter-clockwise
• TTLineBearing: Calculates the bearing of a long/lat polyline, North is zero, clockwise
• TTCreateTrapez: Creates a trapez using a starting point, direction, length, width at start and end, optional midpoint creation and calculation method (1=Cart, 2=Spher
• TTCreateTriangle: Creates a triangle using a starting point, direction, length, width, optional midpoint creation and calculation method (1=Cart, 2=Spher)
• TTRemoveDuplicateNodes: Removed duplicate nodes from the input object using the given tolerance in meters
  TTCreateSector: Create a sector using a point, direction, and one radius.
• TTCreateSectorRing: Create a sector ring using a point, direction, and two radii.
• TTCartesianCreateArrow: Create an arrow from a polyline, giving size and end types.
• TTNorth2MathAngle: Converts a North angle to a Math angle.
• TTMath2NorthAngle: Converts a Math angle to a North angle.
• TTGetDirection: Returns the directions between two coordinate pairs as a Math angle.
• TTGetBearing: Returns the bearing between two long/lat pairs as a North angle.

Documentation hasn't been created yet.

I have a few other things I'd like to add to this first release:

• Shortcut to scripts and queries: This would allow users to place buttons on the Telco tab that execute scripts and SQL statements.
• The above would come with a few scripts out of the box for loading files and creating sectors, loading files and creating sectors with an offset, and loading files and creating rings. These examples have been discussed earlier in a few #MapInfoMonday posts.

Feel free to download the current version of the tool and give it a spin. Download and unzip the file. The attached version of the tool runs in debug mode, meaning it writes out a lot of details to the Message window.

The source code for the tool will be shared on GitHub.

I would love your feedback and ideas on other features to include in the tool moving forward.

Thanks Peter, is very helpful tool

Is their a chance to add one more function to this tool,

It is very helpful in Telco tool, to be able to display Neighbor Relations between sites

something, similar to below image

Expectation, there is a section to enter Source Cell Name

Then the tool draw a line between Source Cell to Neighbors (Destination cells)

With the ability to delete or add any of these relation lines

I have started creating an add-in for MapInfo Pro dedicated to the use case around telco.

I have started small but want to add more as needed. Eventually, I'll get the tool loaded into the MapInfo Marketplace for easy access.

The current version, 1.0.0, has these capabilities:

• Create Sectors: Allows you to create sector cells from a point (or lat/long values), a direction, and a horizontal width.

• Update Bearing: Calculate the bearing between the first and last point of a (poly)line. 

• Nearest Cells: Finds the nearest cell for all the cells in the table. The direction of the cell is taken into account. You can specify a maximum search distance to avoid searching across the country.

• TTLineDirection: Calculates the direction of a polyline, East is zero, counter-clockwise
• TTLineBearing: Calculates the bearing of a long/lat polyline, North is zero, clockwise
• TTCreateTrapez: Creates a trapez using a starting point, direction, length, width at start and end, optional midpoint creation and calculation method (1=Cart, 2=Spher
• TTCreateTriangle: Creates a triangle using a starting point, direction, length, width, optional midpoint creation and calculation method (1=Cart, 2=Spher)
• TTRemoveDuplicateNodes: Removed duplicate nodes from the input object using the given tolerance in meters
  TTCreateSector: Create a sector using a point, direction, and one radius.
• TTCreateSectorRing: Create a sector ring using a point, direction, and two radii.
• TTCartesianCreateArrow: Create an arrow from a polyline, giving size and end types.
• TTNorth2MathAngle: Converts a North angle to a Math angle.
• TTMath2NorthAngle: Converts a Math angle to a North angle.
• TTGetDirection: Returns the directions between two coordinate pairs as a Math angle.
• TTGetBearing: Returns the bearing between two long/lat pairs as a North angle.

Documentation hasn't been created yet.

I have a few other things I'd like to add to this first release:

• Shortcut to scripts and queries: This would allow users to place buttons on the Telco tab that execute scripts and SQL statements.
• The above would come with a few scripts out of the box for loading files and creating sectors, loading files and creating sectors with an offset, and loading files and creating rings. These examples have been discussed earlier in a few #MapInfoMonday posts.

Feel free to download the current version of the tool and give it a spin. Download and unzip the file. The attached version of the tool runs in debug mode, meaning it writes out a lot of details to the Message window.

The source code for the tool will be shared on GitHub.

I would love your feedback and ideas on other features to include in the tool moving forward.

Thanks for reaching out, H.H.

I probably need a bit more detail on the 'Neighbor Relations' you mentioned above.

How is this different from the 'Find Nearest Cells' feature that can already be found in the tool?

Thanks Peter, is very helpful tool

Is their a chance to add one more function to this tool,

It is very helpful in Telco tool, to be able to display Neighbor Relations between sites

something, similar to below image

Expectation, there is a section to enter Source Cell Name

Then the tool draw a line between Source Cell to Neighbors (Destination cells)

With the ability to delete or add any of these relation lines

I have started creating an add-in for MapInfo Pro dedicated to the use case around telco.

I have started small but want to add more as needed. Eventually, I'll get the tool loaded into the MapInfo Marketplace for easy access.

The current version, 1.0.0, has these capabilities:

• Create Sectors: Allows you to create sector cells from a point (or lat/long values), a direction, and a horizontal width.

• Update Bearing: Calculate the bearing between the first and last point of a (poly)line. 

• Nearest Cells: Finds the nearest cell for all the cells in the table. The direction of the cell is taken into account. You can specify a maximum search distance to avoid searching across the country.

• TTLineDirection: Calculates the direction of a polyline, East is zero, counter-clockwise
• TTLineBearing: Calculates the bearing of a long/lat polyline, North is zero, clockwise
• TTCreateTrapez: Creates a trapez using a starting point, direction, length, width at start and end, optional midpoint creation and calculation method (1=Cart, 2=Spher
• TTCreateTriangle: Creates a triangle using a starting point, direction, length, width, optional midpoint creation and calculation method (1=Cart, 2=Spher)
• TTRemoveDuplicateNodes: Removed duplicate nodes from the input object using the given tolerance in meters
  TTCreateSector: Create a sector using a point, direction, and one radius.
• TTCreateSectorRing: Create a sector ring using a point, direction, and two radii.
• TTCartesianCreateArrow: Create an arrow from a polyline, giving size and end types.
• TTNorth2MathAngle: Converts a North angle to a Math angle.
• TTMath2NorthAngle: Converts a Math angle to a North angle.
• TTGetDirection: Returns the directions between two coordinate pairs as a Math angle.
• TTGetBearing: Returns the bearing between two long/lat pairs as a North angle.

Documentation hasn't been created yet.

I have a few other things I'd like to add to this first release:

• Shortcut to scripts and queries: This would allow users to place buttons on the Telco tab that execute scripts and SQL statements.
• The above would come with a few scripts out of the box for loading files and creating sectors, loading files and creating sectors with an offset, and loading files and creating rings. These examples have been discussed earlier in a few #MapInfoMonday posts.

Feel free to download the current version of the tool and give it a spin. Download and unzip the file. The attached version of the tool runs in debug mode, meaning it writes out a lot of details to the Message window.

The source code for the tool will be shared on GitHub.

I would love your feedback and ideas on other features to include in the tool moving forward.

Difference is that neighbor relations is depend on network configuration that's done by Engineers or Automatic algorithm

and normally each cell can have big number of relations like more than 32

*having the ability to display it on the map, is very helpful as sometimes network configuration miss important relations to the closest neighbor sites

Thanks for reaching out, H.H.

I probably need a bit more detail on the 'Neighbor Relations' you mentioned above.

How is this different from the 'Find Nearest Cells' feature that can already be found in the tool?

Thanks Peter, is very helpful tool

Is their a chance to add one more function to this tool,

It is very helpful in Telco tool, to be able to display Neighbor Relations between sites

something, similar to below image

Expectation, there is a section to enter Source Cell Name

Then the tool draw a line between Source Cell to Neighbors (Destination cells)

With the ability to delete or add any of these relation lines

I have started creating an add-in for MapInfo Pro dedicated to the use case around telco.

I have started small but want to add more as needed. Eventually, I'll get the tool loaded into the MapInfo Marketplace for easy access.

The current version, 1.0.0, has these capabilities:

• Create Sectors: Allows you to create sector cells from a point (or lat/long values), a direction, and a horizontal width.

• Update Bearing: Calculate the bearing between the first and last point of a (poly)line. 

• Nearest Cells: Finds the nearest cell for all the cells in the table. The direction of the cell is taken into account. You can specify a maximum search distance to avoid searching across the country.

• TTLineDirection: Calculates the direction of a polyline, East is zero, counter-clockwise
• TTLineBearing: Calculates the bearing of a long/lat polyline, North is zero, clockwise
• TTCreateTrapez: Creates a trapez using a starting point, direction, length, width at start and end, optional midpoint creation and calculation method (1=Cart, 2=Spher
• TTCreateTriangle: Creates a triangle using a starting point, direction, length, width, optional midpoint creation and calculation method (1=Cart, 2=Spher)
• TTRemoveDuplicateNodes: Removed duplicate nodes from the input object using the given tolerance in meters
  TTCreateSector: Create a sector using a point, direction, and one radius.
• TTCreateSectorRing: Create a sector ring using a point, direction, and two radii.
• TTCartesianCreateArrow: Create an arrow from a polyline, giving size and end types.
• TTNorth2MathAngle: Converts a North angle to a Math angle.
• TTMath2NorthAngle: Converts a Math angle to a North angle.
• TTGetDirection: Returns the directions between two coordinate pairs as a Math angle.
• TTGetBearing: Returns the bearing between two long/lat pairs as a North angle.

Documentation hasn't been created yet.

I have a few other things I'd like to add to this first release:

• Shortcut to scripts and queries: This would allow users to place buttons on the Telco tab that execute scripts and SQL statements.
• The above would come with a few scripts out of the box for loading files and creating sectors, loading files and creating sectors with an offset, and loading files and creating rings. These examples have been discussed earlier in a few #MapInfoMonday posts.

Feel free to download the current version of the tool and give it a spin. Download and unzip the file. The attached version of the tool runs in debug mode, meaning it writes out a lot of details to the Message window.

The source code for the tool will be shared on GitHub.

I would love your feedback and ideas on other features to include in the tool moving forward.

I assume you have another table that holds the neighbor relations, right?

A table with a source site ID column and a neighbor Site ID column. From this, we could create a new table linking all the relations and creating a line for each relation.

Difference is that neighbor relations is depend on network configuration that's done by Engineers or Automatic algorithm

and normally each cell can have big number of relations like more than 32

*having the ability to display it on the map, is very helpful as sometimes network configuration miss important relations to the closest neighbor sites

Thanks for reaching out, H.H.

I probably need a bit more detail on the 'Neighbor Relations' you mentioned above.

How is this different from the 'Find Nearest Cells' feature that can already be found in the tool?

Thanks Peter, is very helpful tool

Is their a chance to add one more function to this tool,

It is very helpful in Telco tool, to be able to display Neighbor Relations between sites

something, similar to below image

Expectation, there is a section to enter Source Cell Name

Then the tool draw a line between Source Cell to Neighbors (Destination cells)

With the ability to delete or add any of these relation lines

I have started creating an add-in for MapInfo Pro dedicated to the use case around telco.

I have started small but want to add more as needed. Eventually, I'll get the tool loaded into the MapInfo Marketplace for easy access.

The current version, 1.0.0, has these capabilities:

• Create Sectors: Allows you to create sector cells from a point (or lat/long values), a direction, and a horizontal width.

• Update Bearing: Calculate the bearing between the first and last point of a (poly)line. 

• Nearest Cells: Finds the nearest cell for all the cells in the table. The direction of the cell is taken into account. You can specify a maximum search distance to avoid searching across the country.

• TTLineDirection: Calculates the direction of a polyline, East is zero, counter-clockwise
• TTLineBearing: Calculates the bearing of a long/lat polyline, North is zero, clockwise
• TTCreateTrapez: Creates a trapez using a starting point, direction, length, width at start and end, optional midpoint creation and calculation method (1=Cart, 2=Spher
• TTCreateTriangle: Creates a triangle using a starting point, direction, length, width, optional midpoint creation and calculation method (1=Cart, 2=Spher)
• TTRemoveDuplicateNodes: Removed duplicate nodes from the input object using the given tolerance in meters
  TTCreateSector: Create a sector using a point, direction, and one radius.
• TTCreateSectorRing: Create a sector ring using a point, direction, and two radii.
• TTCartesianCreateArrow: Create an arrow from a polyline, giving size and end types.
• TTNorth2MathAngle: Converts a North angle to a Math angle.
• TTMath2NorthAngle: Converts a Math angle to a North angle.
• TTGetDirection: Returns the directions between two coordinate pairs as a Math angle.
• TTGetBearing: Returns the bearing between two long/lat pairs as a North angle.

Documentation hasn't been created yet.

I have a few other things I'd like to add to this first release:

• Shortcut to scripts and queries: This would allow users to place buttons on the Telco tab that execute scripts and SQL statements.
• The above would come with a few scripts out of the box for loading files and creating sectors, loading files and creating sectors with an offset, and loading files and creating rings. These examples have been discussed earlier in a few #MapInfoMonday posts.

Feel free to download the current version of the tool and give it a spin. Download and unzip the file. The attached version of the tool runs in debug mode, meaning it writes out a lot of details to the Message window.

The source code for the tool will be shared on GitHub.

I would love your feedback and ideas on other features to include in the tool moving forward.