sample points on campus

samplepoints.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.2
-- Dumped by pg_dump version 10.0

-- Started on 2018-01-03 18:49:42

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;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 291 (class 1259 OID 18964)
-- Name: samplepoints_xyz; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE samplepoints_xyz (
    id integer NOT NULL,
    geom geometry(PointZ,25832),
    name character varying(50),
    point_x double precision,
    point_y double precision,
    point_z double precision
);


ALTER TABLE samplepoints_xyz OWNER TO postgres;

--
-- TOC entry 290 (class 1259 OID 18962)
-- Name: samplepoints_xyz_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE samplepoints_xyz_id_seq OWNER TO postgres;

--
-- TOC entry 4127 (class 0 OID 0)
-- Dependencies: 290
-- Name: samplepoints_xyz_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE samplepoints_xyz_id_seq OWNED BY samplepoints_xyz.id;


--
-- TOC entry 3990 (class 2604 OID 18967)
-- Name: samplepoints_xyz id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY samplepoints_xyz ALTER COLUMN id SET DEFAULT nextval('samplepoints_xyz_id_seq'::regclass);


--
-- TOC entry 4122 (class 0 OID 18964)
-- Dependencies: 291
-- Data for Name: samplepoints_xyz; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY samplepoints_xyz (id, geom, name, point_x, point_y, point_z) FROM stdin;
1	01010000A0E8640000E0D78133010A2041DBD2ACFEB5E0554100A8A44E40BD6340	al_02	32525568.6006	5735127.9792999998	157.91409999999999
2	01010000A0E864000080B740A2EF09204168D012E6B6E055410008AC1C5ABE6340	al_01	32525559.8169	5735131.5948999999	157.9485
3	01010000A0E8640000A03E573BD90920418CDF1D8BC1E0554100840D4FAFD46240	al_04	32525548.615899999	5735174.1737000002	150.6464
4	01010000A0E8640000402EFFC1280A2041135CEE6ABCE055410082734694446240	al_03	32525588.378899999	5735153.6708000004	146.1431
5	01010000A0E864000080A301BC0D0A204165F20FDDBDE0554100BCE3141D3D6240	sound_01	32525574.867199998	5735159.4540999997	145.90979999999999
6	01010000A0E864000080D2DE40F5092041F62387D2BCE0554100D0D556EC3D6240	sound_05	32525562.626699999	5735155.2895	145.93510000000001
7	01010000A0E8640000807EFBFA010A2041FEF1A09FBFE0554100BAFC87F4476240	sound_06	32525568.990200002	5735166.4941999996	146.24860000000001
8	01010000A0E8640000805374A40F0A20411E119540BFE05541008251499D626240	sound_07	32525575.821199998	5735165.0091000004	147.08170000000001
9	01010000A0E864000000363CDD0F0A20415ACEE7A6BBE0554100AA605452896240	sound_08	32525575.932100002	5735150.6079000002	148.29130000000001
10	01010000A0E864000040B4C8B6F409204144869776C5E0554100BC749318206240	333	32525562.357000001	5735189.8530000001	145.00299999999999
11	01010000A0E8640000400AD723FC09204182BBF5C8BFE05541009CC420B02A6240	FJ	32525566.07	5735167.1399999997	145.334
\.


--
-- TOC entry 4128 (class 0 OID 0)
-- Dependencies: 290
-- Name: samplepoints_xyz_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('samplepoints_xyz_id_seq', 11, true);


--
-- TOC entry 3992 (class 2606 OID 18969)
-- Name: samplepoints_xyz samplepoints_xyz_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY samplepoints_xyz
    ADD CONSTRAINT samplepoints_xyz_pkey PRIMARY KEY (id);


--
-- TOC entry 3993 (class 1259 OID 18973)
-- Name: sidx_samplepoints_xyz_geom; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sidx_samplepoints_xyz_geom ON samplepoints_xyz USING gist (geom);


-- Completed on 2018-01-03 18:49:43

--
-- PostgreSQL database dump complete
--