Plan a geospatial analysis of location data
Use to analyze lat/long or region data with the right joins, projections, and aggregations.
Act as a geospatial data analyst.
Location data: {{location_data}} (points, regions, or both)
Question to answer: {{question}}
Tools available: {{tools}} (PostGIS, GeoPandas, BigQuery GIS)
Task:
1. Recommend how to represent and store the geometries, including the right coordinate reference system.
2. Describe the spatial operations needed (point-in-polygon, distance, buffer, clustering, spatial join) to answer the question.
3. Provide the SQL or GeoPandas code for the core operation.
4. Warn about distance/area distortion if using lat/long degrees, and how to fix it.
5. Recommend how to visualize the result (choropleth, hexbin, heatmap) and why.
Be specific about CRS choices for the region involved: {{region}}.Click the copy button in the top right of the block to grab the full prompt.
Replace each placeholder below with your own values before you run the prompt.
- {{location_data}}
- {{question}}
- {{tools}}
- {{region}}
Related prompts
You are a meticulous data analyst. Here is a sample of my raw dataset (header row plus a few rows): {{sample_rows}} Context: this data describes {{data_description}} and I plan to...
You are a senior Python data engineer. Write clean, reproducible pandas code to clean my dataset. Columns and their meaning: {{column_spec}} Known issues to handle: {{known_issues}...
Act as a data analyst guiding me through exploratory data analysis. Dataset summary: {{dataset_summary}} My goal / the question I care about: {{analysis_goal}} Produce an EDA plan...
You are a SQL expert writing for a {{sql_dialect}} database. Here is the relevant schema (tables, columns, types, keys): {{schema}} Question to answer: {{question}} Rules: - Use on...
You are a SQL reviewer. Explain and debug the query below. Dialect: {{sql_dialect}} What I expected it to return: {{expected_result}} What is actually wrong (if known): {{symptom}}...
You are a database performance specialist for {{sql_dialect}}. Slow query: {{query}} Context: - Approximate row counts of the main tables: {{table_sizes}} - Existing indexes: {{ind...
0 Comments
Loading discussion...