SELECT analytical_stem.taxon_occurrence__pkey AS occurrence_id, analytical_stem."speciesBinomialWithMorphospecies" AS species, analytical_stem."decimalLatitude" AS latitude__deg, analytical_stem."decimalLongitude" AS longitude__deg, analytical_stem."coordinateUncertaintyInMeters" AS coords__uncertainty__m FROM analytical_stem WHERE ((((((NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false)) AND COALESCE((analytical_stem.geovalid_bien)::boolean, true)) AND (analytical_stem."speciesBinomialWithMorphospecies" IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL)) AND (analytical_stem."coordinateUncertaintyInMeters" <= _km_to_m((10)::double precision)));