Sample SQL

Download Sample:

CREATE DATABASE places;

CREATE TABLE places (
    pc character(4),
    loc character varying,
    state character varying,
    state_name character varying,
    lat numeric,
    long numeric,
    elev numeric,
    placeid character varying,
    placeid_url character varying,
    geomwkt text,
    source character varying,
    area numeric,
    pop bigint,
    pop_m bigint,
    pop_f bigint,
    ap_cat character varying,
    sal_code bigint,
    lga text,
    lga_full jsonb,
    sa2 text,
    sa2_full jsonb,
    sa3 text,
    sa3_full jsonb,
    ced text,
    ced_full jsonb,
    sed text,
    sed_full jsonb,
    geom geometry(PointZ,4326)
);

-- CREATE TABLE places (
--     pc character(4),
--     loc character varying(39),
--     state character varying(3),
--     state_name character varying(28),
--     lat numeric(10,7),
--     long numeric(10,7),
--     elev numeric(22,18),
--     placeid character varying(127),
--     placeid_url character varying(216),
--     geomwkt character varying(52),
--     source character varying(19),
--     area numeric(11,4),
--     pop bigint,
--     pop_m bigint,
--     pop_f bigint,
--     ap_cat character varying(17),
--     sal_code bigint,
--     lga character varying(89),
--     lga_full character varying(571),
--     sa2 character varying(248),
--     sa2_full character varying(1108),
--     sa3 character varying(129),
--     sa3_full character varying(611),
--     ced character varying(56),
--     ced_full character varying(366),
--     sed character varying(125),
--     sed_full character varying(565)
-- );

INSERT INTO places (pc, loc, state, state_name, lat, long, elev, placeid, placeid_url, geomwkt, source, area, pop, pop_m, pop_f, ap_cat, sal_code, lga, lga_full, sa2, sa2_full, sa3, sa3_full, ced, ced_full, sed, sed_full, geom) VALUES ('2145', 'PENDLE HILL', 'NSW', 'New South Wales', -33.8018889, 150.9556279, 40.918136596679700000, 'ChIJZfdaLJmiEmsRIMYyFmh9AQU', 'https://www.google.com/maps/search/?api=1&query=-33.8018889%2C150.9556279&query_place_id=ChIJZfdaLJmiEmsRIMYyFmh9AQU', 'POINT Z (150.9556279 -33.8018889 40.91813659667969)', 'AP, GN, EL, SL', 3.9276, 7743, 3915, 3827, 'Delivery Area', 13193, 'Cumberland, Parramatta', '[{"coverage": 34.52, "lga_code": 16260, "lga_name": "Parramatta"}, {"coverage": 65.48, "lga_code": 12380, "lga_name": "Cumberland"}]', 'Pendle Hill - Girraween, Toongabbie - Constitution Hill', '[{"coverage": 34.52, "sa2_code": 125041493, "sa2_name": "Toongabbie - Constitution Hill"}, {"coverage": 65.48, "sa2_code": 125041588, "sa2_name": "Pendle Hill - Girraween"}]', 'Parramatta', '[{"coverage": 100.00, "sa3_code": 12504, "sa3_name": "Parramatta"}]', 'Greenway, Parramatta', '[{"ced_code": 118, "ced_name": "Greenway", "coverage": 32.53}, {"ced_code": 135, "ced_name": "Parramatta", "coverage": 67.47}]', 'Prospect, Winston Hills', '[{"coverage": 34.52, "sed_code": 10090, "sed_name": "Winston Hills"}, {"coverage": 65.48, "sed_code": 10069, "sed_name": "Prospect"}]', '01010000A0E6100000A534F68094DE62404143A44BA4E640C00000008085754440');