To DB Admins @ Stack Exchange

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: points; Type: TABLE; Schema: public; Owner: webadmin; Tablespace:
--

CREATE TABLE points (
    id bigint NOT NULL,
    route character(10),
    latitude double precision,
    longitude double precision
);


ALTER TABLE public.points OWNER TO webadmin;

--
-- Name: points_id_seq; Type: SEQUENCE; Schema: public; Owner: webadmin
--

CREATE SEQUENCE points_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.points_id_seq OWNER TO webadmin;

--
-- Name: points_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: webadmin
--

ALTER SEQUENCE points_id_seq OWNED BY points.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: webadmin
--

ALTER TABLE ONLY points ALTER COLUMN id SET DEFAULT nextval('points_id_seq'::regclass);


--
-- Data for Name: points; Type: TABLE DATA; Schema: public; Owner: webadmin
--

COPY points (id, route, latitude, longitude) FROM stdin;
1   route 1     11.9038400000000006 75.4211099999999988
2   route 1     11.9034399999999998 75.4208500000000015
3   route 1     11.90245    75.4201599999999956

--The rest of it is redacted data but it is of the same format and goes on for 1734 rows... seesharp
--
--
1733    route99     12.9554299999999998 77.6985700000000037
1734    route99     12.9554600000000004 77.6983800000000002
\.


--
-- Name: points_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webadmin
--

SELECT pg_catalog.setval('points_id_seq', 1734, true);


--
-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: webadmin
--

COPY spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) FROM stdin;
\.


--
-- Name: points_pkey; Type: CONSTRAINT; Schema: public; Owner: webadmin; Tablespace:
--

ALTER TABLE ONLY points
    ADD CONSTRAINT points_pkey PRIMARY KEY (id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--