1 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: There are no distribution points displayed at this position

So I thought I would be clever and use Recorder to do a little house keeping. I had noticed some "out of county" records had crept into my data, and decided I would use Recorder to plot this points on it's internal map, which would then allow me to click on the dot, and trace the dodgy record.

I set up and XML report to exclude any records with grid references outside of my area, and included the necessary fields to "send to map".

Works beautifully, I can see all of my out of county records now. Except they supposedly aren't plotted. When I try and select them with the "find source data for observation" tool, I'm told

There are no distribution points displayed at this position

I also notice that it thinks all of the records are before the cut off point. So I guess Recorder isn't using the TOCC Key to get the data but is using some other means and the Report Wizard is doing something that my XML report is not - do I need to include something else in my XML report for this to work?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: There are no distribution points displayed at this position

I know the following works, but not sure if all the fields are actually required. You definitely need the TAXON_OCCURRENCE AS OCCURRENCE_KEY (the alias is required). I think the type of 'T' is also required.  The symbol cut off only works if all  three parts of the date are included.

Remember that even when it does work it is a  bit sensative. Zooming in and also increasing the symbol size a bit can make it easier to click on the centre of the dot.     



Select TDET.TAXON_OCCURRENCE_KEY AS OCCURRENCE_KEY, 'T' AS TYPE, TDET.TAXON_LIST_ITEM_KEY AS LIST_ITEM_KEY,S.SAMPLE_KEY AS SAMPLE_KEY,S.LAT AS LAT,S.LONG AS LONG ,S.SPATIAL_REF, ITN.ACTUAL_NAME, s.SPATIAL_REF_SYSTEM, s.vague_date_start, s.vague_date_end, s.vague_date_type
        from taxon_occurrence TOCC INNER JOIN Sample S on S.Sample_key = TOCC.Taxon_Occurrence_key INNER JOIN         taxon_determination TDET ON TDET.Taxon_occurrence_Key = TOCC.Taxon_occurrence_Key
AND TDET.Preferred = 1
INNER JOIN Index_taxon_name ITN on ITn.taxon_List_Item_Key = TDET.taxon_List_Item_key

Mike Weideli

MikeWeideli's Website

3 Reply by charliebarnes (edited by charliebarnes 08-08-2011 08:49:21)

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: There are no distribution points displayed at this position

Thanks Mike,

SELECT Taxon_Occurrence.Taxon_Occurrence_Key AS Occurrence_Key,
       'T' AS Type,
       S.Spatial_Ref,
       S.spatial_ref_system,
       S.lat,
       S.long

seems to work for me,

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: There are no distribution points displayed at this position

Thanks. I will update the documentation to eflect this as the minumum required info.

Mike Weideli

MikeWeideli's Website