loarie

Rhinogobius nganfoensis
Rhinogobius vinhensis
Cryptocentroides argulus
Pseudogobius melanosticta
Hazeus diacanthus
Oxyurichthys zeta
Egglestonichthys ulbubunitj
Vieja bimaculata
Teleocichla preta
Percina apina

loarie

#inat not in iucn
Myotis phanluongi
Pipistrellus savii
Pipistrellus nanus
Pipistrellus rendalli
Pipistrellus capensis
Pipistrellus guineensis
Pipistrellus tenuipinnis
Pipistrellus brunneus
Pipistrellus zuluensis

loarie

<?xml version="1.0" encoding="utf-8" ?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Document id="root_doc">
<Schema name="C_s" id="C_s">
	<SimpleField name="featurecla" type="string"></SimpleField>
	<SimpleField name="min_zoom" type="float"></SimpleField>
	<SimpleField name="scalerank" type="int"></SimpleField>
</Schema>
<Folder><name>C_s</name>
  <Placemark>

loarie

<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns:atom="http://www.w3.org/2005/Atom" xmlns="http://www.opengis.net/kml/2.2">
  <Document>
    <Style id="place">
      <IconStyle>
        <Icon>
          <href>http://d3iih28jz42tpt.cloudfront.net/assets/mapMarkers/mm_32_GoldenRod-ba31260706e71ef223ae339349537ded.png</href>
        </Icon>
      </IconStyle>
      <LineStyle>

loarie

#Select leaves including frequncies
SELECT DISTINCT taxa.id, COUNT(o.id) AS frequency,
COUNT(CASE WHEN o.quality_grade = 'research' THEN o.id END) AS rg_count,
CONCAT(taxa.ancestry, '/', taxa.id) AS thread
FROM taxa INNER JOIN (
SELECT "observations".* FROM "observations"  WHERE (user_id=477)
) AS o ON o.taxon_id = taxa.id
WHERE taxa.id NOT IN(
  SELECT DISTINCT regexp_split_to_table(taxa.ancestry, '/')::int8 AS ancestor
  FROM taxa INNER JOIN (

loarie

[#<Observation id: 905334, observed_on: "2014-10-02", description: "[b][url=http://www.swiss-watches.me/ru/]топ часы бр...", latitude: nil, longitude: nil, map_scale: nil, timeframe: nil, species_guess: "топ часы бренда", user_id: 52929, taxon_id: nil, created_at: "2014-10-01 23:35:51", updated_at: "2014-10-01 23:35:51", place_guess: "Addison County, VT, US", id_please: true, observed_on_string: "180", iconic_taxon_id: nil, num_identification_agreements: 0, num_identification_disagreements: 0, time_observed_at: "2014-10-02 07:20:00", time_zone: "Novosibirsk", location_is_exact: false, delta: true, positional_accuracy: 57681, private_latitude: #<BigDecimal:ef714e0,'0.4402840042 11E2',27(27)>, private_longitude: #<BigDecimal:ef71418,'-0.7308979797 36E2',27(27)>, private_positional_accuracy: nil, geoprivacy: "private", geom: nil, quality_grade: "casual", user_agent: "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537...", positioning_method: "180", positioning_device: "", out_of_range: nil, license: "CC-BY-NC",