topic Re: Cities being shown in Wrong Countries in ArcGIS Online Questions https://community.esri.com/t5/arcgis-online-questions/cities-being-shown-in-wrong-countries/m-p/645113#M32141 <HTML><HEAD></HEAD><BODY><P>Hi Muhammad,&nbsp;</P><P>When I ran your query&nbsp;I also received a table with errors. It seems like the export is missing info in certain cities, leading to records not having identical structure. Consequently, when exported it populates rows with wrong data as the schema doesn't match.</P><P>I quickly did a spatial join with a layer of country boundaries. Attached here.&nbsp;Hope this solves your problem.</P><P>Uri</P><P></P><HR /><P><SPAN style="font-size: 13px;"><EM>If this answer solved your question or if you found&nbsp;it helpful please mark it accordingly to help others who have the same question.</EM></SPAN></P></BODY></HTML> Mon, 09 Mar 2020 05:01:01 GMT UriGilad_EsriAu 2020-03-09T05:01:01Z Cities being shown in Wrong Countries https://community.esri.com/t5/arcgis-online-questions/cities-being-shown-in-wrong-countries/m-p/645112#M32140 <HTML><HEAD></HEAD><BODY><DIV class="" style="color: #242729; background-color: #f9f8f6; border: 0px; padding: 0px 15px 0px 0px;"><DIV class="" data-post-id="353342" style="color: var(--black-200) !important; border: 0px; font-weight: inherit; font-size: 13px; margin: -2px;"><DIV class="" data-value="0" style="color: var(--black-500) !important; border: 0px; font-weight: inherit; font-size: 1.61538rem !important; margin: 2px;"></DIV><BUTTON class="" data-selected-classes="fc-theme-primary" style="color: unset; background: none; border: none; text-decoration: none; margin: 2px;" title="This question does not show any research effort; it is unclear or not useful"></BUTTON><BUTTON class="" data-gps-track="post.click({ item: 1, priv: -1, post_type: 1 })" data-selected-classes="fc-yellow-600" style="color: unset; background: none; border: none; text-decoration: none;" title="Click to mark as favorite question (click again to undo)"></BUTTON><A data-shortcut="T" href="https://gis.stackexchange.com/posts/353342/timeline" style="color: unset; background: none; border: none; text-decoration: none; margin: 2px;" title="Timeline">https://gis.stackexchange.com/posts/353342/timeline</A></DIV></DIV><DIV class="" style="color: #242729; background-color: #f9f8f6; border: 0px;"><DIV class="" style="border: 0px; font-weight: inherit; margin: 0px 0px 5px;"><P style="border: 0px; font-weight: inherit; margin: 0px 0px 1em;">I am trying to download the cites with a population greater than 50,000 from the following link<SPAN>&nbsp;</SPAN><A href="https://overpass-turbo.eu/" rel="nofollow noreferrer" style="color: #1d4d5c; border: 0px; font-weight: inherit; text-decoration: underline;">https://overpass-turbo.eu/</A><SPAN>&nbsp;</SPAN>using the code(file attached)</P><P style="border: 0px; font-weight: inherit; margin: 0px 0px 1em;"></P><P style="border: 0px; font-weight: inherit; margin: 0px 0px 1em;">but I am getting the issue that some of the issues are shown in the wrong countries. Please why I am getting this issue and how to correct this.</P><P style="border: 0px; font-weight: inherit; margin: 0px 0px 1em;"><A href="https://i.stack.imgur.com/QJQkd.png" rel="nofollow noreferrer" style="color: #1d4d5c; border: 0px; font-weight: inherit; text-decoration: underline;"><IMG alt="Pic showing the highlighted cites are not in the associated country" src="https://i.stack.imgur.com/QJQkd.png" style="border: 0px; font-weight: inherit;" /></A></P></DIV></DIV></BODY></HTML> Sat, 07 Mar 2020 22:30:18 GMT https://community.esri.com/t5/arcgis-online-questions/cities-being-shown-in-wrong-countries/m-p/645112#M32140 MuhammadRamzan 2020-03-07T22:30:18Z Re: Cities being shown in Wrong Countries https://community.esri.com/t5/arcgis-online-questions/cities-being-shown-in-wrong-countries/m-p/645113#M32141 <HTML><HEAD></HEAD><BODY><P>Hi Muhammad,&nbsp;</P><P>When I ran your query&nbsp;I also received a table with errors. It seems like the export is missing info in certain cities, leading to records not having identical structure. Consequently, when exported it populates rows with wrong data as the schema doesn't match.</P><P>I quickly did a spatial join with a layer of country boundaries. Attached here.&nbsp;Hope this solves your problem.</P><P>Uri</P><P></P><HR /><P><SPAN style="font-size: 13px;"><EM>If this answer solved your question or if you found&nbsp;it helpful please mark it accordingly to help others who have the same question.</EM></SPAN></P></BODY></HTML> Mon, 09 Mar 2020 05:01:01 GMT https://community.esri.com/t5/arcgis-online-questions/cities-being-shown-in-wrong-countries/m-p/645113#M32141 UriGilad_EsriAu 2020-03-09T05:01:01Z