Skip to content

Instantly share code, notes, and snippets.

@gabrieldance

gabrieldance/cut_out_states.rb

Last active August 29, 2015 14:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gabrieldance/12987e34b74967cd590c to your computer and use it in GitHub Desktop.
Save gabrieldance/12987e34b74967cd590c to your computer and use it in GitHub Desktop.
Download ZIP
cut out states from country shapefile
Raw
cut_out_states.rb
require 'csv'
states = CSV.read('states_w_regions.csv',headers:true)
states.each do |state|
puts(state["id"], state["abbreviation"])
`ogr2ogr -f "ESRI Shapefile" -sql "select * from cb_2013_us_county_500k where cast(STATEFP as integer(2)) = #{state["fips_state"]}" cb_2013_#{state["abbreviation"]}_county_500k.shp ../cb_2013_us_county_500k.shp`
end
Raw
states_w_regions.csv
id name abbreviation country type sort status occupied notes fips_state assoc_press standard_federal_region census_region census_region_name census_division census_devision_name circuit_court
1 Alabama AL USA state 10 current occupied 1 Ala. IV 3 South 6 East South Central 11
2 Alaska AK USA state 10 current occupied 2 Alaska X 4 West 9 Pacific 9
3 Arizona AZ USA state 10 current occupied 4 Ariz. IX 4 West 8 Mountain 9
4 Arkansas AR USA state 10 current occupied 5 Ark. VI 3 South 7 West South Central 8
5 California CA USA state 10 current occupied 6 Calif. IX 4 West 9 Pacific 9
6 Colorado CO USA state 10 current occupied 8 Colo. VIII 4 West 8 Mountain 10
7 Connecticut CT USA state 10 current occupied 9 Conn. I 1 Northeast 1 New England 2
8 Delaware DE USA state 10 current occupied 10 Del. III 3 South 5 South Atlantic 3
9 Florida FL USA state 10 current occupied 12 Fla. IV 3 South 5 South Atlantic 11
10 Georgia GA USA state 10 current occupied 13 Ga. IV 3 South 5 South Atlantic 11
11 Hawaii HI USA state 10 current occupied 15 Hawaii IX 4 West 9 Pacific 9
12 Idaho ID USA state 10 current occupied 16 Idaho X 4 West 8 Mountain 9
13 Illinois IL USA state 10 current occupied 17 Ill. V 2 Midwest 3 East North Central 7
14 Indiana IN USA state 10 current occupied 18 Ind. V 2 Midwest 3 East North Central 7
15 Iowa IA USA state 10 current occupied 19 Iowa VII 2 Midwest 4 West North Central 8
16 Kansas KS USA state 10 current occupied 20 Kan. VII 2 Midwest 4 West North Central 10
17 Kentucky KY USA state 10 current occupied 21 Ky. IV 3 South 6 East South Central 6
18 Louisiana LA USA state 10 current occupied 22 La. VI 3 South 7 West South Central 5
19 Maine ME USA state 10 current occupied 23 Maine I 1 Northeast 1 New England 1
20 Maryland MD USA state 10 current occupied 24 Md. III 3 South 5 South Atlantic 4
21 Massachusetts MA USA state 10 current occupied 25 Mass. I 1 Northeast 1 New England 1
22 Michigan MI USA state 10 current occupied 26 Mich. V 2 Midwest 3 East North Central 6
23 Minnesota MN USA state 10 current occupied 27 Minn. V 2 Midwest 4 West North Central 8
24 Mississippi MS USA state 10 current occupied 28 Miss. IV 3 South 6 East South Central 5
25 Missouri MO USA state 10 current occupied 29 Mo. VII 2 Midwest 4 West North Central 8
26 Montana MT USA state 10 current occupied 30 Mont. VIII 4 West 8 Mountain 9
27 Nebraska NE USA state 10 current occupied 31 Nebr. VII 2 Midwest 4 West North Central 8
28 Nevada NV USA state 10 current occupied 32 Nev. IX 4 West 8 Mountain 9
29 New Hampshire NH USA state 10 current occupied 33 N.H. I 1 Northeast 1 New England 1
30 New Jersey NJ USA state 10 current occupied 34 N.J. II 1 Northeast 2 Mid-Atlantic 3
31 New Mexico NM USA state 10 current occupied 35 N.M. VI 4 West 8 Mountain 10
32 New York NY USA state 10 current occupied 36 N.Y. II 1 Northeast 2 Mid-Atlantic 2
33 North Carolina NC USA state 10 current occupied 37 N.C. IV 3 South 5 South Atlantic 4
34 North Dakota ND USA state 10 current occupied 38 N.D. VIII 2 Midwest 4 West North Central 8
35 Ohio OH USA state 10 current occupied 39 Ohio V 2 Midwest 3 East North Central 6
36 Oklahoma OK USA state 10 current occupied 40 Okla. VI 3 South 7 West South Central 10
37 Oregon OR USA state 10 current occupied 41 Ore. X 4 West 9 Pacific 9
38 Pennsylvania PA USA state 10 current occupied 42 Pa. III 1 Northeast 2 Mid-Atlantic 3
39 Rhode Island RI USA state 10 current occupied 44 R.I. I 1 Northeast 1 New England 1
40 South Carolina SC USA state 10 current occupied 45 S.C. IV 3 South 5 South Atlantic 4
41 South Dakota SD USA state 10 current occupied 46 S.D. VIII 2 Midwest 4 West North Central 8
42 Tennessee TN USA state 10 current occupied 47 Tenn. IV 3 South 6 East South Central 6
43 Texas TX USA state 10 current occupied 48 Texas VI 3 South 7 West South Central 5
44 Utah UT USA state 10 current occupied 49 Utah VIII 4 West 8 Mountain 10
45 Vermont VT USA state 10 current occupied 50 Vt. I 1 Northeast 1 New England 2
46 Virginia VA USA state 10 current occupied 51 Va. III 3 South 5 South Atlantic 4
47 Washington WA USA state 10 current occupied 53 Wash. X 4 West 9 Pacific 9
48 West Virginia WV USA state 10 current occupied 54 W.Va. III 3 South 5 South Atlantic 4
49 Wisconsin WI USA state 10 current occupied 55 Wis. V 2 Midwest 3 East North Central 7
50 Wyoming WY USA state 10 current occupied 56 Wyo. VIII 4 West 8 Mountain 10
51 Washington DC DC USA capitol 10 current occupied 11 III 3 South 5 South Atlantic D.C.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment