Naoya Moritani n0531m

## census_zip.sql
#standardsql
with zipcodes as (
SELECT
  zip_census.zipcode as zipcode,
  population,
  WKT as geometry,
  ST_CENTROID(ST_GeogFromText(WKT)) as centroid
FROM
  `bigquery-public-data.census_bureau_usa.population_by_zip_2010` AS zip_census
  join `bigquery-public-data-staging.zcta_test.2017` as zip_geom

## vectorize.py
from __future__ import absolute_import
from __future__ import division
from __future__ import print_function


import numpy as np
import os
import sys
import tensorflow as tf
import json

## vectorize.py
from __future__ import absolute_import
from __future__ import division
from __future__ import print_function

import json
import numpy as np
import os
import tarfile
import tensorflow as tf

## jigsaw.html
<!DOCTYPE html>
<html>

<head>
   <meta charset="UTF-8">
   <title>Jigsaw puzzle</title>
   <script type="text/javascript">
      function save(filename, data)
      {
         var blob = new Blob([data], {type: "text/csv"});
	#standardsql
	with zipcodes as (
	SELECT
	zip_census.zipcode as zipcode,
	population,
	WKT as geometry,
	ST_CENTROID(ST_GeogFromText(WKT)) as centroid
	FROM
	`bigquery-public-data.census_bureau_usa.population_by_zip_2010` AS zip_census
	join `bigquery-public-data-staging.zcta_test.2017` as zip_geom
	from __future__ import absolute_import
	from __future__ import division
	from __future__ import print_function


	import numpy as np
	import os
	import sys
	import tensorflow as tf
	import json
	<!DOCTYPE html>
	<html>

	<head>
	<meta charset="UTF-8">
	<title>Jigsaw puzzle</title>
	<script type="text/javascript">
	function save(filename, data)
	{
	var blob = new Blob([data], {type: "text/csv"});