Missing cities in Hampshire about countries-states-cities-database HOT 1 OPEN

🤖

Based on the context provided, it seems that the location "Hampshire" with isoCode "HAM" and countryCode "GB" is not present in the XML data. To resolve this issue, you need to ensure that the XML file contains the data for this location. If the data is not present, you need to add it to the XML file. The XML data should be in the following format for each city in Hampshire:

<state_city>
    <id>state_id</id>
    <name>Hampshire</name>
    <state_code>HAM</state_code>
    <latitude>latitude_value</latitude>
    <longitude>longitude_value</longitude>
    <country_id>GB</country_id>
    <cities>
      <id>city_id</id>
      <name>city_name</name>
      <latitude>city_latitude</latitude>
      <longitude>city_longitude</longitude>
    </cities>
    ...
</state_city>

Replace state_id, latitude_value, longitude_value, city_id, city_name, city_latitude, and city_longitude with the actual values. You can refer to the xml/states+cities.xml for more details.

Regarding the retrieval of city data, the code uses a GET request to the wft-geo-db API to fetch the city data. The URL for the GET request is constructed using the country and state codes provided in the variables $countryWiki and $stateFips. The offset and limit parameters are used to paginate through the results. You can refer to the scripts/vendor/get_cities_by_state_country.php for more details.

As for the consistency of the issue across all data formats, I wasn't able to find an answer within the repository. It would be helpful if you could provide more information about this. For example, have you checked if the issue is present in other data formats like JSON, SQL, PSQL, YAML, and CSV?

Sources

• xml/states+cities.xml
• scripts/vendor/get_cities_by_state_country.php

from countries-states-cities-database.