Fontos üzenetek: 
  • Ha az adatbázis működésében hibát észleltek, kérjük mentsetek róla képernyőképet (Print Screen) és küldjétek el a map@mme.hu e-mail címre, a hiba leírásával együtt!
  • Figyelmetekbe ajánljuk, hogy a Hírek menüpont alatt elérhetőek a MAP-al kapcsolatban írt legfrissebb cikkek, melyek számos praktikus információval szolgálnak!
  • Belépés után ezen az oldalon lehet megtekinteni a gazdával rendelkező 10*10 km-es UTM négyzeteket, táblázatos formában.
  • Ha jelentkezni szeretnétek (többen is!) egy vagy több 10*10 km-es UTM felmérésére, akkor azt az Áttekintő térképen tudjátok megtenni! >>
  • Ha törölnéd magad egy adott négyzet gazdáinak listájából, akkor azt is ott teheted meg. >>
  • További útmutató a táblázat alatt olvasható!

Útmutató

 

Az egyes mezők nevére kattintva sorba lehet rendezni az adatokat, s az alatta lévő kereső mezőkbe írt értékek vagy szövegek alapján szűréseket is végezhetsz, az alábbiak szerint:

  • szöveg típusú (string) adatokat tartalmazó mezők esetén a kereső mezőbe beírt karakterláncot (legyenek azok betűk és/vagy számok) tartalmazó rekordokat jeleníti meg a táblázatban.
  • = : szám vagy dátum típusú adatokat tartalmazó mezők esetén használható, s csak azokat a rekordokat jeleníti meg a táblázatban, melyek pontosan a kereső mezőbe beírt számot vagy dátumot tartalmazzák. Dátum esetén a táblázatban látható formátumban kell a keresett dátumot beírni (YYYY-MM-DD, pl. 2014-04-18)!
  • > és < : szám vagy dátum típusú adatokat tartalmazó mezők esetén használhatóak, s a keresőmezőbe beírt számnál vagy dátumnál nagyobb (>) vagy kisebb (<) értéket tartalmazó rekordokat jeleníti meg. 
  • A táblázat alatti mezőbe írt számmal tudod beállítani, hogy hány sort szeretnél látni egy oldalon. A szám beírása után a (=) jelre kell kattintani.

 

Kérjük, hogy az adatbázissal kapcsolatban felmerülő problémákkal és kérdésekkel fordulj munkatársainkhoz, a map@mme.hu e-mail címen!

(default) 20 queries took 149 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';1691697
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'utm10x10s' AND table_schema = 'public' ORDER BY position5512
3SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'vutm10x10s' AND table_schema = 'public' ORDER BY position557
4SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'helpek' AND table_schema = 'public' ORDER BY position998
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'admins' AND table_schema = 'public' ORDER BY position447
6SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'coordinators' AND table_schema = 'public' ORDER BY position998
7SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbases' AND table_schema = 'public' ORDER BY position21219
8SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'ksh_telepulesek' AND table_schema = 'public' ORDER BY position668
9SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'obobservers' AND table_schema = 'public' ORDER BY position447
10SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observers' AND table_schema = 'public' ORDER BY position557
11SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'obsareas' AND table_schema = 'public' ORDER BY position336
12SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbaseutm25x25s' AND table_schema = 'public' ORDER BY position447
13SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbasevideos' AND table_schema = 'public' ORDER BY position557
14SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbasevoices' AND table_schema = 'public' ORDER BY position557
15SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbaseimages' AND table_schema = 'public' ORDER BY position11118
16SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbasevvmcs' AND table_schema = 'public' ORDER BY position667
17SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'specsummaries' AND table_schema = 'public' ORDER BY position18189
18SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'specdetails' AND table_schema = 'public' ORDER BY position323210
19SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'tokens' AND table_schema = 'public' ORDER BY position557
20SELECT "help"."id" AS "help__id", "help"."controller" AS "help__controller", "help"."action" AS "help__action", "help"."megjegyzes" AS "help__megjegyzes", "help"."helptext_hun" AS "help__helptext_hun", "help"."helptext_eng" AS "help__helptext_eng", "help"."helptext_rou" AS "help__helptext_rou", "help"."align" AS "help__align", "help"."app_id" AS "help__app_id" FROM "helpek" AS "help" WHERE controller = 'utm10x10s' and action = 'showlist' and app_id = 2 221
(auth) 2 queries took 23 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';1691697
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'users' AND table_schema = 'public' ORDER BY position414116