MapInfo Pro

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

Hi Ad,

If your document is named using a value that also can be found in the data, you can use an expression to point to the document.

If you have a column with unique IDs, a column with the parish in case that is used in the naming too, and want to link to that, you can use an expression like this:

"C:\Parcel Documents\" & PARISH & "\" & UNIQUE_ID & ".PDF"

I may need a bit more details but I'm sure we can find a way

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

Is it possible to show the above mentioned ROWID's  as a seperate column in existing browser

The table comtains 34000 Rows. 

We want to link these ROWID 's  to external permanent Identifyers or permanent webaddress's.

I asked the same question using a different PC and I am not sure it got send properly.

Hi Ad,

If your document is named using a value that also can be found in the data, you can use an expression to point to the document.

If you have a column with unique IDs, a column with the parish in case that is used in the naming too, and want to link to that, you can use an expression like this:

"C:\Parcel Documents\" & PARISH & "\" & UNIQUE_ID & ".PDF"

I may need a bit more details but I'm sure we can find a way

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

Hi Ad

Yes.

To see these IDs, you can create a new numerical column, preferably Integer or LargeInt, via the Table Strcutre dialog.

Is it possible to show the above mentioned ROWID's  as a seperate column in existing browser

The table comtains 34000 Rows. 

We want to link these ROWID 's  to external permanent Identifyers or permanent webaddress's.

I asked the same question using a different PC and I am not sure it got send properly.

Hi Ad,

If your document is named using a value that also can be found in the data, you can use an expression to point to the document.

If you have a column with unique IDs, a column with the parish in case that is used in the naming too, and want to link to that, you can use an expression like this:

"C:\Parcel Documents\" & PARISH & "\" & UNIQUE_ID & ".PDF"

I may need a bit more details but I'm sure we can find a way

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

Hi Ad

Yes.

To see these IDs, you can create a new numerical column, preferably Integer or LargeInt, via the Table Strcutre dialog.

Is it possible to show the above mentioned ROWID's  as a seperate column in existing browser

The table comtains 34000 Rows. 

We want to link these ROWID 's  to external permanent Identifyers or permanent webaddress's.

I asked the same question using a different PC and I am not sure it got send properly.

Hi Ad,

If your document is named using a value that also can be found in the data, you can use an expression to point to the document.

If you have a column with unique IDs, a column with the parish in case that is used in the naming too, and want to link to that, you can use an expression like this:

"C:\Parcel Documents\" & PARISH & "\" & UNIQUE_ID & ".PDF"

I may need a bit more details but I'm sure we can find a way

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

If you don't update the column again the values should stay as they are.

I feel like I'm missing the point though.

Hi Ad

Yes.

To see these IDs, you can create a new numerical column, preferably Integer or LargeInt, via the Table Strcutre dialog.

Is it possible to show the above mentioned ROWID's  as a seperate column in existing browser

The table comtains 34000 Rows. 

We want to link these ROWID 's  to external permanent Identifyers or permanent webaddress's.

I asked the same question using a different PC and I am not sure it got send properly.

Hi Ad,

If your document is named using a value that also can be found in the data, you can use an expression to point to the document.

If you have a column with unique IDs, a column with the parish in case that is used in the naming too, and want to link to that, you can use an expression like this:

"C:\Parcel Documents\" & PARISH & "\" & UNIQUE_ID & ".PDF"

I may need a bit more details but I'm sure we can find a way

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

If you don't update the column again the values should stay as they are.

I feel like I'm missing the point though.

Hi Ad

Yes.

To see these IDs, you can create a new numerical column, preferably Integer or LargeInt, via the Table Strcutre dialog.

Is it possible to show the above mentioned ROWID's  as a seperate column in existing browser

The table comtains 34000 Rows. 

We want to link these ROWID 's  to external permanent Identifyers or permanent webaddress's.

I asked the same question using a different PC and I am not sure it got send properly.

