NunyaBidness on Nostr: ChatGPT-4 works for getting data out of GIS using SQL. I'm not surprised but being ...
ChatGPT-4 works for getting data out of GIS using SQL.
I'm not surprised but being able to query the databases leveraged by arcGIS, ERDAS etc. in natural language seems . . . useful.
Me: Please write a query for arcGIS that locates all single-family dwellings no more than 1/2 mile from a US Interstate and within 5 miles of a hospital
ChatGPT-4: Certainly! Here's a query for ArcGIS that locates all single-family dwellings within a 1/2 mile radius from a US Interstate and within a 5-mile radius of a hospital:
SELECT single_family_dwellings.*
FROM single_family_dwellings, interstate_roads, hospitals
WHERE ST_Distance(single_family_dwellings.geometry, interstate_roads.geometry) <= 0.5 AND ST_Distance(single_family_dwellings.geometry, hospitals.geometry) <= 5;
In this query, you'll need to replace single_family_dwellings with the name of your single-family dwellings dataset or table, interstate_roads with the name of your US Interstate roads dataset or table, and hospitals with the name of your hospitals dataset or table.
The ST_Distance function is used to calculate the distance between the geometries of the single-family dwellings, interstate roads, and hospitals. The query checks if the distance between the single-family dwelling and the interstate road is less than or equal to 0.5 (indicating it is within a 1/2 mile radius) and if the distance between the single-family dwelling and the hospital is less than or equal to 5 (within a 5-mile radius).
Make sure you have the necessary spatial extensions and spatial data loaded into your ArcGIS environment to execute this query successfully.
I'm not surprised but being able to query the databases leveraged by arcGIS, ERDAS etc. in natural language seems . . . useful.
Me: Please write a query for arcGIS that locates all single-family dwellings no more than 1/2 mile from a US Interstate and within 5 miles of a hospital
ChatGPT-4: Certainly! Here's a query for ArcGIS that locates all single-family dwellings within a 1/2 mile radius from a US Interstate and within a 5-mile radius of a hospital:
SELECT single_family_dwellings.*
FROM single_family_dwellings, interstate_roads, hospitals
WHERE ST_Distance(single_family_dwellings.geometry, interstate_roads.geometry) <= 0.5 AND ST_Distance(single_family_dwellings.geometry, hospitals.geometry) <= 5;
In this query, you'll need to replace single_family_dwellings with the name of your single-family dwellings dataset or table, interstate_roads with the name of your US Interstate roads dataset or table, and hospitals with the name of your hospitals dataset or table.
The ST_Distance function is used to calculate the distance between the geometries of the single-family dwellings, interstate roads, and hospitals. The query checks if the distance between the single-family dwelling and the interstate road is less than or equal to 0.5 (indicating it is within a 1/2 mile radius) and if the distance between the single-family dwelling and the hospital is less than or equal to 5 (within a 5-mile radius).
Make sure you have the necessary spatial extensions and spatial data loaded into your ArcGIS environment to execute this query successfully.