I have two tables in Postgis 2.1 database:
- Polygon features with a reach attributive information;
- Regular point grid;
I would like to get a SQL query returning the regular point grid with assigned attributive information from the underlying polygon. The output should contain lat, lon columns and an extra column with a given attribute. This will be passed to R scripts throughout the csv files.