5

I have a grid that has about 30 rows with approx 15 columns each.

I want to label them as A1,A2,B1,B2 etc (Alphabet row, integer is column). Is there any way to do this programatically?

There is no fixed number of columns in a row, so we can not say that after every x columns the next item is B etc.

If necessary I guess we can compare the y on the top right of each grid and when it changes Row A becomes B but I am hoping that there is an easier way of doing this in SQL (Mapinfo) or QGIS.

UNFORTUNATELY I don't have access to ArcGIS grid tool that does this.

I used "QGIS--Vector--Research--Vector Grid" to make the grid.

Another way of asking this is, can this QGIS tool be modified to include grid numbering like in the ArcGIS equivalent Grid Index Features (Cartography) and also ideally the surrounding map numbers.

I am also happy to use a mapbasic program to do this...

  • Could you use the coordinates to determine what row/column a certain cell is at? I would image that the cells are of a specific width/height which could be used to determine "how far away" from the start point a given cell is – Peter Horsbøll Møller Feb 14 '16 at 19:03
  • @PeterHorsbøllMøller yes this could work and I included this in my question but I am hoping that someone already has a solution for this. It would be great to look at the code behind the arcgis tools mentioned to see what they did. – GeorgeC Feb 14 '16 at 21:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.