15 votes

Distance between centroid and farthest point of polygon

Using PostGIS, I used ST_ConvexHull to simplify the polygon for a faster result: Get the furthest Point: SELECT Villages_v4_Trial_region.geom as FarPoint from ( SELECT ST_PointN(ST_ExteriorRing(...
kttii's user avatar
  • 3,630
13 votes

Ogr2ogr: ERROR 1: PROJ: pj_obj_create: Cannot find proj.db

I set the PROJ_LIB environment variable to point to the PROJ.4 data directory (where proj.db lives) and this problem has been solved,hope that is useful to you.
Zzzxs's user avatar
  • 131
11 votes
Accepted

Polyline split at node in QGIS

QGIS can do the same. On the Advance Digitizing Toolbar is the 'Split Features' button: It appears more simple than MapInfo. 1) Make the layer editable 2) Select the 'Split Features' tool 3)...
Knightshound's user avatar
  • 4,430
11 votes
Accepted

Is there a "clone view" functionality in Qgis like in MapInfo

Yes, you can use the Dockable MirrorMap plugin which allows you to create multiple canvas windows: You can download this from the menubar: Plugins > Manage and Install Plugins
Joseph's user avatar
  • 75.7k
11 votes

Ogr2ogr: ERROR 1: PROJ: pj_obj_create: Cannot find proj.db

Check your environment_variable: setx GDAL_DATA "C:\Program Files\GDAL\gdal-data" setx GDAL_DRIVER_PATH "C:\Program Files\GDAL\gdalplugins" setx PROJ_LIB "C:\Program Files\GDAL\projlib" setx ...
 mrHalfer 's user avatar
7 votes
Accepted

Geoprocessing in violated convention environments (Microsoft Windows)

You can circumvent the error of the deep deep folders / file path longer than 255 characters in two ways in Python. One way is to use the win32api and get a short representation of the long filepath. ...
Kersten's user avatar
  • 9,909
7 votes
Accepted

Letters change when saving tab into shp in QGIS

You can use ISO 8859-1 encoding to read Spanish text correctly (along with various other countries).
Joseph's user avatar
  • 75.7k
6 votes
Accepted

Is it possible / wise to work only with .TAB files in QGIS

Tab files should be fine. From GDAL 2.0 onwards features can be updated and modified: http://www.gdal.org/drv_mitab.html Mid/Mif files cannot be updated.
HeikkiVesanto's user avatar
6 votes
Accepted

Migrating from Mapinfo to PostGIS/QGIS and preserving styles?

You will not be able to port MapInfo styles directly to QGIS, mainly because MapInfo styles are per-feature, whereas QGIS styles are rule-based. That said, you can have a go with Nathan Woodrow's ...
Alex Leith's user avatar
  • 13.5k
6 votes
Accepted

Concatenate and sequentially order unique groups of lines using SQL

From the answers in the comments: 1. In order to concatenate unique values with group by clause: group_concat(distinct Locality) Order by: 2. Data ordering (by the data sample link from comment): ...
NettaB's user avatar
  • 1,936
6 votes
Accepted

Subtracting one polygon from another in MapInfo 15

From How to remove overlapping areas from a polygon in MapInfo Pro the procedure seems to be to: Select the region from which the overlapping areas will be removed. Objects > Set Target (32-bit) ...
PolyGeo's user avatar
  • 65.1k
5 votes
Accepted

Spectrum Server Analyst on AWS

Depending on what you need to be exposed to the internet, it might be the easiest just to change the connector port of the Connect Tomcat to 80 in C:\Program Files\Pitney Bowes\SpectrumSpatialAnalyst\...
Mustafa's user avatar
  • 66
5 votes

Polyline split at node in QGIS

Great answer by @Knightshound although I would probably add that if you want to do this manually using the Split Features tool then make sure you enable the snapping options, set a tolerance and snap ...
Joseph's user avatar
  • 75.7k
5 votes
Accepted

Regex expression in mapinfo sql to remove special character

I searched for "mapbasic regex" and found what looks to be what you may need posted in the nyalldawson.net blog: If you’re not familiar with regular expressions, they’re an extremely powerful ...
PolyGeo's user avatar
  • 65.1k
5 votes
Accepted

How to import OS street view data into MapInfo Pro

