Census Map - Revision history

Admin: /* Links */

2018-02-20T09:06:40Z

Links

← Older revision		Revision as of 09:06, 20 February 2018
Line 532:		Line 532:


			=Flags=

	[[Category:GIS]]		[[Category:GIS]]
			[[Category:Maps]]
			[[Category:Python]]
			[[Category:API]]
			[[Category:Javascript]]
			[[Category:Leaflet]]
			[[Category:D3]]
			[[Category:Census]]

Admin: /* Getting County GeoJSON */

2018-02-20T06:51:53Z

Getting County GeoJSON

← Older revision		Revision as of 06:51, 20 February 2018
Line 480:		Line 480:
	Next, define a way to get GeoJSON information for all of the counties:		Next, define a way to get GeoJSON information for all of the counties:

	<~~source lang="python"~~>		<pre>
	def get_counties_geojson(self):		def get_counties_geojson(self):

	url = "~~http~~://api.censusreporter.org/1.0/geo/show/~~tiger2013~~?geo_ids=050\|04000US06"		url = "https://api.censusreporter.org/1.0/geo/show/tiger2016?geo_ids=050\|04000US06"

	results = json.load(urllib2.urlopen(url))		results = json.load(urllib2.urlopen(url))
Line 491:		Line 491:
	return self.county_geojson		return self.county_geojson

	</~~source~~>		</pre>

	===Modify GeoJSON===		===Modify GeoJSON===

Admin: /* Parsing Table Data */

2018-02-20T06:51:18Z

Parsing Table Data

← Older revision		Revision as of 06:51, 20 February 2018
Line 195:		Line 195:

	<pre>		<pre>
	url = "~~http~~://api.censusreporter.org/1.0/data/show/latest?table_ids="+table_id+"&geo_ids=050\|04000US06"		url = "https://api.censusreporter.org/1.0/data/show/latest?table_ids="+table_id+"&geo_ids=050\|04000US06"
	</pre>		</pre>

Line 205:		Line 205:
	def lookup_table(self,table_id):		def lookup_table(self,table_id):

	url = "~~http~~://api.censusreporter.org/1.0/data/show/latest?table_ids="+table_id+"&geo_ids=050\|04000US06"		url = "https://api.censusreporter.org/1.0/data/show/latest?table_ids="+table_id+"&geo_ids=050\|04000US06"

	results = json.load(urllib2.urlopen(url))		results = json.load(urllib2.urlopen(url))

Admin: /* Extracting Location Data */

2018-02-20T06:50:44Z

Extracting Location Data

← Older revision		Revision as of 06:50, 20 February 2018
Line 155:		Line 155:
	==Extracting Location Data==		==Extracting Location Data==

	Here is an example ~~populating~~ geographic IDs and corresponding names for counties in California:		Here is an example Python code that populates geographic IDs and corresponding names for counties in California:

	<source lang="python">		<source lang="python">
Line 171:		Line 171:
	def populate(self):		def populate(self):

	ca_counties_url = "~~http~~://api.censusreporter.org/1.0/geo/show/~~tiger2013~~?geo_ids=050\|04000US06"		ca_counties_url = "https://api.censusreporter.org/1.0/geo/show/tiger2016?geo_ids=050\|04000US06"

	ca_counties = json.load(urllib2.urlopen(ca_counties_url))		ca_counties = json.load(urllib2.urlopen(ca_counties_url))

Admin: /* Illinois */

2018-02-20T06:50:06Z

Illinois

Show changes

Admin: /* California */

2018-02-20T06:49:00Z

California

