Getting FIR from map

Paul Ramsey pramsey at cleverelephant.ca
Fri Dec 13 09:34:56 PST 2024


Fun problem. Some notes, 
- really, this is *only* published in PDF? seems pretty cruel, maybe contact the agency directly to see if they publish raw data?
- I found that ChatGPT gave me a pretty workable starting script for the problem of extracting lines of a particular color from the document. A little more prompting and I imagine I could get labels too. Probably would require some polish to become workable
- The PDF doesn’t include a projection for the map, which means you’ll have to figure that one somehow in order to pick control points and georeference the lines (affine translation into the planar projection, and then inverse projection to geographics).
Enjoy! 
P

> On Dec 13, 2024, at 9:11 AM, Luca Bertoncello <lucabert at lucabert.de> wrote:
> 
> Dear all,
> 
> Surely a little Off Topic, but I don't know where other I can ask...
> 
> I need to import the FIR into my database.
> For me it is very important to get the region with their codes.
> As region I intend these:
> https://www.eurocontrol.int/sites/default/files/2024-05/eurocontrol-firuir-lower-airspace-europe-2024.pdf
> 
> My problem is to convert the regions of the PDF in coordinate series to
> import in my database.
> 
> I really don't have any idea how to do that.
> Surely there are tools to do that, but I don't know them...
> 
> Can someone suggest me how to solve my problem, if possibile in an
> automated way, so that if the map changes I can reimport the data?
> 
> Thank you very very much!
> Luca Bertoncello
> (lucabert at lucabert.de)



More information about the postgis-users mailing list