MapInfo has a tool called seamless table manager, which you can load by going to the tools menu then choosing tool manager. Scroll down and tick the box to load the tool (and put one in the box to ...
ian's user avatar
  • 1,713
5 votes

Cannot open MapInfo created .TAB files in QGIS

Maybe the table is an Extended MapInfo Table build with a 64 bit version of MapInfo Pro? Open the tab file in a text editor and see if it says "Type NATIVE" or "Type NATIVEX" NATIVEX is the new ...
Peter Horsbøll Møller's user avatar
5 votes

Setting fixed scale of map in MapInfo layout?

This is fairly easy to do in MapInfo (works in all versions). Have your layer open in the map/layout window. Right click anywhere on the map and select "Change View" Change your Cartographic Scale to ...
MapInfoNewbie's user avatar
5 votes

Ogr2ogr: ERROR 1: PROJ: pj_obj_create: Cannot find proj.db

Add these commands to your code at the beginning. Your issue will be solved. import os os.environ['PROJ_LIB'] = 'C:\\Users\\Sai kiran\\anaconda3\\envs\\sai\\Library\\share\\proj' os.environ['GDAL_DATA'...
mArk's user avatar
  • 196
5 votes
Accepted

QGIS and Mapinfo reporting different projections for some files

Issue with the latest QGIS, you wont encounter this if you use 3.8 or earlier. I believe it has something to do with the latest version of Proj
MapInfoNewbie's user avatar
4 votes
Accepted

OGR, writing TAB files, and BOUNDS

You will need to install at least GDAL 2.0 and then you can use the OGR Extension with the Layer Creation Options BOUNDS. First install the OGR Extension http://docs.geoserver.org/stable/en/user/...
Duri Bradshaw's user avatar
4 votes

find and Calculate centroid within polygon either in ArcMap or in MapInfo

This is an old answer but here are my two cents using Arcpy. There is a great script from ESRI about creating a point layer of centroids here: http://support.esri.com/cn/knowledgebase/techarticles/...
Dave-Evans's user avatar
4 votes
Accepted

Insert sequential row and column values automatically into a fishnet dataset

You can use pyqgis with the string and collections.defaultdict libraries. Add a field named label of string/text type, change Grid to the name of your layer below and execute: import string from ...
BERA's user avatar
  • 72.6k
4 votes

Finding all polygons overlapping polygons from another layer using MapInfo?

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 ...
Peter Horsbøll Møller's user avatar
4 votes

Distance between centroid and farthest point of polygon

Using next PyQGIS code: from math import sqrt layer = iface.activeLayer() feats = [ feat for feat in layer.getFeatures() ] n = len(feats) centroids = [ feat.geometry().centroid().asPoint() for ...
xunilk's user avatar
  • 29.9k
4 votes
Accepted

Seeking tool to convert MapInfo WOR to QGIS project file with symbology

There is a plugin named OpenWOR. You need to search for the plugin in the plugin manager. The plugin is experimental, so in order to find it, you should go to Plugins -> Manage and Install Plugins -...
ahmadhanb's user avatar
  • 40.9k
4 votes
Accepted

MapBasic subtract date columns

As Tom (@T_Bacon) wrote in the comments, this works nicely via the MapBasic window: dim date1 as date dim date2 as date date1 = NumberToDate(20160912) date2 = NumberToDate(20160913) Print (date2 - ...
Peter Horsbøll Møller's user avatar
4 votes
Accepted

Filtering and updating manually selected features in MapInfo?

MapInfo is fundamentally different than ArcGIS in the way it handles things like this. There isn't a button to only filter out selected features. Instead, what you need to do is create a temporary ...
Fezter's user avatar
  • 21.9k
4 votes

MapInfo to QGIS style generator ; error message

This isn't an answer to you but more a solution to the developer of the "MapInfo to QGIS style generator" tool. When getting the MapInfo Pro 32-bit application thru OLE, you should specify "MapInfo....
Peter Horsbøll Møller's user avatar
4 votes
Accepted

Update Column to a Value

Sometimes packing the tables used helps. This is especially a problem when you are updating one table with values from another table. You can also try to do it via the interface with the MapBasic ...
Peter Horsbøll Møller's user avatar
4 votes
Accepted

Zoom (with mouse scroll wheel) into specific area centred by the mouse cursor in MapInfo?

In 64-bit version 15.2, there is a feature which allows you to zoom to cursor location. This feature was added to MapInfo Pro 11.5 back in 2012. According to this page from Pitney Bowes, There is ...
Fezter's user avatar
  • 21.9k

Only top scored, non community-wiki answers of a minimum length are eligible