Where can I download a list of world cities and towns by ISO ...
文章推薦指數: 80 %
of the countries and their codes are defined in ISO 3166-2. But I couldn't find anything like this for cities. What I need is a table listing of ...
Home
Public
Questions
Tags
Users
Collectives
ExploreCollectives
FindaJob
Jobs
Companies
Teams
StackOverflowforTeams
–Collaborateandshareknowledgewithaprivategroup.
CreateafreeTeam
WhatisTeams?
Teams
CreatefreeTeam
CollectivesonStackOverflow
Findcentralized,trustedcontentandcollaboratearoundthetechnologiesyouusemost.
Learnmore
Teams
Q&Aforwork
Connectandshareknowledgewithinasinglelocationthatisstructuredandeasytosearch.
Learnmore
WherecanIdownloadalistofworldcitiesandtownsbyISO3166-2statecode?[closed]
AskQuestion
Asked
7years,7monthsago
Active
4years,6monthsago
Viewed
29ktimes
19
10
Closed.ThisquestiondoesnotmeetStackOverflowguidelines.Itisnotcurrentlyacceptinganswers.
Wanttoimprovethisquestion?Updatethequestionsoit'son-topicforStackOverflow.
Closed4yearsago.
Improvethisquestion
WorldcountriesandtheirstandardcodesarelistedinISO3166-1.States(whateveraretheycalledindifferentcountries("lands"inGermany,"federationsubjects"inRussiaetc.))ofthecountriesandtheircodesaredefinedinISO3166-2.ButIcouldn'tfindanythinglikethisforcities.
WhatIneedisatablelistingofworldcitieswhereitwouldbealsoshowninwhatparticularstatearetheysituatedandthestatewouldbedesignatedbyanISO3166-2code.
IhavemanagedtofindsuchatablelistingUSAcities(here)butIalsoneedothercountriesdata.
internationalizationgeolocationgisregistrationcity
Share
Improvethisquestion
Follow
editedJul18,2014at15:10
Ivan
askedJul18,2014at15:01
IvanIvan
60.7k9494goldbadges242242silverbadges373373bronzebadges
Addacomment
|
2Answers
2
Active
Oldest
Score
22
IwassearchingforinformationonthesameissueandI'vejustdiscoveredtheUNLOCODEstandard:
Currently,UN/LOCODEincludesover97,114locationsin249countriesandinstallationsininternationalwaters.Itisusedbymostmajorshippingcompanies,byfreightforwardersandinthemanufacturingindustryaroundtheworld.Itisalsoappliedbynationalgovernmentsandintraderelatedactivities,suchasstatisticswhereitisusedbytheEuropeanUnion,bytheUPUforcertainpostalservices,etc
YoucandownloadforfreethefullLOCODElistinMSAccess.mdb,.csvand.txtformats.
Hopethiswillhelpyou.:)
Regards,
--Wayfarer
Share
Improvethisanswer
Follow
answeredNov21,2014at9:55
WayfarerWayfarer
37311goldbadge33silverbadges1010bronzebadges
7
issuewiththisfileisthere'snorelationbetweenregions/locations/subdivisionsandcitiessoyougetallcitiesbutdon'tknowtowhichregionstheyrelate!!
– Steve
Jan23,2015at8:10
Yes,Steve,itdoes:itisonthesixthcolumn,thoughImustadmitthatit'snotcomplete.Itisnotavailableforallthelocationsanditmayuseanonstandardcode.Forexample,forSpainthatcolumnreferstotheprovincewithoutmentioningatalltheupperdivision(autonomouscommunities)andalsosomelocationshavethatfieldvoid.ThelocationsthathavethatfieldfilledusetheISO3166-2:ESstandardwithoutthecountrycodeprefix.
– Wayfarer
Jan28,2015at15:00
wellinthedoctheysaysubdivisionisin4thcolumnandiftakealookintothiscolumnyou'llnotieceseverallocationshavetheirsubdivisionsempty.Also,ifyoulookintotheSubdivisionCodestableorfileyouwillseethere'snorelationwiththeaformentionedsubdivisioncodes!
– Steve
Jan29,2015at17:40
1
Well,itisreallyconfusing:inthedocumentationtheyindeedsaySubDivisionisthe4thcolumn,theweblistinginsertsafirstcolumnnamedCh(Change)thusmovingSubDivisioncolumntothe5th,andtheCSVfile(whichistheoneIuse)inserttheChcolumnplussplitstheLocodecolumnintotwodifferentcolumnsforCountryandLocationcodesoSubDivisioncolumnbecomesthe6th.It'scrazy:-)
– Wayfarer
Feb12,2015at12:45
1
Also,thewebinterfacehelpsaysthefollowing:Column"Subdivision"isintendedtocontaintheISO1-3characteralphabeticand/ornumericcodefortheadministrativedivisionofthecountryconcerned(state,province,department,etc.),asincludedinInternationalStandardISO3166-2/1998andwhendeemeddesirabletoenhancetheuseofthecode,orwhenrequestedbythecountryconcerned.Thecountrycodeelementisnotshowninthiscolumn.It'sfilledonlyonrequest,that'swhyit'semptyinmostcasesunece.org/fileadmin/DAM/cefact/locode/Service/LocodeColumn.htm
– Wayfarer
Feb12,2015at12:53
|
Show2morecomments
6
AsearchonGitHubleadssomedataset
https://github.com/search?q=iso%203166%202
HereyoufinditinCSVforinstancehttps://github.com/fran-diaz/ISO-3166
Share
Improvethisanswer
Follow
answeredAug4,2014at7:58
sabassabas
74588silverbadges1818bronzebadges
2
Thankyou,IfoundtheDebianresourcesononeofgitprojectmuchmoreusablethentheotherresource.
– Rabin
Feb14,2016at13:41
Thankyou.TheCSVexampleisnolongeravailable,Iwonderedwhether
延伸文章資訊
- 1List of all countries with their 2 digit codes (ISO 3166-1) - Dataset
- 2Free ISO 3166-2 Subdivision Code | IP2Location
- 3Where can I download a list of world cities and towns by ISO ...
of the countries and their codes are defined in ISO 3166-2. But I couldn't find anything like thi...
- 4List of ISO 3166 country codes - Wikipedia
- 5ISO3166-2CountrySubdivision