search

hafen / geofacet

R package for geographical faceting with ggplot2
https://hafen.github.io/geofacet/
Other
336 stars 45 forks source link

georgia new grid #286

Open pjm407 opened 3 years ago

pjm407 commented 3 years ago

county_id | county georgia_tiles_updated.xlsx

| row | column 1 | Dade | 1 | 1 2 | Catoosa | 1 | 2 3 | Murray | 1 | 3 4 | Fannin | 1 | 4 5 | Union | 1 | 5 6 | Towns | 1 | 6 7 | Walker | 2 | 1 8 | Whitfield | 2 | 2 9 | Gilmer | 2 | 3 10 | Lumpkin | 2 | 4 11 | White | 2 | 5 12 | Habersham | 2 | 6 13 | Rabun | 2 | 7 14 | Stephens | 2 | 8 15 | Chattooga | 3 | 1 16 | Gordon | 3 | 2 17 | Pickens | 3 | 3 18 | Dawson | 3 | 4 19 | Hall | 3 | 5 20 | Banks | 3 | 6 21 | Franklin | 3 | 7 22 | Hart | 3 | 8 23 | Floyd | 4 | 1 24 | Bartow | 4 | 2 25 | Cobb | 4 | 3 26 | Cherokee | 4 | 4 27 | Forsyth | 4 | 5 28 | Barrow | 4 | 6 29 | Jackson | 4 | 7 30 | Madison | 4 | 8 31 | Elbert | 4 | 9 32 | Polk | 5 | 1 33 | Paulding | 5 | 2 34 | Fulton | 5 | 3 35 | DeKalb | 5 | 4 36 | Gwinnett | 5 | 5 37 | Walton | 5 | 6 38 | Oconee | 5 | 7 39 | Clarke | 5 | 8 40 | Oglethorpe | 5 | 9 41 | Lincoln | 5 | 10 42 | Haralson | 6 | 1 43 | Carroll | 6 | 2 44 | Douglas | 6 | 3 45 | Clayton | 6 | 4 46 | Rockdale | 6 | 5 47 | Newton | 6 | 6 48 | Morgan | 6 | 7 49 | Greene | 6 | 8 50 | Taliaferro | 6 | 9 51 | Wilkes | 6 | 10 52 | Columbia | 6 | 11 53 | Heard | 7 | 1 54 | Coweta | 7 | 2 55 | Fayette | 7 | 3 56 | Spalding | 7 | 4 57 | Henry | 7 | 5 58 | Butts | 7 | 6 59 | Jasper | 7 | 7 60 | Putnam | 7 | 8 61 | Hancock | 7 | 9 62 | Warren | 7 | 10 63 | McDuffie | 7 | 11 64 | Richmond | 7 | 12 65 | Troup | 8 | 2 66 | Meriwether | 8 | 3 67 | Pike | 8 | 4 68 | Lamar | 8 | 5 69 | Monroe | 8 | 6 70 | Jones | 8 | 7 71 | Baldwin | 8 | 8 72 | Washington | 8 | 9 73 | Glascock | 8 | 10 74 | Jefferson | 8 | 11 75 | Burke | 8 | 12 76 | Harris | 9 | 2 77 | Talbot | 9 | 3 78 | Upson | 9 | 4 79 | Taylor | 9 | 5 80 | Crawford | 9 | 6 81 | Bibb | 9 | 7 82 | Twiggs | 9 | 8 83 | Wilkinson | 9 | 9 84 | Johnson | 9 | 10 85 | Emanuel | 9 | 11 86 | Jenkins | 9 | 12 87 | Screven | 9 | 13 88 | Muscogee | 10 | 3 89 | Marion | 10 | 4 90 | Macon | 10 | 5 91 | Peach | 10 | 6 92 | Houston | 10 | 7 93 | Bleckley | 10 | 8 94 | Laurens | 10 | 9 95 | Treutlen | 10 | 10 96 | Candler | 10 | 11 97 | Bulloch | 10 | 12 98 | Effingham | 10 | 13 99 | Stewart | 11 | 2 100 | Chattahoochee | 11 | 3 101 | Schley | 11 | 4 102 | Sumter | 11 | 5 103 | Dooly | 11 | 6 104 | Pulaski | 11 | 7 105 | Dodge | 11 | 8 106 | Wheeler | 11 | 9 107 | Montgomery | 11 | 10 108 | Toombs | 11 | 11 109 | Evans | 11 | 12 110 | Chatham | 11 | 13 111 | Quitman | 12 | 2 112 | Randolph | 12 | 3 113 | Webster | 12 | 4 114 | Lee | 12 | 5 115 | Crisp | 12 | 6 116 | Wilcox | 12 | 7 117 | Ben Hill | 12 | 8 118 | Telfair | 12 | 9 119 | Jeff Davis | 12 | 10 120 | Tattnall | 12 | 11 121 | Liberty | 12 | 12 122 | Bryan | 12 | 13 123 | Clay | 13 | 2 124 | Calhoun | 13 | 3 125 | Terrell | 13 | 4 126 | Dougherty | 13 | 5 127 | Worth | 13 | 6 128 | Turner | 13 | 7 129 | Irwin | 13 | 8 130 | Coffee | 13 | 9 131 | Appling | 13 | 10 132 | Wayne | 13 | 11 133 | Long | 13 | 12 134 | McIntosh | 13 | 13 135 | Early | 14 | 2 136 | Miller | 14 | 3 137 | Baker | 14 | 4 138 | Mitchell | 14 | 5 139 | Colquitt | 14 | 6 140 | Tift | 14 | 7 141 | Berrien | 14 | 8 142 | Atkinson | 14 | 9 143 | Bacon | 14 | 10 144 | Pierce | 14 | 11 145 | Glynn | 14 | 12 146 | Seminole | 15 | 2 147 | Decatur | 15 | 3 148 | Grady | 15 | 4 149 | Thomas | 15 | 5 150 | Brooks | 15 | 6 151 | Cook | 15 | 7 152 | Lanier | 15 | 8 153 | Clinch | 15 | 9 154 | Ware | 15 | 10 155 | Brantley | 15 | 11 156 | Camden | 15 | 12 157 | Lowndes | 16 | 8 158 | Echols | 16 | 9 159 | Charlton | 16 | 10

