backup.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 17.0
-- Dumped by pg_dump version 17.0

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;

--
-- Name: topology; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA topology;


ALTER SCHEMA topology OWNER TO postgres;

--
-- Name: SCHEMA topology; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA topology IS 'PostGIS Topology schema';


--
-- 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 and geography spatial types and functions';


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

CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology;


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

COMMENT ON EXTENSION postgis_topology IS 'PostGIS topology spatial types and functions';


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO webmapping1;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.auth_group ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.auth_group_permissions (
    id bigint NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO webmapping1;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.auth_group_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO webmapping1;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.auth_permission ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(150) NOT NULL,
    first_name character varying(150) NOT NULL,
    last_name character varying(150) NOT NULL,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO webmapping1;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.auth_user_groups (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO webmapping1;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.auth_user_groups ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.auth_user ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.auth_user_user_permissions (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO webmapping1;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: coffee_shops_coffeeshop; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.coffee_shops_coffeeshop (
    id bigint NOT NULL,
    name character varying(200) NOT NULL,
    address character varying(300) NOT NULL,
    area character varying(100) NOT NULL,
    location public.geometry(Point,4326) NOT NULL,
    rating numeric(2,1),
    description text NOT NULL,
    wifi boolean NOT NULL,
    outdoor_seating boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);


ALTER TABLE public.coffee_shops_coffeeshop OWNER TO webmapping1;

--
-- Name: coffee_shops_coffeeshop_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.coffee_shops_coffeeshop ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.coffee_shops_coffeeshop_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO webmapping1;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.django_admin_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO webmapping1;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.django_content_type ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.django_migrations (
    id bigint NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO webmapping1;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.django_migrations ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO webmapping1;

--
-- Name: maps_location; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.maps_location (
    id bigint NOT NULL,
    name character varying(200) NOT NULL,
    description text NOT NULL,
    point public.geometry(Point,4326) NOT NULL,
    created_at timestamp with time zone NOT NULL
);


ALTER TABLE public.maps_location OWNER TO webmapping1;

--
-- Name: maps_location_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.maps_location ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.maps_location_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: maps_testarea; Type: TABLE; Schema: public; Owner: webmapping1
--

CREATE TABLE public.maps_testarea (
    id bigint NOT NULL,
    name character varying(200) NOT NULL,
    boundary public.geometry(Polygon,4326) NOT NULL,
    area_km2 double precision
);


ALTER TABLE public.maps_testarea OWNER TO webmapping1;

--
-- Name: maps_testarea_id_seq; Type: SEQUENCE; Schema: public; Owner: webmapping1
--

ALTER TABLE public.maps_testarea ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.maps_testarea_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.auth_group (id, name) FROM stdin;
\.


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can view log entry	1	view_logentry
5	Can add permission	2	add_permission
6	Can change permission	2	change_permission
7	Can delete permission	2	delete_permission
8	Can view permission	2	view_permission
9	Can add group	3	add_group
10	Can change group	3	change_group
11	Can delete group	3	delete_group
12	Can view group	3	view_group
13	Can add user	4	add_user
14	Can change user	4	change_user
15	Can delete user	4	delete_user
16	Can view user	4	view_user
17	Can add content type	5	add_contenttype
18	Can change content type	5	change_contenttype
19	Can delete content type	5	delete_contenttype
20	Can view content type	5	view_contenttype
21	Can add session	6	add_session
22	Can change session	6	change_session
23	Can delete session	6	delete_session
24	Can view session	6	view_session
25	Can add location	7	add_location
26	Can change location	7	change_location
27	Can delete location	7	delete_location
28	Can view location	7	view_location
29	Can add test area	8	add_testarea
30	Can change test area	8	change_testarea
31	Can delete test area	8	delete_testarea
32	Can view test area	8	view_testarea
33	Can add Coffee Shop	9	add_coffeeshop
34	Can change Coffee Shop	9	change_coffeeshop
35	Can delete Coffee Shop	9	delete_coffeeshop
36	Can view Coffee Shop	9	view_coffeeshop
\.


--
-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
1	pbkdf2_sha256$600000$f9Ac0HYGqnxerFgznrNzHR$QFg+q+b87WX56ooAyk1pgL97dpgYpNgDvYlhXdC0moM=	2025-10-28 18:21:23.489144+00	t	alann				t	t	2025-10-28 18:20:44.865482+00
\.


--
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.auth_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Data for Name: coffee_shops_coffeeshop; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.coffee_shops_coffeeshop (id, name, address, area, location, rating, description, wifi, outdoor_seating, created_at, updated_at) FROM stdin;
1	3fe Coffee	32 Grand Canal Street Lower	Grand Canal Dock	0101000020E610000083C0CAA145F618C0C217265305AB4A40	4.6	Specialty coffee roaster with excellent espresso	t	f	2025-10-30 14:39:31.391912+00	2025-10-30 14:39:31.391912+00
2	Clement & Pekoe	50 South William Street	City Centre	0101000020E6100000AF25E4839E0D19C007CE1951DAAB4A40	4.5	Cozy cafe with great brunch options	t	t	2025-10-30 14:39:31.418232+00	2025-10-30 14:39:31.418232+00
3	Brother Hubbard	153 Capel Street	North City	0101000020E610000089D2DEE00B1319C0BF0E9C33A2AC4A40	4.7	Middle Eastern inspired cafe with amazing coffee	t	f	2025-10-30 14:39:31.421252+00	2025-10-30 14:39:31.421252+00
4	Cloud Picker Coffee	Bachelors Walk	Temple Bar	0101000020E6100000711B0DE02D1019C0BF7D1D3867AC4A40	4.4	Riverside location with specialty coffee	t	t	2025-10-30 14:39:31.424593+00	2025-10-30 14:39:31.424593+00
5	The Bald Barista	Aungier Street	City Centre	0101000020E61000001E166A4DF30E19C008AC1C5A64AB4A40	4.6	Popular spot for quality coffee and pastries	t	f	2025-10-30 14:39:31.429639+00	2025-10-30 14:39:31.429639+00
6	Kaph	31 Drury Street	City Centre	0101000020E610000020D26F5F070E19C088855AD3BCAB4A40	4.5	Minimalist cafe with excellent coffee	t	f	2025-10-30 14:39:31.439639+00	2025-10-30 14:39:31.439639+00
7	Network	39 Aungier Street	City Centre	0101000020E6100000CA54C1A8A40E19C0C139234A7BAB4A40	4.3	Student-friendly cafe with good wifi	t	f	2025-10-30 14:39:31.44364+00	2025-10-30 14:39:31.44364+00
8	Two Pups Coffee	Francis Street	The Liberties	0101000020E6100000D5E76A2BF61719C024287E8CB9AB4A40	4.7	Dog-friendly cafe in the Liberties	t	t	2025-10-30 14:39:31.450638+00	2025-10-30 14:39:31.450638+00
9	Vice Coffee Inc.	54 Middle Abbey Street	City Centre	0101000020E61000005A643BDF4F0D19C05BB1BFEC9EAC4A40	4.4	Specialty coffee in the heart of Dublin	t	f	2025-10-30 14:39:31.453647+00	2025-10-30 14:39:31.453647+00
10	Proper Order Coffee	Smithfield Square	Smithfield	0101000020E6100000B1506B9A771C19C03FC6DCB584AC4A40	4.6	Spacious cafe with great outdoor seating	t	t	2025-10-30 14:39:31.460643+00	2025-10-30 14:39:31.460643+00
11	Mugs Cafe	61A Castle Street, Dalkey, Co. Dublin	Dalkey	0101000020E61000007B14AE47E17A18C0A4703D0AD7A34A40	4.5	Cozy, community-oriented caf├® with strong coffee, pastries, upstairs seating and pavement seating	t	t	2025-11-01 16:53:58.015861+00	2025-11-01 16:53:58.015861+00
12	The Corner Note Cafe	1 Coliemore Road, Dalkey, Co. Dublin	Dalkey	0101000020E610000023DBF97E6A7C18C0B29DEFA7C6A34A40	3.8	Restaurant-quality food in a caf├® setting, free & open wifi, heritage town location	t	f	2025-11-01 16:53:58.065777+00	2025-11-01 16:53:58.065777+00
13	Thyme Out	33/34 Castle Street, Dalkey, Co. Dublin	Dalkey	0101000020E61000005D6DC5FEB27B18C0401361C3D3A34A40	\N	Gourmet food shop / deli with caf├® elements, daily fresh produce and house-made items	t	f	2025-11-01 16:53:58.072788+00	2025-11-01 16:53:58.072788+00
14	Happy Out	Windsor Terrace, D├║n Laoghaire, Co. Dublin, A96 WP7A, Ireland	D├║n Laoghaire	0101000020E61000000AD7A3703D8A18C021B0726891A54A40	4.4	Harbour-side caf├® with strong views, pastries, food options, buzz on sunny days	f	t	2025-11-01 16:53:58.077946+00	2025-11-01 16:53:58.077946+00
15	Shoe Lane Coffee (D├║n Laoghaire)	Unit 107, D├║n Laoghaire Shopping Centre, GeorgeÔÇÖs Street Upper, D├║n Laoghaire	D├║n Laoghaire	0101000020E6100000C3F5285C8F8218C0D9CEF753E3A54A40	\N	Chain caf├®, commuter-friendly spot with reliable coffee and pastry options	t	t	2025-11-01 16:53:58.082147+00	2025-11-01 16:53:58.082147+00
16	Pepper Laine	Blue Court, 2 Convent Rd, Dalkey Commons, Dalkey	Dalkey	0101000020E610000096438B6CE77B18C06B2BF697DDA34A40	\N	Stylish caf├® in Dalkey village, good for coffee and local design/retail items	t	f	2025-11-01 16:53:58.086465+00	2025-11-01 16:53:58.086465+00
17	The Fumbally	Fumbally Lane	The Liberties	0101000020E6100000B84082E2C71819C0C1A8A44E40AB4A40	4.5	Beloved cafe with farm-to-table ethos and excellent coffee	t	t	2025-12-01 17:09:58.55844+00	2025-12-01 17:09:58.55844+00
18	Bear Market Coffee	4 Blackhall Place	Smithfield	0101000020E6100000AC1C5A643B1F19C0CD3B4ED191AC4A40	4.7	Specialty coffee roastery with rotating single origins	t	f	2025-12-01 17:09:58.61383+00	2025-12-01 17:09:58.61383+00
19	Wall & Keogh	Richmond Street South	Portobello	0101000020E6100000006F8104C50F19C08A1F63EE5AAA4A40	4.4	Neighborhood gem with excellent brunch and coffee	t	t	2025-12-01 17:09:58.62089+00	2025-12-01 17:09:58.62089+00
20	Silke Road Cafe	34 Kevin Street Lower	Liberties	0101000020E6100000849ECDAACF1519C017D9CEF753AB4A40	4.3	Cozy student-friendly cafe near DIT	t	f	2025-12-01 17:09:58.623899+00	2025-12-01 17:09:58.623899+00
21	Imbibe	110 Parnell Street	North City	0101000020E6100000022B8716D90E19C0BE30992A18AD4A40	4.6	Specialty coffee with impressive latte art	t	f	2025-12-01 17:09:58.630039+00	2025-12-01 17:09:58.630039+00
22	Coffeeangel	South Anne Street	City Centre	0101000020E6100000EEEBC039230A19C007CE1951DAAB4A40	4.2	Ethical coffee with great bagels and pastries	t	f	2025-12-01 17:09:58.637351+00	2025-12-01 17:09:58.637351+00
23	Shoe Lane Coffee	Arran Street East	Smithfield	0101000020E61000000C022B87161919C0BF7D1D3867AC4A40	4.5	Industrial-chic roastery with outdoor seating	t	t	2025-12-01 17:09:58.675351+00	2025-12-01 17:09:58.675351+00
24	Urbanity Coffee	5 Smithfield Square	Smithfield	0101000020E6100000CD3B4ED1911C19C0780B24287EAC4A40	4.4	Modern cafe in the heart of Smithfield	t	t	2025-12-01 17:09:58.690346+00	2025-12-01 17:09:58.690346+00
25	Proper Order Coffee Co	6 Haymarket	Smithfield	0101000020E610000040A4DFBE0E1C19C0A323B9FC87AC4A40	4.6	Spacious roastery with great breakfast options	t	t	2025-12-01 17:09:58.695382+00	2025-12-01 17:09:58.695382+00
26	Butlers Chocolate Cafe	24 Wicklow Street	City Centre	0101000020E610000096B20C71AC0B19C0A4703D0AD7AB4A40	4.1	Irish chocolate brand with excellent hot chocolate	t	f	2025-12-01 17:09:58.705348+00	2025-12-01 17:09:58.705348+00
27	Roasted Brown	88 Lower Camden Street	Camden	0101000020E6100000ACADD85F760F19C0098A1F63EEAA4A40	4.5	Popular brunch spot with great coffee	t	f	2025-12-01 17:09:58.709382+00	2025-12-01 17:09:58.709382+00
28	Two Boys Brew	Pleasants Place	Camden	0101000020E61000003CBD5296210E19C07AA52C431CAB4A40	4.6	Award-winning specialty coffee roasters	t	t	2025-12-01 17:09:58.713347+00	2025-12-01 17:09:58.713347+00
29	Carved	48 Pearse Street	City Centre	0101000020E6100000910F7A36ABFE18C0A301BC0512AC4A40	4.3	Artisan sandwiches and excellent filter coffee	t	f	2025-12-01 17:09:58.718693+00	2025-12-01 17:09:58.718693+00
30	Accents Coffee	Stephens Green Shopping Centre	St Stephens Green	0101000020E6100000091B9E5E290B19C0DE9387855AAB4A40	4.0	Convenient shopping center location	t	f	2025-12-01 17:09:58.723604+00	2025-12-01 17:09:58.723604+00
31	Cafe Coco	9 South William Street	City Centre	0101000020E6100000CB10C7BAB80D19C0F9A067B3EAAB4A40	4.2	Trendy spot in creative quarter	t	t	2025-12-01 17:09:58.728623+00	2025-12-01 17:09:58.728623+00
32	Bewleys Grafton Street	78 Grafton Street	City Centre	0101000020E6100000986E1283C00A19C0EBE2361AC0AB4A40	4.3	Historic Dublin institution with ornate interior	t	f	2025-12-01 17:09:58.731591+00	2025-12-01 17:09:58.731591+00
33	Havana Cafe	4 Grand Canal Square	Grand Canal Dock	0101000020E61000004CA60A4625F518C024B9FC87F4AB4A40	4.1	Modern cafe with waterfront views	t	t	2025-12-01 17:09:58.736615+00	2025-12-01 17:09:58.736615+00
34	Drury Buildings	52-55 Drury Street	City Centre	0101000020E61000003CBD5296210E19C04F401361C3AB4A40	4.4	Multi-level food hall with specialty coffee	t	f	2025-12-01 17:09:58.741327+00	2025-12-01 17:09:58.741327+00
35	Love Supreme	57 Aungier Street	City Centre	0101000020E61000003B014D840D0F19C0CF66D5E76AAB4A40	4.5	Hip cafe with record shop vibes	t	f	2025-12-01 17:09:58.745358+00	2025-12-01 17:09:58.745358+00
36	Kevin Street Coffee	77 Kevin Street Lower	Liberties	0101000020E6100000F8C264AA601419C0D0D556EC2FAB4A40	4.2	Popular with students and locals	t	f	2025-12-01 17:09:58.750287+00	2025-12-01 17:09:58.750287+00
37	Bread 41	41 Pearse Street	City Centre	0101000020E6100000736891ED7CFF18C06ABC749318AC4A40	4.6	Artisan bakery with exceptional coffee	t	t	2025-12-01 17:09:58.754331+00	2025-12-01 17:09:58.754331+00
38	Queen of Tarts	Cows Lane	Temple Bar	0101000020E6100000C364AA60541219C087A757CA32AC4A40	4.5	Famous for homemade cakes and pastries	f	t	2025-12-01 17:09:58.758775+00	2025-12-01 17:09:58.758775+00
39	Foam Cafe	Aston Quay	City Centre	0101000020E610000094F6065F980C19C007F0164850AC4A40	4.3	River views and quality coffee	t	f	2025-12-01 17:09:58.763775+00	2025-12-01 17:09:58.763775+00
40	Meet Me in the Morning	Pleasants Street	Camden	0101000020E6100000AD69DE718A0E19C0508D976E12AB4A40	4.4	Weekend brunch favorite with excellent coffee	t	t	2025-12-01 17:09:58.768776+00	2025-12-01 17:09:58.768776+00
41	Idle Wild	South Great Georges Street	City Centre	0101000020E61000003CBD5296210E19C0083D9B559FAB4A40	4.2	Relaxed atmosphere with quality beans	t	f	2025-12-01 17:09:58.772778+00	2025-12-01 17:09:58.772778+00
42	Gaillot et Gray	Fade Street	City Centre	0101000020E610000058A835CD3B0E19C0CE88D2DEE0AB4A40	4.1	French-inspired cafe with outdoor terrace	t	t	2025-12-01 17:09:58.777834+00	2025-12-01 17:09:58.777834+00
43	Tartine Cafe	Bachelors Walk	North City	0101000020E6100000ACADD85F760F19C0EA95B20C71AC4A40	4.3	Casual spot near the Liffey	t	t	2025-12-01 17:09:58.781775+00	2025-12-01 17:09:58.781775+00
44	Starbucks Grafton Street	51 Grafton Street	City Centre	0101000020E610000043AD69DE710A19C0DDB5847CD0AB4A40	3.9	Chain coffee shop in prime location	t	f	2025-12-01 17:09:58.791374+00	2025-12-01 17:09:58.791374+00
45	Insomnia Coffee	Trinity College	City Centre	0101000020E6100000143FC6DCB50419C0B22E6EA301AC4A40	4.0	Irish coffee chain with reliable quality	t	f	2025-12-01 17:09:58.796219+00	2025-12-01 17:09:58.796219+00
46	Jungle Cafe	South Great Georges Street	City Centre	0101000020E6100000917EFB3A700E19C096B20C71ACAB4A40	4.4	Vegan cafe with specialty coffee and plants	t	f	2025-12-01 17:09:58.803158+00	2025-12-01 17:09:58.803158+00
47	Cafe Nero	88 Donnybrook Road	Donnybrook	0101000020E61000001904560E2DF218C07DAEB6627FA94A40	3.5	Italian coffee chain with handcrafted drinks and panini	t	t	2025-12-01 17:25:00.249953+00	2025-12-01 17:25:00.249953+00
48	Cafe Diem	Donnybrook	Donnybrook	0101000020E6100000A69BC420B0F218C0A8C64B3789A94A40	4.5	Moroccan-run coffee shop with excellent hospitality and homemade food	t	f	2025-12-01 17:25:00.276954+00	2025-12-01 17:25:00.276954+00
49	Cafe Java	Donnybrook	Donnybrook	0101000020E61000006DC5FEB27BF218C0D3DEE00B93A94A40	3.5	Breakfast and brunch cafe with wide range of dishes and quality coffee	t	f	2025-12-01 17:25:00.284293+00	2025-12-01 17:25:00.284293+00
50	The Art of Coffee	Ballsbridge	Ballsbridge	0101000020E61000005EBA490C02EB18C0355EBA490CAA4A40	4.3	Stylish cafe with freshly roasted beans, relaxing jazz and breakfast options	t	f	2025-12-01 17:25:00.291682+00	2025-12-01 17:25:00.291682+00
51	Ballsbridge Speciality Coffee	Shelbourne Road	Ballsbridge	0101000020E6100000B6F3FDD478E918C01904560E2DAA4A40	4.6	Direct trade specialty coffee with house-baked flatbreads and Italian sandwiches	t	f	2025-12-01 17:25:00.298636+00	2025-12-01 17:25:00.298636+00
52	The Orange Goat	Sandymount/Ballsbridge	Ballsbridge	0101000020E61000009CC420B072E818C0273108AC1CAA4A40	4.5	Fresh homemade food with Cloudpicker specialty coffee	t	f	2025-12-01 17:25:00.305637+00	2025-12-01 17:25:00.305637+00
53	Cafe Java Ballsbridge	49 Shelbourne Road	Ballsbridge	0101000020E6100000448B6CE7FBE918C0EEEBC03923AA4A40	3.8	Continental-style coffee house with table service and Suki tea	t	f	2025-12-01 17:25:00.315634+00	2025-12-01 17:25:00.315634+00
54	Avoca Ballsbridge	Shelbourne Road	Ballsbridge	0101000020E6100000D122DBF97EEA18C0431CEBE236AA4A40	4.2	Food market with coffee bar, patisserie and Fodder Restaurant	t	t	2025-12-01 17:25:00.322638+00	2025-12-01 17:25:00.322638+00
55	Red Bean Roastery	Clayton Hotel Ballsbridge	Ballsbridge	0101000020E6100000EC51B81E85EB18C0448B6CE7FBA94A40	4.0	Barista-style coffee and baked treats in hotel setting	t	f	2025-12-01 17:25:00.329624+00	2025-12-01 17:25:00.329624+00
56	Cafe Du Journal	17a The Crescent	Monkstown	0101000020E610000091ED7C3F359E18C03D0AD7A370A54A40	4.2	Gourmet coffee shop with eggs benedict, pancakes and brunch menu	t	t	2025-12-01 17:25:00.336625+00	2025-12-01 17:25:00.336625+00
57	Insomnia Coffee Monkstown	1A The Crescent	Monkstown	0101000020E6100000E6AE25E4839E18C0764F1E166AA54A40	3.8	Chain coffee shop at Spar with fairtrade coffee and pastries	t	f	2025-12-01 17:25:00.342625+00	2025-12-01 17:25:00.343698+00
58	Avoca Monkstown	Monkstown Main Street	Monkstown	0101000020E61000001F85EB51B89E18C04C37894160A54A40	4.3	Food market with Salt Caf├® serving seasonal breakfast and lunch	t	t	2025-12-01 17:25:00.349626+00	2025-12-01 17:25:00.349626+00
59	Cinnamon	Monkstown	Monkstown	0101000020E6100000575BB1BFEC9E18C013F241CF66A54A40	4.2	Comfortable eatery and coffee house with brunch menu	t	f	2025-12-01 17:25:00.355621+00	2025-12-01 17:25:00.355621+00
60	Hatch Coffee	13 Main Street	Blackrock	0101000020E61000004BEA043411B618C08351499D80A64A40	4.5	3fe specialty coffee with stunning interior and delicious brunch dishes	t	f	2025-12-01 17:25:00.361982+00	2025-12-01 17:25:00.361982+00
61	Fable + Stey	Blackrock	Blackrock	0101000020E6100000BC96900F7AB618C04A0C022B87A64A40	4.4	Neighbourhood cafe serving seasonal food and beautiful coffee	t	f	2025-12-01 17:25:00.372045+00	2025-12-01 17:25:00.372045+00
62	Rocksalt Cafe	Blackrock	Blackrock	0101000020E6100000F6285C8FC2B518C011C7BAB88DA64A40	4.3	Casual dining lifestyle cafe with breakfast, brunch and lunch	t	t	2025-12-01 17:25:00.381983+00	2025-12-01 17:25:00.381983+00
63	Vanilla Pod	Blackrock	Blackrock	0101000020E6100000105839B4C8B618C01FF46C567DA64A40	4.2	Fantastic coffee, wine and freshly made cakes and pastries	t	f	2025-12-01 17:25:00.38898+00	2025-12-01 17:25:00.38898+00
64	The Mellow Fig	Blackrock	Blackrock	0101000020E61000006519E25817B718C0E6AE25E483A64A40	4.4	Cafe with quality food and friendly atmosphere	t	f	2025-12-01 17:25:00.396031+00	2025-12-01 17:25:00.396031+00
65	Ranelagh Ristretto	22 Main Street, Ranelagh	Ranelagh	0101000020E610000048E17A14AE0719C052B81E85EBA94A40	4.6	Trendy, high-quality espresso bar with a focus on single-origin beans.	t	t	2025-12-06 18:49:33.04739+00	2025-12-06 18:49:33.04739+00
66	The Triangle Grind	1 The Triangle	Ranelagh	0101000020E6100000A01A2FDD240619C07D3F355EBAA94A40	4.1	A small, reliable corner spot popular with commuters.	t	f	2025-12-06 18:49:33.089118+00	2025-12-06 18:49:33.089118+00
67	Bubble & Brew	8 Mount Pleasant Avenue	Ranelagh	0101000020E6100000F0A7C64B370919C00AD7A3703DAA4A40	4.4	Known for its signature bubble waffles and ethically sourced coffee.	t	t	2025-12-06 18:49:33.092118+00	2025-12-06 18:49:33.092118+00
68	Leinster Latte	14 Fitzwilliam Place	Ranelagh	0101000020E61000001283C0CAA10519C0D122DBF97EAA4A40	4.7	Upscale cafe offering premium pastries and a quiet working environment.	t	f	2025-12-06 18:49:33.097125+00	2025-12-06 18:49:33.097125+00
69	The Green Bench Coffee	5 Dartmouth Road	Ranelagh	0101000020E61000003F355EBA490C19C0355EBA490CAA4A40	4.2	A simple spot with park views and lovely outdoor seating.	f	t	2025-12-06 18:49:33.100118+00	2025-12-06 18:49:33.100118+00
70	Urban Grounds	3 Richmond Street	Ranelagh	0101000020E610000062105839B40819C08B6CE7FBA9A94A40	4.5	Industrial chic design with a focus on dark, rich roasts.	t	f	2025-12-06 18:49:33.103119+00	2025-12-06 18:49:33.103119+00
71	Wicklow Way Brews	19 Appian Way	Ranelagh	0101000020E610000025068195430B19C0EE7C3F355EAA4A40	4.3	Hiker-friendly cafe with hearty sandwiches and strong coffee.	t	t	2025-12-06 18:49:33.107124+00	2025-12-06 18:49:33.107124+00
72	The Artisan Roastery	4 Upper Ranelagh Road	Ranelagh	0101000020E6100000BA490C022B0719C0448B6CE7FBA94A40	4.8	Specialist roastery where you can watch the beans being roasted.	t	f	2025-12-06 18:49:33.111122+00	2025-12-06 18:49:33.111122+00
73	Little Lane Cafe	7 Cullenswood Place	Ranelagh	0101000020E61000000AD7A3703D0A19C06F1283C0CAA94A40	4.0	Cosy spot down a small lane, famous for its scones and jam.	f	t	2025-12-06 18:49:33.115119+00	2025-12-06 18:49:33.115119+00
74	Booterstown Bay Coffee	1 Merrion Strand	Booterstown	0101000020E6100000A245B6F3FDD418C0D578E92631A84A40	4.7	Directly on the coast road with excellent views of the bay and bird sanctuary.	t	t	2025-12-06 18:49:33.120119+00	2025-12-06 18:49:33.120119+00
75	The Causeway Cafe	12 Booterstown Avenue	Booterstown	0101000020E61000004A0C022B87D618C00E2DB29DEFA74A40	4.2	Traditional Irish cafe with a focus on hearty breakfast and lunch options.	t	f	2025-12-06 18:49:33.123119+00	2025-12-06 18:49:33.123119+00
76	DARTside Brews	5 Station Road	Booterstown	0101000020E6100000FA7E6ABC74D318C0B81E85EB51A84A40	3.9	Quick service kiosk for commuters on the go, near the DART station.	f	f	2025-12-06 18:49:33.128122+00	2025-12-06 18:49:33.128122+00
77	The Blackrock Junction	8 Rock Road	Booterstown	0101000020E610000037894160E5D018C0643BDF4F8DA74A40	4.5	A bright, spacious cafe at the junction leading towards Blackrock.	t	t	2025-12-06 18:49:33.131119+00	2025-12-06 18:49:33.131119+00
78	Fresco Frescati	3 Frescati Park	Booterstown	0101000020E6100000273108AC1CDA18C08195438B6CA74A40	4.4	Contemporary cafe with Italian flair, serving specialty pastries and desserts.	t	f	2025-12-06 18:49:33.135121+00	2025-12-06 18:49:33.135121+00
79	Seapoint Sip	15 Merrion View	Booterstown	0101000020E610000052B81E85EBD118C0AAF1D24D62A84A40	4.1	Small, dog-friendly spot with outdoor benches and a relaxed atmosphere.	t	t	2025-12-06 18:49:33.13912+00	2025-12-06 18:49:33.13912+00
80	The Milltown Mingle	18 Stillorgan Road	Booterstown	0101000020E61000000C022B8716D918C048E17A14AEA74A40	4.3	A popular meeting spot with a vibrant, bustling interior.	t	f	2025-12-06 18:49:33.143122+00	2025-12-06 18:49:33.143122+00
81	St. HelenÔÇÖs Brew	6 St. HelenÔÇÖs Road	Booterstown	0101000020E61000008716D9CEF7D318C0F2D24D6210A84A40	4.6	Quiet cafe tucked away, offering strong, high-quality filter coffee.	t	t	2025-12-06 18:49:33.146117+00	2025-12-06 18:49:33.146117+00
82	Coastal Comforts	2 Booterstown Avenue Upper	Booterstown	0101000020E6100000D7A3703D0AD718C01D5A643BDFA74A40	4.0	Classic, no-frills coffee and tea house.	f	f	2025-12-06 18:49:33.150479+00	2025-12-06 18:49:33.150479+00
83	The Millwheel Cafe	4 Churchtown Road	Milltown	0101000020E61000001B2FDD24060119C0736891ED7CA74A40	4.5	Located near the old mill site, known for its rustic charm and riverside seating.	t	t	2025-12-06 18:49:33.153506+00	2025-12-06 18:49:33.153506+00
84	Goatstown Grounds	15 Lower Main Street	Milltown	0101000020E6100000E5D022DBF9FE18C0BA490C022BA74A40	4.3	Modern cafe with a strong focus on technical brewing methods.	t	f	2025-12-06 18:49:33.159493+00	2025-12-06 18:49:33.159493+00
85	ClassonÔÇÖs Cafe	7 Classon House	Milltown	0101000020E6100000C3F5285C8F0219C0560E2DB29DA74A40	4.1	A popular stop for locals, offering great value lunch deals.	t	t	2025-12-06 18:49:33.16351+00	2025-12-06 18:49:33.16351+00
86	The Dodder Drip	10 Riverwalk Terrace	Milltown	0101000020E6100000DD240681950319C09EEFA7C64BA74A40	4.7	Offers outdoor seating right next to the River Dodder with excellent views.	t	t	2025-12-06 18:49:33.167489+00	2025-12-06 18:49:33.167489+00
87	The Organic Bean	2 Dundrum Road	Milltown	0101000020E6100000CBA145B6F3FD18C039B4C876BEA74A40	4.6	Only serves organic, ethically sourced coffee and vegan treats.	t	f	2025-12-06 18:49:33.171491+00	2025-12-06 18:49:33.171491+00
88	The Nine Lives Coffee Co.	11 Sandford Road	Milltown	0101000020E610000085EB51B81E0519C01D5A643BDFA74A40	4.0	Cat-themed cafe with a very relaxed, playful atmosphere.	t	t	2025-12-06 18:49:33.176494+00	2025-12-06 18:49:33.176494+00
89	Milltown Market Brews	3 Milltown Street	Milltown	0101000020E610000000000000000019C0643BDF4F8DA74A40	4.2	A small kiosk operating near the local market for quick service.	f	f	2025-12-06 18:49:33.18049+00	2025-12-06 18:49:33.18049+00
90	Windy Arbour Cafe	6 Windy Arbour Road	Milltown	0101000020E610000096438B6CE7FB18C08FC2F5285CA74A40	4.4	A charming, slightly elevated spot with a pleasant view of the surrounding area.	t	t	2025-12-06 18:49:33.18349+00	2025-12-06 18:49:33.18349+00
91	The Golden Circle	1 Merrion Grove	Milltown	0101000020E6100000F853E3A59B0419C08195438B6CA74A40	4.5	Known for its excellent service and consistent, medium-roast blend.	t	f	2025-12-06 18:49:33.187492+00	2025-12-06 18:49:33.187492+00
92	Dundrum Depot	1 Main Street, Dundrum	Dundrum	0101000020E6100000BA490C022B0719C0B0726891EDA44A40	4.3	A bustling main street cafe with plenty of indoor and outdoor seating.	t	t	2025-12-06 18:49:33.190489+00	2025-12-06 18:49:33.190489+00
93	The Shopping Centre Brew	Unit 32, Town Centre	Dundrum	0101000020E6100000508D976E120319C0A245B6F3FDA44A40	3.8	Large, high-volume cafe located inside the shopping centre.	t	f	2025-12-06 18:49:33.195491+00	2025-12-06 18:49:33.195491+00
94	Luas Line Cafe	12 Taney Road	Dundrum	0101000020E61000007D3F355EBA0919C085EB51B81EA54A40	4.1	Conveniently located near the Luas stop, offering quick takeaway service.	t	t	2025-12-06 18:49:33.198496+00	2025-12-06 18:49:33.198496+00
95	Sandyford Sip	4 Upper Kilmacud Road	Dundrum	0101000020E61000008D976E12830019C0E9263108ACA44A40	4.5	Modern and sleek cafe focused on innovative coffee drinks.	t	f	2025-12-06 18:49:33.202491+00	2025-12-06 18:49:33.202491+00
96	The Village Blend	7 Dundrum Village	Dundrum	0101000020E610000085EB51B81E0519C0DBF97E6ABCA44A40	4.6	A favourite local gem with a cosy, welcoming interior and exceptional staff.	t	t	2025-12-06 18:49:33.207494+00	2025-12-06 18:49:33.207494+00
97	Sweet & Strong	9 Ballally Close	Dundrum	0101000020E6100000D578E926310819C0068195438BA44A40	4.2	Known for pairing strong espresso with freshly baked sweet pastries.	f	t	2025-12-06 18:49:33.212495+00	2025-12-06 18:49:33.212495+00
98	Airfield Cafe	2 Airfield Farm Lane	Dundrum	0101000020E6100000355EBA490C0219C04C37894160A54A40	4.7	An outdoorsy cafe setting with family-friendly options.	t	t	2025-12-06 18:49:33.21649+00	2025-12-06 18:49:33.21649+00
99	The Old Coach House	18 Main Street Upper	Dundrum	0101000020E61000002DB29DEFA70619C0BE9F1A2FDDA44A40	4.4	Located in a historic building with rustic, timber-framed interior.	t	f	2025-12-06 18:49:33.220492+00	2025-12-06 18:49:33.220492+00
100	Balally Brews	3 Kilmacud Gardens	Dundrum	0101000020E61000000AD7A3703D0A19C0F853E3A59BA44A40	4.0	A no-fuss cafe serving quick, affordable hot drinks near the housing area.	t	t	2025-12-06 18:49:33.224507+00	2025-12-06 18:49:33.224507+00
\.


--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	auth	user
5	contenttypes	contenttype
6	sessions	session
7	maps	location
8	maps	testarea
9	coffee_shops	coffeeshop
\.


--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2025-10-28 18:16:52.325094+00
2	auth	0001_initial	2025-10-28 18:16:52.436571+00
3	admin	0001_initial	2025-10-28 18:16:52.466925+00
4	admin	0002_logentry_remove_auto_add	2025-10-28 18:16:52.475934+00
5	admin	0003_logentry_add_action_flag_choices	2025-10-28 18:16:52.488292+00
6	contenttypes	0002_remove_content_type_name	2025-10-28 18:16:52.517765+00
7	auth	0002_alter_permission_name_max_length	2025-10-28 18:16:52.528245+00
8	auth	0003_alter_user_email_max_length	2025-10-28 18:16:52.542371+00
9	auth	0004_alter_user_username_opts	2025-10-28 18:16:52.557809+00
10	auth	0005_alter_user_last_login_null	2025-10-28 18:16:52.572334+00
11	auth	0006_require_contenttypes_0002	2025-10-28 18:16:52.575332+00
12	auth	0007_alter_validators_add_error_messages	2025-10-28 18:16:52.587701+00
13	auth	0008_alter_user_username_max_length	2025-10-28 18:16:52.606873+00
14	auth	0009_alter_user_last_name_max_length	2025-10-28 18:16:52.624039+00
15	auth	0010_alter_group_name_max_length	2025-10-28 18:16:52.638718+00
16	auth	0011_update_proxy_permissions	2025-10-28 18:16:52.652+00
17	auth	0012_alter_user_first_name_max_length	2025-10-28 18:16:52.663408+00
18	maps	0001_initial	2025-10-28 18:16:52.740739+00
19	sessions	0001_initial	2025-10-28 18:16:52.756042+00
20	coffee_shops	0001_initial	2025-10-30 14:39:23.469828+00
\.


--
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
kv8ekjz0nlfr9yenhjz8kzcuvffsr6s8	.eJxVjDsOwjAQBe_iGln-rA2hpOcM0e56jQPIluKkQtwdIqWA9s3Me6kR16WMa5d5nJI6K6sOvxshP6RuIN2x3prmVpd5Ir0peqddX1uS52V3_w4K9vKtAwSOwfBgXCTxESNbG0OCLBaBPAwUwDA7guMJBSmDF2cscw7WZFHvD9UYOBI:1vDoJv:UOdPC7C3Glw8ODEu1c1gRtPfSsAtBHa3kPXHCQThCSA	2025-11-11 18:21:23.493145+00
\.


--
-- Data for Name: maps_location; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.maps_location (id, name, description, point, created_at) FROM stdin;
1	TUD Grangegorman Campus	Technological University Dublin main campus	0101000020E61000007DAEB6627F1919C0A245B6F3FDAC4A40	2025-10-28 18:30:55.433634+00
2	Trinity College Dublin	Historic university in Dublin city center	0101000020E6100000143FC6DCB50419C0B22E6EA301AC4A40	2025-10-28 18:30:55.450639+00
3	Phoenix Park	Large enclosed park in Dublin	0101000020E610000019E25817B75119C05AF5B9DA8AAD4A40	2025-10-28 18:30:55.453984+00
4	Dublin Castle	Historic castle and government complex	0101000020E610000036CD3B4ED11119C032E6AE25E4AB4A40	2025-10-28 18:30:55.45706+00
5	Temple Bar	Cultural quarter with pubs and galleries	0101000020E6100000E7FBA9F1D20D19C095D4096822AC4A40	2025-10-28 18:30:55.460337+00
\.


--
-- Data for Name: maps_testarea; Type: TABLE DATA; Schema: public; Owner: webmapping1
--

COPY public.maps_testarea (id, name, boundary, area_km2) FROM stdin;
1	Dublin City Center	0103000020E610000001000000050000001F85EB51B81E19C07B14AE47E1AA4A4000000000000019C07B14AE47E1AA4A4000000000000019C03D0AD7A370AD4A401F85EB51B81E19C03D0AD7A370AD4A401F85EB51B81E19C07B14AE47E1AA4A40	5.999999999998855e-10
2	Phoenix Park Area	0103000020E610000001000000050000005C8FC2F5285C19C0CDCCCCCCCCAC4A4048E17A14AE4719C0CDCCCCCCCCAC4A4048E17A14AE4719C0AE47E17A14AE4A405C8FC2F5285C19C0AE47E17A14AE4A405C8FC2F5285C19C0CDCCCCCCCCAC4A40	1.9999999999995593e-10
\.


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

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


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

COPY topology.topology (id, name, srid, "precision", hasz) FROM stdin;
\.


--
-- Data for Name: layer; Type: TABLE DATA; Schema: topology; Owner: postgres
--

COPY topology.layer (topology_id, layer_id, schema_name, table_name, feature_column, feature_type, level, child_id) FROM stdin;
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 1, false);


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false);


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 36, true);


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 1, false);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.auth_user_id_seq', 1, true);


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.auth_user_user_permissions_id_seq', 1, false);


