The tiger2014 from donpdonp

tiger2014's Introduction

#Tiger2014

download, unpack, convert, and upload TIGER city data into RethinkDB.

From Sep 2015, TIGER City count is 29,829 with about 2,900 cities dropped due to a polygon or name import error. properties.state is generated locally from a FIPS state catalog. The slug is generated for a url-safe version of the name.

{

    "id": "000d337f-5aa8-4f1c-b0a4-28e0fc78cf4b" ,
    "polygon": { ... } ,
    "properties": {
        "ALAND": 1507973 ,
        "AWATER": 0 ,
        "CLASSFP": "U1" ,
        "FUNCSTAT": "S" ,
        "GEOID": "1908020" ,
        "INTPTLAT": "+42.6367057" ,
        "INTPTLON": "-093.2489484" ,
        "LSAD": "57" ,
        "MTFCC": "G4210" ,
        "NAME": "Bradford" ,
        "NAMELSAD": "Bradford CDP" ,
        "PCICBSA": "N" ,
        "PCINECTA": "N" ,
        "PLACEFP": "08020" ,
        "PLACENS": "02585467" ,
        "STATE": "IA" ,
        "STATEFP": "19"
    } ,
    "slug": "us-ia-bradford"

}

tiger2014's People

Stargazers

Watchers

tiger2014's Issues

string encoding issue

the Cencus files use an unknown string encoding and some cities names are munged due to non UTF-8 names. Determine the encoding used and translate to UTF-8

examples:

saving us-ca-la_ca?ada_flintridge <= La Ca�ada Flintridge 
saving us-ca-pi?on_hills <= Pi�on Hills

complex polygons

2,976 cities have complex polygons which cause the city to be dropped. Investigate why these polygons are different and get the cities imported in some fasion.

Recommend Projects