emireadcode

type CombineAll<T> = T extends {[name in keyof T]: infer Type} ? Type : never

type PropertyNameMap<T, IncludeIntermediate extends boolean> = {
    [name in keyof T]: T[name] extends object ? (
        SubPathsOf<name, T, IncludeIntermediate> | (IncludeIntermediate extends true ? name : never) 
    ) : name
}

type SubPathsOf<key extends keyof T, T, IncludeIntermediate extends boolean> = (
    `${string & key}.${string & PathsOf<T[key], IncludeIntermediate>}`

emireadcode

In this gist I would like to describe an idea for GraphQL subscriptions. It was inspired by conversations about subscriptions in the GraphQL slack channel and different GH issues, like #89 and #411.

Conceptual Model

At the moment GraphQL allows 2 types of queries:

• query
• mutation

Reference implementation also adds the third type: subscription. It does not have any semantics yet, so here I would like to propose one possible semantics interpretation and the reasoning behind it.

emireadcode

SELECT 
polygons.*,
COUNT(points.*)
FROM polygons, points
WHERE ST_Intersects(points.the_geom, polygons.the_geom)

emireadcode

import pandas as pd
from geopandas import GeoDataFrame, points_from_xy
import geopandas as gpd
import time

# Load the Uber point data

df = pd.read_csv('uber_all.csv')

# Create the GeoDataFrame and assign the proper projection

emireadcode

-- written for PostGIS
-- table states is US State Polygons
-- table capitals are US State Capital points

select
a.name,
a.id,

-- create a centroid of the state polygon

emireadcode

WITH
  buildings AS (
  SELECT
    id,
    latitude,
    longitude,
    username,
    osm_timestamp,
  FROM
    `bigquery-public-data.geo_openstreetmap.planet_nodes`

emireadcode

select
*
from
`bigquery-public-data.geo_us_boundaries.states`

emireadcode

select
state_geom, state_name, state
from
`bigquery-public-data.geo_us_boundaries.states`

emireadcode

select 
*
from bigquery-public-data.geo_us_boundaries.state

emireadcode

select
state_geom, state_name, state
from
`bigquery-public-data.geo_us_boundaries.states`
limit 10