Peter Horsbøll Møller

less info
2,445 reputation
311
bio website blogs.pitneybowes.dk/…
location Denmark
age 42
visits member for 3 years, 3 months
seen 16 hours ago

I have been working with GIS and MapInfo Professional since 1996 when I joined COWI, the Danish distributor of the MapInfo products.

I have worked as end user digitizing paper plans into MapInfo Pro. I have worked as a developer building commercial products as well as customer specfic applications using MapBasic and .NET.

I have also done a lot of training, mostly in the advanced part of MapInfo Pro, such as SQL, Connecting to and using databases and MapBasic.

Currently I work as a Senior Systems Engineer with Pitney Bowes Software who develops MapInfo Professional and the other products in the MapInfo portfolio.


Apr
11
comment New line in MapInfo SQL Select
Alan, that's not cheating - that's getting things done :-) I would probably have ended up doing the same or similar thing. One recommendation is to use the "NoSelect" keyword in queries like these where you don't need the result highlighted or selected into the Selection. MIght even speed up the query a bit
Apr
10
comment New line in MapInfo SQL Select
I don't follow. Normally each record in the result will be a record in the input table. Or each record can be a grouped set of values from the input table. Can you explain a bit more what you are trying to do?
Apr
9
comment New line in MapInfo SQL Select
btw, I think you are missing either AND or OR where you have highlighted it with yellow
Apr
9
answered New line in MapInfo SQL Select
Apr
6
comment Unable to copy text out of MapInfo 12 info tool
Ah, yes. Unfortunately the Info tool doesn't let you mark and copy text from read-only columns. Could you select the text from the browser window instead (haven't tested if that's possible)
Apr
2
comment MapBasic For Loop ignoring every other row
An ever better solution would be to use this structure: " Select * from WorTab where rowid = nrows Into __SOME__NAME NoSelect". In this way you keep overwriting the one query called __SOME__NAME and the NoSelect keyword means that you don't highlight the sected record
Apr
2
answered MapBasic For Loop ignoring every other row
Apr
1
answered Creating points based on coordinates in MapBasic
Mar
31
comment Is there MapInfo Label Expression to label lots in format Map-Lot (017-001) with just Lot?
That will return the Map number and not the Lot number
Mar
31
comment GIS Area question
And if you don't add a Grouping expression, your result set will just contain one single row - aggregated for the entire table
Mar
31
comment MapInfo - writing text using polylines
Could you use a layer of text objects instead?
Mar
31
comment Strange results
Uffe is right. If you don't use an aggrerate on the Area() function you will get the area of a not specified object in the result set, probably the first, but this is not garanteed. Also not that if you add a Where condition to the query the result set will be different and the area will probably be calculated on a different object than in the query without the where condition
Mar
12
answered Why doesn't copying values from MapInfo info tool boxes work properly?
Mar
11
comment Why doesn't copying values from MapInfo info tool boxes work properly?
Oh, forgot to mention that the problem seemed to be that it took MapInfo Pro a bit too long to get ready for copying. So if you wait a while before using Ctrl+C it should work
Mar
11
comment Why doesn't copying values from MapInfo info tool boxes work properly?
Alan, tried finding exactly when we fixed the bug. Only thing I have found so far is that it was fixed some time after december 2010. This would probably mean that it was fixes in v11. I'll try tomorrow when I get back to work to find a more specific version for you
Mar
11
comment Why doesn't copying values from MapInfo info tool boxes work properly?
What version of MI Pro are you using, Alan? I think we fixed this at some point
Mar
5
comment Convert MapInfo raster file (.tab) to use it in QGIS and/or ArcGIS
Universal Translator doesn't handle Raster files, only vector files
Feb
27
revised I have a WKT How can i put it to MAPINFOW.prj file
Reformatet the WKT to make it easier to read
Feb
25
comment Will MapInfo only read PostGIS data that has been loaded via EasyLoader?
The value of 'renditiontype' should be 0 unless you have a text column in your table holding styles in MapBasic syntax or unless you want MapInfo Professional to be able to store these styles on a per row basis. And do make sure that the calue in 'renditioncolumn' matches an existing column in the table and that it isn't left blank!
Feb
25
revised Will MapInfo only read PostGIS data that has been loaded via EasyLoader?
Formated the SQL statements as code