<p>我认为您的请求查询过于复杂:</p>
<p>通过查看下面的网站,您似乎可以在url中使用“Resultofset”来循环浏览整个数据集</p>
<p><a href="https://developers.arcgis.com/rest/services-reference/query-related-records-feature-service-.htm" rel="nofollow noreferrer">enter link description here</a></p>
<pre><code>import requests
import pandas as pd
exceeded_transfer_limit: bool = True
offset: int = 0
result_df = pd.DataFrame()
while exceeded_transfer_limit:
base_url = f"https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_COVID19/" \
f"FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&resultOffset={offset}&f=json"
web_response = requests.get(url=base_url)
web_json = web_response.json()
print(web_json)
# print(type(web_json))
print(web_json.keys())
if 'exceededTransferLimit' in web_json.keys():
exceeded_transfer_limit = web_json['exceededTransferLimit'] #seems like this never return False, key just get ommited if not exceeded
else:
exceeded_transfer_limit=False
print(f"exceededTransferLimit: {exceeded_transfer_limit}")
result_df = result_df.append(pd.DataFrame([dict_row['attributes'] for dict_row in web_json['features']]))
offset += 5000
if len(result_df) >= 500000:
result_df.to_csv(f"covid_data_{offset}.csv", sep=',', index=False)
result_df = pd.DataFrame()
if len(result_df) > 0:
result_df.to_csv(f"covid_data_{offset}_final.csv", index=False)
</code></pre>