<commit_before>--
-- GUADALAJARA DEMO DATA
--
-- SQL DUMP: DATA for GUADALAJARA DEMO
--

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;


BEGIN;
--
-- SCOPES DATA
--
COPY dashboard_scopes (id_scope, scope_name, geom, zoom, dbschema, devices_map) FROM stdin;
guadalajara	Guadalajara	SRID=4326;POINT(-3.17819 40.6329)	14	guadalajara	TRUE
\.

--
-- SCOPES/ENTITIES DATA
--
COPY dashboard_scopesentities (id_scope, id_entity) FROM stdin;
guadalajara	MOBA
\.

--
-- CATEGORIES DATA
--
COPY dashboard_categories (id_category, category_name, category_colour) FROM stdin;
waste_ct	Residuos	0062b4
\.

--
-- ENTITIES DATA
--
COPY dashboard_entities (id_entity, entity_name, id_category, id_table, icon) FROM stdin;
MOBA	Contenedores de residuos	waste_ct	guadal_contenedores_definitivo	SC_vehiculo_activo.svg<commit_msg>fixed guadalajara variables<commit_after>--
-- GUADALAJARA DEMO DATA
--
-- SQL DUMP: DATA for GUADALAJARA DEMO
--

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;


BEGIN;
--
-- SCOPES DATA
--
COPY dashboard_scopes (id_scope, scope_name, geom, zoom, dbschema, devices_map) FROM stdin;
guadalajara	Guadalajara	SRID=4326;POINT(-3.17819 40.6329)	14	guadalajara	TRUE
\.

--
-- SCOPES/ENTITIES DATA
--
COPY dashboard_scopesentities (id_scope, id_entity) FROM stdin;
guadalajara	MOBA
\.

--
-- CATEGORIES DATA
--
COPY dashboard_categories (id_category, category_name, category_colour) FROM stdin;
waste_ct	Residuos	3BB078
\.

--
-- ENTITIES DATA
--
COPY dashboard_entities (id_entity, entity_name, id_category, id_table, icon) FROM stdin;
MOBA	Contenedores de residuos	waste_ct	guadal_contenedores_definitivo	SM_contenedor_activo.svg
{'fraction_non_alphanumeric': 0.09564393939393939, 'fraction_numerical': 0.024147727272727272, 'mean_word_length': 4.952112676056338, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3621198', 'n_tokens_mistral': 869, 'n_tokens_neox': 781, 'n_words': 195}