← Older revision		Revision as of 06:49, 20 February 2018
Line 139:		Line 139:
	Likewise, California has a FIPS code of 06 (via http://www.census.gov/geo/reference/ansi_statetables.html), so we can get county boundaries in California with the command:		Likewise, California has a FIPS code of 06 (via http://www.census.gov/geo/reference/ansi_statetables.html), so we can get county boundaries in California with the command:

	<~~source lang="bash"~~>		<pre>
	$ curl "~~http~~://api.censusreporter.org/1.0/geo/show/~~tiger2013~~?geo_ids=050\|04000US06"		$ curl "https://api.censusreporter.org/1.0/geo/show/tiger2016?geo_ids=050\|04000US06"
	</~~source~~>		</pre>

	This results in the following map:		This results in the following map:

Admin: /* Illinois */

2018-02-20T06:47:46Z

Illinois

← Older revision		Revision as of 06:47, 20 February 2018
Line 118:		Line 118:

	<pre>		<pre>
	$ curl "http://api.censusreporter.org/1.0/geo/show/~~tiger2013~~?geo_ids=050\|04000US17"		$ curl "http://api.censusreporter.org/1.0/geo/show/tiger2016?geo_ids=050\|04000US17"
	</pre>		</pre>

Line 133:		Line 133:

	[[Image:QGIS_IL.png\|500px]]		[[Image:QGIS_IL.png\|500px]]
			s

	===California===		===California===

Admin: /* Shapefiles for U.S. Counties */

2018-02-20T06:47:18Z

Shapefiles for U.S. Counties

← Older revision		Revision as of 06:47, 20 February 2018
Line 46:		Line 46:

	<pre>		<pre>
	$ curl "~~http~~://api.censusreporter.org/1.0/geo/~~tiger2013~~/04000US55?geom=true"		$ curl "https://api.censusreporter.org/1.0/geo/tiger2016/04000US55?geom=true"
	{		{
	"geometry": {		"geometry": {

Admin: /* Visualizing County Boundaries with GeoJSON in QGIS */

2018-02-20T06:46:53Z

Visualizing County Boundaries with GeoJSON in QGIS

← Older revision		Revision as of 06:46, 20 February 2018
Line 82:		Line 82:

	<pre>		<pre>
	$ curl "~~http~~://api.censusreporter.org/1.0/geo/~~tiger2013~~/05000US04027?geom=True"		$ curl "https://api.censusreporter.org/1.0/geo/tiger2016/05000US04027?geom=True"

	{"geometry": {"type": "MultiPolygon", "coordinates": [[[[-114.563779, 32.418853999999996], [-114.813613, 32.494276], [-114.816591, 32.507695999999996], [-114.802211, 32.513191], [-114.813348, 32.524186], [-114.802181, 32.536414], [-114.80583, 32.546354], [-114.791551, 32.557023], [-114.793224, 32.569459], [-114.80683, 32.55888], [-114.813995, 32.562201], [-114.812995, 32.568706], [-114.801877, 32.576009], [-114.799737, 32.592177], [-114.807906, 32.602782999999995], [-114.809393, 32.617118999999995], [-114.799302, 32.625115], [-114.782573, 32.624303999999995], [-114.779215, 32.633578], [-114.764382, 32.642666], [-114.76495, 32.649391], [-114.74948, 32.66178], [-114.730086, 32.704298], [-114.702223, 32.74541], [-114.68823, 32.73753], [-114.617395, 32.728257], [-114.615112, 32.734515], [-114.581784, 32.734946], [-114.581736, 32.74232], [-114.564508, 32.742274], [-114.564447, 32.749553999999996], [-114.539224, 32.749812], [-114.539092, 32.756949], [-114.526856, 32.757093999999995], [-114.532432, 32.776922], [-114.529633, 32.795477], [-114.510327, 32.816488], [-114.494116, 32.823287], [-114.468971, 32.845155], [-114.46289, 32.905797], [-114.48092, 32.935252], [-114.468061, 32.955259999999996], [-114.468605, 32.971649], [-114.47653199999999, 32.975173999999996], [-114.492938, 32.971781], [-114.501226, 33.007556], [-114.516454, 33.027617], [-114.268748, 33.029815], [-114.267815, 33.463574], [-113.958042, 33.464655], [-113.958046, 33.377578], [-113.33392, 33.377424999999995], [-113.333767, 32.038607], [-114.563779, 32.418853999999996]]]]}, "type": "Feature", "properties": {"awater": 13175612, "display_name": "Yuma County, AZ", "simple_name": "Yuma County", "sumlevel": "050", "population": 199026, "full_geoid": "05000US04027", "aland": 14281187259}}		{"geometry": {"type": "MultiPolygon", "coordinates": [[[[-114.563779, 32.418853999999996], [-114.813613, 32.494276], [-114.816591, 32.507695999999996], [-114.802211, 32.513191], [-114.813348, 32.524186], [-114.802181, 32.536414], [-114.80583, 32.546354], [-114.791551, 32.557023], [-114.793224, 32.569459], [-114.80683, 32.55888], [-114.813995, 32.562201], [-114.812995, 32.568706], [-114.801877, 32.576009], [-114.799737, 32.592177], [-114.807906, 32.602782999999995], [-114.809393, 32.617118999999995], [-114.799302, 32.625115], [-114.782573, 32.624303999999995], [-114.779215, 32.633578], [-114.764382, 32.642666], [-114.76495, 32.649391], [-114.74948, 32.66178], [-114.730086, 32.704298], [-114.702223, 32.74541], [-114.68823, 32.73753], [-114.617395, 32.728257], [-114.615112, 32.734515], [-114.581784, 32.734946], [-114.581736, 32.74232], [-114.564508, 32.742274], [-114.564447, 32.749553999999996], [-114.539224, 32.749812], [-114.539092, 32.756949], [-114.526856, 32.757093999999995], [-114.532432, 32.776922], [-114.529633, 32.795477], [-114.510327, 32.816488], [-114.494116, 32.823287], [-114.468971, 32.845155], [-114.46289, 32.905797], [-114.48092, 32.935252], [-114.468061, 32.955259999999996], [-114.468605, 32.971649], [-114.47653199999999, 32.975173999999996], [-114.492938, 32.971781], [-114.501226, 33.007556], [-114.516454, 33.027617], [-114.268748, 33.029815], [-114.267815, 33.463574], [-113.958042, 33.464655], [-113.958046, 33.377578], [-113.33392, 33.377424999999995], [-113.333767, 32.038607], [-114.563779, 32.418853999999996]]]]}, "type": "Feature", "properties": {"awater": 13175612, "display_name": "Yuma County, AZ", "simple_name": "Yuma County", "sumlevel": "050", "population": 199026, "full_geoid": "05000US04027", "aland": 14281187259}}
Line 90:		Line 90:

	<pre>		<pre>
	$ curl "~~http~~://api.censusreporter.org/1.0/geo/~~tiger2013~~/05000US04027?geom=True" > yuma.geojson		$ curl "https://api.censusreporter.org/1.0/geo/tiger2016/05000US04027?geom=True" > yuma.geojson
	</pre>		</pre>

Admin: /* Visualizing County Boundaries with GeoJSON in QGIS */

2018-02-17T23:07:05Z

Visualizing County Boundaries with GeoJSON in QGIS

← Older revision		Revision as of 23:07, 17 February 2018
Line 89:		Line 89:
	Now we can save that output to a GeoJSON file,		Now we can save that output to a GeoJSON file,

	<~~source lang="bash"~~>		<pre>
	$ curl "http://api.censusreporter.org/1.0/geo/tiger2013/05000US04027?geom=True" > yuma.geojson		$ curl "http://api.censusreporter.org/1.0/geo/tiger2013/05000US04027?geom=True" > yuma.geojson
	</~~source~~>		</pre>

	and open up the GeoJSON file in QGIS, by picking Add Vector Layer, then picking GeoJSON or All File Formats from the file format drop-down box.		and open up the GeoJSON file in QGIS, by picking Add Vector Layer, then picking GeoJSON or All File Formats from the file format drop-down box.