Hi Mike,
This the result of Report Sy06:
Problem Table Records
Missing Spatial_ref_System Sample 4.00
More than 1 Preferred Taxon_Occurrence 22.00
No Accuracy Taxon_Occurrence 156.00
No Recorder Sample 11.00
No Recorder Survey_Event 26.00
Verified Indicator Wrong Biotope_Occurrence 72.00
Verified Indicator Wrong Taxon_Occurrence 40136.00
(Not sure what happened with all these not verified records as I checked several by running Sy07 and all have determination type correct)
This is the result of the LC_Special_SER_Issuse report:
Sample_Key Survey_EVent_Key
SR0004650000002W SR0004650000002S
SR0004650000003W SR0004650000003S
SR00046500000047 SR00046500000043
SR00046500000046 SR00046500000042
SR0004650000003K SR0004650000003G
SR00046500000039 SR00046500000035
SR0004650000002D SR00046500000029
SR0004650000001R SR0004650000001S
SR00046500000028 SR00046500000024
SR00046500000025 SR00046500000026
SR00046500000021 SR0004650000001X
SR0004650000001V SR0004650000001R
SR0004650000006A SR0004650000006B
SR0004650000006F SR0004650000006G
SR00046500000065 SR00046500000061
SR0004650000006V SR0004650000006W
SR00046500000079 SR00046500000075
SR0004650000007R SR0004650000007S
SR0004650000007L SR0004650000007M
SR0004650000000U SR0004650000000V
SR0004650000003C SR00046500000038
SR00046500000043 SR0004650000003Z
SR0004650000003Q SR0004650000003M
SR0004650000002I SR0004650000002J
SR0004650000002M SR0004650000002I
SR00046500000036 SR00046500000032
SR00046500000037 SR00046500000033
SR0004650000002X SR0004650000002Y
SR0004650000001T SR0004650000001P
SR0004650000001Z SR0004650000001V
SR00046500000027 SR00046500000023
SR00046500000029 SR0004650000002A
SR0004650000001W SR0004650000001S
SR00046500000049 SR00046500000045
SR00046500000056 SR00046500000052
SR0004650000005X SR0004650000005T
SR00046500000060 SR0004650000005W
SR0004650000007D SR0004650000007E
SR00046500000070 SR0004650000006W
SR0004650000007J SR0004650000007F
SR0004650000007Q SR0004650000007R
SR0004650000007N SR0004650000007J
SR0004650000007U SR0004650000007V
SR0004650000007H SR0004650000007D
SR0004650000007Z SR0004650000007V
SR00046500000081 SR0004650000007X
SR00046500000008 SR00046500000009
SR0004650000000O SR0004650000000P
SR0004650000000P SR0004650000000Q
SR0004650000002J SR0004650000002K
SR00046500000042 SR0004650000003Y
SR0004650000002Z SR0004650000002V
SR0004650000002S SR0004650000002T
SR0004650000002X SR0004650000002Y
SR0004650000003F SR0004650000003B
SR0004650000002Y SR0004650000002U
SR0004650000001S SR0004650000001O
SR0004650000001U SR0004650000001Q
SR0004650000002J SR0004650000002K
SR0004650000005V SR0004650000005R
SR0004650000006G SR0004650000006C
SR00046500000069 SR0004650000006A
SR0004650000006N SR0004650000006O
SR0004650000006P SR0004650000006L
SR0004650000006Y SR0004650000006Z
SR0004650000007G SR0004650000007H
SR0004650000007U SR0004650000007V
SR0004650000007P SR0004650000007L
SR0004650000007Q SR0004650000007R
SR0004650000007W SR0004650000007S
SR0004650000007Y SR0004650000007U
SR00046500000081 SR0004650000007X
SR00046500000005 SR00046500000006
SR0004650000000R SR0004650000000S
SR00046500000039 SR00046500000035
SR0004650000003Y SR0004650000003U
SR0004650000003U SR0004650000003Q
SR00046500000040 SR0004650000003W
SR00046500000049 SR00046500000045
SR0004650000003G SR0004650000003C
SR00046500000025 SR00046500000026
SR0004650000002I SR0004650000002J
SR00046500000062 SR00046500000063
SR00046500000064 SR00046500000060
SR0004650000005Q SR0004650000005M
SR00046500000063 SR0004650000005Z
SR0004650000006Z SR0004650000006V
SR00046500000077 SR00046500000073
SR0004650000005L SR0004650000005M
SR00046500000003 SR00046500000004
SR0004650000003B SR00046500000037
SR0004650000002R SR0004650000002N
SR0004650000003T SR0004650000003P
SR0004650000002H SR0004650000002D
SR00046500000033 SR0004650000002Z
SR0004650000002U SR0004650000002Q
SR0004650000001Q SR0004650000001R
SR0004650000001Y SR0004650000001U
SR0004650000004A SR00046500000046
SR0004650000005M SR0004650000005I
SR0004650000005O SR0004650000005K
SR0004650000006L SR0004650000006H
SR00046500000062 SR00046500000063
SR0004650000006D SR00046500000069
SR0004650000006K SR0004650000006L
SR00046500000067 SR00046500000063
SR00046500000075 SR00046500000071
SR0004650000007B SR0004650000007C
SR00046500000076 SR00046500000072
SR0004650000007M SR0004650000007I
SR0004650000007F SR0004650000007B
SR0004650000007X SR0004650000007T
SR00046500000007 SR00046500000008
SR0004650000000A SR0004650000000A
SR0004650000000T SR0004650000000U
SR0004650000002E SR0004650000002A
SR0004650000003X SR0004650000003T
SR0004650000003R SR0004650000003N
SR0004650000003Z SR0004650000003V
SR0004650000002L SR0004650000002H
SR0004650000003H SR0004650000003D
SR0004650000002B SR00046500000027
SR00046500000026 SR00046500000022
SR0004650000005K SR0004650000005L
SR0004650000000G SR0004650000000H
SR0004650000000A SR0004650000000A
SR0004650000000Y SR0004650000000Z
SR0004650000005R SR0004650000005N
SR00046500000061 SR00046500000062
SR0004650000006I SR0004650000006E
SR0004650000006E SR0004650000006A
SR00046500000078 SR00046500000074
SR0004650000007L SR0004650000007M
SR0004650000002F SR0004650000002B
SR0004650000002P SR0004650000002L
SR0004650000003S SR0004650000003O
SR00046500000045 SR00046500000041
SR00046500000041 SR0004650000003X
SR00046500000044 SR00046500000040
SR0004650000002K SR0004650000002G
SR00046500000034 SR00046500000030
SR00046500000030 SR0004650000002W
SR00046500000032 SR0004650000002Y
SR0004650000002A SR00046500000026
SR0004650000001X SR0004650000001T
SR0004650000005T SR0004650000005P
SR00046500000061 SR00046500000062
SR0004650000006H SR0004650000006D
SR0004650000006M SR0004650000006N
SR0004650000005L SR0004650000005M
SR0004650000006T SR0004650000006U
SR0004650000006V SR0004650000006W
SR0004650000006O SR0004650000006K
SR0004650000005P SR0004650000005L
SR00046500000071 SR00046500000072
SR0004650000005S SR0004650000005O
SR0004650000006X SR0004650000006T
SR0004650000007S SR0004650000007O
SR00046500000004 SR00046500000005
SR0004650000000A SR0004650000000A
SR0004650000002S SR0004650000002T
SR00046500000048 SR00046500000044
SR0004650000003N SR0004650000003J
SR0004650000003L SR0004650000003H
SR0004650000003M SR0004650000003I
SR0004650000002G SR0004650000002C
SR0004650000003I SR0004650000003E
SR0004650000002V SR0004650000002R
SR00046500000020 SR0004650000001W
SR00046500000023 SR0004650000001Z
SR00046500000022 SR0004650000001Y
SR00046500000049 SR00046500000045
SR0004650000005I SR0004650000005E
SR0004650000005W SR0004650000005S
SR0004650000006A SR0004650000006B
SR0004650000006C SR00046500000068
SR00046500000066 SR00046500000067
SR0004650000006K SR0004650000006L
SR0004650000006R SR0004650000006N
SR00046500000074 SR00046500000070
SR0004650000007K SR0004650000007G
SR0004650000007R SR0004650000007S
SR0004650000007O SR0004650000007K
SR0004650000007T SR0004650000007P
SR00046500000080 SR0004650000007W
SR00046500000006 SR00046500000007
SR0004650000000M SR0004650000000N
Not sure if it is useful, I am listing below the identifiers of the 8 events that historically we cannot delete:
10/08/1983 - SP301655:
The unique record identifier is SR00046500000028.
This Event was imported from database SR000465.
03/06/1988 - SP316614:
The unique record identifier is SR00046500000002.
This Event was imported from database SR000465.
29/09/1988 - SP308648:
The unique record identifier is SR0004650000000E.
This Event was imported from database SR000465.
02/07/1993 - SP3165:
The unique record identifier is SR00046500000049.
This Event was imported from database SR000465.
24/07/1993 - SP3265:
The unique record identifier is SR0004650000001M.
This Event was imported from database SR000465.
31/05/1994 - SP308651:
The unique record identifier is SR0004650000001F.
This Event was imported from database SR000465.
22/08/2002 - SP317635:
The unique record identifier is SR0004650000000O.
This Event was imported from database SR000465.
02/03/2004 - SP305601:
The unique record identifier is SR0004650000000G.
This Event was imported from database SR000465.
Many thanks,
Agni