Skip to content

Instantly share code, notes, and snippets.

View rutgerhofste's full-sized avatar

Rutger Hofste rutgerhofste

  • WRI
  • Washington DC
View GitHub Profile
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
import pandas as pd
import numpy as np
from sqlalchemy import *
DATABASE_ENDPOINT = "aqueduct30v05.cgpnumwmfcqc.eu-central-1.rds.amazonaws.com"
DATABASE_NAME = "database01"
TABLE_NAME_RAW = "test01_raw"
TABLE_NAME_MODIFIED = "test01_modified"
{
"cells": [
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"type": "FeatureCollection",
"crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
"features": [
{ "type": "Feature", "properties": { "pop_est": 28400000.0, "continent": "Asia", "name": "Afghanistan", "iso_a3": "AFG", "gdp_md_est": 22270.0 }, "geometry": { "type": "Polygon", "coordinates": [ [ [ 61.210817091725744, 35.650072333309225 ], [ 62.230651483005886, 35.270663967422294 ], [ 62.98466230657661, 35.404040839167621 ], [ 63.193538445900352, 35.857165635718914 ], [ 63.98289594915871, 36.007957465146603 ], [ 64.546479119733903, 36.312073269184268 ], [ 64.746105177677407, 37.111817735333304 ], [ 65.588947788357842, 37.305216783185642 ], [ 65.745630731066825, 37.661164048812068 ], [ 66.217384881459338, 37.39379018813392 ], [ 66.51860680528867, 37.362784328758792 ], [ 67.075782098259623, 37.356143907209287 ], [ 67.829999627559516, 37.144994004864685 ], [ 68.135562371701383, 37.023115139304309 ], [ 68.859445835245936, 37.344335842430596 ], [ 69.196272820924378, 37.15114350030742
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Multi-label prediction with Planet Amazon dataset"
]
},
{
state_fips county_fips x y
1 47 -87.114 32.334
1 65 -87.623 32.753
1 85 -86.651 32.148
1 105 -87.294 32.639
1 119 -88.2 32.597
1 3 -87.746 30.659
1 53 -87.168 31.122
1 99 -87.383 31.58
1 9 -86.566 33.977
"name": "flare",
"children": [
{
"name": "analytics",
"children": [
{
"name": "cluster",
"children": [
{"name": "AgglomerativeCluster", "value": 39380},
{"name": "CommunityStructure", "value": 3812},