ESG section: people, services and land around each site

What it does

Every year: the people living within 5 km of each site, the schools and clinics nearby and the latest satellite picture, summed up by xMap AI as the social and environmental section of the ESG report.

In one sentence: Monthly on the 1st at 08:00, take your table, count who lives around, count the schools and medical clinics within 5 km of each, get satellite pictures, write a report with xMap AI, then create file from text in Google Drive and email the list to you.

Why it is useful

ESG reports need facts about communities and land. The section is drafted from the map and pictures from above.

Who it is for

Mining, oil & gas. Mining companies, oil and gas operators and their suppliers keeping remote sites safe, supplied and on good terms with their neighbours. Every use case for mining, oil & gas

Best use cases

• A mining company’s sustainability team
• An oil and gas operator
• An ESG consultant

What each run gives you

• A report in Google Drive

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 240 minutes each time; it runs about 1 time a month, so it saves about 4 hours a month (an estimate). It is medium: 8 blocks.

The flow, block by block

1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
2. Our sitesYour data · My dataBrings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
3. Who lives aroundxMap data · DemographicsWho lives in an area: the number of residents, men and women, and nine age groups, from xMap’s population grid (hexagons of about 0.1 km², about 100 countries).
4. Schools and clinics nearbyxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
5. Latest picture of each sitexMap data · Satellite imagesRecent satellite pictures (Sentinel-2, about 10 m per pixel, a new pass every few days) of each incoming place, a point or the Area of interest: when it was taken, how cloudy, and the picture itself.
6. Write the ESG sectionxMap AI · xMap LLMTell the AI what to do in plain words.
7. Save it to Google DriveApp · Google DriveCloud storage and file backup
8. Email me the resultsAction · EmailSends one email per run with all the items, or one email per item.

Every block can be changed after you use the template: the city, the type of place, the score, where the results go.

Use it now

Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.