New answers tagged

0

It looks like you are working with MapInfo. The "Distance Calculator" (find it in tool manager) has many options and I think it can handle this task too. There is an article about it here: http://web.pb.com/mapinfopro-jul-2013/Toolbox-Distance-Calculator


4

Using PostGIS, I used ST_ConvexHull to simplify the polygon for a faster result: Get the furthest Point: SELECT ST_PointN(ST_ExteriorRing(ST_ConvexHull(the_geom)),Generate_Series(1, ST_NPoints(ST_ExteriorRing(ST_ConvexHull(the_geom))))) as FarPoint FROM PolyTable; And if you are interested in creating a Circle from the centroid: SELECT ST_Buffer(Center,...


0

You can use the Update Column function in MapInfo Pro to do this. Table to Update: DBMS_Table Column to Update: Get Value From Table: Polygon_Table Calculate: Value of: Click on the Join button to specify how to join the two tables. Select the option "where object from table DBMS_table is within objects from table Polygon_Table". Repeat this for ...


1

You will need to do two queries. In the first one: Same as yours, but remove "(Rowid<=100) And" Then, secondly, query the 'Selection' table to show where Rowid<=100


0

Take a look at the Distance Calculator tool (under Tool Manager). You can use it to identify the nearest rail line to each geocoded data point you've got and output a unique ID from each table. You might get something like this: +---------+--------+----------+ | PointID | RailID | Distance | +---------+--------+----------+ | 1 | 2 | 1.8 | +--...


0

As I stated in a comment above, removing all layers from a map window, will eventually close the map. It might be faster just to close the map window: nMapWinID = FrontWindow() 'make sure the map window is at the front before running this Close Window nMapWinID Now the map window has been closed and you can create a new one. By the way, you can have more ...


0

What you need to do is loop through the layers of the map window and remove them individually from the mapper window. This way they are not closed, just removed from the map. e.g. Dim nLayers, i, nMapWinID as Integer nMapWinID = FrontWindow() '// make sure the map window is at the front before running this nLayers = MapperInfo(nMapWinID, ...


2

And if you prefer a statement for your MapBasic window: Set CoordSys Table MYTABLE Update MYTABLE Set MIN_X = ObjectGeography(OBJ, 1) , MIN_Y = ObjectGeography(OBJ, 2) , MAX_X = ObjectGeography(OBJ, 3) , MAX_Y = ObjectGeography(OBJ, 4) The first statement asks MapInfo Pro to use the coordinate system of the table when extracting ...


3

Add 4 float columns to your table titled something like X1, Y1, X2, Y2. Then using Table > Update Column enter the following: Update table: YourTable Column to update: X1 Get value from table: YourTable Value: ObjectGeography(obj, 1) Click OK. This will update the X1 column with the minimum X value. For Y1 change the column to update to Y1 and the Value ...


1

Just realised that it's simply the same process as in older mapinfo versions ... so Sum(ObjectLen(obj,"m"))"Length_m" Thanks to http://web.pb.com/mapinfopro-oct-2013/Query-Ninja-Calculating-Line-Objects-Length/?webSyncID=46d43e17-2562-4890-a3d6-aae32714dc02


0

I'm assuming that a locality object is only covered by one pincode object, right? You can do this in three steps: Add a column to hold the pincode to the locality table Use SQL Select to join the two tables Update the locality layer using the join query result Let's try: First you need to add a column for the pincode to the Locality table Next we are ...


1

MapCAD has such a tool. If you are using MapInfo Pro 15.0 (the 32bit version), you can find the tool on the Objects toolbar. If you are using MapInfo Pro 15.2 (the 64bit version), you can find the tool in the Modify control on the SPATIAL tab.


0

I'm assuming your habitats are regions, too. In that case you might need to split the habitat regions with your admin regions in order to get the exact area within each region. The good thing is that you can do all this in a single SQL Select statement: Select ADMIN_NAME, Sum(CartesianArea(Overlap(ADMIN.obj, HABITATS.obj), "hectare")) "Summed_Areas_Ha" ...


1

AGD 66 Zone 55 Datum is a projected UTM coordinate system. The geographic spheroid for this datum is Australian_1966. Normally helicopters will use WGS-84 datum read from the GPS sensors. The format they would prefer would be decimal minutes. i.e. Lat dd mm.mmm S Long ddd mm.mmm E where dd is degrees mm.mmm is decimal minutes You will need to set your map ...


0

It's the "Autoscroll" option that controls whether the map pans if you move the cursor "outside" the window while drawing or measuring. You do however seem to have "Autoscroll" enabled. Another thing that can prevent it, is if the border of your map window is outside the application area of MapInfo Pro, as you see here: You can fix that by scrolling the ...


1

Yes, there is an option to add 'Hotlinks' to objects and/or labels in MapInfo. You can point the hotlink to a field in the data containing the relevant filepath/url, then using the Hotlink tool you can click on any map object containing a Hotlink and it will launch the file/url with the appropriate application. You can read more about it in a section of the ...


3

To create a point from CSV file in MapInfo, you need to do the following: Go to File -> Open Change the format of the file from (tab) to (csv) Select the CSV file that you want. This procedure will open CSV file as table not point. To plot the X,Y as point, go to Table -> Create Points Select the field that represents X coordinate and the field the ...



Top 50 recent answers are included