stedy commented 3 years ago

This looks a bit incomplete, can you please add the rows and columns for the grid? Thanks!

pjm407 commented 3 years ago

This looks a bit incomplete, can you please add the rows and columns for the grid? Thanks!

Thanks for catching that. Updated! Thank you so much!

stedy commented 3 years ago

pjm407 commented 3 years ago

This looks great! I noticed Charlton was on there twice so I removed it and updated Camden County coordinates

Thank you for your help! Had no idea Georgia had so many counties; I greatly appreciate you catching that and all your support.

pjm407 commented 3 years ago

georgia

us_ga_counties_grid1 <- data.frame(
code = c("1","2","3","4","5","6","7","8","9","10",
                "11","12","13","14","15","16","17","18",
                "19","20","21","22","23","24","25","26",
                "27","28","29","30","31","32","33","34",
                "35","36","37","38","39","40","41","42",
                "43","44","45","46","47","48","49","50",
                "51","52","53","54","55","56","57","58",
                "59","60","61","62","63","64","65","66",
                "67","68","69","70","71","72","73","74",
                "75","76","77","78","79","80","81","82",
                "83","84","85","86","87","88","89","90",
                "91","92","93","94","95","96","97","98",
                "99","100","101","102","103","104","105",
                "106","107","108","109","110","111","112",
                "113","114","115","116","117","118","119",
                "120","121","122","123","124","125","126",
                "127","128","129","130","131","132","133",
                "134","135","136","137","138","139","140",
                "141","142","143","144","145","146","147",
                "148","149","150","151","152","153","154",
                "155","156","157","158","159"),

name = c("Dade","Catoosa","Murray","Fannin","Union","Towns",
             "Walker","Whitfield","Gilmer","Lumpkin","White","Habersham",
             "Rabun","Stephens","Chattooga","Gordon","Pickens","Dawson",
             "Hall","Banks","Franklin","Hart","Floyd","Bartow","Cobb",
             "Cherokee","Forsyth","Barrow","Jackson","Madison","Elbert",
             "Polk","Paulding","Fulton","DeKalb","Gwinnett","Walton","Oconee",
             "Clarke","Oglethorpe","Lincoln","Haralson","Carroll","Douglas",
             "Clayton","Rockdale","Newton","Morgan","Greene","Taliaferro",
             "Wilkes","Columbia","Heard","Coweta","Fayette","Spalding",
             "Henry","Butts","Jasper","Putnam","Hancock","Warren","McDuffie",
             "Richmond","Troup","Meriwether","Pike","Lamar","Monroe","Jones",
             "Baldwin","Washington","Glascock","Jefferson","Burke","Harris",
             "Talbot","Upson","Taylor","Crawford","Bibb","Twiggs","Wilkinson",
             "Johnson","Emanuel","Jenkins","Screven","Muscogee","Marion","Macon",
             "Peach","Houston","Bleckley","Laurens","Treutlen","Candler","Bulloch",
             "Effingham","Stewart","Chattahoochee","Schley","Sumter","Dooly","Pulaski",
             "Dodge","Wheeler","Montgomery","Toombs","Evans","Chatham","Quitman",
             "Randolph","Webster","Lee","Crisp","Wilcox","Ben Hill","Telfair",
             "Jeff Davis","Tattnall","Liberty","Bryan","Clay","Calhoun","Terrell",
             "Dougherty","Worth","Turner","Irwin","Coffee","Appling","Wayne","Long",
             "McIntosh","Early","Miller","Baker","Mitchell","Colquitt","Tift",
             "Berrien","Atkinson","Bacon","Pierce","Glynn","Seminole","Decatur",
             "Grady","Thomas","Brooks","Cook","Lanier","Clinch","Ware","Brantley",
             "Camden","Lowndes","Echols","Charlton"),

row  = c(1,1,1,1,1,1,2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,4,4,4,4,4,4,4,4,4,
           5,5,5,5,5,5,5,5,5,5,6,6,6,6,6,6,6,6,6,6,6,7,7,7,7,7,7,7,7,7,7,7,7,
           8,8,8,8,8,8,8,8,8,8,8,9,9,9,9,9,9,9,9,9,9,9,9,10,10,10,10,10,10,10,10,
           10,10,10,11,11,11,11,11,11,11,11,11,11,11,11,12,12,12,12,12,12,12,12,12,
           12,12,12,13,13,13,13,13,13,13,13,13,13,13,13,14,14,14,14,14,14,14,
           14,14,14,14,15,15,15,15,15,15,15,15,15,15,15,16,16,16),

col  = c(1,2,3,4,5,6,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,9,
           1,2,3,4,5,6,7,8,9,10,1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11,12,
           2,3,4,5,6,7,8,9,10,11,12,2,3,4,5,6,7,8,9,10,11,12,13,
           3,4,5,6,7,8,9,10,11,12,13,2,3,4,5,6,7,8,9,10,11,12,13,2,3,4,5,6,7,8,9,10,11,12,13,
           2,3,4,5,6,7,8,9,10,11,12,13,2,3,4,5,6,7,8,9,10,11,12,
           2,3,4,5,6,7,8,9,10,11,12,8,9,10), stringsAsFactors = FALSE)

geofacet::grid_preview(us_ga_counties_grid1)