Tag Info

Hot answers tagged

6

If I understand your question correctly, you might have values in the Map-Lot field that look like the following: 017-001 017-002 018-121 And you only want to show the portion after the "-". So, the above would be displayed like this: 001 002 121 If your Lot number is always going to be three characters long, then you can use the following label ...


3

When doing a group-by you need to do it this way: select field1, field2, aggregate(field3), aggregate(field4), count(*) from .. group by field1, field2 This means fields NOT listed in the group by, needs to be aggregated in some way such as sum, avg etc. Alternatively they should not be in the select at all. In your case you have both area(obj,"sq km"), ...


2

A For Loop automatically adds to or subtracts from the counter variable. You are subtracting one from it and then the loop itself subtracts one from the counter. That's why it skips every second records in your table. If you are sure all your records are polylines and that noe of them have more than one segment, you can do this in a single update ...


2

Alan I would recommend that you insert the start and end coordinates as separate rows in your table. In that way you can create points for these individually like explanined below. I'm assuming that you have already: - created your new table - made this new table mappable - read the coordinates from the polyline into varialbes called fX1, fY1, fX2, fY2 ...


2

Sum and Count are aggregate functions meaning that you need to Group the data by a column for them to be meaningful. In MapInfo, area(obj,"sq km"), will simply return the area for the first object that it finds whereas Sum(Area(obj, "sq km")) will sum the areas for all objects that have the same attribute value in the "Grouped By" column.


1

towgs parameter is actually a 7 parameter datum shift from the CRS in question to WGS84 (EPSG:4326), because WGS84 is commonly used as a kind of a "base datum", to which all other CRSs have known 7 parameters transformations. Why the definition in QGIS is different is hard to say, but in QGIS you could easily create a custom CRS which would be defined ...


1

Software that does not rely on GDAL/PROJ (like QGIS does) handles datum shifts separately from the projection. This is useful when several datum shifts exist for a specific projection. If you can not define a custom datum with the mapinfo software, reproject your data to a CRS based on the WGS84 ellipsoid inside QGIS. Or create a second custom CRS with ...



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