Hi Ad,

If your document is named using a value that also can be found in the data, you can use an expression to point to the document.

If you have a column with unique IDs, a column with the parish in case that is used in the naming too, and want to link to that, you can use an expression like this:

"C:\Parcel Documents\" & PARISH & "\" & UNIQUE_ID & ".PDF"

I may need a bit more details but I'm sure we can find a way

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance

Morning Ad,

MapInfo Pro doesn't support this out of the box, and nor does the MapInfo tab format.

This would require a tool to help you manage the data or a database system in the background.

A small workaround could be to create a small script that can update the ID of the selected record(s).

The script would work like this:

1. Find the maximum ID currently in the table selected from
2. Update selection with the maximum ID + ROWID

The script could look like this:

Dim sBaseTable As String
sBaseTable = SelectionInfo(SEL_INFO_TABLENAME)
Dim sQuery As String
sQuery = SelectionInfo(SEL_INFO_SELNAME)

aID = sBaseTable + "." + sColumn
Select Max(aID) As "Max"
From sBaseTable
Into __MAX__ID NoSelect Hide

Fetch First From __MAX__ID
Dim nMaxID As Integer
nMaxID = __MAX__ID.MAX

Print "Max ID: " + nMaxID
Dim aID As Alias
aID = sQuery + "." + sColumn
Run Command "Update " + sQuery + " Set " + sColumn + " = " + nMaxID + " + ROWID"

Close Table __MAX__ID
Close Table sQuery

The script will show a dialog like this so that you can 1) see how many records are being updated in what table, and 2) change the name of the ID column if it's not just called ID.

If you don't update the column again the values should stay as they are.

I feel like I'm missing the point though.

Hi Ad

Yes.

To see these IDs, you can create a new numerical column, preferably Integer or LargeInt, via the Table Strcutre dialog.

Is it possible to show the above mentioned ROWID's  as a seperate column in existing browser

The table comtains 34000 Rows. 

We want to link these ROWID 's  to external permanent Identifyers or permanent webaddress's.

I asked the same question using a different PC and I am not sure it got send properly.

Hi Ad,

If your document is named using a value that also can be found in the data, you can use an expression to point to the document.

If you have a column with unique IDs, a column with the parish in case that is used in the naming too, and want to link to that, you can use an expression like this:

"C:\Parcel Documents\" & PARISH & "\" & UNIQUE_ID & ".PDF"

I may need a bit more details but I'm sure we can find a way

Dear Peter,

In my research, parcels also are being split and therefor renumbered.

The alternative is to add the the unique identiier into one column in  the Browser.

Selecting a parcel on the map should open the original source, where the original document can be viewed.

I read your article of 4-24-23; it is not quite clear yet how the above could be achieved. in the current (2023) vesrsion

Thanks for your help

Hi Ad

Tables in MapInfo Pro are assigned a unique hidden ID called ROWID in MapInfo Pro.

It can be used in applications to refer to records in a table but it's not a stable ID. If you pack your table, the IDs will change if some records have been deleted.

The ROWID always starts with 1 for the first record in the table and ends with an ID identical to the number of records in the table, including deleted records.

To see these IDs, you can create a new numerical column, and using Update Column, you can assign the value ROWID to this column.

Every time a browser is opened (unsorted), it seems to open in the same order and new data seem to be added to the bottom of the browser.

1) Is there a ( hidden)  identifying number associated with each of the data lines, containing data for land parcels on a map, and how can that be made visible,

2) if so what happens to that identifyer of the parcel is split?

I reconstruct historic landownership, working backwards from an early 19th century kadastral database and certain parcels originated from more than one earlier  parcel.

We are planning through linked data to connect these parcels to old maps, deeds, manuscripts etc located in various Historic Archives.

These Archives also use unique identifyers like https://hetutrechtsarchief.nl/collectie/609C5B9B48944642E0534701000A17FD for these documents.

Thank in advance