--
-- PostgreSQL database dump
--

\restrict xiQK0dkftfT68VQ1TRPiN6HjG9vlb1eUpDxd8Z7aujgSNIU0pRgxPv0PFr0Pi2l

-- Dumped from database version 16.10
-- Dumped by pg_dump version 17.6 (Debian 17.6-1.pgdg11+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: mdc_superfund_site; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.mdc_superfund_site (
    objectid integer NOT NULL,
    name character varying(27),
    usepaid character varying(13),
    address character varying(24),
    dermpermit character varying(8),
    folio character varying(13),
    weblink character varying(100),
    lat double precision,
    lon double precision,
    point_x double precision,
    point_y double precision,
    globalid character varying(38),
    geom public.geometry(Point,4326),
    geom_local public.geometry(Point,2236)
);


ALTER TABLE public.mdc_superfund_site OWNER TO postgres;

--
-- Name: mdc_superfund_site_objectid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.mdc_superfund_site_objectid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.mdc_superfund_site_objectid_seq OWNER TO postgres;

--
-- Name: mdc_superfund_site_objectid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.mdc_superfund_site_objectid_seq OWNED BY public.mdc_superfund_site.objectid;


--
-- Name: mdc_superfund_site objectid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mdc_superfund_site ALTER COLUMN objectid SET DEFAULT nextval('public.mdc_superfund_site_objectid_seq'::regclass);


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

COPY public.mdc_superfund_site (objectid, name, usepaid, address, dermpermit, folio, weblink, lat, lon, point_x, point_y, globalid, geom, geom_local) FROM stdin;
1	Airco Plating	FLD004145140	3650 NW 46 St.	HWR-55	3031210001060	www.epa.gov/superfund/airco-plating-company	25.81558	-80.25549	901088.62537985	539355.500408926	c53ef5ad-5306-4a0e-a34f-530f695cd2b6	0101000020E6100000282A7DDC591054C01D514E15CAD03940	0101000020BC08000059EDBC74BF7F2B4193AAA667BA752041
2	Anodyne Inc.	FLD981014368	1270 NW 165 St.	IW5-4649	3421140070120	www.epa.gov/superfund/anodyne-inca	25.92412	-80.22064	912318.31217431	578873.249693724	0a8bd388-1134-4915-9f45-5661f15e68a9	0101000020E61000005631CFEE1E0E54C09994B66B93EC3940	0101000020BC0800003343C0D57AD72B41A4E26DEC75AA2141
3	B&B Chemical	FLD004574190	875 W 20 St.	HWR-111	0430130010172	www.epa.gov/superfund/b&b-chemical-co	25.84008	-80.29957	886536.37499829	548179.749761144	59c043ef-4118-46fb-8818-ce34dc595418	0101000020E6100000CA41F33D2C1354C010D4B98A0FD73940	0101000020BC080000B83490F20E0E2B415AD6ABE8AABA2041
4	Homestead Air Force Base	FL7570024037	HARB	HWR-150	3079020000160	www.epa.gov/superfund/homestead-air-force-base	25.49552	-80.40057	853886.56197589	422784.437004376	79442ddb-65ca-4da1-9691-5f8d52bcddb1	0101000020E61000002E71FCE9A21954C05E7DA068DA7E3940	0101000020BC0800006751224EFB0E2A4144549D6F08CE1941
5	Miami Drum Service	FLD076027820	7049 NW 70 St.	HWR-43	3040350001052	www.epa.gov/superfund/miami-drum-services	25.83641	-80.31229	882361.87515441	546826.187647885	ca34c36d-f14f-436a-9e11-5a08ff848996	0101000020E6100000E234C688FC1354C064436A761FD63940	0101000020BC0800002D9429F271ED2A4135FB5DC817B02041
6	Pepper Steel & Alloy	FLD032544587	10900 NW S River Dr	HWR-165	2220330010530	www.epa.gov/superfund/pepper-steel-and	25.87294	-80.35421	868508.5621175	560033.999756181	7614fab8-9bf2-4bf3-8aa5-02da160350da	0101000020E6100000CC75B557AB1654C0845E009379DF3940	0101000020BC0800004BDD565037812A41273DE26947172141
7	Pepper Steel & Alloy	FLD032544587	11002 NW S River Dr	HWR-165	2220330010540	www.epa.gov/superfund/pepper-steel-and	25.87386	-80.35325	868822.5000378	560369.437580495	85304bf6-fda2-4bdf-b16c-9971481f1f57	0101000020E61000009FAB369E9B1654C030F3DEC6B5DF3940	0101000020BC080000976C2430AB832A41703D264AE6192141
8	Pepper Steel & Alloy	FLD032544587	11100 NW S River Dr	HWR-165	2220330010560	www.epa.gov/superfund/pepper-steel-and	25.87477	-80.35345	868756.06291774	560697.2496768	ad3ab18d-2ae4-4b4a-8d3e-f17d1fb92b20	0101000020E6100000591C0ED99E1654C06F482DF1F0DF3940	0101000020BC080000A591B95026832A4168F0FBE9751C2141
9	Standard Auto Bumper	FLD004126520	2500 W 3 Ct.	HWR-44	0431070062040	www.epa.gov/superfund/standard-auto-bumper	25.84488	-80.28925	889925.93788145	549943.875458783	a55c63ed-4146-4d09-8189-7b7ee92c69d6	0101000020E6100000AD4B48ED821254C06F36FB564AD83940	0101000020BC080000AFB454138A282B4115944A2973C82041
10	Continental Cleaners	FLD982130098	798 NW 62nd St	IW5-3959	0131140370080	www.epa.gov/superfund/continental-cleaners	25.83197	-80.21028	915924.4998	545399.9001	7d8acd7e-8a97-4f0a-9783-f130cd6ada41	0101000020E6100000282F7337750D54C03006484CFCD43940	0101000020BC08000085095B36A7F32B413BF73235F3A42041
11	NW 58th Street Landfill	FLD980602643	2525 NW 62 ST	SW-1373	3030160000010	www.epa.gov/superfund/northwest-th-street	25.83433	-80.34611	871242	546013	e9c94ece-2f9e-44ef-8806-aba3a9f92fe3	0101000020E6100000D047869F261654C009C2051297D53940	0101000020BC080000EC89B33092962A41E8481A68BDA92041
\.


--
-- Name: mdc_superfund_site_objectid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.mdc_superfund_site_objectid_seq', 11, true);


--
-- Name: mdc_superfund_site mdc_superfund_site_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mdc_superfund_site
    ADD CONSTRAINT mdc_superfund_site_pkey PRIMARY KEY (objectid);


--
-- Name: mdc_superfund_site_geom_geom_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX mdc_superfund_site_geom_geom_idx ON public.mdc_superfund_site USING gist (geom);


--
-- Name: mdc_superfund_site_geom_local_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX mdc_superfund_site_geom_local_idx ON public.mdc_superfund_site USING gist (geom_local);


--
-- PostgreSQL database dump complete
--

\unrestrict xiQK0dkftfT68VQ1TRPiN6HjG9vlb1eUpDxd8Z7aujgSNIU0pRgxPv0PFr0Pi2l