--
-- Name: coffee_shops_coffeeshop_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.coffee_shops_coffeeshop_id_seq', 100, true);


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 1, false);


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.django_content_type_id_seq', 9, true);


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 20, true);


--
-- Name: maps_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.maps_location_id_seq', 5, true);


--
-- Name: maps_testarea_id_seq; Type: SEQUENCE SET; Schema: public; Owner: webmapping1
--

SELECT pg_catalog.setval('public.maps_testarea_id_seq', 2, true);


--
-- Name: topology_id_seq; Type: SEQUENCE SET; Schema: topology; Owner: postgres
--

SELECT pg_catalog.setval('topology.topology_id_seq', 1, false);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: coffee_shops_coffeeshop coffee_shops_coffeeshop_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.coffee_shops_coffeeshop
    ADD CONSTRAINT coffee_shops_coffeeshop_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: maps_location maps_location_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.maps_location
    ADD CONSTRAINT maps_location_pkey PRIMARY KEY (id);


--
-- Name: maps_testarea maps_testarea_pkey; Type: CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.maps_testarea
    ADD CONSTRAINT maps_testarea_pkey PRIMARY KEY (id);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);


--
-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);


--
-- Name: coffee_shops_coffeeshop_location_51562c4b_id; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX coffee_shops_coffeeshop_location_51562c4b_id ON public.coffee_shops_coffeeshop USING gist (location);


--
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


--
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);


--
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: maps_location_point_e17011b7_id; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX maps_location_point_e17011b7_id ON public.maps_location USING gist (point);


--
-- Name: maps_testarea_boundary_9c7a12d9_id; Type: INDEX; Schema: public; Owner: webmapping1
--

CREATE INDEX maps_testarea_boundary_9c7a12d9_id ON public.maps_testarea USING gist (boundary);


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: webmapping1
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--