Create a GeoJSON of the Countries Surrounding the Disputed India Boundary

index.sql

COPY 
( 
       SELECT row_to_json(fc) AS json_out 
       FROM   ( 
                     SELECT 'FeatureCollection'         AS type, 
                            array_to_json(array_agg(f)) AS features 
                     FROM   ( 
                                     SELECT   'Feature'                                              AS type,
                                              st_asgeojson(st_transform(st_union(b.geom), 4326))::json AS geometry,
                                              ROW_TO_JSON(
                                        (SELECT l
                                         FROM
                                           (SELECT b.iso_a3 AS "ISO_A3") AS l)) AS properties
                                     FROM ne_10m_admin_0_countries b
                                     JOIN india_boundary a ON ST_Intersects(a.geom, b.geom)
                                     WHERE NOT ADMIN = 'India'
                                     GROUP BY b.iso_a3
                                     ) f) fc ) TO '/Users/<user_name>/Desktop/india-surrounding-differences.json';

india-surrounding-differences.json