I have multiple polygon shapes covering the UK. How can I create an Excel spreadsheet of all 6 (sometimes 7) figure XY British National Grid northings/eastings that fall within these polygons?

I don't want just the XYs of the polygon verticies, but all coordinates intersecting the polygon.

  • why do you want all of them? Basically you need to scan across the rectangle defined by the polygon bounding box in metre steps and test to see if it the point is inside the polygon – Ian Turton Nov 24 '17 at 15:10
  • You can't have 7 figure national grid references, that would be meaningless. – Hornbydd Nov 24 '17 at 15:17
  • 1
    @Hornbydd not OS grid references- XY northing/eastings. In Northern Scotland you can get XYs like 353,269 East (X) 1,013,806 North (Y) – Theo F Nov 24 '17 at 15:54
  • @IanTurton Because we need a list of all XYs to compare against incoming client orders. EG. a client will make an order with us, inputting details such as 123 Fake Street, XY: 125,456 523,366 – Theo F Nov 24 '17 at 15:57
  • just do a point in polygon when the points come in – Ian Turton Nov 24 '17 at 15:58

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.