Колдонуучу:OBM

[email protected]
password: nomad80
password Bcrypt: $2y$10$ffasPys/pAdN/L238u8qR.BRefIkjfSzbr7g7SqeFVVcj.z1bU5.m

Hadad_Kyrgyzstan_2023_admin wtqpo6l9hue HadadKG2023_admin rtloa9p2pk hadad_kg_2023_admin ko1mr6f50yq

supervisor:$apr1$hiSqvlzO$dJ58.6Fh6iM0CaP9Q4vIr0

u6FlT45ntxF8DPfQ1AQG19pk3t12nbiX

Iv2EzvMDuN2fGUp-Tdx2KLH2262saWzd
BIOMAPS_POSTGRES_PASSWORD=dZVye8oV1IsOGLUzDQJ_MWo4_6bmBzHK
GISDATA_POSTGRES_PASSWORD=dZVye8oV1IsOGLUzDQJ_MWo4_6bmBzHK

server (container) openbiomaps_biomaps_db_1;
db_name = biomaps
db_user = biomapsadmin
BIOMAPS_DB_PASSWORD=5Al9DAG6yZY4mVJSluvzauMlysJ5k-ZP

MAINPAGE_ADMIN_PASSWORD=AtOn1WM7375J_-G65pGp6GvLSIwqWLdR
SABLON_ADMIN_PASSWORD=RALAyWa7FbztB7uNmDPGmhpHJdP6_SUl
SABLON_HASH=J5AE2l-3 ~

Summary of the species individual observation Recommended

text

map center X 74.8862150 map center Y 42.8734810 EPSG srid 4326

Create new project's logs SQL: 'hadad_kg_2023_admin' created with password 'ko1mr6f50yq' done. This user can connect to the PostgreSQL database. Save this account informations. SQL: Create taxon list function done. SQL: Create taxon name update function done. SQL: Create history function done. SQL error: ERROR: syntax error at or near "&" LINE 19: date&time timestamp without time zone, ^ SET statement_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; CREATE TABLE hadad_kg_2023 ( obm_id integer NOT NULL, obm_geometry geometry, obm_datum timestamp with time zone, obm_uploading_id integer, obm_validation numeric, obm_comments text[], obm_modifier_id integer, obm_files_id character varying(32), species text, date&time timestamp without time zone, Individual ID text, observer full name(s) text, Team ID text, Oblast (Province) text, Place name text, GPS Coordinate N numeric, GPS Coordinate E numeric, Place Altitude numeric, Individual's Gender text, Individual's Age numeric, Individual's Direction (azimuth) numeric, Individual's Porches Quantity integer, Individual's Partner ID text, Nest ID text, Nest Status text, Nest altitude numeric, Nest material text, Nest Level text, Nest exposure text, Nest slope degree integer, Nest size text, Nest eggs quantity integer, Nest chicks quantity integer, Nest Prey Leftovers text, Nest comments text, Weather Status text, Weather Percipitation text, Weather Wind Direction text, Photo-Video Link text, Other Findings text, Summary text, CONSTRAINT enforce_dims_obm_geometry CHECK ((st_ndims(obm_geometry) = 2)), CONSTRAINT enforce_geotype_obm_geometry CHECK (((geometrytype(obm_geometry) = 'POINT'::text) OR (geometrytype(obm_geometry) = 'LINE'::text) OR (geometrytype(obm_geometry) = 'POLYGON'::text) OR (obm_geometry IS NULL))), CONSTRAINT enforce_srid_obm_geometry CHECK ((st_srid(obm_geometry) = 4326)) ); COMMENT ON TABLE hadad_kg_2023 IS 'user defined table:Valaki Valahol'; COMMENT ON COLUMN hadad_kg_2023.Individual's Direction (azimuth) IS 'An azimuth is the direction measured in degrees clockwise from north on an azimuth circle. An azimuth circle consists of 360 degrees. Ninety degrees corresponds to east, 180 degrees is south, 270 degrees is west, and 360 degrees and 0 degrees mark north.'; COMMENT ON COLUMN hadad_kg_2023.Individual's Partner ID IS 'Partners occur usually in pair for reproduction.'; COMMENT ON COLUMN hadad_kg_2023.Nest Level IS 'Upper, middle, lower position relatively to nest holding object such as rock, tree, etc'; COMMENT ON COLUMN hadad_kg_2023.Nest size IS 'may be approximate'; CREATE SEQUENCE hadad_kg_2023_obm_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE hadad_kg_2023_obm_id_seq OWNED BY hadad_kg_2023.obm_id; ALTER TABLE ONLY hadad_kg_2023 ALTER COLUMN obm_id SET DEFAULT nextval('hadad_kg_2023_obm_id_seq'::regclass); ALTER TABLE ONLY hadad_kg_2023 ALTER COLUMN obm_datum SET DEFAULT now(); ALTER TABLE ONLY hadad_kg_2023 ADD CONSTRAINT hadad_kg_2023_pkey PRIMARY KEY (obm_id); CREATE INDEX hadad_kg_2023_obm_geometry_idx ON hadad_kg_2023 USING gist (obm_geometry); CREATE INDEX hadad_kg_2023_obm_uploading_id_idx ON hadad_kg_2023 USING btree (obm_geometry); DROP TRIGGER IF EXISTS history_update_hadad_kg_2023 ON public.hadad_kg_2023; CREATE TRIGGER history_update_hadad_kg_2023 AFTER DELETE OR UPDATE ON hadad_kg_2023 FOR EACH ROW EXECUTE PROCEDURE history_hadad_kg_2023(); ALTER TABLE hadad_kg_2023 DISABLE TRIGGER history_update_hadad_kg_2023; DROP TRIGGER IF EXISTS taxon_update_hadad_kg_2023 ON public.hadad_kg_2023; CREATE TRIGGER taxon_update_hadad_kg_2023 BEFORE INSERT ON hadad_kg_2023 FOR EACH ROW EXECUTE PROCEDURE update_hadad_kg_2023_taxonlist(); ALTER TABLE hadad_kg_2023 DISABLE TRIGGER taxon_update_hadad_kg_2023; CREATE TRIGGER file_connection AFTER INSERT ON hadad_kg_2023 FOR EACH ROW EXECUTE PROCEDURE file_connect_status_update(); ALTER TABLE hadad_kg_2023 DISABLE TRIGGER file_connection; ALTER TABLE ONLY hadad_kg_2023 ADD CONSTRAINT obm_uploading_id FOREIGN KEY (obm_uploading_id) REFERENCES system.uploadings(id); ALTER TABLE public.hadad_kg_2023 OWNER TO hadad_kg_2023_admin;