[Live-demo] [OSGeo] #689: NaturalEarth Character Encodings

[OSGeo]

#689: NaturalEarth Character Encodings
-----------------------+----------------------------------------------------
 Reporter:  darkblueb  |       Owner:  darkblueb                   
     Type:  defect     |      Status:  new                         
 Priority:  normal     |   Milestone:  OSGeoLive7.5                
Component:  LiveDVD    |    Keywords:  7.0, natural earth, upstream
-----------------------+----------------------------------------------------

Comment(by darkblueb):

 Preliminary for Live 7.9:

 checked out '''10m_physical''', '''10m_cultural''' from svn stable and
 devel

 {{{ https://github.com/nvkelso/natural-earth-vector }}}

 * built and tried FileGDB API v1.2 2012  (note this
 http://forums.arcgis.com/threads/72541-File-Geodatabase-API-1.3-is-now-
 available-for-download)

 * sadly, the .gdb dirs are not readable.. due to pre ArcGIS v10 data ?

 * gathered Live 7.0 tables subset (listed above in this ticket)

 * import subset shps via shp2pgsql -W LATIN1, LATIN9, CP1252

 * compared admin_1 states name, name_local,name_alt from each import and
 Live7

 * compared export of name,name_local,name_alt with ogr2ogr from shp file,
 and psql COPY from imported database.

 '''SUMMARY:'''
 I found that the contents and accuracy of admin_1_states is as good, but
 not better than, Live 7.0, using any of those approaches. There are at
 least two broken admin1 names, showing a 00 byte in the unicode (legal
 utf8 will never have a 00 byte), as well as many hard-to-decipher cases
 due to character set availability on any given terminal. and display
 environment quirks.

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/689#comment:22>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.