Skip to main content
Question

Get Substation Names using GPT


parashari
Forum|alt.badge.img+2

Hi,

I have this list of substations that has the city, state, zip, county, lat/lon information present already, and I want the name of the substation plotted in the name field. Is there a possibility to do this using ChatGPT?

Spatial Regards.

4 replies

david_r
Celebrity
  • January 20, 2023

Perhaps it's possible to ask ChatGPT to supply some value to the substation name, but I'm not sure I'd trust it to be correct... ;-)

However, if you want to try it out, this Python interface to ChatGPT might be a starting point:

https://github.com/mmabrouk/chatgpt-wrapper

I haven't tested it myself, however.


parashari
Forum|alt.badge.img+2
  • Author
  • January 20, 2023
david_r wrote:

Perhaps it's possible to ask ChatGPT to supply some value to the substation name, but I'm not sure I'd trust it to be correct... ;-)

However, if you want to try it out, this Python interface to ChatGPT might be a starting point:

https://github.com/mmabrouk/chatgpt-wrapper

I haven't tested it myself, however.

Hey, thank you @david_r​ for your response.

I have tried something and it seems to be working partially. But, something that is strange is that it returns a maximum of 30 outputs, and puts the rest of the ones under rejected(Error: HTTP/2 429 (Too many requests)).

This is how it has worked for me:

Prompt: Get the names of the substations using @Value(LATITUDE) @Value(LONGITUDE) @Value(COUNTRY) @Value(COUNTY) @Value(ZIP)ChatGPT


david_r
Celebrity
  • January 20, 2023
parashari wrote:

Hey, thank you @david_r​ for your response.

I have tried something and it seems to be working partially. But, something that is strange is that it returns a maximum of 30 outputs, and puts the rest of the ones under rejected(Error: HTTP/2 429 (Too many requests)).

This is how it has worked for me:

Prompt: Get the names of the substations using @Value(LATITUDE) @Value(LONGITUDE) @Value(COUNTRY) @Value(COUNTY) @Value(ZIP)ChatGPT

The 429 is pretty much to be expected unless you're a paying customer, ChatGPT usage is very restricted for non-paying users due to heavy load.

https://help.openai.com/en/articles/5955604-how-can-i-solve-429-too-many-requests-errors

https://help.openai.com/en/articles/5955598-is-api-usage-subject-to-any-rate-limits

You can try using the rate limiting (2021) and retry failed requests (2022) options in the HTTPCaller to try and work around this.


parashari
Forum|alt.badge.img+2
  • Author
  • January 24, 2023

Tried playing around and doing some QC using GPT. It provides impressive results. Here are the results:

 

There are 4 examples here, each on the big boxes. The highlighted(in blue) in each big boxes is the output from GPT and the corresponding below one is the expected output. One good part, it provides not only the names but also the type of generator.image


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings