-- -- Table structure for table `group` -- DROP TABLE IF EXISTS `group`; CREATE TABLE `group` ( `id` int(11) NOT NULL auto_increment, `email` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `name_r` varchar(255) NOT NULL default '', `country` varchar(255) NOT NULL default '', `initial_upload_status` varchar(255) NOT NULL default 'no', PRIMARY KEY (`id`), KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='survey group'; -- -- Dumping data for table `group` -- INSERT INTO `group` VALUES (1,'','plants','','KG','skip'); INSERT INTO `group` VALUES (15,'','birds','','KG','no'); INSERT INTO `group` VALUES (16,'','birds','','TJ','no'); INSERT INTO `group` VALUES (2,'','plants','','TJ','skip'); INSERT INTO `group` VALUES (3,'','amphibians','','KG','no'); INSERT INTO `group` VALUES (4,'','amphibians','','TJ','no'); INSERT INTO `group` VALUES (5,'','reptiles','','KG','no'); INSERT INTO `group` VALUES (6,'','reptiles','','TJ','no'); INSERT INTO `group` VALUES (7,'','mammals','','KG','no'); INSERT INTO `group` VALUES (8,'','mammals','','TJ','no'); INSERT INTO `group` VALUES (9,'','fish','','KG','no'); INSERT INTO `group` VALUES (10,'','fish','','TJ','no'); INSERT INTO `group` VALUES (22,'','invertebrates','','KG','no'); INSERT INTO `group` VALUES (21,'','invertebrates','','TJ','no'); -- -- Table structure for table `group_columns` -- DROP TABLE IF EXISTS `group_columns`; CREATE TABLE `group_columns` ( `id` int(11) NOT NULL auto_increment, `group_id` int(11) default NULL, `type` enum('meta','data') default 'data', `column_name` varchar(255) NOT NULL default '', `title` varchar(255) default NULL, `title_r` varchar(255) default NULL, `display_order` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `group_columns` -- INSERT INTO `group_columns` VALUES (26,NULL,'meta','weather_r','Weather (Russian)',NULL,18); INSERT INTO `group_columns` VALUES (3,NULL,'meta','lat_start','Latitude at start',NULL,11); INSERT INTO `group_columns` VALUES (4,NULL,'meta','lon_start','Longitude at start',NULL,12); INSERT INTO `group_columns` VALUES (5,NULL,'meta','date','Date',NULL,2); INSERT INTO `group_columns` VALUES (6,NULL,'meta','start_time','Start time',NULL,4); INSERT INTO `group_columns` VALUES (7,NULL,'meta','end_time','End time',NULL,5); INSERT INTO `group_columns` VALUES (8,NULL,'meta','habitat_description','Description of habitat (English)',NULL,15); INSERT INTO `group_columns` VALUES (9,NULL,'meta','weather','Weather (English)',NULL,17); INSERT INTO `group_columns` VALUES (10,NULL,'meta','researcher','Researcher',NULL,3); INSERT INTO `group_columns` VALUES (11,NULL,'meta','altitude_at_start','Altitude at start (m)',NULL,6); INSERT INTO `group_columns` VALUES (12,NULL,'meta','altitude_at_end','Altitude at end (m)',NULL,7); INSERT INTO `group_columns` VALUES (13,NULL,'meta','transect_length','Length of transect (m)',NULL,8); INSERT INTO `group_columns` VALUES (14,NULL,'meta','site_name','Site name',NULL,1); INSERT INTO `group_columns` VALUES (15,NULL,'data','common_name','Common name',NULL,1); INSERT INTO `group_columns` VALUES (16,NULL,'data','latin_name','Latin name',NULL,2); INSERT INTO `group_columns` VALUES (17,NULL,'data','abundance','Abundance',NULL,3); INSERT INTO `group_columns` VALUES (18,NULL,'data','observation_code','Observation code',NULL,4); INSERT INTO `group_columns` VALUES (19,NULL,'data','lists','Within lists',NULL,5); INSERT INTO `group_columns` VALUES (20,NULL,'data','extra','Outside lists',NULL,6); INSERT INTO `group_columns` VALUES (21,NULL,'data','photo','Photo taken',NULL,8); INSERT INTO `group_columns` VALUES (22,NULL,'data','notes','Notes (English)',NULL,7); INSERT INTO `group_columns` VALUES (23,NULL,'meta','lat_end','Latitude at end',NULL,13); INSERT INTO `group_columns` VALUES (24,NULL,'meta','lon_end','Longitude at end (GPS)',NULL,14); INSERT INTO `group_columns` VALUES (25,NULL,'meta','habitat_description_r','Description of habitat (Russian)',NULL,16); INSERT INTO `group_columns` VALUES (28,3,'data','sex','Sex',NULL,7); INSERT INTO `group_columns` VALUES (27,NULL,'data','notes_r','Notes (Russian)',NULL,7); INSERT INTO `group_columns` VALUES (29,4,'data','sex','Sex',NULL,7); INSERT INTO `group_columns` VALUES (30,3,'data','age','Age',NULL,8); INSERT INTO `group_columns` VALUES (31,4,'data','age','Age',NULL,8); INSERT INTO `group_columns` VALUES (32,21,'data','sex','Sex',NULL,3); INSERT INTO `group_columns` VALUES (33,22,'data','sex','Sex',NULL,3); INSERT INTO `group_columns` VALUES (34,9,'meta','num_sample_sites','No. of sample sites',NULL,10); INSERT INTO `group_columns` VALUES (36,9,'meta','depth','Mean depth',NULL,17); INSERT INTO `group_columns` VALUES (37,10,'meta','depth','Mean depth',NULL,17); INSERT INTO `group_columns` VALUES (38,9,'meta','width','Width',NULL,18); INSERT INTO `group_columns` VALUES (39,10,'meta','width','Width',NULL,18); INSERT INTO `group_columns` VALUES (40,9,'meta','flow_rate','Flow rate',NULL,19); INSERT INTO `group_columns` VALUES (41,10,'meta','flow_rate','Flow rate',NULL,19); INSERT INTO `group_columns` VALUES (42,9,'meta','turbidity','Turbidity',NULL,20); INSERT INTO `group_columns` VALUES (43,10,'meta','turbidity','Turbidity',NULL,20); INSERT INTO `group_columns` VALUES (44,9,'meta','acidity','Acidity',NULL,21); INSERT INTO `group_columns` VALUES (45,10,'meta','acidity','Acidity',NULL,21); INSERT INTO `group_columns` VALUES (46,9,'meta','dissolved_o2','Dissolved oxygen',NULL,22); INSERT INTO `group_columns` VALUES (47,10,'meta','dissolved_o2','Dissolved oxygen',NULL,22); INSERT INTO `group_columns` VALUES (48,9,'meta','temperature','Temperature',NULL,23); INSERT INTO `group_columns` VALUES (49,10,'meta','temperature','Temperature',NULL,23); INSERT INTO `group_columns` VALUES (50,9,'data','sample_site_number','Sample site number',NULL,3); INSERT INTO `group_columns` VALUES (51,10,'data','sample_site_number','Sample site number',NULL,3); INSERT INTO `group_columns` VALUES (52,9,'data','age','Age',NULL,4); INSERT INTO `group_columns` VALUES (53,10,'data','age','Age',NULL,4); INSERT INTO `group_columns` VALUES (54,9,'data','sex','Sex',NULL,5); INSERT INTO `group_columns` VALUES (55,10,'data','sex','Sex',NULL,5); INSERT INTO `group_columns` VALUES (56,9,'data','measurements','Measurements',NULL,6); INSERT INTO `group_columns` VALUES (57,10,'data','measurements','Measurements',NULL,6); INSERT INTO `group_columns` VALUES (58,5,'data','sex','Sex',NULL,7); INSERT INTO `group_columns` VALUES (59,6,'data','sex','Sex',NULL,7); INSERT INTO `group_columns` VALUES (60,5,'data','age','Age',NULL,8); INSERT INTO `group_columns` VALUES (61,6,'data','age','Age',NULL,8); INSERT INTO `group_columns` VALUES (62,1,'data','',NULL,NULL,0); INSERT INTO `group_columns` VALUES (63,2,'data','',NULL,NULL,0); INSERT INTO `group_columns` VALUES (68,7,'data','abundance',NULL,NULL,0); INSERT INTO `group_columns` VALUES (69,8,'data','abundance',NULL,NULL,0); INSERT INTO `group_columns` VALUES (70,9,'data','abundance',NULL,NULL,0); INSERT INTO `group_columns` VALUES (71,10,'data','abundance',NULL,NULL,0); INSERT INTO `group_columns` VALUES (72,15,'data','abundance',NULL,NULL,0); INSERT INTO `group_columns` VALUES (73,16,'data','abundance',NULL,NULL,0); INSERT INTO `group_columns` VALUES (74,19,'data','abundance',NULL,NULL,0); INSERT INTO `group_columns` VALUES (75,20,'data','abundance',NULL,NULL,0); -- -- Table structure for table `map` -- DROP TABLE IF EXISTS `map`; CREATE TABLE `map` ( `id` varchar(255) NOT NULL default '', `filename` varchar(255) NOT NULL default '', `coverage` enum('PATCA-KG','PATCA-TJ','PATCA') NOT NULL default 'PATCA-KG', `source` varchar(255) NOT NULL default '', `description` text NOT NULL, `type` enum('vector','raster') NOT NULL default 'vector', `imported` int(11) NOT NULL default '1', `notes` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `map` -- INSERT INTO `map` VALUES ('m000','m000_patca','PATCA','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m001','m001_patca_kg','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m002','m002_patca_tj','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m003','m003_kg_botanist','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m004','m004_kg_botanist','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m005','m005_kg_botanist','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m006','m006_kg_Tulpar_kol','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m007','m007_kg_Lutra_lutra','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m008a','m008a_kg_Lutra_lutra','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m008b','m008b_kg_Capra_Ovis_reserve','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m009a','m009a_kg_tourism_areas','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m009b','m009b_kg_tourism','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m010','','PATCA-KG','Bernard, annex 2','Proposed Pik Lenin INS','vector',0,''); INSERT INTO `map` VALUES ('m011','','PATCA-KG','Bernard, annex 2','Territory of Chong Alai CAHC','vector',1,''); INSERT INTO `map` VALUES ('m012','','PATCA-TJ','Bernard, annex 2','Preliminary zoning of PATCA Pamir','vector',0,''); INSERT INTO `map` VALUES ('m013','','PATCA-TJ','Bernard, annex 2','Proposed anti-poaching organisation','vector',0,''); INSERT INTO `map` VALUES ('m014','','PATCA-TJ','Bernard, annex 2','Wildlife-rich areas and migration corridors','vector',0,''); INSERT INTO `map` VALUES ('m015','','PATCA-TJ','Bernard, annex 2','Preliminary proposal on ecotourism development','vector',0,''); INSERT INTO `map` VALUES ('m016','m019_kg_Alai_IBA','PATCA-KG','Workshop, Issyk-Kul, February 2008','IBA','vector',0,'data are included in map m019'); INSERT INTO `map` VALUES ('m017','m019_kg_Alai_IBA','PATCA-KG','Workshop, Issyk-Kul, February 2008','IBA','vector',0,'data are included in map m019'); INSERT INTO `map` VALUES ('m018','m019_kg_Alai_IBA','PATCA-KG','Workshop, Issyk-Kul, February 2008','IBA','vector',0,'data are included in map m019'); INSERT INTO `map` VALUES ('m019','m019_kg_Alai_IBA','PATCA-KG','Workshop, Issyk-Kul, February 2008','IBA','vector',1,''); INSERT INTO `map` VALUES ('m020','m020_kg_mineral_deposits','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m021','m021_kg_seasonal_pastures','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m022','m022_tj_Capra_sibirica','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m023','m023_tj_Ursus_arctos','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m024','m024_tj_Uncia_uncia','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m025a','m025a_tj_Marco_polo','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m025b','m025b_tj_Marco_polo','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m026a','m026a_kg_Paralasa','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m026b','m026b_tj_Vipera_lebetina','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m026c','m026c_kg_entomocomplex','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m026d','m026d_kg_Asymblepharus_alaicus','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m027','m027_tj_insecta_teresken','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m028a','m028a_kg_Salmo_trutta_oxianus','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m028b','m028b_kg_insecta','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m028c','m028c_kg_reptiles','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m029a','m029a_kg_insecta','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m029b','m029b_kg_Eremias','PATCA-KG','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m030','m030_tj_forestry','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m031','m031_tj_glaciers','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m032','m032_tj_population','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m033','m032_tj_population','PATCA-TJ','Workshop, Issyk-Kul, February 2008','Poverty','vector',1,'data are included in map m032'); INSERT INTO `map` VALUES ('m034','m034_tj_teresken_use','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m035','m035_tj_alternative_energy','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m036','m036_tj_pastures','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m037','m037_tj_birds_rare','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m038','m038_tj_birds_migration','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m039','m039_tj_birds_iba','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m040','m040_tj_birds_endemic','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m041','','PATCA-TJ','Workshop, Issyk-Kul, February 2008','Pastures','vector',0,''); INSERT INTO `map` VALUES ('m042a','m042a_tj_base_camps','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m042b','m042b_tj_meta_guesthouse','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m042c','m042c_tj_meta_yurt_camp','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m043','m043_tj_poaching','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m044a','m044a_tj_hunting_concession','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m044b','m044b_tj_hunting_camps','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m045','','PATCA-TJ','Workshop, Issyk-Kul, February 2008','Proposed tourism circuits','vector',0,''); INSERT INTO `map` VALUES ('m046','m046_tj_cultural','PATCA-TJ','Workshop, Issyk-Kul, February 2008','','vector',1,''); INSERT INTO `map` VALUES ('m047','','PATCA-KG','Workshop, Issyk-Kul, February 2008','Toktoraliev/Asykulov 1 - zonation','vector',0,''); INSERT INTO `map` VALUES ('m048','','PATCA-KG','Workshop, Issyk-Kul, February 2008','Milko/Eremchenko 1','vector',0,''); INSERT INTO `map` VALUES ('m049','','PATCA-KG','Workshop, Issyk-Kul, February 2008','Milko/Eremchenko 2','vector',1,''); INSERT INTO `map` VALUES ('m050','','PATCA-KG','Workshop, Issyk-Kul, February 2008','Toktoraliev/Asykulov 2 - recreation zones','vector',0,''); INSERT INTO `map` VALUES ('m051','','PATCA-KG','Workshop, Issyk-Kul, February 2008','botanists zoning','vector',1,''); INSERT INTO `map` VALUES ('m052','m052_kg_zoning_birds','PATCA-KG','Workshop, Issyk-Kul, February 2008','Kulagin birds zoning','vector',1,''); INSERT INTO `map` VALUES ('m053','m053_kg_birds','PATCA-KG','Workshop, Issyk-Kul, February 2008','GPS bird locations','vector',1,'no species data in map - need to match to survey data in BIMS'); INSERT INTO `map` VALUES ('m054','','PATCA-KG','Workshop, Issyk-Kul, February 2008','Geobotanic map','vector',0,'not imported from image'); INSERT INTO `map` VALUES ('m055','','PATCA-TJ','Workshop, Issyk-Kul, February 2008','Ecosystems map','vector',0,'not imported from image'); INSERT INTO `map` VALUES ('m056','m056_kg_main_roads','PATCA-KG','West Tien Shan GIS workshop','','vector',1,''); INSERT INTO `map` VALUES ('m057','m057_kg_main_rivers','PATCA-KG','West Tien Shan GIS workshop','','vector',1,''); INSERT INTO `map` VALUES ('m058','m058_kg_lakes','PATCA-KG','West Tien Shan GIS workshop','','vector',1,''); INSERT INTO `map` VALUES ('m059','m059_kg_rayon','PATCA-KG','West Tien Shan GIS workshop','','vector',1,''); INSERT INTO `map` VALUES ('m060','m060_patca_landmarks','PATCA','Digitised from Russian topographic maps','','vector',1,''); INSERT INTO `map` VALUES ('m061','m061_tj_roads','PATCA-TJ','CDE','','vector',1,''); INSERT INTO `map` VALUES ('m062','m062_tj_rivers','PATCA-TJ','CDE','','vector',1,''); INSERT INTO `map` VALUES ('m063','m063_tj_main_lakes','PATCA-TJ','CDE','','vector',1,''); INSERT INTO `map` VALUES ('m064','m064_tj_rayon','PATCA-TJ','CDE','','vector',1,''); INSERT INTO `map` VALUES ('m065','','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 1','raster',0,'not imported from raw'); INSERT INTO `map` VALUES ('m066','m066_etm_band2','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 2','raster',1,''); INSERT INTO `map` VALUES ('m067','m067_etm_band3','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 3','raster',1,''); INSERT INTO `map` VALUES ('m068','m068_etm_band4','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 4','raster',1,''); INSERT INTO `map` VALUES ('m069','','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 5','raster',0,'not imported from raw'); INSERT INTO `map` VALUES ('m070','','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 6 (high gain)','raster',0,'not imported from raw'); INSERT INTO `map` VALUES ('m071','','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 6 (high gain)','raster',0,'not imported from raw'); INSERT INTO `map` VALUES ('m072','','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 7','raster',0,'not imported from raw'); INSERT INTO `map` VALUES ('m073','','PATCA','ftp://ftp.glcf.umiacs.umd.edu','Landsat ETM band 8','raster',0,'not imported from raw'); INSERT INTO `map` VALUES ('m074','m074_etm_432','PATCA','BIMS Expert mission, Aug-Sept 2007','Landsat composite 432','raster',1,''); INSERT INTO `map` VALUES ('m075','m075_ndvi','PATCA','BIMS Expert mission, May-June 2007','NDVI derived from Landsat','raster',1,''); INSERT INTO `map` VALUES ('m076','m076_landcover_smap.tif.gz','PATCA','BIMS Expert mission, Aug-Sept 2007','Landcover model','raster',1,''); INSERT INTO `map` VALUES ('m077','m077_srtm','PATCA','http://srtm.csi.cgiar.org','SRTM digital elevation','raster',1,''); INSERT INTO `map` VALUES ('m078','map_4206.tif','PATCA','CDE','Scanned, georectified Russian topographic maps, map 4206','raster',1,''); INSERT INTO `map` VALUES ('m079','map_4301.tif','PATCA','CDE','Scanned, georectified Russian topographic maps, map 4301','raster',1,''); INSERT INTO `map` VALUES ('m080','map_4302.tif','PATCA','CDE','Scanned, georectified Russian topographic maps, map 4302','raster',1,''); INSERT INTO `map` VALUES ('m081','map_4303.tif','PATCA-KG','CDE','Scanned, georectified Russian topographic maps, map 4303','raster',0,''); INSERT INTO `map` VALUES ('m082','map_4212.tif','PATCA','CDE','Scanned, georectified Russian topographic maps, map 4212','raster',1,''); INSERT INTO `map` VALUES ('m083','map_4307.tif','PATCA','CDE','Scanned, georectified Russian topographic maps, map 4307','raster',1,''); INSERT INTO `map` VALUES ('m085','map_4308.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4308','raster',1,''); INSERT INTO `map` VALUES ('m086','map_4309.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4309','raster',0,''); INSERT INTO `map` VALUES ('m087','map_4313.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4313','raster',1,''); INSERT INTO `map` VALUES ('m088','map_4314.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4314','raster',1,''); INSERT INTO `map` VALUES ('m089','map_4315.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4315','raster',0,''); INSERT INTO `map` VALUES ('m090','map_4224.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4224','raster',0,''); INSERT INTO `map` VALUES ('m091','map_4319.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4319','raster',0,''); INSERT INTO `map` VALUES ('m092','map_4320.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4320','raster',0,''); INSERT INTO `map` VALUES ('m093','map_4321.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4321','raster',0,''); INSERT INTO `map` VALUES ('m094','map_4322.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4322','raster',0,''); INSERT INTO `map` VALUES ('m095','map_4230.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4230','raster',0,''); INSERT INTO `map` VALUES ('m096','map_4325.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4325','raster',0,''); INSERT INTO `map` VALUES ('m097','map_4326.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4326','raster',0,''); INSERT INTO `map` VALUES ('m098','map_4327.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4327','raster',0,''); INSERT INTO `map` VALUES ('m099','map_4328.tif','PATCA-TJ','CDE','Scanned, georectified Russian topographic maps, map 4328','raster',0,''); INSERT INTO `map` VALUES ('m100','m100_survey','PATCA','BIMS Expert mission, Aug-Sept 2007','GPS landcover survey points, with landcover class','vector',1,''); INSERT INTO `map` VALUES ('m101','m101_landcover_sample','PATCA','BIMS Expert mission, Aug-Sept 2007','Sample landcover polygons for landcover classification','vector',1,''); INSERT INTO `map` VALUES ('m102','m102_gns_patca','PATCA','US-NGA GEOnet Names Server (GNS) country files for KG and TJ','Placenames and attributes','vector',1,''); INSERT INTO `map` VALUES ('m103','','PATCA-KG','Workshop, Issyk-Kul, February 2008','mammal zoning map','vector',0,'used to be m087'); -- -- Table structure for table `map_attribute` -- DROP TABLE IF EXISTS `map_attribute`; CREATE TABLE `map_attribute` ( `id` int(11) NOT NULL auto_increment, `map_id` varchar(255) NOT NULL default '', `attribute` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `map_id` (`map_id`), KEY `attribute` (`attribute`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `map_attribute` -- INSERT INTO `map_attribute` VALUES (1,'m000','boundary'); INSERT INTO `map_attribute` VALUES (2,'m001','boundary'); INSERT INTO `map_attribute` VALUES (3,'m002','boundary'); INSERT INTO `map_attribute` VALUES (4,'m003','biodiversity'); INSERT INTO `map_attribute` VALUES (5,'m004','biodiversity'); INSERT INTO `map_attribute` VALUES (6,'m005','biodiversity'); INSERT INTO `map_attribute` VALUES (7,'m006','biodiversity'); INSERT INTO `map_attribute` VALUES (8,'m007','biodiversity'); INSERT INTO `map_attribute` VALUES (9,'m008a','biodiversity'); INSERT INTO `map_attribute` VALUES (10,'m008b','biodiversity'); INSERT INTO `map_attribute` VALUES (11,'m009a','tourism'); INSERT INTO `map_attribute` VALUES (12,'m009b','tourism'); INSERT INTO `map_attribute` VALUES (13,'m010','zoning'); INSERT INTO `map_attribute` VALUES (14,'m011','resources'); INSERT INTO `map_attribute` VALUES (15,'m012','zoning'); INSERT INTO `map_attribute` VALUES (16,'m013','zoning'); INSERT INTO `map_attribute` VALUES (17,'m014','biodiversity'); INSERT INTO `map_attribute` VALUES (18,'m015','tourism'); INSERT INTO `map_attribute` VALUES (19,'m016','biodiversity'); INSERT INTO `map_attribute` VALUES (20,'m017','biodiversity'); INSERT INTO `map_attribute` VALUES (21,'m018','biodiversity'); INSERT INTO `map_attribute` VALUES (22,'m019','biodiversity'); INSERT INTO `map_attribute` VALUES (23,'m020','resources'); INSERT INTO `map_attribute` VALUES (24,'m021','resources'); INSERT INTO `map_attribute` VALUES (25,'m022','biodiversity'); INSERT INTO `map_attribute` VALUES (26,'m023','biodiversity'); INSERT INTO `map_attribute` VALUES (27,'m024','biodiversity'); INSERT INTO `map_attribute` VALUES (28,'m025a','biodiversity'); INSERT INTO `map_attribute` VALUES (29,'m025b','biodiversity'); INSERT INTO `map_attribute` VALUES (30,'m026a','biodiversity'); INSERT INTO `map_attribute` VALUES (31,'m026b','biodiversity'); INSERT INTO `map_attribute` VALUES (32,'m026c','biodiversity'); INSERT INTO `map_attribute` VALUES (33,'m026d','biodiversity'); INSERT INTO `map_attribute` VALUES (34,'m027','biodiversity'); INSERT INTO `map_attribute` VALUES (35,'m028a','biodiversity'); INSERT INTO `map_attribute` VALUES (36,'m028b','biodiversity'); INSERT INTO `map_attribute` VALUES (37,'m028c','biodiversity'); INSERT INTO `map_attribute` VALUES (38,'m029a','biodiversity'); INSERT INTO `map_attribute` VALUES (39,'m029b','biodiversity'); INSERT INTO `map_attribute` VALUES (40,'m030','resources'); INSERT INTO `map_attribute` VALUES (41,'m031','resources'); INSERT INTO `map_attribute` VALUES (42,'m032','socio-economic'); INSERT INTO `map_attribute` VALUES (43,'m033','socio-economic'); INSERT INTO `map_attribute` VALUES (44,'m034','resources'); INSERT INTO `map_attribute` VALUES (45,'m035','resources'); INSERT INTO `map_attribute` VALUES (46,'m036','resources'); INSERT INTO `map_attribute` VALUES (47,'m037','biodiversity'); INSERT INTO `map_attribute` VALUES (48,'m038','biodiversity'); INSERT INTO `map_attribute` VALUES (49,'m039','biodiversity'); INSERT INTO `map_attribute` VALUES (50,'m040','biodiversity'); INSERT INTO `map_attribute` VALUES (51,'m041','resources'); INSERT INTO `map_attribute` VALUES (52,'m042a','tourism'); INSERT INTO `map_attribute` VALUES (53,'m042b','tourism'); INSERT INTO `map_attribute` VALUES (54,'m042c','tourism'); INSERT INTO `map_attribute` VALUES (55,'m043','resources'); INSERT INTO `map_attribute` VALUES (56,'m044a','resources'); INSERT INTO `map_attribute` VALUES (57,'m044b','resources'); INSERT INTO `map_attribute` VALUES (58,'m045','tourism'); INSERT INTO `map_attribute` VALUES (59,'m046','tourism'); INSERT INTO `map_attribute` VALUES (60,'m047','zoning'); INSERT INTO `map_attribute` VALUES (61,'m048','zoning'); INSERT INTO `map_attribute` VALUES (62,'m049','zoning'); INSERT INTO `map_attribute` VALUES (63,'m050','zoning'); INSERT INTO `map_attribute` VALUES (64,'m051','zoning'); INSERT INTO `map_attribute` VALUES (65,'m052','zoning'); INSERT INTO `map_attribute` VALUES (66,'m053','biodiversity'); INSERT INTO `map_attribute` VALUES (67,'m054','landcover'); INSERT INTO `map_attribute` VALUES (68,'m055','landcover'); INSERT INTO `map_attribute` VALUES (69,'m056','features'); INSERT INTO `map_attribute` VALUES (70,'m057','features'); INSERT INTO `map_attribute` VALUES (71,'m058','features'); INSERT INTO `map_attribute` VALUES (72,'m059','boundary'); INSERT INTO `map_attribute` VALUES (73,'m060','features'); INSERT INTO `map_attribute` VALUES (74,'m061','features'); INSERT INTO `map_attribute` VALUES (75,'m062','features'); INSERT INTO `map_attribute` VALUES (76,'m063','features'); INSERT INTO `map_attribute` VALUES (77,'m064','boundary'); INSERT INTO `map_attribute` VALUES (78,'m065','satellite'); INSERT INTO `map_attribute` VALUES (79,'m066','satellite'); INSERT INTO `map_attribute` VALUES (80,'m067','satellite'); INSERT INTO `map_attribute` VALUES (81,'m068','satellite'); INSERT INTO `map_attribute` VALUES (82,'m069','satellite'); INSERT INTO `map_attribute` VALUES (83,'m070','satellite'); INSERT INTO `map_attribute` VALUES (84,'m071','satellite'); INSERT INTO `map_attribute` VALUES (85,'m072','satellite'); INSERT INTO `map_attribute` VALUES (86,'m073','satellite'); INSERT INTO `map_attribute` VALUES (87,'m074','satellite'); INSERT INTO `map_attribute` VALUES (88,'m075','satellite'); INSERT INTO `map_attribute` VALUES (89,'m076','landcover'); INSERT INTO `map_attribute` VALUES (90,'m077','satellite'); INSERT INTO `map_attribute` VALUES (91,'m078','topo'); INSERT INTO `map_attribute` VALUES (92,'m079','topo'); INSERT INTO `map_attribute` VALUES (93,'m080','topo'); INSERT INTO `map_attribute` VALUES (94,'m081','topo'); INSERT INTO `map_attribute` VALUES (95,'m082','topo'); INSERT INTO `map_attribute` VALUES (96,'m083','topo'); INSERT INTO `map_attribute` VALUES (97,'m085','topo'); INSERT INTO `map_attribute` VALUES (98,'m086','topo'); INSERT INTO `map_attribute` VALUES (99,'m087','topo'); INSERT INTO `map_attribute` VALUES (100,'m088','topo'); INSERT INTO `map_attribute` VALUES (101,'m089','topo'); INSERT INTO `map_attribute` VALUES (102,'m090','topo'); INSERT INTO `map_attribute` VALUES (103,'m091','topo'); INSERT INTO `map_attribute` VALUES (104,'m092','topo'); INSERT INTO `map_attribute` VALUES (105,'m093','topo'); INSERT INTO `map_attribute` VALUES (106,'m094','topo'); INSERT INTO `map_attribute` VALUES (107,'m095','topo'); INSERT INTO `map_attribute` VALUES (108,'m096','topo'); INSERT INTO `map_attribute` VALUES (109,'m097','topo'); INSERT INTO `map_attribute` VALUES (110,'m098','topo'); INSERT INTO `map_attribute` VALUES (111,'m099','topo'); INSERT INTO `map_attribute` VALUES (112,'m100','landcover'); INSERT INTO `map_attribute` VALUES (113,'m101','landcover'); INSERT INTO `map_attribute` VALUES (114,'m102','features'); INSERT INTO `map_attribute` VALUES (115,'m103','zoning'); INSERT INTO `map_attribute` VALUES (119,'m003','plants'); INSERT INTO `map_attribute` VALUES (120,'m004','plants'); INSERT INTO `map_attribute` VALUES (121,'m005','plants'); INSERT INTO `map_attribute` VALUES (122,'m006','mammals'); INSERT INTO `map_attribute` VALUES (123,'m007','mammals'); INSERT INTO `map_attribute` VALUES (124,'m008a','mammals'); INSERT INTO `map_attribute` VALUES (125,'m008b','mammals'); INSERT INTO `map_attribute` VALUES (134,'m016','birds'); INSERT INTO `map_attribute` VALUES (135,'m017','birds'); INSERT INTO `map_attribute` VALUES (136,'m018','birds'); INSERT INTO `map_attribute` VALUES (137,'m019','birds'); INSERT INTO `map_attribute` VALUES (140,'m022','mammals'); INSERT INTO `map_attribute` VALUES (141,'m023','mammals'); INSERT INTO `map_attribute` VALUES (142,'m024','mammals'); INSERT INTO `map_attribute` VALUES (143,'m025a','mammals'); INSERT INTO `map_attribute` VALUES (144,'m025b','mammals'); INSERT INTO `map_attribute` VALUES (145,'m026a','invertebrates'); INSERT INTO `map_attribute` VALUES (146,'m026b','reptiles'); INSERT INTO `map_attribute` VALUES (147,'m026c','invertebrates'); INSERT INTO `map_attribute` VALUES (148,'m026d','reptiles'); INSERT INTO `map_attribute` VALUES (149,'m027','invertebrates'); INSERT INTO `map_attribute` VALUES (150,'m028a','fish'); INSERT INTO `map_attribute` VALUES (151,'m028b','invertebrates'); INSERT INTO `map_attribute` VALUES (152,'m028c','reptiles'); INSERT INTO `map_attribute` VALUES (153,'m029a','invertebrates'); INSERT INTO `map_attribute` VALUES (154,'m029b','reptiles'); INSERT INTO `map_attribute` VALUES (162,'m037','birds'); INSERT INTO `map_attribute` VALUES (163,'m038','birds'); INSERT INTO `map_attribute` VALUES (164,'m039','birds'); INSERT INTO `map_attribute` VALUES (165,'m040','birds'); INSERT INTO `map_attribute` VALUES (181,'m053','birds'); INSERT INTO `map_attribute` VALUES (182,'m054','plants'); INSERT INTO `map_attribute` VALUES (230,'m103','mammals'); -- -- Table structure for table `message` -- DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `id` int(11) NOT NULL auto_increment, `english` text NOT NULL, `russian` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `message` -- INSERT INTO `message` VALUES (1,'test',''); INSERT INTO `message` VALUES (2,'Error - file not found',''); INSERT INTO `message` VALUES (3,'The requested document %s was not found.',''); INSERT INTO `message` VALUES (4,'Please inform the maintainer of the refering page %s that the link is broken.',''); INSERT INTO `message` VALUES (5,'Please check the URL.',''); INSERT INTO `message` VALUES (6,'Upload a file',''); INSERT INTO `message` VALUES (7,'File upload status',''); INSERT INTO `message` VALUES (8,'Raw survey data',''); INSERT INTO `message` VALUES (9,'Blank worksheets',''); INSERT INTO `message` VALUES (10,'PATCA BIMS',''); INSERT INTO `message` VALUES (11,'Pamir-Alai Transboundary Conservancy Area - Biodiversity Information Management System',''); INSERT INTO `message` VALUES (12,'In the species lists, black indicates the species occurs in both Tajikistan and Kyrgyzstan, red indicates the species occurs only in Kyrgyzstan, and green indicates the species occurs only in Tajikistan.',''); INSERT INTO `message` VALUES (13,'Data sheets for recording field observations',''); INSERT INTO `message` VALUES (14,'Excel worksheets for transcribing field data',''); INSERT INTO `message` VALUES (16,'Diagrams',''); INSERT INTO `message` VALUES (17,'Schematic of the BIS architecture',''); INSERT INTO `message` VALUES (18,'Data collection workflow ',''); INSERT INTO `message` VALUES (19,'Database status',''); INSERT INTO `message` VALUES (20,'View surveys',''); INSERT INTO `message` VALUES (21,'Survey data',''); INSERT INTO `message` VALUES (22,'Survey meta',''); INSERT INTO `message` VALUES (23,'View survey data',''); INSERT INTO `message` VALUES (24,'View survey meta',''); INSERT INTO `message` VALUES (25,'Generate MacKinnon lists',''); INSERT INTO `message` VALUES (26,'MacKinnon lists',''); INSERT INTO `message` VALUES (27,'Meta',''); INSERT INTO `message` VALUES (28,'Data',''); INSERT INTO `message` VALUES (29,'Lists',''); INSERT INTO `message` VALUES (30,'Help',''); INSERT INTO `message` VALUES (31,'This website is used to upload survey results from the PATCA project baseline biodiversity studies. ',''); INSERT INTO `message` VALUES (32,'To contribute data to the site, field records should be transcribed into the appropriate blank worksheet for your group.',''); INSERT INTO `message` VALUES (33,'Blank worksheets are available here.',''); INSERT INTO `message` VALUES (34,'Survey teams',''); INSERT INTO `message` VALUES (35,'Completed worksheets should be delivered to the PATCA office in Bishkek, either via email, or as hard copy.',''); INSERT INTO `message` VALUES (36,'Data transcription',''); INSERT INTO `message` VALUES (37,'Worksheets delivered to the PATCA office should be transcribed into the appropriate blank Excel worksheet for the group.',''); INSERT INTO `message` VALUES (38,'Blank Excel worksheets are available here.',''); INSERT INTO `message` VALUES (39,'Note that each Excel file contains 2 worksheets - one for survey metadata (the \'meta\' sheet), and one for survey records (the \'data\' sheet).',''); INSERT INTO `message` VALUES (40,'Completed Excel worksheets should be uploaded using the file upload page.',''); INSERT INTO `message` VALUES (41,'You will need a password to use the upload page - please get in touch with the site administrator, David Baird - d a v e @ z e r o f i v e . c o . u k',''); INSERT INTO `message` VALUES (42,'Problems',''); INSERT INTO `message` VALUES (43,'If you have any problems with using this site, please email d a v e @ z e r o f i v e . c o . u k',''); INSERT INTO `message` VALUES (44,'I\'m sorry for the inconvenience, but emails must be in English!',''); INSERT INTO `message` VALUES (45,'Survey ID',''); INSERT INTO `message` VALUES (46,'Browse database records',''); INSERT INTO `message` VALUES (47,'Workshop May 2007',''); INSERT INTO `message` VALUES (48,'A workshop was held in Bishkek in May 2007 to discuss biodiversity sampling methods. Presentations from the workshop are available here, in English and Russian, and in PDF and PowerPoint formats.',''); INSERT INTO `message` VALUES (49,'PDF',''); INSERT INTO `message` VALUES (50,'PowerPoint',''); INSERT INTO `message` VALUES (51,'Russian',''); INSERT INTO `message` VALUES (52,'English',''); INSERT INTO `message` VALUES (53,'Introduction to baseline studies',''); INSERT INTO `message` VALUES (54,'Biodiversity Rapid Assessment Techniques: MacKinnon Lists',''); INSERT INTO `message` VALUES (55,'MacKinnon Lists: Collecting field data and practical uses of results',''); INSERT INTO `message` VALUES (56,'On constructing a PATCA baseline information system',''); -- -- Table structure for table `survey` -- DROP TABLE IF EXISTS `survey`; CREATE TABLE `survey` ( `id` int(11) NOT NULL auto_increment, `group_id` int(11) NOT NULL default '0', `upload_dt` datetime default NULL, `loaded` enum('no','skip','yes','error','locked') default 'no', PRIMARY KEY (`id`), KEY `group_id` (`group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `survey` -- INSERT INTO `survey` VALUES (175,16,'2007-09-06 17:42:44','yes'); INSERT INTO `survey` VALUES (174,16,'2007-09-06 17:41:58','yes'); INSERT INTO `survey` VALUES (173,16,'2007-09-06 17:41:22','yes'); INSERT INTO `survey` VALUES (172,16,'2007-09-06 17:40:45','yes'); INSERT INTO `survey` VALUES (171,16,'2007-09-06 17:39:56','yes'); INSERT INTO `survey` VALUES (474,16,'2008-04-11 13:22:17','yes'); INSERT INTO `survey` VALUES (476,16,'2008-04-11 13:22:35','yes'); INSERT INTO `survey` VALUES (168,16,'2007-09-06 17:34:01','yes'); INSERT INTO `survey` VALUES (167,16,'2007-09-06 17:33:14','yes'); INSERT INTO `survey` VALUES (475,16,'2008-04-11 13:22:26','yes'); INSERT INTO `survey` VALUES (165,16,'2007-09-06 17:30:22','yes'); INSERT INTO `survey` VALUES (164,15,'2007-09-05 15:23:57','yes'); INSERT INTO `survey` VALUES (163,15,'2007-09-05 15:23:37','yes'); INSERT INTO `survey` VALUES (162,22,'2007-09-05 15:20:03','yes'); INSERT INTO `survey` VALUES (161,22,'2007-09-05 15:19:35','yes'); INSERT INTO `survey` VALUES (160,22,'2007-09-05 15:18:58','yes'); INSERT INTO `survey` VALUES (159,22,'2007-09-05 15:18:04','yes'); INSERT INTO `survey` VALUES (158,22,'2007-09-05 15:17:14','yes'); INSERT INTO `survey` VALUES (157,22,'2007-09-05 15:16:42','yes'); INSERT INTO `survey` VALUES (156,22,'2007-09-05 15:13:25','yes'); INSERT INTO `survey` VALUES (155,22,'2007-09-05 15:12:19','yes'); INSERT INTO `survey` VALUES (154,8,'2007-09-03 08:01:28','yes'); INSERT INTO `survey` VALUES (153,8,'2007-09-03 08:00:48','yes'); INSERT INTO `survey` VALUES (152,8,'2007-09-03 07:56:23','yes'); INSERT INTO `survey` VALUES (151,8,'2007-09-03 07:53:52','yes'); INSERT INTO `survey` VALUES (412,7,'2008-04-03 11:25:51','yes'); INSERT INTO `survey` VALUES (413,7,'2008-04-03 11:26:00','yes'); INSERT INTO `survey` VALUES (414,8,'2008-04-03 11:26:13','yes'); INSERT INTO `survey` VALUES (147,15,'2007-08-31 11:53:01','yes'); INSERT INTO `survey` VALUES (431,15,'2008-04-04 07:11:42','yes'); INSERT INTO `survey` VALUES (432,15,'2008-04-04 07:11:51','yes'); INSERT INTO `survey` VALUES (144,15,'2007-08-31 11:48:01','yes'); INSERT INTO `survey` VALUES (143,15,'2007-08-31 11:47:19','yes'); INSERT INTO `survey` VALUES (433,15,'2008-04-04 07:12:09','yes'); INSERT INTO `survey` VALUES (141,15,'2007-08-31 11:46:21','yes'); INSERT INTO `survey` VALUES (140,15,'2007-08-31 11:39:12','yes'); INSERT INTO `survey` VALUES (139,15,'2007-08-31 11:38:24','yes'); INSERT INTO `survey` VALUES (138,15,'2007-08-31 11:37:38','yes'); INSERT INTO `survey` VALUES (434,15,'2008-04-04 07:12:24','yes'); INSERT INTO `survey` VALUES (136,15,'2007-08-31 11:35:55','yes'); INSERT INTO `survey` VALUES (462,15,'2008-04-11 13:08:02','yes'); INSERT INTO `survey` VALUES (435,15,'2008-04-04 07:12:33','yes'); INSERT INTO `survey` VALUES (437,15,'2008-04-04 07:13:56','yes'); INSERT INTO `survey` VALUES (132,15,'2007-08-31 11:27:48','yes'); INSERT INTO `survey` VALUES (438,15,'2008-04-04 07:14:05','yes'); INSERT INTO `survey` VALUES (439,15,'2008-04-04 07:14:24','yes'); INSERT INTO `survey` VALUES (466,15,'2008-04-11 13:11:51','yes'); INSERT INTO `survey` VALUES (59,22,'2007-08-14 08:54:28','yes'); INSERT INTO `survey` VALUES (60,22,'2007-08-14 08:54:53','yes'); INSERT INTO `survey` VALUES (61,22,'2007-08-14 08:55:30','yes'); INSERT INTO `survey` VALUES (62,22,'2007-08-14 08:55:58','yes'); INSERT INTO `survey` VALUES (63,22,'2007-08-14 08:56:23','yes'); INSERT INTO `survey` VALUES (64,22,'2007-08-14 08:57:07','yes'); INSERT INTO `survey` VALUES (65,22,'2007-08-14 08:57:37','yes'); INSERT INTO `survey` VALUES (66,22,'2007-08-14 08:58:04','yes'); INSERT INTO `survey` VALUES (67,22,'2007-08-14 08:58:30','yes'); INSERT INTO `survey` VALUES (68,22,'2007-08-14 08:58:59','yes'); INSERT INTO `survey` VALUES (69,22,'2007-08-14 08:59:31','yes'); INSERT INTO `survey` VALUES (70,22,'2007-08-14 08:59:59','yes'); INSERT INTO `survey` VALUES (71,22,'2007-08-14 09:00:22','yes'); INSERT INTO `survey` VALUES (72,7,'2007-08-29 12:02:21','yes'); INSERT INTO `survey` VALUES (73,7,'2007-08-29 12:03:10','yes'); INSERT INTO `survey` VALUES (74,7,'2007-08-29 12:04:00','yes'); INSERT INTO `survey` VALUES (75,7,'2007-08-29 12:04:38','yes'); INSERT INTO `survey` VALUES (76,7,'2007-08-29 12:05:36','yes'); INSERT INTO `survey` VALUES (77,7,'2007-08-29 12:06:39','yes'); INSERT INTO `survey` VALUES (78,7,'2007-08-29 12:07:58','yes'); INSERT INTO `survey` VALUES (79,7,'2007-08-29 12:08:51','yes'); INSERT INTO `survey` VALUES (80,7,'2007-08-29 12:10:31','yes'); INSERT INTO `survey` VALUES (81,7,'2007-08-29 12:12:17','yes'); INSERT INTO `survey` VALUES (420,8,'2008-04-03 11:27:11','yes'); INSERT INTO `survey` VALUES (83,7,'2007-08-29 12:14:45','yes'); INSERT INTO `survey` VALUES (84,7,'2007-08-29 12:15:10','yes'); INSERT INTO `survey` VALUES (419,8,'2008-04-03 11:27:02','yes'); INSERT INTO `survey` VALUES (86,7,'2007-08-29 12:17:29','yes'); INSERT INTO `survey` VALUES (87,7,'2007-08-29 12:18:39','yes'); INSERT INTO `survey` VALUES (418,8,'2008-04-03 11:26:52','yes'); INSERT INTO `survey` VALUES (417,8,'2008-04-03 11:26:43','yes'); INSERT INTO `survey` VALUES (90,7,'2007-08-29 12:22:20','yes'); INSERT INTO `survey` VALUES (467,15,'2008-04-11 13:14:52','yes'); INSERT INTO `survey` VALUES (92,15,'2007-08-29 12:25:11','yes'); INSERT INTO `survey` VALUES (93,15,'2007-08-29 12:25:30','yes'); INSERT INTO `survey` VALUES (94,15,'2007-08-29 12:26:30','yes'); INSERT INTO `survey` VALUES (425,15,'2008-04-04 07:07:31','yes'); INSERT INTO `survey` VALUES (477,16,'2008-04-11 13:22:45','yes'); INSERT INTO `survey` VALUES (423,15,'2008-04-04 07:07:10','yes'); INSERT INTO `survey` VALUES (422,15,'2008-04-04 07:06:59','yes'); INSERT INTO `survey` VALUES (421,15,'2008-04-04 07:06:47','yes'); INSERT INTO `survey` VALUES (100,15,'2007-08-29 12:29:09','yes'); INSERT INTO `survey` VALUES (436,15,'2008-04-04 07:13:11','yes'); INSERT INTO `survey` VALUES (102,7,'2007-08-29 12:33:24','yes'); INSERT INTO `survey` VALUES (103,7,'2007-08-29 12:34:21','yes'); INSERT INTO `survey` VALUES (416,8,'2008-04-03 11:26:33','yes'); INSERT INTO `survey` VALUES (105,7,'2007-08-29 12:35:40','yes'); INSERT INTO `survey` VALUES (106,7,'2007-08-29 12:36:10','yes'); INSERT INTO `survey` VALUES (107,7,'2007-08-29 12:37:20','yes'); INSERT INTO `survey` VALUES (108,7,'2007-08-29 12:37:48','yes'); INSERT INTO `survey` VALUES (109,7,'2007-08-29 12:38:21','yes'); INSERT INTO `survey` VALUES (110,7,'2007-08-29 12:39:21','yes'); INSERT INTO `survey` VALUES (111,7,'2007-08-29 12:40:19','yes'); INSERT INTO `survey` VALUES (112,7,'2007-08-29 12:41:22','yes'); INSERT INTO `survey` VALUES (113,7,'2007-08-29 12:41:48','yes'); INSERT INTO `survey` VALUES (114,7,'2007-08-29 12:43:05','yes'); INSERT INTO `survey` VALUES (115,7,'2007-08-29 12:43:25','yes'); INSERT INTO `survey` VALUES (460,15,'2008-04-11 13:07:37','yes'); INSERT INTO `survey` VALUES (426,15,'2008-04-04 07:09:26','yes'); INSERT INTO `survey` VALUES (297,15,'2008-02-10 22:36:03','yes'); INSERT INTO `survey` VALUES (456,15,'2008-04-11 12:52:25','yes'); INSERT INTO `survey` VALUES (463,15,'2008-04-11 13:08:12','yes'); INSERT INTO `survey` VALUES (294,15,'2008-02-10 22:34:40','yes'); INSERT INTO `survey` VALUES (293,15,'2008-02-10 22:34:16','yes'); INSERT INTO `survey` VALUES (292,15,'2008-02-10 22:33:52','yes'); INSERT INTO `survey` VALUES (465,15,'2008-04-11 13:09:41','yes'); INSERT INTO `survey` VALUES (461,15,'2008-04-11 13:07:48','yes'); INSERT INTO `survey` VALUES (430,15,'2008-04-04 07:10:07','yes'); INSERT INTO `survey` VALUES (279,1,'2007-11-11 12:26:46','skip'); INSERT INTO `survey` VALUES (278,1,'2007-11-11 12:26:22','skip'); INSERT INTO `survey` VALUES (177,16,'2007-09-06 17:44:27','yes'); INSERT INTO `survey` VALUES (178,16,'2007-09-06 17:45:06','yes'); INSERT INTO `survey` VALUES (473,16,'2008-04-11 13:21:48','yes'); INSERT INTO `survey` VALUES (180,21,'2007-09-06 17:48:37','yes'); INSERT INTO `survey` VALUES (181,21,'2007-09-06 17:50:26','yes'); INSERT INTO `survey` VALUES (182,21,'2007-09-06 17:50:55','yes'); INSERT INTO `survey` VALUES (183,21,'2007-09-06 17:51:42','yes'); INSERT INTO `survey` VALUES (184,21,'2007-09-06 17:52:19','yes'); INSERT INTO `survey` VALUES (185,21,'2007-09-06 17:53:31','yes'); INSERT INTO `survey` VALUES (186,21,'2007-09-06 17:54:52','yes'); INSERT INTO `survey` VALUES (187,21,'2007-09-06 17:56:33','yes'); INSERT INTO `survey` VALUES (188,21,'2007-09-06 17:57:48','yes'); INSERT INTO `survey` VALUES (189,10,'2007-09-06 17:58:56','yes'); INSERT INTO `survey` VALUES (190,10,'2007-09-06 17:59:14','yes'); INSERT INTO `survey` VALUES (191,10,'2007-09-06 18:00:23','yes'); INSERT INTO `survey` VALUES (192,10,'2007-09-06 18:01:06','yes'); INSERT INTO `survey` VALUES (193,6,'2007-09-06 18:04:43','yes'); INSERT INTO `survey` VALUES (194,6,'2007-09-06 18:06:02','yes'); INSERT INTO `survey` VALUES (195,6,'2007-09-06 18:07:39','yes'); INSERT INTO `survey` VALUES (196,6,'2007-09-06 18:07:59','yes'); INSERT INTO `survey` VALUES (411,7,'2008-04-03 11:25:38','yes'); INSERT INTO `survey` VALUES (410,7,'2008-04-03 11:25:27','yes'); INSERT INTO `survey` VALUES (409,7,'2008-04-03 11:25:15','yes'); INSERT INTO `survey` VALUES (408,7,'2008-04-03 11:25:04','yes'); INSERT INTO `survey` VALUES (201,7,'2007-09-13 11:28:22','yes'); INSERT INTO `survey` VALUES (202,7,'2007-09-13 11:29:36','yes'); INSERT INTO `survey` VALUES (203,7,'2007-09-13 11:30:29','yes'); INSERT INTO `survey` VALUES (204,7,'2007-09-13 11:31:45','yes'); INSERT INTO `survey` VALUES (205,7,'2007-09-13 11:33:03','yes'); INSERT INTO `survey` VALUES (206,7,'2007-09-13 11:35:07','yes'); INSERT INTO `survey` VALUES (415,8,'2008-04-03 11:26:21','yes'); INSERT INTO `survey` VALUES (208,7,'2007-09-13 11:43:43','yes'); INSERT INTO `survey` VALUES (209,7,'2007-09-13 11:44:33','yes'); INSERT INTO `survey` VALUES (210,7,'2007-09-13 11:45:15','yes'); INSERT INTO `survey` VALUES (211,7,'2007-09-13 11:46:46','yes'); INSERT INTO `survey` VALUES (266,7,'2007-11-11 12:09:01','yes'); INSERT INTO `survey` VALUES (265,7,'2007-11-11 12:08:32','yes'); INSERT INTO `survey` VALUES (214,22,'2007-09-17 16:09:20','yes'); INSERT INTO `survey` VALUES (215,22,'2007-09-17 16:09:51','yes'); INSERT INTO `survey` VALUES (216,22,'2007-09-17 16:10:23','yes'); INSERT INTO `survey` VALUES (217,22,'2007-09-17 16:10:49','yes'); INSERT INTO `survey` VALUES (218,22,'2007-09-17 16:11:25','yes'); INSERT INTO `survey` VALUES (219,22,'2007-09-17 16:11:51','yes'); INSERT INTO `survey` VALUES (220,22,'2007-09-17 16:12:23','yes'); INSERT INTO `survey` VALUES (221,22,'2007-09-17 16:12:45','yes'); INSERT INTO `survey` VALUES (222,22,'2007-09-17 16:13:59','yes'); INSERT INTO `survey` VALUES (223,22,'2007-09-17 16:14:28','yes'); INSERT INTO `survey` VALUES (224,22,'2007-09-17 16:14:52','yes'); INSERT INTO `survey` VALUES (225,22,'2007-09-17 16:15:20','yes'); INSERT INTO `survey` VALUES (226,22,'2007-09-17 16:15:44','yes'); INSERT INTO `survey` VALUES (227,22,'2007-09-17 16:16:17','yes'); INSERT INTO `survey` VALUES (228,22,'2007-09-17 16:16:38','yes'); INSERT INTO `survey` VALUES (229,22,'2007-09-17 16:17:06','yes'); INSERT INTO `survey` VALUES (230,22,'2007-09-17 16:17:29','yes'); INSERT INTO `survey` VALUES (231,22,'2007-09-17 16:17:53','yes'); INSERT INTO `survey` VALUES (232,22,'2007-09-17 16:18:17','yes'); INSERT INTO `survey` VALUES (233,22,'2007-09-17 16:18:45','yes'); INSERT INTO `survey` VALUES (234,22,'2007-09-17 16:20:13','yes'); INSERT INTO `survey` VALUES (235,22,'2007-09-17 16:20:58','yes'); INSERT INTO `survey` VALUES (236,22,'2007-09-17 16:21:21','yes'); INSERT INTO `survey` VALUES (237,22,'2007-09-17 16:21:49','yes'); INSERT INTO `survey` VALUES (238,22,'2007-09-17 16:22:15','yes'); INSERT INTO `survey` VALUES (239,22,'2007-09-17 16:22:43','yes'); INSERT INTO `survey` VALUES (240,22,'2007-09-17 16:23:06','yes'); INSERT INTO `survey` VALUES (241,22,'2007-09-17 16:23:40','yes'); INSERT INTO `survey` VALUES (242,22,'2007-09-17 16:24:19','yes'); INSERT INTO `survey` VALUES (243,22,'2007-09-17 16:24:54','yes'); INSERT INTO `survey` VALUES (244,22,'2007-09-17 16:25:24','yes'); INSERT INTO `survey` VALUES (245,22,'2007-09-17 16:25:47','yes'); INSERT INTO `survey` VALUES (246,22,'2007-09-17 16:26:11','yes'); INSERT INTO `survey` VALUES (247,22,'2007-09-17 16:26:38','yes'); INSERT INTO `survey` VALUES (248,22,'2007-09-17 16:27:01','yes'); INSERT INTO `survey` VALUES (249,22,'2007-09-17 16:27:39','yes'); INSERT INTO `survey` VALUES (250,22,'2007-09-17 16:28:04','yes'); INSERT INTO `survey` VALUES (251,22,'2007-09-17 16:28:39','yes'); INSERT INTO `survey` VALUES (252,22,'2007-09-17 16:29:09','yes'); INSERT INTO `survey` VALUES (253,22,'2007-09-17 16:29:53','yes'); INSERT INTO `survey` VALUES (254,22,'2007-09-17 16:30:33','yes'); INSERT INTO `survey` VALUES (255,22,'2007-09-17 16:31:07','yes'); INSERT INTO `survey` VALUES (256,22,'2007-09-17 16:31:36','yes'); INSERT INTO `survey` VALUES (257,22,'2007-09-17 16:32:01','yes'); INSERT INTO `survey` VALUES (258,22,'2007-09-17 16:32:43','yes'); INSERT INTO `survey` VALUES (259,22,'2007-09-17 16:33:17','yes'); INSERT INTO `survey` VALUES (260,22,'2007-09-17 16:33:50','yes'); INSERT INTO `survey` VALUES (261,22,'2007-09-17 16:34:20','yes'); INSERT INTO `survey` VALUES (262,22,'2007-09-17 16:48:48','yes'); INSERT INTO `survey` VALUES (263,22,'2007-09-17 16:49:10','yes'); INSERT INTO `survey` VALUES (264,22,'2007-09-17 16:49:31','yes'); INSERT INTO `survey` VALUES (280,1,'2007-11-11 12:27:09','skip'); INSERT INTO `survey` VALUES (281,1,'2007-11-11 12:27:31','skip'); INSERT INTO `survey` VALUES (282,1,'2007-11-11 12:28:09','skip'); INSERT INTO `survey` VALUES (283,1,'2007-11-11 12:28:56','skip'); INSERT INTO `survey` VALUES (284,1,'2007-11-11 12:29:38','skip'); INSERT INTO `survey` VALUES (285,1,'2007-11-11 12:30:03','skip'); INSERT INTO `survey` VALUES (286,1,'2007-11-11 12:30:31','skip'); INSERT INTO `survey` VALUES (287,1,'2007-11-11 12:30:56','skip'); INSERT INTO `survey` VALUES (288,1,'2007-11-11 12:31:33','skip'); INSERT INTO `survey` VALUES (300,15,'2008-02-10 22:37:12','yes'); INSERT INTO `survey` VALUES (442,3,'2008-04-09 07:26:38','yes'); INSERT INTO `survey` VALUES (450,3,'2008-04-09 07:38:44','yes'); INSERT INTO `survey` VALUES (443,3,'2008-04-09 07:29:05','yes'); INSERT INTO `survey` VALUES (304,3,'2008-02-11 16:34:25','yes'); INSERT INTO `survey` VALUES (305,3,'2008-02-11 16:34:56','yes'); INSERT INTO `survey` VALUES (306,3,'2008-02-11 16:35:27','yes'); INSERT INTO `survey` VALUES (307,3,'2008-02-11 16:37:15','yes'); INSERT INTO `survey` VALUES (308,3,'2008-02-11 16:37:35','yes'); INSERT INTO `survey` VALUES (309,3,'2008-02-11 16:37:52','yes'); INSERT INTO `survey` VALUES (311,3,'2008-02-11 16:38:28','yes'); INSERT INTO `survey` VALUES (312,3,'2008-02-11 16:38:54','yes'); INSERT INTO `survey` VALUES (313,3,'2008-02-11 16:40:28','yes'); INSERT INTO `survey` VALUES (314,3,'2008-02-11 16:41:24','yes'); INSERT INTO `survey` VALUES (315,3,'2008-02-11 16:41:59','yes'); INSERT INTO `survey` VALUES (316,3,'2008-02-11 16:42:22','yes'); INSERT INTO `survey` VALUES (446,3,'2008-04-09 07:34:44','yes'); INSERT INTO `survey` VALUES (318,3,'2008-02-11 16:43:12','yes'); INSERT INTO `survey` VALUES (319,3,'2008-02-11 16:44:13','yes'); INSERT INTO `survey` VALUES (320,3,'2008-02-11 16:44:42','yes'); INSERT INTO `survey` VALUES (321,3,'2008-02-11 16:45:09','yes'); INSERT INTO `survey` VALUES (322,3,'2008-02-11 16:45:35','yes'); INSERT INTO `survey` VALUES (323,3,'2008-02-11 16:47:17','yes'); INSERT INTO `survey` VALUES (324,3,'2008-02-11 16:47:42','yes'); INSERT INTO `survey` VALUES (325,3,'2008-02-11 16:48:10','yes'); INSERT INTO `survey` VALUES (326,3,'2008-02-11 16:48:54','yes'); INSERT INTO `survey` VALUES (327,3,'2008-02-11 16:49:19','yes'); INSERT INTO `survey` VALUES (328,3,'2008-02-11 16:49:42','yes'); INSERT INTO `survey` VALUES (329,3,'2008-02-11 16:50:29','yes'); INSERT INTO `survey` VALUES (444,3,'2008-04-09 07:32:00','yes'); INSERT INTO `survey` VALUES (448,3,'2008-04-09 07:36:00','yes'); INSERT INTO `survey` VALUES (353,9,'2008-02-15 12:06:01','error'); INSERT INTO `survey` VALUES (352,9,'2008-02-15 12:05:30','error'); INSERT INTO `survey` VALUES (351,9,'2008-02-15 12:04:40','error'); INSERT INTO `survey` VALUES (350,9,'2008-02-15 12:04:08','error'); INSERT INTO `survey` VALUES (349,9,'2008-02-15 12:00:34','error'); INSERT INTO `survey` VALUES (348,9,'2008-02-15 11:59:54','error'); INSERT INTO `survey` VALUES (347,9,'2008-02-15 11:59:26','error'); INSERT INTO `survey` VALUES (346,9,'2008-02-15 11:59:02','error'); INSERT INTO `survey` VALUES (345,9,'2008-02-15 11:58:19','error'); INSERT INTO `survey` VALUES (344,9,'2008-02-15 11:57:53','error'); INSERT INTO `survey` VALUES (343,9,'2008-02-15 11:57:27','error'); INSERT INTO `survey` VALUES (354,22,'2008-02-16 19:30:33','yes'); INSERT INTO `survey` VALUES (355,22,'2008-02-16 19:32:10','yes'); INSERT INTO `survey` VALUES (356,22,'2008-02-16 19:32:40','yes'); INSERT INTO `survey` VALUES (357,22,'2008-02-16 19:33:02','yes'); INSERT INTO `survey` VALUES (358,22,'2008-02-16 19:33:29','yes'); INSERT INTO `survey` VALUES (359,22,'2008-02-16 19:34:03','yes'); INSERT INTO `survey` VALUES (360,22,'2008-02-16 19:34:23','yes'); INSERT INTO `survey` VALUES (361,22,'2008-02-16 19:34:43','yes'); INSERT INTO `survey` VALUES (363,22,'2008-02-16 19:37:40','yes'); INSERT INTO `survey` VALUES (364,22,'2008-02-16 19:38:55','yes'); INSERT INTO `survey` VALUES (365,22,'2008-02-16 19:39:37','yes'); INSERT INTO `survey` VALUES (366,22,'2008-02-16 19:40:26','yes'); INSERT INTO `survey` VALUES (367,22,'2008-02-16 19:41:23','yes'); INSERT INTO `survey` VALUES (368,22,'2008-02-16 19:42:08','yes'); INSERT INTO `survey` VALUES (369,22,'2008-02-16 19:43:05','yes'); INSERT INTO `survey` VALUES (370,22,'2008-02-16 19:44:03','yes'); INSERT INTO `survey` VALUES (371,22,'2008-02-16 19:45:08','yes'); INSERT INTO `survey` VALUES (372,22,'2008-02-16 19:46:05','yes'); INSERT INTO `survey` VALUES (373,22,'2008-02-16 19:46:48','yes'); INSERT INTO `survey` VALUES (374,22,'2008-02-16 19:48:27','yes'); INSERT INTO `survey` VALUES (375,22,'2008-02-16 19:49:25','yes'); INSERT INTO `survey` VALUES (376,22,'2008-02-16 19:49:52','yes'); INSERT INTO `survey` VALUES (377,22,'2008-02-16 19:51:08','yes'); INSERT INTO `survey` VALUES (378,22,'2008-02-16 19:52:16','yes'); INSERT INTO `survey` VALUES (379,22,'2008-02-16 19:53:25','yes'); INSERT INTO `survey` VALUES (380,22,'2008-02-16 19:55:07','yes'); INSERT INTO `survey` VALUES (381,22,'2008-02-16 19:56:15','yes'); INSERT INTO `survey` VALUES (382,22,'2008-02-16 19:57:26','yes'); INSERT INTO `survey` VALUES (383,22,'2008-02-16 19:58:20','yes'); INSERT INTO `survey` VALUES (384,22,'2008-02-16 19:58:54','yes'); INSERT INTO `survey` VALUES (385,22,'2008-02-16 19:59:50','yes'); INSERT INTO `survey` VALUES (386,22,'2008-02-16 20:00:30','yes'); INSERT INTO `survey` VALUES (387,22,'2008-02-16 20:01:34','yes'); INSERT INTO `survey` VALUES (388,22,'2008-02-16 20:02:29','yes'); INSERT INTO `survey` VALUES (389,22,'2008-02-16 20:03:35','yes'); INSERT INTO `survey` VALUES (390,22,'2008-02-16 20:05:21','yes'); INSERT INTO `survey` VALUES (391,22,'2008-02-16 20:05:56','yes'); INSERT INTO `survey` VALUES (392,22,'2008-02-16 20:06:27','yes'); INSERT INTO `survey` VALUES (393,22,'2008-02-16 20:07:17','yes'); INSERT INTO `survey` VALUES (394,22,'2008-02-16 20:08:11','yes'); INSERT INTO `survey` VALUES (395,22,'2008-02-16 20:08:54','yes'); INSERT INTO `survey` VALUES (396,22,'2008-02-16 20:09:38','yes'); INSERT INTO `survey` VALUES (397,22,'2008-02-16 20:10:43','yes'); INSERT INTO `survey` VALUES (398,22,'2008-02-16 20:11:30','yes'); INSERT INTO `survey` VALUES (399,22,'2008-02-16 20:12:03','yes'); INSERT INTO `survey` VALUES (400,22,'2008-02-16 20:13:22','yes'); INSERT INTO `survey` VALUES (401,22,'2008-02-16 20:14:01','yes'); INSERT INTO `survey` VALUES (402,22,'2008-02-16 20:14:52','yes'); INSERT INTO `survey` VALUES (403,22,'2008-02-16 20:15:23','yes'); INSERT INTO `survey` VALUES (404,22,'2008-02-16 20:15:45','yes'); INSERT INTO `survey` VALUES (405,22,'2008-02-16 20:16:09','yes'); INSERT INTO `survey` VALUES (407,22,'2008-02-16 20:19:46','yes'); INSERT INTO `survey` VALUES (441,15,'2008-04-04 07:14:44','yes'); INSERT INTO `survey` VALUES (445,3,'2008-04-09 07:32:23','yes'); INSERT INTO `survey` VALUES (447,3,'2008-04-09 07:35:06','yes'); INSERT INTO `survey` VALUES (449,3,'2008-04-09 07:36:58','yes'); INSERT INTO `survey` VALUES (451,3,'2008-04-09 07:39:03','yes'); INSERT INTO `survey` VALUES (454,15,'2008-04-11 12:47:09','yes'); -- -- Table structure for table `survey_data` -- DROP TABLE IF EXISTS `survey_data`; CREATE TABLE `survey_data` ( `id` int(11) NOT NULL auto_increment, `survey_id` int(11) NOT NULL default '0', `common_name` varchar(255) default NULL, `latin_name` varchar(255) NOT NULL default '', `abundance` int(11) default NULL, `observation_code` varchar(255) default NULL, `lists` int(11) NOT NULL default '1', `extra` int(11) NOT NULL default '0', `photo` int(11) NOT NULL default '0', `notes` varchar(255) default NULL, `notes_r` varchar(255) default NULL, `sex` varchar(255) default NULL, `age` varchar(255) default NULL, `sample_site_number` int(11) default NULL, `measurements` varchar(255) default NULL, PRIMARY KEY (`id`), KEY `survey_id` (`survey_id`), KEY `latin_name` (`latin_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `survey_data` -- INSERT INTO `survey_data` VALUES (4022,59,'','Geotrupes ?jakovlevi Sem.',0,'v',0,1,0,'Flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4023,59,'','Aphodius ?nigrivittis Sols.',0,'c',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4024,59,'','Calliphoridae indet.',0,'v',0,0,0,'near Colchicum kesselringii Regel flower','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4025,59,'','Calliphoridae indet.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4026,59,'','Aphodius ?nigrivittis Sols.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4027,59,'','?Eristalis sp.',0,'v',0,0,0,'on dandelion (Taraxacum sp.) flower','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4028,59,'','Calliphoridae indet.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4029,59,'','Aphodius ?nigrivittis Sols.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4030,59,'','?Chelosia sp.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4031,59,'','Calliphoridae indet.',0,'v',0,0,0,'on dandelion (Taraxacum sp.) flower','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4032,60,'','Pieris (Artogeia) sp.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4033,60,'','Melitaea sp.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4034,60,'','Pieris (Artogeia) sp.',0,'v',0,1,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4035,61,'','Pardosa sp.',0,'v',0,0,0,'Juvenil','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4036,61,'','Pardosa sp.',0,'v',0,0,0,'Juvenil','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4037,61,'','Podalonia sp.',0,'v',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4038,61,'','Aphodius (Neagolius) haroldi D.Koshantschikov, 1894',0,'s',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4039,61,'','Geotrupes ?jakovlevi Sem.',0,'v',0,1,0,'Flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4040,61,'','Pardosa sp.',0,'v',0,0,0,'Juvenil','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4041,62,'','Pieris (Artogeia) sp.',0,'v',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4042,63,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'v',0,0,0,'many specimenss  2 females + 4 males + ~10males and females (in copula);several beetles eating of glaucescent sage-brush (Artemisia sp.)','','male, female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4043,63,'','Galeodes sp.',0,'c',0,0,0,'juvenil, under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4044,63,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'s,f',0,0,0,'collected 2males + 4males and females (in copula)','','male, female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4045,63,'','Galeodes sp.',0,'s,f',0,0,0,'?juvenil, under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4046,63,'','Galeodes sp.',0,'c',0,0,0,'juvenil, under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4047,64,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'male',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4048,64,'','Diptera Acalyptrata',0,'',0,0,0,'flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4049,64,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'male',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4050,64,'','Diptera Acalyptrata',0,'',0,0,0,'flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4051,64,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4052,64,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4057,65,'','Cymindis (Paracymindis) mannerheimi Gebler, 1843',0,'S',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4058,65,'','Lycosa (s. l.) sp.',0,'V, ?F',0,0,0,'1 juvenil (?B), at surface','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4059,65,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'C',0,0,0,'under a stone','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4060,65,'','Galeodes sp.',0,'C',0,0,0,'Juvenil; under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4061,65,'','Lithobiidae sp.-1 indet.',0,'S',0,0,0,'?Juvenil; under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4062,65,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'S',0,0,0,'under a stone','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4063,65,'','Ophonus (Hesperophonus) chlorizans Solsky, 1874',0,'S',0,0,0,'under a stone','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4064,65,'','Porcellionidae sp. indet.',0,'V',0,0,0,'~10 specimens; mostly juvenil; mostly under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4065,65,'','Cymindis (s. str.) picta (Pallas, 1771) nom. ssp.',0,'V',0,0,0,'~10 specimens; under stones and ruins (of old clayey destroyed walls)','','female, male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4066,65,'','Cymindis (s. str.) picta (Pallas, 1771) nom. ssp.',0,'S, F',0,0,0,'collected several specimens of both sexes; under ruins (of old clayey destroyed walls)','','female, male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4067,65,'','Oreasiobia fedtschenkoi (Saussure, 1874)',0,'V',0,0,0,'under ruins (of old clayey destroyed walls)','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4068,65,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'S, F',0,0,0,'under ruins (of old clayey destroyed walls)','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4069,65,'','Oreasiobia fedtschenkoi (Saussure, 1874)',0,'S, F',0,0,0,'at a nest (with eggs) under ruins (of old clayey destroyed walls); volant (morpha macroptera)','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4070,65,'','Oreasiobia fedtschenkoi (Saussure, 1874)',0,'S',0,0,0,'at a nest (with eggs) under ruins (of old clayey destroyed walls); forma ?microptera','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4071,65,'','Dasylabris (s. str.) mongolica (Radoszkowski, 1861)',0,'S',0,0,0,'in an entrance to old marmot\'s hole','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4072,65,'','Catomus sp. aff. alaiensis G.Medvedev',0,'V',0,0,0,'5 specimens; mostly under stones and ruins (of old clayey destroyed walls)','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4073,65,'','Catomus sp. aff. alaiensis G.Medvedev',0,'S',0,0,0,'under stones','','2 females+male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4074,65,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'V',0,0,0,'5 specimens; mostly under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4075,65,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'V',0,0,0,'~10 specimens; mostly under stones and ruins (of old clayey destroyed walls)','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4076,65,'','Cymindis (Paracymindis) mannerheimi Gebler, 1843',0,'S',0,0,0,'under a stone','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4077,65,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'V',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4078,65,'','Ophonus (Hesperophonus) chlorizans Solsky, 1874',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4079,65,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4080,65,'','Harpalus (s. str.) pseudoserripes Reitter, 1900 nom. ssp.',0,'S',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4081,65,'','Galeodes sp.',0,'C',0,0,0,'Juvenil; under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4082,65,'','Lithobiidae sp.-2 indet.',0,'V',0,0,0,'Juvenil; under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4083,65,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'S, F',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4084,65,'','Cymindis (Paracymindis) mannerheimi Gebler, 1843',0,'V',0,0,0,'under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4085,65,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'S',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4086,65,'','Agonum (s. str.) chalconotum Ménétriès, 1832',0,'S',0,0,0,'under a dry cow\'s dung','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4087,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4088,66,'','Colias sp.',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4089,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','X',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4090,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4091,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4092,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','X',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4093,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4094,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','X',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4095,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4096,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4097,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4098,66,'Painted lady','Vanessa cardui (Linnaeus, 1758)',0,'',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4099,67,'','Cymindis (Paracymindis) mannerheimi Gebler, 1843',0,'S',0,0,0,'under a stone','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4100,67,'','Pardosa sp.',0,'V',0,0,0,'~10 juvenils','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4101,67,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'C',0,0,0,'under a stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4102,67,'','Xylocopa (Copoxyla) turanica F.Morawitz, 1875',0,'S',0,0,0,'?fresh dead headless','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4103,67,'','Diptera Acalyptrata',0,'V',0,0,0,'Flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4104,68,'','Anatolica sp.',0,'V',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4105,68,'','Porcellionidae sp. indet.',0,'V',0,0,0,'6 juvenils; mostly under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4106,68,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'C',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4107,68,'','Tettigoniidae (?Glyphonotus sp.)',0,'V',0,0,0,'small (<10 mm) larva','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4108,68,'','Diphyus pseudomercator Heinrich, 1978',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4109,68,'','Calathus (Neocalathus) melanocephalus (Linnaeus, 1758) nom.ssp.',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4110,68,'','Calathus (Neocalathus) melanocephalus (Linnaeus, 1758) nom.ssp.',0,'V',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4111,68,'','Geocoris sp. aff. alaiensis Reuter, 1885',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4112,68,'','Zophosis nitida Gebler, 1844',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4113,68,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'C',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4114,68,'','Zophosis nitida Gebler, 1844',0,'S',0,0,0,'under stone','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4115,68,'','Zophosis nitida Gebler, 1844',0,'V',0,0,0,'under stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4116,68,'','Catomus sp. aff. alaiensis G.Medvedev',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4117,68,'','Trichalophus sp.',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4118,68,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'S, F',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4119,68,'','Anatolica sp.',0,'V',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4120,68,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'C',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4121,68,'','Cymindis (Paracymindis) mannerheimi Gebler, 1843',0,'S',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4122,68,'','Camponotus (s. str.) fedtschenkoi Mayr, 1877',0,'S',0,0,0,'worker','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4123,68,'','Camponotus (s. str.) fedtschenkoi Mayr, 1877',0,'V',0,0,0,'~10 workers; solitarely (nothing a nest)','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4124,68,'','Catomus sp. aff. alaiensis G.Medvedev',0,'S',0,0,0,'under stone','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4125,68,'','Trichalophus sp.',0,'S',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4126,68,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'C',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4127,68,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4128,68,'','Catomus sp. aff. alaiensis G.Medvedev',0,'V',0,0,0,'under stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4129,68,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4130,68,'','Zophosis nitida Gebler, 1844',0,'V',0,0,0,'under stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4131,68,'','Cymindis (Paracymindis) mannerheimi Gebler, 1843',0,'S',0,0,0,'under stone','','male, female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4132,68,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'C',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4133,68,'','Calathus (Neocalathus) melanocephalus (Linnaeus, 1758) nom.ssp.',0,'C',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4134,68,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'S',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4135,68,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'C',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4136,68,'','Trichalophus sp.',0,'S',0,0,0,'under stone','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4137,68,'','Catomus sp. aff. alaiensis G.Medvedev',0,'V',0,0,0,'under stone','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4138,68,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'V',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4139,68,'','Camponotus (s. str.) fedtschenkoi Mayr, 1877',0,'S',0,0,0,'worker','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4140,68,'','Blaps caraboides Allard, 1882 ssp. alaiensis Reinig, 1931',0,'V',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4141,69,'','Gerridae sp. indet.',0,'V',0,0,0,'~10 ?larvae (at wather-surface in one puddle)','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4142,69,'','Diptera Acalyptrata sp.-1 indet.',0,'V',0,0,0,'Flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4143,69,'','?Hydrous sp.',0,'V',0,0,0,'1 (in puddle)','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4144,69,'','Diptera Acalyptrata sp.-2 indet.',0,'V',0,0,0,'Flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4145,69,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'C',0,0,0,'','','@',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4146,69,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'C',0,0,0,'','','@',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4148,70,'','Porcellionidae sp. indet.',0,'V',0,0,0,'4 juvenils; mostly under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4149,70,'','Nebria (Eunebria) limbigera Solsky, 1874',0,'V',0,0,0,'>10 specimens; under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4150,70,'','Nebria (Eunebria) limbigera Solsky, 1874',0,'S',0,0,0,'Collected several specimens of both sexes; under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4151,70,'','?Tachinidae',0,'V',0,0,0,'Flying near the rock precipity','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4152,70,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4153,70,'','Geotrupes (s. str.) jakovlevi Semenov, 1891',0,'V',0,1,0,'Flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4154,70,'','Myrmica dschungarica Ruzsky, 1905',0,'S',0,0,0,'5 workers from 2 nests under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4155,70,'','Myrmica dschungarica Ruzsky, 1905',0,'V',0,0,0,'several nests under stones','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4156,70,'','Formica (Serviformica) picea Nylander, 1846',0,'',0,0,0,'Medium-sized nest under a stone, 2 workers collected','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4157,70,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'V, C',0,0,0,'~10 specimens of both sexes','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4158,70,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'C',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4159,70,'','Calliphoridae',0,'V',0,0,0,'On buttercup (Ranunculus sp.) flower','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4160,70,'','Formica (Serviformica) picea Nylander, 1846',0,'',0,0,0,'Large nest (nothing sexual speceimens on a surface)','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4161,70,'','Geotrupes (s. str.) jakovlevi Semenov, 1891',0,'S',0,0,0,'On fresh yaks dung','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4162,70,'','Bioramix (Planoplatyscelis) pamirensis Bates, 1879',0,'C',0,0,0,'','','female',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4163,70,'','Geotrupes (s. str.) jakovlevi Semenov, 1891',0,'V',0,1,0,'Flying','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4164,70,'','Prosodes (Uroprosodes) costifera Kraatz, 1886',0,'S',0,0,0,'','','male',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4165,71,'','Vanessa cardui (Linnaeus, 1758)',0,'V',0,0,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4166,71,'','Vanessa cardui (Linnaeus, 1758)',0,'C',0,0,0,'dead abdomen-less','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4167,71,'','Colias sp.',0,'V',0,1,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4168,71,'','Vanessa cardui (Linnaeus, 1758)',0,'V',0,1,0,'','','',NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (7710,176,'Crag martin','Riaparia rupestris',8,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4170,72,'Long-tailed Marmot','Marmota caudate',300,'v',0,1,0,'the obserwation made from vehicle','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4171,72,'Long-tailed Marmot','Marmota caudate',2500,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4172,73,'Long-tailed Marmot','Marmota caudate',4,'v',0,1,0,'obserwation made from vehicle','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4173,74,'Long-tailed Marmot','Marmota caudate',28,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4174,74,'Long-tailed Marmot','Marmota caudate',42,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4175,75,'Long-tailed Marmot','Marmota caudate',37,'v',0,1,0,'obserwation made from vehicle','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4176,75,'Long-tailed Marmot','Marmota caudate',285,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4177,75,'Tolai hare','Lepus tolai',1,'e',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4178,76,'Long-tailed Marmot','Marmota caudate',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4179,76,'Long-tailed Marmot','Marmota caudate',26,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4180,76,'Tolai hare','Lepus tolai',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4181,76,'Tolai hare','Lepus tolai',1,'e',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4182,76,'Northern Mole Vole','Ellobius talpinus',1,'m',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4183,76,'Wood Mouse','Apodemus sylvaticus',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4184,77,'Long-tailed Marmot','Marmota caudate',47,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4185,77,'Long-tailed Marmot','Marmota caudate',285,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4186,77,'Northern Mole Vole','Ellobius talpinus',1,'t',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4187,78,'Northern Mole Vole','Ellobius talpinus',1,'t',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4188,78,'Long-tailed Marmot','Marmota caudate',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4189,78,'Long-tailed Marmot','Marmota caudate',48,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4190,79,'Fox','Vulpes vulpes',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4191,79,'Long-tailed Marmot','Marmota caudate',28,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4192,80,'Long-tailed Marmot','Marmota caudate',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4193,80,'Long-tailed Marmot','Marmota caudate',21,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4194,80,'Badger','Meles meles',1,'m',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4195,80,'Northern Mole Vole','Ellobius talpinus',1,'m',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4196,81,'Long-tailed Marmot','Marmota caudate',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4197,81,'Long-tailed Marmot','Marmota caudate',16,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4198,81,'Tolai hare','Lepus tolai',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4200,83,'Northern Mole Vole','Ellobius talpinus',1,'m',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4201,83,'Long-tailed Marmot','Marmota caudate',13,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4202,83,'Long-tailed Marmot','Marmota caudate',58,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4203,84,'Badger','Meles meles',1,'m',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4204,84,'Northern Mole Vole','Ellobius talpinus',1,'m',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4205,84,'Long-tailed Marmot','Marmota caudate',160,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4206,84,'Long-tailed Marmot','Marmota caudate',10,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (11884,414,'Long-tailed marmot','Marmota caudate',3,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4208,86,'Long-tailed Marmot','Marmota caudate',4,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4209,86,'Long-tailed Marmot','Marmota caudate',500,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4210,87,'Long-tailed Marmot','Marmota caudate',16,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4211,87,'Long-tailed Marmot','Marmota caudate',109,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4213,88,'Long-tailed Marmot','Marmota caudate',10,'b',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4214,88,'Tolai hare','Lepus tolai',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4215,88,'Narrow-headed Voe','Microtus gregalis',1,'m',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (11883,414,'Marco polo sheep','Ovis ammon polii',4,'t',1,0,0,'tracks are fresh','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4217,89,'Tolai hare','Lepus tolai',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4218,90,'Fox','Vulpes vulpes',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (15471,474,'Blue hill pigeon','Columba rupestris',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4220,91,'Tree sparrow','Passer montanus dilutus',4,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4221,91,'Rock sparrow','Petronia petronia',4,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4222,91,'Raven','Corvus corax',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4223,91,'Rosefinch','Carpodacus rubicilla',2,'v',0,1,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4224,91,'Rock sparrow','Petronia petronia',4,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4225,91,'Rock sparrow','Petronia petronia',8,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4226,91,'Tree sparrow','Passer montanus dilutus',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4227,91,'Rock sparrow','Petronia petronia',4,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4228,92,'Chough','Pyrrhocorax pyrrhocorax',7,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4229,92,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4230,92,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'male, female and nest, 5 nestlings','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4231,92,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4232,92,'Scarlet Rosefinch','Carpodacus erythrinus',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4233,92,'Common sandpiper','Actitis hypoleucos',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4234,92,'Chough','Pyrrhocorax pyrrhocorax',3,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4235,92,'Citrine wagtail','Motacilla citreola',1,'f',1,0,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4236,92,'Rock sparrow','Petronia petronia',3,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4237,92,'Citrine wagtail','Motacilla citreola',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4238,92,'Magpie','Pica pica',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4239,92,'Hume\'s lesser Whitethroat','Sylvia althaea',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4240,92,'Citrine wagtail','Motacilla citreola',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4241,92,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4242,92,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4243,92,'Chough','Pyrrhocorax pyrrhocorax',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4244,92,'Masked wagtail','Motacilla personata',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4245,92,'Blue hill pigeon','Columba rupestris',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4246,92,'Chough','Pyrrhocorax pyrrhocorax',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4247,92,'Horned lark','Eremophila alpestris',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4248,92,'Hodgson\'s rosefinch','Leucosticte nemoricola',8,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4249,92,'Isabelline wheatear','Oenanthe isabellina',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4250,92,'Scarlet Rosefinch','Carpodacus erythrinus',1,'a',0,1,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4251,92,'Chough','Pyrrhocorax pyrrhocorax',7,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4252,92,'Common swift','Apus apus',1,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4253,92,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',1,0,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4254,92,'Rock sparrow','Petronia petronia',1,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4255,92,'Rock sparrow','Petronia petronia',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4256,92,'Rock sparrow','Petronia petronia',5,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4257,92,'Masked wagtail','Motacilla personata',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4258,92,'Blue hill pigeon','Columba rupestris',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4259,92,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4260,92,'Hoopoe','Upupa crous',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4261,92,'Black vulture','Aegypius monachus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4262,92,'Water pipit','Anthus spinoletta',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4263,92,'Blue hill pigeon','Columba rupestris',4,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4264,92,'Twite','Acanthis flavirostris',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4265,92,'Redstart SP','Phoenicurus SP',2,'v',0,1,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4266,92,'Golden eagle','Aquila chrysaetos',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4267,92,'Snowfinch','Montifringilla nivalis',5,'v',1,0,0,'2 males, 3 females','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4268,92,'Brown accentor','Prunella fulvescens',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4269,92,'Snowfinch','Montifringilla nivalis',3,'v',0,1,0,'male, 2 females','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4270,93,'Citrine wagtail','Motacilla citreola',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4271,93,'Eversmann\'s redstart','Phoenicurus erythronotus',2,'v',0,1,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4272,93,'Magpie','Pica pica',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4273,93,'Stonechat','Saxicola torquata',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4274,93,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4275,93,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4276,93,'Mongolian finch','Bucanetes mongolicus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4277,93,'Warbler SP','Phylloscopus SP',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4278,93,'Redstart SP','Phoenicurus SP',1,'v',1,0,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4279,93,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4280,93,'Black redstart','Phoenicurus ochrurus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4281,93,'Warbler','Phylloscopus humei',3,'v',1,0,0,'1 adult+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4282,93,'Red-fronted serin','Serinus pusillus',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4283,93,'Eurasian Dipper','Cinclus cinclus',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4284,93,'Olivaceous willow warbler','Phylloscopus griseolus',1,'a,v',0,1,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4285,93,'Common sandpiper','Actitis hypoleucos',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4286,93,'Citrine wagtail','Motacilla citreola',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4287,93,'Masked wagtail','Motacilla personata',1,'v',1,0,0,'young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4288,93,'Common sandpiper','Actitis hypoleucos',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4289,93,'Citrine wagtail','Motacilla citreola',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4290,93,'Guldenstadt\'s redstart','Phoenicurus erythrogaster',1,'v',1,0,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4291,93,'Red-fronted serin','Serinus pusillus',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4292,93,'Snowfinch','Montifringilla nivalis',5,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4293,93,'Twite','Acanthis flavirostris',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4294,93,'Lammergeier','Gypaetus barbatus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4295,94,'Himalayan rubythroat','Luscinia pectoralis',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4296,94,'Citrine wagtail','Motacilla citreola',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4297,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4298,94,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4299,94,'Eurasian Dipper','Cinclus cinclus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4300,94,'Warbler SP','Phylloscopus SP',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4301,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4302,94,'Warbler','Phylloscopus humei',3,'v',1,0,0,'1 adult+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4303,94,'Redstart SP','Phoenicurus SP',1,'v',0,1,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4304,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4305,94,'Hume\'s lesser Whitethroat','Sylvia althaea',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4306,94,'Eversmann\'s redstart','Phoenicurus erythronotus',1,'v',1,0,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4307,94,'Warbler','Phylloscopus humei',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4308,94,'Brown accentor','Prunella fulvescens',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4309,94,'Olivaceous willow warbler','Phylloscopus griseolus',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4310,94,'Scarlet Rosefinch','Carpodacus erythrinus',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4311,94,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4312,94,'Himalayan rubythroat','Luscinia pectoralis',1,'v',1,0,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4313,94,'Warbler','Phylloscopus humei',4,'v',1,0,0,'1 adult+3 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4314,94,'Brown accentor','Prunella fulvescens',2,'v',1,0,0,'1 adult+1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4315,94,'Brown accentor','Prunella fulvescens',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4316,94,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',0,1,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4317,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4318,94,'Citrine wagtail','Motacilla citreola',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4319,94,'Olivaceous willow warbler','Phylloscopus griseolus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4320,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4321,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'1',1,1,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4322,94,'Olivaceous willow warbler','Phylloscopus griseolus',1,'a',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4323,94,'Hume\'s lesser Whitethroat','Sylvia althaea',1,'a',0,1,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4324,94,'Himalayan rubythroat','Luscinia pectoralis',3,'v',0,1,0,'1 adult+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4325,94,'Scarlet Rosefinch','Carpodacus erythrinus',2,'f',1,0,0,'2 males','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4326,94,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4327,94,'Chough','Pyrrhocorax pyrrhocorax',4,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4328,94,'Olivaceous willow warbler','Phylloscopus griseolus',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4329,94,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4330,94,'Magpie','Pica pica',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4331,94,'Red-fronted serin','Serinus pusillus',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4332,94,'Isabelline wheatear','Oenanthe isabellina',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4333,94,'','Delichon urbica',6,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4334,94,'Eurasian Dipper','Cinclus cinclus',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4335,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4336,94,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4337,94,'Warbler','Phylloscopus humei',1,'a',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4338,94,'Hodgson\'s rosefinch','Leucosticte nemoricola',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4339,94,'Masked wagtail','Motacilla personata',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4340,94,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4341,94,'Black redstart','Phoenicurus ochrurus',5,'v',0,1,0,'2 adults+3 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4342,94,'Hodgson\'s rosefinch','Leucosticte nemoricola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4343,94,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4344,94,'Himalayan rubythroat','Luscinia pectoralis',1,'v',0,1,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4345,94,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4346,94,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',0,1,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4347,94,'Eurasian Dipper','Cinclus cinclus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4348,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4349,94,'Hodgson\'s rosefinch','Leucosticte nemoricola',4,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4350,94,'Brown accentor','Prunella fulvescens',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4351,94,'Citrine wagtail','Motacilla citreola',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4352,94,'Scarlet Rosefinch','Carpodacus erythrinus',3,'v',0,1,0,'2males, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4353,94,'Magpie','Pica pica',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4354,94,'Guldenstadt\'s redstart','Phoenicurus erythrogaster',1,'v',0,1,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4355,94,'Mistle thrush','Turdus visciforus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4356,94,'','Delichon urbica',20,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4357,94,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4358,94,'Redstart SP','Phoenicurus SP',2,'v',1,0,0,'2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4359,94,'Scarlet Rosefinch','Carpodacus erythrinus',3,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4360,94,'Eurasian Dipper','Cinclus cinclus',4,'v',1,0,0,'2 adults+2 youngs, photo','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4361,94,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4362,94,'Hodgson\'s rosefinch','Leucosticte nemoricola',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4363,94,'Olivaceous willow warbler','Phylloscopus griseolus',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4364,94,'Guldenstadt\'s redstart','Phoenicurus erythrogaster',1,'v',0,1,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4365,94,'Redstart SP','Phoenicurus SP',1,'v',0,1,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4366,94,'Water pipit','Anthus spinoletta',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4367,94,'Red-mantled rosefinch','Carpodacus rhodochlamys',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4368,94,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4369,94,'Himalayan rubythroat','Luscinia pectoralis',1,'v',0,1,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4370,94,'Red-mantled rosefinch','Carpodacus rhodochlamys',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4371,94,'White-winged grosbeak','Mycerobas carnipes',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4372,94,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4373,94,'Citrine wagtail','Motacilla citreola',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4374,94,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4375,94,'Black redstart','Phoenicurus ochrurus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4376,94,'Himalayan rubythroat','Luscinia pectoralis',3,'v',1,0,0,'female+2 youngs, photo','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4377,94,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'male, female + nest with 5 nestlings','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (12009,431,'Rock sparrow','Petronia petronia',2,'v,f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4379,95,'Horned lark','Eremophila alpestris',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4380,95,'Common swift','Apus apus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4381,95,'Pin-tailed sandgrouse','Pterocles alchata',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4382,95,'Horned lark','Eremophila alpestris',1,'v',1,0,0,'1 young, photo','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4383,95,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4384,95,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4385,95,'Horned lark','Eremophila alpestris',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4386,95,'Common sandpiper','Actitis hypoleucos',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4387,95,'Little ringed plover','Charadrius dubius',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4388,95,'Horned lark','Eremophila alpestris',3,'v',1,0,0,'2 adults+1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4389,95,'Isabelline wheatear','Oenanthe isabellina',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4390,95,'Common sandpiper','Actitis hypoleucos',4,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4391,95,'Pipit SP','Anthus SP',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4392,95,'Common sandpiper','Actitis hypoleucos',5,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4393,95,'Citrine wagtail','Motacilla citreola',4,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4394,95,'Horned lark','Eremophila alpestris',4,'v',1,0,0,'2 adults+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4395,95,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4396,95,'Little ringed plover','Charadrius dubius',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4397,95,'Roody shellduck','Tadorna ferruginea',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4398,95,'Long-legged buard','Buteo rufinus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4399,95,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4400,95,'Isabelline wheatear','Oenanthe isabellina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4401,95,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (12008,431,'Barn swallow','Hirundo rustica',2,'v,f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4403,96,'Horned lark','Eremophila alpestris',12,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4404,96,'Hoopoe','Upupa crous',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4405,96,'Horned lark','Eremophila alpestris',3,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4406,96,'Carrion crow','Corvus corone',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4407,96,'Horned lark','Eremophila alpestris',9,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4408,96,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4409,96,'Isabelline wheatear','Oenanthe isabellina',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4410,96,'Hoopoe','Upupa crous',3,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4411,96,'Long-legged buard','Buteo rufinus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4412,96,'Horned lark','Eremophila alpestris',8,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4413,96,'Citrine wagtail','Motacilla citreola',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4414,96,'Common cuckoo','Cuculus canorus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4415,96,'Black kite','Milvus migrans',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4416,96,'Skylark','Alauda arvensis',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4417,96,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4418,96,'Horned lark','Eremophila alpestris',20,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4419,96,'Isabelline wheatear','Oenanthe isabellina',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4420,96,'Long-legged buard','Buteo rufinus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4421,96,'Common cuckoo','Cuculus canorus',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4422,96,'Skylark','Alauda arvensis',5,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4423,96,'Horned lark','Eremophila alpestris',40,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4424,96,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4425,96,'Isabelline wheatear','Oenanthe isabellina',4,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4426,96,'Horned lark','Eremophila alpestris',12,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4427,96,'Skylark','Alauda arvensis',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4428,96,'Isabelline wheatear','Oenanthe isabellina',6,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4429,96,'Horned lark','Eremophila alpestris',40,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4430,96,'Long-legged buard','Buteo rufinus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4431,96,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4432,96,'Common cuckoo','Cuculus canorus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4433,96,'Isabelline wheatear','Oenanthe isabellina',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4434,96,'Horned lark','Eremophila alpestris',40,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4435,96,'Citrine wagtail','Motacilla citreola',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4436,96,'Skylark','Alauda arvensis',12,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4437,96,'Horned lark','Eremophila alpestris',30,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4438,96,'Horned lark','Eremophila alpestris',40,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (12007,431,'Common kestrel','Falco tinnunculus',2,'v,f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4440,97,'Horned lark','Eremophila alpestris',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4441,97,'Commom kestrel','Falco tinnunculus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4442,97,'Horned lark','Eremophila alpestris',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4443,97,'Isabelline wheatear','Oenanthe isabellina',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4444,97,'','Delichon urbica',26,'f',0,1,0,'colony, 17 nests on a rock','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4445,97,'Horned lark','Eremophila alpestris',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4446,97,'Skylark','Alauda arvensis',4,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4447,97,'Black redstart','Phoenicurus ochrurus',1,'a',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4448,97,'Horned lark','Eremophila alpestris',5,'v',1,0,0,'3 youngs+2 adults','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4449,97,'Skylark','Alauda arvensis',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4450,97,'Horned lark','Eremophila alpestris',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4451,97,'Horned lark','Eremophila alpestris',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4452,97,'','Delichon urbica',1,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4453,97,'Horned lark','Eremophila alpestris',3,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4454,97,'Golden eagle','Aquila chrysaetos',1,'v',0,1,0,'young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4455,97,'Black redstart','Phoenicurus ochrurus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4456,97,'Common swift','Apus apus',5,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4457,97,'Northern Wheatear','Oenanthe oenanthe',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4458,97,'Northern Wheatear','Oenanthe oenanthe',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4459,97,'Black redstart','Phoenicurus ochrurus',3,'v',1,0,0,'1 male+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4460,97,'Snowfinch','Montifringilla nivalis',3,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4461,97,'Black vulture','Aegypius monachus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4462,97,'Horned lark','Eremophila alpestris',4,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4463,97,'Rock sparrow','Petronia petronia',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4464,97,'Horned lark','Eremophila alpestris',8,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4465,97,'Horned lark','Eremophila alpestris',6,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4466,97,'Isabelline wheatear','Oenanthe isabellina',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4467,97,'Horned lark','Eremophila alpestris',4,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (12006,431,'Long-billed pipit','Anthus campestris',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4469,98,'Mongolian finch','Bucanetes mongolicus',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4470,98,'Northern Wheatear','Oenanthe oenanthe',3,'v',1,0,0,'1 adult+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4471,98,'Common sandpiper','Actitis hypoleucos',1,'v',1,0,0,'photo','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4472,98,'Rock thrush','Monticola saxatilis',2,'v',1,0,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4473,98,'Olivaceous willow warbler','Phylloscopus griseolus',4,'v',1,0,0,'1 adult+3 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4474,98,'Common whitethroat','Sylvia communis',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4475,98,'Bluethroat','Luscinia svecica',2,'v',1,0,0,'2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4476,98,'Common cuckoo','Cuculus canorus',1,'v',1,0,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4477,98,'Cetti`s Warbler','Cettia cetti',2,'v',1,0,0,'feeding cuckooling','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4478,98,'Common cuckoo','Cuculus canorus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4479,98,'Common whitethroat','Sylvia communis',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4480,98,'House dove','Columba livia',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4481,98,'Common mayna','Acridotheres tristis',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4482,98,'Magpie','Pica pica',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4483,98,'Citrine wagtail','Motacilla citreola',1,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4484,98,'Common sandpiper','Actitis hypoleucos',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4485,98,'House dove','Columba livia',3,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4486,98,'Rock thrush','Monticola saxatilis',5,'v',1,0,0,'male, female+3 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4487,98,'Common whitethroat','Sylvia communis',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4488,98,'Cetti`s Warbler','Cettia cetti',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4489,98,'Barred warbler','Sylvia nisoria',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4490,98,'Redstart SP','Phoenicurus SP',1,'v',0,1,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4491,98,'Linnet','Carduelis cannabina',5,'v',1,0,0,'2 adults+3 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4492,98,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4493,98,'Crimson-winged finch','Rhodopechys sanquinea',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4494,98,'Common whitethroat','Sylvia communis',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4495,98,'Bluethroat','Luscinia svecica',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4496,98,'Booted eagle','Hieraaetus pennatus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4497,98,'Stonechat','Saxicola torquata',1,'v',1,0,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4498,98,'Crimson-winged finch','Rhodopechys sanquinea',1,'v',1,0,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4499,98,'Linnet','Carduelis cannabina',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4500,98,'Hoopoe','Upupa crous',3,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (12005,431,'Rock sparrow','Petronia petronia',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4502,99,'Hoopoe','Upupa crous',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4503,99,'','Delichon urbica',14,'f',1,0,0,'colony, 12 nests on a rock','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4504,99,'Masked wagtail','Motacilla personata',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4505,99,'Pleschanka Wheatear','Oenanthe pleschanka',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4506,99,'Commom kestrel','Falco tinnunculus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4507,99,'Hoopoe','Upupa crous',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4508,99,'Red-fronted serin','Serinus pusillus',3,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4509,99,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4510,99,'Grey wagtail','Motacilla cinerea',1,'v',0,1,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4511,99,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4512,99,'Eurasian Dipper','Cinclus cinclus',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4513,99,'Rock thrush','Monticola saxatilis',4,'v',0,1,0,'2 adults+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4514,99,'Golden eagle','Aquila chrysaetos',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4515,99,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4516,99,'Alpine chough','Pyrrhocorax graculus',5,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4517,99,'Pleschanka Wheatear','Oenanthe pleschanka',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4518,99,'Magpie','Pica pica',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4519,99,'Commom kestrel','Falco tinnunculus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4520,99,'Common whitethroat','Sylvia communis',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4521,99,'Scarlet Rosefinch','Carpodacus erythrinus',2,'v',0,1,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4522,99,'Common whitethroat','Sylvia communis',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4523,99,'Greenish warbler','Phylloscopus trochiloides',2,'a',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4524,99,'Carrion crow','Corvus corone',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4525,99,'Tree pipit','Anthus trivialis',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4526,99,'Common whitethroat','Sylvia communis',1,'v',1,0,0,'nest, 2 nestlings, photo','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4527,99,'Grey wagtail','Motacilla cinerea',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4528,99,'Tree pipit','Anthus trivialis',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4529,99,'Linnet','Carduelis cannabina',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4530,99,'Citrine wagtail','Motacilla citreola',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4531,99,'Carrion crow','Corvus corone',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4532,99,'Greenish warbler','Phylloscopus trochiloides',2,'v',1,0,0,'nest, 5 nestlings, photo','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4533,99,'Crimson-winged finch','Rhodopechys sanguinea',2,'v',1,0,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4534,99,'Northern Wheatear','Oenanthe oenanthe',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4535,99,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'male, female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4536,99,'Rock thrush','Monticola saxatilis',1,'v',1,0,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4537,99,'Masked wagtail','Motacilla personata',1,'v',1,0,0,'1 young','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4538,99,'Rufous turtle dove','Streptopelia orientalis',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4539,99,'Linnet','Carduelis cannabina',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4540,99,'Northern Wheatear','Oenanthe oenanthe',2,'v',1,0,0,'2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4541,99,'Citrine wagtail','Motacilla citreola',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4542,99,'Water pipit','Anthus spinoletta',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4543,99,'Rock thrush','Monticola saxatilis',1,'v',1,0,0,'female','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4544,99,'Golden eagle','Aquila chrysaetos',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4545,99,'Northern Wheatear','Oenanthe oenanthe',2,'v',1,0,0,'2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4546,99,'Magpie','Pica pica',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4547,99,'Water pipit','Anthus spinoletta',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4548,99,'Citrine wagtail','Motacilla citreola',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4549,99,'Quail','Coturnix coturnix',1,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4550,99,'Eurasian hobby','Falco subbuteo',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4551,99,'Blue whistling thrush','Myophonus caeruleus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4552,99,'Masked wagtail','Motacilla personata',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4553,99,'Common sandpiper','Actitis hypoleucos',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4554,99,'Masked wagtail','Motacilla personata',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4555,99,'Carrion crow','Corvus corone',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4556,99,'Eurasian Dipper','Cinclus cinclus',1,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4557,99,'Pleschanka Wheatear','Oenanthe pleschanka',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4558,99,'Rock bunting','Emberiza cia',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4559,99,'Rufous turtle dove','Streptopelia orientalis',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4560,99,'Magpie','Pica pica',5,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4561,99,'Shrike','Lanius phunicuroides',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4562,99,'Masked wagtail','Motacilla personata',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4563,100,'Black redstart','Phoenicurus ochrurus',4,'v',1,0,0,'male, female+2 youngs','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4564,100,'Red-fronted serin','Serinus pusillus',2,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4565,100,'Himalayan snowcock','Tetraogallus himalayensis',2,'a',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4566,100,'Himalayan snowcock','Tetraogallus himalayensis',4,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4567,100,'Brown accentor','Prunella fulvescens',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4568,100,'Scarlet Rosefinch','Carpodacus erythrinus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4569,100,'Magpie','Pica pica',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4570,100,'Alpine chough','Pyrrhocorax graculus',4,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4571,100,'Brown accentor','Prunella fulvescens',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4572,100,'Saker falcon','Falco cherrug',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4573,100,'Black redstart','Phoenicurus ochrurus',1,'v',1,0,0,'male','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4574,100,'Northern Wheatear','Oenanthe oenanthe',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4575,100,'Lammergeier','Gypaetus barbatus',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4576,100,'Black redstart','Phoenicurus ochrurus',1,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4577,100,'Northern Wheatear','Oenanthe oenanthe',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4578,100,'Rock sparrow','Petronia petronia',2,'v',1,0,0,'nest in stone wall','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4579,100,'Crimson-winged finch','Rhodopechys sanguinea',3,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4580,100,'Mongolian finch','Bucanetes mongolicus',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4581,100,'Northern Wheatear','Oenanthe oenanthe',3,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4582,100,'House dove','Columba livia',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4583,100,'Common swift','Apus apus',8,'f',1,0,0,'nest on a rock','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4584,100,'Rock sparrow','Petronia petronia',2,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4585,100,'Citrine wagtail','Motacilla citreola',2,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4586,100,'Carrion crow','Corvus corone',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4587,100,'Hoopoe','Upupa crous',1,'v',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (11997,431,'Rock bunting','Emberiza cia',1,'a',0,1,0,'male, photo','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4589,101,'Corn bunting','Emberiza calandra',2,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4590,101,'Isabelline wheatear','Oenanthe isabellina',3,'v',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4591,101,'Horned lark','Eremophila alpestris',1,'f',1,0,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4592,101,'Rock sparrow','Petronia petronia',1,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4593,101,'Horned lark','Eremophila alpestris',6,'f',0,1,0,'','',NULL,NULL,NULL,NULL); INSERT INTO `survey_data` VALUES (4594,101,'Isabelline wheatear','Oenanthe isabellina',4,'v',0,1,0,'','',N