GeoNames Forum

I see that in the island of Puerto Rico there are lots of Administrative Divisions like "Orocovis Municipio" and "Orocovis, Municipio de".

According to http://en.wikipedia.org/wiki/Puerto_Rico#Administrative_divisions , "As an unincorporated territory of the United States, Puerto Rico does not have any first-order administrative divisions as defined by the U.S. Government, but there are 78 municipalities at the second level (Mona Island is not a municipality, but part of the municipality of Mayagüez)."

I guess that you could program something to convert every Adminstrative division in Puerto Rico with a name like "*, Municipio de" to a 2nd order administrative division with a name "Municipio de *", adding es:* as an alternate name.

It seems that the "* Municipio" spots are English-language duplicates of the "*, Municipio de". They seem to be located apart of the Spanish ones so I don't know if you could easily merge them as English alternate names.

I am not sure if the Spanish names should be given priority over the English ones, don't know enough of the Puerto-Rican organization. In that case, make "Municipio de *" the alternate name.

--
Jobrafo

The two entries don't have the same lat/lng. Do you have an idea which one we should use and whether there is a deeper meaning in the second lat/lng?

Marc

I don't know. Maybe they are separated just to display better on paper maps.

--
Jobrafo

Here are all the English names, courtesy of the US government:

[postgres@uberkoder] 1009 ogrinfo -sql "select county from county" county.shp | grep county
INFO: Open of `county.shp'
Layer name: county
county: String (66.0)
OGRFeature(county):0
county (String) = lsabela
OGRFeature(county):1
county (String) = Aguadilla
OGRFeature(county):2
county (String) = Hatillo
OGRFeature(county):3
county (String) = Camuy
OGRFeature(county):4
county (String) = Quebradillas
OGRFeature(county):5
county (String) = Vega Baja
OGRFeature(county):6
county (String) = Barceloneta
OGRFeature(county):7
county (String) = Vega Alta
OGRFeature(county):8
county (String) = Arecibo
OGRFeature(county):9
county (String) = Dorado
OGRFeature(county):10
county (String) = Toa Baja
OGRFeature(county):11
county (String) = Manati
OGRFeature(county):12
county (String) = Catano
OGRFeature(county):13
county (String) = Moca
OGRFeature(county):14
county (String) = Loiza
OGRFeature(county):15
county (String) = Guaynabo
OGRFeature(county):16
county (String) = Bayamo'n
OGRFeature(county):17
county (String) = San Juan
OGRFeature(county):18
county (String) = Aguada
OGRFeature(county):19
county (String) = Carolina
OGRFeature(county):20
county (String) = Canovanas
OGRFeature(county):21
county (String) = Toa Alta
OGRFeature(county):22
county (String) = San Sebastian
OGRFeature(county):23
county (String) = Luquillo
OGRFeature(county):24
county (String) = Florida
OGRFeature(county):25
county (String) = Rio Grande
OGRFeature(county):26
county (String) = Trujillo Alto
OGRFeature(county):27
county (String) = Morovis
OGRFeature(county):28
county (String) = Rincon
OGRFeature(county):29
county (String) = Ciales
OGRFeature(county):30
county (String) = Corozal
OGRFeature(county):31
county (String) = Lares
OGRFeature(county):32
county (String) = Utuado
OGRFeature(county):33
county (String) = Naranjito
OGRFeature(county):34
county (String) = Anasco
OGRFeature(county):35
county (String) = Fajardo
OGRFeature(county):36
county (String) = Caguas
OGRFeature(county):37
county (String) = Gurabo
OGRFeature(county):38
county (String) = Aguas Buenas
OGRFeature(county):39
county (String) = Jayuya
OGRFeature(county):40
county (String) = Culebra
OGRFeature(county):41
county (String) = Naguabo
OGRFeature(county):42
county (String) = Orocovis
OGRFeature(county):43
county (String) = Las Marias
OGRFeature(county):44
county (String) = Comerio
OGRFeature(county):45
county (String) = Las Piedras
OGRFeature(county):46
county (String) = Juncos
OGRFeature(county):47
county (String) = Adjuntas
OGRFeature(county):48
county (String) = Barranquitas
OGRFeature(county):49
county (String) = Cidra
OGRFeature(county):50
county (String) = San Lorenzo
OGRFeature(county):51
county (String) = Ceiba
OGRFeature(county):52
county (String) = Maricao
OGRFeature(county):53
county (String) = Aibonito
OGRFeature(county):54
county (String) = Villalba
OGRFeature(county):55
county (String) = Coamo
OGRFeature(county):56
county (String) = San German
OGRFeature(county):57
county (String) = Yauco
OGRFeature(county):58
county (String) = Cayey
OGRFeature(county):59
county (String) = Hormigueros
OGRFeature(county):60
county (String) = Sabana Grande
OGRFeature(county):61
county (String) = Guayanilla
OGRFeature(county):62
county (String) = Mayaguez
OGRFeature(county):63
county (String) = Patillas
OGRFeature(county):64
county (String) = Vieques
OGRFeature(county):65
county (String) = Humacao
OGRFeature(county):66
county (String) = Yabucoa
OGRFeature(county):67
county (String) = Maunabo
OGRFeature(county):68
county (String) = Arroyo
OGRFeature(county):69
county (String) = Penuelas
OGRFeature(county):70
county (String) = Lajas
OGRFeature(county):71
county (String) = Cabo Rojo
OGRFeature(county):72
county (String) = Guanica
OGRFeature(county):73
county (String) = Juana Diaz
OGRFeature(county):74
county (String) = Guayama
OGRFeature(county):75
county (String) = Santa Isabel
OGRFeature(county):76
county (String) = Salinas
OGRFeature(county):77
county (String) = Ponce

If you need the shapefiles shoot me an email. You can view this shapefile in a MapServer map of PR using ka-map at http://spatial.hopto.org/maps/

P.S. Can provide PostgreSQL/PostGIS dump as well.