In MapInfo 10.0, how can I quickly colorize point symbols according to a field in the data table, without creating a new map? My data is just longitude, latitude and time, and I'd like to colorize the points according to the time field. This seems really basic but I can't find any way to do it.
[GIS] How to color symbols by data in MapInfo
mapinfo
Related Solutions
OGR will read mapinfo files, and export to virtually any format you can imagine. You may want to try that first.
Since I asked this question QGIS has developed the capacity to do this more simply and easily... (since 2.14 I think)... so I'm returning to answer my own question.
Use a QGIS 'Virtual Layer'. Menu: Layer|Add Layer|Add Virtual Layer (or corresponding button)
In the image is the add virtual layer dialogue window that appears - in this case I'm working with a layer with points 'TestPCode' and a csv layer 'TestSchools' which has school data with matching postcodes but no geometries.
- Give your layer a name
- Use the import button to add the two files (to the 'Embedded layers' box).
- Write the appropriate SQL (see further notes below)
- test if you like
- 'OK'
I'm (obviously) no expert on SQL - but things aren't quite as simple as they might be. The statement in the image does odd things where there's a null value for the field to be matched in the CSV file ("Postcode"). It matches a null value in the csv file to each and every object in the other table. To get the join to only create objects where there's a proper full match I've found that the following works...
SELECT "TestSchools".*,"TestPCode".* FROM "TestSchools" inner join "TestPCode" ON "TestPCode"."TestPCode" = "TestSchools"."Postcode" and "TestSchools"."Postcode" is not null
(Advice on getting the SELECT statement right would be appreciated - as would any further comment - I've been feeling my way on this)
Best Answer
what i understand from your question is that you want to create points thematic,changes both symbol size and color.
you can do it as :
1.Map > Create Thematic Map
2.Select Point Ranges Default from template
3.Click Next and select a table and a field.
4.Select your Ranges...
The result will be sth. like this. you can more info here.
.
i hope it helps you...