Michael Hodge mshodge

## GEOJSON_for_choromap_testing_REVERSE.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                mshodge
                / GEOJSON_for_choromap_testing_REVERSE.geojson
            
            
              Created
              November 6, 2020 08:30
            
              
                GEOJSON for choromap testing REVERSE
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## gist:48fc68b8565cf0cab1749dda376e6ea1
{
"type": "FeatureCollection",
"name": "utla_ew_2019_bgc",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "objectid": 1, "ctyua19cd": "E06000001", "ctyua19nm": "Hartlepool", "ctyua19nmw": null }, "geometry": { "type": "MultiPolygon", "coordinates": [ [ [ [ -1.24097984294886, 54.723183493277659 ], [ -1.176154551853605, 54.697675590632898 ], [ -1.173979715641095, 54.691810535033106 ], [ -1.196240961710026, 54.698572873239343 ], [ -1.188027070515213, 54.693350750135806 ], [ -1.199092276155691, 54.680575316590208 ], [ -1.175868906270257, 54.653409351351932 ], [ -1.157622586772996, 54.648194817334229 ], [ -1.173151655989613, 54.633703854281833 ], [ -1.188235396549023, 54.632592966449621 ], [ -1.200638130907635, 54.622932365213501 ], [ -1.250691663237776, 54.625307283758019 ], [ -1.298999443949639, 54.627970223416497 ], [ -1.316349739952518, 54.645223613452174 ], [ -1.328849151830261, 54.643990402788916 ], [ -1.335046640018955

## sample_line_gradient_data.csv

          
            short_date
            trend
            derivative

            
              Apr 22
              4532.223707864365
              -8.28051974130132

            
              Apr 23
              4525.636942524678
              -23.016923502693214

            
              Apr 21
              4518.403520579247
              5.0231311086280135

            
              Apr 7
              4506.418899568459
              -9.586325074903844

            
              Apr 24
              4501.040868337549
              -35.855855157130925

            
              Apr 20
              4500.8983651062235
              10.58808912367458

            
              Apr 6
              4493.487230506871
              12.668445101599211

            
              Apr 8
              4491.459394117728
              -25.712550354628483

            
              Apr 19
              4490.036326508919
              10.282280644025285

## BigQuery_GEOGRAPHY_to_STRING_GeoJSON
SELECT *, REPLACE(CAST(ST_ASGEOJSON(county_geom) AS STRING),' ', '') as g FROM `bigquery-public-data.geo_us_boundaries.counties` counties
	{
	"type": "FeatureCollection",
	"name": "utla_ew_2019_bgc",
	"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
	"features": [
	{ "type": "Feature", "properties": { "objectid": 1, "ctyua19cd": "E06000001", "ctyua19nm": "Hartlepool", "ctyua19nmw": null }, "geometry": { "type": "MultiPolygon", "coordinates": [ [ [ [ -1.24097984294886, 54.723183493277659 ], [ -1.176154551853605, 54.697675590632898 ], [ -1.173979715641095, 54.691810535033106 ], [ -1.196240961710026, 54.698572873239343 ], [ -1.188027070515213, 54.693350750135806 ], [ -1.199092276155691, 54.680575316590208 ], [ -1.175868906270257, 54.653409351351932 ], [ -1.157622586772996, 54.648194817334229 ], [ -1.173151655989613, 54.633703854281833 ], [ -1.188235396549023, 54.632592966449621 ], [ -1.200638130907635, 54.622932365213501 ], [ -1.250691663237776, 54.625307283758019 ], [ -1.298999443949639, 54.627970223416497 ], [ -1.316349739952518, 54.645223613452174 ], [ -1.328849151830261, 54.643990402788916 ], [ -1.335046640018955
short_date	trend	derivative
Apr 22	4532.223707864365	-8.28051974130132
Apr 23	4525.636942524678	-23.016923502693214
Apr 21	4518.403520579247	5.0231311086280135
Apr 7	4506.418899568459	-9.586325074903844
Apr 24	4501.040868337549	-35.855855157130925
Apr 20	4500.8983651062235	10.58808912367458
Apr 6	4493.487230506871	12.668445101599211
Apr 8	4491.459394117728	-25.712550354628483
Apr 19	4490.036326508919	10.282280644025285