--
-- PostgreSQL database dump
--

-- Dumped from database version 10.3 (Ubuntu 10.3-1.pgdg16.04+1)
-- Dumped by pg_dump version 10.1

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

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: bbox; Type: TABLE; Schema: public; Owner: rjhale
--

CREATE TABLE bbox (
    id integer NOT NULL,
    geom geometry(Polygon,2274)
);


ALTER TABLE bbox OWNER TO rjhale;

--
-- Name: bbox_id_seq; Type: SEQUENCE; Schema: public; Owner: rjhale
--

CREATE SEQUENCE bbox_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE bbox_id_seq OWNER TO rjhale;

--
-- Name: bbox_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rjhale
--

ALTER SEQUENCE bbox_id_seq OWNED BY bbox.id;


--
-- Name: rpoints; Type: TABLE; Schema: public; Owner: rjhale
--

CREATE TABLE rpoints (
    id integer NOT NULL,
    geom geometry(Point,2274)
);


ALTER TABLE rpoints OWNER TO rjhale;

--
-- Name: rpoints_id_seq; Type: SEQUENCE; Schema: public; Owner: rjhale
--

CREATE SEQUENCE rpoints_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE rpoints_id_seq OWNER TO rjhale;

--
-- Name: rpoints_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rjhale
--

ALTER SEQUENCE rpoints_id_seq OWNED BY rpoints.id;


--
-- Name: bbox id; Type: DEFAULT; Schema: public; Owner: rjhale
--

ALTER TABLE ONLY bbox ALTER COLUMN id SET DEFAULT nextval('bbox_id_seq'::regclass);


--
-- Name: rpoints id; Type: DEFAULT; Schema: public; Owner: rjhale
--

ALTER TABLE ONLY rpoints ALTER COLUMN id SET DEFAULT nextval('rpoints_id_seq'::regclass);


--
-- Data for Name: bbox; Type: TABLE DATA; Schema: public; Owner: rjhale
--

COPY bbox (id, geom) FROM stdin;
1	0103000020E2080000010000000500000069717BE9DC894041D486C492E0810F4169717BE9DC8940410855B9D9CDF310410F3CBAB4B2B840410855B9D9CDF310410F3CBAB4B2B84041D486C492E0810F4169717BE9DC894041D486C492E0810F41
\.


--
-- Data for Name: rpoints; Type: TABLE DATA; Schema: public; Owner: rjhale
--

COPY rpoints (id, geom) FROM stdin;
1	0101000020E2080000EE114804F39A40418A739A02EC951041
2	0101000020E2080000158DC69B16984041F68F180900421041
3	0101000020E20800004BBAB6BD368340410EEB83B9567D1041
4	0101000020E208000023EB3BC00F844041C005158B9D171041
5	0101000020E2080000EA1553D2E8944041B1898E337EFC1041
6	0101000020E20800004DBFC2E57FC64041F26CFBAD90CF1041
7	0101000020E20800004B17CA1979C2404113BFB0D60B311041
8	0101000020E2080000B40714CFDEBE4041B565325B82071041
9	0101000020E2080000F75D2ECE0AA940419504764206E80F41
10	0101000020E2080000B8C5A6C3BC9A40412837E879ACFA0F41
11	0101000020E2080000C1F2DB6EBE93404167784C227A4A1041
12	0101000020E2080000EDBD4B9EEF9840412746EF69ADB81041
13	0101000020E20800007173979286AA4041E61B09BC2F7E1041
14	0101000020E20800008D6DE418A5AC40417482C5E06F341041
15	0101000020E2080000AE6326D1CDB440412C1A1C87626C1041
16	0101000020E20800009015DDE4ABB04041E8CC187E75BF1041
17	0101000020E208000098EE152AAAA74041114DA33DE2FF1041
18	0101000020E2080000D4DEA468F1B14041E3F8EB60C00B1141
19	0101000020E2080000606D29A286BA40419ADF32456D021141
20	0101000020E20800008C19E8B2A1AA4041817D37AF64600F41
21	0101000020E20800005E87CE98538C4041A3C775CD906A0F41
22	0101000020E2080000316862031F854041B4EC94DCA66F0F41
23	0101000020E2080000FB1BC1C2E8844041E147DC9E7ACA1041
24	0101000020E2080000B8030901E9C44041A440134C6C021041
25	0101000020E20800008A90A005B1BB404194137D3207A61041
26	0101000020E2080000DB82926602BC40417533D5A2B5751041
27	0101000020E2080000358308543FA0404191B15DAE7B231041
28	0101000020E2080000C9EAC5D2D29F4041405AE1E6988C1041
29	0101000020E20800007AA0CC3D88A340415F3A8976EABC1041
30	0101000020E2080000F6EA8049F1914041B65DBB5033B01041
31	0101000020E208000095276C3F8D8E404113BFB0D60B311041
32	0101000020E2080000CCC709E6C6904041A62995511CED0F41
33	0101000020E20800007FD10CB77F964041BF3D87CE07C10F41
34	0101000020E20800006BCFA99475A04041CC47008DFDAA0F41
35	0101000020E20800005B1D380A79B24041709F91D3B9C20F41
\.


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

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


--
-- Name: bbox_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rjhale
--

SELECT pg_catalog.setval('bbox_id_seq', 1, true);


--
-- Name: rpoints_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rjhale
--

SELECT pg_catalog.setval('rpoints_id_seq', 35, true);


--
-- Name: bbox bbox_pkey; Type: CONSTRAINT; Schema: public; Owner: rjhale
--

ALTER TABLE ONLY bbox
    ADD CONSTRAINT bbox_pkey PRIMARY KEY (id);


--
-- Name: rpoints rpoints_pkey; Type: CONSTRAINT; Schema: public; Owner: rjhale
--

ALTER TABLE ONLY rpoints
    ADD CONSTRAINT rpoints_pkey PRIMARY KEY (id);


--
-- Name: sidx_bbox_geom; Type: INDEX; Schema: public; Owner: rjhale
--

CREATE INDEX sidx_bbox_geom ON public.bbox USING gist (geom);


--
-- PostgreSQL database dump complete
--

