Crime, flood or natural-hazard risk for each place
get_area_riskOne risk fact for each of up to 250 addresses or points. crime: recorded crimes within about 250 m in the latest month (police.uk; England and Wales; kind narrows it: vehicle, burglary, violent, theft, shoplifting, robbery, anti-social, drugs, criminal damage, bike). flood: the flood zone with high/medium/low (Environment Agency for England, FEMA for the US) and how each compares: FEMA's base flood elevation, the neighbourhood's river and coastal flooding on FEMA's National Risk Index with its national percentile (US), the place's rank on the list (1 = most at risk) and a sentence in words (says) to use on a call or in a note; the map beside the answer draws the places coloured by risk over the official flood zones (for flood prospecting, renewals or a book of business). hazard: FEMA National Risk Index rating for the census tract (US; kind: overall, flood, hurricane, wildfire, tornado, earthquake, heat…). Rows outside a source's coverage say so rather than guess. Set render to true only when the user wants to keep or share the map: it returns a link, GeoJSON and KML, and update_map can change it later.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | No | ||
| title | No | The kept map's title when render is on. | |
| metric | Yes | ||
| render | No | flood: also keep the map (the places by risk over the flood zones): a link to share, GeoJSON and KML. | |
| source | No | Instead of typing rows: { sheet: "<Google Sheets link>", tab?: "Sites" } (shared with the InstaMaps service account, or viewable by anyone with the link), { file: "<Drive link to a CSV or Excel file>" }, or { run: "<run_id from an earlier answer>" }. Columns are found by their headers (id, name, address or its parts, lat/lng); name them if they aren't obvious (id_column, address_column, lat_column, lng_column; from_column and to_column for road distances). Rows with coordinates are used as they are. | |
| records | No | {id, address} or {id, lat, lng}. Send your own ids to merge results back. | |
| addresses | No | Or plain addresses/postcodes, numbered from 1. | |
| background | No | With source: run as a background job and answer at once with job_id (automatic past 200 rows). Check with get_job; write_to_sheet with the job_id puts the results in the sheet as they finish. |